Skip to main content
All CollectionsFAQ
FAQ: Reports
FAQ: Reports
Updated over a week ago

Below is a list of frequently asked questions about reports in WellnessLiving. If your question isn’t addressed in this article, please contact WellnessLiving Support.

How do I get an accurate picture of my cash revenue?

To ensure you get accurate sales numbers or cash revenue in WellnessLiving reports, check the following settings:

Date Range: Make sure you have selected the appropriate date range for the period you want to analyze.

Filter Settings: Ensure that the filters are set correctly to display your desired purchase options, services, and products.

Accounting Method: Select the correct accounting method. Usually, choosing “Cash” will help match your sales numbers with other systems, as the Cash based accounting method tracks the revenue from a sale on the day your business receives the payment.

View Mode:

  • Item View - shows each purchased item as separate row. Free ($0.00) purchases are only shown in Item View.

  • Transaction View -shows all items in a purchase, grouped into a single row.

If you want your report to generate new data whenever it's opened, you must select the Generate new report option in the report’s settings. For more information, see To customize the report view under Viewing a report.

Why aren’t my reports showing new features and improvements?

After a new release, you may need to regenerate saved reports to see new features or improvements added to those reports.

Why does the Batch Reconciliation Report not accurately reflect the deposits received?

There are several possible reasons why your Batch Reconciliation Report might not match the deposits received:

  • The Batch Reconciliation Report only displays transactions from your merchant processor. It doesn’t display cash or checks manually deposited into the bank account.

  • The Batch Reconciliation Report only displays transactions that took place within the merchant processor’s default batch period (from the beginning of the day until the processor’s default batch cutoff time). You can sync your Batch Reconciliation Report with the cutoff time set with your merchant processor for more accurate reporting. For more information, see the Batch Reconciliation Report setting in Store settings.

  • If Business has next day funding is enabled, your transactions will be processed the next business day, instead of the standard two to three business day period when next day funding is disabled. As a result, your transactions will show up earlier and won’t be reflected in the Batch Reconciliation Report.

  • The Batch Reconciliation Report allows you to view transactions in WellnessLiving. However, it’s the merchant processor, not WellnessLiving, that processes these transactions. The merchant processor may perform transactions and other activities that WellnessLiving can't track. Such activities may include:

    • Splitting a payment into two transactions. For example, the processor may split a payment of $1000 into two deposits of $500 over two days.

    • Subtracting processing fees from the deposit amount.

    • Delaying the deposit date for a batch.

To perform an in-depth reconciliation between the transactions that have been processed and the deposits you have received, contact your merchant processor.

What’s the difference between Transaction View and Item View?

When viewing the All Sales Report, you can choose to view the transactions in the report in different ways: Transaction View and Item View.

Transaction View

When viewing a report in transaction view, multiple items that were purchased together are shown on a single row and will include both the purchase ID and the transaction ID. For example, if a client buys three items in a single purchase, this purchase is shown on one row.

When a report is in transaction view, the Total Payments summary card is displayed, which shows the total number of transactions during the selected date range.

Item View

When viewing a report in item view, multiple items that were purchased together are shown on individual rows with the same purchase ID. For example, if a client buys three items in a single purchase, each item is shown in a separate row.

When a report is in item view, it will display the Total Items summary card, which displays the total quantity of items sold during the selected date range.

What’s the difference between a Purchase and a Transaction on a sales report?

Purchase

A purchase is a single flow through the store where a client adds a single or multiple items to the shopping cart and pays for them. A purchase in WellnessLiving is identified by a purchase ID, which is the number that appears on the sales receipt. This number is also included when viewing sales reports in payment view or item view.

Transaction

A transaction is the exchange of payment for a purchase. A purchase can have more than one transaction. For example, if the payment for a purchase is split into different payment methods, each payment method used for the purchase will have its own transaction. A transaction in WellnessLiving is identified by a transaction ID. The transaction ID is included when viewing sales reports in payment view.

What’s the difference between Accrual and Cash-based accounting?

When filtering your sales reports, you can choose to filter many of the reports based on two accounting methods: accrual and cash. Below are explanations of accrual and cash-based accounting.

Accrual-based accounting

