Updated: 12 June 2024
The Bank Reconciliation alerts show the reconciliation status for the transactions from the period you selected. They are the first step to ensuring the data for a period is complete.
When working on a period close, get these alerts to green before working on the rest of the Period Close checklist. This ensures that the rest of the checklist takes all transactions from the period into account.
How to cross-check Aider against the data in Xero
Unreconciled Transactions alert
Aider's data comes from the Cash Validation Customer Report with transactions date range restricted to only the period you selected. This date range filter is not available in the standard Xero Cash Validation Customer Report. So, to check that the Aider data is correct:
 |
Click on the image to see a bigger version.
- Use the "Quick Resync" button to ensure you're looking at the latest data.
- For oldest unreconciled item date and total number of transactions for the selected period:
Go to Accounting > Bank accounts > a bank account > Reconcile tab.
Select “Filter", set the start and end dates to match the selected period, click "Apply".
Oldest unreconciled item = date of the first unreconciled item in the filtered list.
Unreconciled items = total number of items at the bottom of the screen. - For the unreconciled income and expense subtotals for transactions in the selected period:
Go to Accounting > Reports > Reconciliations > Cash Validation Customer Report.
Select a bank account in Accounts, and the last day of the selected period as the Date.
Click "Update".
Income subtotal = "Unreconciled Amount (Pos)" in "Bank Statement Transactions".
Expenses subtotal = "Unreconciled Amount (Neg)" in "Bank Statement Transactions".
Balance Difference alert
Aider's data comes from the Bank Summary Report, plus the Cash Validation Customer Report with transactions date range restricted to only the period you selected. This date range filter is not available in the standard Xero Cash Validation Customer Report. So, to check that the Aider data is correct:
 |
Click on the image to see a bigger version.
- Use the "Quick Resync" button to ensure you're looking at the latest data.
- For reconciled up to date for the transactions in the selected period:
Go to Accounting > Bank accounts > a bank account > Reconcile tab.
Select “Filter", set the start and end dates to match the selected period, click "Apply".
Reconciled up to = the day before the date of the first unreconciled item in the filtered list. - For the Xero Balance at the end of the selected period:
Go to Accounting > Reports > Reconciliations > Bank Summary
Select the first and last days of the selected period as the Date range.
Click "Update".
Xero Balance = "Closing Balance". - For the Bank Statement Balance at the end of the selected period:
Go to Accounting > Reports > Reconciliations > Cash Validation Customer Report.
Select a bank account in Accounts, and the last day of the selected period as the Date.
Click "Update".
Bank Statement Balance = "Value" in "Bank Statement Balance".
FAQ’s:
Q: Why do the numbers and date not match the Reconciliation screens in Xero?
A: Here are some common reasons why the Bank Reconciliation alerts in Aider may not match what you see in Xero:
- Data not up to date: Have there been additional activities in Xero recently? You can check when the data in Aider was updated by the date and time shown under the "Bank Reconciliation" heading. Use the "Quick Resync" link to update the "Bank Reconciliation" data.
- Not comparing data from the same date range: Aider's period checklists focus on transactions within the selected period. Xero by default shows ALL transactions irrespective of period. When comparing Aider numbers with Xero, make sure you have filtered the Xero data by the start and end dates of the selected period.
Check whether there are unreconciled items from previous periods and get those reconciled to avoid old unreconciled transactions affecting the data accuracy.
If you still find the data are not matching, please report the problem to our friendly Customer Success Team.