Metrc Reconciliation for Michigan Cannabis Businesses

Metrc reconciliation compares the operational inventory activity recorded in a seed-to-sale system against every other record that describes the same inventory: physical counts on the shelf or in the vault, point-of-sale or production system data, purchasing and receiving documentation, incoming and outgoing transfers, the inventory balance carried in the general ledger, cost of goods sold, and ultimately the financial statements those balances produce.

For most Michigan operators the problem is not that one system is wrong and another is right. It is that nobody has defined how the systems are supposed to relate. Once that relationship is documented — which products map to which items, how units convert, how transfers are treated, when the period closes — differences stop being mysterious and start being explainable. That is the deliverable.

This page covers the commercial reconciliation engagement. Background reading on how seed-to-sale tracking works in practice is kept separate in the Metrc Guide. General transaction coding and monthly close are covered under cannabis bookkeeping.

Metrc reconciliation is the process of comparing seed-to-sale inventory records with physical, operational and accounting records to identify and resolve discrepancies. It is a defined comparison performed for a defined period, ending in a documented explanation of every material difference.

Depending on the operator and the systems in use, the comparison points typically include:

• Packages and package identifiers
• Units, weights and saleable quantities
• Receipts and incoming transfers
• Outgoing and inter-location transfers
• Sales and inventory decrements
• Operational adjustments
• Documented waste and loss
• Production inputs and outputs
• On-hand inventory quantities
• Inventory value in the accounting records
• General ledger inventory balances
• Cost of goods sold for the period

A reconciliation is complete when each of those points either agrees or has a documented reason for not agreeing. Anything else is a comparison, not a reconciliation.

The single most expensive misunderstanding in cannabis inventory accounting is the assumption that a seed-to-sale system is a substitute for accounting records. It is not, and it was never designed to be. Seed-to-sale platforms exist to track regulated material as it moves. Accounting exists to state what the business owns, what it owes and what it earned.

Metrc quantity and general-ledger inventory value are different measures and should not be expected to match numerically without a defined reconciliation method. Once cost data and a documented method are applied, operational quantities become a reliable input to inventory accounting — which is a very different statement from saying the seed-to-sale system produces the accounting answer.

Operational inventory answers the question "what is here and where did it go?" Accounting inventory answers "what is it worth and how does it affect the financial statements?" Both are correct within their own frame, and both are necessary.

The systems must connect, but they do not contain identical data and should not be expected to. The reconciliation is the bridge: it maps products, converts units, applies cost and explains what remains.

A physical count is what keeps a reconciliation honest. Two system records can agree with each other and still both be wrong. Counting provides a third, independent point of validation against the material actually on hand.

When the count and the expected quantity differ, the difference is classified before anything is adjusted. Frequent causes include:

• Count errors, missed locations or double-counted packages
• Timing between the count date and the system cutoff
• Waste or loss recorded in one place and not another
• Movement that occurred but was never recorded
• Package splits, merges or repackaging not reflected consistently
• Unit conversion between bulk weight and finished units
• Adjustments entered incorrectly or against the wrong package
• Transfers shipped but not yet received, or received but not posted
• Receiving errors in quantity, product or location

Counts work best when the procedure is repeatable: a defined cutoff, a defined count sheet built from system data, a second-person verification of exceptions and a written record of what was found. Ad hoc counting produces numbers that cannot be defended a month later.

This is the center of the engagement. Operational data, purchasing records, physical counts and point-of-sale or production output all describe the same inventory from different angles. Reconciliation assembles them into a single position that accounting can rely on.

The work proceeds in a deliberate order. Product and unit mapping is standardized first, because comparing large data sets before mapping simply generates noise. Quantities are reconciled next, by product or category rather than line by line, so that exceptions surface where they matter. Cost is applied only after quantities are understood. Value is compared last, against the general ledger.

The goal is not to make two numbers artificially match. Forcing a match by posting a balancing entry destroys the information the reconciliation was supposed to produce: it hides whether the difference came from theft, breakage, mis-receiving, a mapping error or nothing more than timing. The goal is to understand why the records differ, correct what should be corrected, and document the rest.

