The AP Aging report breaks down the amount outstanding in approved bills for each vendor. The report is organized into 30 day buckets and breaks out the amounts owed by each vendor in those buckets. The report will only pull from bills with the status of approved or partialPayment. Created, voided, and paid status bills are not taken into account for this report. The amounts represented in each bucket are calculated based off of the invoice date (e.g. invoice date of 5/15/2020 would be represented in the 31-60 bucket on 6/20/2020). Here is an example:
You can further review a single vendor's bills by clicking the dropdown arrow on the far left of the screen, next to the vendor name:
It is also important to note that the data represented in the reports is as of the system date in the top right of your screen:
This means that the calculation for days from invoice date starts at the system date (e.g. system date set to 1/1/2020, invoice date of 12/20/2020 would be bucketed in the 0-30 range, even if today's date is 5/15/2020). This allows you to see the AP Aging of your vendors from a specific date in time, making it easier to review historical data.
Similarly, adjusting the system location picker will limit the data shown to bills entered for the selected location and its children:
- Update System Date Picker - Changes the starting date of the aging buckets
- Update System Location Picker - Updating the system location will limit the balances to bills posted in the selected location or any of its children
- View Vendor's Bills - Click to expand and view all bills which fit the criteria