AUSTRALIAN ODC REPORTS IN ONE CLICK
Stop spending days compiling quarterly reports for the Office of Drug Control. GrowerIQ generates submission-ready XLSX files directly from your seed-to-sale data, with every sheet filled and every figure validated.
- Generate all 8 ODC template sheets from one button click
- Built-in cross-tab validation catches errors before submission
- Dual-path audit trail verifies every closing stock figure independently
| Jan | Feb | Mar | |
|---|---|---|---|
| Opening Stock | 42.80 | 51.35 | 48.60 |
| Own Cultivation | 18.50 | 12.25 | 22.10 |
| Purchased | 0.00 | 0.00 | 0.00 |
| Used in Mfg | -6.45 | -11.20 | -8.90 |
| Destroyed | -3.50 | -3.80 | -2.15 |
| Closing Stock | 51.35 | 48.60 | 59.65 |
The Challenge
Quarterly ODC reporting shouldn’t consume your entire compliance team.
Every quarter, Australian cannabis licensees face the same ordeal: compile months of inventory data into the Office of Drug Control’s mandated XLSX template. With 8 interconnected sheets, cumulative year-to-date figures, and THC threshold splits, a single mistake can trigger a compliance investigation.
- Days spent pulling data from multiple screens into one spreadsheet
- Manual month-to-month continuity checks across hundreds of cells
- Splitting every gram by THC content (above vs below 1%) by hand
- Cross-referencing stock tabs against the manufacturing tab for consistency
- Q4 annual reconciliation doubles the workload
- One transposition error can prompt an ODC audit notice
The Solution
How GrowerIQ’s ODC Quarterly Report solves it
GrowerIQ pulls every data point from your live seed-to-sale records, fills the official ODC template, validates cross-tab consistency, and delivers a submission-ready XLSX file in seconds.
Select
Choose the reporting year and quarter from the QA Exports page. GrowerIQ knows your licence details, site IDs, and permit numbers from organization settings.
Generate
One click queries your entire inventory history, plant lifecycle events, manufacturing records, and destruction logs. All 8 template sheets are populated simultaneously.
Validate
Five automated checks verify month-to-month continuity, stock-to-manufacturing reconciliation, and row balance. A dashboard tells you if the report is ready or needs review.
Process
How it works
Navigate to QA Exports
Open the ODC Quarterly Report card from QA > Exports. Select your reporting year and quarter from the dropdowns.
Click Generate
GrowerIQ queries all inventory movements, plant events, manufacturing activities, and destruction records for the selected period.
Review Validation
The Instructions sheet displays REPORT READY or REVIEW NEEDED with a breakdown by tab. Five cross-tab checks verify every figure.
Submit to ODC
Download the completed XLSX with the correct file naming convention. Email it before the quarterly deadline. No manual data entry required.
Features
Core capabilities
All 8 official ODC template sheets auto-populated from seed-to-sale data (Crops Medicinal, Crops Scientific, Stock >1% THC, Stock <=1% thc, resin stock, manufacturing, licence details, supply pathways)
Automatic THC threshold classification: inventory split by >1% and <=1% thc based on lab-tested values
Cumulative year-to-date aggregation for all quarters (Q1=Jan-Mar, Q2=Jan-Jun, Q3=Jan-Sep, Q4=Jan-Dec + annual reconciliation)
Dual-path data integrity audit: equation-based closing stock (Path A) vs direct database inventory snapshot (Path B) with variance diagnostics
Manufacturing tab handles 660 data cells across 5 material types, 11 columns, and 12 months automatically
Supply pathway diagrams preserved via Office Drawing object restoration during XLSX generation
Use Cases
Who benefits from ODC Quarterly Report automation
Compliance Managers
Deliver submission-ready reports in minutes instead of days. Focus on reviewing the validation dashboard rather than manually compiling data across spreadsheets.
Quality Assurance Teams
Built-in cross-tab validation catches discrepancies between stock, manufacturing, and resin sheets before they reach the ODC. No more manual reconciliation.
Operations Directors
Scale from one site to multiple permitted sites without multiplying compliance headcount. Each site gets its own correctly formatted report with proper file naming.
Regulatory Compliance
Built for Australian regulatory requirements
GrowerIQ’s ODC reporting is purpose-built for the Narcotic Drugs Act 1967 framework. The system uses the official ODC template (version 2.0, September 2022) and follows the UN Single Convention on Narcotic Drugs definitions for cannabis classification.
- Official ODC template v2.0 used as base file for every report
- Separate reports generated per permitted site as required by regulation
- Cannabis stock reported as dry weight in kilograms at 10% moisture content
- Correct file naming convention: ODC Reporting Q{quarter} {year} {licence}_{site}.xlsx
- Cumulative year-to-date format matching ODC quarterly submission requirements
Ecosystem
Part of the GrowerIQ ecosystem
ODC Quarterly Report automation draws from every module in the GrowerIQ platform to compile complete, accurate regulatory submissions:
Cultivation Tracking
Plant lifecycle events (propagation, harvest, destruction) feed the Crops Medicinal and Crops Scientific tabs automatically.
Learn more →Inventory Management
Lot movements, sales, transfers, and destructions populate the Stock and Resin sheets with accurate source and destination data.
Learn more →Quality Assurance
Lab-tested THC values determine the automatic classification of inventory into above or below 1% THC threshold categories.
Learn more →Results
Business impact
Hours Saved Per Quarter
Per quarter in compliance staff time previously spent on manual data compilation, cross-referencing, and continuity checks across 8 interconnected sheets.
Automated Validation Checks
Cross-tab consistency validation catches errors that manual processes miss: month continuity, stock-to-manufacturing reconciliation, extraction yields, and row balance.
Copy-Paste Errors
Every cell is populated directly from your database. No manual data entry means no transposition errors that could trigger ODC compliance investigations.
FAQ
Frequently asked questions
Does the report match the official ODC template exactly?
Yes. GrowerIQ uses the official Office of Drug Control template (version 2.0, September 2022) as the base file. All 8 sheets are populated in the exact format ODC requires, including the supply pathway diagrams. The output XLSX is submission-ready.
How does GrowerIQ handle the cumulative year-to-date format?
ODC reports are cumulative: Q2 includes January through June, not just April through June. GrowerIQ automatically aggregates the correct date range for each quarter, so Q1 covers Jan-Mar, Q2 covers Jan-Jun, Q3 covers Jan-Sep, and Q4 covers Jan-Dec with annual reconciliation.
What validation checks run before I can submit?
Five automated checks verify data integrity: month-to-month continuity (closing stock equals next month opening), stock-to-manufacturing reconciliation, resin-to-manufacturing reconciliation, extraction yield reasonableness, and equation-based row balance. A dashboard on the Instructions sheet shows REPORT READY or REVIEW NEEDED with specific items to check.
Can I generate reports for multiple sites?
Yes. Australian regulations require separate reports per permitted site. GrowerIQ generates site-specific reports with the correct ODC file naming convention: ODC Reporting Q{quarter} {year} {licence_id}_{site_id}.xlsx.
How does the system split inventory by THC content?
The ODC template requires separate tracking for cannabis above 1% THC and at or below 1% THC. GrowerIQ automatically classifies inventory based on lab-tested THC values and routes data to the correct sheet, eliminating manual threshold calculations.
Customer Reviews
Trusted by cannabis operators worldwide
Platform
Explore GrowerIQ Modules
ODC Quarterly Report automation integrates seamlessly with the full GrowerIQ platform. Pull compliance data from cultivation batches, quality workflows, and inventory management.
Cultivation
Software that conforms to your operations
Manufacturing
Produce the best quality products
QMS
Connect your QA team to the rest of your operations
CRM
Track Accounts, Orders, and Shipments in one place
GACP/EU GMP
Capture new markets through high-quality standards
Reporting & Data
Multi-facility and team reporting in one place
See ODC reporting automation in action
Ready to stop spending days on quarterly compliance reports? Let us show you how GrowerIQ generates submission-ready ODC reports in seconds.
Recommended For You
About GrowerIQ
GrowerIQ is changing the way producers use software - transforming a regulatory requirement into a robust platform to learn, analyze, and improve performance.
To find out more about GrowerIQ and how we can help, fill out the form to the right, start a chat, or contact us.