• Standardize product, package and category mapping first
• Reconcile quantity before applying cost
• Use a consistent, documented period cutoff
• Investigate material variances rather than netting them
• Separate timing differences from real differences
• Support each correcting entry with evidence
• Retain the workpaper, not just the final number
• Repeat the same method every period so results are comparable

Operational data does not reconcile directly to the general ledger. It reconciles to an inventory subledger, and the subledger reconciles to the ledger. Skipping the middle step is why so many operators cannot explain their inventory balance.

When the valued subledger and the ledger disagree, the cause is almost always in the accounting records rather than in the operations. Typical findings include:

• Purchases expensed instead of capitalized to inventory
• Missing purchase or receiving entries for the period
• Inventory purchases coded to the wrong account
• Duplicate bills or duplicate inventory entries
• Manual journal entries against inventory with no support
• Activity posted to the wrong entity
• Activity posted to the wrong location or class
• Incorrect unit cost or cost applied to the wrong product
• Stale balances rolled forward without review
• Cost of goods sold recorded without a corresponding inventory relief

Receiving is where most inventory problems are created, because it is the point at which an operational event and an accounting event are supposed to happen together and frequently do not.

Reconciling receiving means confirming every link in that chain for the period, and listing the exceptions. Exceptions worth investigating include:

Received operationally, missing in accounting

Inventory is physically on hand but never entered as a purchase, understating both inventory and payables. Compare receipts to bills posted for the period.

Invoice booked, no inventory receipt

Accounting shows a purchase with no corresponding operational receipt. Check whether the goods arrived in a later period, were received under a different product, or were never received at all.

Quantity mismatch

The receipt quantity differs from the invoice quantity. Confirm partial shipments, short shipments, credits and whether the count at receiving was verified.

Unit mismatch

One record is stated in grams and the other in units or cases. Confirm the conversion factor and whether it was applied at receiving.

Cost mismatch

The cost recorded in inventory differs from the vendor invoice. Review discounts, credits, freight treatment and whether cost was updated after a price change.

Wrong entity or location

Inventory received at one site is recorded against another, distorting both location results. Verify the receiving location against the transfer record.

Duplicate receipt

The same delivery is recorded twice, often once at delivery and once when the invoice arrives. Compare by vendor, date, product and quantity.

Timing difference at cutoff

Goods received near period end with an invoice dated in the following period, or the reverse. Confirm the cutoff convention and apply it consistently.

Transfers move inventory between locations and, in some structures, between legal entities. Operationally they are one event. In accounting they may be no event at all, a reclassification, or a purchase and sale between entities — and the difference matters.

Reconciliation covers each transfer type separately:

• Incoming transfers matched to receiving and vendor documentation
• Outgoing transfers matched to the destination's receipt confirmation
• Inter-location transfers within one entity, reclassified by location
• Intercompany transfers where separate entities are involved
• Transfers in transit at period end, with a documented cutoff
• Rejected or partially rejected transfers and their return treatment

Whether a transfer is within a single entity, between locations under one ledger, or between separate legal entities determines the accounting treatment, including whether intercompany balances are created. We identify how transfers are actually occurring and reconcile them consistently; entity structuring and tax conclusions belong with your attorney and tax advisor.

For retailers, every sale is simultaneously a revenue event, an inventory decrement and an operational record. Reconciliation confirms that all three tell the same story.

Differences between point-of-sale inventory movement and operational records commonly trace to timing at day or period boundaries, product and package mapping, discount and promotional handling, returns, voided or reopened transactions, unit conversions between bulk and packaged product, and manual adjustments made in one system only.

Cash handling, tender reconciliation, deposit tracing and store-level retail reporting are covered under dispensary accounting. This page owns the inventory side of the same transaction.

Purchase reconciliation follows the money rather than the material, and it should arrive at the same place.

For each purchase in the period the reconciliation confirms quantity, unit of measure, unit cost and extended cost, the vendor, the receiving location, the owning entity and the invoice date relative to the period cutoff. Where an operator buys the same product from multiple vendors at different prices, the costing approach has to be documented so that inventory value and cost of goods sold remain consistent from month to month.

