The short answer: a bank reconciliation proves that the ledger agrees with the bank statement. A dedicated AI can do the slow part, which is checking every statement line against the ledger and listing what is missing, doubled up or miscoded. Your team then makes the corrections and clicks reconcile.
What a bank reconciliation is
A bank reconciliation compares two records of the same account for the same period: the bank’s statement and your ledger. Every difference is found and explained. Differences usually come from one of four causes:
- A transaction is on the statement but was never entered in the ledger.
- A transaction was entered twice.
- A transaction was entered with the wrong amount, date or account.
- A payment or deposit is in the ledger but has not cleared the bank yet.
When the adjusted closing balances agree, the account is reconciled.
How to do a bank reconciliation, step by step
- Confirm the statement’s opening balance matches the ledger’s closing balance from the last period.
- Tick each line on the statement against the matching ledger entry.
- List the statement lines with no ledger entry, and record them.
- List the ledger entries with no statement line, and decide whether each is a timing difference or an error.
- Correct anything entered twice or with the wrong amount.
- Check that the adjusted balances agree, and keep the working paper.
What your dedicated AI checks
Your dedicated AI does steps 1 to 4 for you and prepares step 5 for approval:
- Reads the bank or card statement export for the period.
- Matches every line against the ledger in Xero, MYOB, QuickBooks or Reckon.
- Lists what is missing, doubled up or miscoded, with the reason.
- Suggests the account and tax code for each unmatched line, from how that client has been coded before.
- Produces an Excel working paper with matched lines, exceptions and the opening and closing totals.
On real client books it found 5 missing transactions in 1,000, in seconds.
Bank reconciliation in Xero and MYOB
Xero and MYOB keep the final match inside their own bank reconciliation screens, and neither gives an outside app access to bank feed lines. That applies to every third-party tool, not only Agentive. So the work splits in two: your dedicated AI prepares the list of exactly what to match and what to fix, and a person in your practice does the reconcile in Xero or MYOB.
Where a client’s account has no bank feed, transactions can come into Xero through Basiq open banking, already coded.
Who it is for
- Bookkeepers keeping many client files current. See AI bookkeeping.
- BAS agents who need the accounts right before the quarter is reviewed. See AI for BAS agents.
- Accounting practices preparing year-end workpapers. See AI for accountants.
For the full product page, see bank statement checks.