Someone has asked for "all of last year's transactions in one spreadsheet". Maybe it's your CPA in tax season, a bookkeeper catching up your books, or a lender reviewing an application. You have twelve monthly PDFs per account and a deadline. This guide shows the quick way, the free way in Excel, and the checks that make sure nothing is missing or counted twice.
The fastest way: upload all 12 PDFs at once
- Download every PDF statement. Download the original PDF statement for every account and every month of the period from online banking, and name them consistently, for example Checking-0000_2026-01.pdf.
- Upload them in one batch. Drop up to 24 text-based PDFs, 20 MB each, into the converter at once. That's 12 months for two accounts, or 24 months for one.
- Check each statement's balance result. Each statement is compared with its opening and closing balances where it shows them. Look at any statement marked as not reconciling or not verified before you use the file.
- Download one merged file. Download one Excel or CSV file with every transaction sorted by date, plus Account and Source file columns. The Excel file also has a Files sheet with one row per statement.
Here's what the converter does with a batch:
- Up to 24 PDFs at once, 20 MB each.
- A balance check per statement: each one is compared with its opening and closing balances where the statement shows them, and you get a warning if it doesn't add up. A PDF that covers several accounts gets a check for each account.
- One merged spreadsheet: Excel or CSV with every transaction sorted by date, plus Account and Source file columns, so each row traces back to its PDF. There's also a merged Xero CSV, with the account and source file in the Reference column.
- QuickBooks: it downloads a .qbo (Web Connect) file for each account. Statements are combined into one file only when they show the same printed account number, so different accounts aren't combined. There's also a CSV you can upload to QuickBooks Online's bank upload.
- Rule-based extraction, no AI: the text in your PDF is read with fixed rules, not sent to an AI model.
- Text-based PDFs only: scanned or photographed statements aren't supported.
A few rows of the merged spreadsheet, with made-up transactions:
| Date | Description | Amount | Balance | Account | Source file |
|---|---|---|---|---|---|
| 2026-01-03 | Deposit Example Client | 1,250.00 | 6,410.55 | Account ending 0000 | Checking-0000_2026-01.pdf |
| 2026-01-04 | Card purchase Example Office Supply | -84.20 | 6,326.35 | Account ending 0000 | Checking-0000_2026-01.pdf |
| 2026-01-05 | Transfer to savings | -500.00 | 5,826.35 | Account ending 0000 | Checking-0000_2026-01.pdf |
| 2026-01-05 | Transfer from checking | 500.00 | 2,500.00 | Account ending 1111 | Savings-1111_2026-01.pdf |
Money out is negative and money in is positive. The Account column comes from the account number printed on the statement, shown by its last four digits; if a statement doesn't print one, the cell is left blank and the Source file column still tells you where the row came from. A combined checking-and-savings PDF gets one label per account and a balance check for each.
The Excel file also has a Files sheet with one row per statement. Its columns are Source file, Pages, Type, Opening, Closing, Transactions and Balance check. A made-up example:
| Source file | Pages | Type | Opening | Closing | Transactions | Balance check |
|---|---|---|---|---|---|---|
| Checking-0000_2026-01.pdf | 4 | bank | 4210.55 | 5065.35 | 38 | balanced |
| Checking-0000_2026-02.pdf | 4 | bank | 5065.35 | 4388.10 | 35 | balanced |
| Card-2222_2026-01.pdf | 3 | card | 812.40 | 1104.92 | 27 | not verified |
"Balanced" means the transactions add up from the opening to the closing balance. "Doesn't reconcile" means they don't, so review that statement. "Not verified" means no opening and closing balance was found to check against. A file that couldn't be converted is still listed, with the reason.
Working in Xero or QuickBooks Online instead of a spreadsheet? See PDF bank statement to Xero CSV and convert a PDF statement to QBO. A .qbo file holds one account, so upload each account's file into its own account. Intuit's help article "Manually upload transactions into QuickBooks Online" (updated August 24, 2026) says: "You can include up to 1,000 lines per upload. Each line contains one transaction." A busy account can pass that in a year, so upload a few months at a time if needed. We test our .qbo files by importing them into QuickBooks Online (October 2026).
Before you start: get every statement
Download the original statements from online banking, usually under Statements or Documents. Don't use printouts or phone photos: CleanStatement reads text-based PDFs, and scanned or photographed statements aren't supported.
Make a list of every account used during the period, including any opened or closed partway through the year. Those are the ones most often forgotten, and a closed account's online access may not last, so download its statements first.
Statement archives and transaction downloads are often separate features with different time limits. American Express's help page, for example, says: "Your previous two years of transactions can be viewed electronically allowing you to sort, filter and download as a PDF, Excel or CSV file." It adds that PDF statements, including archived ones, are listed separately. Check your own bank's help pages for its limits.
Name the files so they sort in order, for example Checking-0000_2026-01.pdf. The Source file column then tells you the account and month of every row at a glance. There are notes for specific banks in our bank guides: Chase, Bank of America, Wells Fargo, Citi, Capital One, American Express, U.S. Bank, PNC, Navy Federal, Truist.
Check nothing is missing: the balance chain
Each statement's opening balance should equal the previous statement's closing balance. If the chain is unbroken from the first month to the last, you have every statement. The Files sheet puts both numbers side by side, so sort it by Source file and read down. A made-up example:
| Statement | Opening | Closing | Chain |
|---|---|---|---|
| January (example) | $4,210.55 | $5,065.35 | Start |
| February (example) | $5,065.35 | $4,388.10 | ✓ Matches January's closing balance |
| March (example) | $4,512.77 | … | ✗ Gap: February closed at $4,388.10 |
There are two different kinds of error to look for:
- A break between months: a missing statement or a shifted statement cycle. The chain catches this.
- A mismatch inside a month: a missed or doubled row. The per-statement balance check catches this, where the statement shows its balances.
Statement cycles often don't match calendar months. For a calendar year, include the statement that covers the last days of December even if it closes in January, then filter the merged file by date when you need calendar totals.
Credit cards work the same way, using the previous balance and the new balance printed on each statement.
Duplicates, transfers and overlapping periods
Duplicates creep in when the same weeks arrive from two sources, for example a statement plus a transaction download from the bank, or when one month is converted twice. If you upload the exact same PDF twice in one batch, CleanStatement skips the second copy so its transactions aren't counted twice. Across separate batches, use the Source file column: a whole statement that appears twice is easy to spot when you filter by file name.
Don't blindly run Excel's Remove Duplicates on Date, Description and Amount. Two identical coffees on the same day are two real transactions, and removing one breaks the balance check you just passed.
Transfers between your own accounts appear once as money out of one account and once as money in to the other, like the savings transfer in the sample above. Both rows are correct, but leave them out of any income or spending total, or you'll count the same money twice.
Do it free in Excel with Power Query
If you already have one CSV or Excel file per month, Excel can stack them for free. Microsoft's support article "Import data from a folder with multiple files (Power Query)" covers it. Its advice is to put the files in a dedicated folder, and that "each file should have the same schema with consistent column headers, data types, and number of columns." Columns are matched by name, so their order doesn't matter.
- Put one file per month, all with identical headers, in one folder and nothing else.
- In Excel, select Data > Get Data > From File > From Folder, and pick the folder.
- Choose Combine > Combine and Transform Data. The Power Query Editor opens.
- Keep the Source.Name column, which holds each row's file name.
- Set the Date column to a date type and the amount and balance columns to numbers.
- Select Home > Close & Load.
Where it breaks: Power Query combines CSV and Excel files, not PDF statements, so the PDFs still need turning into per-month files first. Reading tables straight out of PDFs varies with each bank's layout, and if one month's columns are named differently, rows end up in the wrong place. It also doesn't check any month against its balances. If you'd rather skip that, the converter does the merge for you.
Sending it to your CPA or bookkeeper
Send both: the original PDFs as the record, and the merged spreadsheet as the working file. The Source file column lets them check any row against its statement, and the Files sheet shows which statements balanced. Use their client portal or secure file-sharing link rather than plain email if they have one, and keep your own copies, because CleanStatement deletes uploaded files within an hour.
For more on tax season, see what your CPA needs at tax time. If the books are months behind, see catching up months of bookkeeping, and if QuickBooks is missing older months, see why the QuickBooks bank feed stops at about 90 days.
Applying for a loan?
Lenders and brokers set their own document rules, so send exactly what they ask for. Usually that's the complete original statements with every page.
A combined spreadsheet still helps you. It puts each month's deposits in one place, shows a missing month before the lender finds it, and makes it quick to answer questions about specific deposits. It's a working copy for you, not a replacement for the statements. Ask your lender or broker what they need.
Need one PDF instead of a spreadsheet?
"Combine bank statements" sometimes means merging several PDFs into a single PDF, for example as supporting documents. Any PDF-merge tool will do that. CleanStatement doesn't merge PDFs; it turns them into a spreadsheet.
What it costs
Every page of every PDF counts. Free use is 3 pages a day across all files, no account needed. As an example only: 12 statements of 4 pages each is 48 pages, which fits in the 100-page pack at $9 one-time. Pack pages never expire. Converting every month? Pro is $15/month for 500 pages, and Business is $30/month for 2,000 pages. See pricing, or how our pricing compares.
A year of statements is usually more than the free pages. The 100-page pack is $9 one-time and never expires.
Frequently asked questions
How do I combine 12 months of bank statements into one spreadsheet?
Download all 12 PDF statements, convert them in one batch, and export a single Excel or CSV file sorted by date with a column for the account and one for the source statement. Then check that each statement's opening balance matches the previous closing balance.
Can I combine statements from different accounts?
Yes. Upload them together. The merged file is sorted by date and has an Account column, so you can filter back to one account. Transfers between your own accounts appear twice (once out, once in), so leave them out of any income or spending total.
How do I know no month is missing?
Line the statements up by date. Each statement's opening balance should equal the previous one's closing balance. A break means a missing statement or a gap in the period. A per-statement summary with opening and closing balances makes this a quick check.
Will the combined file have duplicates?
Only if the same transactions go in twice, for example a statement plus a bank download covering the same weeks. CleanStatement skips an identical PDF uploaded twice in the same batch. Use the Source file column to spot a statement that was converted twice in separate batches.
Can I do it free in Excel?
Yes, if you already have one CSV or Excel file per month with identical columns. Excel's Data > Get Data > From File > From Folder stacks them into one table and keeps the file name. The hard part is getting clean per-month files out of the PDFs first.
Does my CPA want the spreadsheet or the PDFs?
Ask. Many accountants want both: the original PDFs as the record and one spreadsheet as the working file. A spreadsheet doesn't replace the statements.
A lender asked for 12 months of statements. What do I send?
Send what the lender asks for, which is usually the complete original PDF statements, all pages. A combined spreadsheet is a working copy for you to check for gaps before sending. It isn't a substitute for the statements.
How much does it cost to convert a year?
It depends on page count. Every page of every PDF counts. As an example, 12 four-page statements is 48 pages: more than the 3 free pages a day, but inside the $9 one-time 100-page pack, whose pages never expire.
Is it safe to upload a year of statements?
Uploaded PDFs are deleted as soon as conversion finishes (or within 1 hour if held at the upgrade screen) and converted files within 1 hour. Extraction is rule-based with no AI, and there's no AI training on your data.
A year of statements, one spreadsheet
Drop in up to 24 statements and get one spreadsheet, sorted by date, with Account and Source file columns and a balance check on every statement. 3 free pages a day, no signup.
A year of statements is usually more than the free pages. The 100-page pack is $9 one-time and never expires.
Uploaded files are deleted within 1 hour. Also useful: PDF bank statement to Excel · to CSV · credit card statement to Excel · All guides
Sources
Microsoft, Intuit and American Express wording quoted from their help pages as checked October 22, 2026. Product details are from CleanStatement's own site. These pages change, so follow what you see on screen.
- Microsoft Support: Import data from a folder with multiple files (Power Query)
- Intuit: Manually upload transactions into QuickBooks Online (updated August 24, 2026)
- American Express: How do I access my transaction history and billing statements?
- CleanStatement: Pricing
QuickBooks is a trademark of Intuit Inc. CleanStatement is independent and not affiliated with Intuit, Microsoft or any bank. This page is general information, not tax, lending or financial advice.