Month End A/P Report

Accounting>File>Month End>A/P Report
This report recreates the Accounts Payables for prior accounting periods and is used to balance with the General Ledger. Elect to print this report sorted by either Account Code or by Supplier.

Choosing to sort by Account Code lists all payable posted in the month reported whether paid or unpaid (open), as well as posted in prior months still unpaid. This may be particularly helpful in referencing the journal entries. The .csv report with this choice includes the report type indicator 1, Store, Account Description, Sub Account, Supplier, Invoice number, Invoice Date, Date Paid, Check Number and Gross Amount.

Choosing to sort by Supplier will list the payables unpaid as of the month reported as they appear in the Accounts Payable file. The .csv report with this choice includes the report type indicator 2 (which means by supplier), the Supplier, Invoice Number, Invoice Date, and Gross Amount. Choosing summary will list the total open per supplier versus individual invoices due.

Stores

Tag a single store, multiple stores or all stores for printing -There is also an option to combine the selected stores into one report doing so will merge all data from all selected stores into one document.

Print Preview

Click in this box to view the report on the screen before sending it to the printer.

Output to CSV

select to create an ASCII text file for use in other applications

Notes: 

The Open AP by Account Code produces two sections:

Open: All open AP that were not paid during the time the report covers. 

Posted: All entered during the month the report is covering. 

The report lists Gross Amount (Discounts not included).

Date Paid/Check # - If the payable has been paid since the month reported, that information will be listed.

See Also: 

Accounting - Month End - AP By Account Code CSV fields – RFMS Help Desk (zendesk.com)

Accounting - Month End - AP By Supplier CSV Fields – RFMS Help Desk (zendesk.com)