Check a bank feed sheet
Researches every unchecked line on a bank feed spreadsheet and writes who each was paid to, with sources, on a research tab.
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.
Try
- 1Google SheetsRead rowsReads the research tab to see which bank lines are already done, then the bank feed tab for the date, description and amount of each line.
If a step fails
- 2Google SheetsCreate tabCreates the 'Vendor research' tab with its sixteen headings on the first run, when the tab does not exist yet.
- 3Google SheetsAppend rowAppends one row per bank line to the research tab with what the verifier found, or a 'Could not research' row when it failed.
- 1
- 4Google SheetsRead rows
For each
line- 5Google SheetsAppend row
- 5
How it works
What happens on each run, in plain English.
Point it at the Google Sheet that holds a client's bank feed and run it. Every line that has not been looked into yet is handed to the vendor verifier, which searches the live web for the business or person behind it and reads the vendor's own page, and what it finds lands as one row on a 'Vendor research' tab: status, vendor, website, what they do, the likely reason, a suggested account, the independent check's verdict, the summary, the evidence, the sources and a question for the client.
The feed is never edited, finished lines are skipped on the next run, a failed line is recorded rather than retried forever, and each run is capped so the cost stays predictable. Fill in the client's name and notes once and import a fresh copy for each client. Import the verifier alongside it and choose it in the 'Run a workflow' step before the first run.
You May Also Be Interested In
Verify the vendor behind a bank or card lineThe engine behind the bank-line checks: finds who a feed line was paid to, what they do and what it was likely for, or says it could not.Check one bank linePaste one bank or card feed line and get back who was paid, what they do and what it was likely for, with sources.
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.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 "Check a bank feed sheet" to your workspace, connect its apps, and make it yours. No credit card required.
Free plan available · No credit card required