📋 In This Article
- Introduction
- How to Generate
- What's Inside
- The Reconciliation Tab
- Detail Tabs
- The Orphans Tab
- Common Questions
Introduction
The Breakdown Report is a separate verification tool that shows you exactly which GrowerIQ activities feed into each field of your ODC report. Use it to audit your data before submission or to answer questions from the ODC about specific numbers.
Think of it as the "show your working" companion to the main report. While the ODC report gives you the totals, the Breakdown Report lists every individual activity that makes up those totals.
When to Use
Generate a Breakdown Report before every quarterly submission, especially if the Pre-Submission Review article shows any amber or red variances.
📝 How to Generate
- Navigate to Reports > ODC Quarterly Report
- Select the year and quarter
- Click Generate Breakdown Report (this is a separate button from the main report)
- Wait for the progress indicator to complete
- Click Download to save the verification XLSX file
Generation Time
The Breakdown Report may take longer to generate than the main report because it pulls individual activity-level detail for every field across all tabs.
📦 What's Inside
The Breakdown Report contains 8 tabs, each serving a different purpose:
| Tab | What It Shows |
|---|---|
| Reconciliation | Field-by-field comparison of expected vs actual values, colour-coded PASS/FAIL |
| All Activities | Every activity in the quarter that could relate to the ODC report, with tagging |
| Crops | Individual activity rows for each crops field (medicinal + scientific, high + low THC) |
| Stock High THC | Individual activity rows for every stock >1% THC field |
| Stock Low THC | Individual activity rows for every stock <=1% THC field |
| Resin | Individual activity rows for every resin field |
| Manufacturing | Individual activity rows for manufacturing fields |
| Orphans | Activities that occurred during the quarter but don't map to any ODC field |
✅ The Reconciliation Tab
This is the most important tab in the Breakdown Report. For each field in the ODC report, it compares two values:
| Column | What It Shows |
|---|---|
| Expected Value | The sum of individual activities listed in the detail tabs |
| Reported Value | The aggregate number that appears in the main ODC report |
| Difference | The gap between expected and reported values |
| Status | PASS or FAIL |
PASS / FAIL Criteria
- PASS — The expected value and reported value match within 1 gram (0.001 kg). Minor rounding differences are tolerated.
- FAIL — The difference exceeds 1 gram. The sum of individual activities does not match the reported total.
What FAIL Means
If any field shows FAIL, it means the sum of individual activities doesn't match the reported total. This could indicate a data issue such as a miscategorised activity, a duplicate record, or an activity that was recorded after the main report was generated. Review the corresponding detail tab for that section.
PASS Does Not Replace the Pre-Submission Review
The Reconciliation tab checks that activities add up to the reported totals (internal consistency). The Pre-Submission Review article checks that the balance equations hold (Opening + Sources - Destinations = Closing). Both checks are important. A report can PASS reconciliation but still have balance variances flagged in the Pre-Submission Review.
Detail Tabs
The six detail tabs (Crops, Stock High THC, Stock Low THC, Resin, Manufacturing, and All Activities) share a common structure:
Crops Tab
Lists every plant-related activity that feeds into the Crops (Medicinal) and Crops (Scientific) tabs of the main report. Each row shows:
- The specific activity (e.g., propagation, harvest, destruction)
- The date it was recorded
- The batch or plant group it belongs to
- Which ODC field it maps to (e.g., "Plants Propagated", "Plants Destroyed")
- The THC classification (High THC >1% or Low THC <=1%)
- Whether it is medicinal or scientific purpose
Stock High THC Tab
Lists every activity that feeds into the Cannabis Stock >1% THC tab. Each row shows the activity, date, lot or batch, the weight in kg (dry weight at 10% moisture), and which ODC field it maps to (e.g., "Grown Own Cultivation", "Domestic Sales", "Destroyed").
Stock Low THC Tab
Same structure as Stock High THC, but for cannabis with THC <=1%.
Resin Tab
Lists every activity that feeds into the Cannabis Resin Stock tab. Includes resin production from cannabis flower, resin purchases, resin used in manufacturing, and resin destroyed.
Manufacturing Tab
Lists every activity that feeds into the Manufacturing tab. This includes raw material inputs, extract production outputs, domestic supply, exports, and destroyed or lost material. Each row identifies the material type (Raw Starting Material, Gross Weight Extract, Delta-9 THC, CBD, or Other THC Isomers).
All Activities Tab
A comprehensive list of every activity recorded during the quarter that could relate to the ODC report. Each activity is tagged with:
- The ODC tab it maps to (Crops, Stock, Resin, Manufacturing, or Orphan)
- The specific field it feeds into
- The month it falls under
Using All Activities for Auditing
The All Activities tab is useful when you need to trace a specific lot or batch across multiple report sections. Filter by lot number to see every ODC-relevant activity for that inventory item.
🔍 The Orphans Tab
Activities listed on the Orphans tab occurred during the reporting quarter but are not claimed by any ODC report field. This helps you identify:
- Miscategorised activities — An activity that should feed into the report but doesn't match any mapping rule
- Unusual operations — Activities that need review to determine if they should be reflected in the report
- Missing data — Inventory-affecting activities that might indicate gaps in your report
Some Orphans Are Normal
A small number of orphan activities is expected. System activities, metadata updates, and certain administrative operations do not map to ODC report fields. These are harmless.
Investigate Inventory-Affecting Orphans
If you see activities on the Orphans tab that involve inventory changes (weight adjustments, transfers, destructions), investigate them. These could represent data that should be captured in the report but is not being mapped correctly. Contact support if you cannot determine why an inventory activity appears as an orphan.
❓ Common Questions
When should I generate a Breakdown Report? Before every submission, especially if the Pre-Submission Review article shows any amber or red variances. It is also useful when the ODC asks you to explain a specific number in your report.
A field shows FAIL in Reconciliation. What do I do? Open the corresponding detail tab to see which individual activities make up that field. Look for activities that seem miscategorised, duplicated, or missing. If you recently recorded new activities, regenerate both the main report and the Breakdown Report to ensure they are in sync. Contact support if you cannot identify the issue.
What are orphan activities? Activities recorded in GrowerIQ during the quarter that do not feed into any ODC report field. Some are expected (system operations, metadata updates). Others might indicate data that should be captured in the report. Investigate any orphans that involve inventory weight changes.
Can I share the Breakdown Report with the ODC? It is designed as an internal verification tool, but you can share it if the ODC requests activity-level detail to support your submission. The Breakdown Report provides a complete audit trail that demonstrates how each reported number was calculated.
Do I need to generate the Breakdown Report every quarter? It is not mandatory for submission, but it is strongly recommended. The Breakdown Report gives you confidence that your reported numbers are accurate and provides documentation if the ODC queries your data.
The Breakdown Report and the main report show different numbers. Why? This can happen if activities were recorded between generating the main report and the Breakdown Report. Always generate both reports close together (ideally one after the other) to ensure they reflect the same data.
For an overview of the full ODC reporting process, see ODC Overview.