Accounts Payable and Receivable

  • The Accounts Payable and Receivable reports lists any non-zero balance order for all events with start dates between two dates as provided in the filters.  There are three views for this report:

    1. AR/AP Status then by Event.
      Display non-zero balance orders first by AR/AP status and then by Event.
      mceclip0.png

    2. Event then by AR/AP Status.
      Display non-zero balance orders first by event and then AR/AP status.

    3. Aging
      Displays aging ranges as columns similar to a Quick Books format.  The definition of "Aging" is the difference between the event's end date and the current date (so all orders in an event will have the same aging value).

      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: 31-60 Days: Balances overdue by more than 90 days.

    4. Aging by Customer
      Displays all outstanding balance orders grouped by customer within any desired date range.  This allows insight on which customers owe money in one event before refunding a payment in an order for another event.
      mceclip2.png


  • Field Name Available Values Default
    Choose from Events In
    No event filter or 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 (this is the Exhibitor Service Manager field)
    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

  • Accounts Payable and Receivable
    Accounts Payable and Receivable Aging by Customer