Accounts Payable Aging Report

View all outstanding vendor invoices and the current aging status (Current, 1 – 30, 31 – 60, 61 – 90, 90+). The Accounts Payable Aging report ties back to the General Ledger for easy reference.
 

Accounts Payable Aging Report Filters:


Vendor Class Filter

Vendor classes group vendors by type for reporting purposes. For example, inventory, utility, subcontractors, or general vendors. Once vendor classes are created, use the Vendor Class field on the Options tab of the Vendor screen (Administration > Accounting > Accounts Payable > Search Vendors > Open a vendor) to add a vendor class to a vendor.

  Output Options
  • Summary by Vendor: Summarizes the total due to each vendor. It does not list each invoice individually. Clicking the Vendor's name will take you directly to the Vendor's Profile.

  • Detail by Vendor: Lists each invoice individually for each vendor. Clicking the Vendor's name will take you directly to the Vendor's Profile. Clicking the Invoice or Debit Memo number will take you directly to the referenced document. NOTE: (HOLD) next to a vendor invoice indicates the invoice has not yet posted.

  • Detail by Aging Period: Categorizes each invoice by aging period. All the invoices that are due within 1 - 30 days will show in the same section. Clicking the Vendor's name will take you directly to the Vendor's Profile. Clicking the invoice or Debit Memo number will take you directly to the referenced document. NOTE: (HOLD) next to a vendor invoice indicates the invoice has not yet posted.

 

Example AP Aging Report:

 

Security Permissions Required  

Category
 
Function
 
Admin-Accounting
 
AP – Accounts Payable Aging
 

Related Reports

  • Accounts Payable Invoice Register (Administration > Reports > Accounting > Accounts Payable > Accounts Payable Invoice Register): View all AP invoices for a selected time period.
  • Cash Requirements (Administration > Reports > Accounting > Accounts Payable > Cash Requirements): Detailed or Summary list of AP Invoices that are coming due and the cash required to pay them.