Ximple Solution footer logo

MSA MULTICAT Reporting Software for Tobacco Distributors

MSA MULTICAT Report — Q4 2024
Validated
State Submissions

California

$127,450

Texas

$98,230

New York

$84,890

Total Escrow Liability
$310,570

What is MSA MULTICAT Reporting?

The Master Settlement Agreement (MSA) is a 1998 legal settlement between major tobacco companies and 46 U.S. states. It requires tobacco manufacturers and distributors to make annual payments to states based on cigarette sales volume.

MULTICAT is the standardized reporting format used by states to collect tobacco sales data from distributors. It tracks sales by brand, manufacturer (OPM vs. NPM), quantity, and state — ensuring proper escrow payments and compliance verification.

For tobacco distributors, accurate MSA reporting isn’t optional — it’s a legal requirement with significant penalties for errors or late submissions.

⚠️ Non-Compliance Risk

Inaccurate or late MSA reports can result in fines, loss of tobacco licenses, and liability for unpaid escrow. Manual reporting increases error risk significantly.

Key MSA Reporting Deadlines

Sales Data Collection

Capture all cigarette sales by state, brand, and manufacturer classification (OPM/NPM).


State Report Submissions

Many states require quarterly MULTICAT format reports with reconciled sales data.


Annual Certification

Annual reports due with escrow deposit confirmations for NPM brands.


Directory Compliance

Verify all brands sold are on state tobacco directories; remove non-compliant products.

MSA Reporting by the Numbers

States requiring MSA compliance

Reporting accuracy with automation

Reduction in reporting time

Penalty exposure with proper compliance

Built-In MSA Compliance Features

Ximple ERP includes comprehensive MSA MULTICAT reporting capabilities designed specifically for tobacco distributors. No third-party add-ons or manual exports required.

Automated MULTICAT Generation

Generate state-compliant MULTICAT format reports automatically from your sales data. No manual data entry or spreadsheet manipulation required.

Multi-State Compliance

Manage reporting requirements for all 46 MSA states from one system. Each state’s specific format requirements and deadlines are built in.

OPM vs. NPM Classification

Automatically classify sales by Original Participating Manufacturer (OPM) and Non-Participating Manufacturer (NPM) for accurate escrow calculations.

Escrow Calculation

Calculate escrow deposit requirements for NPM brands automatically. Track deposits, verify compliance, and generate payment documentation.

Directory Verification

Cross-reference products against state tobacco directories. Get alerts when selling non-compliant brands and prevent prohibited sales.

Deadline Management

Never miss a filing deadline. Built-in calendar tracks state-specific due dates and sends alerts before reports are due.

Export & Submission

Export reports in the exact format required by each state. Support for electronic filing where available and paper submission where required.

Audit Trail

Complete documentation of all reported data, calculations, and submissions. Ready for state audits with full transaction-level detail.

Reconciliation Tools

Reconcile reported sales against invoices, inventory movements, and excise tax filings. Identify discrepancies before they become compliance issues.

How MSA MULTICAT Reporting Works in Ximple

From daily sales capture to state submission — the entire MSA reporting workflow is automated within your ERP.

Every tobacco sale is automatically tagged with state, brand, manufacturer, and OPM/NPM classification.

System aggregates sales by reporting period, validates against directory, and flags any compliance issues.

Click to generate MULTICAT format reports for each state. Escrow calculations included automatically.

Export in required format, submit to states, and archive with full audit trail for future reference.

MSA Reports Generated by Ximple

Comprehensive reporting for all MSA compliance requirements — from monthly sales tracking to annual certifications.

MULTICAT Sales Reports

State-by-state cigarette sales data in the standardized MULTICAT format required for MSA compliance.

Sales by brand, manufacturer, and UPC

Stick counts and pack/carton quantities

OPM and NPM classification

Monthly, quarterly, and annual options

NPM Escrow Reports

Calculate and track escrow deposit requirements for Non-Participating Manufacturer cigarette brands.

Per-state escrow calculations

Deposit tracking and verification

Payment documentation

Compliance certification support

Directory Compliance Reports

Verify all tobacco products sold are listed on approved state tobacco directories.

Brand-to-directory cross-reference

Non-compliant product alerts

Directory update tracking

Removal/addition notifications

Excise Tax Reports

State-specific cigarette and tobacco excise tax reports integrated with MSA compliance data.

State and local tax calculations

Tax stamp reconciliation

Cross-reference with MSA data

Filing-ready export formats

Manual Reporting vs. Ximple MSA Automation

See how built-in MSA MULTICAT reporting compares to manual spreadsheet-based processes.

