Use this simple tracker to see what is still owed and who needs a follow-up. The two entries below are fictional examples.
Copy the three lines below into a plain-text file named invoice-tracker.csv, then open or import it in your spreadsheet app. Use one currency throughout and replace the examples with your own invoices.
Customer,Invoice ID,Due date,Original amount,Amount paid,Outstanding balance,Next follow-up,Payment promise
Example Cleaning Co,INV-001,2026-10-31,480,200,280,2026-11-09,Customer promised to pay Monday
Example Maintenance Co,INV-002,2026-11-02,325,0,325,2026-11-10,Confirm payment date
Calculate the remaining balance. In a spreadsheet, enter =D2-E2 in F2 and copy the formula down. When a payment arrives, update the total in Amount paid so your next reminder reflects the remaining balance.
Choose your follow-ups. Filter for a positive balance and a follow-up date on or before today. Before contacting anyone, check your latest payment records. Set a new follow-up date after the conversation.
If you want overdue balances and follow-ups shown together in a browser, FieldDue offers a local board with backup and four reminder templates. The business license is a one-time €89 purchase.