Aged Accounts Payable Report

An aged accounts payable report sometimes referred to as an aged creditors report, is used as a management tool to monitor the age of the outstanding payables from supplier or vendor invoices, allowing early action to be taken to ensure good trade credit terms are maintained with suppliers, invoices are paid at the appropriate time, and early settlement discounts are taken whenever possible. In addition the aged accounts payable report can be used to help predict cash flow requirements for future accounting periods.

The schedule of accounts payable is produced by analyzing vendor invoices into several different age classifications based on the number of days the invoice is past its due date. For example, if the invoice is unpaid 27 days after its due date it would be placed in the 1-30 days classification column, or if the invoice was unpaid 55 days after its due date it would be placed in the 31-60 days column.

On the report, a sub-total is drawn showing the aged accounts payable for each supplier, and a total line shows the aged accounts payable for the business as a whole. Finally, a line is added to show what percentage of the total outstanding accounts payable is represented by each age classification. For instance, in the example aged accounts payable report below, the amount outstanding between 1 – 30 days is 2,800, and this represents 2,800/15,700 or 17.8% of the total aged accounts payable.

Aged Accounts Payable Report
Supplier Amount Current 1 – 30 31 – 60 > 60
Invoice 1 2,800 2,800
Invoice 2 5,100 5,100
Supplier A 7,900 5,100 2,800
Invoice 3 1,600 1,600
Invoice 4 2,400 2,400
Supplier B 4,000 2,400 1,600
Invoice 5 2,600 2,600
Invoice 6 1,200 1,200
Supplier C 3,800 1,200 2,600
Total 15,700 6,300 2,800 2,400 4,200
Percentage 100.0% 40.1% 17.8% 15.3% 26.8%

A business will normally produce an aged accounts payable report at the end of each accounting period, although with today’s accounting software they can be produced at any time.

The aged accounts payable example report above shows overdue vendor invoices and may mean that the business is placing too much reliance on supplier credit to fund its business or that cash is not being properly controlled.

Aged Accounts Payable Report November 6th, 2016Team

You May Also Like

Related pages

markup margin tableexamples of deferred tax liabilities and assetsaccounts ledger bookpv of perpetuityprepaid expense meaningreceivable turnover calculatorcontra income accountpetty cash summary templatejournal entry for paying dividendsin consignment sales the consigneecost of capital calculation excelthe accounts receivable ledgerlifo reserve adjustmentsuspense account in trial balanceeffective monthly interest rate calculatorfactory overhead variance analysispresent value of a perpetuity calculatorhow to calculate markup in accountinglifo equationfinancial leverage ratio debt equity ratiohow to calculate predetermined manufacturing overhead ratemcq on accounting with answersunearned subscription revenueyield to maturity excel formulaaccrued expenses vs accounts payablelcm inventorybad debt accounting entryproveit assessment test answersaccruals journal entrieswhy do we prepare bank reconciliation statementfob shipping point means the seller pays cost of freightwip in accountingamortization of prepaid expensesrecording bad debt expense journal entrygeneral ledger t accounts templatehow to calculate vertical analysisperpetual inventory record examplewhen accounts receivable are collectedbookkeeping entries examplesbank statement reconciliation templatenominal annual rate formulaformula for continuous compoundingpv of perpetuityformat of asset registerhow to calculate depreciation expensedebts and creditsannuity formula excelformula of contribution marginmerchandise inventory adjusting entrycash flow projections template excelunpresented chequeentry for bad debtscos bookkeepingreverse stock split examplelabor rate variance calculatorcontinuously compounded formulaincome statement unearned revenuetrading securities journal entriespetty cash assetbookkeeping meaning & definitionapplying manufacturing overheadgross profit inventory methodpurchase ledger control account exampledirect material cost variance formulasales discounts on income statementdebt equity ratio calculation formulaaccumulated depreciation asset or liabilityformulas for simple and compound interestannual interest rate formula excelending retained earningstemplate for receipt of moneydiscount on bonds payable balance sheethow to calculate average accounts receivableexamples of direct labor costsretained profit balance sheetmarkup vs marginexcel margin formula