Invoice Payment Tracker

An invoice tracker spreadsheet that shows who owes you, how much and how late, at a glance, with accounts receivable aging and a printable invoice template built in.

$12.00 USD · instant digital download

Buy now: $12.00

Prefer Etsy? Find us on Etsy.

Features

• Invoice log with automatic due dates from your payment terms
• Partial payments, balance and Paid/Open/Overdue status; overpayments show as customer credits
• Days overdue and accounts receivable aging buckets (Current, 1-30, 31-60, 61-90, 90+)
• 1-page printable invoice (up to 10 line items per printed invoice): pick an invoice # (text or number), and its line items, service date and service address fill in from the log. Customers see Balance due / Paid / Credit, never 'Overdue'
• Dashboard: total owed, customer credits, overdue count, monthly invoiced (by issue date) vs collected (by paid date, capped at the invoice amount) for the year you choose

What you get

• 1 Excel (.xlsx) file, plus a PDF with a Google Sheets 'Make a copy' link and setup steps
• Works in Microsoft Excel (desktop, 2016 or later) and free Google Sheets (desktop recommended for setup)
• Instant digital download. No physical item will be shipped.

One license covers one person or one business. See Terms & License. Digital download, so returns aren't accepted, but we'll fix or replace any file that doesn't work (details).

Save this template to Pinterest

This is an organizing tool, not tax, legal, accounting or financial advice, and it doesn't calculate tax owed. Results depend on the numbers you enter. Talk to a qualified professional about your own situation.