Start with the decision
The useful question is not “what is the perfect number?” but “what decision will this number improve?” This guide is for people who need to make a practical call, not win an argument with a spreadsheet. A small agency with several overdue invoices and no shared rule for when to follow up. The subject is using clear due dates and calm reminders instead of improvised pressure. We will use the calculation as a way to organise the facts, then add the judgment that a formula cannot supply.
Make the inputs comparable
Begin with a definition that your team can repeat. Write down the period, the currency, and what is included before opening a spreadsheet. Build a late-payment routine before you need one is most useful when it stays connected to using clear due dates and calm reminders instead of improvised pressure. A small agency with several overdue invoices and no shared rule for when to follow up.
Work through one example
Use one small worked example from your own situation. A simple example often exposes an assumption more quickly than a polished dashboard. Build a late-payment routine before you need one is most useful when it stays connected to using clear due dates and calm reminders instead of improvised pressure. A small agency with several overdue invoices and no shared rule for when to follow up.
Read the movement
When the result changes, ask what changed in the underlying business. A metric is a signal; it is not an instruction by itself. Build a late-payment routine before you need one is most useful when it stays connected to using clear due dates and calm reminders instead of improvised pressure. A small agency with several overdue invoices and no shared rule for when to follow up.
Leave an audit trail
Keep a short note next to the calculation. Future-you should be able to see where the inputs came from and why a judgment was made. Build a late-payment routine before you need one is most useful when it stays connected to using clear due dates and calm reminders instead of improvised pressure. A small agency with several overdue invoices and no shared rule for when to follow up.
Avoid the comparison trap
The most common mistake is comparing numbers built on different periods or definitions. Consistency is usually more valuable than false precision. Build a late-payment routine before you need one is most useful when it stays connected to using clear due dates and calm reminders instead of improvised pressure. A small agency with several overdue invoices and no shared rule for when to follow up.
Stress-test the choice
Before acting, test a less comfortable case. Lower revenue, a delay in payment, a lost customer, or a higher cost can show whether the plan has room to breathe. Build a late-payment routine before you need one is most useful when it stays connected to using clear due dates and calm reminders instead of improvised pressure. A small agency with several overdue invoices and no shared rule for when to follow up.
Put the result in context
A calculator can make the arithmetic quick. It cannot replace local rules, contracts, tax advice, or the conversations that give the number meaning. Build a late-payment routine before you need one is most useful when it stays connected to using clear due dates and calm reminders instead of improvised pressure. A small agency with several overdue invoices and no shared rule for when to follow up.
A practical next step
Before you close this guide, write down the one decision this article needs to support this week. Choose a source for every input, set a date to revisit the assumption, and tell the person affected by the decision what would make you change course. Ask them to challenge one assumption as well, especially the easiest one to overlook. Keep the note with the quote, budget, or meeting record that prompted it, rather than letting it disappear into an unlabelled spreadsheet tab. That small discipline turns a calculation from a display of confidence into a useful working note.