How to Track Overdue Invoices by Job Number (Contractor Aging Report)

Your office manager says three invoices are overdue. A technician insists that one of those jobs was paid on-site, and the customer replies with a screenshot of a deposit from two months ago. Everyone is looking at a different record. The problem may not be that your team forgot to send reminders; it may be that your invoices are not consistently connected to the jobs that created them.

A job-number-based invoice tracker solves a very specific problem for contractors: it links each unpaid balance to the customer, property, approved estimate, visit history, partial payments and person responsible for follow-up. This article explains how to build that record in a spreadsheet or invoicing system without mixing up invoices, deposits and payment-provider payouts.

Quick answer: give every job and every invoice its own identifier

Use a unique job ID, such as JOB-1042, for the work performed at a particular customer property or under a defined contract. Use a separate unique invoice number, such as INV-2210, for each customer bill. Store the job ID on every related invoice. If one job produces a deposit, progress payment and final bill, all corresponding records should share the job ID without reusing invoice numbers.

This distinction matters because one job can have multiple invoices, and one customer can have multiple jobs. Sorting only by customer name will not tell you whether a $350 payment was for last month's appliance replacement or this week's plumbing repair.

The 10 fields a contractor invoice tracker needs

• Job ID: a stable reference for the service call, project or contract.
• Invoice number: a unique identifier for the individual bill.
• Customer and service address: include both when the payer manages more than one property.
• Invoice issue date: when the invoice was created.
• Due date: the agreed date payment is expected.
• Original invoice amount: the amount billed on this invoice, not the entire job's lifetime revenue.
• Payments and credits applied: amounts actually matched to this invoice.
• Open balance: invoice amount minus valid applied payments and credits.
• Status and days overdue: sent, partially paid, paid, overdue, disputed or voided.
• Last action and next follow-up: when someone contacted the customer and what should happen next.

If you manage multiple crews, add the responsible team member or job supervisor. If you bill commercial properties, add a purchase-order number and the manager's approval contact. Keep sensitive payment credentials out of the tracker; transaction references are enough.

Worked example: three contractor jobs and $970 overdue

Assume today is November 3, 2026. A small service business has the following invoice records. Job JOB-1042 was a $1,750 project: the customer paid a $500 deposit before the final invoice, leaving a $1,250 final bill. After the invoice was issued, a further $700 was applied, so that final invoice's open balance is $550. A second job has an unpaid $420 invoice; a third invoice is not due yet.

JOB-1042 is 14 calendar days past due, and JOB-1043 is five days past due. The overdue total is $550 + $420 = $970. JOB-1044's $750 is outstanding but not overdue. The combined open receivable in this example is $1,720, of which $970 is past due. Your report should show those figures separately so you do not chase a customer before payment is due.

The $500 deposit for JOB-1042 must already have been applied in determining the $1,250 final bill. Do not subtract it again from the $550 open balance. If you instead issue one full $1,750 invoice and apply all $1,200 of customer payments to that invoice, the open balance is also $550; use one consistent accounting method rather than mixing the two.

Calculate days overdue and aging buckets correctly

Use calendar days unless your contract and reporting convention explicitly define a different basis. An invoice due on October 20 is 14 days overdue on November 3. An invoice due November 10 is not overdue, even if its amount remains unpaid. A robust formula is:

Days overdue = maximum of 0 and (report date − due date), but only while the invoice has an open balance and is not voided. In a spreadsheet where the due date is column E and balance column D, an example formula is =IF(D2<=0,0,MAX(0,TODAY()-E2)). If your software stores timestamps, use a consistent business time zone and date-only comparison so an invoice does not shift buckets during an overnight batch.

Common aging buckets are current, 1–30 days, 31–60 days, 61–90 days and over 90 days past due. The report date matters: do not present an old export as today's balances. Also distinguish customers who formally dispute a charge from customers who simply have not responded.

Why job-number tracking is better than invoice-number tracking alone

An invoice number tells you which financial document you are discussing; a job ID tells you what work it represents. That lets you answer customer questions without reading a dozen unrelated invoices. You can open the job record and see the signed estimate, deposit, completion notes, approved change orders, invoices and payments in one place.

For a handyman who visits the same landlord's four rental homes, each property service call should have a distinct job reference. For an HVAC replacement with several agreed milestones, the related invoices can share one project job ID. For monthly maintenance, your job identification model might be a contract ID plus an individual visit or billing-period ID. Choose a scheme that stays stable when employees change.

Do not rely only on invoice titles such as “September work.” That text can be duplicated across accounts and properties; a unique searchable identifier is much more reliable.

Keep original invoices, deposits and final balances separate

Three money concepts are easy to confuse. The approved job value is the agreed price for the scope. The customer payments received may include a pre-work deposit and later installments. The invoice open balance is what remains owed on a specific financial document after applying the correct payments or credits.

A customer could truthfully say “I paid $500 already” while still owing $550 on the final bill. Your reminder should acknowledge the prior deposit instead of saying no payment was ever made. Before following up, review how to show a paid deposit on the final invoice and how to reconcile invoices to payments.

If a processor has received the payment but not paid out to your bank, that is a different status. Do not send a past-due reminder merely because a bank deposit has not arrived; first check the actual customer transaction and whether it has been applied to the invoice.

Design a daily overdue-invoice worklist

A good worklist should be actionable, not a spreadsheet full of red cells. Sort by status, age, balance and the presence of unresolved disputes. For each job, display the amount due, customer contact, last message date, promised payment date if any, and the next appropriate step.

