AP Aging By Vendor (Legacy)

Modified on Thu, Feb 29 at 5:45 PM

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
Email	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