AP Reports                                        

Reports - Accounts Payable

Open Payables

This report shows outstanding (not fully paid) invoices for each vendor. Invoice date and due date are printed for each invoice, as are invoice amount, amount paid so far, amount owing, discount amount, and discount date.

The report prints vendor total amount owing, and for foreign currency vendors, an extra total line prints showing the vendor total converted to domestic currency using the exchange rate specified for the currency. Final report totals are printed in domestic currency.

The report may be filtered to show only invoices for a selected currency or vendor.

Aged Payables

This report shows outstanding (not fully paid) invoices for each vendor. The age (number of days since the invoice date) of each invoice is printed and based on the age, the amount owing is printed in an age column (current, over 30, over 60, etc).

The report prints vendor totals for amount owing, current, over 30, etc. and for foreign currency vendors, an extra total line prints showing the vendor totals converted to domestic currency using the exchange rate specified for the currency. Final report totals are printed in domestic currency.

The report may be filtered to show only invoices for a selected currency, or for a selected vendor.

The selected “As of date” is used for the age calculation, but is not used in the data selection. You could print a report as of the previous period-end if it took a few days after the period to finish entering invoices, so long as no invoices or payments were entered for the new period.

AP History

This report shows invoices and Checks for each vendor for the selected period. The report may be filtered to show only transactions for a selected currency or vendor.

Lists

These list screens have a print option, and can be filtered and sorted in different sequences.

Vendors

AP Invoices

AP Checks

To print a cash requirement report prior to printing Checks (a list of Checks that will be printed with the total amount of money required) you can use the filter button, then menu File | Print.

Other

An ODBC driver is available for creation of custom reports via MS Access or Crystal Reports, mail merge with MS Word, and to import Pilot data to MS Excel, etc.