Platform: Enolytics DTC
Summary:
What it shows: A comprehensive order-level export with complete transaction details and customer shipping information. This ready-made report pulls every order field you need for accounting reconciliation, tax reporting, and detailed sales analysis — no setup required.
Who should use it:
• Accounting teams reconciling sales data with payment processors
• Finance managers preparing detailed transaction reports for audits or tax purposes
When to use it:
• Monthly or quarterly accounting closes when you need complete order details
• Tax season preparation requiring itemized sales data with customer locations
• Detailed sales analysis requiring order-level granularity across all channels
Questions this report answers:
• "How do I export all my order details for my accountant?"
• "Where can I get a complete breakdown of sales, shipping, and taxes by order?"
• "Can I pull all transaction data with customer shipping addresses for tax reporting?"
• "How do I get order-level data showing what was sold, when, and for how much?"
• "Where can I find a detailed export showing payment status and shipping information for each order?"
Tip: Use the date picker to focus on specific accounting periods — the Order Submitted Date column lets you align the data with your reporting timeline, while Completed Date shows when transactions were finalized.
Note: Parts of this article were generated with AI and may not be perfect. If something looks off or could be better, click the 😞 below — it opens a quick chat so you can let us know.
📂 How to Access This Report
This is a public bookmark — a pre-built report ready for you to use. You don't need to create it from scratch.
To open it:
Click the Bookmarks icon in the left sidebar
Look under Public Bookmarks
Open the folder: Accounting Reports
Click Accounting Report # 2
Quick Stats:
0 filter(s) applied
20 dimension(s) displayed
6 measure(s) displayed
Report Page: Build Beyond Limits | Advanced Reporting
⚠️ Date Picker Required: This report uses time-sensitive measures that respond to the date picker. The bookmark does not save date picker settings. Please adjust the date picker to ensure the report shows the data for your desired time period.
Filter Behavior: When you select this bookmark, your existing filters will be replaced with the bookmark's saved filters.
📝 Original Description
Complete order export with transaction details and shipping data for accounting reconciliation, tax reporting, and sales analysis.
Filters Applied
✅ No filters applied - this bookmark shows all available data.
📋 Columns Displayed
Dimensions:
Order Submitted Date — This is the to local time zone converted date of the order_submitted_at (UTC timestamp)
Completed Date — This is the to local time zone converted date of the order_completed_at (UTC timestamp)
Order Number — The actual order number of the order (normally represented in numeric format but we will use it as a string)
Order Source — Indicates whether the order was created internally by the CRM or if it was created by an external source like TOCK or imported through the API as part of a data migration. The likely values will be 'Internal' and 'External'
Payment Status — Indicates the status of the payment likely something like Paid, Authorized or Cancelled. We will use this status on several occassions to standardize on the order status and to run formulas based on payment and order status. Therefore we may need to map to our standard.
Shipping Status — The status of the fulfillment of the order. likely values are Fulfilled, Not Fulfilled, Partially Fulfilled, or No Fulfillment Required.
Order Type — The order_type is the channel or order type the transaction happened in. Order Type is the lowest level of the transaction channel. Commerce7 has limited channels (POS, Club, Web, Inbound), while WD allows for free text creation of order types. The channel in Commerce7 is equivalent to the order type in WD. VST doesn't have a field for channel but has a set of booleans (isClub, IsWeb, etc.) that allow us to create an order type.
Order Delivery Method — The order delivery method indicates whether the order was shipped or if it was picked up (obvious values are Pickup, Ship or Carry Out)
Item Name — The name of the product as defined in the CRM
Product Type — The product type of the product. This will be very important going forward as we will need to distinguish between wine, bundles and non-wine types. The product types are the result of enum tables and may have to be mapped to allow us to have efficient transformations.\nTypes can be:\n- Wine\n- Bundle\n- General Merchandise\n- Tasting\n- Reservation\n- Event Ticket\n- Gift Card\n- Collateral\n- Rebate
Item SKU — The unique product sku (stock keeping unit) as defined in the CRM
Quantity — The quantity of the item/sku in the order.
Sold Price — The price at which the item was sold, after discounts.
Order Club Name — Name of the club linked to the club order. that way we can link the revenue to that specific club.
Ship To First Name — First name of person shipment is being sent to
Ship To Last Name — Last name of person shipment is being sent to
Ship To City — City of person shipment is being sent to
Ship To State — Abbreviated state code of person shipment is being sent to
Ship To Zip Code — Zip code of person shipment is being sent to
Department — Departments serve as broad categories to help organize Products internally, mainly for accounting purposes and to be displayed in Reports. We use departments extensively to identify tasters, display data in the Tasting Room Module for Tasting Details and Glass Pours.
Measures:
ℹ️ Additional Details
Bookmark ID:
bed4a9eb-b8c1-4585-b393-f855249c8e21