Bank statement conversion
Prepare bank statements for an accountant
Give your accountant clean rows, clear date ranges and the original statements as evidence.
What this page helps with
Keep each account and statement period separate while you review the data, with file names that show account and date range.
Compare the first and last rows with the PDF, check totals where possible and make sure every statement page was included.
Send only the files needed through the secure channel your accountant recommends.
What the Excel output should contain
- Transaction dates from the PDF statement.
- Descriptions for merchants, payees, transfers, fees or deposits.
- Amounts with debit and credit signs ready for review.
- Balances when the original statement has a balance column.
Common questions
Should I send the PDF or the spreadsheet?
Usually both: the PDF is the source document and the spreadsheet is the working file.