QuickBooks Cleanup and Catch Up Bookkeeping: Convert Old PDF Bank Statements to QBO

Every cleanup job hits the same wall in the first hour. The bank feed only reaches back about 90 days, the books are eight or eighteen months behind, and the only record of what happened is a folder of PDF statements. PDFQBO turns those statements into QBO files QuickBooks accepts, with no date limit, so you can rebuild the missing period in the order it actually happened instead of keying it in by hand.

Quick answer

To catch up months of bookkeeping in QuickBooks, do not rely on the bank feed. It usually pulls only the last 90 days. Download every monthly PDF statement for the missing period, convert each one to a QBO (Web Connect) file with PDFQBO, and import them oldest month first. Categorize and reconcile one month before you import the next, checking the register against the closing balance printed on that statement. Errors then surface a month at a time instead of compounding across a year.

No date limit on imports Whole backlog in one sitting Review before anything posts

Last updated August 2026

Convert a back-period statement to QBO

Upload any month's PDF statement, however old, and download a QBO file for QuickBooks.

No credit card required to try your first statement.

Any date

Prior years included

QBO + IIF

Online and Desktop

Every account

Bank, card, loan

Auto delete

Files removed after use

How to catch up months of bookkeeping in QuickBooks

Four steps take a folder of old PDF statements to a reconciled QuickBooks file, one month at a time.

Inventory the accounts

List every account that touched business money in the missing period: operating checking, savings, each credit card, a line of credit, a merchant account, a payroll account. Download the monthly PDF for each one, all the way back to the last month that was reconciled. A missed card is the usual reason a cleanup never balances.

Convert oldest first

Upload the statements to the tool above, one account and one month at a time, starting with the oldest. Chronological order keeps running balances meaningful and makes gaps obvious the moment they appear. Scanned and mailed statements work too, which matters for prior-year work.

Import and categorize

Import each QBO file into its matching QuickBooks bank account, then categorize that month before moving on. Build bank rules as you go, because a cleanup repeats the same vendors dozens of times and rules turn month three onward into a much faster job than month one.

Reconcile before you move on

Reconcile each month against the closing balance printed on that statement, then start the next month. Reconciling as you go is the whole discipline. Import a year first and reconcile later, and a single duplicated or missing transaction leaves you hunting through twelve months of register instead of one.

Why catch up work stalls, and what actually unblocks it

Cleanup jobs rarely fail because the accounting is hard. They fail on data access, on sequence, and on a handful of decisions that are cheap to make at the start and expensive to change in month nine.

The bank feed cannot reach the period you need

When you connect a bank to QuickBooks Online, the feed typically pulls about the last 90 days. Some institutions release more, occasionally a year or two, but you find out only after connecting and you cannot ask for more. That window is the opposite of what a cleanup needs. The 90 days the feed hands you are usually the months already entered, and the eighteen months you are missing are exactly the ones it will not give you. Statement imports have no such limit: a QBO file dated 2023 imports as readily as one dated last week.

Connecting the feed before you import history creates the duplicates

The most common self-inflicted wound in cleanup work is connecting the live feed first, letting it drop 90 days of transactions in, and then importing statement files that cover the same 90 days. Now every recent transaction exists twice, and untangling that is slower than the import it was meant to save. Decide the boundary before you start. Pick the date the feed's coverage begins, import statement files up to the day before it, and let the feed own everything from that day forward.

The opening balance decides whether anything will ever reconcile

Before the first historical file goes in, the account needs a correct starting point: the closing balance from the last statement before your catch-up period, dated the last day of that statement. Get this wrong and every month afterwards is off by the same amount, and you will spend the cleanup chasing a difference that was baked in on day one. If the account already carries a wrong opening balance from an earlier attempt, fix it before importing rather than after.

Closed periods and filed returns constrain what you may touch

A catch-up often crosses a year whose tax return is already filed. Those months are not free to edit. Changing a prior-year transaction that fed a filed return changes the numbers the return was built on, so the correction usually belongs in the current period as an adjusting entry, made with the tax preparer, rather than as a quiet edit to a closed month. Set a closing date with a password in QuickBooks before you start so nobody, including you at 11pm, edits across the line by accident.

Statements are evidence of cash, not of accrual

