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.


  • 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.


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).