For your accountant with Statement to Spreadsheet
This page opens with a statement that has Debit and Credit columns, and Excel (.xlsx) as the download. That is the layout accountants and bookkeepers prefer: typed date and amount cells, money out and money in in their own columns, and a balance check so errors show before the file is sent.
- Drop the statement PDF on the tool. It is read in your browser and never uploaded.
- Check the preview against the statement, especially any amber rows, and the balance check line.
- Press Download Excel. For several months at once, add the other statements first (Pro) and they are merged into one sheet.
- Send the workbook. Pro can also add a Category column and a Totals sheet by month.
What to know
An accountant wants a file that can be sorted, filtered and totalled without clean-up. The workbook has a real date column, numbers with two decimals, a Debit column and a Credit column, a signed Amount column and the running Balance, in that order. Nothing in it is a text value pretending to be a number, so a pivot table or a SUMIFS works the first time.
A file from a converter is only as good as its checking. The tool adds each amount to the previous balance and compares it with the printed balance; rows where the arithmetic fails are marked, which is how a missed or misread transaction is found before the workbook leaves your hands. Rows it could not read are listed and excluded, not left out unseen.
With Pro you can add several statements, for example twelve months, and they are merged into one sheet sorted by date with a Source column naming the file each row came from. A Totals sheet adds money in, money out and net by month, and a Category column suggests a category from keywords in each description that you can edit before exporting.
Updated · Cosmovex
Questions
What does the accountant receive?
An Excel workbook with a Transactions sheet: Date, Description, Debit, Credit, Amount and Balance, plus any extra columns the statement had. Pro can add a Totals sheet and a Category column.
Can I combine several months into one file?
Yes, with Pro. Add each statement and they are merged into one sheet sorted by date, with a Source column for the file each row came from.
How do I know the numbers are right?
If the statement has a Balance column, the tool checks that every amount plus the previous balance equals the printed balance and marks rows that do not. Compare the totals with the statement as a final check.
Are the categories reliable?
They are suggestions from keywords in the description, such as groceries or fuel, and anything without a keyword is marked Uncategorised. Edit them in the preview before you download.
Is the statement uploaded?
No. The PDF is read and the workbook is built in your browser. Nothing from the statement is sent to our servers, which matters for client files.
The free plan covers everything on this page. Statement to Spreadsheet Pro ($9/mo, billed monthly) is described on the Statement to Spreadsheet page.