Top utilized Sales reports in Dutchie POS Backoffice

Learn more about the top Sales reports in Dutchie POS Backoffice.

Sales reports provide some of Dutchie Backoffice's most useful features to help elevate your business. Each report provides valuable insights and data to help you make informed decisions and drive your business toward success. Whether it's tracking product performance metrics, analyzing customer behavior, or monitoring key sales trends, sales reports allow you to access this information quickly and easily. This comprehensive guide will showcase the top Sales reports that cater your diverse needs and preferences.

Explore Sales Reports

  • Average Order Value 
  • Closing Report
  • Daily Sales Breakdown
  • Discount Detail Report
  • End of Day Summary
  • Inventory Transaction Report By Category
  • POS Hour Totals
  • POS Transactions By Date Report
  • POS Transaction Summary
  • Sales by Category
  • Sales Report

How to Find Sales Reports

When logged into the Backoffice, go to Reports > Sales. This will take you to the overview page of all the sales reports where you can search for specific reports by name using the Search Sales Reports search bar. There are hundreds of reports to choose from, so we do recommend utilizing this search bar in tandem with either the top used reports listed above or the help desk article, ‘What Kinds Of Reports Can I Run in the Dutchie Backoffice?’

Mark your Favorites

The Favorites feature in the Reports module allows you to favorite your top used reports so they are easy to find and quickly accessible. You can click the heart icon on your top utilized reports to have those reports show up in the Favorites panel of the Reports homepage or at the top of the list on the Sales Reports page. 

Customize Your Reporting View

When working with reports, anytime you see a settings cog, this means you can customize the table to view the information how you see fit. This adjustment is user specific and will only impact your viewing experience. Options can be checked, unchecked, or dragged and dropped to instantly reorder the columns in the viewed report. 

Additionally, when you see an Actions dropdown, you can print a copy of the report in question, or export it to excel. 

Average Order Value

  • What Does This Report Do: This report shows the average order value of the cart, gross sales, net sales, number of items sold, and number of transactions by budtender. In addition, if the fulfillment model is selected, data shows the budtender responsible for adding the item to the cart, see AOV report overview.
  • Key Fields: Transactions, Items, Gross AOV, Net AOV, Net AOV w/ Tax. 
  • Why Businesses Love This: This report is used to help you understand the average order value of each cart for your budtenders. Through this report you can get insight into which budtenders have the highest cart values on average, budtender order fulfillment, other budtender trends that can help you with employee incentives and drive engagement.  

Closing Report

  • What Does This Report Do: It provides data for accounting purposes and data that helps you with store closing. The closing report is so detailed, it has its own help desk page that can be accessed here. 
  • Why Businesses Love This: This report is a critical step to a successful close of business when used every day. While this report can be accessed retroactively at any point in time, many operators like to save digital copies at the end of each business day as part of their closing workflow. This provides critical information on profits and losses, breakdown in payment tender types, an overview of discounts issued, and specific details on products sold. 

Daily Sales Breakdown

  • What Does This Report Do: The Daily Sales Breakdowns report shows detailed sales totals with tender type breakdowns as well as a category breakdown of daily sales, see Daily Sales Breakdown report overview.
  • Key Fields: Location, Return Total, Date, Customer Type, Total Sales, Discounts, Cost, Description, Pre Tax Loyalty Spent, Post Tax Loyalty Spent.
  • Why Businesses Love This: This report is best used on a daily basis to see a summary of sales by Master Category. It helps you evaluate what categories of products are selling well or not, as well as your profit for each. Returns, profit, and taxes are all elements that make this report valuable for operators.  

