Dental practice accounts payable aging shows the supplier bills still open on a stated date and how far each is from its contractual due date. Before using it to approve a payment run, reconcile the invoice detail to the payable ledger, verify the aging convention, and separate approved balances from credits, disputes, and payments already in motion.
The result should answer four questions: whom the practice owes, how much remains, when it is due, and what action is authorized. Xero describes aged payables as a report of amounts the business owes and their due dates. Xero's guide to financial reports
Set the boundary before reviewing the oldest column
Record the legal practice entity, included locations, report cutoff, ledger accounts, and preparer. Obtain both the supplier summary and invoice-level detail. A total by vendor can conceal one overdue bill behind a newer credit.
Include the open obligations recorded in the selected payable accounts. Identify bills received but not yet entered and ask the bookkeeper how they belong in the cutoff. An invoice cannot appear in the report if nobody recorded it.
Keep a separate list of commitments that are not posted supplier payables, such as unfilled purchase orders or future contract charges. Payroll, taxes, debt payments, and other obligations may also live outside this report. The aging supports an owner's broader working-capital review, but does not list every future cash requirement.
If the practice maintains cash-basis books without a complete payable ledger, have the accountant define a supplemental unpaid-obligations schedule and its reconciliation. Do not describe an incomplete report as the total amount the practice owes.
Make the aging convention visible
For payment review, use days past the actual due date unless there is a documented reason for another convention. Retain invoice date and receipt date as separate fields. An invoice issued 45 days ago on 60-day terms is different from one that is 45 days overdue.
Intuit explains that QuickBooks aging distinguishes current items from amounts overdue after their due date. Its treatment of missing due dates can also affect the result. Check the selected report's behavior instead of relying on a familiar column heading. Intuit's explanation of current and overdue aging
For the worksheet below, define:
- Current: due on or after the report date.
- 1–30 days: one through thirty calendar days past due.
- 31–60 days: thirty-one through sixty days past due.
- 61–90 days: sixty-one through ninety days past due.
- Over 90 days: at least ninety-one days past due.
Show missing or disputed due dates as exceptions. Obtain the underlying invoice and reviewed contract terms. Never change a contractual due date to make a report look current; record an agreed extension only with supporting evidence and the appropriate accounting review.
Reconcile the report to what is actually recorded
Compare the invoice-detail total with the payable control account for the same entity and cutoff. Match vendor credits, partial payments, and journal entries. Confirm that historical reports use the intended cutoff rather than today's aging date.
When the totals disagree, look for excluded vendors, duplicate supplier records, payments applied to the wrong invoice, entries outside the selected date, or direct postings without vendor detail. Have the bookkeeper resolve the actual cause. A miscellaneous adjustment that makes the totals equal does not establish accuracy.
Use a rollforward as a second check:
Opening payable balance + new bills − applied payments − credits = closing payable balance, adjusted for any other supported entries.
In a hypothetical month, $8,700 + $6,200 − $9,600 − $200 = $5,100. The final aging detail should explain that $5,100 under the same reporting boundary. Preserve the reports before and after approved corrections so the reviewer can follow the changes.
Work through a supplier-aging example
All amounts, vendors, and dates below are fictional. The report is dated September 30, 2026. The table first shows gross open invoices before a separately recorded $200 laboratory credit is applied.
| Supplier obligation | Due date | Open amount | Aging result |
|---|---|---|---|
| Supply order | September 30 | $1,000 | Current; due today |
| Laboratory invoice | September 15 | $2,500 | 15 days; 1–30 |
| Service invoice under dispute | August 15 | $800 | 46 days; 31–60 |
| Maintenance invoice | July 15 | $600 | 77 days; 61–90 |
| Earlier supply invoice | June 15 | $400 | 107 days; over 90 |
| Gross invoice total | — | $5,300 | — |
The laboratory confirms a valid $200 credit, already recorded separately in the payable ledger. Applying it to the identified $2,500 invoice leaves $2,300 owed on that invoice. The net payable total is $5,300 − $200 = $5,100, matching the rollforward.
The $800 dispute remains visible in that $5,100 total while the authorized reviewer determines its accounting and payment treatment. Under the example's approved hold, the remaining invoices total $4,300 for payment consideration. That is not permission to spend $4,300: the payment approver still reviews evidence, cash availability, and obligations outside this report.
Give credits and disputes their own evidence
For a credit, keep the vendor document, amount, reason, related invoice, and application status. Confirm whether it reduces an unpaid bill or represents a refund to be received. Do not subtract the same credit in both the invoice balance and a separate adjustment column.
Intuit's vendor-credit instructions distinguish recording a credit from applying it and tell users to verify the applied amount. That distinction matters even when the practice uses different software. Intuit guidance on vendor credits and refunds
For a disputed invoice, record the exact item, supporting purchase or service evidence, supplier contact, review owner, and next date. A dispute does not automatically cancel the obligation or extend the due date. Check the governing agreement through the vendor contract register and obtain adviser review when needed.
Turn the aging into a reviewed payment list
Start with overdue approved obligations, items due before the next payment run, and any documented service-continuity concern. Investigate old balances before paying them: a forgotten credit, duplicate invoice, or previously issued payment may explain their age.
Show each proposed payment's invoice references, amount, credit applied, approval, intended payment date, and method. Identify automatic debits and payments already submitted so the same bill is not selected twice. If cash is insufficient, have the owner address the shortfall and communicate any proposed arrangement through the approved process.
After release, record the payment reference and confirm its application. Use the separate bank reconciliation process to follow clearing differences. Keep the aging review open for unresolved credits, disputes, missing invoices, and unmatched payments, with a named next action for each.
