Automatic Billy Payment Reconciliation
When a payment lands, WebRun opens Billy, reads the new bank transaction, looks for an open invoice with the same customer and amount, records the match or the mismatch in Airtable, and posts your finance channel in Microsoft Teams a short note of what settled and what needs a human.
How do I match incoming bank payments to invoices in Billy?
WebRun reconciles your Billy bookkeeping as money arrives. Each time a payment lands it reads the bank line, finds the open invoice with the same customer and amount, logs the result in Airtable, and posts your Microsoft Teams finance channel any short payment or transaction that matches nothing.
- Settled invoices are identified the day the money arrives
- Short payments are spotted same day instead of at month end
- Unmatched deposits never sit unexplained in the bank feed
Built for small business owners · bookkeepers · Danish SMEs · finance 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
billy.dkin a real browser with your saved login - no setup, no API keys. -
1
Billy - match the payment to an invoice
billy.dk
WebRun opens Billy to match the payment to an invoice. - Open Billy and read the new bank transaction: date, amount, and payer text
- Search open invoices for the same customer and a matching amount
- Note a clean match, a short payment, an overpayment, or no candidate at all
- Prepare the reconciliation but leave the posting for a person to confirm
Done when The payment has a proposed invoice match or is marked as unmatched.
-
2
Airtable - log the match or the exception
airtable.com
WebRun opens Airtable to log the match or the exception. - Add a row per payment with the date, amount, customer, and the invoice it appears to settle
- Record the difference when the amount does not line up exactly
- Set the status to Matched, Short paid, Overpaid, or Unmatched
- Keep a running view of everything still unmatched
Done when Airtable holds a row for the payment with its match status.
-
3
Microsoft Teams - flag payments with no home
microsoft.com
WebRun opens Microsoft Teams to flag payments with no home. - Post the finance channel a short line: which invoice this payment settles and the remaining balance
- Call out short payments and payments that match nothing, with the amount and the payer text
- Skip the post entirely when the match is clean and the invoice is fully settled
Done when The finance channel knows about every payment that needs a decision.
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 post the reconciliation in my books by itself?
No. WebRun proposes the match and leaves it for you to confirm in Billy. The ledger only changes when a person approves it, so nothing is booked against the wrong invoice.
What happens when a payment matches nothing?
It is logged in Airtable as Unmatched with the amount and payer text, and posted to your Teams channel the same day, so an unexplained deposit is chased while the detail is fresh.
Does it contact the customer about a short payment?
No. Short payments are flagged internally with the shortfall amount. Any message to the customer is written and sent by you.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.