For small‑business owners and finance teams, getting the accounts payable (AP) balance right is essential. A precise AP figure protects the integrity of the balance sheet, supports cash‑flow forecasting, and satisfies auditors. This guide walks you through the three‑input roll‑forward formula, explains where each number comes from, and highlights the key controls that keep the calculation defensible.

Three inputs that drive the ending AP balance

The standard roll‑forward formula is simple:

Ending AP = Beginning AP + Credit purchases – Supplier payments

Using the same three inputs each period lets your team reconcile the roll‑forward to source records before reporting. Below is a quick example: a company starts the period with $45,000 in AP, records $30,000 in credit purchases, and pays suppliers $35,000. The ending balance is $40,000.

Where each input originates

Beginning AP comes from the prior period’s reconciled trial balance or general‑ledger (GL) control account. The closing balance of one period becomes the opening balance of the next, so any error compounds forward. In multi‑entity structures, pull the beginning balance by entity before consolidating to avoid hiding an uncleared invoice at a subsidiary level.

Credit purchases represent all invoices posted to the AP control account during the period, including vendor credit notes and invoice reversals. Expenses booked directly to the GL without an AP entry—such as payroll or tax liabilities—stay out of this input. A common mistake is using total period expenses instead of the AP‑specific transactions, which will break the formula.

Supplier payments are taken from the payment register, confirmed against the cash‑disbursement journal or bank reconciliation. Only disbursements that cleared the AP account—ACH, wire, check, or virtual‑card payments—belong here. Payroll runs, tax remittances, and direct GL journal entries that bypass the AP subledger must be excluded; otherwise the ending AP will be understated.

Average AP and its role in financial ratios

Once you have beginning and ending balances, calculate average AP:

Average AP = (Beginning AP + Ending AP) / 2

Using the example above, average AP is ($45,000 + $40,000) / 2 = $42,500. This figure feeds the accounts‑payable turnover and days‑payable‑outstanding ratios that analysts use to assess working‑capital efficiency.

Key reconciliation checks before finalizing AP

• Subledger vs. GL control account: Compare the total of open vendor balances on the aging report to the GL AP control balance as of period‑end. Any divergence points to a direct journal entry, an unposted subledger transaction, or an intercompany posting error.
• AP aging report vs. balance sheet: The aging buckets (current, 30‑day, 60‑day, >90‑day) should sum to the AP control balance. Discrepancies often stem from timing issues, unapplied vendor credits, or stale invoices that may no longer be valid obligations.
• Invoice state review: At close, invoices may be received but not approved, partially paid, or disputed. Ensure each state is documented according to company policy and that any unapproved but received invoices are accrued so the liability is not omitted.

Impact on the cash‑flow statement

Changes in AP appear as an operating cash‑flow adjustment. An increase in AP is a source of cash because the company has incurred expenses without yet paying them; a decrease uses cash. Accurate AP reporting therefore supports reliable cash‑flow forecasting and corporate cash‑management decisions.

Best practices for a defensible AP close

• Run reports as of the same period‑end date to avoid post‑close activity contaminating the comparison.
• Document any manual journal entries that affect the AP control account.
• Perform entity‑level validation before consolidating multi‑entity balances.
• Maintain a clear audit trail linking each input back to its source document.

By following these steps and controls, controllers can produce an AP balance that stands up to CFO review and external audit, while also providing the accurate data needed for sound working‑capital management.

Original reporting: El Paso News (HLL/CB) — read the source article.