If you need to import a closed bank account into QuickBooks, the bank feed is off the table — a closed account has no live connection, so there’s nothing to download. This comes up constantly in catch-up and cleanup work: the business switched banks, closed a card, or wound down an entity, and now you need that account’s full history on the books anyway. The good news is that a closed account with no bank feed is still a solved problem, because you have the one thing that matters — the statements.
Why the feed isn’t an option (and why that’s fine)
QuickBooks’ bank feed only works with a connected, active account. Close the account and the connection disappears, taking any chance of downloading transactions with it. People assume that means the history is lost or has to be keyed in by hand. It doesn’t. The statements are a complete, authoritative record of every transaction the account ever processed, and that’s all you need for a historical bank statement import.
Get the statements first
Before anything else, collect every statement for the closed account — bank or credit card — as PDF, CSV, or Excel. If the client doesn’t have them, most banks will provide closed-account statements on request, though it can take a few days, so start that ask early. Put the statements in date order and confirm there are no gaps between periods. A missing month will leave a balance you can’t reconcile later.
Convert the statements into an import file
Here’s how I handle a closed account with no bank feed: instead of typing the history in, I convert the statements into an import file. I run the PDF/CSV/Excel statements through Bookmonstic, which reads every transaction, categorizes it with AI, and exports a QuickBooks “batch transactions import file” — built straight from the PDF statement to QuickBooks with no bank feed and no API required. (Disclosure: I’m a CPA and Bookmonstic is my own tool.) That turns months of a closed account’s history into a single import instead of a manual data-entry marathon.
For the step-by-step import mechanics, this guide on converting a PDF bank statement to QuickBooks Online walks through getting the file in.
Import, then reconcile to the final balance
Set up the closed account in QuickBooks (you can mark it inactive after the work is done), bring in the import file, and reconcile each statement period in date order against its ending balance. The last statement’s closing balance is your finish line — when the account reconciles to that final balance and zeroes out (or matches the transfer that closed it), you know the full history is captured correctly. Then book any adjusting entries and lock the periods.
Frequently asked questions
Can I import a closed bank account into QuickBooks without the bank feed? Yes. The bank feed only works on active accounts, but it isn’t required. Convert the account’s PDF/CSV/Excel statements into a batch transactions import file and bring the full history in that way.
Where do I get statements for a closed account? From the client first, and from the bank if needed — most banks provide closed-account statements on request, though it may take a few days. Collect the full date range and check for gaps before importing.
How do I confirm the closed account is fully captured? Reconcile each period to its ending balance, ending with the final statement’s closing balance. When the account ties out to that last balance, the complete history is in correctly.
Does going from a PDF statement to QuickBooks require manual entry? No. A PDF statement can be converted into an import file, so the data entry and categorization happen at once and you only review exceptions instead of keying every transaction.
Written by the founder of Bookmonstic, a practicing CPA. Bookmonstic turns PDF/CSV/Excel bank statements into AI-categorized, import-ready files for QuickBooks and Xero — no rules to build, no API. Try it free →
Leave a Reply