The Monthly Order Report is a detailed monthly document that provides an in-depth overview of your fulfilled orders. Designed for transparency and clarity, it includes itemized sales data, summaries by SKU, and a breakdown of sales-related expenses such as free shipping costs and coupon redemptions. This report is an essential tool for distilleries to track performance, manage payouts, and ensure accuracy in financial operations.
Delivered in an Excel spreadsheet format, the Monthly Order Report focuses on fulfilled orders, ensuring payouts reflect only what has been processed and shipped. It is critical to note that fulfilled orders may differ from sales figures in your dashboard, as payments are based on fulfillment rather than sales.
Important Note: The Monthly Order Report focuses on fulfilled orders, which may differ from the sales figures in your dashboard. Payments are based on fulfillment, ensuring accuracy in payouts.
Key Features of the Order Report
Tracks Fulfilled Orders: Includes only orders shipped during the reporting period, regardless of when the sale occurred.
Comprehensive Financial Overview: Outlines MSRP, wholesale prices, sales expenses, and net payouts.
Transparency: Offers detailed insights into deductions and adjustments, ensuring accountability between retailers and distillers.
Tabs in the Monthly Order Report
The Order Report is divided into several tabs, each designed to provide a specific view of your sales and fulfillment data. Below is an overview of what each tab covers:
Payout Summary Report
Purpose: A consolidated view summarizing all key financial data from the report.
Contents:
Total bottles fulfilled.
Gross and net payouts to the distillery.
Sales expenses incurred, such as discounts and promotions.
Use Case: Quickly assess the total amount owed to your distillery after all deductions.
For more details, see: Understanding the 'Payout Summary Report' Tab
Orders Report
Purpose: Provides line-item details of every fulfilled order during the month.
Contents:
Order and fulfillment dates.
Store name and order ID.
Number of bottles and associated SKUs.
Discounts, shipping costs, and total sales expenses.
Use Case: Analyze individual orders and associated costs for reconciliation or deeper insights.
For more details, see: Understanding the 'Orders Report' Tab
Product Sales Report
Purpose: Offers a detailed view of all products sold during the reporting period.
Contents:
Order ID, SKU, product name, and quantity.
Total MSRP for each product in the order.
Use Case: Ideal for creating pivot tables or analyzing product-specific sales trends.
For more details, see: Understanding the 'Product Sales Report' Tab
Product Sales Summary Report
Purpose: Summarizes total bottles fulfilled for each product during the month.
Contents:
Product names and SKUs.
Total quantity fulfilled and total MSRP value.
Use Case: Quickly identify top-performing products and track overall sales performance.
For more details, see: Understanding the 'Product Sales Summary Report' Tab
Sales Expense Report
Purpose: Itemizes all expenses deducted from your payouts.
Contents:
Discounts, free shipping, and other store policy-driven expenses.
Total expenses for each order.
Use Case: Evaluate the financial impact of promotions and incentives to refine your strategy.
For more details, see: Understanding the 'Sales Expense Report' Tab
Why the Order Report Matters
Financial Clarity: Offers a transparent breakdown of revenues and deductions, ensuring you know exactly what contributes to your payouts.
Performance Insights: Enables distilleries to track fulfillment performance and identify top-selling products.
Promotional Strategy Evaluation: Highlights the financial impact of discounts and promotions, helping you adjust your policies for maximum profitability.
FAQs
Why does the Order Report focus on fulfilled orders?
Payouts are based on orders that have been fulfilled and shipped, ensuring accuracy in financial calculations. This may differ from dashboard sales figures, which reflect all orders placed, regardless of fulfillment status.
Can I access past reports?
Yes, all past Monthly Order Reports are available in your dashboard under the Finance section.
What if I find discrepancies in the report?
If you notice any issues, contact Partner Success. Our team will work with retailers to address and reconcile discrepancies.
The Monthly Order Report is your go-to resource for understanding your payouts and operational performance. By reviewing this report regularly, you can gain valuable insights into your business, refine your strategies, and ensure accurate payouts.
For questions or assistance, contact Partner Success.