Accrual-based accounting tracks a sale from the day a client purchases an item from your business. This means that all revenues are recorded when they’re earned and all expenses are recorded when they’re incurred, with the expectation that money will be paid in the future.

Revenues are considered earned when your business provides the client with the product or service they have paid for. Purchases made on the account with a gift card, through a partner like ClassPass, or any other delayed payment/redemption will all show on the day the client redeems the service, not when someone buys the pass used to pay for it.

The exception to this rule in WellnessLiving is with Purchase Options and payment plans. When a client buys a Purchase Option or purchases an item with a payment plan, the sale will appear on a report filtered for accrual-based accounting with its full revenue for the day it was sold.

For example: A customer purchases a $25 gift card at your business on January 1 and redeems the gift card for a $25 item at your business on January 10. Accrual-based accounting would record a sale for $25 on January 10, but no sale would be recorded on January 1, because the revenue isn’t earned until the client makes a purchase with the gift card.

Note: Transactions made using the Account payment method can be viewed in the All Sales Report only when the accrual accounting method is selected.

Cash-based accounting

Cash-based accounting tracks a sale from the day your business received payment for it. This means that all revenues are recorded when they’re received, and all expenses are recorded when they’re paid. This method makes it very easy to track the cash flow of your business but doesn’t account for any receivable or payable sums that haven’t yet been paid.

For example: A customer purchases a $25 gift card at your business on January 1 and redeems the gift card for a $25 item at your business on January 10. Cash-based accounting would record a sale for $25 on January 1, but no sale would be recorded on January 10, because no money was received.

How can I ensure my All Sales report totals are accurate

When displaying or exporting the All Sales Report, failed transactions or account adjustments might be automatically included.

To ensure that automatic account transactions, voided transactions, and manual account adjustments do not appear in your sales report:

  • Set Accounting Method to Cash to ensure that only cash-equivalent transactions are accounted for.

  • Review the following filters:

    • Under Payment Status select only Successful to see only successful transactions.

    • Under Deposit select only the desired deposit types.

    • Under Others, unselect Manual transactions to exclude manual account adjustments

After setting up the filters, you can save the report with these filters applied from the action menu by selecting Save. The next time you visit your saved report, it will include only the data you’d like to see.

How can I see how many members have cancelled?

To see how many members have canceled, access your Memberships report by going to the App Drawer > Reports> Sales > Memberships.

Under Filter, select Membership Status and uncheck all except Canceled to view all canceled memberships within your selected date range.

To include canceled memberships in your report, use the Display Canceled

Memberships filter, to show all canceled memberships based on your report settings.

For cancellations by staff, the Cancelation Reason column will show the reason for the cancelation. If there's a Note icon, you can hover over it for more details.

Where can I see how many memberships are on hold?

To see how many memberships are on hold, use the Membership Status filter in the Memberships report.

To view the number of times and date range that a membership was on hold, hover over the tooltip button in the Status column.

Why are my reports taking so long to update?

There are several reasons why your reports might be taking longer than expected to load or update:

  1. Large Data Volume: If your business has a high volume of transactions, the system may take longer to process and update the reports.

  2. Network Issues: Slow or unstable internet connections can cause reports to be generated and updated slowly.

  3. Complex Filters: Using multiple or complex filters can increase the time it takes to generate and update reports.

  4. System Maintenance: Ongoing system maintenance or updates can temporarily affect the performance and speed of report generation. You can always check the status of our systems at https://status.wellnessliving.com/ .

Important: Reports that have the Generated label on the top, can be generated in the background. You can leave and go back to the report page to see the generated report, or select Generated on the right menu under the Reports section to see your generated reports.

We are continuously working on optimizing our platform to improve the speed and efficiency of report generation. If the issue persists, please contact our support team for further assistance.

What’s the difference between the All Sales report & the Batch Reconciliation report?

All Sales report

The All Sales report provides a comprehensive overview of all sales transactions within a specified period.

It includes details such as transaction dates, amounts, payment methods, and customer information. Has several View Modes, such as Item View and Transaction View, as well as ability to show figures in various accounting methods.

The All Sales report is ideal for tracking overall sales performance, identifying trends, and analyzing revenue streams.

Batch Reconciliation Report

The Batch Reconciliation report focuses on reconciling batches of transactions, typically for accounting and financial auditing purposes.

