Skip to main content

Accounts Payable - Reports

📄️ AP-11 Open Item List

The AP Open Item List will produce a report of all open (unpaid) items for a range of suppliers. This report or the AP-14 Aged Payables report are commonly used to balance the AP sub-system to the GL control account. To balance accurately, you must complete a month's transactions and print your Open Item List for that month end prior to posting entries for the next month. If you run multiple months together, then you need to be very careful with the transaction dates and posting dates as to not mix transactions from one month into another. In this case you will use the AP-15 Historical Open Item List to balance to the GL.

📄️ AP-13 Check Register

The Check Register will print a list of checks that have not yet been reconciled/cleared. The total on the check register is required to balance the bank account. This is the amount of the checks that have been written, but not yet cashed and so needs to be added back into the EPASS bank account balance to help match the bank statement. The check register is also used to show all checks that were written during a period. If you want to see all checks written during a period, run this report prior to doing the check reconciliation or drop paid invoices.

📄️ AP-14 Aged Payables Report

The AP Aged Payables report will produce a list of all open (unpaid) items and age those invoices into due in 1-30, 30-60, over 60 days or overdue 1-30, 30-60, over 60 days columns. This report or the AP-11 Open Item List are commonly used to balance the AP sub-system to the GL control account. To balance accurately, you must complete a month's transactions and print your Aged Payables report for that month end prior to posting entries for the next month. If you run multiple months together, then you need to be very careful with the transaction dates and posting dates as to not mix transactions from one month into another. In this case, you will use the AP-15 Historical Open Item List to balance to the GL.

📄️ AP-15 Historical Open Item List

The AP Historical Open Item List will produce a report of all open (unpaid) items for a range of suppliers based on AP history. This report is very similar to the AP-11 Open Item List except it can be run for the past. The AP-15 gives more flexibility than the AP-11 because a lot of companies have to keep payables open after month end while waiting for last month's invoices to arrive. During this time, invoices for the new month are also arriving and need to be paid. This means we are putting payables into two periods and so will need to use the AP-15 later on to give us an accurate closing balance for the month end.