Tracking sheet export
Copy this CSV into Google Sheets, Excel, or Airtable for next month.
invoice_number,customer,email,amount,paid_amount,remaining_amount,due_date,days_overdue,aging_bucket,reminder_stage,last_contact_date,contact_attempts,next_followup_date,status,exception_reason,next_action
"INV-1001","Acme Studio","[email protected]","1200.00","1200.00","0.00","2026-06-19","12","1-30","second","2026-06-20","1","2026-07-05","paid-match","Possible payment found; verify before reminding the customer.","Mark as paid after confirming the payment reference."
"INV-1002","Northwind Agency","[email protected]","750.00","300.00","450.00","2026-06-21","10","1-30","second","","0","2026-07-05","partial-or-possible-match","Partial or amount-mismatch payment found.","Review the possible partial payment, then follow up for the remaining balance."
"INV-1003","Bright Labs","[email protected]","490.00","0.00","490.00","2026-07-05","-4","current","none","","0","2026-07-07","due-soon","","Optional: send a soft reminder before the due date."
"INV-1004","River City Builders","[email protected]","2400.00","0.00","2400.00","2026-05-15","47","31-60","call","2026-06-10","3","2026-07-02","overdue","Last contacted on 2026-06-10; avoid repeating the same note.","Call or send a firm written reminder today."
Contact log export
Use this to record every collection attempt, promise-to-pay date, and next step.
customer,email,invoice_number,remaining_amount,days_overdue,reminder_stage,recommended_contact_date,contact_method,commitment_date,outcome,next_step
"Northwind Agency","[email protected]","INV-1002","450.00","10","second","2026-07-01","email","","","Review the possible partial payment, then follow up for the remaining balance."
"River City Builders","[email protected]","INV-1004","2400.00","47","call","2026-07-01","email + phone","","","Call or send a firm written reminder today."