Every day, n8n pulls unsettled transactions from Xero and checks each one against your open invoices. Any transaction that doesn't match an invoice triggers a Slack message to your bookkeeper with the amount, date, and merchant name. Your team catches gaps in real time instead of finding them at month-end.
Set n8n on a daily schedule trigger at 6 AM to pull new bank transactions from Xero via the Bank Transactions endpoint.
For each transaction, query Xero's Invoices endpoint to check for a matching amount and contact.
Filter for transactions with no invoice match and format a summary message listing each unmatched item.
Post the summary to your Slack #bookkeeping channel, tagging the responsible team member.
Create a free account to get the steps written out for your tools, click by click.
Create a free accountCatch unmatched transactions the same day they happen and close your books faster at month-end.
Grab a 15-minute chat. We don't sell software, so we have no stake in which one you use.