AP Reports

Menu File | AP | Reports

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 cheques 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 Cheques

To print a cash requirement report prior to printing cheques (a list of cheques 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 (free upon request for end-user versions of BS1 costing over $199) for creation of custom reports via MS Access or Crystal Reports, mail merge with MS Word, and to import BS1 data to MS Excel, etc. There is also a free utility for importing and exporting data. Source Code is available so that programmers can modify the built-in reports and screens, and add new features.