PDF to QBO Conversion of a Full Year of Client Statements
Convert a PDF bank statement to a QuickBooks file
Drop in a PDF statement and get a QBO (Web Connect) or IIF file you can import into QuickBooks Online or Desktop.
PDF to QBO conversion of a full year works best as twelve separate conversions done in date order, each one tied to its statement's closing balance, and then a single chain check: every month must open exactly where the previous month closed. Done that way, a year of a client's checking account goes from twelve PDFs to a reconciled QuickBooks register in well under an hour, and the totals you carry onto the return trace back to the bank's own figures.
This is the situation most tax preparers and catch-up bookkeepers meet every February. A client keeps no books, downloads a year of statements from the bank portal, and emails them over. Below is the method we recommend, with a worked example from a real-sized small business account, the mistakes that cost the most time, and what a converter has to do for this job. If you just want to start, the converter on our PDF to QBO home page takes the first statement now.
Why a full year should be converted month by month
It is tempting to merge twelve PDFs into one file and convert it in one go. Resist that. Each monthly statement carries its own opening and closing balance, and those printed balances are the only independent check you have that nothing was dropped. Convert one month at a time and every file gets its own proof. Merge them and you lose eleven checkpoints, so a single misread row anywhere in the year shows up as one unexplained difference at the end.
Month by month also matches how QuickBooks reconciles. You reconcile a bank account statement by statement, so importing the year in the same shape means each reconciliation has exactly the transactions it should. The batch PDF to QBO converter page covers how to move through a stack of files quickly without merging them.
A worked example with one client's year
Here is a single business checking account for calendar 2025, the kind of account a small contractor or service business runs. The figures are an example, but the size is typical: around 35 to 45 transactions a month and roughly $15,000 moving in each direction.
| Month | Opening balance | Deposits | Withdrawals | Closing balance |
|---|---|---|---|---|
| January | $8,412.37 | $14,210.00 | $13,108.42 | $9,513.95 |
| February | $9,513.95 | $12,880.50 | $14,022.18 | $8,372.27 |
| March | $8,372.27 | $15,930.25 | $14,771.60 | $9,530.92 |
| April | $9,530.92 | $16,402.10 | $15,240.95 | $10,692.07 |
| May | $10,692.07 | $13,775.00 | $14,390.11 | $10,076.96 |
| June | $10,076.96 | $14,990.40 | $13,305.27 | $11,762.09 |
| July | $11,762.09 | $12,150.75 | $13,980.04 | $9,932.80 |
| August | $9,932.80 | $13,320.00 | $12,744.50 | $10,508.30 |
| September | $10,508.30 | $15,015.60 | $14,402.33 | $11,121.57 |
| October | $11,121.57 | $16,880.20 | $15,999.80 | $12,001.97 |
| November | $12,001.97 | $14,402.90 | $15,210.66 | $11,194.21 |
| December | $11,194.21 | $18,930.15 | $17,345.09 | $12,779.27 |
| Year | $8,412.37 | $178,887.85 | $174,520.95 | $12,779.27 |
Two arithmetic facts must hold, and you can check both in a minute. Down the table, each opening balance equals the line above's closing balance. Across the year, $8,412.37 plus $178,887.85 minus $174,520.95 equals $12,779.27. If both hold after conversion, the year is complete. If either fails, you know which month to open.
What a failed month looks like
Suppose July converts with a closing total of $10,345.30 against the printed $9,932.80. The difference is $412.50, and a difference that is a single clean amount almost always means one withdrawal was missed. In practice it is usually a payment whose description wrapped onto a second line, which a weak parser reads as a text-only row and drops. You search the PDF for $412.50, find the row, fix it in the review table, and the month ties out. Without the per-month check, that $412.50 would sit inside the year's withdrawals and surface weeks later as an expense the client cannot explain.
Deposits are not the same as income
The year shows $178,887.85 of deposits. In our example $6,000 of that was the owner moving money in from personal savings and $4,500 was a draw on a line of credit in June. Neither is revenue. Once the transactions are in QuickBooks you categorize those two as owner contribution and loan, which leaves $168,387.85 as the starting point for gross receipts. Doing this from a ledger, rather than circling credits on twelve PDFs, is the main reason preparers convert at all. Our page on the PDF to QBO converter for tax preparers shows what that costs across a whole practice in season.
Step by step for twelve statements
- Sort and count the PDFs. Name them by month and look for a gap. A missing statement is a question for the client today, not a surprise during reconciliation.
- Write down the printed balances. Opening and closing for each month, straight from the statement summary box. This is your control list.
- Convert January first. Read the rows, then compare the converted closing figure with the printed one. Fix any difference before you download the .qbo.
- Repeat in date order. Each month's converted opening must equal the closing you just tied out.
- Set the opening balance in QuickBooks once. Use the January opening balance as of December 31. Getting this wrong is the most common reason a clean import still will not reconcile. Our guide to fixing a wrong opening balance after a QBO import covers the repair.
- Import month by month and reconcile as you go. Upload each .qbo, accept the transactions, then reconcile that statement before importing the next.
- Build bank rules after February. By the second month the repeating payees are obvious, so rules categorize most of March to December automatically.
The year boundary trap
Statements rarely follow calendar months. A cycle that runs December 17 to January 16 holds transactions for two tax years. Make sure the converter reads each row's year from the statement period rather than assuming the year printed on the cover, and check the first and last rows of any statement that crosses January 1. A December 29 payment stamped as the following year moves an expense out of the return you are preparing. The same applies at the other end of the year: the January statement of the next year often contains the last days of December.
Overlapping imports are the second trap. If the client also connected a bank feed partway through the year, QuickBooks may already hold some of those months. Import only the months the feed does not cover, and use the review screen to exclude any duplicate that slips through. We cover the clean-up in deleting duplicate transactions in QuickBooks Online.
What a converter must do for a full year
| Requirement | Why it matters for a year |
|---|---|
| Closing balance check per file | Twelve independent proofs instead of one total at the end |
| Editable review table | A dropped or misread row is fixed before it becomes a transaction |
| Correct year on boundary rows | Keeps December and January in the right tax year |
| Pricing per statement | A year is exactly twelve documents per account, easy to budget |
| QBO and IIF output | Clients on older Desktop files still get an importable file |
| Scan support | Some clients print and scan older statements |
On our plans a document is one statement PDF, so one account for a year is twelve documents. Starter includes 50 a month and Plus 200, with current prices on the pricing page. If you are weighing other tools, the PDF to QBO converter buying checklist gives nine tests to run on a real statement before paying.
How long a full year actually takes
Keying the example account by hand means about 480 lines at roughly 20 seconds each, close to two and a half hours before any correction. Converting the same twelve PDFs takes a couple of minutes each, most of it spent reading the rows, so the year is typically done in 30 to 40 minutes including the chain check and imports. For a preparer with thirty such clients the gap is roughly 80 hours of entry against about 20 hours of review.
Keep the PDFs with the client file after the return is filed. The IRS explains in how long you should keep records that supporting documents generally stay until the period of limitations runs out. Firms that store years of client statements across shared drives and email often add an internal search tool such as InSearch so staff can pull up last year's PDFs in seconds when a question comes back.
Frequently asked questions
Can I convert a year of bank statements to QuickBooks at once?
You can convert all twelve in one sitting, but convert and import each month as its own file. Each statement's closing balance then proves that month is complete, and QuickBooks reconciles statement by statement, so separate files keep both checks clean.
How do I know the converted year is complete?
Check two things. Each month's opening balance must equal the previous month's closing balance, and the first opening plus all deposits minus all withdrawals must equal the last closing balance. If both hold, no transaction is missing or doubled.
How far back can I import transactions into QuickBooks?
A .qbo file can carry transactions from any past date, so you can load a full prior year from PDF statements even when the bank feed only reaches back about 90 days. Set the account's opening balance as of the day before your first statement.
How much does it cost to convert a year of statements?
On a per-document plan, one account for a year is twelve documents. Our Starter plan includes 50 documents a month and Plus 200, so a single client's year fits easily in Starter and a busy tax practice fits Plus for the peak months.
Skip the manual entry
Upload a PDF bank statement and get a QBO or IIF file ready to import into QuickBooks.
Convert a Statement