On May 23rd and 24th, 2023, the following changes were made to reporting in GrowFlow Retail App. This is a follow-up to the previous update to the Sales report in Insights.
Sales Report
A new and updated Sales Report is now available. The previous Sales report (the legacy report) is the default. The new report can be accessed by clicking on the 'beaker' icon in the upper right-hand corner of the Sales report screen. See the section below for additional information.
The data in the old and new Sales reports should be the same in all but a few uncommon cases. There may be small differences with respect to Returns in the legacy Sales report. In that case, the new Sales report should be considered correct. Please contact our support team if you have any questions.
Shift Summary Report
The Shift Summary report has been updated to provide additional sales data as defined below:
We have renamed the following data on the report. The calculations remain the same. The change was made since these amounts include both sales and taxes. This is noted by the * and description on the report.
“Cash Sales” is now “Cash Total”
“Card Payment Sales” is now “Card Payment Total”
“Other Sales” is now “Other Total”
“Paytender Sales” is now “Paytender Total”.
We have added the amount of Taxes collected to the report.
The Shift Summary Report only includes data for shifts that are closed. Data for Open Shifts is not included in those amounts in the summary section.
Gross Sales was added to the report. It is the sum of Gross Sales for all the shifts that have been closed.
Discounts was added to the report. It is the sum of Discounts for all the shifts that have been closed.
Returns was added to the report. It is the sum of Returns for all the shifts that have been closed.
Net Sales was added to the report. It is the sum of Returns for all the shifts that have been closed.
On the Shift Summary report, the Sum of Net Sales + Taxes should equal the sum of Cash Total + Card Payment Total + Other Total + Paytender Total.
New Sales Report
The new Sales report in the Retail application and the Sales report in Insights now use the same reporting infrastructure. This significantly improves performance and data quality across both platforms.
The new report can be accessed by clicking on the 'beaker' icon in the upper right-hand corner of the Sales report screen.
Report generation performance improvements. Sales reports for multiple days, weeks, and months are now generated within seconds, similar to Insights.
The data for the current day (Today) can be delayed up to one hour. We are continuing to make improvements to reduce this lag. Real-time data is available through other reports including the Shift reports and the legacy Sales report.
We have updated the format of the data. It is now arranged vertically following standard accounting practices.
Sales are broken out by MJ, Non-MJ, and Total.
Sales are broken out by Customer Type, Recreational, Medical, and Total (where applicable).
Product Category Sales have been moved to their own report.
This report does not include “Sales” by Payment Type.
Sales by Product Category Report
Product Category sales are now also available in a separate report. They remain in the legacy Sales report also.
Data for the current day (today) may be delayed up to one hour.
We have updated the format of the data. It is now arranged with the Product Categories in columns, and the financial numbers are arranged vertically following standard accounting practices.
Insights Sales Report
The formatting has been updated to match the new Sales report in the Retail application.
Understanding the Data
Definition of Terms
Gross Sales is the sum of the price of all items sold before any discount or taxes are applied.
Discounts is the sum (net) of discounts applied to the price of the items sold and/or returned.
If a product was sold with a discount of $1.00, and then later in the same shift or time period of the report was returned, the first transaction would have a discount of $1.00, the second transaction would have a negative discount of $1.00, with the net discount amount being $0.00.
Returns is the sum of the price of items returned. The price used is the non-discounted amount.
For example, if the item was $10.00, with a discount of $1.00, for a net price of $9.00, when returned, the return amount would be $10.00.
Net Sales is Gross Sales less Discounts and less Returns.
For example:
Gross Sales: $100.00
Discounts: $10.00
Returns: $5.00
Net Sales: $85.00
Voids is the sum of orders that were completed and then voided. Voids are not included in any of the other sales metrics (Gross Sales, Discounts, Returns, Net Sales).
Payment Amount versus Sales by Payment Type
Payment Amount
This is the sum of payments received.
For example, if the sales amount is $23.48 and $30.00 is paid in cash, the Cash Payment amount recorded is $30.00.
Cash Total, Card Payment Total, Paytender Total, Other Total
Cash Total is the sum of sales and taxes for orders that were paid in cash.
For example, if the sale amount is $20.00 and taxes are $2.00, for a total of $22.00, and the order is paid in cash, the Cash Total is $22.00.
The same is true for Card Payment Total, Paytender Total, and Other Total.