IP Library Granted Patent US 11,669,912
Granted Patent B1
US 11,669,912 · App. 16/928,460 · Granted Jun 6, 2023

Cash loss exception and reconciliation system and method

Inventors: Shellie Crandall (Jupiter, FL); Brian McCabe (Jupiter, FL)
Assignee: G4S Retail Solutions (USA) Inc.
G06Q40/12G06F3/0481
View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 11,669,912
App. No.
16/928,460
Granted
Jun 6, 2023
Kind
B1
Abstract

To maintain an updated and immutable record of reconciliation data provided to reconcile an exception relating to one or more cash-based transactions. Exceptions are automatically identified based at least in part on data received from one or more data sources, and corresponding exception case data objects are generated as immutable exception case data objects. Update data is provided for the immutable exception case data objects, causing updates to a corresponding graphical user interface while maintaining an immutable historical record of updates provided for the exception case data objects.

Claims (61)

1. An automated cash transaction reconciliation system for generating an immutable record of a transaction reconciliation, the system comprising:

one or more memory storage areas; and

one or more processors collectively configured to:

receive transaction data corresponding with a plurality of cash-based transactions, wherein the transaction data is generated via a cash handling device to reflect physical cash movement associated with the cash handling device;

generate and store, for one or more of the plurality of cash-based transactions, an exception case data object for storage as an immutable data object within the one or more memory storage areas;

automatically determine, for each exception case data object, a plurality of associated data sources based at least in part on metadata stored in association with each exception case data object;

receive update data for a corresponding exception case data object of the plurality of exception case data objects;

match a source of the update data with one of the plurality of associated data sources;

upon matching the source of the update data with the one of the plurality of associated data sources, immutably store the update data as an immutable update to the corresponding exception case data object together with a timestamp associated with the update data wherein the immutable update is stored within the one or more memory storage areas and associated with the exception case data object; and

generate a graphical user interface displaying data relating to the corresponding exception case data object, wherein the graphical user interface comprises a plurality of updatable fields each configured for display of data stored within the corresponding exception case data object having a most-recent timestamp;

upon immutably storing the update data, identify a portion of the update data associated with a first updateable field of the plurality of updateable fields, wherein the portion of the update data is identified as having the most-recent timestamp of immutably stored data within the exception case data object for display within the first updatable field;

automatically update data for display within the first updatable field based at least in part on timestamps of the immutably stored data to display at least a portion of the update data; and

upon receipt of user input provided via the graphical user interface, display a historical data record relating to the corresponding exception case data object, wherein the historical data record comprises historical data previously included within at least one of the plurality of updatable fields.

2. The automated cash transaction reconciliation system of claim 1 , wherein the one or more processors are further configured to:

identify received update data as reconciling the corresponding exception case data object;

transmit an approval request data object to at least one of the plurality of associated data sources; and

upon receipt of approval data in response to the approval request data object, close the corresponding exception case data object.

3. The automated cash transaction reconciliation system of claim 1 , wherein the one or more processors are further configured to automatically assign a user identifier to an exception case data object, wherein the assigned user identifier is identified as one of the plurality of associated data sources.

4. The automated cash transaction reconciliation system of claim 3 , wherein generating a graphical user interface comprises generating a graphical user interface accessible via a user computing entity associated with the assigned user identifier.

5. The automated cash transaction reconciliation system of claim 3 , wherein the one or more processors are further configured to generate a summary graphical user interface reflecting a plurality of exception case data objects associated with the user identifier.

6. The automated cash transaction reconciliation system of claim 1 , wherein each of the exception case data objects are configured for storing one or more data files in association with each of the exception case data objects.

7. The automated cash transaction reconciliation system of claim 1 , wherein the one or more processors are further configured to automatically identify a link between at least two of the plurality of exception case data objects to at least partially reconcile the at least two of the plurality of exception case data objects, and wherein data indicative of the link is stored within each of the at least two of the plurality of exception case data objects.

8. A computer-implemented method for automated cash transaction reconciliation for generating an immutable record of a transaction reconciliation, the method comprising:

receiving, via one or more processors, transaction data corresponding with a plurality of cash-based transactions, wherein the transaction data is generated via a cash handling device to reflect physical cash movement associated with the cash handling device;

