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.
- 1Google SheetsRead rowsReads the tab first, to check its headings and to skip lines this account already has from an earlier run.
If
tabRows.rowsis empty- 2Google SheetsAppend rowAppends one row per new transaction line as plain text, plus an 'INCOMPLETE' row if any line was not written.
- 2
- 3ExtendExtract dataReads every posted transaction line off the statement PDF, copying the date, description and amount exactly as printed, and whether it was money in or out.
For each
line- 4Google SheetsAppend row
- 4
If
linesDroppedis more than 0- 5Google SheetsAppend row
- 5
How it works
What happens on each run, in plain English.
Upload 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. When the statement prints money in and money out in separate columns, an In/Out column says which one each amount came from.
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. Running the same statement again never writes a line twice: lines already on the tab for that account are skipped. If any line is skipped, fails to write or falls past the row limit, a clearly marked 'INCOMPLETE' row is added with the counts, so a partial run never looks like a complete one.
You need an Extend connection (it reads the PDF) and a Google Sheets connection, the statement PDF, the link to your spreadsheet, the name of the tab, and a label for the account.
You may also be interested in
Never miss a filing or renewal deadlineChecks your deadline sheet each morning and emails you as each licence, permit, tax filing or renewal comes due, with a calendar event.
Email last month's profit and loss for each departmentOn the 3rd of each month, emails you last month's profit and loss for each department, or for the whole business, with AI commentary.Identify who was paid on every bank feed lineResearches each new line on a client's bank feed sheet and writes who was paid, what they do and where to post it, with sources.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.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.
Free plan, no credit card