Templates › Payment Tracker
Payment Tracker Excel Template
See who has paid and who has not. Enter each invoice and the amount received. Balance and status fill in on their own.
⬇ Download free (.xlsx)Free · No sign-up · 17 KB · Works in Excel and Google Sheets
See it filled with data
The file has two sheets: a blank one for your own data, and this filled Example so you can see how it works.
What is inside
- Balance for every invoice (Invoice Amount − Received)
- Status shows Paid, Part Paid or Pending
- Totals on top: invoiced, received, balance due
- Ready for 100 invoices
How to use it
- Add one row for each invoice you send.
- Type the amount whenever a customer pays.
- Read the Status column to know whom to call.
- Check Balance Due on top for the total pending money.
⬇ Download the Payment Tracker template
More free templates
InvoiceQuotationExpense TrackerMonthly BudgetSales TrackerStock InventorySalary SheetAttendance SheetTask TrackerLead TrackerLoan EMI Calculator