Report Title: AP Aging by Invoice
Category: Bill Pay
Available to: Users with access to Bill Pay
Pricing Package: Basic
The AP Aging by Invoice report returns unpaid invoices with their corresponding aging bucket.
Bill Pay users can use this report to see a breakdown of their outstanding payments to better plan and manage cashflows.
|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.|
|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.|
|Open Balance||Sum of the spend for that invoice.|
User who approved
Memo added to invoice (if applicable)
|Issue||(If the invoice was flagged)|