Discount Detail Report

  • What Does This Report Do: Provides details associated with every discount applied during the input date-range. Can be run for all locations. Inputs: To Date, From Date, Lsp, Location (optional, see Discount Detail Report overview.
  • Key Fields: Location, Patient, Discount Name, Product Description, Discount Code, Price, Serial No., Discount Amount. 
  • Why Businesses Love This: The "Discount Detail Report" offers a comprehensive breakdown of all discounts applied within the specified date range, with the flexibility to run the report for all locations or a specific location if desired. This detailed discount data empowers business operators to monitor and analyze discount usage, evaluate the effectiveness of various discount strategies, track employee compliance with discount policies, and identify trends in customer behavior and preferences related to discounts. By leveraging this information, businesses can optimize their discount strategies, ensure adherence to discount policies, and make data-driven decisions to enhance sales and customer satisfaction.

End of Day Summary

  • What Does This Report Do: The End of Day Summary report gives you a snapshot of all your sales data for the day, see End of Day Summary report overview.
  • Key Fields: Location, Coupons, Tax, Cash Given Back, Transaction Count, Item Count, Net Profit, Invoice Total.
  • Why Businesses Love This: Want a valuable summary of your store's performance at the end of the day? This report offers that insight. Data such as returns processed, taxes collected, transactions completed, and items sold are all accessible in this report.  

Inventory Transaction by Category

  • What Does This Report Do: Lists sales by category per day for the timeframe specified, see Inventory Transaction by Category report overview.
  • Key Fields: Date, Cannabis, Master Category, Price, Discounts, Net Amount, Total Tax, Cost.
  • Why Businesses Love This: This report empowers operators to monitor and analyze sales performance for each product category, identify popular and high-margin categories, track pricing and discount effectiveness, and assess overall profitability. With these insights, the operator can make informed decisions regarding inventory management, marketing strategies, and pricing adjustments to optimize revenue and maximize profitability.

POS Hour Totals

  • What Does This Report Do: The POS Hours Totals report shows you hour by hour POS sales data such as total transactions, items, and sales at the POS for a given location, see POS Hour Totals report overview.
  • Key Fields: Hours Starting, Day, Average Transaction Amount, Delivery Count, Average Items Sold.
  • Why Businesses Love This: This report is used to see hourly trends of your POS sales data. It can help you with information such as, 'How many items did you sell between 12-1 pm on Friday?’ and ‘Which hours of the day do you have the most sales volume?’.  

POS Transactions by Date Report

  • What Does This Report Do: Lists the POS transaction details in the specified timeframe. This report includes the Customer, SKU, Category, and Description of the items, see POS Transaction by Date report overview.
  • Key Fields: POS ID, Patient ID, Category, Description, Prescription Number, Grams, Gross Price, Discount Amount, Sold Price, Responsible for Sale, Cost, Profit, Order Source, Order Type. 
  • Why Businesses Love This: This report provides insights into sales performance, inventory management, customer behavior, employee performance, and other data that helps you identify transaction trends. When armed with this comprehensive data, a business operator can make informed decisions to improve sales, optimize inventory, enhance customer satisfaction, and increase overall profitability.

POS Transaction Summary

  • What Does This Report Do: Lists POS transaction information without individual item details for transactions that occurred in the specified timeframe. This report includes revenue and cost information along with the employee and register that completed the sale, see POS Transaction Summary report overview. 
  • Key Fields: POS ID, POS Date, New Customers, Total Items Sold, Total Items Sold Cannabis, Total Items Sold Non-Cannabis, Unit Price, Responsible for Sale, Discount Amount, POS Coupon Amount, POS Tax, Total.
    Note: The New Customer designation indicates customers that were created during the specified timeframe. It is possible for a new customer to show up on this report multiple times if they made multiple purchases in the timeframe.
  • Why Businesses Love This: This report offers data on new customer acquisitions, total items sold (separately for cannabis and non-cannabis), unit prices, discounts, taxes, net profit, and various payment methods used. With this comprehensive information, operators can assess overall transaction performance, customer acquisition trends, revenue sources, and payment preferences, facilitating strategic decision-making to enhance profitability and customer service.

Sales by Category

  • What Does This Report Do: The Sales by Category report gives you sales summary data such as gross sales, discounts, net sales, and wholesale cost, grouped by day within a given timeframe for each master category, see Sale by Category report overview. 
  • Key Fields: Master Category, Sold Date, Quantity, Grams Sold, Cost, Discounts, Net Sales. 
  • Why Businesses Love This:  This report provides a concise overview of daily sales data for the selected date range, aggregated by each product master category. The report encompasses all locations, ensuring a comprehensive view of sales performance. This data enables business operators to track sales trends for different product categories, identify high-performing and low-performing master categories, analyze profitability, assess sales volume in terms of quantity and weight, and optimize inventory management and pricing strategies based on the demand for each master category. With this information, businesses can make informed decisions to enhance product offerings, improve profitability, and drive overall growth.

Sales Report

  • What Does This Report Do: Transaction level sales data within a given timeframe, Sales Report overview. 
  • Key Fields: Transaction ID, Date, Who Added to Cart, Customer, Customer Type, Vendor, Product, Category, Package Number, Batch, External Package ID, Quantity, Unit Grams, Grams, Revenue, Cost, Discounts, Net, Void Date, Return Date.
  • Why Businesses Love This: This detailed sales data enables business operators to analyze individual transactions, monitor revenue generation, track customer behavior, assess product popularity, measure profitability, and identify trends over the specified period. With this information, the business operator can make data-driven decisions, optimize marketing strategies, improve inventory management, and enhance overall sales performance for increased business success.

Additional reading

Was this article helpful?