Report Title: AP Aging by Invoice
Category: Bill Pay
Available to: Users with access to Bill Pay
Pricing Package: Basic
Overview
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.
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 |
| 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:
|
| 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
