QuickBooks
Closed bank account statements to QuickBooks
A practical workflow for converting closed-account statement PDFs into reviewable CSV rows for QuickBooks cleanup work.
The bank feed may no longer be available
When an account is closed, users may lose easy access to CSV exports or a live QuickBooks connection. The remaining archive is often a folder of monthly PDF statements.
Use statement PDFs as the source of truth
Original downloaded PDFs are the best input. Redacted scans can work if dates, descriptions, amounts, and the full transaction table remain readable.
Export rows for review
A closed-account cleanup file should focus on actual transactions. Summaries, beginning balances, ending balances, fee disclosures, and page footers should not become imported rows.
Use the result downstream
After review, the CSV can be used for QuickBooks import prep, spreadsheet cleanup, reconciliation, or an accountant handoff package.
Closed-account review checks
- Date range
- Does the CSV cover the same month as the statement?
- Missing pages
- Are all transaction pages included?
- Signs
- Are withdrawals negative and deposits positive?
- Duplicates
- Was the same month already imported from another source?
FAQ
Can I redact the account number?
Yes. Redacting account numbers is fine as long as the transaction table remains readable.
Does a closed account need a bank login?
No. This workflow is file-based. The user uploads statements instead of reconnecting bank credentials.
What if I only have scanned copies?
Scans can work when they are upright, bright, and complete. Original PDFs are usually more reliable.
Turn a statement file into reviewable rows
Upload a PDF, scan, screenshot, or clear photo and review the rows before downloading CSV.