Invoice & Payment Follow-up Tracker for Freelancers — Partial Payments, Overdue Queue & Manual Reminders

Sending an invoice is the easy half. The hard part comes later: remembering who still owes what after part-payments, deciding who needs a follow-up today, and keeping your promises and reminders straight.

This 15-sheet Excel workbook brings that work into one place. It calculates outstanding balances from your payment log, including partial payments; groups overdue balances by age; ranks a collection queue; drafts reminder wording; and records reminders so the next follow-up date can be worked out.

INCLUDED

• CLEAN workbook for your own records and a DEMO workbook with fictional sample data

• Quick Start PDF

• CSV backups and sample invoice/payment exports

• Python helper that reads exported CSVs and creates a collection list, reminder drafts, and an .ics calendar snapshot

• One-business license

COMPATIBILITY & LIMITS

Designed for Microsoft Excel 2016 or later. Other spreadsheet apps have not been independently checked. The reminder helper is manual: export your data and run it again when dates or statuses change. It does not send email, sync with a bank, create invoices, or connect to a live calendar.

The amounts shown in preview images come from fictional records in the included demo workbook. They are examples, not customer results.