Accounts receivable templatesAutomate a cash receipts forecast from Xero
Modern looks at every open invoice in Xero, how each customer has paid in the past and any promise to pay, and updates a 13-week cash receipts forecast in Google Sheets every week.
TriggerMondays at 7:00
Steps5 steps, from trigger to sign-off
ControlFinance lead approves each weekly update
Free to start. No card needed.
Mondays at 7:00The instruction
“Every Monday at 7:00, take every open invoice in Xero and estimate the week it will be paid, using the average days late for that customer over the last 12 months and any promise to pay on file. Update the receipts tab of our 13-week cash forecast in Google Sheets and highlight any week that moves by more than 10%. Ask the finance lead to approve before replacing the numbers from last week.”
Works with every major ERP
- +100 more
How it runs
5 steps from trigger to sign-off
- 01
Read open invoices
Pulls every open invoice in Xero with its due date, balance and customer.
Xero - 02
Learn payment habits
Works out how late each customer usually pays from 12 months of history.
Modern - 03
Estimate the week
Assigns each invoice to a week, using promises to pay where they exist.
Modern - 04
Approve the update
The finance lead reviews the changes from last week and approves them.
Slack - 05
Update the forecast
Writes receipts by week into your 13-week model and highlights big moves.
Google Sheets
Replaces cash flow forecasting software
Still paying for cash flow forecasting?
This template does the job of Float inside Modern. Run the stack audit to see what you could cancel across your whole finance stack.
Related templates
More AR automations
- Replaces Chaser
Weekdays at 9:00Accounts receivable
Chase overdue invoices on a cadence
Sends reminders at 1, 7 and 14 days overdue from your own inbox, reads replies and stops chasing as soon as the invoice is paid.
5 stepsUse template → - Daily at 8:00
Accounts receivable
Send reminders before invoices fall due
Emails a friendly heads-up three days before each QuickBooks invoice is due, with the invoice and a payment link attached.
5 stepsUse template → - Replaces ChaserWhen a customer replies to ar@
Accounts receivable
Log promises to pay from customer replies
Reads replies to your reminders, captures promise dates and disputes, and logs them against the right NetSuite invoice.
5 stepsUse template →
FAQs
Forecast cash receipts for the next 13 weeks: FAQs
Can’t find what you’re looking for? Send us a message and a person on the team will answer.
No. It updates the receipts side of the model you already have. You can add other automations for payables and payroll if you want them in the same sheet.
It is only as good as your payment history and promise data. Modern shows the basis for each estimate so you can adjust it, and you can compare forecast to actual each week.
Yes. Modern reads invoices from QuickBooks, NetSuite, Sage or Xero and can write to Excel or Google Sheets.