How to Track Invoices Effectively (Systems, Metrics, and Habits)

To track invoices effectively, keep every invoice in one system, give each one a clear status (such as sent, partially paid, paid or overdue), and review your unpaid invoices by how long they're overdue at least once a week. Give every overdue invoice a next step and a date, and record each payment against its invoice as soon as it arrives.

1. Keep one record of every invoice

Choose one place where every invoice lives, such as your invoicing software. If you also keep a spreadsheet, update it from that system rather than typing figures twice, so the two can't drift apart. For each invoice, the record should show:

• The invoice number, client and amount
• The invoice date and due date
• The amount paid so far and the balance still owed
• The status
• The next step and its date, if the invoice is overdue

Unique, sequential numbers make invoices easier to find and match. See how to number invoices.

2. Use a small set of statuses

A short list of statuses is easier to keep accurate:

• Draft: not yet sent to the client.
• Sent: with the client and not yet due.
• Partially paid: some of the amount received. See how to handle partial payments.
• Paid: settled in full.
• Overdue: past the due date and not fully paid. See what is an overdue invoice.
• Void: canceled, for example because it was issued by mistake.

3. Record payments against the right invoice

When a payment arrives, match it to the invoice number and update the balance the same day. Ask clients to quote the invoice number when they pay. A payment that sits in your bank account without being matched makes a paid invoice look unpaid, and you may chase a client who has already paid.

4. Review unpaid invoices by age

Group your unpaid invoices by how long they're overdue: not yet due, 1 to 30 days, 31 to 60 days, 61 to 90 days and over 90 days. The open textbook Principles of Accounting, Volume 1 from OpenStax describes this grouping, where "accounts receivable is organized into categories by length of time outstanding", and explains why it matters: "The longer the time passes with a receivable unpaid, the lower the probability that it will get collected." (OpenStax, section 9.2, opened October 29, 2026).

Each week, look for invoices that have just become overdue, invoices moving into an older group, and any single client who owes a large share of the overdue total.

5. Give every overdue invoice a next step

For each overdue invoice, write down the next step (a reminder, a phone call or a question about a dispute), who will take it, and the date. When you speak to a client, note the invoice numbers you discussed and anything they promised. See how to follow up on unpaid invoices and how to write invoice payment reminders.

6. Watch a few numbers over time

• The overdue share: overdue balances divided by all unpaid balances.
• The amount in each age group, from your weekly review.
• Days' sales in receivables: OpenStax says this ratio "shows the expected days it will take to convert accounts receivable into cash." It calculates it as 365 divided by the accounts receivable turnover ratio, which is net credit sales divided by average accounts receivable (OpenStax, section 9.3). See accounts receivable turnover.

Compare each number with your own earlier figures, so you can see whether collection is speeding up or slowing down.

Sample: a weekly aging list

This is a sample with invented figures. On July 31, a business has five unpaid invoices:

• INV-101: $1,200.00, due August 10: not yet due
• INV-102: $800.00, due July 25: 6 days overdue
• INV-103: $2,500.00, due July 5: 26 days overdue
• INV-104: $600.00, due June 20: 41 days overdue
• INV-105: $1,500.00, due May 31, with $500.00 paid: $1,000.00 still owed, 61 days overdue

Grouped by age:

• Not yet due: $1,200.00
• 1 to 30 days overdue: $800.00 + $2,500.00 = $3,300.00
• 31 to 60 days overdue: $600.00
• 61 to 90 days overdue: $1,000.00
• Total unpaid: $1,200.00 + $3,300.00 + $600.00 + $1,000.00 = $6,100.00
• Overdue: $6,100.00 − $1,200.00 = $4,900.00, so the overdue share is $4,900.00 ÷ $6,100.00 = 80.3%

The next steps for this week: call about INV-105, the oldest, and send reminders for INV-102, INV-103 and INV-104.

Where Billed fits

Billed's financial reporting page says: "Billed offers several built-in reports: Invoice Reports (paid, partially paid, and overdue), Expense Reports, Income vs Expense Reports, Top Selling Products, and Time Tracking Reports. Each report can be filtered by date range and exported."

Its invoice software page says: "Invoice reports show which invoices are paid, partially paid or past due, and you can see who owes you money and send them a payment reminder." It adds: "When a client pays by check or cash, record it as an offline payment so all your income is in one place."

Its client management page says: "Each client profile in Billed includes a complete history of invoices, estimates, and payments. You can quickly see outstanding balances, payment history, and any overdue invoices at a glance." Its features page lists "Void Invoices" and says you can "Easily void your invoices in Billed App".

Related Articles

• What Is Accounts Receivable Management?
• How to Follow Up on Unpaid Invoices
• How to Write Invoice Payment Reminders
• What Is an Overdue Invoice?
• How to Number Invoices

Frequently Asked Questions

What statuses should I use to track invoices?

A short set is easier to keep accurate: draft, sent, partially paid, paid, overdue and void. Each invoice should have one status, updated whenever a payment arrives or the due date passes.

How do I see which invoices are overdue?

Group unpaid invoices by how long they're past the due date, such as 1 to 30, 31 to 60 and 61 to 90 days. In the sample on this page, $4,900.00 of $6,100.00 in unpaid invoices is overdue, an overdue share of 80.3%.

When should I review unpaid invoices?

At least once a week, so newly overdue invoices get a next step before they move into an older age group. Record payments against their invoices the day they arrive, so the review shows what's really still owed.

What does days' sales in receivables measure?

OpenStax says it "shows the expected days it will take to convert accounts receivable into cash," calculated as 365 divided by the accounts receivable turnover ratio.