Adjustments are the most under-examined data in cannabis inventory. Each one changes quantity, and quantity changes eventually change value. Reviewing them is not an accusation of wrongdoing — it is basic control.

Legitimate operational adjustment reasons include documented waste, damaged or expired product, sample activity where applicable, count corrections, conversions between bulk and packaged forms, production loss, packaging and repackaging changes, and corrections of prior data-entry errors.

• Review adjustments by reason code for the period
• Confirm each material adjustment has supporting documentation
• Map adjustment reasons to an accounting treatment consistently
• Identify adjustments that were never reflected in accounting
• Watch for repeated adjustments against the same product or package
• Flag adjustments made after the period cutoff
• Understand the financial effect before the period is closed
• Track adjustment volume over time as a process indicator

An adjustment pattern that repeats every month is usually telling you something about process — receiving, counting, mapping or conversion — rather than about the product.

Documented waste and loss reduce the quantity a business expects to hold. Depending on the facts, the accounting method in use and applicable rules, the same activity may affect inventory value, the presentation of cost of goods sold or expense, gross margin and management reporting.

We do not apply blanket classifications to waste and loss. The correct treatment depends on the operator, the stage at which the loss occurred, the costing method and the applicable accounting and tax rules, which should be evaluated with your tax advisor. What reconciliation contributes is a defensible record: what was lost, when, at what stage, in what quantity and with what documentation behind it.

Most reconciliation failures are mapping failures wearing a disguise. Before any two data sets can be compared meaningfully, the products in each have to be matched to each other.

Common mapping problems:

Inconsistent SKU naming

The same product is named differently in each system, so automated matching fails and manual matching drifts. Establish one naming convention and a crosswalk table.

Duplicate product records

One physical product exists as several items, splitting quantity and cost across records. Merge or map duplicates before comparing periods.

Unit mismatch between systems

One record is weight-based and another is unit-based for the same product. Document the conversion and store it with the mapping.

Package changes over time

Repackaging, splits and merges break the link between historical and current records. Retain package lineage so prior periods remain traceable.

Product and category mismatch

Items are grouped differently in operations and accounting, so category-level margin analysis is meaningless. Align category definitions once and hold them.

Naming drift after menu changes

New POS items are created without updating the accounting mapping, so new products fall outside the reconciliation. Add mapping to the new-product process.

Product and unit-of-measure mapping should be standardized before large data sets are compared. Standardized mapping is the single highest-leverage improvement most operators can make to reduce reconciliation noise.

Cannabis inventory is measured in grams, ounces, pounds, each-units, packages, cases and finished saleable goods, often simultaneously. A cultivator may track bulk weight while a retailer tracks eighths; a processor may track input weight and output units for the same material.

The recurring issue is straightforward: one system tracks weight while another tracks saleable units. If the conversion factor is undocumented, applied inconsistently, or never updated when packaging changes, the resulting difference looks exactly like shrinkage and gets investigated as if it were.

• Document the conversion factor for every product family
• Store conversions alongside the product mapping table
• Review conversions whenever packaging configurations change
• Apply conversions in one place rather than in each spreadsheet
• Reconcile in the unit the source system actually uses, then convert
• Keep rounding conventions consistent across periods

We document and apply the conversion logic your operation uses. We do not invent regulatory conversion rules; where a required convention exists, it should be confirmed against current guidance.

Negative inventory is a diagnostic signal. It says the records claim more product left than ever arrived, which is a data condition rather than a physical one. Treating it as a shortage and adjusting it away destroys the evidence.

Timing

Sales or usage posted before the corresponding receipt. Check whether the receipt lands in the following period.

Missing receiving

Product arrived and was sold but never entered. Compare vendor documents to receipts for the period.

Duplicate sale entries

Integration retries or manual re-entry double-decrement the same item. Compare transaction identifiers.

Unit mismatch

A quantity entered in grams is decremented as units. Verify the conversion applied at the point of decrement.

Package mapping error

Sales are decrementing a different item than the one that was received. Review the crosswalk for that product.

