How to Build an Overdue Payment Tracker

Credit customers are common, and chasing payments from a sheet is slow. Let a rule mark each invoice as Paid, Due or Overdue.

1. Link Invoices to Customers, with a Due Date and an Amount Paid.
2. Add a rule: "Overdue if the due date has passed and the invoice isn't fully paid".
3. On Customers, add a Rollup for total outstanding.
4. Create an Overdue view sorted by days late.