Finance · Invoices & payments
Bank-to-Invoice Reconciliation
Starts when: New bank transactions are available, or a reconciliation run starts
Free plan · Outcome verification included · You approve every connection
How it runs
Six stages, from the moment it starts to the checks that keep running afterwards.
It starts
New bank transactions are available, or a reconciliation run starts
Awish plans it and asks for each app
The apps it needs are connected one at a time, with your permission, before anything runs.
It does the work
Exactly as the request below describes, across the connected apps.
It stops where a person should decide
Never force fuzzy matches above the configured monetary tolerance; keep an auditable unmatched queue.
It verifies the outcome
After each run, Awish checks that every entry reached the books and matches its source.
It keeps monitoring
Failures, silent failures and connection health are watched on every plan; anomalies, root cause and recommendations on Business.
The request it runs
This is what opens in chat when you use the template. Change any part of it before anything connects.
“Create an automation for bank-to-invoice payment reconciliation. Trigger it when new bank transactions are available or a reconciliation job runs. It should match deposits to open invoices using reference, amount, customer and dates, classify them as exact, partial, over, unpaid or unmatched, post the safe matches, produce the reconciliation report and alert on exceptions. Connect it with Stripe, QuickBooks, Google Sheets and Slack. Never force fuzzy matches above the configured monetary tolerance; keep an auditable unmatched queue.”
- Stripe
- QuickBooks
- Google Sheets
- Slack
Monitoring included
What Awish watches once this template is running.
- Outcome verificationEvery plan
- Silent-failure detectionEvery plan
- Connection healthEvery plan
- Hours saved and ROIEvery plan
- Anomaly detectionOn Business
- Root-cause explanationOn Business
- Recovery recommendationOn Business
More Finance templates
Receivables Reminders and Collections
- QuickBooks
- Gmail
- HubSpot
- Slack
Budget vs Actual Variance Digest
- NetSuite
- Google Sheets
- Slack
- Metabase
Cash Flow and Runway Monitoring
- QuickBooks
- Stripe
- Google Sheets
- Slack
Expense Capture and Policy Check
- Expensify
- Gmail
- Slack
- Google Drive
Questions about this template
Can I change where it stops for approval?
Yes. Open the template in chat and say where you want it to stop. The plan updates before anything connects.
What if one of these apps is not connected yet?
Awish asks you to connect each app it needs, one at a time, before the workflow runs. You can decline any of them.
How does Awish know this workflow worked?
After each run it checks that every entry reached the books and matches its source, in the app where that should happen. If a run reports success but the result is missing, it flags a silent failure.
Run it on your own apps
It opens in chat with the request written. See the plan, approve each connection, and Awish verifies the outcome from the first run.
Free plan · No credit card required