DEV Community

lucky
lucky

Posted on

Show BankStatementSheets: turn monthly bank statement PDFs into clean Excel sheets

Every month it's the same routine for anyone who invoices or reconciles: statements arrive as PDFs, and the numbers need to be in a spreadsheet before you can sort, filter, or pivot them. Copy-pasting out of a PDF viewer mangles the columns, and retyping a few hundred rows by hand is where errors creep in.

I've been running BankStatementSheets as part of a monthly close checklist:

  • drop each statement file in
  • get an Excel or CSV back with one row per transaction
  • dates land as real dates, amounts stay numeric, balances get their own column
  • paste into a master sheet and let pivot tables finish the job

Nothing fancy — it just removes the most error-prone step of the monthly tidy-up. Handy for freelancers reconciling invoices, small teams closing the books, or a year-end cleanup across several accounts.

If you want to try the workflow, the tool lives at bankstatementsheets.com.

Would love feedback from anyone doing heavier reconciliation — what does your monthly statement workflow look like?

Top comments (0)