How to prove a bank reconciliation is correct: a statement tie-out you can show your accountant
Getting transactions into QuickBooks or Xero is usually the easy part. The harder part, as bookkeepers often say, is showing that the reconciliation is actually right. A screen that says the difference is $0.00 tells you the ledger agrees with the numbers you typed in. It doesn't show anyone else that those numbers came from the statement, that no month was skipped, or that nothing was forced to balance.
The fix is a tie-out: a short record, per account and per statement-month, that anyone can check against the bank statement without opening your books. This guide lists the checks, then shows how to lay them out on one sheet. It works the same in QuickBooks, Xero or a spreadsheet, and it works when your bank only gives you PDF statements.
What "proved" means
For each statement-month, a reviewer should be able to confirm five things from paper alone: the opening balance is the prior month's closing balance, the month's money in and money out match the statement, the transactions run from opening to closing balance with no gaps, the ledger balance on the closing date matches the statement or is explained by a short list of uncleared items, and no adjustment was posted to make it fit. The checks below cover each one.
1. Opening balance matches the prior closing balance
- The statement's opening balance must equal the previous statement's closing balance, to the cent, and the period must start the day after the previous one ended.
- In QuickBooks Online, Intuit says to review the Last statement ending date, since your current statement should start the day after it, and to double check that the opening balance matches your statement (Intuit: reconcile an account in QuickBooks Online, updated Aug 5, 2026). If it doesn't, see beginning balance doesn't match the statement before you go further.
- In Xero's Reconcile period tab you enter the date range and the opening and closing balances from your bank statement. Xero recommends closing periods in chronological order, and when you close a period it fills in the start date and opening balance of the next one (Xero Central: reconcile and close a period).
2. Money in and money out match the statement totals
- Most statements print a summary: total deposits and credits, total withdrawals and debits, sometimes with item counts. Total the same two sides from your rows and compare. Matching totals on each side are stronger evidence than a matching closing balance, because a missing item and an extra one can cancel out.
- Then check the arithmetic: opening balance + deposits − withdrawals = closing balance. If that fails on the statement's own figures, a page is missing; see check a bank statement PDF is complete before you import it.
- Xero shows the same split: its Reconcile period screen totals Payments in Xero and Deposits in Xero for the period and works out a period balance from the opening statement balance (Xero Central). For credit card accounts Xero says to enter the balances as negative numbers with a minus sign.
3. Running balance, row by row
- Start from the opening balance and add each row in statement order. Where the statement prints a daily or running balance, your running figure should match it on each of those lines.
- The first row where they part is where the problem is: a missing row, a doubled row, a flipped sign or a misread digit. This finds the error in minutes instead of a search through the whole month.
- Our free tie-out checker does this in your browser for a CSV and shows the row where it stops balancing.
4. Ending balance per statement vs the ledger
- Write down the statement's closing balance and the ledger's balance for the account on the same date. Note both, not only the difference.
- In QuickBooks Online you enter the ending balance and ending date from the statement and match transactions until the Difference is $0.00 (Intuit). In Xero you can't close a period until the balances match and all transactions in it are reconciled (Xero Central).
- Don't force it. Intuit says you can finish with a difference, and QuickBooks then posts an adjusting entry for the amount, but advises talking to your accountant first and says it's usually best to resolve the difference (Intuit). A forced month isn't proved. If one is already in the books, record it on the sheet with the amount, and look for entries in a reconciliation discrepancies account in earlier months too.
5. List the uncleared items
- If the ledger and the statement differ on the closing date, the gap should be explained by items that are in the ledger but haven't reached the bank yet, such as a check not yet cashed or a deposit made on the last day.
- List each one: date, payee or description, amount and why it's open. Their total should equal the difference between the ledger balance and the statement balance.
- Check them next month. Each item should appear on the following statement. One that is still open after a couple of statements needs a decision, not another month on the list.
6. One tie-out sheet, month by month
Put the checks for one account on one sheet, one row per statement-month, oldest first. A layout that works:
| Column | What goes in it |
|---|---|
| Statement period | Start and end date as printed |
| Opening balance | From the statement; equals the row above's closing balance |
| Deposits, withdrawals | Statement totals, and your row totals beside them |
| Computed closing | Opening + deposits − withdrawals |
| Statement closing | As printed; difference to computed should be 0.00 |
| Running balance | Pass, or the first row that breaks |
| Ledger balance on closing date | From QuickBooks or Xero |
| Uncleared items | Total, with the list on a second tab |
| Adjustments | Any forced or plug entry, with amount; ideally none |
| Checked by, date | Who did the month and when |
Keep the sheet with the statement PDFs and the reconciliation reports. QuickBooks saves a report after each reconciliation, which you can find under History by account on the Reconcile page (Intuit). Your accountant can then pick any month, open the statement, and follow the row across without logging in to anything.
If your bank only gives you PDFs
- That's fine for the proof. The PDF statement is the bank's own record for the period, and checks 1, 2 and 4 use only the figures printed on it.
- Check 3 needs the rows in a form you can add up. If the bank won't give you a spreadsheet or a QBO file for older months, the rows have to come out of the PDF, by typing or by conversion, and then be tied out before they go into your books.
- Both QuickBooks Online and Xero now take some PDF statements directly. See import a PDF bank statement into QuickBooks Online and import bank statements into Xero from a PDF. Whichever route you use, tie out what was imported against the statement.
For a whole catch-up, the same routine is in how pros do catch-up, with a sample tie-out result.
Where LedgerReady fits
We do checks 1 to 3 for the statements you send. For each statement-month you get a QBO file, a Xero CSV, a plain CSV and a tie-out sheet. The sheet shows opening balance + every transaction = stated closing balance, to the cent, with any difference shown, the running balance checked line by line, and any lines we couldn't read. You can put the sheets side by side to check each closing balance against the next opening balance, and hand them to your accountant with the statements. See a sample tie-out sheet (synthetic data).
It costs $15 per digital statement-month, or $149 for a 12-month catch-up of one account, and we aim to deliver within 12 hours. Your first statement-month can be free. Full prices are on the pricing section. If the output doesn't reconcile to the statement's opening and closing balances and we can't fix it, you don't pay for that statement.
What we don't do
- We don't reconcile your QuickBooks or Xero file, compare it to the ledger, or build your uncleared items list. Checks 4 to 6 stay with you or your bookkeeper.
- We don't log in to your bank, QuickBooks or Xero. We work only from the statement PDFs you send.
- We are not accountants or CPAs. The tie-out sheet shows the file matches the statement. It is not an audit, review or attestation, and categories still need your review.
QuickBooks and Xero details are from the Intuit and Xero Central pages linked above, as read on 8 Nov 2026. Menus and wording change, so check their current help if something differs.
Skip the manual work
We turn statement PDFs into QBO, Xero and CSV files plus a tie-out sheet. $15 per statement-month, $149 for a 12-month catch-up. Prefer to check it yourself? Our tie-out checker runs in your browser. See how pros do catch-up.
Bank menus change; labels here were accurate to our knowledge in Oct 2026, so check your bank's help pages if something differs.