PAYVEX: Invoice Tracking Template for Google Sheets

One row per invoice you've sent, four figures up top — PAYVEX is an invoice tracking template for Google Sheets that answers the daily freelance question without any digging: how much is out there, how much came in, and what's overdue. It downloads free as .xlsx and runs identically in Google Sheets, Excel and LibreOffice.

What the invoice tracker shows at a glance

Four headline figures sit above the table and read the whole sheet: total invoiced, collected, outstanding, and the count of overdue invoices. They're plain sums and conditional counts over the rows below — register an invoice or mark one paid and all four move with it. No refresh, no script.

Inside the invoice tracking template

Nine columns per invoice: number, client, issue date, due date, amount, a status dropdown (Draft, Sent, Paid), the date it was collected, days overdue, and notes. Days overdue is the column you never fill in — the sheet compares each unpaid invoice's due date with today and counts the lag, then goes quiet once the invoice is marked Paid. Colour rules run on top: a row turns red when it's overdue and uncollected, amber when its due date falls inside the next seven days, green when paid. The ten sample invoices arrive in all three states on purpose, so the formatting shows itself before your data goes in. Statuses live on a small Lists tab; renaming one or adding your own is a one-cell edit.

How to track invoices in Google Sheets

1. Register each invoice you issue, with its dates and amount.
2. Keep Status current — and when you mark Paid, note the collection date.
3. Watch the reds: overdue, uncollected rows while Days overdue counts the delay.
4. Read the header for invoiced, collected and outstanding at any moment.
5. Sort by Due date to line up the next collections.

An invoice tracker in twelve languages

PAYVEX comes in twelve language editions — separate .xlsx files with column headers, statuses, date and currency formats translated, formulas untouched. Download the one that matches your page language; the opening guide covers getting any of them into Google Sheets.

The tracker assumes the invoices already exist. If creating them is the slow part, INVIX builds the invoice itself from client and item catalogues — the two sheets are designed to sit side by side, and both belong to the Google Sheets invoice templates.