AUSTRALIAN ODC REPORTS IN ONE CLICK
Stop spending days compiling quarterly reports for the Office of Drug Control. GrowerIQ auto-classifies every variance, colour-codes your submission readiness, and generates the comments you need for ODC. One click from data to done.
- Generate all 8 ODC template sheets from one button click
- Colour-coded Pre-Submission Review classifies every variance before you submit
- Activity-level Breakdown Report traces every figure to its source
| 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
Your compliance safety net: built-in Pre-Submission Review
GrowerIQ doesn’t just fill the template. It reviews the entire report for you, classifies every variance, and writes the comments you need for ODC submission. No other platform does this.
| Classification | What It Means |
|---|---|
| BALANCED | Perfect balance, submit with confidence |
| NEGLIGIBLE | Under 100g, within measurement tolerance |
| MOISTURE LOSS | Expected weight loss from drying/storage |
| PROCESSING LOSS | Expected loss from extraction/refinement |
| WEIGHT CORRECTION | Documented inventory adjustment on file |
| REVIEW REQUIRED | Investigate before submitting |
Before GrowerIQ
Export raw data. Build your own reconciliation spreadsheet. Manually investigate every variance. Write explanations for ODC from scratch.
After GrowerIQ
One click. Colour-coded verdict. Auto-generated comments. Submit.
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.
Review & Submit
The Pre-Submission Review analyses every month across all tabs. Colour-coded verdicts (green, amber, red) tell you instantly what’s ready and what needs attention. Suggested comments are generated automatically for your ODC submission.
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 Pre-Submission Analysis
The Pre-Submission Review tab colour-codes every month: green (balanced), blue (moisture loss), yellow (documented correction), or red (investigate). Suggested comments are generated automatically for any variance.
Submit with Confidence
Download the completed XLSX with colour-coded verdicts and auto-generated comments. If the ODC asks questions, your Breakdown Report has the activity-level audit trail ready.
Features
Core capabilities
Pre-Submission Review — Colour-coded variance analysis classifies every discrepancy as balanced, moisture loss, processing loss, weight correction, or review required. Dual-path verification: balance equation AND database snapshot compared for every closing figure.
Breakdown Report — Activity-level audit trail maps every gram to the GrowerIQ activities that produced it. Field-by-field reconciliation accurate to 1 gram. Orphan detection catches unclaimed activities. 8 verification tabs.
All 8 ODC template sheets auto-populated from seed-to-sale data, including Crops (Medicinal + Scientific), Stock (High + Low THC), Resin, and Manufacturing.
Cannabinoid reporting (INCB 2021) — Manufacturing tab breaks extract output into delta-9 THC, other THC isomers, and CBD mass. Gross weight and cannabinoid content tracked separately.
Fresh-to-dry conversion — All weights automatically standardised to dry weight in kg at 10% moisture. Fresh harvest weights converted using your actual drying data. Even complex patterns like batch merges followed by destruction are detected.
Auto-generated submission comments — Plain-language explanations for every variance, ready to copy into your ODC submission form. Zero hours writing variance justifications from scratch.
Use Cases
Who benefits from ODC Quarterly Report automation
Compliance Managers
Review the colour-coded Pre-Submission Review before every submission. Green means submit. Amber means check the auto-generated comments. Red means investigate, with the exact variance already identified.
Quality Assurance Teams
Use the Breakdown Report to trace any number back to the specific activities that produced it. PASS/FAIL reconciliation within 1 gram. Orphan activity detection catches anything the report might miss.
Operations Directors
One-click report generation replaces days of manual compilation. Automated variance classification eliminates the back-and-forth between compliance and operations teams.
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 Back Per Quarter
Per quarter in compliance staff time previously spent on manual data compilation, cross-referencing, and writing variance explanations across 8 interconnected sheets.
Every Variance Explained
7 automatic classifications trace every discrepancy to its root cause. Moisture loss, processing loss, documented corrections. Submit knowing nothing will surprise the ODC.
Audit-Ready On Demand
Generate an activity-level Breakdown Report that maps every gram to the GrowerIQ record that produced it. Reconciliation accurate to 1 gram. If the ODC asks, the answer is already waiting.
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.
How do I explain weight variances in my ODC quarterly report?
GrowerIQ’s Pre-Submission Review automatically identifies the cause of every weight variance. Moisture loss from storage, processing loss from extraction (e.g., crude oil to distillate), and documented inventory corrections are all classified with colour-coded labels. The system generates plain-language comments you can copy directly into your ODC submission.
What causes closing stock discrepancies in cannabis reporting?
Closing stock discrepancies typically result from moisture evaporation during storage, weight lost during extraction or refinement, or manual inventory corrections. GrowerIQ detects each pattern automatically and classifies it (moisture loss, processing loss, or weight correction) so you only investigate genuine data gaps.
How can I verify my ODC report before submission?
GrowerIQ provides two verification tools. The Pre-Submission Review tab colour-codes every month (green = submit, amber = review recommended, red = investigate) and generates suggested comments. The Breakdown Report provides activity-level detail for every number in the report, with PASS/FAIL reconciliation accurate to 1 gram and orphan activity detection.
For detailed field-by-field guidance on every section of the ODC report, visit our Help Centre.
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.
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.