AP Cash Requirements Report

The AP Cash Requirements report lists all the payables due as of the date you specify. It totals by vendor, with current balance due, discounts to be taken and net balance due and then a grand total of the cash required to pay everything listed. You can access this report by selecting Accounts Payable > Reports > AP Batch Transactions.

This report lists all the payables due as of the date you specify. It totals by vendor, with current balance due, discounts to be taken and net balance due and then a grand total of the cash required to pay everything listed.

You may choose whether or not unapproved payables are included, and you may choose whether open payables should be included based on their due date or their discount date. Transactions on hold and transactions due later than the report date you specify will not be included.

Typically, this report will be printed prior to creating an AP payment work file. You may want to use it to compare with the check preview report to make sure you are paying what you intended to pay. Keep in mind when comparing the grand totals that if you made any changes to transactions in the work file you will have to make those same changes to the cash requirements totals in order for the two to balance.
Report ParametersDescription

Company

Accept the default, or press F4 to select a company.

Due Date

Enter or select the through date in which payments are due.

Include based on Discount when present?

Select check box to include a discount when present.

Include Unapproved Transactions?

Select the check box to include unapproved transactions.

Print Vendors with Negative Balances?

Select the check box to include all vendors with credit balances.

AP Pay Category (Blank for All)

Press F4 to select a pay category or leave the field blank to include all categories.