The short answer
To reconcile Metrc to QuickBooks, tie three things out every month: ending inventory (Metrc package quantities times your unit costs versus the inventory balance on your balance sheet), sales (Metrc sales receipts versus POS and recorded revenue), and inventory movements (waste, adjustments and transfers versus the entries in your books). Investigate every difference above a set threshold, document the cause, and book the correcting entry before you close the month. Done monthly, it takes hours; done annually, it takes weeks and weakens your COGS position.
Why does Metrc need to match your books?
Metrc (and other state track-and-trace systems like BioTrack, depending on your state) is the regulator's record of every plant, package, transfer and sale. QuickBooks, or whatever ledger you use, is the record your tax return is built from. When the two disagree, both your license and your tax position are exposed.
Under Section 280E, adult-use operators can't deduct ordinary business expenses, so cost of goods sold carries enormous weight. COGS is computed from beginning inventory, plus purchases and production costs, minus ending inventory. If ending inventory in the books doesn't match what the state system says you physically hold, your COGS number is unsupported, and an unsupported COGS number is exactly what an examiner will test first.
The short version: Metrc proves the units. Your cost records prove the dollars per unit. The reconciliation proves units times dollars equals the balance sheet.
If you haven't yet set up inventory and COGS accounts that can actually be reconciled, start with our guide to building a cannabis chart of accounts.
What is the monthly Metrc to QuickBooks checklist?
Run this within the first 10 business days after month-end, after bank reconciliations are done and before you finalize financial statements.
- Freeze the snapshot.Export Metrc active packages (and plants, for cultivators) as of the last day of the month. Save the file with the date. Reports pulled on the 9th won't reflect the 31st if anything moved in between.
- Run a physical count or cycle count.Compare a counted sample (or a full count at quarter-end) to Metrc. Fix Metrc discrepancies through proper adjustments with reason codes, not by quietly editing quantities.
- Cost the Metrc quantities.Apply your unit costs by product or package to the Metrc snapshot. For producers, this is your capitalized production cost under IRC 471; for resellers, it's purchase price plus allowable inbound costs.
- Compare to the general ledger.Tie the costed total to the inventory accounts on the balance sheet, broken out by category (raw materials, work in process, finished goods) if you track them separately.
- Tie out sales.Compare Metrc reported sales for the month to POS sales and to revenue in the books. Differences usually point to voids, returns, discounts or POS sync failures.
- Review movements.Pull Metrc waste, adjustments and outbound/inbound transfers. Confirm each has a matching entry: waste and shrink expensed or written off, transfers recorded as sales or receipts at the right value.
- Book adjustments and document.Post the true-up entry, attach the reconciliation workbook and exports, and write a one-line explanation for each variance over your threshold.
What causes most Metrc vs. QuickBooks variances?
After enough of these, you see the same culprits again and again:
- Timing. A transfer manifest accepted in Metrc on the 31st but the vendor bill entered on the 3rd (or the reverse).
- Unrecorded waste. Destruction logged in Metrc but never written off in the books, so the ledger carries inventory that no longer exists.
- Unit-of-measure mismatches. Metrc tracks grams or each; your purchase records may be in pounds or cases. One conversion error can move a balance by a lot.
- Repackaging and remediation. New packages created from old ones without carrying the cost basis forward, which strands cost on the old package.
- Samples, trade samples and employee product. Recorded in Metrc under the correct category but never relieved from inventory in the books.
- POS and Metrc sync gaps. Sales that failed to post to Metrc, returns processed in one system and not the other.
- Stale unit costs. Costs not updated after a price change or a new harvest batch, so quantities match but values don't.
Tip: Set a materiality threshold before you start, for example any single product line off by more than a set dollar amount or percentage you choose. Investigate everything above it; track the rest as a running net variance so small items don't hide a trend.
What does a reconciliation look like? (Illustrative example)
The numbers below are illustrative only, for a single-location dispensary at month-end.
| Item | Amount |
|---|---|
| Metrc active packages, costed at unit cost | $184,600 |
| Inventory per balance sheet (before adjustments) | $192,350 |
| Unexplained difference | $7,750 |
| Less: waste destroyed in Metrc, not written off in books | ($3,900) |
| Less: vendor bill booked, manifest not accepted until next month | ($2,800) |
| Less: no-charge trade samples booked into inventory at a cost value | ($650) |
| Remaining unexplained variance | $400 |
The entries: write off the $3,900 of waste, move the $2,800 bill to an in-transit or accrual account (or reverse it until the manifest is accepted, depending on your policy), and reverse the sample entry since nothing was paid. The remaining $400 is below this operator's threshold, so it's booked as shrink and noted in the file. Next month, if shrink repeats in the same category, it becomes a cash-controls question, not just an accounting one.
Who should own each step?
Reconciliations fail most often because everyone assumes someone else did it. Assign names, not departments.
| Task | Typical owner | Why |
|---|---|---|
| Metrc adjustments, waste logs, manifests | Inventory or compliance manager | They're licensed users and accountable to the regulator |
| Physical and cycle counts | Inventory team, with someone independent observing | Separates the counter from the record keeper |
| Unit costs and cost roll-forward | Accountant or controller | Drives COGS under IRC 471 |
| Reconciliation workbook and journal entries | Bookkeeper or accountant | Owns the ledger |
| Review and sign-off | Owner, CFO or controller | Someone who didn't prepare it |
Smaller operators often combine roles. That's fine, as long as the person who adjusts Metrc isn't also the only person who reviews the variance. If you'd rather hand off the accounting side entirely, that's part of our COGS and inventory accounting work.
How do you keep the reconciliation from becoming a cleanup project?
- Do it monthly, every month. A year of unreconciled activity is a forensic project. One month is a checklist.
- Keep the evidence. Save the Metrc export, the costed workbook, count sheets and the entry together for each month. That folder is your COGS support if you're ever examined.
- Fix the source, not just the ledger. If the same variance shows up twice, change the process: a receiving step, a POS setting, a waste-logging habit.
- Watch dual-license activity. If you hold both medical and adult-use licenses, reconcile inventory by license. With medical activity now outside 280E from April 28, 2026, and adult-use still subject to it, inventory and COGS need to land in the right bucket. Our Schedule III guide covers the split.
If your books and Metrc haven't been tied out in a while, a catch-up and cleanup engagement is usually the fastest way back to a clean monthly rhythm.
Frequently asked questions
How often should a cannabis business reconcile Metrc to QuickBooks?
Monthly, as part of the month-end close. Many operators also do a full physical count at least quarterly and cycle counts in between.
Does QuickBooks integrate directly with Metrc?
Not natively in a way that replaces reconciliation. Some POS and inventory platforms pass data between systems, but you still need to tie quantities and dollars out and investigate differences.
What if Metrc is wrong, not the books?
Correct Metrc through proper adjustments with the right reason codes and documentation under your state's rules. Never force the books to match a state record you know is wrong.
Why does the Metrc reconciliation matter for 280E?
Under 280E, COGS is often the main item reducing taxable income for adult-use operators. COGS depends on ending inventory, so an unreconciled inventory balance leaves COGS unsupported.