AP aging [in-depth guide]
Shows all Accounts Payables with open balances and aging.
Run report | Search criteria | Display options
Run report
Generate
This button will create and open the report on a new screen.
New schedule
This button will allow you to create a Scheduled report that can be emailed out based on your requirements.
Search criteria
As of date
Shows all accounts payable aging with amount open and days old. The "As Of" date always uses the Posting Date from the Vendor Invoice or Payment. The selection of Using: Invoice Date, Due Date, or Posting Date is used to decide how to place the amounts into your defined aging buckets. The As Of: Date will act as if no transactions exist after this date. So if you are running the report as of a past date, keep in mind you may see transactions that have already been accounted for after that date.
Vendor
Limits the results to a specific vendor.
Company
This appears if you have GL companies enabled. Limits results to open transactions for that GL Company
AP account
Limits results based on transactions for that AP account.
Currency
Appears only if you have Multicurrency enabled. Limits results based on transactions for that currency.
Find date of last balance
This can be used for the system to try and locate the last date your AP tied out.
NOTES:
- It checks by day when the open amount total on the AP aging last matched the accounts payables line(s) on your balance sheet as of the same day.
- The most common issues for an out-of-balance issue is a journal entry being posted to accounts payable, or if the vendor invoice has a header or line GL account posting to an incorrect account.
Display options
Posted transactions only
Limits the results to only show transactions that have been posted to the GL.
Include unapplied payments
If checked, unapplied payments not applied to a vendor invoice will be included.
AE view
Groups the results by the account manager of the project linked in the header of the invoice. If no project is listed in the header for the invoice, then it's grouped under No Account Manager.
AE view page break
Same as above yet does a page break before each AEs name when you export to PDF only.
Summary view
If checked, the report will be made into one line per vendor.
Group by office
Groups the results by office if set on the invoice and project.
First period (days)
User adjustable, typical use is 30 days.
Second period (days)
User adjustable, typical use is 60 days.
Third period (days)
User adjustable, typical use is 90 days.