Skip to content

How to Track Invoice Payments and Overdue Balances

Build an invoice payment tracker with due dates, partial payments and balances. Follow a worked example and a short weekly follow-up routine.

Keep one row per invoice. Record confirmed payments against it, subtract them from the invoice total, and sort open balances by due date before following up.

A client can pay part of an invoice before its due date and still owe the rest after it passes. An invoice payment tracker should answer two questions separately: how much is still open, and when was it due?

On this page

Start with the fields you need

In a spreadsheet, use columns for invoice number, client, issue date, due date, invoice total, payments received, balance and last follow-up. Keep payment dates and bank references in a separate payment log keyed by invoice number if customers sometimes pay in instalments.

If the invoice total is in E2 and confirmed payments received are in F2, enter =E2-F2 in the balance column. Check negative balances as possible overpayments or entry errors. Keep a separate view for each currency so you never add unlike amounts.

Work through three example invoices

Assume today is 19 November and these are fictional invoices in rupees.

  • INV-104 · due 16 November · ₹12,000 invoiced · ₹5,000 received. Partially paid, with ₹7,000 overdue.
  • INV-105 · due 25 November · ₹8,000 invoiced · ₹0 received. Unpaid and still within terms.
  • INV-106 · due 18 November · ₹6,500 invoiced · ₹6,500 received. Paid, with no balance to follow up.

Review what is due before sending a reminder

Match new deposits with invoices first. Check any payment that arrived without a clear reference. Then look at invoices with a positive balance and a due date earlier than today.

Follow up with the invoice number, due date and remaining balance. For example: “A quick check on INV-104, due 16 November. We’ve received ₹5,000 and the remaining balance is ₹7,000. Could you confirm the expected payment date?” Write down the reply so your next follow-up starts with the latest agreement.

Keep the invoice and its payments together in BizBeat

Record each payment against its invoice, then use the invoice list to see unpaid, partially paid and overdue records. Open the individual invoice to confirm what was received before following up.

BizBeat

Invoicing and expenses for small businesses

Explore BizBeat invoicing and payment tracking

Sources