Closed bank account: getting its last months into QuickBooks or Xero

A business switches banks, or a client closes an old account partway through the year. The bank feed stops, and the books end wherever the feed last downloaded. At year-end the months between that point and the closing date are still missing, and the statement PDFs are usually the only place they exist.

This guide covers getting those months in, proving the account ends at the right balance, and then closing it out cleanly in QuickBooks Online or Xero.

Why the bank feed can't fill the gap

• Intuit says that when a bank account is closed or suspended, the bank stops sharing its data with QuickBooks, and the account "can't be reconnected and needs to be disconnected" (Intuit: fix bank connection error 324, updated Aug 21, 2026).
• Intuit also says that if transactions are older than 90 days, you won't be able to download them from the bank when you reconnect, and that you can still upload old transactions manually (Intuit: disconnect accounts connected to online banking, updated Aug 17, 2026).
• So the remaining months come in by file: the statement PDF itself, or a CSV, QBO or OFX file made from it.

1. Get every statement while you still can

• Download one PDF per statement period from online banking, from the last month the books cover through the final statement. How long a closed account's statements stay available online varies by bank, so download them now and ask the bank for copies of anything you can't find.
• Make sure you have the final statement. It shows the closing date and the last balance, which is usually zero once the remaining money has moved to the new account.
• Name the files by account and period (for example 4821_2026-06.pdf) so a missing month is obvious.
• Keep the PDFs with the workpapers. The IRS says to keep records that support items on a tax return until the period of limitations for that return runs out, generally 3 years, longer in some situations (IRS: how long should I keep records?). Confirm what applies with the client's tax preparer; this isn't tax advice.

2. Find where the books stop

1. Open the account's register and sort by date. Note the last transaction that is already in the books.
2. In QuickBooks Online, also look at the account's tile in Bank transactions for anything still waiting to be added. Intuit says that when you disconnect, QuickBooks removes any transactions still in the Pending tab, so add or match them first (Intuit).
3. Everything after the last transaction in the books, up to the closing date, is the gap. Work out which statement months that covers.

3. Tie out each month, down to the final balance

• For each statement: opening balance + deposits − withdrawals = closing balance, using the totals printed on the statement.
• Chain the months: each closing balance equals the next statement's opening balance, all the way to the final statement.
• At the first month of the gap, the statement's opening balance should equal the register balance after the last transaction already in the books. If it doesn't, something before the gap is missing or doubled; fix that first.
• The full method, with a worked example, is in check a statement PDF is complete before you import it. Our free tie-out checker shows the row where a CSV stops balancing.

4. Bring the missing months in

QuickBooks Online. Intuit's manual upload is for when you can't connect your bank or need earlier transactions. It accepts an account statement as a PDF or image, or a list of transactions as a QBO, QFX or CSV file. A list must be 350 KB or less, with 3 columns (Date, Description, Amount) or 4 (Date, Description, Credit, Debit), and up to 1,000 lines per upload (Intuit: manually upload transactions into QuickBooks Online, updated Aug 24, 2026).

1. Go to Bank transactions, select the closed account's tile, open Link account ▾ and choose Upload from file.
2. In the QuickBooks account dropdown, pick the existing account, not a new one, so the history stays in one register (Intuit).
3. Upload oldest month first. For a PDF, check the side-by-side view of the statement against what QuickBooks extracted before you save.
4. Start each file the day after the last transaction already in the books, so nothing comes in twice. See duplicate transactions after a bank upload.

QuickBooks Desktop. Bank transactions come in as Web Connect .qbo files. See convert a PDF bank statement to a QBO file.

Xero. Import into the same bank account: Accounting → Bank accounts, the account's menu, Import a Statement. A CSV needs at least Date and Amount, with income positive and expenses negative in one column, and no opening or closing balance columns, because Xero calculates the balance from the transactions. Xero treats transactions matching ones already in Xero as duplicates and won't import them (Xero Central: import a bank statement in CSV format). More: importing bank statements into Xero.

5. Reconcile to the final statement

• Reconcile one statement at a time, oldest first, to each statement's ending balance. The last reconciliation should land on the final statement's balance.
• The closing transfer to the new account appears on both statements. Record it as a transfer between the two bank accounts, not as income or an expense, and check both sides match.
• If the beginning balance on the reconcile screen is off, stop and fix it rather than forcing an adjustment. See beginning balance doesn't match.

6. Close the account out in the software

QuickBooks Online:

• Intuit distinguishes two steps. Disconnecting stops new downloads but keeps the account active. Making the account inactive is for an account you no longer use, and it also disconnects it from online banking; the account shows "(Deleted)" but isn't gone, and its transactions stay in your reports (Intuit).
• Get the balance to zero first. Intuit says that if a balance sheet account you make inactive still has a balance, QuickBooks Online creates an automatic adjustment to zero it out and adds it to the Opening Balance Equity account, which can affect balances and sales tax reports. If you later reactivate the account, QuickBooks won't move the balance back (Intuit: make an account inactive, updated Aug 5, 2026).
• To make it inactive: Settings → Chart of accounts, find the account, then Make inactive in the Action column (Intuit). Intuit also asks you to check with your accountant before you do.
• Adding the replacement account: disconnect the closed one first, or QuickBooks shows an error saying it's already connected (Intuit).

Xero:

• A bank account that has transactions must be archived, not deleted. Delete is only for an account that never had a statement imported or transactions added (Xero Central: delete or archive a bank account).
• Transactions from an archived account still appear in reports, and an archived account can be restored. A deleted one can't (Xero Central).
• To archive: Accounting → Chart of accounts, tick the bank account, Archive, OK. You need the administrator or standard + bank accounts user role (Xero Central).

Doing a full year-end? See the year-end bookkeeping catch-up checklist. Several accounts with months missing? See importing multiple months of bank statements.

Where LedgerReady fits

If you'd rather not convert and check each month yourself, LedgerReady turns digital statement PDFs into a QBO file, a Xero CSV, a plain CSV and a tie-out sheet showing every month matches its opening and closing balance. It costs $15 per statement-month, and we aim to deliver within 12 hours. Tie-out guarantee: if the output doesn't reconcile to the statement's opening and closing balances and we can't fix it, you don't pay for that statement.

Bank menus change; labels here were accurate to our knowledge in Oct 2026, so check your bank's help pages if something differs.