Month End A/P Report

  Back to Month-End Accounting Guide

Use the Month-End A/P Report during month-end close to review Accounts Payable for a selected month.

This report can recreate Accounts Payable for prior accounting periods. Use it to compare A/P totals to the General Ledger or journal balance.

Accounting>File>Month End>A/P Report

Report Options

Option	Description
Report Month	Select the month to review.
Print by Account Code (Posted & Open)	Prints A/P by account code. This option includes posted and open items. Use it when comparing A/P activity to journal entries or General Ledger balances.
Account Code	Select the account codes to include when printing by account code.
Print by Supplier (Open Only)	Prints open A/P by supplier. Use it when reviewing open payables by vendor.
Supplier	Select the supplier to include when printing by supplier.
Summary	Prints supplier totals instead of invoice detail. This option is only available when Print By Supplier (Open Only) is selected.
Stores	Select one store, multiple stores, or all stores.
Combine	Combines selected stores into one report.
Print Preview	Shows the report on screen before printing.
Output CSV to	Creates a text file that can be used in another application.

CSV Fields

Report Type

Store

Act Dec

Sub Code

Supplier

Invoice Number

Invoice Date

Date Paid

Check Number

Gross Amount

Due Date

Status

Print By Account Code

Use Print By Account Code (Posted & Open) when you need to review A/P by account code.

This option includes posted and open items. It is useful when comparing A/P activity to journal entries or General Ledger balances.

Select the account codes to include before running the report.

Print By Supplier

Use Print By Supplier (Open Only) when you need to review open A/P by supplier.

This option only includes open items. If you select Summary, the report prints supplier totals instead of invoice detail.

Example Reports

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.