Transfer timing

Outgoing transfer recorded before the corresponding inbound receipt at the destination. Confirm both sides.

Manual adjustment

An adjustment reduced quantity that had already been relieved. Review adjustments against the same package.

Integration failure

A sync between POS, ERP and the seed-to-sale system dropped or duplicated records. Check the integration logs for the period.

Variance analysis is what turns a list of differences into information. It starts with a simple calculation and ends with a classification.

Every variance is then assigned a probable source:

• Timing — the activity is real but landed in a different period
• Physical variance — product genuinely is not there
• Data entry — quantity, product or date entered incorrectly
• System mapping — the records describe different items
• Costing — quantities agree but value does not
• Transfer — one side of a movement is unrecorded
• Receiving — the inbound event was never captured correctly
• Sale — decrement logic or return handling is wrong
• Adjustment — an operational change never reached accounting

Repeated unexplained variance is a process problem, not just an accounting problem. If the same category produces a variance every month, the fix is upstream — in receiving, counting, mapping or conversion — and no amount of month-end correction will resolve it.

Retail is the highest-volume reconciliation environment: many small transactions, many SKUs, frequent menu changes and constant receiving. Small mapping errors compound quickly.

A retail engagement typically covers:

• Point-of-sale sales, returns, voids and discounts by period
• Operational inventory movement for the same period
• Purchases and vendor invoices by store
• Receiving records and exception review
• Incoming and inter-store transfers
• Cycle counts and full physical counts
• Accounting inventory value by store and category
• Cost of goods sold and resulting gross margin

Cash, tender and store operations accounting sits with dispensary accounting, and retail background reading is collected in the Dispensary Accounting Guide. Retail-specific service context is on the dispensaries page.

Cultivation reconciliation follows material through production stages rather than across a sales counter. Quantity changes form and unit repeatedly before it becomes finished inventory.

• Plant and material movement through stages where applicable
• Harvest quantities and wet-to-dry conversion records
• Movement between rooms, stages and locations
• Outgoing transfers to processors or retailers
• Documented waste and loss at each stage
• Conversion from bulk weight to packaged units
• Finished goods entering accounting inventory
• Production cost accumulation and allocation

We reconcile the records your operation actually produces rather than assuming a standard workflow. Cost accumulation and production accounting are covered under cultivation accounting, with sector context on the cultivators page.

Processing converts inputs into different products, which makes reconciliation a question of transformation rather than movement alone.

Reconciliation covers input quantities drawn from inventory, work-in-process concepts where the operation and accounting method support them, output quantities by product, packaging and finished-goods creation, documented waste and loss, unit conversion between input and output measures, and the valuation of finished inventory.

The appropriate costing methodology depends on the operation and the applicable accounting rules; we work within the method the business uses rather than imposing one. Related service detail is under manufacturing accounting, with sector context on the manufacturers and processors pages.

Yield reconciliation compares what a production run should have produced with what it actually produced, using the operation's own documented loss expectations rather than external benchmarks.

A large unexplained difference is worth investigating before it is accepted as a production characteristic. Likely causes include data-entry errors on input or output quantities, unit conversion between input weight and output units, unrecorded production loss, waste captured operationally but not accounted for, product mapping errors on the output side, and genuine process variance between runs.

We do not publish yield benchmarks or represent what a run "should" return. The comparison is to your own documented expectations, tracked over time so that deviations become visible.

Multi-location operators face a compounding problem: each site has its own inventory, its own counts and its own receiving, but consolidated reporting requires the same product to mean the same thing everywhere.

• Separate inventory records maintained per location
• Inter-location transfers matched on both sides
• One product and unit mapping applied across all sites
• Location-specific general ledger coding or class tracking
• Physical counts performed on a consistent schedule per site
• Variance reviewed by location, not only in total
• Consolidated inventory reporting that still ties to each site

Reviewing variance only at the consolidated level hides offsetting errors. Two sites with opposite mistakes can produce a total that looks correct.

Where an operation spans multiple legal entities, operational ownership and accounting ownership can diverge. Material may move freely between facilities while the ledgers treat the same movement as a transaction between separate businesses.

