MR129: Liability Summary

The MR129 reports on liabilities (gift cards, packages/package tips, points, and client account credits) that were purchased, redeemed, or refunded within the date range, including starting and ending value, offsite redemptions, expired liabilities, and more.

Report definitions

Click here for details on each of the fields that appear in the MR129 report.Click here for details on each of the fields that appear in the MR129 report.

Amounts in parenthesis/italics ($150.00) have been redeemed (subtracted from the unused amount).

  • Total Liabilities Added from __ to __: The total of all liabilities that appear in the report. This is the sum of the following "Total" row in the detail section: Client Account Credits: Total Amount; Gift Cards: Total Value; Packages: Total Value; Package Tips: Total Tip Amount; Points: Total Point Value
  • Unused Liabilities as of __: Unused liabilities as of the End Date in the report parameters. In this context, an unused liability is one that has not been redeemed, refunded, expired, voided or transferred out to another location.
  • Expired Unused Liabilities as of __: Expired liabilities as of the End Date in the report parameters. In this context, an expired liability is one that has not been redeemed, refunded, expired, voided or transferred out to another location but is marked expired.

Liability Activity from __ to __ (detail section)

This section displays details for each selected liability type (Client Account Credits, Gift Cards, Packages, etc.).

Client Account Credits

  • Client: The name of the client who has credits on their account.
  • Unused Credits Starting __: The value of all unused client credits as of the Start Date in report parameters.
  • Amount: Amount of client credits added during the date range. Refunds do not affect this column.
  • $ Redeemed: The dollar value of all credits that were redeemed during the date range. Refunds do not affect this column.
  • Refund: The amount of all client account credits refunded during the date range.
  • Unused Credits Ending __: Amount of unused client credits as of the End Date in report parameters.
    (Total Unused Credits Starting + Total Amount – Total Refund – Total $ Redeemed)

Gift Cards

  • Type: The Gift Card Type.
  • Unused Value Starting __: The value of all unused client gift cards as of the Start Date in report parameters.
  • # Sold: The number of gift cards of that type that were sold in the date range. Gift cards that were transferred into a location will count towards this column. Refunds do not affect this column.
  • Price: The total amount that clients paid for gift cards in the date range. Refunds do not affect this column.
  • Value: The total value of new gift cards purchased in the date range and gift cards that were loaded in the date range. Refunds do not affect this column.
  • # Redeemed: Total number of gift cards redeemed in the date range. Refunds do not affect this column.
  • $ Redeemed: The total value on the gift cards that was redeemed in the date range. Refunds do not affect this column.
  • # Redeemed Offsite: Number of gift cards that were purchased/loaded in this location (before or during the date range) and then redeemed outside of this location in the date range. Refunds do not affect this column.
  • $ Redeemed Offsite: Total value of gift cards that were purchased/loaded in this location (before or during the date range) and then redeemed outside of this location. Refunds do not affect this column.
  • Refunds: Total amount of refund that were processed for gift cards.
  • Expired Within Date Range: The remaining value on gift cards that expired within the date range.
  • Unused Value Ending __: Amount of unused gift card value as of the End Date in report parameters.
    (Total Unused Value Starting + Total Value – Total $ Redeemed – Total Refund – Total Expired within Date Range)

Expired Gift Cards

All definitions are identical to gift cards, but in the context of expired gift cards. Note the following:

  • Expired Value Starting __: The value of expired gift cards as of the Start Date in report parameters.
  • # Expired: The number of gift cards that expired during the date range.
  • $ Expired: The value of gift cards that expired during the date range. This field should match the Total Expired Within Date Range value in the Gift Card table above.

