Custom Sales Reports

Welcome to a new age of reporting! POSaBIT is thrilled to release custom sales reporting with the ability to build all the sales reports you desire. In this article, you will learn all the ins and outs of POSaBIT's custom sales reporting.

Building Custom Sales Reports

To get to the custom sales reports, go to the POS portal --> Reports --> Custom Reports. Or you can go to one of the listed reports below and select the "Customize" button at the top right of the report to customize an existing report

Reports you can customize:

  • Sales by Product
  • Sales by Product Type
  • Sales by Product Brand
  • Sales by Supplier
  • Sales by Product Tag
  • Sales Profits
  • Sales by Employee

Custom Sales Reporting Basics

From the Custom Sales Report page, you will select what you would like to Report by, and Group by based on what is being reported, turn subtotals on or off, add optional filters, and customize the date range. Click Search to run the report.

  • Report by: This is what the report will start filtering by (Example: Product Type will show the sales by different product types)
  • Group by: This is how the report will group the "Report by" items (Example: If Product Type is the Report by and Group by is Order Type, it will show a breakdown of each order type for the different product types).
  • Subtotals: Turning this toggle on will show subtotals of the groups.
Caveat - subtotals are totaled by page, so if data from a grouping runs off onto another page, then the suggestion would be to increase the number of entries per page (100, 250, 500)
  • Download CSV / Download Excel: These will download the custom report based on the customized settings of the report into either a CSV or Excel file.
  • Columns: Show or hide columns based on your preference. Click Reset to bring back the default columns.
  • Chart: Below the table, your report is also shown as a chart. Use Switch to Bar Chart or Switch to Pie Chart to change how it looks.

Example Custom Report: Report by Customer Profile, and group by Order Type, with an Order types filter to only show Recreational sales, subtotals turned off, and it would look like this:

This is one example of hundreds of ways to customize a report.

Suggested Reports:

Under the Suggested Reports dropdown, users will have the ability to use one of POSaBIT's pre-built custom reports. These have been built based on some of the more commonly requested reports. This will show all types of custom reports (Sales, Discounts, and Inventory), not only custom sales reports.

To make your own custom reports, see the different customization options below:

Report by options AND Group by Options:

Age Group
Displays sales by Age Group
Brand Name
This will display the sales by Product Brands, with a link to go directly to each brand.
Client Type
Displays sales by Client Type
Customer Name
Display sales by individual customers
Customer Profile
Displays sales by Customer Profile (Loyalty, Guest, and non-member)
Customer Referral Source
Displays sales by Customer Referral Source
DOH Compliant (WA Only)
Shows DOH Compliant sales vs non-DOH sales (WA Only)
Employee
Displays sales by Employee
Flower Type
This will display the Flower Types (Indica, Hybrid, Sativa, CBD, etc.)
Fulfillment Method
Displays sales by how the order was fulfilled
Gender
Displays sales by Gender breakdown
Integrator
Displays sales by the integration the order came through
Is Marijuana
Separates marijuana vs non-MJ sales
Lot Number
Displays sales by Lot Numbers
Order Date
Displays sales by Orders Date
Order Day of Week
This will display the Orders by Day of the Week
Order Fraction of Day
This will display the sales by Order Fraction of Day (Morning, Afternoon, Evening, Late Night)
Order Hour
This will display sales by Order Hour
Order ID
This displays orders by sale ID
Order Month
This will display sales by Order Month
Order Origin
This will display sales by Order Origin (POS, Menu Type, etc.)
Order Source
This will display the Order Source (Online pickup, Walk In, delivery)
Order Type
This displays orders by order type (Recreational, Medical, Employee, Employee Med, and Employee Rec)
Order Year
This will display the Order Years
Payment Type
This will display the Payment Type (Cash, Debit, Other, etc.)
Product Family
This will display the Product Families
Product Internal ID
This will display sales by Product Internal ID
Product Name
This will display the Product Names
Product Strain
This will display the Product Strain
Product Type
This will display the Product Type (Flower, Cartridge, Edible (Solid/Liquid), Pre-roll, etc.)
SKU Name
This will display sales by SKU.
SKU Weight
This will display sales by SKU weight.
Supplier Name
This will display the supplier
Terminal
Breakdown of specific terminals
To Cart
How the items were added to the cart (scan or search)
Venue Name
Display a sales breakdown by Venue (only applicable for multi-store merchants)

Additional Filter Options:

Click Filters to show or hide these options:

  • Terminals
  • Employees
  • Product types
  • Suppliers
  • Brands
  • Strains
  • Customer segment
  • Order types
  • Is marijuana (Yes or No)
  • DOH exempt sale
  • Date range (Custom Date Ranges now have no restriction)
When building these reports, keep in mind that if you're building a report with more than 3,000 rows of data, only the first 3,000 rows will show.

Example Reports

  • Report by Age Group
    • Group by Product Type - Understand which age groups like which products
  • Report by Age Group
    • Group by Customer Profile - Understand age of loyalty customers
  • Report by Order Month, Group by Order Year - this is an easy way to view year-over-year sales for each month
  • Report by Brand Name, Group by Employee - track employee sales by each brand - helpful for sales contests
  • Report by Order Hour, Group by Employee - analyze employee sales data by hour to monitor and schedule productivity goals and for wage and hour compliance
  • Report by Order Source, Group by Product Type - analyze the popularity of certain product types in store vs online

Saving Custom Reports

If you are building a report you want to reuse, you can also save the report you built to make it easier in the future.

  1. Once you have your report built out to your liking, click the Save button at the top of the report.
  2. This will open a pop-up where you can customize the report name, interval, and you can even schedule the report to send to any existing user or email, with an option for scheduled frequency.
Note: When adding emails to scheduled reports, the emailed user must have a portal login to access the report. This is to ensure important data is never leaked.
  1. Once you have filled out your ideal name, interval, and schedule, click Save to save it to your custom reports.
  1. To see all your saved reports, from the Custom Sales Report page, click Manage.
    1. You can also get to the saved reports by going to the Saved Reports page under the Reports tab.
  2. This will take you to a page with all your previously saved custom sales reports for easy access.
To edit the report, click on the report name. To edit the scheduling, click the green "Edit" button on the right side of the page.

Report Inbox

There is also a way to view all previously sent scheduled reports by going to the Report Inbox page under the Reports tab. On this page, you will have access to all your scheduled reports that have been sent out. Click the blue Download button to get a downloaded copy.



How did we do?

Powered by HelpDocs (opens in a new tab)

Powered by HelpDocs (opens in a new tab)