Reconcile in QuickBooks Online or Desktop and fix a difference that will not go to zero. Convert any missing months to a .qbo file and import the gaps.
Upload your bank statement
Drop file here or click to upload
PDF, JPG, PNG, BMP, HEIC, TIFF · Max 50MB
Uploading...
To reconcile a bank statement in QuickBooks, you enter the statement's ending balance and date, then check off every QuickBooks transaction that appears on the statement until the difference reads $0.00. When the difference will not go to zero, it is almost always because transactions are missing, duplicated, or were edited after a past reconciliation. If a whole period is missing because the bank feed never pulled it, the fastest fix is to convert that statement PDF to a .qbo file with the tool above and import it, so QuickBooks holds every line on the statement and the difference resolves.
Last updated June 2026. QuickBooks menus and reconciliation screens change between versions; confirm the current steps for your QuickBooks Online or Desktop edition.
Reconciliation is the check that proves your books match the bank. You compare what QuickBooks recorded against the official statement, line by line, and the account is reconciled only when the two agree to the penny. Most of the time it goes smoothly. The trouble starts when the difference sits at some stubborn number that is not zero, and you are left hunting for which transaction is wrong, doubled, or simply not there.
The single most common reason a reconciliation will not balance is a transaction that is on the statement but not in QuickBooks. The live bank feed only reaches back about 90 days, so any month earlier than that often never made it in, and a feed that silently dropped for a few weeks leaves a hole nobody notices until reconciliation time. The converter at the top of this page turns the statement you are reconciling against into a .qbo Web Connect file QuickBooks imports as a standard bank feed, so the missing transactions post with their real dates and the account ties out.
| Why the difference is not zero | What it looks like | How to fix it |
|---|---|---|
| Missing transactions | On the statement but not in QuickBooks | Import the missing period: convert the PDF statement to .qbo and upload it |
| Duplicate transactions | The same charge posted twice (feed plus a manual entry) | Delete the duplicate and keep one copy |
| Beginning balance is off | A previously reconciled transaction was later edited or deleted | Restore the change, or re-reconcile that transaction |
| Wrong ending balance or date | The difference equals one round figure you typed | Re-enter the statement's ending balance and ending date |
Work down that list and the difference usually collapses to zero. The rest of this page answers the specific questions people ask when a reconciliation fights back, with the exact steps for both QuickBooks Online and QuickBooks Desktop.
Built for the statements US banks actually send, checked before it exports.
The converter adds up the transactions it parsed and matches that to the statement total before you export, so nothing is silently dropped.
Valid OFX 1.02 with QuickBooks Web Connect headers. Online and Desktop import it as a standard bank feed.
OCR runs before parsing, so a scanned or photographed paper statement comes out the same as a digital PDF.
Bulk upload for catch-up and cleanup work. Each file gets its own reconciliation check and its own exports.
Enter the password on upload. Multi-column and multi-page statement layouts are parsed too.
One conversion, three files: the .qbo for QuickBooks, an XLSX to review, and a CSV for everything else.
Three steps. No column-mapping wizard.
Drag in a PDF, a scan, or a phone photo. Password-protected and multi-page files are fine.
Every transaction is extracted and checked against the statement total. You see the parsed rows before exporting.
Download the .qbo and import it as a Web Connect bank feed. Excel and CSV are in the same download.
The specifics that decide whether the import is clean. If your case is not here, email [email protected].
In QuickBooks Online go to Settings, then Reconcile, or open Transactions and select Reconcile. Pick the account, enter the Ending balance and Ending date from your bank statement, and select Start reconciling. Check off each transaction that matches the statement until the Difference shows $0.00, then select Finish now.
In QuickBooks Desktop open the Banking menu and select Reconcile. Choose the account, enter the Statement Date and Ending Balance, and add any service charge or interest the bank lists. Mark every transaction that cleared the statement until the Difference is 0.00, then select Reconcile Now to save the report.
A bank account will not reconcile when the difference between the statement and QuickBooks is not zero. The usual causes are transactions on the statement that were never recorded in QuickBooks, duplicate entries, a transaction with the wrong amount or date, or a beginning balance thrown off by an edited reconciled item. Fix the cause and the difference clears.
A reconciliation discrepancy is caused by a change to data after a reconciliation was finished, or by transactions that do not match the bank. Common triggers are a previously reconciled transaction that was edited, deleted, or unreconciled, a duplicate from the bank feed, or a missing month the feed never imported. QuickBooks flags the gap so you can trace it.
Your bank balance and QuickBooks balance differ when timing or missing data separates the two. Outstanding checks and deposits that have not cleared, transactions the bank feed never pulled, duplicates, and uncategorized entries all create a gap. Reconcile the account against the statement to find the exact transactions responsible, then add, remove, or correct them.
A wrong beginning balance has one root cause: a transaction that was reconciled in a past period was later changed, deleted, or unreconciled. QuickBooks built this period's opening figure from those cleared items, so altering one breaks it. The full repair sequence, including the first reconciliation case, is in the guide to changing the beginning balance in QuickBooks Online. Run the reconciliation discrepancy report to find the edited transaction and restore it, then your beginning balance matches again.
Compare the statement to QuickBooks and note every line on the statement that is not in your register. Enter each as the matching expense, deposit, or transfer, or import them in one pass. For a whole missing month, converting the statement to a .qbo file and uploading it is faster and more accurate than typing every line by hand.
Download that month's statement from your bank, convert the PDF to a .qbo file with the converter above, then in QuickBooks Online go to Transactions, Bank transactions, Upload from file. In QuickBooks Desktop use File, Utilities, Import, Web Connect Files. The transactions post with their original dates, so the period is complete and ready to reconcile.
Start with the reconciliation discrepancy report, which lists every reconciled transaction that changed since the last reconcile. Restore or re-enter the items it flags. Then look for missing transactions on the statement and import or add them, and delete any duplicates. When the discrepancy total reaches $0.00, the account reconciles cleanly.
The reconciliation discrepancy report shows transactions that were modified, deleted, or unreconciled after a reconciliation was completed, which is what throws the beginning balance off. In QuickBooks Desktop open Reports, Banking, Reconciliation Discrepancy and pick the account. In QuickBooks Online the report opens from the We can help you fix it link when a discrepancy is detected.
Reconcile one statement period at a time, oldest first, never several months at once. Start with the earliest unreconciled statement, balance it to $0.00, then move to the next month. If older months are missing from QuickBooks, import each statement as a .qbo file before you reconcile it so every period has its transactions in place.
Yes. A live bank feed is optional for reconciliation. You can enter or import transactions manually and still reconcile them against the paper or PDF statement. Many businesses that will not connect a feed convert each statement to a .qbo file, upload it, and reconcile from that, which keeps bank login credentials out of QuickBooks entirely.
QuickBooks cannot read a raw PDF, so you convert it first. Use the tool above to turn the PDF statement into a .qbo file, import it through Upload from file in QuickBooks Online or Web Connect Files in Desktop, then reconcile against the same statement's ending balance and date. Every line on the statement is now in the register to match.
Reconcile every account once a month, as soon as the statement closes. Monthly reconciliation catches missing or duplicate transactions while they are easy to trace, keeps your reports accurate, and means year-end and tax filing start from books that already tie to the bank. Letting it slide for months turns a quick check into a long catch-up.
Upload a PDF, see every transaction extracted in seconds. No card to try it.
Still comparing tools? See our bank statement to QuickBooks converter comparison.
Keep going with the related guides: learn how to import old bank statements into QuickBooks past the 90-day feed limit, see how far back QuickBooks can import bank transactions, read why your bank balance doesn't match QuickBooks, and fix a stuck file with why QuickBooks won't import your .qbo file. At tax time, import a full year of statements for taxes, and bookkeepers reconciling many clients should read bank statement to QuickBooks for accountants and don't forget the credit card statements. While you hunt down a difference, a bank statement to Excel converter gives you a spreadsheet to compare against the register, a CSV to QBO converter handles any account that only exports CSV, and a receipt scanning tool matches the expense lines you are clearing to their receipts.
Same converter, tuned for the layout each bank uses. Find yours:
For one bookkeeper running monthly close.
USD
per month
billed as
$288 yearly
Choose speed vs accuracy when extracting
| Base AI Faster | 2,500 pages |
| Pro AI Best accuracy | 500 pages |
For an accounting firm or finance team with steady volume. Adds QuickBooks .qbo export and bulk conversion.
USD
per month
billed as
$888 yearly
Choose speed vs accuracy when extracting
| Base AI Faster | 10,000 pages |
| Pro AI Best accuracy | 2,000 pages |
For lenders, audit firms and analysts running thousands of statements a month.
USD
per month
billed as
$ yearly
Choose speed vs accuracy when extracting
| Base AI Faster | pages |
| Pro AI Best accuracy | pages |
