Reporting
      Back to home
      1. Help Center
      2. Point of Sale
      3. Reporting

      Tasting Room End-of-Day Practices: Closing Report and Managing Pours

      Closing out the Tasting Room at the end of the day

      At the end of the day, you can utilize these tools to close out your register - and manage the pours in your tasting room.

      Closing Report

      Managing Pours

      Closing Report

      Closing Report allows filtering by Fulfillment Status, Channel, Order Delivery and POS Profile.

      1. Go to Settings > Reports > Order Reports > Closing
        Screen Shot 2023-05-10 at 4.00.03 PM-1
      2. Choose a From Date. The Closing Report shows totals for just the date that is chosen here. It's a snapshot for that one day.
      3. Select the Filters button to see a list of options that you can use to filter the items in the report.
        Screen Shot 2024-03-25 at 3.30.41 PM-1
      4. Choose applicable Filters and then click Apply Filters button.
        Screen Shot 2023-05-10 at 4.09.40 PM-1
      5. Scroll down to view all totals on the screen.
        Screen Shot 2024-03-25 at 3.26.59 PM
      6. Email the Report by clicking on the Email icon in upper left. This will export to a csv file.
        Screen Shot 2024-03-25 at 3.25.01 PM

      What's in the Closing Report

      Click here to download an example of what the CSV export looks like.

      Overview

      • Number of Orders
      • Number of Refunds

      Sales Overview

      • Net Sales
      • Shipping Total
      • Duties Total
      • Bottle Deposit Total
      • Total Sales
      • Tips Total
      • Total Revenue

      Sales By Channel

      • POS
      • Web
      • Inbound

      Tender Details

      • Visa
      • American Express
      • Mastercard
      • Cash

      Sales By Department

      Departments is a primary Product group. Click here for more information about Departments.

      Sales By POS Profile

      POS Profiles are used to segment and track sales and inventory by each Location. Click here for more information about POS Profiles

      Server Tip Out

      Displays Sales Associate name and total amount of tip they received.

      Sales By SKU

      Displays name, SKU, quantity and net sales for the day.

      Club Signups

      Displays name of Customer and Club they signed up for.

      Club Cancellations

      Displays name of Customer and Club they cancelled.

      Reservations

      Displays the name of Experience and total of booking per Experience.

      		  

       

      Managing Pours

      For poured wine, spoiled wine, breakage etc. we highly recommend managing these transactions directly through your accounting system. Commerce7 is a DTC platform and managing Orders such as these will skew your DTC data.

      However, if you do choose to manage these orders in Commerce7, you can track your bottles manually and then ring them out as guest order on POS at $0.  You can then either use our Order Tags or Order Meta Data to identify the order for reporting later.

      The Order Tag option allows you to filter by Order Tag in the Order Dashboard and there is also a Report called 'Sales By Order Tag' to get you the summary of those orders.

      The Meta Data Option will come out of the system as a column in the Order Export. So you can basically see the identifier you have setup (i.e. whether it's a poured wine etc.) on the order in a spreadsheet view.

      Another option could be to track the bottles separately and then do a manual inventory transaction at the end of the day with the reason notes (i.e. poured bottle etc).