An accounts receivable aging report shows which issued invoices still have an unpaid balance and how far each one is past its due date. For a home-service office, the practical question is not just “How much is open?” It is “Which invoice needs a records check, a customer update, or an owner decision today?” The blank spreadsheet and browser worksheet below group open balances into Current, 1–30, 31–60, 61–90, and 91+ days. They are administrative planning tools, not a substitute for your accounting system.
Download the blank aging spreadsheet
Download the Excel template The workbook starts blank, with room for 100 invoices. Enter a report date on the first sheet, then copy each invoice's number, customer reference, issue date, due date, original amount, and payments or credits applied as of that report date. The formulas calculate the remaining balance, days overdue, and one aging bucket. No real customer data is supplied.
Use a customer reference that your office can reconcile to the approved billing system. Avoid putting payment-card details or unnecessary personal information into a downloaded worksheet. Store the completed file where your company keeps billing records, with access limited by your own policy. If an invoice has no due date or a disputed balance, resolve the record in the source system before treating this template's bucket as authoritative.
What each bucket means
The report date is the “as of” date. In this template, a due date on or after that date is Current; a due date one day earlier is 1–30. The later groups are 31–60, 61–90, and 91 or more days past due. Intuit's explanation of aging columns confirms that aging is based on the transaction due date, while Current is not yet past due and 1–30 is past due by that many days. Intuit also notes that a missing due date can be treated as due upon receipt in QuickBooks; this independent template instead leaves that row unbucketed until the office supplies the actual due date.
Count only the open balance, not the original invoice amount. If an invoice was $800 and $300 was applied by the report date, the aged balance is $500. If a credit fully closes it, its open balance is zero and it does not add to any bucket. The workbook caps the open balance at zero when payments plus credits exceed the entered invoice amount and flags the row for review. That is a record check, not permission to erase or reclassify a customer credit in the accounting system.
Try the aging worksheet in your browser
Enter a report date and one or more illustrative or approved invoice rows. The preview updates locally in this browser; the entries are not sent to Early Bird. You can export a CSV with the entered and calculated columns. The CSV is a snapshot, not a live accounting ledger. It is deliberately not prefilled with fictional customers or supposedly real balances.
Original editable office asset
Invoice aging worksheet
Choose a report date and enter an invoice.
| Invoice | Open balance | Days overdue | Bucket | Office owner | Action |
|---|
No invoices added.
The preview uses this formula for each complete row: open balance = max(0, invoice amount − payments − credits). days overdue = max(0, report date − due date). A zero balance is Closed; a positive balance with a due date on or after the report date is Current; otherwise it enters exactly one overdue bucket. Dates are compared as calendar dates, not by time of day. The downloaded Excel workbook uses the same boundaries. Check the source invoice when a credit exceeds the amount, the due date is missing, or the invoice was issued after the chosen report date.
Pull clean inputs from the billing system
Start with the system your office already uses to issue invoices and post payments. Export or review open invoices as of one report date, then reconcile invoice numbers and balances before copying them here. An invoice amount on its own cannot tell you what the customer still owes. Include payments and credits applied through the same date; otherwise a later payment can make a historical report misleading. A current export cannot automatically reconstruct a prior-date balance if the system does not expose payment history.
Keep service-job context separate from the receivable math. A plumbing return visit, HVAC replacement, electrical permit handoff, or roofing production milestone might explain why an invoice needs an administrative check, but this sheet does not decide technical completion or whether an amount is collectible. Assign a billing owner to reconcile the record, and escalate disputed or unusual items to the person authorized by your company. Do not use bucket age alone to assume the customer is at fault.
Use the report for a weekly office review
First, scan rows marked Review, missing due dates, or missing owner. Fix those records in the billing system. Next, compare bucket totals with the system's own receivables report. A difference may be a timing issue, a credit, a duplicate invoice, a void, or a formula input error. Work from the system of record rather than changing this worksheet until the totals appear comfortable.
Then decide an administrative next action for each open invoice: verify a payment was posted, confirm the recipient received the invoice, answer a documentation question, or ask the owner to decide how to handle a dispute. The aging report is a visibility tool; it is not a collection policy or a promise that a particular follow-up will produce payment. For language after your company has verified an open balance and its communication policy, see the invoice follow-up email templates. This page addresses the separate question of what is open and how old it is.
A small home-service office can maintain this report without new software if it has few invoices and a disciplined reconciliation habit. When volume or handoffs increase, use the accounting platform's own report where possible, with this template as a review aid. The Corporate Finance Institute's published aging template illustrates a broader finance-oriented approach to grouping receivables in 30-day intervals. This version deliberately stays at the office-action level and omits bad-debt estimates or accounting judgments.
Where a dedicated assistant can help
An owner should not have to find the same invoice twice just to answer a routine customer question. A dedicated, full-time executive assistant can maintain the administrative view, check missing records, prepare a clear handoff for the billing decision maker, and keep customer updates from being forgotten. Early Bird maps the full operating scope, systems, people, and approval boundaries during onboarding, then stabilizes one priority workflow at a time with ongoing support. An assistant does not replace your accountant or decide write-offs, credit terms, debt collection, or trade completion.
If the owner still handles scheduling changes and office follow-up while reviewing receivables, the broader assistant responsibility guide can help separate routine coordination from decisions that stay with the owner. The useful boundary here is simple: an assistant can make the records and next step clear; the authorized person decides what the company is owed and how to resolve exceptions.
Common questions
Should a fully paid invoice appear in the aging totals?
No. Keep it out of the open-balance totals. The workbook labels a zero remaining balance Closed, so you can spot an entered row without counting it as receivable.
What if a customer disputes an invoice?
Keep the dispute visible to the billing owner and reconcile the source record. A date bucket describes timing, not the merits of the invoice or the right response.
Can I use this as a historical report?
Only if each amount, payment, and credit reflects what was recorded by the chosen report date. A present-day balance pasted beside an earlier report date is not a reliable historical snapshot.