Bank statements tell you what moved and when. They do not tell you what a payment was for, whether a deposit was revenue or a transfer or an owner contribution, or which invoice a customer was settling. That is why a cleanup built only from statements produces an accurate cash picture and a badly wrong income statement. Pair the imports with the sales records, the payroll reports, and the vendor bills for the same period, and treat any line you cannot source as a question for the client rather than a guess into Miscellaneous.

Undeposited Funds and owner draws are where the mess concentrates

Two accounts absorb most of the damage in neglected books. Undeposited Funds swells because payments were recorded as received but never matched to the deposit that actually hit the bank, so the same money sits in the register twice. And personal spending run through the business card gets coded to expense accounts it does not belong in, which overstates deductions in a way that matters more than the bookkeeping tidiness suggests. Clear both deliberately. They will not resolve themselves as you import more months.

How far back each way of getting history into QuickBooks reaches

This is the table worth reading before you plan a catch-up, because it decides how much of the backlog you can actually pull and how much you have to rebuild from statements.

Method	How far back	What it is good for in a cleanup
Connected bank feed	About 90 days on most banks, occasionally 12 to 24 months	Keeping current from today forward. Almost never enough for the backlog itself.
Web Connect file downloaded from the bank	Whatever the bank's site offers, commonly 12 to 18 months	The easiest win when the bank still has it. Check the date range before you assume.
QBO file converted from a PDF statement	No limit. Any month you hold a statement for	The reliable route for prior years and closed accounts. This is what this page is about.
CSV upload	No limit, but the file has to match QuickBooks' column format	Workable, though it carries no account identifier, so mis-imports into the wrong register are easy.
QuickBooks Online built-in PDF upload	No date limit, but capped by file size and transaction count	Fine for a small recent statement. It posts lines without a review step, which is the wrong trade in cleanup work.
Manual entry	Unlimited, at roughly a minute per transaction	Only sane for a handful of lines. A year of a busy account is thousands of them.
Accountant's prior file or trial balance	Through the last filed year	Use it to set the opening balances the catch-up starts from, not to re-derive detail.

Bank feed history varies by institution and changes without notice, so confirm what your own bank released after connecting rather than planning around a number.

What order to clean up QuickBooks in

Sequence matters more than speed. Each step below assumes the one above it is finished, and doing them out of order is what turns a two-week job into a two-month one.

Step	What you do	What breaks if you skip it
1. Scope the gap	Find the last month that genuinely reconciled, and list every account open since.	You rebuild months that were already fine, or miss an account entirely.
2. Lock the closed periods	Set a closing date with a password through the last filed tax year.	A stray edit changes a year whose return is already filed.
3. Fix the chart of accounts	Merge duplicates and retire dead accounts before thousands of lines land on them.	You categorize a year into accounts you then have to merge and re-check.
4. Set opening balances	Enter each account's balance as of the day before the catch-up period starts.	Every month is off by the same amount and nothing ever reconciles.
5. Import history, oldest first	Convert each PDF statement to QBO and import month by month, per account.	Running balances stop meaning anything and gaps hide until reconciliation.
6. Categorize with rules	Build bank rules on the vendors that repeat, then work the month.	You hand-code the same twenty vendors a hundred times.
7. Reconcile that month	Match to the closing balance on the statement before importing the next month.	One duplicate turns into a twelve-month search instead of a one-month one.
8. Clear the holding accounts	Empty Undeposited Funds, settle Opening Balance Equity, split out owner draws.	The balance sheet stays wrong even though every bank account ties out.
9. Review AR and AP	Age both, write off what is genuinely uncollectible, clear negative balances.	Phantom receivables and payables carry into the financials and the return.
10. Hand off with a trial balance	Produce a trial balance and a note on every judgment call you made.	The tax preparer redoes your work because they cannot see your reasoning.

Built for the volume a catch-up job actually involves

Many months, several accounts, and statements that are often scans rather than clean digital files.

No date limit

A statement from three years ago converts the same way as last month's. The QBO file carries the real transaction dates, so the register rebuilds in the right period rather than landing today.

Scanned statements work

Older statements often arrive as scans or photos rather than downloadable PDFs. Those convert too, which matters because the oldest months of a backlog are the ones most likely to be paper.

A whole backlog in one sitting

Run a year of statements for every account in a single pass rather than a file a day. The batch converter page covers the workflow when you have dozens of documents to get through.

Review before anything posts

Every transaction is shown before export. Catching a misread on screen takes seconds. Finding it later in a reconciled month, after eleven more months went in on top, does not.

Cards and loans, not just checking

