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.

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.

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.