• Inventory tracked and reconciled per entity
• Intercompany transfers identified and matched on both sides
• Purchasing entity identified for each vendor invoice
• Due-to and due-from balances reconciled between ledgers
• Separate ledgers maintained rather than blended records
• Operational ownership reconciled to accounting ownership
• Consolidation performed with intercompany activity eliminated appropriately

We reconcile the structure as it exists and report where records conflict with it. Entity structuring, ownership and legal questions belong with your attorney, and the related tax analysis with your tax advisor.

Reconciliation is not a replacement for bookkeeping; it is an input to it. The reconciled inventory position becomes an accounting entry, that entry lands in the ledger, and the ledger closes.

Transaction coding, bank reconciliation, the monthly close calendar and general financial hygiene are covered under cannabis bookkeeping, with background in the Cannabis Bookkeeping Guide. This page owns the inventory reconciliation that feeds it.

Where Section 280E applies, the quality of inventory and cost records can matter a great deal to how positions are supported. Reliable quantity and movement data makes the underlying analysis possible. It does not perform the analysis.

Seed-to-sale data does not determine tax basis, cost of goods sold, deductibility, capitalization or any other tax treatment. Those conclusions depend on the accounting records, the applicable rules and the facts of the business.

Tax-specific cost treatment and workpaper support are handled under 280E tax compliance, with background reading in 280E Explained. Return preparation is a separate engagement under cannabis tax preparation.

Inventory discrepancies do not stay in inventory. Because inventory and cost of goods sold are two ends of the same relationship, an unresolved operational error becomes a financial reporting error.

The practical consequences are a balance sheet that overstates or understates a major asset, cost of goods sold that swings without operational explanation, gross margin that cannot be compared period to period, location reporting that misattributes results, and working-capital figures that mislead lenders and management alike. Statement preparation and reporting packages are covered under financial reporting.

Strategic finance depends entirely on whether inventory can be trusted. Unreliable inventory limits margin analysis by product and category, cash forecasting where inventory is the largest use of cash, purchasing decisions, inventory-turn analysis and working-capital management.

Forecasting, budgeting, scenario planning and management reporting are covered under fractional CFO services. Reconciliation is the prerequisite, not the substitute.

Cleanup engagements start where the records have already drifted, sometimes over several years. The work is methodical rather than dramatic: establish what is knowable, correct what should be corrected and document the rest.

Conditions that typically prompt a cleanup:

Packages do not map correctly

Operational, POS and accounting items cannot be matched, so no comparison is meaningful until a crosswalk exists.

Physical inventory differs from system inventory

Counts and system records diverge with no documented cause, and prior differences were adjusted away without investigation.

POS and Metrc do not tie

Sales activity is decrementing different products or quantities in each system, usually a mapping or conversion issue.

Purchases are missing

Inventory exists on hand with no corresponding purchase entry, understating both inventory and payables.

Transfers are unmatched

Outbound and inbound records do not pair, leaving quantity stranded between locations or entities.

Negative inventory exists

Quantities below zero indicate missing receipts, duplicate decrements or conversion errors that need tracing.

General ledger inventory is stale

The balance has not changed in a way that reflects activity, suggesting purchases expensed directly or no periodic valuation.

COGS is erratic

Cost of goods sold swings without operational cause, usually a timing, costing or inventory-relief problem.

Unit conversion is inconsistent

Different conversion factors were applied in different periods or spreadsheets, producing artificial variance.

Old adjustments are unexplained

Large historical adjustments have no supporting reason or documentation and distort trend analysis.

Locations and entities are mixed

Inventory belonging to different sites or entities sits in one record, making per-site results unusable.

Some historical differences cannot be resolved with the records that exist. When that is the case we say so, document the limitation and establish a clean starting position going forward rather than manufacturing a false history.

A recurring monthly reconciliation keeps differences small enough to explain. This is a representative workflow; the specifics depend on operator type and systems in use.

