Bank Rec in QuickBooks Online: How to Do It Step by Step
July 2026 · Reconciler
Try it while you read
This is the tie-out board Reconciler gives you: both sides side by side, matches explained in plain English, exceptions flagged. Read-only, and it never moves money.
Read-only · Never moves money
To do a bank rec in QuickBooks Online, open Settings, choose Reconcile, select the bank account, and enter the ending balance and ending date from your bank statement. QuickBooks then lists every transaction in that account, and you tick off each one that appears on the statement. As you tick, the "difference" figure at the top moves toward zero. When the difference reads 0.00, the account is reconciled and you click Finish now. The whole job is the ticking, and everything that goes wrong is a reason the difference will not reach zero.
Last updated July 2026.
A bank reconciliation in QuickBooks Online proves that the cash QuickBooks thinks you have matches the cash your bank says you have, for one statement period. The bank feed makes it feel automatic, but a fed transaction is not a reconciled one. Reconciliation is the separate step that confirms both records tell the same story.
How do I do a bank rec in QuickBooks Online?
Do a bank rec in QuickBooks Online by opening the Reconcile screen, entering the statement's ending balance and date, matching each QuickBooks transaction to the statement, and confirming the difference is 0.00 before you finish. Here are the steps with the detail that trips people up.
- Post everything first. Before you start, make sure every transaction for the period is in QuickBooks and categorized. Go to the Banking screen and clear the "For review" tab so there is nothing waiting to be added. Reconciling around unposted transactions is the fastest way to a difference you cannot explain.
- Open Reconcile. Go to Settings (the gear icon), then Reconcile under Tools. Pick the account you are reconciling from the dropdown.
- Enter the statement figures. Type the ending balance and the ending date exactly as they appear on your bank or credit card statement. The beginning balance should already match last period's ending balance. If it does not, stop and read the section on beginning-balance problems below.
- Match line by line. QuickBooks shows every uncleared transaction. Tick each one that appears on the statement. Work by amount first, then date. Use the Payments and Deposits columns to keep the two sides straight, and filter by date to shrink the list.
- Watch the difference. The number in the top right is statement ending balance minus what you have cleared. It has to reach 0.00. If it does, click Finish now. If it does not, do not force it, and do not tick things that are not really there.
One prep note for anyone who imports history by hand. If your bank only gives you a PDF and the transactions are not in the feed, convert the statement into a QuickBooks-ready file before you import, rather than retyping lines. Manual entry introduces the exact transposition errors reconciliation exists to catch.
What is the difference between reconcile and match in QuickBooks?
Matching in QuickBooks Online happens on the Banking screen, where QuickBooks suggests which existing transaction a downloaded bank-feed line belongs to and you accept it. Reconciling happens on the Reconcile screen, where you confirm that the full set of cleared transactions agrees with the bank statement balance for the period. Matching records a single transaction correctly; reconciling proves the whole account is right.
This is why a bank feed that is fully "matched" is not automatically reconciled. Matching can accept a duplicate, miss a bank fee that never came through the feed, or attach a payment to the wrong invoice. Reconciliation is the control that catches those, because it forces the cleared total to equal an independent number, the statement balance, that QuickBooks did not generate.
Why is my QuickBooks reconciliation off by a small amount?
A QuickBooks reconciliation is usually off by a small amount because of one of a handful of specific causes: a bank fee or interest posted on the statement but not in QuickBooks, a duplicate transaction, a transaction dated outside the statement period, a manually edited or deleted transaction that was already reconciled, or a payment recorded net of a processing fee. Each one has a standard fix.
| Cause | What it looks like | How to fix it in QuickBooks Online |
|---|---|---|
| Unrecorded bank fee or interest | A service charge or interest credit on the statement with no QuickBooks entry. | Add it during reconciliation, or post it as an expense or deposit, then re-tick. |
| Duplicate transaction | The same amount and payee appear twice, often after a re-imported feed. | Exclude or delete the duplicate from the Banking screen before reconciling. |
| Wrong statement dates | A transaction dated after the ending date shows up in the list. | Confirm the ending date matches the statement. Leave later-dated items uncleared. |
| Edited a reconciled transaction | An amount changed on a transaction that was already reconciled in a prior period. | Run the Reconciliation Discrepancy report and restore the original amount. |
| Processor payout booked net | Stripe deposits $4,712.18, your invoice says $4,850.00; the $137.82 is fees. | Split the deposit into gross sales and the processing fee expense. |
| Transposed digits | $1,520.00 keyed for $1,250.00. The difference divides evenly by 9. | Correct the entry. A difference divisible by 9 almost always means swapped digits. |
The fastest way to find a small difference is to search for its exact amount on both sides. If the difference equals a single transaction, something was recorded once too often or once too few. If it is exactly twice a transaction, a debit was booked as a credit or the reverse.
How do I fix a reconciliation discrepancy in QuickBooks Online?
Fix a reconciliation discrepancy in QuickBooks Online by running the Reconciliation Discrepancy report, which lists any reconciled transaction that was later changed or deleted, along with who changed it and when. Open each flagged transaction, compare it to the statement, and restore the original amount or re-enter what was removed. Then reopen Reconcile and the beginning balance should line up again.
Find the report under Reports, then search "Reconciliation Discrepancy." The most common trigger is someone editing an already-reconciled transaction, which silently changes a prior period's cleared total and throws off the beginning balance of the next one. That is why a wrong beginning balance is always a signal to look backward, not forward: the error lives in a period you already closed.
Can you undo a reconciliation in QuickBooks Online?
In QuickBooks Online, an accountant user can undo an entire reconciliation from the reconciliation history, and any user can unreconcile a single transaction by opening it, clicking the checkmark in the top corner of the transaction until it clears to blank, and saving. Undo the whole thing only when the beginning balance is wrong and you cannot trace the cause any other way, because it removes the reconciled status from every transaction in that period.
Repeated unreconciling is a symptom, not a fix. If you find yourself undoing reconciliations often, the underlying problem is usually transactions being matched or accepted too quickly on the Banking screen, or edits being made to closed periods. Tightening those two habits removes most of the reason to unreconcile at all.
How often should I reconcile in QuickBooks Online?
Reconcile every bank and credit card account in QuickBooks Online at least once a month, as soon as each statement closes, because your financial statements and tax filings are built on reconciled balances. High-volume businesses, especially those taking card payments, benefit from reconciling weekly, since a duplicate charge or a missing payout is far easier to trace across seven days than across thirty.
The payoff of reconciling on time is a quiet month end close. If cash is already tied out when the period ends, closing the books is a formality. If it is not, closing turns into a scramble to explain a difference under deadline, which is exactly when mistakes get plugged to a suspense account and forgotten.
Automating the QuickBooks bank rec without giving up control
Manual reconciliation in QuickBooks Online works fine for one checking account with a clean feed. It stops scaling the moment a Stripe or PayPal deposit bundles thirty sales into one line, a corporate card statement arrives with a hundred charges, or you keep the books for several entities. That is the case automated QuickBooks reconciliation is built for. Reconciler connects to QuickBooks Online read-only, pulls in your bank feed and payment processors, and scores every candidate pair on amount, date, memo, and reference, so a $3,200.00 deposit ties to invoice 1043 and a payout is opened up to tie each sale, refund, and fee inside it.
The design is deliberately conservative. It never moves money and never auto-posts, and a person reviews every exception before anything is marked reconciled. Corporate cards reconcile on the same pass, so credit card reconciliation is not a separate evening of work, and discrepancy detection surfaces the duplicates, missing entries, and unbooked fees that would otherwise eat your afternoon. It sits on top of the ledger you already run, so there is nothing to migrate and nothing to rip out. Plans start at $49/mo, listed on the pricing page.
Software or the Reconcile screen, the logic is the same: tick what matches, explain what does not, fix the right side, and prove the difference is 0.00. Do that every month and the bank rec in QuickBooks stops being the task you dread.
This article is for general information and is not financial or tax advice. Consult your accountant about your specific situation.
See your accounts tie out to $0.00
Connect your bank, processors and ledger read-only. Reconciler matches transactions, flags what does not add up, and explains every match, so your books close faster. Read-only, never moves money.