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

definition of acid test ratioexample of petty cash fundpv of annuity due tabledebtor ledgerhow to calculate profit markupcalculating pmtobsolescence inventoryrequisition of materialshow to calculate project payback periodfv formula in excelthe cvp income statementimprest system of accountingmulti step income statement excel templateformula for annual depreciationexcel annuity calculationpetty cash spreadsheet exampleeffective interest rate calculator excelgeneral ledger sheetmanufacturing overhead calculatorbank reconciliation statement wikipediadebtor control account formatfuture value and present value formulasexamples of prepaid expenses in accountingexcel paybackarr formulafind the future value of an annuityfixed assets turnover formulapurchase order format xlsincreasing annuityaccounting sales returnsexample payroll journal entryaccrual and prepaymenttemplate for timesheetgoodwill accounting treatmentpv and fv formulaspmt mortgageaccounts receivable journaldifference between carriage and freightcarriage inward meaningdebtor days formula monthlyreceived invoice journal entrywhat is the accounting cycle stepsmarkup percentage on costaccounting rate of return disadvantagesformula for double declining depreciationcash flow in excel formatnper 3sundry expenses examplehow to calculate receivables turnover ratiofuture value of a lump sum formulawhat is the normal balance of accounts receivableextended dupont formulabalance sheet prepaid rentaverage cost method formulaexcel pmt functionaccounts payable and accrued expensessum of annuity formulaaccounting journal template excelwhat is the meaning of contra entrypresent value perpetuity calculatortotal overhead variancepetty cash format in excelcapital gearing ratio meaningaccrual accounting and adjusting entriesdepreciation of fixed assets journal entryaccounting ledger bookfifo and lifo in accountingfuture value annuity equationcash book entry exampleavailable for sale securities journal entriesmanagerial accounting journal entriesadvantages of zero based budgetingaccounts payable journal entrieseft accountinghow to calculate spending variancepresent value of lump sum formulaformula for present value of annuity duegrowth perpetuity