generating and storing, via the one or more processors and for one or more of the plurality of cash-based transactions, an exception case data object for storage as an immutable data object within the one or more memory storage areas;

automatically determining, via the one or more processors and for each exception case data object, a plurality of associated data sources based at least in part on metadata stored in association with each exception case data object;

receiving, via the one or more processors, update data for a corresponding exception case data object of the plurality of exception case data objects;

matching, via the one or more processors, a source of the update data with one of the plurality of associated data sources;

upon matching the source of the update data with the one of the plurality of associated data sources, immutably storing, within one or more memory storage areas, the update data as an immutable update to the corresponding exception case data object together with a timestamp associated with the update data wherein the immutable update is stored within the one or more memory storage areas and associated with the exception case data object; and

generating, via the one or more processors, a graphical user interface displaying data relating to the corresponding exception case data object, wherein the graphical user interface comprises a plurality of updatable fields each configured for display of data stored within the corresponding exception case data object having a most-recent timestamp;

upon immutably storing the update data, identifying, via the one or more processors, a portion of the update data associated with a first updateable field of the plurality of updateable fields, wherein the portion of the update data is identified as having the most-recent timestamp of immutably stored data within the exception case data object for display within the first updatable field;

automatically updating, via the one or more processors, data for display within the first updatable field based at least in part on timestamps of the immutably stored data to display at least a portion of the update data; and

upon receipt of user input provided via the graphical user interface, displaying, via the one or more processors, a historical data record relating to the corresponding exception case data object, wherein the historical data record comprises historical data previously included within at least one of the plurality of updatable fields.

9. The computer-implemented method for automated cash transaction reconciliation of claim 8 , further comprising:

identifying received update data as reconciling the corresponding exception case data object;

transmitting an approval request data object to at least one of the plurality of associated data sources; and

upon receipt of approval data in response to the approval request data object, closing the corresponding exception case data object.

10. The computer-implemented method for automated cash transaction reconciliation of claim 8 , further comprising automatically assigning a user identifier to an exception case data object, wherein the assigned user identifier is identified as one of the plurality of associated data sources.

11. The computer-implemented method for automated cash transaction reconciliation of claim 10 , wherein generating a graphical user interface comprises generating a graphical user interface accessible via a user computing entity associated with the assigned user identifier.

12. The computer-implemented method for automated cash transaction reconciliation of claim 10 , further comprising generating a summary graphical user interface reflecting a plurality of exception case data objects associated with the user identifier.

13. The computer-implemented method for automated cash transaction reconciliation of claim 8 , wherein each of the exception case data objects are configured for storing one or more data files in association with each of the exception case data objects.

14. The computer-implemented method for automated cash transaction reconciliation of claim 8 , further comprising automatically identifying a link between at least two of the plurality of exception case data objects to at least partially reconcile the at least two of the plurality of exception case data objects, and wherein data indicative of the link is stored within each of the at least two of the plurality of exception case data objects.

15. A computer program product comprising a non-transitory computer readable medium having computer program instructions stored therein, the computer program instructions when executed by a processor, cause the processor to:

receive transaction data corresponding with a plurality of cash-based transactions, wherein the transaction data is generated via a cash handling device to reflect physical cash movement associated with the cash handling device;

generate and store, for one or more of the plurality of cash-based transactions, an exception case data object for storage as an immutable data object within the one or more memory storage areas;

automatically determine, for each exception case data object, a plurality of associated data sources based at least in part on metadata stored in association with each exception case data object;

receive update data for a corresponding exception case data object of the plurality of exception case data objects;

match a source of the update data with one of the plurality of associated data sources;

upon matching the source of the update data with the one of the plurality of associated data sources, immutably store, within one or more memory storage areas, the update data as an immutable update to the corresponding exception case data object together with a timestamp associated with the update data wherein the immutable update is stored within the one or more memory storage areas and associated with the exception case data object; and

generate a graphical user interface displaying data relating to the corresponding exception case data object, wherein the graphical user interface comprises a plurality of updatable fields each configured for display of data stored within the corresponding exception case data object having a most-recent timestamp;

upon immutably storing the update data, identify a portion of the update data associated with a first updateable field of the plurality of updateable fields, wherein the portion of the update data is identified as having the most-recent timestamp of immutably stored data within the exception case data object for display within the first updatable field;

