The quickbooks reconciliation report is the one page that proves a month is closed. Every reconciliation in QuickBooks Online ends with two things: a difference of zero and a report that shows how you got there. The report lists the beginning balance, every transaction that was cleared, the ending balance, and the difference — and when the difference is zero, the report is the evidence that the books and the bank agree. This guide explains what each section means, how accountants read the report at month-end, and what a clean report looks like, so the next time you finish a reconciliation you know exactly what you are looking at.
Be clear about what our tools do before you start. Our reconciliation tools are file-based converters and checkers, not a live connection to QuickBooks: you export your statement or register to a QBO or CSV file, check it against the statement, and import the corrected file yourself, reviewing every row before it posts. Nothing connects to your QuickBooks account, and nothing posts without your review. To check a file for the duplicate transactions that cause most reconciliation problems, use our quickbooks reconciliation report file route — the steps below show how the report itself fits with the built-in reconciliation. For the wider picture, see our QuickBooks hub.
What the QuickBooks Reconciliation Report Shows
The report comes in two parts: a summary and a detail. The summary is the short version. It shows the beginning balance — the ending balance of the last successful reconciliation — then the cleared deposits and credits, the cleared checks and payments, and the ending balance, which should match the bank statement's ending balance for the same period. The last line is the difference, and a clean reconciliation shows $0.00 there. If the difference is anything else, the reconciliation is not finished, no matter how good the rest looks.
The detail is the long version: every transaction that was cleared in this reconciliation, one row each, with the date, the transaction type, the payee or description, and the amount. Uncleared transactions do not appear in the detail at all — the report only covers what was marked cleared — which is why the detail is the right place to look when a number feels wrong. You can generate the report from the Reconcile screen's history for the account, or from the Reports section by searching for the reconciliation report. Keep a copy of each month's report with the bank statement for that month, filed by tax year, because the report and the statement together are the audit trail.
Reading a QuickBooks Reconciliation Report Section by Section
Start at the top. The beginning balance should equal the ending balance of the previous month's report — that chain is what makes the books trustworthy, because each month builds on the last. If the beginning balance is wrong, the problem is not in this month at all: something changed in a month you already closed, and the report for that month will show where. Our guide to the wrong beginning balance walks through that exact diagnosis.
Next, the cleared deposits and credits: every deposit, customer payment, and credit that was marked cleared in this period, totaled. Compare that total with the deposits on the bank statement for the same period — they should match, and if they do not, a deposit is missing, duplicated, or dated in the wrong month. Then the cleared checks and payments: every check, bill payment, and expense that was marked cleared, totaled the same way. A mismatch here usually means a check recorded for the wrong amount or posted to the wrong account. Finally, the ending balance and the difference. The ending balance should match the statement's ending balance to the cent, and the difference should be $0.00. When both are true, the month is closed, and the report is the proof.
What a Clean Report Looks Like at Month-End
A clean report is boring, and boring is the goal. The beginning balance ties to last month. Every deposit on the statement appears in the cleared deposits, every check on the statement appears in the cleared payments, and nothing else does. The uncleared list — the transactions still waiting — is short and explainable: a check written but not yet cashed, a deposit in transit at month-end, a transfer that will clear next week. Accountants read the uncleared list first, because it is where the next month's problems hide: an uncleared item from three months ago is not a timing difference, it is a stale transaction that needs a decision.
At month-end, the routine is the same every month: finish the reconciliation, print or save the report, and file it with the statement. Then look at the uncleared items and ask about each one — is it really outstanding, or did it clear and nobody marked it? A monthly habit of ten minutes keeps the uncleared list honest, and an honest uncleared list is what makes the next reconciliation take twenty minutes instead of two hours. If the books have a deeper problem, work through the reconciliation checklist before touching any transaction, and if you need to reopen a period, our guide on how to undo a reconciliation explains the two routes and when each one is safe.
When the Report Does Not Balance
A difference that is not zero has a short list of usual causes, and the report itself helps you narrow it down. First, check the beginning balance: if it does not match last month's ending balance, a transaction in a closed month was changed, and the change report will name it. Second, search the detail for the difference amount: a $250 difference often points at a $250 transaction that was entered twice or with the wrong amount. Third, check the dates: a transaction dated in the wrong month clears in the wrong reconciliation and throws both months off by the same amount. Fourth, check for a transposed number — $1,245 entered as $1,254 — which leaves a difference divisible by nine, a classic tell.
Fix one thing at a time, and re-run the report after each fix. Never force the difference to zero with a plug or an adjusting entry you cannot explain — a forced zero hides the error and guarantees it reappears next month, larger and harder to find. If the difference is small and the cause is genuinely a bank fee or interest the statement shows and the books do not, record that fee properly and re-run. The report is a diagnostic tool, not a formality: a difference of $0.00 that you understand is worth more than a difference of $0.00 that you forced.