AP Aging by Invoice (Legacy)

Modified on Tue, Feb 13 at 3:34 PM

Report Title: AP Aging by Invoice

Category: VendorPay

Available to: Users with access to VendorPay

Pricing Package: Basic

Overview

The AP Aging by Invoice report returns unpaid invoices with their corresponding aging bucket.

VendorPay users can use this report to see a breakdown of their outstanding payments 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
Status	Approved status determined by approval state in Plate IQ. If Invoice has been exported, then Status = Exported. If Invoice has been approved, but not exported, then Status = Approved If Invoice is neither of the above, then Status = Pending.
Invoice Number	Invoice number, as it's read on the invoice
Date	Invoice date, as it's read on the invoice
Vendor	Concatenation between Vendor ID - Vendor Name, as it's read on the invoice
Due Date	If Net Terms are specified, then the Due Date = Invoice Date + Term. Otherwise, the Due Date = Invoice Date.
Aging	Represents the aging bucket based on the difference between the Due Date and the "Aged as of" date from above. Buckets include: current: less than or equals 0 1 to 30: (0, 30] 31 to 60: (30, 60] 61 to 90: (60, 90] 91+: 90+ exclusive
Open Balance	Sum of the spend for that invoice.
Approver	User who approved
Memo	Memo added to invoice (if applicable)
Issue	(If the invoice was flagged)

Sample