Accounts Receivable & DSO Tracker

Know who owes you, how overdue, and your true DSO.One flat invoice register that captures both the receivable and the collection activity — promise-to-pay, last contact, disputes, notes — so you can pivot DSO and aging any way you need. A single as-of date re-ages the whole book.• Aging summary by customer that reconciles to the register• DSO, Best-Possible DSO, Average Days Delinquent, and Collection Effectiveness Index• Auto-built collections worklist that flags escalation and 90+ exposure• Pivot-ready: slice by customer, segment, or collector• One as-of date controls all aging — deterministic and cleanDone-For-You Setup & CustomizationHand off the setup. I’ll fit the right template to your real chart of accounts, accounting export, lease portfolio, or ownership structure, then walk you through it so you own it going forward. Scoped per engagement.Typical range $500–2,000 depending on scope. Invoiced directly — not sold through the storefront. Start with a short scoping call. For use within your own business or for your own work. Not for resale, redistribution, or use across multiple unrelated clients.For accounting, bookkeeping, or advisory firms. Permits use across your client engagements. Not for resale or redistribution of the template itself.Tax tables and accounting conventions change. Your purchase includes the current version; an optional annual update keeps brackets, MACRS tables, and standards current each year.Built by a practicing financial analyst. 100% Microsoft Excel — no add-ins, no subscriptions, works offline. Color-coded inputs, formula-driven throughout, with a built-in Read Me. Instant download. For planning and analysis; reconcile to your records and consult a qualified professional before relying on the figures.

Found on Devadex — the discovery index for independent software the big search engines bury. More from gumroad.

Report this listing