Report Title: AP Aging by Vendor
Category: VendorPay
Available to: Users with access to VendorPay
Pricing Package: Basic
Overview
The AP Aging by Vendor report returns a summary of liabilities broken out by vendor.
VendorPay users can use this report to see a the various amounts due to Vendors to better plan and manage cashflows.
Dashboard View
Filters
| Filter | Meaning |
|---|---|
| Group | Group of locations to run the report on. To run the report on all locations, leave this blank. |
| Location | To run a report for a single location, select the location's Group, and choose the location from the dropdown. |
| Aged as of | If chosen, the report will slate invoices into aging buckets as of the given date. Otherwise, the report will default to Today's date. |
| Vendor | To view invoices from a particular vendor |
| Pre-populated with the user's email address. Additional emails can be included by appending other comma-separated emails. |
Data
| Column | Meaning |
|---|---|
| Location | Location specified on the invoice |
| Vendor | Vendor, as it's read on the invoice |
| Current | Sum of invoice balances for that Location and Vendor where the Due Date is <= As of Date (Today, if none is specified) |
| 1 to 30 | Sum of invoice balances for that Location and Vendor where the As of Date - Due Date (Today, if none is specified) is between 1 and 30 days, inclusive |
| 31 to 60 | Sum of invoice balances for that Location and Vendor where the As of Date - Due Date (Today, if none is specified) is between 31 and 60 days, inclusive |
| 61 to 90 | Sum of invoice balances for that Location and Vendor where the As of Date - Due Date (Today, if none is specified) is between 61 and 90 days, inclusive |
| 91+ | Sum of invoice balances for that Location and Vendor where the As of Date - Due Date (Today, if none is specified) is greater than 90 days |
Sample
