The Reconciliation page should reflect the bank's closing balance for any given date. If the bank balance differs from the total reconciliation balance (displayed on Financials > Reconciliation), the following steps should be taken to rectify this.
The Finance Support team can assist users in identifying and resolving any balance discrepancies but will require the following information from users to do so:
1. When the balance last matched
Go to Financials > Reconciliation
Click Set end date on the left and set the date to the previous working day.
Compare this to the bank balance for the equivalent date.
Repeat this, going back one day at a time until the two balances match. Make a note of the date that the balances last matched.
2. What the difference is
Set end date to the date that the balances first did not match. This should be the day after they last matched. This will be the source of the discrepancy.
Make a note of the difference and the date this first occurred on
Make a note of whether this is higher or lower than the value shown in the system
3. The cause of the discrepancy
Go to Bank > View bank lines
Select the Filter by dropdown on the top left and choose the Client account (or the name of your bank account on the system)
Select Change date range and adjust the date to the day the discrepancy first occur
Compare the bank lines displayed to those in the bank statement for the same day and make note of any differences
Note: Bank lines that have been split will show as two separate lines in the system but one bulk line on the bank statement.
For assistance in investigating and resolving balance differences, please contact our Finance Support team ([email protected]) and provide the information outlined in the steps above.