Credit card statements convert the same way and import to the card account, with charges and payments on the correct sides. Forgotten cards are the classic reason a cleanup will not tie out.

QBO and IIF output

Download a QBO Web Connect file for QuickBooks Online or Desktop, or an IIF file if the client's Desktop file needs one. Any US bank or card statement format is fair game.

Who uses this

Bookkeepers selling cleanup work

Catch-up engagements are usually quoted per month of backlog, so the hours spent keying statements come straight out of the margin. Converting them is the difference between a profitable cleanup and a break-even one.

CPA firms in filing season

A client arrives in March with a shoebox and an extension deadline. Rebuilding the year from statements is faster and more defensible than working from a summary nobody can tie to a bank balance.

Owners catching their own books up

Businesses that fell behind through a busy year, a bookkeeper leaving, or a bank switch, and now need a real set of numbers before a return, a loan application, or a sale.

Frequently asked questions

What is a QuickBooks cleanup?

A QuickBooks cleanup is the work of making an existing company file accurate again: importing the transactions that were never entered, correcting miscategorized ones, clearing holding accounts like Undeposited Funds and Opening Balance Equity, and reconciling every bank and card account to the statements. It ends with a trial balance somebody can file a return from. Catch up bookkeeping is the same job when the missing period is months or years rather than a few messy weeks.

How do I catch up on months of bookkeeping?

Work chronologically, one account at a time. Gather every monthly statement back to the last reconciled month, set correct opening balances, then convert each PDF statement to a QBO file and import it oldest first. Categorize and reconcile each month against the closing balance printed on that statement before importing the next. The discipline is reconciling as you go, not at the end.

How far back can QuickBooks import bank transactions?

There is no date limit on importing a QBO, Web Connect, or CSV file. You can import a statement from any year and the transactions land on their real dates. The limit people run into belongs to the connected bank feed, which typically pulls only about the last 90 days when you first link an account. Statement imports are how you get anything older than that.

Can I import old bank statements into QuickBooks?

Yes. QuickBooks accepts imported transaction files regardless of how old the period is, so a statement from two or three years ago imports exactly like a recent one. What QuickBooks will not do reliably is read the PDF itself, especially on Desktop, which has no PDF capability at all. Convert the PDF to a QBO file first, then import that.

How long does a QuickBooks cleanup take?

It depends far more on transaction volume and account count than on how many months are missing. A single low-activity checking account for a year can be done in a few focused sessions. A business with several cards, payroll, a merchant processor, and inventory can take weeks. The slowest part is almost always data entry and sourcing, which is why converting statements instead of typing them changes the timeline most.

How much does a QuickBooks cleanup cost?

Cleanup work is normally quoted per month of backlog, with the rate set by transaction volume, the number of accounts, whether payroll and inventory are involved, and how much source documentation survives. Nobody can quote it accurately without seeing the file and a statement or two, so treat any fixed price offered before that as an estimate. Ask what happens to the price if the backlog turns out worse than it looked.

What order should I clean up QuickBooks in?

Scope the gap, lock closed periods with a closing date password, fix the chart of accounts, set opening balances, then import history oldest first. Categorize with bank rules, reconcile each month before starting the next, clear Undeposited Funds and Opening Balance Equity, review AR and AP aging, and finish with a trial balance. The order matters because every step assumes the one before it is done.

Do I need to reconcile every month during a cleanup?

Yes, and it is the step people skip that costs them the most. Reconciling month by month confines any error to a single statement period, where a difference is usually one transaction and takes minutes to find. Import a whole year and reconcile only at the end, and the same difference is buried in thousands of lines with no way to narrow it down except by working backwards month by month anyway.

Can I fix prior year transactions during a catch-up?

Only carefully. If the year's tax return is already filed, editing the transactions behind it changes the numbers the return was based on. The usual approach is to leave the filed period alone and post an adjusting entry in the current period, agreed with the tax preparer, so the books and the return can still be reconciled to each other. Set a closing date password so nobody edits across the line by accident.

Will importing old statements create duplicates?

It can, if the period you import overlaps transactions already in the file, usually from a bank feed that pulled 90 days when the account was connected. Avoid it by deciding a cutoff date first: import statement files up to the day before the feed's coverage starts and let the feed own everything after. QuickBooks flags likely duplicates on import, but the reliable fix is not to create them.

Rebuild the missing months without retyping them

Convert your back-period PDF statements to QBO files and import the years the bank feed will not give you.

Convert a statement View pricing