Reconcile Your Bank Feed Weekly
Every Monday, WebRun uses Plaid to pull the prior week's bank transactions, opens Xero to match them against posted entries, logs any unmatched items to a reconciliation sheet, and flags gaps for you to resolve before the week is out.
How can I automatically reconcile my bank feed in Xero every week?
Every Monday, WebRun uses Plaid to pull the prior week's bank transactions, opens Xero to match them against posted entries, logs any unmatched items to a Google Sheets reconciliation sheet, and flags gaps for you to resolve - so your books are never weeks behind.
- Bank feed reconciled weekly - no more months of catch-up
- Unmatched items flagged before they compound
- Reconciliation report ready in Google Sheets every Monday
Built for bookkeepers · accountants · small business owners · finance operations teams
What does WebRun do on every run?
The exact actions WebRun takes, in order - in plain language, so you can adjust anything.
-
WebRun signs in and gets to work
Opens
go.xero.comin a real browser with your saved login - no setup, no API keys. -
1
Plaid - pull bank transactions
plaid.com
WebRun opens Plaid to pull bank transactions. - Connect to Plaid and retrieve all transactions for the prior week from linked bank accounts
- Export the list with date, payee, and amount for each transaction
Done when All bank transactions for the prior week are captured.
-
2
Xero - match to ledger entries
xero.com
WebRun opens Xero to match to ledger entries. - Open Xero Bank Reconciliation for the same date range
- Match each bank transaction against the corresponding Xero entry by date, amount, and payee
- Identify transactions in the bank feed with no matching Xero entry and vice versa
Done when All transactions are matched or flagged as unmatched exceptions.
-
3
Google Sheets - log unmatched items for review
google.com
WebRun opens Google Sheets to log unmatched items for review. - Open the Bank Reconciliation sheet
- Log every unmatched item: date, amount, source (bank or Xero), and a suggested action
- Record the total matched and the total unmatched for the week
Done when The reconciliation sheet shows matched count, unmatched exceptions, and suggested actions.
How is each run configured?
Secure by default
Connect once, stays signed in
WebRun signs in once and keeps each session in a persistent environment, so every run picks up right where it left off.
Every action is checked against this policy before it runs.
Questions, answered
Will it make any changes in Xero?
No - it reads and compares only. All reconciliation decisions and journal entries remain yours to make in Xero.
What if I have multiple bank accounts?
Tell WebRun which accounts to reconcile and it will run through each one in turn, producing a separate exception list per account.
How long does the run take?
For a typical SMB with a few hundred weekly transactions, the run completes in a few minutes. You get the report before you start your Monday.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.