Reconcile a bank statement CSV with your accounting software, step by step

Published 19 October 2026 · by Tekiba

Three checks straight after the import

1. The count

Note how many transaction rows the CSV holds, then how many lines arrived. QuickBooks Online counts the same way: “You can include up to 1,000 lines per upload. Each line contains one transaction.” Xero shows a review screen before the import goes through, and it can leave lines out on purpose: “Transactions matching those already in Xero will be treated as duplicates and won’t be imported.” So a smaller count is not always an error, but it always needs an explanation — and two real payments of the same amount on the same day are worth checking by name.

2. Overlap with what was already there

The commonest duplicate is a file whose dates overlap the bank feed or an earlier import. Intuit lists the causes: “This can happen if you reconnect an account, import a file that overlaps with your bank feed, add a downloaded transaction instead of matching it, or record the same sale in two different ways.” Its advice for next time is simple: “Import files that start after the newest transaction that's already in QuickBooks.” Xero says the same of its own lines: “Duplicate bank statement lines can occur if a bank statement is manually imported into an organisation, as well as imported via a bank feed.”

3. The statement balance

In Xero, the imported lines build a balance of their own. “The Statement Balance in Xero is the opening bank balance plus the sum of all bank statements imported into the bank account in Xero.” Compare it with the closing balance on the PDF for the same date. If they differ before you have reconciled anything, the problem is in the import or the opening balance, not in the matching.

Reconciling in QuickBooks Online

1. Review the uploaded transactions first. Uploaded rows wait on the For review tab, which may be labelled Pending, and cannot be reconciled from there. Match each one to a record you already have, add or categorise the new ones, and exclude confirmed duplicates. Intuit's reconcile page asks for exactly that: “Make sure that all transactions for the statement period have been added and categorized in QuickBooks.”
2. Open the reconcile screen. Intuit's path is “Go to All apps , then Accounting, then Reconcile”, then choose the account.
3. Check where the last one ended. “Review the Last statement ending date. Your current account statement should start the day after this date.” A gap or overlap here is the first thing to fix.
4. Enter the statement's figures. “Enter the Ending balance and Ending date from your account statement.” You do not type a beginning balance: QuickBooks carries it from the last reconciliation.
5. Tick each line that is on the statement. “Continue matching until the Difference is $0.00. This means your account is balanced.” Then finish; QuickBooks saves a reconciliation report.

If the beginning balance is wrong, QuickBooks stops you there. Intuit explains: “It should match the ending balance of your last reconciliation. If it doesn't, QuickBooks won't let you continue until you account for the difference.” The Reconcile Discrepancy Report lists what changed since; deleted and voided transactions are not in it, and the page sends you to the audit log for those. On a first reconciliation, Intuit says the cause is usually the opening balance.

Reconciling in Xero

1. Open the Reconcile tab for the account. Xero describes the job: “Your aim is to match each statement line in the bank account to an existing transaction in Xero, or create a transaction during the reconciliation process.”
2. Accept good suggestions, search for the rest. Where Xero suggests the right transaction, accept it; where it does not, use find & match rather than creating a new one, which is how duplicates are made.
3. Compare the two balances at the end. “Once you’ve reconciled the bank account, the statement balance in Xero and the balance in Xero should be the same.”
4. Run the report. The Bank Reconciliation report pack puts the figures side by side: “your Balance in Xero, Statement balance (calculated) and the balance in your online banking for that day should be the same.” Enter the bank's ending balance on the summary and it shows how far the calculated balance is out.

Reconciling in Wave

Wave's reconciliation is on the web version. Its help page says to “enter the end date and closing balance of the bank statement, then click Start reconciling.” and that “The Difference amount will be zero once all transactions have been matched and there are no discrepancies between transactions and your bank statement.”

When it will not reach zero

1. Check the figures you typed. The ending balance and date from the statement, and in QuickBooks the last ending date. Intuit's first causes are an ending balance entered wrongly and transactions entered that have not yet cleared the bank.
2. Find the date it goes wrong. Xero's method works in any program: run the reconciliation report for a month after the last date the balances agreed, then for dates inside that month, “Keep doing this until you've identified the date where the balances go out.”
3. Read that stretch line by line. Look for a line missing, a line imported twice, a line deleted by mistake. The size of the difference helps: one transaction's amount suggests one missing or doubled line; twice an amount suggests a sign the wrong way round.
4. Fix duplicates the way the program expects. In QuickBooks, exclude a downloaded duplicate rather than deleting it — “If you delete the transaction instead, QuickBooks will download it again from the bank.” — and if one copy is reconciled, keep that one. In Xero, “you should only delete a statement line if it’s a duplicate”; a deleted line can be restored. If a whole file went in wrongly, undo a bank statement CSV upload in QuickBooks Online and delete an imported bank statement in Xero cover taking it back out.
5. Look at the file itself. If the stretch that goes wrong is one the CSV covers, compare it with the PDF. A row the converter missed, or a sign it read the wrong way, will show there; how to check a converted bank statement CSV for errors lists what to look for.

What this page cannot tell you

Whether a difference should be written off, or how an adjustment belongs in your books; that is for whoever keeps them. Menus and plan features change, and some QuickBooks reconciliation tools depend on the plan. Other accounting programs are not covered, though the method — count, overlap, balance, then the date where it goes wrong — carries over.

Questions