Debtor Days Calculator (free Excel template)

How long do your customers really take to pay you, and how much cash is tied up waiting? This free calculator tells you in two minutes.

What it does

• Works out your debtor days from three numbers in your accounts
• Shows how much cash you would release by getting paid faster
• Monthly tracker with a trend chart
• A short action plan to get paid faster

What you get

An Excel file (.xlsx) that also works in Google Sheets, with a Start Here tab, example figures for a made-up company, and yellow cells to fill in. Formulas are done for you.

Want the full set? The Cash Control Kit adds a 13-week cash flow forecast, invoice chasing emails, an aged debtors tracker and a stage payment planner.

Designed by Basir Consulting with AI assistance, and checked by hand. A planning tool, not financial, tax or legal advice. Licensed for use in one business.