Aged Accounts Payable Report

Aged AP Report Overview

The Aged Accounts Payable Report will list all vendor accounts that currently have unpaid invoices. All invoices are aged based on their individual due dates.

The aging periods of the report are defined in the Program Setup window.  These aging periods may be modified to customized settings for your application.

This report is date sensitive, which means that checks or invoices dated after the accounting date of this report will not be printed on the report.  This report provides the detail report needed to reconcile the Accounts Payable balance in the General Ledger.

Any invoices that have been entered but have not been updated to the General Ledger through the Invoice Journal will not appear on the Aged Accounts Payable Report.

Find this window at Payables > Payables Reports > Aged Accounts Payable Reports.

A screenshot of a computer

Description automatically generated

Accounting Date

The date entered here will determine the aging of the invoices on the report.  You may run this for any date current, in the future, or a previous date.

Vendor Class to Include

If you want to print this report for a single class, enter the class number for which you are printing the report.

Vendor Class to Exclude

If you are printing a report for all vendor classes, you can select one vendor class to exclude.  This is sometimes used by packers and processors to exclude grower payables from the report.

Report Type

A detail report will list each open invoice on each vendor account on a separate line.  A summary report will list the total owed to each vendor account on a single line without the invoice detail.

Print P.O. # / Job Number

To print the PO or Job number on the report, select these boxes.

Print Prepayment Balances

To print Prepayment Balances on the report, select this box.

Excel Filename

This report can be exported to excel using this entry. Enter the preferred file name or use the folder button to browse to a certain location/overwrite an existing file.