A year of statements into a spreadsheet you can check.
Tax time, a loan application, or an accountant who asked for "everything from last year." Drop the statements in, see which ones add up, and download the file.
The statements are there. The rows are not.
The bank's website shows 90 days. The rest is in PDF statements, downloaded one at a time. The accountant wants a spreadsheet or a file they can import. Retyping a year of transactions introduces the errors the accountant was trying to avoid.
Two files and one check.
-
The spreadsheet
Every transaction from every statement in one XLSX, with the date, description, amount, balance, account, statement, and page. Sorted, with a sheet that lists each statement and whether it added up.
-
The import file
If your accountant uses QuickBooks Online or Xero, the file in the columns they need. It is checked against the software's own rules before download.
-
The check
Each statement is added up and compared with its own printed closing balance. A statement that adds up is marked. One that does not is flagged with the difference, so you know which page to look at before you send anything.
Four steps, from the bank's website to the file.
-
Download the statements from your bank
One PDF per month per account. Photos of paper statements work too; they read a little less well, and the check tells you where to look.
-
Drop them all in
The page count shows before anything runs, with what it will use.
-
Look at the flags
Most statements add up. For one that does not, the page points at the row most likely to be wrong. You can fix the number or re-read the page.
-
Download
The spreadsheet, or the file for the accountant.
Credits instead of a subscription.
Ten pages a month are free, which covers one or two statements. For a year, a pack of credits covers one business's checking and card statements and never expires. There is nothing to cancel.
Start with last month's statement.
Drop it in and see the check.