The Accounts Payable and Receivable report identifies orders with non-zero balances across events within a selected date range. Multiple report views allow balances to be analyzed by AR/AP status, event, aging period, or customer.
Description
This report lists orders with non-zero balances for events that fall within the selected date range. It can be used to review outstanding receivables and payables across multiple events or for a specific event.
The View By filter determines how balances are organized and displayed.
Available Report Views
AR/AP Status then by Event
Displays orders with non-zero balances, grouped first by AR/AP status and then by event.
Event then by AR/AP Status
Displays orders with non-zero balances, grouped first by event and then by AR/AP status.
Aging
Displays outstanding balances in aging columns, similar to a QuickBooks aging report.
Aging is calculated using the difference between the event's end date and the current date. As a result, all orders within the same event have the same aging value.
The report uses the following aging categories:
- Current: Events that have taken place within the last 30 days.
- 1-30 Days: Balances overdue between 1 and 30 days.
- 31-60 Days: Balances overdue between 31 and 60 days.
- 61-90 Days: Balances overdue between 61 and 90 days.
- 91 and Over: Balances overdue by more than 90 days.
Aging by Customer
Displays outstanding balance orders grouped by customer within a selected date range. This view is particularly useful for identifying balances a customer owes in one event before issuing a refund for an order in another event.
Manager Then Event
Organizes results by the Exhibitor Service Manager field and then by event.
By State With Taxes
Provides an additional report view organized by state with tax information.
Available Filters
Use the following filters to select events, control how balances are grouped, and narrow the results by date, customer type, or balance amount.
| Field Name | Available Values | Default |
|---|---|---|
| Choose from Events In | No event filter One specific event |
No Event Filter |
| View By | AR/AP Status then by Event Event then by AR/AP Status Aging Aging by Customer Manager Then Event By State With Taxes |
AR/AP Status then by Event |
| Sort By | Exhibitor Booth |
Exhibitor |
| Starting Event Start Date | Any date | Beginning of Time |
| Ending Event Start Date | Any date | End of Time |
| Starting Event End Date | Any date | Beginning of Time |
| Ending Event End Date | Any date | End of Time |
| Customer Type(s) | All Customer Types | All Customer Types |
| Balance Minimum | Any numeric value | None (Null) |
| Balance Maximum | Any numeric value | None (Null) |
| Include Contact Details | Yes No |
No |
Tip: Select Aging by Customer from the View By filter to review outstanding balances across events for individual customers. This can be helpful when evaluating refunds or outstanding account balances.
Sample Reports
Open the Accounts Payable and Receivable PDF to see an example of the standard report.
Open the Accounts Payable and Receivable Aging by Customer PDF to see an example of balances grouped by customer.