Payment follow-up register format in Excel

What the file looks like

The heading row and the five example rows, as they open in Excel. Under them the file has empty rows that are ready: the lists, the formulas and the colours are already set.

The columns, and what to write in each

1. 1
   Party

   Firm name and city, as in Tally.

2. 2
   Invoice no.

   From Tally or Busy.

3. 3
   Invoice date

   Date of the invoice.

4. 4
   Amount

   Invoice amount.

5. 5
   Due date

   Invoice date plus the credit period you agreed.

6. 6
   Received

   Money received against this invoice so far.

7. 7
   Balance

   Fills itself: amount minus received.

8. 8
   Days overdue

   Fills itself: days past the due date while a balance is open.

9. 9
   Last contact

   The day you last called or wrote.

10. 10
    What was said

    One line. Also any problem with the material or the bill.

11. 11
    Promised date

    The date the party gave. Ask "which date shall I note?"

12. 12
    Next action date

    When you act next. Never empty for an unpaid bill.

13. 13
    Next action

    The step that is due, from your follow-up calendar.

    Reminder messageCallSalesperson callOwner callStatement sentHold next dispatch
14. 14
    Follow-up by

    One name, in accounts.

How to keep it

1. Add one row for every credit invoice on the day it is made. Check the party ledger in Tally before you call.
2. After every call or message, fill "Last contact", "What was said" and the date the party gave.
3. Never leave "Next action date" empty for an unpaid bill. A row without it is a row nobody follows up.
4. On the two calling days of the week, filter "Next action date" up to today and work down the list.
5. When the money comes, enter it in "Received". The balance and the colour change by themselves.