I’m an Ocado customer but I can’t see any slots available to book

Reconciliation Summary

Overview

• Run the Bank Reconciliation Summary to check if your actual bank balance and the balance of the bank account in match.
• If your balances don't match, run this report to check for missing, deleted or duplicated transactions.

Run the Bank Reconciliation Summary

1. In the Accounting menu, select Reports.
2. Under Accounting, click More reports to expand the section if the report is hidden.
3. Click Bank Reconciliation Summary.
4. Choose a Bank Account and select a Date, then click Update to view your report.

You can also access the report from the Manage Account menu within a bank account or by clicking the Reconciliation report link next to the Manage Account button in the bank reconciliation screens. If you view this report directly from the bank account, the account name is already selected.

Report tabs: Bank Reconciliation Summary, Bank Statement, and Statement Exceptions

The report has three tabs, the Bank Reconciliation Summary, Bank Statement and Statement Exceptions. From the Bank Reconciliation Summary tab, you can switch to the Bank Statement or Statement Exceptions tabs to compare the unreconciled items on your Bank Reconciliation Report with any outstanding, imported statement lines.

Bank Reconciliation Summary tab

The report breaks up into sections to show what your actual bank balance is, based on the data you entered into  on any given date. This figure is not taken from your online bank balance, it's calculated using the data in Xero.

If your transactions and reconciliation are up to date on the report date, your balance in  and your statement balance for that day should be the same.

A reconciled bank statement line or account transaction matched to a future dated item will appear in the report as unreconciled. The report won't recognise a match if the bank statement line or account transaction is dated after the date of the report.

From the Bank Reconciliation Summary tab, you can click on any individual transaction in the lists of transactions already in Xero to view the original transaction.

If you are using multicurrency, the report footnotes show the conversion rates for the figures converted into your base currency. They also show if the exchange rate was the official XE rate of the day, or if a user in your organisation entered it. 

Totals explained

Total	Description
Balance	The sum of all bank account transactions entered in a bank account dated today or in the past.
Total Outstanding Payments/Receipts	Transactions that were entered , but not yet reconciled.
Total Unreconciled Statement Lines	Transactions imported from your online bank account (at the report date) that are not yet reconciled (or possibly not yet entered).
Total Outstanding Payments/Receipts	Transactions that were entered , but not yet reconciled.
Statement Balance	The sum of all imported bank statements for a bank account . A difference displays if you run the report for the day the statement was imported, and the Statement balance and Balance  are different.
Imported Statement Balance	Displays if an end balance has been imported for the date that the report has been run for.

Tip

An Imported Statement Balance and Balance out by error message will show, if an end balance has been imported for the date that the report has been run for and if there is a discrepancy between this end balance and the  Statement Balance.

If your accounts are fully reconciled, but your balances don't match

• Cross-check your bank account transactions and imported statement lines to make sure nothing is missed or doubled.
• Check your conversion balance to make sure that the balances that you loaded when you started using  were the exact balance of your bank account and accounts from your previous accounting system.
• Use the Bank Statement and Statement Exceptions tabs on this report.

Bank Statement tab

The Bank Statement tab shows you:

• A list of all statement lines downloaded for the current month by default
• The date the item was imported from the statement into 
• Whether the item was reconciled
• Where each statement line came from (auto bank feed or manual file import from online banking)

It also shows you all imported statement lines for the date range you chose. Click the date link to view that bank statement that was imported.

If you only want to see reconciled bank statements lines select the Reconciled Only checkbox.

Statement Exceptions tab

The Statement Exceptions tab shows you any items that do not match the normal import statement to reconcile to item in process. It shows things like:

• Items that are in  and are manually reconciled
• Imported statement items that are deleted in 
• Duplicates

If you're having trouble getting your online bank account balance to match the balance showing in Xero, this is a useful place to check for any anomalies.