Ultimate Billing Statement Spreadsheet Template for Google Sheets & Excel

Twenty client slots: who they are, who to contact, the email, the payment terms agreed and the billing rate that applies to them, with room for notes. Every other sheet reads its names from here, and the Billing Log picks the client from a dropdown rather than asking you to retype it. Recording terms per client rather than assuming one set is the part that matters when collections start. A client on thirty days and one on sixty are not late at the same moment, and an aging report built without that distinction quietly accuses the wrong people.

A row per billed item, each carrying the date, the client, what the work was, the hours, the rate, the amount, whether it has been paid, the date payment arrived and the balance still due on that line. Keeping the payment date beside the billing date is what makes everything downstream possible. It is the difference between knowing a client owes you money and knowing how long they have owed it - and only the second one changes how you handle the call.

One row per client: what they have been billed in total, what they have paid, what remains, when they last paid anything, and an aging label for the oldest unpaid work. The last-payment date is the column to read alongside the balance. A large outstanding figure from a client who paid something last week is a different situation from a smaller one from a client who has paid nothing since spring, and the two demand different responses.

What each client owes, split by how long it has been outstanding: current, thirty to sixty days, sixty to ninety, and beyond ninety. The brackets are worked out against today's date, so the report ages itself every time the file is opened. The far-right column is the one that costs money. Debt that has sat past ninety days is materially less likely to be collected than debt at thirty, and seeing the balance drift rightward across a few months is a better warning than any single total.

Each client across twelve months, with totals both ways. It answers a question the balances cannot: not who owes you money, but who is actually giving you work. A client can be entirely current on payments and still be worth watching if their monthly figure has been falling since February. Revenue concentration and revenue decline both show up as a row here long before they show up in a bank balance.

Billed year to date, received year to date, and the outstanding balance between them. Those three are the whole receivables position: what you have earned, what has arrived, and the gap you are carrying. For a business that invoices rather than takes payment at the till, that gap is the figure that decides whether a profitable month feels like one. Three more say how the collecting is going - the average days from invoice to payment, the collection rate as received against billed, and how many clients are on file. Average payment time answers what the agreed terms cannot: agreeing thirty days and being paid in twenty is a different business from agreeing thirty days and being paid in forty-five. Underneath, total billed by client on a chart, and the outstanding balance totalled into its four aging brackets.