# Formula And Example For How To Calculate Accounts Payable How to calculate accounts payable with the three-input roll-forward formula, then validate the balance against your subledger and GL for a defensible close. **URL Source:** https://www.brex.com/spend-trends/accounting/how-to-calculate-accounts-payable --- How to calculate accounts payable using the right formula ### Introduction Controllers can calculate the accounts payable (AP) formula quickly, but applying it to a real ledger takes judgment. At close, invoices sit in multiple states, and ERP sync gaps can leave the balance sheet showing one figure and the aging report another. Getting the number right is what makes it defensible to your CFO and auditors, because AP errors flow into current liabilities, working capital, and operating cash flow. The ending AP balance starts with three inputs that trace to source records. It has to tie to both the balance sheet and the cash flow statement before it holds up under review. The AP subledger, summarized in [accounts payable reporting](https://www.brex.com/spend-trends/accounting/accounts-payable-reporting), provides the vendor-level detail that should support the reported balance. The controls that address common [accounting reconciliation](https://www.brex.com/spend-trends/accounting/accounting-reconciliation) breaks matter as much as the formula itself, since the same tie-outs that anchor the [financial close process](https://www.brex.com/spend-trends/accounting/financial-close-process) become the audit workpapers auditors will request. Use the information below to help inform your decision, and consider working with an appropriate professional advisor based on your specific circumstances. ### How to calculate accounts payable The standard roll-forward formula calculates ending AP from three inputs. Using the same three inputs each period lets your team reconcile the roll-forward to source records before reporting. The standard roll-forward formula is: Ending AP = Beginning AP + Credit purchases − Supplier payments For example, a company begins the period with $45,000 in AP, posts $30,000 in credit purchases, and pays suppliers $35,000. The company ends the period with $40,000 in AP. Each input generally trace to a specific source record, and pulling the wrong report can produce a balance that may not tie to the ledger. Tracing beginning AP to the prior period’s reconciled balance Beginning AP is the closing AP balance from the prior period’s reconciled trial balance or GL control account. The ending balance of one period becomes the beginning balance of the next, so an error in one close compounds forward into later periods. The figure is only reliable if the prior period went through [accounts payable reconciliation](https://www.brex.com/spend-trends/accounting/accounts-payable-reconciliation) and the controller signed off on it. In a [multi-entity accounting](https://www.brex.com/spend-trends/accounting/multi-entity-accounting) structure, teams tend to pull beginning AP by entity before consolidating. A consolidated figure can hide an entity-level break, such as one subsidiary’s uncleared vendor invoice, that surfaces later as an intercompany mismatch. Entity-level validation keeps the roll-forward from masking the exact place where the error started. Isolating credit purchases from total period expenses Credit purchases cover the invoices posted to the control account during the period, including vendor invoices and AP-posted adjustments such as vendor credit notes netted against them or invoice reversals. Expenses booked directly to the GL without an AP entry generally stay out, and so do payroll and taxes payable, which live in separate liability accounts. A common input error is pulling total expenses for the period instead of the transactions that specifically affect the payables control balance. Those two figures diverge whenever spend bypasses AP, and the difference can break the formula and send reviewers looking for a non-existent vendor issue. Matching supplier payments to cleared AP disbursements The payment register is the usual starting point, with cleared disbursements confirmed against the cash-disbursement journal or bank reconciliation report. The cash-disbursement journal is the accounting log of payments made from cash accounts. The input covers only disbursements that cleared the AP account through [ACH payments](https://www.brex.com/spend-trends/business-banking/ach-payments), wire transfers, checks, or virtual cards. Payroll runs, tax remittances, and direct GL journal entries that bypass the AP subledger generally don’t belong in this input. Including non-AP cash outflows subtracts too much from the roll-forward and understates ending AP. An understated AP line carries into current liabilities, so completeness testing typically focuses on missing obligations. ### How to calculate average accounts payable Average accounts payable smooths out the roll-forward’s ending balance into a figure that supports the turnover and days-payable ratios later in this article. The formula is Average AP = (Beginning AP + Ending AP) / 2. Using the earlier example, a company with $45,000 in beginning AP and $40,000 in ending AP has an average AP of ($45,000 + $40,000) / 2, or $42,500. Both figures come from the same reconciled period-end balances used in the roll-forward, since an unreconciled starting or ending balance skews every ratio built on top of it. ### How ending AP connects to financial statements On the balance sheet, ending AP flows directly to the accounts payable line under current liabilities. The reported figure should tie to the control balance, which in turn ties to the vendor subledger total. A gap anywhere in that chain means one layer needs investigation before you report the balance. On the cash flow statement, the period-over-period change in AP appears as an [operating cash flow](https://kpmg.com/kpmg-us/content/dam/kpmg/frv/pdf/2026/statement-cash-flows.pdf) adjustment. An increase in AP is a source of cash because the company paid out less than the obligations it incurred, and a decrease is a use of cash. Balance sheet and cash flow tie-outs support the completeness of the calculation, and the same relationship between AP movement and cash underpins AP forecasting for [corporate cash management](https://www.brex.com/spend-trends/business-banking/corporate-cash-management). ### How to validate your accounts payable balance A calculated balance still needs proof before it goes on the balance sheet. Controllers usually run the checks below before finalizing AP each period. Each check catches a different failure mode, such as a missing accrual or a cutoff error. Tying the AP subledger to the GL control account This check compares the vendor subledger total, meaning the sum of open vendor balances on the aging report, against the GL AP control account balance as of the same period-end date. In a properly configured close, the two typically agree before you certify the close. When they diverge, the layer where the break occurred points to the cause. Common causes could be a direct journal entry to the control account, an unposted subledger transaction, or an intercompany entry routed to the wrong entity. Timing matters. Running either report as of the current date lets post-close activity, such as a payment that clears the next morning, contaminate the comparison and mask a break that belongs to the period you’re certifying. Reconciling the AP aging report to the balance sheet The AP aging report buckets open invoices by how long they’ve been outstanding, into current, 30-day, 60-day, and more than 90 days. The recorded total across buckets should equal the payables control balance on the balance sheet. Differences often trace to timing issues, unapplied vendor credits (credits that haven’t been matched to an invoice or payment), or heavily aged items that may no longer be valid obligations. A heavy balance in invoices more than 90 days outstanding signals entries to investigate before you report the balance. A stale open item may be a miscoded payment or a genuinely unpaid bill, and each calls for different handling. Checking for invoices in mixed states The standard formula assumes an invoice is recorded or paid. At close, invoices sit in several different states. They can be received and approved but unpaid, received but not yet approved, partially paid, or disputed. Each state generally requires a documented treatment under the company’s accounting policy and applicable standards, and that treatment must remain consistent from one period to the next. Companies generally record or accrue received-but-not-yet-approved invoices in the period in which the goods or services are received, subject to their accounting policy and applicable standards. Approval is an internal control over authorization, and it doesn’t change when the [expense recognition principle](https://www.brex.com/spend-trends/accounting/expense-recognition-principle) says the obligation was incurred. If the invoice isn’t in the subledger, AP may be understated, so controllers commonly record it or accrue the liability before closing. Partially paid invoices keep the unpaid portion in AP, and the open remainder continues to age until cleared. Confirming that the AP team applied the payment to the correct invoice matters, since a misapplied payment distorts both the vendor balance and the aging. Disputed invoices need a documented policy. The policy can accrue while the dispute is open or hold the item outside AP pending resolution, depending on the facts and applicable accounting framework. The chosen treatment applies the same way in the first quarter as it does in the fourth. The Public Company Accounting Oversight Board (PCAOB) treats inconsistent treatment across periods as a [comparability problem](https://pcaobus.org/oversight/standards/archived-standards/details/AU420B). A dispute over the amount generally doesn’t erase a contractual obligation once goods or services have been received. Companies commonly evaluate whether an accrual is appropriate based on the facts, their accounting policy, and the applicable reporting framework. Consult a qualified accounting professional for specific treatment decisions. Accrue for GRNI obligations not yet invoiced Goods received not invoiced (GRNI) obligations can arise when a company receives goods or services, but no supplier invoice has been posted yet. For example, a subscription renewal that a vendor delivered in December but doesn’t invoice until January creates a GRNI obligation for December. The liability exists even though nothing shows in the subledger. A GRNI accrual records the estimated liability in the period the goods or services were received, then reverses the following period when the actual invoice posts to AP. Controllers who skip the accrual can understate current liabilities and overstate net income for the period. At the audit, the directional risk for payables is understatement. The American Institute of Certified Public Accountants (AICPA) auditing standard [AU-C 330](https://www.aicpa-cima.com/resources/download/aicpa-statements-on-auditing-standards-currently-effective), part of its clarified auditing standards, directs auditors to respond to assessed risks with targeted procedures. For AP, the assessed risk is missing obligations, so auditors test [completeness for payables](https://pcaobus.org/oversight/standards/auditing-standards/details/AS1105), whereas they test asset accounts for existence instead. Before closing AP each period, controllers commonly run the GRNI open items report in ERP software such as [NetSuite ERP](https://www.brex.com/spend-trends/accounting/netsuite-erp). They then accrue received-not-invoiced lines with [T-accounts](https://www.brex.com/spend-trends/accounting/t-accounts), the debit-and-credit view of an accounting entry, by debiting the expense or asset account and crediting the accrual liability. That entry gives reviewers a clear trail from receipt to accrual to invoice reversal. Reconcile operational AP views against the financial record AP operations teams often work from a tool that shows invoices as awaiting approval, in transit, or scheduled for payment. The operational views may not match what’s recorded in the GL. Comparing the operational queue to the accounting record can turn workflow status into close evidence. An invoice that shows as open in the AP tool with no GL record could mean an unrecorded liability. That mismatch can arise when invoice capture software and ERP posting run in separate tools, or when a bill payment fails silently between systems. Brex customers can see failed bill payments surfaced directly on the Bills page and by email, with guidance on what to fix and retry. Brex syncs bills to supported ERP integrations at bill creation or approval, depending on configuration. In any AP automation setup where capture and posting live in different tools, the comparison becomes a standing close step. Controllers commonly record or accrue any open invoice that lacks a subledger entry before the period closes. ### Accounts payable best practices for a defensible close A defensible AP balance depends on a handful of close-period habits as much as it depends on the formula itself. Each practice below targets a specific way the balance can drift, toward either an overstatement or an understatement. Building these checks into every close catches the drift before it reaches the balance sheet. A fuller rundown of these habits lives in [accounts payable best practices](#). Checking for duplicate invoices before every close A duplicate check before closing AP matches on vendor, invoice number, amount, and date. Duplicate delivery is more common than fraud, such as when the same invoice arrives via both email and the vendor portal. A [duplicate invoice entry](https://www.apqc.org/resource-library/resource-collection/understanding-accounts-payable-benchmarks-and-best-practices) inflates credit purchases and overstates the ending AP. Manual entry error is another common source, especially when a vendor resends an invoice after a payment inquiry. Teams void or reverse confirmed duplicates before finalizing the balance. Validating invoice numbering at entry, automating duplicate detection, and matching invoices on PO-backed purchases are the upstream habits behind [preventing duplicate payments in accounts payable](https://www.brex.com/spend-trends/accounting/prevent-duplicate-payments-in-accounts-payable), and [invoice matching](https://www.brex.com/spend-trends/accounting/invoice-matching) against the purchase order catches most of the rest before they reach the ledger. Reviewing for unrecorded liabilities every period A subsequent-payments review catches obligations incurred during the period that never entered the AP subledger. An unrecorded liability understates AP and overstates net income, the same completeness failure the GRNI review targets. The review traces each post-period payment back to whether the company recorded the liability in the correct period. Obligations that crossed the cutoff unrecorded get catch-up accruals. A controller who has already run this test has ready support when auditors ask for evidence of a completeness search over post-period invoices and payments. Setting and communicating a hard cutoff date Teams can set a hard cutoff date for AP entries each period, recording each invoice with a receipt or service date on or before the cutoff in that period. A cutoff error records an invoice or payment in the wrong period. For example, an invoice for December goods posted in January understates December AP, while a payment that cleared in December but posted in January overstates it. When the invoice hasn’t arrived but the obligation exists, the accrual goes in and reverses once the invoice posts. [Aligning department leaders on the cutoff](https://www.ledge.co/content/month-end-close-process-and-best-practices) ahead of the month-end close keeps late submissions from turning into period errors. Restricting direct journal entries to the AP control account Journal entries posted directly to the GL payables control account move the GL balance without updating vendor details. The control account and the aging report then show different totals, and the tie-out breaks. Restricting direct journal entries to the control account keeps this from happening. AP adjustments run through the subledger instead, as a credit memo, an invoice reversal, or a properly coded entry that updates both records at once. A pattern of frequent direct entries signals a [control weakness](https://pcaobus.org/oversight/standards/auditing-standards/details/AS2401). Tightening posting access is worth documenting in the control file, alongside the other habits covered above. ### Accounts payable turnover and days payable outstanding A validated AP balance also feeds two ratios your CFO may ask about. The turnover ratio measures how often the company pays down its payables, and days payable outstanding (DPO) converts that rate into days. Both draw on the average AP figure calculated earlier in this article. A fuller set of related [accounts payable metrics](https://www.brex.com/spend-trends/accounting/accounts-payable-metrics) can round out the picture for your close checklist. Calculating the accounts payable turnover ratio The AP turnover ratio measures how many times a company pays off its average AP balance in a given period. It answers whether the company is paying vendors in line with stated payment terms or whether AP is building up faster than purchasing activity explains. The ratio equals net credit purchases divided by average AP. Net credit purchases, or total credit purchases minus returns and allowances, work better here than cost of goods sold (COGS), which only matches the cost of purchases when inventory levels hold steady. A higher ratio means the company pays suppliers faster, and a lower ratio means it pays more slowly, though neither is inherently better on its own. The trend across consecutive periods, compared against industry peers, may tell more than a single reading. A sudden drop can flag a cash flow problem or an invoice backlog before it surfaces elsewhere. Calculating days payable outstanding DPO translates the turnover ratio into something more intuitive, the average number of days a company takes to pay suppliers after receiving an invoice. For example, a DPO of 34 means a company pays invoices, on average, 34 days after receipt. DPO equals average AP divided by net credit purchases, multiplied by 365, or alternatively, 365 divided by the AP turnover ratio. No single DPO benchmark applies across industries. The figure varies by industry, competitive position, and supplier relationships. A company with strong negotiating power can extend days payable outstanding to preserve cash, while a company with fewer supplier options might pay faster to maintain vendor goodwill. DPO means the most against industry peers, and a sharp move in either direction could be a prompt to find out what changed. ### Get your accounts payable calculation close-ready Calculating AP takes minutes when the prior close is reconciled and period activity is clean. The bigger consequence is reporting confidence, because the AP number affects current liabilities, working capital, and operating cash flow. That confidence comes from catching breaks before the balance is reported, not after. Many finance teams use the roll-forward calculation as the backbone of the close, since it forces every other AP figure to reconcile against it. The subledger-to-GL tie-out often happens early in the close rather than at the end, because differences are still easy to trace back to their source when they're caught early. Teams can use [AP automation](https://www.brex.com/spend-trends/accounting/ap-automation) to connect invoice capture, approvals, ERP posting, and payment evidence. Brex customers can detect duplicate invoices, match purchase orders automatically, and capture itemized invoice line items using AI, through Brex bill pay, and can sync bills to supported ERPs, depending on configuration. Brex’s [corporate card](https://www.brex.com/product/credit-card) runs on the Mastercard network depending on the card program, carries no annual fee, and doesn’t require a personal guarantee. Business-metrics underwriting can support credit limits up to 30x higher than a traditional card. Bills paid through Brex can settle from a [Brex business account](https://www.brex.com/product/business-account), keeping AP disbursements and cash visibility in the same platform. Brex product availability, supported ERP integrations, and payment methods vary by customer and configuration. Card terms, approvals, and limits depend on the issuer and the full underwriting review, and customer experiences vary as well. Approval decisions and limits aren't guaranteed. _Created with AI assistance and reviewed by Brex. This article reflects Brex's perspective at the time of publication and is intended for general informational purposes only. It is not intended as legal, tax, accounting, or financial advice. Laws, regulations, and guidance may vary based on your specific circumstances, and interpretations or outcomes may differ. Information may also change over time. Before making any decisions, you should consult your own qualified legal, tax, accounting, or financial advisors._ ## FAQs about calculating accounts payable ### What is the formula for accounts payable? Ending AP equals beginning AP plus credit purchases minus supplier payments. Beginning AP is the prior period’s closing GL balance. Credit purchases are the invoices posted to the AP control account during the period, and supplier payments are the disbursements that cleared the AP account. An error in any input flows straight into the balance sheet. ### How do you calculate average accounts payable? Average accounts payable equals the sum of beginning and ending AP, divided by 2. The figure is the denominator in the AP turnover ratio and feeds days payable outstanding. Both inputs typically come from reconciled period-end GL balances, because an unreconciled starting or ending balance skews the ratios and can make vendor payment trends look better or worse than they are. ### What’s the difference between accounts payable and accrued liabilities? Accounts payable represents a supplier invoice with a known, exact amount. [Accrued liabilities](https://corporatefinanceinstitute.com/resources/accounting/accrued-expenses-vs-accounts-payable/) are costs a company has incurred but hasn’t yet received a bill for, so the amount is an estimate until the invoice arrives. Once that invoice posts, the estimated accrual reverses, and the exact amount moves into accounts payable. ## Related Articles ### [The complete guide to invoice matching](https://www.brex.com/spend-trends/accounting/invoice-matching) Manual invoice processing creates costly bottlenecks and fraud risks. Learn about different matching types, implementation strategies, and how automation can improve accuracy and reduce errors. ### [11 accounts payable best practices your AP team should know](https://www.brex.com/spend-trends/accounting/accounts-payable-best-practices) Learn 11 accounts payable best practices that will transform your financial operations. From automation to compliance, enhance your AP process today. ### [What is Sage Intacct and how does it work?](https://www.brex.com/spend-trends/accounting/sage-intacct) Learn how the Sage Intacct works, understand its benefits, and discover how different types of organizations use it to transform their financial operations. ### [Trade Payables vs Accounts Payable For Controllers](https://www.brex.com/spend-trends/accounting/trade-payables-vs-accounts-payable) Controllers who separate trade payables from the AP balance keep DPO comparable, and simplify audit disclosures. ### [What is multi-entity accounting and how does it work? ](https://www.brex.com/spend-trends/accounting/multi-entity-accounting) Multi-entity accounting allows businesses to track and manage financial data across multiple subsidiaries. Learn how to implement this accounting practice. ### [The complete guide to accounts receivable aging reports](https://www.brex.com/spend-trends/accounting/accounts-receivable-aging-reports) Stop chasing late payments and take control of your accounts receivables. Learn how aging reports can transform your collections process & boost your cash flow.