1. 01Confirm the reporting period and cutoff convention.
2. 02Export seed-to-sale data for the period.
3. 03Export POS or production system data for the same period.
4. 04Review receiving activity and exceptions.
5. 05Review incoming, outgoing and inter-location transfers.
6. 06Review sales or production output.
7. 07Review inventory adjustments by reason.
8. 08Review documented waste and loss.
9. 09Review physical count results.
10. 10Review purchases and vendor invoices.
11. 11Compare operational quantities across systems.
12. 12Compare valued accounting inventory to the subledger.
13. 13Reconcile the general ledger inventory balance.
14. 14Investigate material variances and classify causes.
15. 15Document corrections and supporting evidence.
16. 16Close the inventory period and file the workpaper.

These are the statements we hear most often, and what each one usually warrants investigating first.

Metrc and POS inventory do not match.

Start with product mapping and unit conversion, then check period cutoff and manual adjustments made in one system only.

Physical inventory does not match Metrc.

Verify the count procedure and cutoff, then review unrecorded movement, waste, package changes and receiving before assuming shrinkage.

Our inventory GL has not changed correctly.

Check whether purchases are being expensed rather than capitalized, and whether a periodic valuation entry is being made at all.

Receiving is in Metrc but not in accounting.

Compare receipts to bills for the period; the usual cause is a delivery received operationally with the invoice never entered.

Purchases are in accounting but not inventory.

Confirm whether goods arrived in a later period, were received under a different product, or were never received.

Transfers are unmatched.

Pair each outbound record with its inbound counterpart and review items in transit at the cutoff date.

Negative inventory keeps appearing.

Trace to missing receiving, duplicate decrements, unit mismatch or integration errors rather than adjusting the balance to zero.

COGS changes dramatically month to month.

Review costing consistency, inventory relief timing and whether adjustments and waste are being recorded in bursts.

Product names do not map across systems.

Build a crosswalk table and add mapping to the new-product setup process so drift stops recurring.

Weight-based and unit-based systems do not reconcile.

Document conversion factors per product family and apply them in one place rather than per spreadsheet.

We have unexplained inventory adjustments every month.

Analyze adjustments by reason and product; recurring adjustments usually indicate an upstream receiving, counting or mapping issue.

Nobody can explain the inventory balance.

Rebuild from a valued subledger; a ledger balance with no supporting subledger cannot be reconciled, only recalculated.

Engagements differ by operator type, systems and the condition of the existing records. The following is how a typical engagement is scoped and sequenced, not a fixed script.

1. 01Understand the operator type and license activities.
2. 02Review the seed-to-sale account structure and data availability.
3. 03Review POS, ERP and production systems in use.
4. 04Review product and SKU mapping across systems.
5. 05Review unit-of-measure and conversion logic.
6. 06Review the physical count process and history.
7. 07Review purchasing and vendor documentation.
8. 08Review incoming, outgoing and intercompany transfers.
9. 09Review sales or production output records.
10. 10Review inventory adjustments, waste and loss.
11. 11Review accounting inventory and the subledger.
12. 12Review general ledger inventory and COGS activity.
13. 13Identify historic discrepancies and quantify materiality.
14. 14Establish a documented reconciliation methodology.
15. 15Establish recurring reporting and a monthly cadence.

Ready to scope one? Call (947) 218-1871 or schedule a consultation.

We work with licensed cannabis operators throughout Michigan, including management teams in Detroit, Grand Rapids, Ann Arbor, Lansing, Flint, Kalamazoo, Sterling Heights, Warren, Troy and Dearborn, as well as cultivation and processing facilities in smaller markets across the state. Engagements are delivered remotely using system exports and secure document exchange; we do not maintain branch offices in these cities.

Reconciled seed-to-sale and accounting records can support financial, tax and regulatory reporting. We are not affiliated with, endorsed by or certified by Metrc or any Michigan regulatory agency, and we do not represent that any reconciliation satisfies a specific regulatory requirement — reporting obligations should be confirmed against current guidance for your license types.

Broader Michigan accounting context is collected in the Michigan Cannabis Accounting Guide, and educational background on seed-to-sale tracking is in the Metrc Guide. Multi-state operators can find structural context on the multi-state operators and distributors pages.