Xero Sales Invoice Follow-Up Calendar and Cash Forecast Notes
Plan collection and a short-term cash view.
The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.
[VERIFY] is an editorial flag, not a blank to fill. Wherever the prompt shows [VERIFY], check that item against a reliable source before you use it.
Plan collections and a short cash view for the next 8 weeks using Xero data, as an educational planning aid, not financial advice. Outstanding invoices with customer, amount and due date: [OUTSTANDING_INVOICES]. Bills due: [BILLS_DUE]. Payroll and fixed costs: [FIXED_COSTS]. Current bank balance: [BANK_BALANCE]. Safety level: [SAFETY_LEVEL]. A forecast is a set of assumptions; list each (collection rates, supplier terms, payroll dates, and tax payments, which are easy to forget). Week-by-week table of expected receipts, payments and closing balance, with a best and a worst case. Worked first two weeks: opening balance 12,000, expected receipts 7,000 at 70 percent on time is 4,900, payments 9,500 leave 7,400; next week receipts of 2,100 from late payers and payments of 3,000 leave 6,500. Highlight weeks below the safety level and suggest actions: call the five largest debtors, ask for deposits on new work, renegotiate a supplier date, chase earlier. Write three collection messages of increasing firmness. Weekly update every Monday: update expected receipts with actual payments, move promised invoices, add new ones, and compare last week's forecast with actuals (forecast closing balance 7,400, actual 6,900, error 500), averaging the error over four weeks. Give a one-line owner summary (lowest balance in the next eight weeks and the week it occurs). Local tax or legal rules could change answers [VERIFY].
Fill in before use
Optional: type your details and the prompt above updates. Nothing is saved or sent.
Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.