Deliver an automated bank reconciliation solution to streamline month end process
Prior to the Cashbook bank reconciliation software implementation, TGI Friday`s have the following challenges:
- All bank and credit card reconciliations were performed in Excel.
- No reporting facilities. They used filters and pivot tables in Excel.
- Operated 5- 6 Bank Accounts across 46 stores.
- Matching individual credit card payments with store/merchant IDs.
- The cost of outsourcing bank reconciliations for all stores.
TGI Friday UK Ltd. went live with Cashbook’s Bank Reconciliation Software Module in 2011, integrating their existing ERP (SAGE) with their bank. All 46 stores now deposit into the one TGI bank retail account. When the store makes a deposit in any of the bank’s branches, the branch and the store reference code is shown on the bank statement, along with date and amount. TGI’s POS system is downloaded daily into the SAGE system, where the store number is referenced on all daily sales. Both of these sets of data can be viewed within Cashbook’s Bank Reconciliation Software Module.
Full Bank & ERP Integration
Full integration regardless of bank
- Automatic integration with SAGE environment on SQL Server
- Ability to apply different matching rules to different bank.
More Advanced Intelligence
Powering an unprecedented level of automation; massively reducing staff time.
- Bank Statement uploads with auto-posting of transfers, sweeps and charges.
- Credit Card Statement upload with auto-posting of credit card charges.
- Automatic matching to GL of bank data containing a combination of bank branch and store reference data.
- Auto matching algorithms which are separately configurable for matching criteria.
- Auto matching algorithms allowing tolerance levels to be specified on amounts.
- Differences within tolerance levels to automatically create journals.
Greater Financial Control
A higher level of reporting and detail than ever before
- A full suite of reports is available to facilitate greater overall control: Reconciliation, Write off, Auto Matched, Carried Forward Reports, Un-Matched Reports, Control Reports, Comparison reports between Bank & GL balances.
RESULTS
Achieved >75% automation on match rates
Auto-matching of data between the ERP and bank.
>50% less workforce required
Workforce reduced from 2 full time to 1 part-time person.
>75% time saved in cash management
Automating the process generates huge efficiencies.
The Cashbook team worked with us in the deployment of their cash management software. We had some specific requirements which they analysed, developed and deployed. I would recommend them highly to companies looking to reconcile retail bank reconciliations.
Jason Smith, Financial Controller, TGI Friday’s