Invoice Payment Tracker Spreadsheet

How this tracker works

Nothing you pick here is sent anywhere: the file is built in this browser tab and handed straight to your downloads folder.

What to put in each column

Invoice number

The exact number on the invoice itself, so this row and that document always match. If you haven’t settled on a format yet, seeinvoice number format first.

Client

The name you’d recognize the client by at a glance: a company name for business clients, or a person’s name for individuals. Keep it consistent so you can filter or sort by client later, and start from a customer database if you don’t have client names written down anywhere yet.

Issue date

The date the invoice was sent. It’s the anchor for your own records, separate from the due date, especially useful if your payment terms are something like “Net 30 from issue”.

Due date

The date payment is actually owed by. This is what you compare today’s date against to know who’s overdue and who isn’t yet.

Amount

The full invoice total, tax included, in whatever currency you billed in. Keeping this consistent with the invoice itself makes the log something you can reconcile against, not just a guess.

Amount paid

What’s actually landed in your account so far. Leave it at 0 until payment arrives, and update it as partial payments come in, so a row can show “paid in part” honestly rather than as fully paid or fully unpaid.

Payment date

The date payment actually arrived, not the date it was due. Leave it blank until it happens. Comparing this against the due date is what tells you how reliably a given client actually pays.

Status

A short word you’re consistent about, such as “Paid”, “Partially paid”, “Unpaid”, or “Overdue”. If a row’s overdue, that’s the moment to write the reminder letter for it.

Payment method

How the payment came in: bank transfer, card, cash, or whatever else you accept. Useful for reconciling against a bank statement later, less useful if you only ever get paid one way.

Reference

A purchase order number, a bank transfer reference, or any other code the client used to tag the payment. Handy when a bank statement shows a reference instead of a client name.

Notes

Anything that doesn’t fit another column: “invoiced twice by mistake”, “client asked for 30 more days”, or a short note from a phone call. Free text, so it’s the one column that’s genuinely yours to use however you like.

Currency

The 3-letter code the amount was billed in, such as EUR or USD. Only worth adding if you actually invoice in more than one currency: for a single-currency business it’s the same value on every row and adds nothing.

Tax amount

The tax portion of the total, kept separate from the pre-tax amount. Useful at tax time if you want to total up what you’ve collected without recalculating it from the invoice total and rate every time.

Why a plain CSV instead of a written explanation

A payment log only works if you actually keep it, and a wall of instructions doesn’t give you anything to open and start typing into. This tool skips the explanation-only approach: pick the columns you want, and you get an actual file, already headed correctly, ready to drop invoices into today.

Once a few rows go past their due date, an accounts receivable aging report turns this same list into totals by 30, 60, and 90 day bucket, instead of you tallying it by hand.

Frequently asked questions

What’s the difference between “Due date” and “Payment date”?

Due date is when payment is owed. Payment date is when money actually arrived. Comparing these two dates tells you how reliably a client pays their obligations.

Can I track partial payments in this tracker?

Yes. The “Amount paid” column starts at 0. As partial payments come in, update it with what has landed so far, and mark the status as “Partially paid” rather than fully paid or unpaid.

Why should I download the CSV as a backup?

This page itself saves nothing between visits: your column choices reset the next time you open it. The downloaded CSV is the only copy that exists, and once you're using it as your live payment log in a spreadsheet program, treat that file like any other business record. Back it up the way you'd back up anything you can't afford to lose.

Should I include already-paid invoices in this tracker?

No. This is a working log for invoices you want to track. Once an invoice is fully paid and resolved, many people remove it from the active tracker and keep it in a separate archive for reference.

Which columns are required?

Only “Invoice number”, “Amount”, and “Due date” are truly essential. The rest depend on what you need to track. If you only ever work with one client or one currency, those columns are less useful.

Related tools

• Overdue invoice reminder letter: write the letter for a row that’s gone late.
• Invoice number format: pick what goes in the Invoice number column.
• Profit and loss statement: total the Amount paid column against expenses.