Excel for credit control: who to call today
A collections workbook is the call list. One row is one open customer invoice: the amount, the due date, the promise date you were given, and the next reminder date you set. SUMIF totals the open amount by customer. COUNTIFS counts the rows whose next action is today or earlier. This is not the bank match, and it is not the list of bills you have to pay. The money here is what customers still owe you, and the next thing you will do about it. The guide below builds that call list. Elyx writes the days overdue and the total from the invoices you imported. You still record what the customer said. The trial lasts 7 days, with no card.
Frequently asked questions
What is one row in collections?
One open invoice: customer, number, amount, due date, promise date, last reminder, and the next action date you set.
Does the sheet charge interest?
No. It does not know a late fee or a legal rate. You type amounts. The formulas add days and totals.
Is this the same as aging buckets?
Aging groups amounts by how late they are. This sheet is the next action on each invoice. You can keep both. They answer different questions.