Contains data at the transaction level processed within a specific timeframe, along with reconciliation status, allowing to analyze discrepancies with your payment processor, and make adjustments if necessary.

The Batch Reconciliation report is useful for ensuring that all transactions are accurately recorded and matched with bank deposits or other financial records.

What does the "Account Payment" stand for?

Account Payment refers to a payment method where clients charge their purchases to their account tab within WellnessLiving. This allows clients to make purchases or book services without immediate payment, and instead, the amount is added to their account balance.

Clients can then make a payment on their account to settle their account balance at a later time, either through a single payment or multiple payments. See the Account Balance article for more details.

How can I save the filters on my reports?

If you often run a report with the same advanced filters, you can save the report to keep your filter choices and save time. Once you've configured the filters, you can save the report with those settings by selecting Save in the action menu. When you revisit your saved report, it will automatically show only the data you’ve selected.

Saved reports can be viewed by all staff members with access to reports. When you save a report, the selected date range will also be saved. For more information, see Customization settings for all reports.

Why don't the All Sales report on the Dashboard & the All Sales report under Reports match?

A discrepancy between the All Sales report on the Dashboard, and the All Sales report under Reports can occur for a few reasons:

  1. Old Report Versions: The Dashboard may be displaying an older version of the All Sales Report. To ensure you have the latest and most accurate version, remove the All Sales Report from the Dashboard and add it again.

  2. Filter and Criteria Differences: The reports might be using different filters or criteria, leading to variations in the data displayed.

  3. Timing Differences: The reports might have been generated at different times, capturing different sets of data.

By updating the report on the Dashboard, you can ensure that it reflects the most current and accurate data available.

Why doesn’t the same data match across different reports?

Various sales reports are intended to provide different points of view of your data. Expected inconsistencies can occur due to:

  1. Timing: The most common issue is reports generated at different times. The reports may reflect different data due to ongoing transactions. Click the “Regenerate” button to view the most up-to-date data.

  2. Filtering and date ranges: Reports may use different filters and default date ranges, causing data to appear inconsistent. If you notice inconsistencies, especially in your saved reports, try opening the unsaved versions, and review the filters and date ranges.

  3. Accounting Methods and View Modes: Some reports have their own built-in accounting method or view mode. For example, the Batch Reconciliation report displays each line by Transaction, whereas Sales Details by Revenue Category displays each line by Item.

  4. Double-counting: Some reports, such as the Revenue Category report, count items sold per revenue category; items with multiple revenue categories may be counted several times leading to what looks like inconsistent data. Set the Revenue Attribution Method to Primary Category Only to view items under only 1 main category.

If you’re still run into issues, please do not hesitate to contact our support team by email or via the in-app chat, and we’ll make sure to look into this with you and make sure your numbers are accurate.

Why aren’t my filters working correctly?

We’re excited to announce an upcoming enhancement to our filters, featuring a more intuitive and user-friendly interface. This update is designed to make filtering your data easier and more efficient.

If you find that filtered-out items are still appearing in your reports, please review your filter settings. Ensure you've correctly selected or unselected the services and products you want under all filter categories to align with your desired data.

Why is my sales report different than it used to be?

There are several reasons why your sales report might appear different than it used to be:

  1. Date Range Changes: Ensure that the date range selected for the report is the same as before. Different date ranges can lead to variations in the data displayed.

  2. Filter Adjustments: Check if any filters have been added, removed, or modified. Filters can significantly alter the data shown in the report.

  3. Data Updates: Any updates or corrections made to the sales data can affect the report. This includes manual adjustments, refunds, or updates from your payment processor.

  4. Report Settings: Changes in the report settings or view modes such as Accounting Methods or View Modes, as well as sorting options or various report customizations, can result in different report outputs.

  5. System Updates: Updates or changes to the WellnessLiving platform itself might impact how reports are generated or displayed. We always strive to provide thorough updates to our community before an update that might affect how your sales reports behave or look like is about to go live.

How can I see the All Sales report broken down by revenue category?

You can use the Sales Summary by Revenue Category or Sales Details by Revenue Category reports. Please make sure to select the correct Accounting Method and Revenue Attribution Method to ensure consistency.

Did this answer your question?