Accounts Payable and Receivable

Report Overview

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.

Accounts Payable and Receivable grouped by AR/AP status and 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.

Accounts Payable and Receivable Aging by Customer report example

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

▤

View Sample Report

Open the Accounts Payable and Receivable PDF to see an example of the standard report.

▤

View Aging by Customer Sample

Open the Accounts Payable and Receivable Aging by Customer PDF to see an example of balances grouped by customer.