Docs
Compliance Reporting

Compliance Reporting

Generate compliance, club-detail, and cancellation reports for regulators and your accountant.

Wine shipping is regulated state-by-state. OnCloudWine produces the reports most direct-to-consumer wineries need on a monthly or quarterly cadence.

Where reports live

Reports are generated from Reports in the dashboard sidebar.

dashboard.oncloudwine.com

Reports

Generate and download various reports for your organization

ReportDescriptionFormat
Compliance reportMember list with addresses, DOBs, and order history for a date range.CSV
Contact listFull export of all contacts in your CRM.Excel
Club detailsMembership counts, churn, tenure per club.CSV
Cancellation reasonsCancellations by reason, club, and date range.CSV

Compliance report

The compliance report is the one most state regulators care about. It includes:

Member identity

Full name, DOB (for age verification), email, phone.

Shipping addresses

Every address used during the report period, with state codes for cross-jurisdiction reporting.

Order history

Every fulfillment in the date range, with product name, quantity, and shipped date.

Tax data

Where applicable, the tax collected per shipment broken out by jurisdiction.

Generating it

  1. Pick a date range

    Most regulators want a calendar quarter or calendar year. The picker defaults to the last full quarter.

  2. Optionally filter by state

    Some states only want shipments to their state. Filter to just that state code before generating.

  3. Generate

    Reports kick off as a background job. You'll get an in-app notification and email when the file is ready to download.

  4. Download

    The download link expires after 7 days. Re-generate if you need it again.

Club details report

Useful for monthly business reviews or board updates. Per-club breakdown of:

  • Active member count (period-end)
  • New signups in the period
  • Cancellations in the period
  • Net change
  • Average tenure (months)

Cancellation reasons report

The cancellation flow on a contact captures one of these reasons:

ReasonDescription
PRICE_TOO_HIGHMember said the cost was too high.
NOT_DRINKING_ENOUGHWine accumulated faster than they drank.
MOVING_AWAYRelocating to a state where you can't ship.
QUALITY_ISSUESUnhappy with the wine.
DELIVERY_ISSUESShipping problems, missed deliveries, breakage.
CUSTOMER_SERVICEService complaints.
TOO_FREQUENTWanted fewer releases per year.
FINANCIAL_REASONSGeneral budget cut.
HEALTH_REASONSPregnancy, sobriety, dietary changes.
OTHERFree-text follow-up captured at cancellation.

The cancellation reasons report aggregates these by month and club so you can spot trends — a sudden jump in DELIVERY_ISSUES after a heat-wave shipment, for example.

Scheduling reports

Reports are on-demand today. If you need a recurring weekly or monthly report, two options:

Use an API key to fetch contact data programmatically and feed it into your own scheduled job (Zapier, n8n, BigQuery, etc.).

What's next?