Fill Missing Months in QuickBooks from Statement PDFs at Year-End
Close gaps in QuickBooks Online before year-end: turn statement PDFs into upload-ready CSV files in your browser. Free QuickBooks layout.
Converts text-based PDF bank statements to CSV or Excel in your browser. Your file is never uploaded. Always review the output before using it.
Steps for small business year-end
- Download all twelve statements for each business account as a PDF (scanned PDFs aren't supported).
- Put the PDF in the converter at the top of the page.
- Check each month's first balance against the previous month's last balance.
- Set Export layout to Quickbooks layout (free), choose Download CSV, then put each month on its own tab.
What the file looks like
| Date | Description | Amount |
|---|---|---|
| 12/15/2026 | Payroll service | -3150.00 |
| 12/31/2026 | Bank service fee | -15.00 |
| 12/18/2026 | Card processor payout | 2316.55 |
Sample rows, Quickbooks layout setting.
QuickBooks notes
- QuickBooks Online accepts a bank CSV in a 3-column format (Date, Description, Amount) or a 4-column format (Date, Description, Credit, Debit). The Quickbooks layout uses the 3-column format, with money in positive and money out negative, and dates as MM/DD/YYYY.
- Intuit's own limits: the file must be 350 KB or less, up to 1,000 lines per upload, and cells that only contain zero should be blank. The Quickbooks layout already leaves out $0 rows, so there's nothing to delete.
Why it fits small business year-end
At year-end you often find a bank feed dropped for a few weeks. Convert just the missing statements and upload them, rather than keying in every line.
A common year-end pattern: run a reconciliation for each month, note which months fail, then convert and upload only those statements. Reconcile again once the uploaded rows are added. It's far quicker than re-entering the whole year.
Tip: Check the dates already in QuickBooks first, then delete rows in the preview that QuickBooks already has, so you don't create duplicates.
Questions
Can I upload a whole year at once?
Intuit limits uploads to 1,000 lines and 350 KB, so busy accounts usually need to go a few months at a time.
What if a month's statement has no activity?
The tool tells you there are no transactions in that statement period, and there's nothing to upload for that month.
What about the opening balance?
QuickBooks works from the transactions you add. If the account's opening balance is wrong, fix it in QuickBooks rather than in the uploaded file.
RowSmith is an independent tool and is not affiliated with any bank or software company named on this page.
Converting is free. RowSmith Pro ($9/month or $59/year) adds suggested Schedule C categories, saved cleanup rules and monthly category totals.