Weekly reminder to clear uncategorized transactions (Make)

Count unreconciled Xero bank transactions and post the number every Friday, so month-end doesn't pile up.

MakeBank reconciliationIntermediateHuman check: Low

Tools
Make: Xero, Slack

Time saved
~1-2 hrs/month (estimate)

Difficulty
Intermediate

Steps

Schedule the scenario for Fridays.
Xero 'Make an API Call' to GET /BankTransactions?where=IsReconciled==false.
Array aggregator or a length() function to count the results and sum the amounts.
Slack 'Create a Message': 'X items ($Y) are waiting to be reconciled.'

Keep a human check here: Low risk

You still code each transaction yourself. The scenario only counts what's waiting.

Node and module names match Make's docs as of Oct 2026. Apps rename triggers and actions sometimes, so check yours in the editor. Try it with test data or a sandbox company first.

Build it

[AFFILIATE LINK PLACEHOLDER: not live]
Try Make. We may earn a commission if you sign up, at no cost to you. Disclosure

Related recipes

Match a bank CSV against the ledger in a sheet (n8n)

Drop a bank CSV in a folder and get a sheet of matched and unmatched items.

n8nBank reconciliationAdvancedHuman check: High

Saves ~3-6 hrs/month

Get Slack alerts for large bank transactions (Zapier)

Get a message whenever a bank-feed transaction over a set amount shows up in QuickBooks.

ZapierBank reconciliationBeginnerHuman check: Low

Saves ~1 hr/month

Get AI-suggested GL codes for card transactions (n8n)

Paste card transactions into a sheet and get a suggested account and a confidence score for each one.

n8nBank reconciliationIntermediateHuman check: High

Saves ~2-4 hrs/month