Platform: Enolytics DTC
Summary:
What it shows: A comprehensive, line-by-line breakdown of every order detail within your selected time period — perfect for accounting reconciliation and financial reporting. This ready-made report captures everything from order basics (dates, status, customer info) to product specifics (SKUs, quantities, pricing) plus all the financial components your accounting team needs (net sales, shipping, taxes, tips). No setup required.
Who should use it:
• Accounting and finance teams
• Operations managers handling reconciliation
• Winery owners preparing financial statements
When to use it:
• Monthly or quarterly accounting close processes
• Reconciling payment processor statements with internal records
• Preparing detailed financial reports for investors or lenders
• Auditing order fulfillment and payment discrepancies
Questions this report answers:
• "How do I get a detailed export of all our orders for accounting purposes?"
• "Where can I find every transaction broken down by taxes, shipping, and tips?"
• "Can I get a report showing exact order details including fulfillment dates and payment status?"
• "How do I pull all order line items with pricing for financial reconciliation?"
• "Where can I see complete order information including customer details and product SKUs?"
Tip: Since this report includes Current Period (CP) measures, make sure to set your date picker to match your accounting period — whether that's month-to-date, quarter-to-date, or a custom range for your financial reporting cycle.
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 Order Details in Period
Quick Stats:
0 filter(s) applied
21 dimension(s) displayed
9 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
Shows comprehensive line-by-line breakdown of every order detail within selected time periods for accounting reconciliation and reporting.
Filters Applied
✅ No filters applied - this bookmark shows all available data.
📋 Columns Displayed
Dimensions:
Order Number — The actual order number of the order (normally represented in numeric format but we will use it as a string)
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)
Fulfillment Date — Date when this event occurred
Order Status — Indicates the status of the order, likely something like Paid or Completed. 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.
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.
Channel Type — This is a mapped field and is an enolytics ENUM. (eg. Club, Tasting Room or Website)
Sales Attribute — This is a WineDirect specific field. Sales attribute are discreet dropdown values helping to categorize the order. It is not often used.
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)
First Name — Contact first name as defined in the contacts table
Last Name — The name of the actual club as specified in the respective CRM. (eg. 3 Bottle Pinot Noir Club). A customer can belong to multiple clubs at once but the club itself can only exist once within the winery data.
Ship To State — Abbreviated state code of person shipment is being sent to
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
Item Quantity Fulfilled — order items level parameter indicating the number of items fulfilled in the order (C7 only)
Sold Price — The price at which the item was sold, after discounts.
Original Price — The List (retail) price of the item, as written by the CRM at the time the order was completed. This normally is the value of the product_price at the time that the order was created. The combination of item_original_price and item_sold_price will allow us to calculate the discount for the item.
Inventory Pool — The name of the physical inventory location, aka inventory pool (eg. warehouse, tasting room)
Measures:
ℹ️ Additional Details
Bookmark ID:
53acc1a5-99b6-4384-9995-67b0d5b5a931