Report Title: AP Aging by Vendor
Category: Bill Pay
Available to: Users with access to Bill Pay
Pricing Package: Basic
Overview
The AP Aging by Vendor report returns a summary of liabilities broken out by vendor.
Bill Pay 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 |