automatically update data for display within the first updatable field based at least in part on timestamps of the immutably stored data to display at least a portion of the update data; and

upon receipt of user input provided via the graphical user interface, display a historical data record relating to the corresponding exception case data object, wherein the historical data record comprises historical data previously included within at least one of the plurality of updatable fields.

16. The computer program product of claim 15 , wherein the computer program instructions are further configured to, when executed by a processor, cause the processor to:

identify received update data as reconciling the corresponding exception case data object;

transmit an approval request data object to at least one of the plurality of associated data sources; and

upon receipt of approval data in response to the approval request data object, close the corresponding exception case data object.

17. The computer program product of claim 15 , wherein the assigned user identifier is identified as one of the plurality of associated data sources.

18. The computer program product of claim 17 , wherein generating a graphical user interface comprises generating a graphical user interface accessible via a user computing entity associated with the assigned user identifier.

19. The computer program product of claim 15 , wherein the computer program instructions are further configured to, when executed by a processor, cause the processor to generate a summary graphical user interface reflecting a plurality of exception case data objects associated with the user identifier.

20. The computer program product of claim 15 , wherein the computer program instructions are further configured to, when executed by a processor, cause the processor to automatically identify a link between at least two of the plurality of exception case data objects to at least partially reconcile the at least two of the plurality of exception case data objects, and wherein data indicative of the link is stored within each of the at least two of the plurality of exception case data objects.

Assignments (9)
NOTES PATENT SECURITY AGREEMENT Recorded Jul 11, 2025
From: G4S RETAIL SOLUTIONS (USA) INC.
To: WILMINGTON TRUST, NATIONAL ASSOCIATION, AS NOTES COLLATERAL AGENT
Reel/Frame 071888/0745 →
RELEASE OF SECURITY INTEREST Recorded Aug 9, 2024
From: WILMINGTON TRUST, NATIONAL ASSOCIATION, AS NOTES COLLATERAL AGENT
To: G4S RETAIL SOLUTIONS (USA) INC.
Reel/Frame 068242/0972 →
SUPPLEMENTAL ABL PATENT SECURITY AGREEMENT (2019) Recorded Feb 21, 2024
From: G4S RETAIL SOLUTIONS (USA) INC.
To: CITIBANK, N.A., AS COLLATERAL AGENT
Reel/Frame 066641/0639 →
SUPPLEMENTAL PATENT SECURITY AGREEMENT (2019) Recorded Feb 21, 2024
From: G4S RETAIL SOLUTIONS (USA) INC.
To: CREDIT SUISSE AG, CAYMAN ISLANDS BRANCH, AS COLLATERAL AGENT
Reel/Frame 066641/0646 →
SUPPLEMENTAL PATENT SECURITY AGREEMENT (2021) Recorded Feb 21, 2024
From: G4S RETAIL SOLUTIONS (USA) INC.
To: CREDIT SUISSE AG, CAYMAN ISLANDS BRANCH, AS COLLATERAL AGENT
Reel/Frame 066641/0660 →
SUPPLEMENTAL NOTES PATENT SECURITY AGREEMENT (2021) Recorded Feb 21, 2024
From: G4S RETAIL SOLUTIONS (USA) INC.
To: WILMINGTON TRUST, NATIONAL ASSOCIATION
Reel/Frame 066641/0667 →
SUPPLEMENTAL NOTES PATENT SECURITY AGREEMENT (2019) Recorded Feb 21, 2024
From: G4S RETAIL SOLUTIONS (USA) INC.
To: WILMINGTON TRUST, NATIONAL ASSOCIATION
Reel/Frame 066641/0653 →
NOTES PATENT SECURITY AGREEMENT Recorded Feb 21, 2024
From: G4S RETAIL SOLUTIONS (USA) INC.; U. S. SECURITY ASSOCIATES HOLDING CORP.
To: WILMINGTON TRUST, NATIONAL ASSOCIATION, AS COLLATERAL AGENT
Reel/Frame 066641/0632 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Jul 14, 2020
From: CRANDALL, SHELLIE; MCCABE, BRIAN
To: G4S RETAIL SOLUTIONS (USA) INC.
Reel/Frame 053203/0934 →
Continuity (1)
Provisional Application 62874215 · Jul 15, 2019