How to Reconcile an Imported Bank Statement in QuickBooks

1. Keep the import and reconciliation separate

An imported statement does not complete a QuickBooks reconciliation. In QuickBooks Online, imported or downloaded rows enter the bank-transactions review area. They do not affect the books until you match them to existing records or categorize them as new records. Reconciliation then compares the resulting register with the issued statement.

Use one issued statement for one account and one statement end date. Keep the PDF or bank record open throughout the review. If you converted a PDF, retain the reviewed CSV or XLSX beside it so you can trace each imported row to the source page.

2. Confirm the account, period, and row count

Select the QuickBooks bank or credit-card account that corresponds to the statement. Check the account name, last four digits when available, and statement end date. A clean import in the wrong register creates a reconciliation problem that can look like missing activity in two accounts.

Count the statement's transaction rows and compare that count with the staged import. Explain any difference before posting rows. Page headers, subtotals, and balance summaries should stay out of the transaction count. A row omitted from the import needs a written reason tied to the source.

3. Match existing records before you categorize new ones

Open All apps, Accounting, then Bank transactions in QuickBooks Online. Select the account and review the Pending or For review area shown in your interface. Use Match when QuickBooks already contains the invoice payment, bill payment, check, receipt, transfer, or other record. Matching links the bank row to that record and avoids a duplicate.

Use Categorize when the transaction has no existing QuickBooks record and you have enough business evidence to create one. Check the suggested account before posting. A merchant name can help identify a purchase, but it cannot decide whether the cost belongs to office supplies, inventory, an asset, or an owner transaction.

4. Clear the import-review queue

Finish the statement period before you begin reconciliation. Resolve each staged row as a match, a supported new record, or an exclusion with a documented reason. Check grouped deposits, split transactions, credit-card payments, and transfers because their bank amount may represent several records or two ledgers.

Search the QuickBooks register for the same dates and amounts after review. A duplicate can enter through a prior manual entry, a bank feed, and a statement upload. Review the posted transaction before deleting or excluding anything so you preserve the record that carries the correct accounting detail.

5. Confirm the beginning balance

The QuickBooks beginning balance should agree with the prior completed reconciliation. For the first reconciliation, compare the opening-balance entry with the bank statement from the day before you began tracking the account. Stop if the beginning balance is wrong; imported current-period rows will not repair an older discrepancy.

In QuickBooks Online, use the Reconcile Discrepancy Report when a previously reconciled balance changed. In Desktop, use the beginning-balance and discrepancy tools for that edition. Trace edited, deleted, or unreconciled transactions before you alter the opening balance or create an adjustment.

6. Enter the statement ending information

QuickBooks Online users can open All apps, Accounting, then Reconcile. Select the account, review the last statement ending date, and enter the ending date and ending balance printed on the current statement. Start the reconciliation after those fields agree with the source.

QuickBooks Desktop users can open Banking, then Reconcile. Select the account, confirm the statement date and beginning balance, and enter the ending balance. Intuit also provides fields for a service charge or interest that has not entered the books. Create a company-file backup before a Desktop reconciliation.

7. Clear transactions against the issued statement

Start with the first printed transaction and find the same record in the reconciliation screen. Compare date, amount, description or name, and reference when present. Mark the record cleared only after the source supports the match. Continue in statement order so page breaks and repeated amounts stay visible.

Watch the cleared balance and difference as you work, but do not use the difference as the sole control. Two missing transactions with equal and opposite amounts can still produce $0.00. The row count and source trace in the control sheet guard against that offsetting-error case.

8. Resolve a nonzero difference at the source

Recheck the ending balance and date first. Then search for a missing row, duplicate, wrong amount, reversed sign, grouped deposit, or record outside the statement period. Compare the exact difference with transaction amounts and inspect changes to prior reconciled records when the beginning balance also changed.

Leave the reconciliation open or save it for later while you fix the source record. Do not force an unexplained adjustment to make the screen reach zero. Intuit's troubleshooting guidance directs users to find and correct the cause; an adjustment can hide the import error and create a problem in the next period.

9. Finish and preserve the report

Finish after the row review is complete and QuickBooks shows a $0.00 difference. QuickBooks Online stores the reconciliation report in History by account and also exposes reconciliation reports through Reports. Desktop can display or print a previous reconciliation report.

Save the report with the issued statement and import-control sheet. Record the preparer, completion date, source file, imported row count, matched-record count, and any excluded rows. Review the next period's beginning balance before you start new imports.

Prepare clean source rows when the bank gave you a PDF

StatementMint converts entitled bank-statement pages into CSV and formatted Excel with Date, Description, and signed Amount. It does not connect to QuickBooks, match existing records, select categories, or complete reconciliation. The export gives you a source-review table before you use QuickBooks' import and accounting workflow.

Compare the export with the issued PDF before import. Preserve the full descriptions and numeric amounts, then create a destination copy if QuickBooks needs another date representation or column layout. The related formula guide explains bank-side and book-side adjustments without duplicating this QuickBooks workflow.

Frequently asked questions