Custom Discount Reports

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

Building Custom Discount Reports

To get to the custom sales reports, go to the POS portal --> Reports --> Custom Reports.

Custom Discount Reporting Basics

From the Custom Reports page, you will select Discounts at the top. Then you can select what you would like to Report By, and Group By based on what is being reported, display subtotals (when applicable), add optional filters, and customize the date range.

  • Date Range (Custom Date Ranges now have no restriction)
  • Report By: This is what the report will start filtering by (Example: Product Type will show the discounts used 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 Customer Type, it will show a breakdown of each customer type for the different product types).
  • Show Subtotals: Enabling this 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 ‘show entries’ (Show 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.

Example Custom Report: Report by Product Brand, and group by Product Type, enabled subtotals, and it would look like this:

This is one example of hundreds of ways to customize a report. To break down the different customization options, see below:

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, not only custom discount reports. The only current suggested discount report is the Discounts by Product.

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

Report By options AND Group By Options:

Age Group
Displays discounts used by Age Group type
Customer Profile
Displays discounts used by Customer Profile (Loyalty, Guest, and non-member)
Customer Type
Displays discounts used by Customer Type
DOH Compliant (WA Only)
Shows DOH Compliant discount sales vs non-DOH discount sales (WA Only)
Discount Active
Display discounts by whether they are active or not
Discount Applies To
Display discounts by whom they apply to
Diiscount Barcode
Display Discounts used by barcode
Discount Kind
Display discounts by kind
Discount Link
Display discounts used with a link to the discounts
Discount Manager
Display discounts used by which manager approved the discount
Discount Name
Display by Discount Name
Discount Stacking
Display discounts by stacking vs non-stacking
Discount Type
Display discounts by the Discount Type
Employee
Displays Discounts by Employee
Flower Type
This will display discounts by Flower Types (Indica, Hybrid, Sativa, CBD, etc.)
Gender
Displays discounts by Gender breakdown
Is Marijuana
Separates marijuana vs non-MJ discounts
Lot Link
Discplay Discounts by Lot with a link to each lot
Lot Number
Displays discounts by Lot Number
Order Date
Displays discounts used by Order Date
Order Day of Week
This will display discounts by Day of the Week
Order Fraction of Day
This will display the discounts used by Order Fraction of Day (Morning, Afternoon, Evening, Late Night)
Order Hour
This will display discounts used by Order Hour
Order Month
This will display discounts used by the month
Order Origin
This will display discounts used by Order Origin (POS, Menu Type, etc.)
Order Source
This will display discounts used Order Source (Online pickup, Walk In, delivery)
Order Year
This will display discounts used by the year
Payment Type
This will display discounts used by Payment Type (Cash, Debit, Other, etc.)
Product Brand
This will display discounts used by Product Brands
Product Family
This will display discounts by Product Families
Product Internal ID
This will display discounts used by Product Internal ID
Product Link
This will display discounts used for products and includes a link directly to each product.
Product Name
This will display discounts used by Product Names
Product Strain
This will display discounts used by Product Strain
Product Type
This will display discounts used Product Type (Flower, Cartridge, Edible (Solid/Liquid), Pre-roll, etc.)
SKU Link
This will display discounts used by SKU with a link to the lot associated to the SKU.
Supplier
This will display discounts by supplier
Supplier Link
This will display discounts by supplier and includes a link to go to the supplier's profile page within POSaBIT.
Terminal
Breakdown of discounts by specific terminals
To Cart
How the items were added to the cart (scan or search)
Venue Name
Display discounts used by Venue (only applicable for multi-store merchants)

Additional Filter By Options:

  • Terminals
  • Employees
  • Product Types
  • Suppliers
  • Brands
  • Strains
  • Flower Types
  • Customer Segment
  • Customer Types
  • Is Marijuana? (Yes or No)
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.

Saving Custom Discount 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 Saved Reports.
    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)