O2C Collections Excel Toolkit

What you get, exactly: One Excel file with 5 sheets — Cover, Ageing Report with 10 dummy invoices and Days Overdue and 0–30, 31–60, 61–90, 90+ bucket formulas with bucket totals, Cash-Application Tracker with 10 dummy receipts and Unapplied = Received minus Applied formula, Dunning Letters for Day 7 (friendly), Day 30 (firm), and Day 60 (final / hold) with name, date, and amount placeholders, and a Credit-Limit Calculator with formula-driven suggested limits and worked examples — plus a separate 2-page instruction PDF with a 15-minute weekly routine. All example data is dummy; you replace it with your own invoices. Format: XLSX + PDF, one-time purchase, download after prepaid payment, limit 3 in 30 days, no COD. What you do NOT get: this is not accounting or credit advice for a specific customer, not customised to your company, and not an SAP implementation. It is a template only.