The Sales by Product report generates a list of individual products with units sold, sale, and tax information.
In order to optimize our reporting, reports over a 2-week period will no longer be shown in our UI. Any reports over a 2-week period will be auto-generated and sent to the email you are logged in with.
- To access these generated reports in BLAZE, navigate to Data Export > Generated, you will find a list of generated reports you can easily download.
The Sales by Product report can be accessed by navigating to Data Export > Transaction. It will be located within the list of reports.
The following is a list of all the types of data you will get in this report, and what they all mean. There is also an example export of this report attached to this support document.
- Brand: The brand assigned to the product in BLAZE.
- Product: Name of the product as assigned in BLAZE.
- SKU: The SKU of the product as assigned in BLAZE.
- Category: Category of the product as assigned in BLAZE.
- Vendor: The vendor name as listed in BLAZE.
- Units Sold: Total number of units sold in the specified date range.
- COGS: COGS stands for Cost of Goods Sold. To calculate this, BLAZE uses the batch COG on a unit level and applies it to the quantity being purchased by the customer to get COGS. This does not include excise tax, excise tax is a separate line item.
- Retail Value: Retail value is the price the consumer pays BEFORE any discounts, rewards, promotions and/or taxes have been applied.
- Subtotal Sales: Total of sales before taxes.
- Pre AL Excise Tax: Total of pre-tax excise applied for AL (Arms Length) sales.
NOTE: The vendor of the product determines whether AL or NAL excise tax is applied. - Pre NAL Excise Tax: Total of pre-tax excise applied for NAL (Non-Arms Length) sales.
NOTE: The vendor of the product determines whether AL or NAL excise tax is applied. - Post AL Excise Tax: Total of post-tax excise applied for AL (Arms Length) sales.
NOTE: The vendor of the product determines whether AL or NAL excise tax is applied. - Post NAL Excise Tax: Total of post-tax excise applied for NAL (Non-Arms Length) sales.
NOTE: The vendor of the product determines whether AL or NAL excise tax is applied. - Display City Tax: Total of city taxes applied.
- Display County Tax: Total of county taxes applied.
- Display State Tax: Total of state taxes applied.
- Display Federal Tax: Total of federal taxes applied.
- Total Tax: Total of all applied taxes.
- Credit Card Fees: Total of Credit Card fees applied to the transaction.
NOTE: Fees can be configured in Global Settings > Current Shop Settings > Fees & Minimums - Cashless ATM Fees: Total of Cashless ATM fees applied to the transaction.
NOTE: Fees can be configured in Global Settings > Current Shop Settings > Fees & Minimums - Delivery Fees: Total of delivery fees.
NOTE: Delivery fee pricing is set in Global Settings > Current Shop Settings > Fees & Minimums - After-Tax Discounts: Total of discounts added after taxes have been applied.
- Margin: Profit margin for the specified product in the defined date range.
- Revenue/Unit: Revenue generated per unit sold.
- Gross Receipts: Gross receipts is the sum total of all of your sales including taxes and fees, but not including discounts.
NOTE: Sales + Taxes + Fees - Discounts = Gross Receipts. - % of Sales: Percentage of total sales. The formula is total sales divided by a number of transactions.
NOTE: Sales ÷ # of Transactions.