Bookkeeping transaction log — free Excel template
A free bookkeeping log for bank transactions: date, description, amount, direction, running balance and category, one row per transaction. Download it for manual entry, or upload your bank statements and export every transaction into this exact layout.
What’s inside the bookkeeping transaction log
The template is a single ready-to-use sheet with a frozen header row and one column per field. Its columns are:
- Date
- Description
- Amount
- Direction
- Running balance
- Category
- Account
How to use this template
Two ways. Fill it in by hand as a plain spreadsheet — or, to skip the typing, upload your bank statements to ParseForMe, pick this template as your export format, and the parsed data lands in these columns automatically. Map the fields once and every future document reuses the layout.
Who it’s for
Bookkeepers and small-business owners keeping a clean ledger, especially where the bank only offers PDF statements and there is no live accounting feed.
Frequently asked questions
Is the Bookkeeping transaction log template free?
Yes — download the .xlsx and use it however you like. No signup is required just to download the template.
How do I fill it in automatically?
Upload your bank statements to ParseForMe, then choose this template as your export format. Your parsed data lands in these exact columns — no manual typing.
Can I change the columns?
Yes. Edit the spreadsheet freely. If you re-upload your edited version as your export template, ParseForMe maps the parsed fields to your columns.
Try it on your own document
Drop a document to see the structured data come back.