Merge a year of bank statements into one spreadsheet
Year-end, tax time, a loan application: you need every transaction in one place. Drop all the PDFs at once and Sheetlark produces one sorted list, checks that each statement starts where the previous one ended, and warns you if a month is missing.
Step by step
- Drop all the statements for the account at once (any order).
- Sheetlark sorts them by date and checks the hand-over between each pair.
- Duplicates from overlapping statements are removed and listed for you.
- Download one combined Excel file with a summary sheet, or a single CSV.
Missing statements are caught
If one statement’s closing balance does not equal the next statement’s opening balance, a statement is probably missing. Sheetlark shows exactly which dates and how much money is unaccounted for.
Questions
Can I mix different accounts?
Yes. Statements are grouped by account number automatically and each account gets its own continuity check.
More guides
Convert a PDF bank statement to Excel
Turn a PDF bank statement into a clean Excel spreadsheet in seconds, with real dates and numbers, every row checked against your statement’s balances, and your file never leaves your device.
Convert a PDF bank statement to CSV
Convert PDF bank statements to CSV with your choice of date format, separator and amount columns. Verified against the statement balance. Runs in your browser.
Get PDF bank statements into QuickBooks
Convert PDF bank and credit card statements into QuickBooks Online CSV or QuickBooks Desktop QBO (Web Connect) files, verified against the statement balance.