← All guides

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.

Open the converter, free

Step by step

  1. Drop all the statements for the account at once (any order).
  2. Sheetlark sorts them by date and checks the hand-over between each pair.
  3. Duplicates from overlapping statements are removed and listed for you.
  4. 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.

Your files stay with you. Statements are converted on your own device and never sent to us. How it works.