Why Doesn’t My QuickBooks Balance Match My Bank Statement?
The September statement ends at $14,465. The QuickBooks register shows $13,760. The $705 gap looks like one problem, but it comes from three transactions that need three different decisions.
If QuickBooks Online doesn’t match your bank statement, first confirm the account, opening balance, statement end date, and statement ending balance. Then compare posted bank transactions with entries in the QuickBooks register. A payment can be recorded in September and clear in October, so keep timing differences separate from entries that need a correction. Intuit’s guide to reconciliation differences
Get two lists for the same account
Bank. Use the transaction CSV for the statement period and keep the statement’s opening and ending balances. Keep the posted date, description, signed amount, and check number or reference when available. A few days of activity from the next statement can help confirm when an outstanding payment cleared.
QuickBooks Online. Export transaction detail for that checking account and period to Excel. Keep the transaction date, payee, signed amount, reference, and entry source if available. Use a detail report for the checking account so the export includes the posted entries you’re comparing. Intuit’s Excel export instructions
Put the records on separate Bank and QuickBooks tabs. Check that money in is positive and money out is negative on both sides. If you already keep a reconciliation workbook, work from copies of its source tabs.
Match the transactions before chasing the balance
Start with check numbers or references when both sides have them. Confirm the amount and direction. Where no reference is shared, use the amount, payee or memo, and a plausible date window. If two entries could match the same bank debit, leave them for review. The amount alone can’t tell you whether a second payment was recorded twice or paid twice.
| Finding in the sample | Where to look | What it explains |
|---|---|---|
| $35 bank fee | Bank row 12 | One posted bank debit has no corresponding entry in the register. |
| Possible $260 duplicate | Bank row 9 and QuickBooks rows 9–10 | One bank debit matches two book entries, one from the feed and one entered manually. |
| $480 outstanding check | QuickBooks row 13 and Bank row 13 | The check was issued September 30 and posted at the bank October 2. |
Subtract the outstanding $480 check from the bank’s $14,465 balance. On the book side, account for the missing $35 fee and reverse the effect of the extra $260 debit once you confirm it is a duplicate. Both sides come to $13,985. The October bank row explains the September timing difference and stays outside the September total.
Try the same check in Jolene.pro
Select the two source tabs in Jolene.pro and use the prompt below. Change the dates and opening balance to fit your file. Open the cited rows and confirm each proposed match before updating the books.
Compare the Bank and QuickBooks tabs for September 1–30, 2026, using $12,000 as the opening balance on both sides. Show bank-only items, possible duplicate book entries, and book entries that cleared after September 30. Use October rows only as clearing evidence. Explain the balance difference and cite the source rows. Flag any uncertain matches.
Copy the sample data
Use a $12,000 opening balance on both sides. Save each block as a separate CSV, then import each into the corresponding tab of one Excel workbook. Row references above use the sample workbook’s layout, with headers on row 3. Use the transaction references if your headers start on row 1.
Bank CSV
Posted date,Bank ID,Description,Reference,Amount (USD)
2026-09-02,BK-101,Cedar Studio client payment,DEP-701,4200.00
2026-09-04,BK-102,Rent transfer,ACH-901,-900.00
2026-09-08,BK-103,Harbor Internet,ACH-902,-58.75
2026-09-11,BK-104,Payroll withdrawal,PAY-211,-1125.50
2026-09-15,BK-105,Northline client payment,DEP-702,1825.00
2026-09-18,BK-106,Mesa Office Supply,ACH-903,-260.00
2026-09-22,BK-107,Equipment service,ACH-904,-430.25
2026-09-26,BK-108,Insurance premium,ACH-905,-750.50
2026-09-30,BK-109,Monthly bank service fee,FEE-0930,-35.00
2026-10-02,BK-110,Oak Printworks check cleared,CHK-1048,-480.00
QuickBooks CSV
Transaction date,QuickBooks ID,Payee or memo,Reference,Amount (USD),Entry source
2026-09-02,QB-501,Cedar Studio client payment,DEP-701,4200.00,Deposit
2026-09-04,QB-502,Rent transfer,ACH-901,-900.00,Bank feed
2026-09-08,QB-503,Harbor Internet,ACH-902,-58.75,Bank feed
2026-09-11,QB-504,Payroll withdrawal,PAY-211,-1125.50,Payroll
2026-09-15,QB-505,Northline client payment,DEP-702,1825.00,Deposit
2026-09-18,QB-506,Mesa Office Supply,ACH-903,-260.00,Bank feed
2026-09-18,QB-507,Mesa Office Supply,ACH-903,-260.00,Manual entry
2026-09-22,QB-508,Equipment service,ACH-904,-430.25,Bank feed
2026-09-26,QB-509,Insurance premium,ACH-905,-750.50,Bank feed
2026-09-30,QB-510,Oak Printworks check issued,CHK-1048,-480.00,Check
This example uses fictional transactions. Confirm proposed changes against your records and complete the reconciliation in QuickBooks Online.