How can we help?

Search for answers to your questions by entering keywords below, or look through our knowledge base.

Accrual Revenue Report

Follow

The Accrual Revenue Report lists revenue from transactions with a 'Success' or 'Pending Success' status from ABC. This report can be filtered by date range, location, and employee. 

Reading the Accrual Revenue Report

Paid Invoices: The Accrual Revenue Report adjusts its data as invoice status changes. Once an invoice is settled and paid, it will always appear as 'Paid' on the Accrual Revenue Report.

Example: On 8/30, Micah’s invoice possessed a ‘Pending’ status. On 9/2, Micah’s invoice settled -shifting its status to ‘Paid’. As a result, Micah’s invoice’s status will now always appear with the Accrual Revenue Report as being ‘Paid’.

Refunds: When a paid invoice is later refunded, a new invoice is generated for the refund and appears separately in the report. The value of the original invoice (in the 'Total ($)' column) becomes negative and it is assigned a Refund Invoice Number (this appears in its own column, separate from the original invoice number). These invoices only appear on reports for the date(s) they were created.

Example: Oliver’s initial invoice was marked as paid on 2/1. A refund was issued on 3/1. At the end of March, you decide to review the reports by month. Your February Accrual Revenue Report does not include Oliver's refund invoice, but it does include a negative value and a Refund Invoice Number for the original transaction. Your March Accrual Revenue Report shows Oliver's refund, but not the original invoice. However, if you generated a report for the date range 2/1 - 3/31, you would see both invoices.

Chargebacks/Returns: These will only appear on a report containing the the original paid invoice.

Example: Candice’s initial invoice billed on 11/20. Her bank issued a Chargeback on 12/2. November's Accrual Revenue Report will display the Chargeback invoice, but the December report will not.

Sample Accrual Revenue Report

Sample Report

Total Revenue by Payment Type

The summary table at the top of the report lists the amount of new Charges, Refunds, and Chargeback/Returns by payment type (Cash/Check or Credit/ACH). The 'Total($)' column on the right lists the total revenue accrued in each category (new Charges minus Refunds and Chargebacks).

Payment Type table

  • New Down Payment: Down payments on new Agreements (first-time Members) 
  • Renew Down Payment: Down payments from returning Members renewing their Agreement
  • Recurring: Recurring payments from both new and renewed Agreements
  • Cancellation: Cancellation fees collected
  • Total

Total Revenue by Payment Status

Payment Status table

  • Total Pending Revenue: Invoices that are not yet settled
  • Total Not Paid Revenue: Invoices that are unpaid (for example, in the event of a chargeback)
  • Total Paid Revenue: Invoices that have been successfully paid. This does not include refunded revenue.

New Down Payment, Renew Down Payment, Recurring Payment, Cancellation Payment

Below the Payment Type and Payment Status tables, each category is listed separately. You can view the details of all invoices in the New Down Payment, Renew Down Payment, Recurring Payment, and Cancellation categories.

 Transaction details

  • Invoice Date: The date the invoice is set to bill. It is possible for the Invoice and Attempt Dates to be identical.
  • Attempt Date: For Cash/Check transactions, this is the date that club staff took payment and marked it as received in the system. For Credit/ACH transactions, this is the date the transaction was sent to ABC.  
  • Invoice Number: The invoice’s identification number.
  • Member Name
  • Agreement Name
  • Member Services: The Member Service(s) attached to the invoice. If there are multiple Member Services on this invoice, they will be listed and separated by a comma.
  • Salesperson: The employee who sold the Member their package.
  • Member Service ($): The Unit Price of the Member Service(s)
  • Fees ($): Additional fees, if applicable
  • Subtotal ($): The pre-tax cost of the invoice (Service costs + Fees)
  • Tax ($): Tax added, if applicable
  • Total ($): Subtotal plus tax. Refunded totals appear as a negative number.
  • Invoice Type: Can be either Recurring, Integration, Cancellation, or Down Payment.
  • Billing Type: 'Pay Now' invoices are manually collected and recorded. 'Auto-Billing' are automated Credit/ACH transactions.
  • Payment Profile: Cash, Credit Card, Checking, or Savings
  • Status'Pending', 'Paid', or 'Not Paid'. Displays as 'Pending' by default. Once an invoice is settled, its status is 'Paid'. If it is refunded or charged back, its status will become 'Not Paid'.
  • Refund Invoice Number: Remains blank except in the case of a refund. If a paid invoice is refunded, it is assigned an identification number that appears in this column.

 

Learn more about accessing, filtering, and scheduling reports.

Was this article helpful?
1 out of 1 found this helpful

Comments