Home › Finance manager toolkit › AR/AP Aging & 13-Week Cash Forecast (Excel)
AR/AP Aging & 13-Week Cash Forecast (Excel)
Every open invoice, aged by customer and supplier, rolled into a 13-week cash forecast that shows the week you run short.
Paste your open receivables and payables (up to 1,000 invoices). The workbook ages them (current, 1–30, 31–60, 61–90, 90+) by customer and by supplier, then builds a 13-week cash forecast from the due dates: expected collections at your collection rate, overdue recovery over four weeks, supplier payments, fixed weekly outflows, one-offs — and flags the first week you fall below your minimum cash.
Sheets: Settings · Cash Forecast · Invoices · AR Aging · AP Aging. Sample data included. Formulas only, no macros.