How to Keep Track of Paid and Unpaid Invoices

The awkward part of chasing an invoice is often the five minutes before you send the message. Did this customer pay a deposit? Was that transfer for this job or the previous one? Did you already promise to wait until Friday? When the answers live in different chats, folders and project notes, even a polite reminder becomes hard work.

Our approach is to keep one invoice list, a short payment history and a next action for every open balance. You can start in a spreadsheet. The important part is giving each payment a home and making the next check easy.

Start with one row per invoice, not one row per customer

A customer can have three projects and five invoices in progress. A single “paid” tick beside their name cannot tell you which balance is settled. Give each invoice its own row and use its number as the reference in your payment notes, saved PDF and customer conversation.

• Record the invoice number, customer, project or service date, currency, invoice total and due date.
• Add the amount received, remaining balance and payment status.
• Keep the last contact date, any promised payment date and your next action together.
• Link the invoice PDF and relevant project record so you can answer a question without searching several apps.

Keep quotes in a separate view. A quote proposes the work and price; an invoice requests payment. An accepted quote is useful project context, but it should not become an unpaid balance in your invoice list until you have issued the appropriate invoice.

Make the balance visible

Here is a fictional tracker reviewed on 14 November 2026. All amounts are in NAD and represent final invoice totals, including any tax already shown on each invoice. The status describes payment; the due date tells you when to follow up.

For these invoices, the total remaining is N$2,900, of which N$2,000 is overdue. Cora’s invoice is unpaid but not late. Keeping those two ideas separate prevents unnecessary reminders. If you invoice in several currencies, total each currency separately.

Record partial payments as events

Keep the original invoice total intact when a customer pays part of it. Add the payment to a history and reduce the balance. For Ben’s N$3,000 repair, a N$1,000 payment leaves N$2,000 owing. A second payment of N$750 would leave N$1,250. Neither payment turns the whole invoice into “paid”.

For each receipt, record the date, amount, payment reference, invoice allocation and who checked it. Confirm receipt through your usual payment records before updating the tracker. A customer’s “sent” message is useful context while you check, not a second payment to record.

When one transfer covers several invoices, split the allocation between those invoice numbers and check that the allocations add up to the transfer. Keep an unclear payment unallocated until you confirm what it covers. Never count the same receipt against two projects.

Show any agreed credit or adjustment separately, with its reference. Your working balance is the invoice total less payments allocated and valid credits. Keeping those entries visible makes a later disagreement much easier to resolve.

Give every open invoice a next action

Set aside ten minutes twice a week, or use a rhythm that suits your volume. Check new payments first, update balances, then look at overdue invoices. That order keeps you from chasing money that has already arrived.

1. Confirm that the invoice reached the right person and includes the details their accounts team needs.
2. Review the balance and the latest conversation before writing.
3. Ask for a payment date or clarify any disputed item.
4. Record the reply and set a date to check again.

Separate “waiting for payment” from “waiting for our correction”. If a customer needs a purchase-order reference or disputes a charge, record that specific issue and who will resolve it. Sending the same reminder again will not fix missing information.

Send a reminder that is easy to answer

Keep the invoice number, remaining amount and one clear request in the message. Attach or link the invoice through your normal secure sharing method. Here are original scripts you can adapt to your own customer and agreed terms.

Hi Ben, a quick follow-up on invoice INV-102 for the pump repair, due 12 November. We’ve received N$1,000, thank you. The remaining balance is N$2,000. Could you let me know when we can expect the balance? I’ve attached the invoice for reference.

Hi Ben, thanks for confirming Friday as the payment date for the N$2,000 balance on INV-102. I’ve noted it against the job. Please let me know if anything changes or if your accounts team needs another detail from us.

Hi Ben, I’m checking back on the payment we expected on Friday for INV-102. Our records still show N$2,000 outstanding. Could you confirm the current payment date, or send the reference if you’ve already paid?

If someone else handles follow-ups, hand over the history

A bookkeeper or collections service needs more than a customer name and an amount. Prepare the invoice, payment allocations, agreed terms, contact history, any dispute and the next promised date. Agree who contacts the customer and who updates the record, so two people do not chase the same balance.

Before appointing a service, check its fees, communication approach and how it protects customer information. Agree which decisions stay with you, including settlements or changes to payment terms. Start with an organised record rather than asking someone else to reconstruct it.

Where Quotavani fits into the routine

Quotavani helps you prepare an invoice on Android, review the draft and share a PDF. You can record payment status and manage due dates. Treat those entries as your record of checks you have made: they do not reconcile bank payments or collect money for you. Keep partial-payment details in your own tracker if your installed version does not provide the fields you need.

For repeat work, reuse the relevant document details, then check the customer, work, dates and amounts before sharing a fresh invoice. Review the payment record before each follow-up and send reminders yourself. Our payment-status guidance and repeat-client workflow explain these steps.

Building the next invoice? Check its quantities and rates with our free invoice line-item calculator. It gives you a subtotal before tax. To hear about Android availability, join our launch updates.