Payment Recovery Tracker

How to use it

1. 1Add each invoice with customer, salesman or area, invoice date, amount and credit days.
2. 2Update the amount received when payment comes in, including part payments.
3. 3Due date, balance, days late and ageing group are calculated from today's date.
4. 4Summary shows the amount to recover in each ageing group.

What it shows

• Due date from credit days
• Days late and ageing groups
• Follow-up date and notes
• Recovery summary

Made for: Distributors, pharma and FMCG suppliers and B2B sellers who give credit days.

The few rows marked EXAMPLE show how it works. Delete them before adding your own data.