What your accounts payable total is hiding from you

A wholesale food distributor we work with owed $19,900 to four vendors at the end of June. The bookkeeper reported that total every month. No one reviewed the breakdown behind it. Three of the four vendors were current. The fourth, a packaging supplier handling 30 percent of monthly order volume, had not been paid in 51 days. That supplier sent one notice and converted the account to prepayment-required two weeks later.

The total was accurate. The risk behind it was not being tracked.

What the AP aging report actually shows

Accounts payable (AP) is the total of what a business owes to vendors and suppliers. The AP balance tells you the dollar amount outstanding. The AP aging report breaks that number into time columns: what is current, what is 1 to 30 days past due, what is 31 to 60 days past due, and what is past 60 days. Most accounting software generates the aging report in under a minute. Most businesses pull it quarterly, if at all.

Several gaps cause the aging to misrepresent actual exposure even when the total balance looks right.

Bills entered without due dates. When a vendor invoice is posted in QuickBooks without a due date, it appears in the total balance but cannot be placed in any aging column. The software has no way to calculate how late a bill is without a due date on file. A business can show $8,000 in accounts payable while the aging report shows nothing overdue because no bills were entered with due dates assigned.

Payments applied to the vendor, not to individual invoices. A payment posted “on account” closes the oldest open invoice automatically, not necessarily the one the owner intended to clear. When a disputed invoice is the oldest on file, that payment may close it while leaving a current, undisputed invoice open and continuing to age past its due date.

Expenses recorded only when paid. Some businesses log vendor costs at the time of payment rather than when the bill arrives. In that workflow, accounts payable is always zero and aging is not possible. There is no visibility into what is owed or when it is due until the vendor sends a notice.

Vendor terms not updated after a change. Suppliers sometimes tighten terms from net-60 to net-30 after a late payment without sending a formal letter. If QuickBooks still shows the original terms, invoices from that vendor will appear current in the aging when they are already overdue by 30 days.

What the aging looked like in practice

Here is what the AP aging showed for the food distributor above, as of June 30.

The balance was $19,900. Reported as a single number, it looked manageable. The aging showed that $7,500 of it was past due, including $5,100 owed to the packaging supplier. That vendor changed terms two weeks after the 51-day mark. Had someone reviewed the aging at 30 days past due, the payment could have gone out before any notice was sent.

Why this matters

Vendor terms erode without warning. Net-30 and net-60 terms are extended based on payment history, not on contract language. A supplier watching invoices age past 60 days will typically send one notice and then convert the account to prepayment-required. For a business buying materials or services from that vendor regularly, losing credit terms disrupts operations at exactly the moment cash is already tight. The cost of that disruption often exceeds the past-due amount that caused it.

Early payment discounts expire unnoticed. Many vendors offer a 2 percent discount if an invoice is paid within 10 days of the issue date, often written as “2/10 net 30” on the invoice itself. On a vendor relationship with $60,000 in annual spend, that is $1,200 per year in savings. The window closes in 10 days. Without a weekly AP review, those windows close without anyone noticing.

Cash flow planning uses the wrong horizon. The AP total tells you what you owe. The aging tells you when it is due. A business planning outflows from a total balance alone may underestimate what has to go out in the next two weeks and overspend elsewhere in the same period.

What proper accounts payable management looks like

For the clients we work with, the AP aging report is a weekly review item, not a monthly one. The bookkeeper runs the report every Monday, identifies any invoice approaching 30 days past due, and flags it for the owner before it crosses into the next aging column.

Every vendor bill is posted in QuickBooks within 24 hours of receipt, with the correct payment terms and due date recorded. If the terms on the incoming invoice differ from what the vendor record in QuickBooks shows, the discrepancy is flagged before the bill is posted. Vendor records are checked once a year to confirm that the terms in the system match what each vendor is currently extending.

Payments are applied to specific invoice numbers, not to the vendor account in general. A general payment reduces the vendor balance but does not close the individual invoice in the aging. It will continue to appear as overdue until matched to the specific bill it was meant to cover.

Best practices for tracking accounts payable

• Enter every vendor bill on the day it is received, with the correct due date. A bill with no due date will not appear in any overdue column, regardless of how old it is.
• Run the AP aging report weekly. An invoice 35 days past due can be cleared with a payment and a brief acknowledgment. At 90 days, the conversation with the vendor may need to happen before terms are restored.
• Confirm vendor payment terms in QuickBooks against the most recent invoice from each vendor, at least once a year. Terms change after late payments, and the vendor record in the system rarely updates on its own.
• Before approving payment on large invoices, check for early payment discount terms. A 2 percent discount on a $10,000 invoice is $200 in savings with a 10-day expiration.
• Apply all payments to specific invoice numbers. A payment posted to “Vendor X” closes the vendor balance without closing the individual invoice in the aging report.

Three questions worth asking

1. What is the total dollar amount in your AP aging that is more than 30 days past due, and have you received any notices or change-in-terms communications from those vendors in the past 60 days?
2. How many vendor bills in your QuickBooks have no due date assigned, and does your bookkeeper enter bills when they are received or only when they are paid?
3. On your three largest vendor accounts by annual spend, have payment terms changed in the past two years, and does QuickBooks reflect those current terms?

If those answers are uncertain, the aging report is not accurately reflecting your payable exposure. The correction is a change in how bills are entered and how vendor terms are maintained in the system.

If you want to see where your payable position actually stands, send us your current AP aging report from QuickBooks. We will review whether the bills are being aged correctly, which vendor accounts are at term risk, and whether any early payment discount windows are worth capturing before they close.