Packages

  • Package Name: The name of the package.
  • Unused Value Starting __: The value of all unused packages as of the Start Date in report parameters.
  • # Sold: The number of packages that were sold in the date range. Refunds do not affect this column.
  • Amount Paid: The total price paid for packages in the date range. Refunds do not affect this column.
  • Pkg Price: The total value of packages purchased in the date range. Refunds do not affect this column.
  • # Redeemed: Number of items from a package that were redeemed in the date range. Refunds do not affect this column.
  • $ Redeemed: Total value of package items that were redeemed in the date range. Refunds do not affect this column.
  • # Redeemed Offsite: Total number of package items that were purchased in this location (before or during the date range), and then redeemed outside of this location in the date range. Refunds do not affect this column.
  • $ Redeemed Offsite: Total value of packages that were purchased in this location (before or during the date range) and then redeemed outside of this location in the date range. Refunds do not affect this column.
  • Refunds: The value of all refunded package items in the date range.
  • Expired Within Date Range: The remaining value of packages that expired within the date range.
  • Unused Value Ending __: Amount of unused package value as of the End Date in report parameters.
    (Total Unused Value Starting + Total Value – Total $ Redeemed – Total Refund – Total Expired within Date Range)

Expired Packages

All definitions are identical to packages, but in the context of expired packages. Note the following:

  • Expired Value Starting __: The value of expired packages as of the Start Date in report parameters.
  • # Expired: The number of packages that expired during the date range.
  • $ Expired: The value of packages that expired during the date range. This field should match the Total Expired Within Date Range value in the Packages table above.

Points

  • Points Promo: The name of the point promotion.
  • Unused Value Starting __: The value of all unused points as of the Start Date in report parameters.
  • Points Awarded: The number of points awarded in the date range. Refunds do not affect this column.
  • Points Value: The value of points that were awarded in the date range. Refunds do not affect this column.
  • # Redeemed: Total number of points redeemed in the date range. Refunds do not affect this column.
  • $ Redeemed: Total value of points redeemed in the date range. Refunds do not affect this column.
  • # Redeemed Offsite: Total number of points that were added in this location (before or during the date range), and then redeemed outside of this location in the date range. Refunds do not affect this column.
  • $ Redeemed Offsite: Total value of points that were added in this location (before or during the date range) and then redeemed outside of this location in the date range. Refunds do not affect this column.
  • Expired Within Date Range: The remaining value of packages that expired within the date range.
  • Unused Value Ending __: Amount of unused points value as of the End Date in report parameters.
    (Total Unused Value Starting + Total Value – Total $ Redeemed – Total Refunds – Total Expired within Date Range)

Setting up the MR129 report

  1. Type MR129 in the Convobar, or go to Meevo > Reports > Liabilities, and then select the MR129 report.
  2. Select a date or date range. The MR129 looks at historical data, so the report can only be run on dates in the past. This report cannot be run for today or future dates.
  • To run a report for a specific range, select Custom and specify the Start Date and End Date for the report. The range cannot be greater than 1 year.
  • Otherwise, select a specific date (Yesterday, This Week, Last Week, Previous Two Weeks).

Note: If you select a date other than Custom, you can still modify the Start Date and End Date as needed. Doing so changes the selection back to Custom.

  1. All Liabilities: If you deselect All Liabilities, use the list to select which liabilities to include.

Running the report

  1. When you are ready to generate the report, select a Report Format beside the Run Report button.
  2. Here is a rundown of each format type:
    1. PDF: Each time you select Run Report with PDF selected, Meevo opens a separate browser tab that displays the PDF'ed report. Meevo remains on the setup page, so you can quickly jump back over to Meevo to run more date ranges or other reports. Each PDF report you run will open its own browser tab, so you can easily review and compare reports by simply jumping between browser tabs.
    2. HTML: This is our original legacy format, which opens the report within Meevo. All of the functionality within that report is still there and available via the toolbar.
    3. XLSX: Each time you select Run Report, your browser auto-downloads the report in .xlsx format. Select the downloaded file in the browser footer to open the spreadsheet.
  3. Select Run Report to generate the report in your chosen format. Depending on the type of report and criteria you entered, this process may take a few minutes.