Reconciliation Discrepancies

How to identify a reconciliation discrepancy

Reconciliation discrepancies can be common when checking your Arbor Finance Online figures at month/year-end.

This article details common issues and diagnostics to help you find the source of the discrepancy. Some of the ways to identify if you have an issue of this type are: 

• There is a difference between the Financial Summary Carry Forward figure and the Bank Balance report.
• Transactions have been reconciled and the bank balance has been updated but the transactions are still showing on the reconciliation screen.
• There is a transaction missing from the reconciliation screen/transaction showing an incorrect amount on the reconciliation screen.
• Year-end/month-end is out by £XX.

In the reports > transactions > bank section, there is a reconciliation report which you can run to see items reconciled or non-reconciled.

Things to check

Considering some or all of the following might help you locate which transaction is causing the discrepancy:

• What is the value of the discrepancy and do you know what this relates to?
• What is the cheque number/voucher number/bank account?
• Have the transactions been posted correctly?
• When did things last balance correctly? 
• What should the value be?
• What is the bank balance as per the bank statements? Can you send the bank statements to us?
• How is the reconciliation screen grouped/sorted?
• Compare the bank statement with the reconciled transactions in Arbor Finance Online, running the Reconciliation Report by reconciled reference. Are all the transactions on the bank statement posted in Arbor Finance Online?
• Are all of the transactions that appear as reconciled in Arbor Finance Online on the bank statement?

Getting help from the Arbor Support team

If you're still unable to resolve the discrepancy, please contact the Finance Support team. 

To investigate the issue fully please provide as much information as you can. As a minimum, we will require all of the information you have already checked in the 'Things to check' section above along with the following:

• Where in Arbor Finance Online is the figure incorrect? i.e. which report/what screens are you comparing?
• Is the discrepancy on an external spreadsheet? Please send us the spreadsheet detailing where each figure in the spreadsheet can be found in Arbor Finance Online.

To send us any reports/screenshots/external spreadsheets your support representative can explain how to achieve this.

Note: Please ensure that you include your support call reference.

We'll confirm the receipt of your files and will then contact you further when we have completed investigations.