Capability Manual / Spreadsheets Ximple MSA Reporting
Data Collection Export sales data, manually compile from multiple sources ✓ Automatic capture from every sale
OPM/NPM Classification Manual lookup and tagging for each brand ✓ Automatic classification at point of sale
MULTICAT Formatting Manual formatting in Excel, error-prone ✓ One-click generation in correct format
Multi-State Reporting Create separate reports for each state manually ✓ All state reports generated simultaneously
Escrow Calculations Manual calculation based on state rates ✓ Automatic with current state rates
Directory Compliance Manual cross-reference against state lists ✓ Real-time verification and alerts
Deadline Tracking Calendar reminders, easy to miss ✓ Built-in alerts with advance notice
Audit Readiness Compile documentation from multiple sources ✓ Complete audit trail always available
Error Rate High — manual entry and formatting errors ✓ Near-zero with automated validation
Time Required Hours to days per reporting period ✓ Minutes with automated generation

MSA MULTICAT Reporting — FAQ

What is the MULTICAT format and why is it required?

MULTICAT is the standardized data format required by states for reporting cigarette sales under the Master Settlement Agreement. It includes specific fields for manufacturer, brand family, UPC, quantity (sticks), and OPM/NPM classification. States use this data to verify escrow compliance and calculate settlement payments. Using the correct format is mandatory — non-compliant submissions are rejected.

How does Ximple classify OPM vs. NPM manufacturers?

Ximple maintains a database of tobacco manufacturers with their MSA classification status (Original Participating Manufacturer or Non-Participating Manufacturer). When products are set up in the system, they’re linked to their manufacturer and automatically tagged as OPM or NPM. This classification flows through to every sale and report automatically, ensuring accurate escrow calculations for NPM brands.

Can Ximple handle reporting for all 46 MSA states?

Yes. Ximple supports MSA reporting for all 46 states that are party to the Master Settlement Agreement. Each state’s specific reporting requirements, formats, deadlines, and escrow rates are built into the system. You can generate reports for individual states or all states at once, with each report formatted according to that state’s requirements.

How does the system handle state tobacco directory compliance?

Ximple can be configured to cross-reference your tobacco products against state tobacco directories. When a product is removed from a state’s directory, the system alerts you so you can stop selling that product in that state. This prevents compliance violations from selling brands that have lost their directory listing.

What happens if I sell in states with different reporting periods?

Different states have different reporting requirements — some monthly, some quarterly, some annual. Ximple tracks each state’s reporting schedule and allows you to generate reports for any period. The deadline management feature alerts you before each state’s specific due date, so you never miss a filing regardless of varying schedules.

How are escrow deposits calculated and tracked?

For NPM (Non-Participating Manufacturer) cigarettes, Ximple calculates the required escrow deposit based on each state’s per-cigarette rate and your sales volume. The system tracks these calculations, helps you document deposits, and maintains records for compliance certification. Escrow calculations are included in your MULTICAT reports automatically.

Can I reconcile MSA reports with excise tax filings?

Yes. Since both MSA reports and excise tax filings are based on the same underlying sales data, Ximple allows you to reconcile these reports against each other. This helps identify any discrepancies and ensures consistency across all your tobacco compliance filings.

What documentation does Ximple provide for state audits?

Ximple maintains a complete audit trail including: transaction-level sales detail, OPM/NPM classification records, report generation history, escrow calculations, and submission logs. All data can be exported in formats suitable for state auditors, with drill-down capability from summary reports to individual invoices.

Does Ximple integrate with state electronic filing systems?

Ximple generates reports in the electronic formats accepted by state systems. For states that accept electronic filing, you can export directly from Ximple and upload to the state portal. We continue to add direct integrations as states expand their electronic filing capabilities.

How quickly can I be set up for MSA reporting?

MSA reporting capabilities are included in Ximple’s tobacco distribution module. During implementation, we configure your manufacturer database, product classifications, and state-specific settings. For existing Ximple customers, MSA reporting can typically be activated and configured within a few days. Historical data can be imported to provide complete reporting from day one.

Simplify Your MSA Compliance

See how Ximple’s built-in MSA MULTICAT reporting can save hours of manual work and eliminate compliance risk. Request a demo tailored to tobacco distribution.

Excise Tax Management

Automated state and local tobacco excise tax calculation, reporting, and stamp reconciliation.

Age Verification & Compliance

Built-in age verification at POS and eCommerce with logged checks for audit compliance.

FEFO & Lot Tracking

First-expiry-first-out picking with full lot traceability for freshness and recall readiness.