You do not need a full accounting system to keep unpaid invoices visible. Start with one spreadsheet that records each invoice, its due date, amount, status, and next action. Then review it at the same time every week. That simple routine prevents a sent invoice from disappearing into an inbox while keeping the record small enough to maintain.
This is a payment follow-up list, not a replacement for bookkeeping, tax records, or the invoice itself. Keep your issued invoices and receipts in their proper records; use the tracker to answer one practical question: who still owes me, and what should I do next?
Set up one row per invoice
Make one row for every amount you expect to collect. If a single project has three separate payment milestones, give each milestone its own row. That way, a deposit can be paid while the final balance remains open without making the whole project look settled.
Use a stable reference such as the invoice number, plus the client and project name. Enter the date you sent it, its due date, the amount, and the status. Add a last-contact date and a next-action note if you send reminders or agree on a revised date. You can keep the columns in this order:
| Field | What to record | Why it helps |
|---|---|---|
| Client and reference | Name, project, invoice number | Find the right record quickly |
| Dates | Sent date and agreed due date | See what is coming due or late |
| Amount and status | Amount due; sent, due, part-paid, or paid | Keep outstanding work distinct from collected money |
| Next action | Last contact and next follow-up date | Make the next step concrete |
Use the currency shown on the invoice and keep a separate row or note for any partial payment. Do not silently change the original amount: record what came in and calculate the remaining balance in its own cell. If spreadsheet formulas are not comfortable, a manually updated balance is perfectly workable.
Choose a few clear statuses
A status should tell you where to look, not try to explain every detail. “Sent” means the invoice has gone out and is not yet due. “Due” means its payment date has arrived or passed. “Part-paid” means some money has arrived and a balance remains. “Paid” means the amount you were tracking has been received and reconciled against your records.
Some people prefer “overdue” as a separate status. That is useful if it helps you sort the list; otherwise, make the due date easy to scan and filter dates before today. Avoid a long menu of labels that you will need to interpret later. Put exceptions such as “client asked to pay Friday” in the note and record the agreed date.
Review the list once a week
Pick a regular time, such as the beginning or end of your work week. Sort by due date and look at the next few weeks first. Check that invoices already sent have an entry, identify anything newly due, and decide which client needs a message. After you send a reminder, enter the date and the next point at which you will check in.
When a payment arrives, mark the matching row and update the remaining balance if needed. Check the transfer against your bank or payment record before marking it paid. A client saying “sent” is useful information, but it is not the same as seeing the money arrive. If you receive a partial payment, keep the row open and note the date and amount received.
The review does not need to turn into a daily ritual. The purpose is to give every open item a next step. If the next step is “wait until the revised date,” write that down; if the due date has passed, prepare a concise follow-up rather than relying on memory.
Keep the record useful and private
Record only what you need to identify the work and follow up. Names, invoice references, dates, amounts, and a short note are usually enough for this list. Do not copy bank account details, passwords, card data, or long client conversations into a general-purpose sheet. Link to or store the original invoice in the place you already use for business documents.
Protect access to the file and keep a backup you can restore. If the sheet lives on a device, know where its backup is. If it is stored with an online spreadsheet provider, understand that the provider may process the file under its own terms. Choose a setup that fits your confidentiality needs, and do not treat any one tracker as your only copy of important financial records.
Make follow-up ordinary
A reminder can be brief: identify the invoice, state the amount and due date, attach the invoice again if useful, and ask whether the client needs anything to process it. Keep the tone neutral. A late payment may be an oversight, an approval delay, or a problem; a calm first note leaves room to find out.
If you want ready-to-edit wording, see our payment reminder email templates. If a particular client remains unresponsive, this step-by-step guide to a late client payment covers what to check and when to set a firmer boundary.
When a simple tracker stops being enough
As projects and obligations grow, the question may shift from “what is still unpaid?” to a broader need for bookkeeping, tax preparation, expense records, or formal reporting. A follow-up sheet is not designed to do all of that. At that point, consider a system that matches the work you actually need, and keep a clear boundary between the receivables list and accounting records.
The method above is complete on its own: one row per invoice, a few statuses, a weekly review, and a recorded next action. If you would rather keep that narrow view in a dedicated local board, owed, the studio’s payment board, is releasing soon. It keeps who owes you what in sent → due → paid, drafts polite follow-up emails, makes reports, and can export a JSON backup—a file you own. It is deliberately not accounting software or an invoicing tool.
Frequently asked questions
What is the simplest way to track unpaid invoices?
Use one row per invoice and record the client, reference, amount, sent date, due date, status, and next action. Review open rows once a week and update them when you contact the client or receive money.
Should I track a partial payment as paid?
No. Mark it part-paid, record the amount and date received, and leave the remaining balance open. Mark the row paid only when the tracked balance has been received and checked against your records.
How often should I follow up?
Use the payment terms you agreed and a cadence that suits the relationship. A polite note around the due date, followed by a measured check-in if it remains unpaid, is a reasonable starting point. Record your next contact date so you do not send duplicate messages.
Does an unpaid-invoice tracker replace accounting software?
No. It is a practical list for payment follow-up. Keep invoices, income records, expense records, and tax information in the systems and formats your business requires.