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

Payment Tracker Excel template filled with sample 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

  1. Add one row for each invoice you send.
  2. Type the amount whenever a customer pays.
  3. Read the Status column to know whom to call.
  4. Check Balance Due on top for the total pending money.

Formulas used: IF SUM COUNTIF

⬇ Download the Payment Tracker template

More free templates

InvoiceQuotationExpense TrackerMonthly BudgetSales TrackerStock InventorySalary SheetAttendance SheetTask TrackerLead TrackerLoan EMI Calculator

← All templates