How can we help?

    The Accrual Revenue Report [Breakdown]

    Follow

    The Accrual Revenue Report records invoices whose initial transactions have earned a ‘Success’ or ‘Pending Success’ status from ABC. This report allows Club Owners and Admins to see, at once, the total earnings billed to Members and refunded invoices within a designated date range. It is a tool in accrual-based accounting.

    Invoices are listed in order of ascending, successful Attempt Dates. This report is filterable by Date Range, Location and Employee. For steps on how to access, filter, and schedule the report, click here.

    Report Logic

    As an invoice’s status shifts, the Accrual Revenue Report updates its records accordingly.

    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’.

    A. Refunds

    When a paid invoice results in a refund, a second, separate invoice gets created. The initial invoice will keep its ‘Paid’ status and gain a Refund Invoice Number. The new invoice, too, will possess a ‘Paid’ status -however, its Total ($) will display a negative number.

    Neither invoice appears alongside each other within the report. Rather, each appears strictly within reports depicting the date in which their action actually occurred.

    Example: Oliver’s initial invoice billed on 2/1. It refunded on 3/1. To run the Accrual Revenue Report for February would not display Oliver’s refunded invoice. Similarly, March’s Accrual Revenue Report would not contain Oliver’s initial, paid invoice. However, were the Accrual Revenue Report made to depict both February and March, the report would include both invoices.

    B. Chargebacks/Returns

    A Chargeback/Return will only appear on a report containing the date in which the invoice’s initial, successful transaction occurred.

    Example: Candice’s initial invoice billed on 11/20. Her bank issued a Chargeback on 12/2. To run the Accrual Revenue Report for December would not display Candice’s Chargeback invoice. However, November’s Accrual Revenue Report would.

    The Report


    This report consists of five tables: 'Total Revenue by Payment Type', 'Total Revenue by Payment Status', 'New Down Payment', 'Renew Down Payment' and 'Recurring Payment'. All events are listed in order of ascending date. Click each link to jump ahead to a specific section.

    Total Revenue by Payment Type • Total Revenue by Payment Status • New Down Payment
    Renew Down Payment • Recurring Payment

    Table One: Total Revenue by Payment Type

    Screen_Shot_2018-06-14_at_8.42.22_AM.png

    This table is comprised of five sections:

    • New Down Payment: Displays the total number of first-ever down payments that Members made within the designated date range.

      Note: Only Members who have never previously purchased an agreement will populate this section.

    • Renew Down Payment: Displays the total number of returning down payments that Members made within the designated date range.

      Note: Only Members who have previously purchased an agreement (similar or otherwise) will populate this section.

    • Recurring: Displays the combined total of recurring payments that Members made during the report’s designated date range.

      Note: Both ‘New’ and ‘Renew’ Members will populate this section.

    • Cancellation: Displays the total amount of Cancellation Fees collected within the designated date range

     

    • Total: Displays the combined totals of the ‘New Down Payment’, ‘Renew Down Payment’, and ‘Recurring’ sections.

      Example: Total = ‘New Down Payment’ + ‘Renew Down Payment’ + ‘Recurring’


    Furthermore, each section is comprised of five columns:

    • Payment Type: Displays the method through which payments were achieved.

      Note: Here, payment types are divided into two categories:
      • Cash/Check
      • Credit/ACH (Bank Account)

    • Charge: Displays the total payment that a club received per payment type, within the report’s designated dates.

    • Refund: Displays the total refunds that a club paid out per payment type, within the report’s designated dates.
    • Chargeback/Return: Displays the total returns that a club paid out per payment type, within the report’s designated dates.

    • Total ($): The resulting total of a club’s remaining profits once its losses have been accounted for.

      Note: This is factored by subtracting both the club’s ‘Refund’ and ‘Chargeback/Return’ totals from its ‘Charge’ total.

      Example: Total ($) = Charge - (Refund + Chargeback/Return)

     

    Table Two: Total Revenue by Payment Status

    This table summarizes the status of the costs the club billed out within the report's depicted dates.

    Such sections include:

    • Total Pending Revenue: The total cost of what the club billed its Members within the designated dates that has yet to be settled.

    • Total Not Paid Revenue: The total cost of what the club billed its Members within the designated dates that has failed to find funding.

    • Total Paid Revenue: The total cost of what the club billed its Members within the designated dates that has found funding.

      Note: This does not include refunded revenue.

     

    Table Three: New Down Payment

    This table details the agreements that comprise the previously seen ‘New Down Payment’ total revenue.

    Such columns include:

    • Invoice Date: The date in which the invoice is set to bill.

      Note: It is possible for the Invoice and Attempt Dates to be identical.
    • Attempt Date: The date of an invoice’s first, successful step toward funding.

      Note: For invoices paid via Cash/Check, this is the date that club staff report taking the Member’s payment. For invoices paid via Credit Card/Checking/Savings, this is the date in which the invoice’s initial transaction occurred -prompting ABC to verify that the credit card/bank account exists and is valid.

    • Invoice Number: The invoice’s identification number.

    • Member Name: The Member who owns the invoice.

    • Agreement Name: The package to which the invoice is attached.

    • Member Services: The Member Service(s) that are attached to the invoice.

      Note: It is possible for an invoice to possess multiple Member Services. In this event, each Service will be listed within the same field and separated by a comma.
    • Salesperson: The employee who sold the Member their package.
    • Member Service ($): The cost of the package’s Service(s), alone.

    • Fees ($): The cost of any additional fees.

    • Subtotal ($): The combined cost of the invoice, prior to tax.

    • Tax ($): The cost of the invoice’s added tax.

    • Total ($): The combined cost of the invoice, including tax.

      Note: Refunded totals appear as a negative number.

    • Invoice Type: Distinguishes the financial transaction attributed to the invoice. This can be either Recurring, Integration, Cancellation, or Down Payment.

    • Billing Type: Distinguishes the process in which the invoice is paid. This includes either ‘Auto-Billing’ or the manually-occurring ‘Pay Now’.

    • Payment Profile: The method in which a Member has arranged for their invoice to be charged. (This can be either ‘Cash’, ‘Credit Card’, ‘Checking’, or ‘Savings’.)

    • Status: Displays the invoice’s eventual pay status. (This can be either ‘Pending’, ‘Paid’, or ‘Not Paid’.)

      Note: By default, this will display as ‘Pending’. Once the invoice becomes settled, its status will switch to ‘Paid’. However, if the invoice is returned or charged back, its status will switch to ‘Not Paid’.

    • Refund Invoice Number: When a paid invoice results in a refund, this displays the initial invoice’s resulting, refunded invoice’s identification number. When a paid invoice does not result in a refund (or is, itself, the refunded invoice), this space remains blank.

     

    Table Four: Renew Down Payment

    This table details the agreements that comprise the previously seen ‘Renew Down Payment’ total revenue.

    Such columns include:

    • Invoice Date: The date in which the invoice is set to bill.

      Note: It is possible for the Invoice and Attempt Dates to be identical.
    • Attempt Date: The date of an invoice’s first, successful step toward funding. 

      Note: For invoices paid via Cash/Check, this is the date that club staff report taking the Member’s payment. For invoices paid via Credit Card/Checking/Savings, this is the date in which the invoice’s initial transaction occurred -prompting ABC to verify that the credit card/bank account exists and is valid.

    • Invoice Number: The invoice’s identification number.

    • Member Name: The Member who owns the invoice.

    • Agreement Name: The package to which the invoice is attached.

    • Member Services: The Member Service(s) that are attached to the invoice.

      Note: It is possible for an invoice to possess multiple Member Services. In this event, each Service will be listed within the same field and separated by a comma.
    • Salesperson: The employee who sold the Member their package.
    • Member Service ($): The cost of the package’s Service(s), alone.

    • Fees ($): The cost of any additional fees.

    • Subtotal ($): The combined cost of the invoice, prior to tax.

    • Tax ($): The cost of the invoice’s added tax.

    • Total ($): The combined cost of the invoice, including tax.

      Note: Refunded totals appear as a negative number.

    • Invoice Type: Distinguishes the financial transaction attributed to the invoice. This can be either Recurring, Integration, Cancellation, or Down Payment. 

    • Billing Type: Distinguishes the process in which the invoice is paid. This includes either ‘Auto-Billing’ or the manually-occurring ‘Pay Now’.

    • Payment Profile: The method in which a Member has arranged for their invoice to be charged. (This can be either ‘Cash’, ‘Credit Card’, ‘Checking’, or ‘Savings’.)

    • Status: Displays the invoice’s eventual pay status. (This can be either ‘Pending’, ‘Paid’, or ‘Not Paid’.)

      Note: By default, this will display as ‘Pending’. Once the invoice becomes settled, its status will switch to ‘Paid’. However, if the invoice is returned or charged back, its status will switch to ‘Not Paid’.

    • Refund Invoice Number: When a paid invoice results in a refund, this displays the initial invoice’s resulting, refunded invoice’s identification number. When a paid invoice does not result in a refund (or is, itself, the refunded invoice), this space remains blank.

     

    Table Five: Recurring Payment

    This table details the agreements that comprise the previously seen ‘Recurring Payment’ total revenue.

    Such columns include:

    • Invoice Date: The date in which the invoice is set to bill.

      Note: It is possible for the Invoice and Attempt Dates to be identical.
    • Attempt Date: The date of an invoice’s first, successful step toward funding. 

      Note: For invoices paid via Cash/Check, this is the date that club staff report taking the Member’s payment. For invoices paid via Credit Card/Checking/Savings, this is the date in which the invoice’s initial transaction occurred -prompting ABC to verify that the credit card/bank account exists and is valid.

    • Invoice Number: The invoice’s identification number.

    • Member Name: The Member who owns the invoice.

    • Agreement Name: The package to which the invoice is attached.

    • Member Services: The Member Service(s) that are attached to the invoice.

      Note: It is possible for an invoice to possess multiple Member Services. In this event, each Service will be listed within the same field and separated by a comma.
    • Salesperson: The employee who sold the Member their package.

    • Member Service ($): The cost of the package’s Service(s), alone.
    • Fees ($): The cost of any additional fees.

    • Subtotal ($): The combined cost of the invoice, prior to tax.

    • Tax ($): The cost of the invoice’s added tax.

    • Total ($): The combined cost of the invoice, including tax.

      Note: Refunded totals appear as a negative number.

    • Invoice Type: Distinguishes the financial transaction attributed to the invoice. This can be either Recurring, Integration, Cancellation, or Down Payment. 

    • Billing Type: Distinguishes the process in which the invoice is paid. This includes either ‘Auto-Billing’ or the manually-occurring ‘Pay Now’.

    • Payment Profile: The method in which a Member has arranged for their invoice to be charged. (This can be either ‘Cash’, ‘Credit Card’, ‘Checking’, or ‘Savings’.)

    • Status: Displays the invoice’s eventual pay status. (This can be either ‘Pending’, ‘Paid’, or ‘Not Paid’.)

      Note: By default, this will display as ‘Pending’. Once the invoice becomes settled, its status will switch to ‘Paid’. However, if the invoice is returned or charged back, its status will switch to ‘Not Paid’.

    • Refund Invoice Number: When a paid invoice results in a refund, this displays the initial invoice’s resulting, refunded invoice’s identification number. When a paid invoice does not result in a refund (or is, itself, the refunded invoice), this space remains blank.

     

     

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

    Comments