Turn a bank statement into transaction rows
Reads every transaction line off a bank statement PDF and adds one row per line to your spreadsheet, exactly as printed.
Apps it connects
Authenticate each one once and the workflow is ready to run.
What it does
Each integration step this workflow runs, in order, what it is for, and the conditions and loops that decide when it runs.
- 1ExtendExtract dataReads every posted transaction line off the statement PDF, copying the date, description and amount exactly as printed.
For each
line- 2Google SheetsAppend rowAppends one row per transaction line with account, date, description, amount and note, plus an 'INCOMPLETE' row if any line was dropped.
- 2
If
linesDroppedis more than 0- 3Google SheetsAppend row
- 3
How it works
What happens on each run, in plain English.
Give it one bank statement PDF, run it, and every posted transaction line becomes a row on your spreadsheet under the account label you choose. The date, description and amount are copied exactly as printed, currency symbols, minus signs and brackets included, and saved as plain text so nothing becomes a formula or another date format.
Rows are only ever appended, never edited, and nothing is calculated: balances and subtotals are left out. Where part of a line was not printed, the cell is left blank and the notes column says so, and a line that cannot be split into date, description and amount is not written at all. If any line is skipped, fails to write or falls past the row limit, a clearly marked 'INCOMPLETE' row is added at the end with the counts, so a partial run never looks like a complete one.
Before the first run, your tab needs the headings 'Recorded on', 'Account', 'Date', 'Description', 'Amount' and 'Notes', in that order.
You May Also Be Interested In
Monthly P&L report for each cost centerOn the 3rd of each month, turns last month's transactions in your sheet into a P&L for each cost center, with AI commentary.Check a bank feed sheetResearches every unchecked line on a bank feed spreadsheet and writes who each was paid to, with sources, on a research tab.Weekly revenue up-or-down emailEvery Monday, totals last week's revenue from your sheet, says if it is up or down on the week before, and explains a rise.
File emailed documents and log what they sayFiles every document that arrives by email into Box and records what it says as a row on your register.
Start from a workflow that already works.
Add "Turn a bank statement into transaction rows" to your workspace, connect its apps, and make it yours. No credit card required.
Free plan available · No credit card required