For example, a five-day-overdue $420 service invoice may need one courteous reminder with a secure payment link. A $550 balance 14 days overdue may need confirmation that the customer's deposit and final balance were explained properly. A 60-day-old commercial invoice may need the purchase order or manager's approval traced before sending another generic email.

Use a named owner for each follow-up—especially when office staff, estimators and field technicians all contact customers. Duplicated reminders from three different team members can create confusion and erode trust.

Sample follow-up sequence for an undisputed invoice

There is no universal legal or commercially appropriate collection schedule, but a calm, documented sequence can help:

1. Before due date: verify delivery and send a courtesy reminder if the customer agreed to reminders.
2. Shortly after due date: mention invoice number, job reference, actual open balance and secure payment instructions.
3. Later follow-up: ask whether an administrative problem, billing question or dispute is preventing payment.
4. Escalation: check the signed agreement, applicable law and the value of the balance before considering a formal demand or professional collection assistance.

For JOB-1042, a message might say: “Our records show $550 outstanding on INV-2210 for job JOB-1042 at [address], due October 20. We have recorded your earlier deposit and partial payment. Please use the original secure invoice link or let us know if you see a discrepancy.” This is more precise than an automated “You still owe $1,750” message that ignores money already received.

How to handle disputed, partially paid and promised payments

A disputed invoice deserves a review rather than a stream of escalating reminders. Identify the line item questioned, gather the original estimate and completion record, and respond with the facts. If the amount changes by agreement, create a properly documented correction or credit. Preserve the original record rather than silently rewriting history.

A partially paid invoice should continue to show its remaining balance and the dates of payments applied. If a customer promises payment on Friday, record the promised date without treating it as a completed transaction. Confirm through the appropriate payment record once it arrives.

For repeat commercial customers, you may need to submit a purchase-order reference, W-9, completion proof or other approved documentation before their accounts-payable team processes the invoice. Treat that as a workflow problem to solve rather than immediately labeling the payer unreliable.

Spreadsheet workflow when you are not using billing software

Create one row per invoice with the columns described above. Use unique IDs, protect completed invoice numbers from being reused, and avoid overwriting payment dates. If a job produces three invoices, use three rows with the same job ID. A separate payments table with transaction reference, date, amount and related invoice number is safer than squeezing several installments into one comment cell.

Keep at least one reference to source documents—estimate, final invoice and customer approval. For recurring jobs, include the service period in each invoice. If you sort the sheet to create a worklist, ensure the formulas and linked records still match the correct customer.

Back up the records and restrict access to people who need customer billing information. Do not store complete card numbers, bank passwords or other sensitive credentials in an ordinary workbook.

What an invoicing dashboard should show

The most useful dashboard highlights total open invoices, total past due, age of past-due amounts, partially paid invoices, disputed invoices and the next follow-up actions. A trend view can show whether 1–30-day overdue balances are growing faster than paid invoices. A job-level filter lets the owner compare bills with the completed scope.

Do not present a large green “collected” number when payments are merely pending. If your business accepts online payments, keep customer payment status separate from processor settlement and actual bank payout. Our payment-to-bank guide explains why a customer-paid invoice and your bank balance can legitimately differ.

Late fees, liens and formal collections need extra care

An unpaid invoice does not automatically authorize any late fee you choose. Review your contract and applicable consumer, business and state law before charging interest or penalties. Contractor lien rights can involve strict notice, licensing and filing deadlines that vary by jurisdiction; do not assume this generic guide creates a right to file a lien.

Avoid threatening customers or disclosing their debt to unrelated people. If the claim is significant or disputed, obtain appropriate professional guidance. Clear invoices, signed scope changes and a documented payment history make any next step more defensible than relying on an angry reminder message.

Weekly contractor receivables review

• Reconcile newly received customer payments against the correct invoice numbers.
• Confirm deposits were applied once, not twice.
• Separate overdue invoices from balances that are not yet due.
• Filter by job ID to review notes, estimates and completed work.
• Assign an owner and next follow-up date to each actionable overdue balance.
• Hold disputed items for appropriate review rather than blind escalation.
• Match processor payouts to the bank without confusing them with customer payment dates.
• Archive paid and voided invoices with an audit trail.

A small weekly review is usually more useful than a once-a-quarter scramble when unpaid bills have become difficult to explain.

Frequently asked questions

Can one job have more than one invoice?

Yes. Progress billing, deposits and final invoices may create multiple financial records under one job ID. Each invoice should still have its own unique identifier and a clear relationship to the job.

Should I send a reminder if a customer paid a deposit?

Only for a valid remaining balance that is due. Acknowledge earlier payments and make sure the final invoice reflects them accurately.

Does “overdue” mean the payment has not reached my bank?

No. A customer can have completed payment even while the processor's payout remains pending. Check the customer transaction, not just the bank deposit, before labeling the invoice overdue.

How do I track invoices for multiple properties?

Store the service address and separate job ID for each location. Use the customer's preferred purchase-order or property reference when available.

What is an aging report?

It groups unpaid receivables by how long they are past due, typically separating current invoices from 1–30, 31–60, 61–90 and older overdue balances.

Make every overdue balance traceable to a real job

The best receivables tracker does not just identify who owes money. It answers which job created the charge, what the customer approved, what they already paid and which action should happen next. If you would rather organize those records around connected estimates, invoices and customer details, explore ProInvoice and the ProInvoice contractor billing guides.

Reference perspective: QuickBooks' general invoice tracking guide covers core statuses and reporting; this article focuses on the contractor-specific job-ID relationship and worked receivables reconciliation.