Metrc Reconciliation for Ohio Cannabis Businesses

Metrc Reconciliation for Ohio Cannabis Businesses

Metrc reconciliation compares operational seed-to-sale records with the other records a cannabis business maintains, so differences can be identified, explained and — where appropriate — corrected before they reach the financial statements.

Cannabis operators run several systems that all describe the same product from different angles. The seed-to-sale system records regulated movement. The point-of-sale system records transactions. Purchasing and receiving record what arrived. Physical counts record what is actually on the shelf. The accounting system records what all of it is worth. Each is built for a different purpose, and each will occasionally disagree with the others.

• Metrc and other operational tracking records
• Physical inventory counts
• Point-of-sale sales and product movement
• Purchasing and vendor invoices
• Receiving records
• Transfers between locations and facilities
• Inventory adjustments and waste records
• Accounting inventory and the general ledger

These systems will not always contain identical numbers, and they are not always supposed to. Timing, unit conventions, product mapping and legitimate operational adjustments all create differences that are explainable. The work is telling the explainable differences apart from the ones that indicate an actual problem — and doing it while the records are still recent enough to investigate.

Read the educational Metrc Guide

What Is Metrc Reconciliation?

Reconciliation is the process of determining whether related records can be connected to one another, and explaining the legitimate differences that remain.

The objective is not simply to make every system equal. Forcing one number to match another destroys the information the difference contained. The objective is a documented chain of reasoning that connects the records:

A reconciliation difference is not automatically an error. Timing, mapping and supported operational adjustments can create legitimate differences that should be identified and documented. What matters is that every difference has a name and an explanation by the time the period closes.

Metrc vs Accounting Inventory

These two systems answer different questions, and confusing them is the most common cause of inventory reporting problems we see in cannabis businesses.

Metrc inventory and accounting inventory serve different purposes. Operational quantity records do not by themselves establish the financial value reported on the balance sheet. A tracking system can be perfectly current on units and still tell you nothing about landed cost, freight, production cost absorption, write-downs or the costing method applied.

Quantity is not the same thing as financial value. A quantity-based operational system does not replace inventory accounting, and treating a tracking export as an inventory valuation is one of the fastest routes to a balance sheet that cannot be supported.

Financial Reporting Services

Metrc vs POS

The point-of-sale system and the operational tracking system both record retail product movement, but they capture it at different moments and in different formats.

• Timing differences around period cutoffs
• Voids and corrected transactions
• Returns where the business accepts them
• Discounts and promotional pricing effects on reporting
• Unit of measure conventions that differ between systems
• Product and SKU mapping that does not align cleanly
• Manual adjustments made in one system only
• Data-entry errors at the register or in receiving
• System synchronization and integration issues

A difference between the POS and the operational record is a data question first. It becomes a compliance question only if investigation shows it is one, and that determination belongs to the operator and its regulatory advisors — not to a spreadsheet variance. Our role is to identify the differences, classify them and make sure the accounting records reflect a defensible conclusion.

POS-to-Metrc Reconciliation

A workable POS-to-operational reconciliation follows a repeatable sequence. Configurations vary between businesses, so not every operation will follow exactly these steps.

1. 01Establish the reporting period and cutoff.
2. 02Export POS sales and product movement for the period.
3. 03Export the relevant operational tracking records.
4. 04Standardize product identifiers and units of measure.
5. 05Compare quantities by product and category.
6. 06Identify exceptions above a working threshold.
7. 07Investigate timing and mapping differences first.
8. 08Investigate adjustments that lack supporting documentation.
9. 09Document the explanation for each remaining difference.
10. 10Correct source and accounting records where appropriate.

Standardization usually takes longer than the comparison itself. Two systems rarely name products the same way, and unit conventions — grams versus each, package versus unit — create apparent variances that dissolve once the mapping is fixed. Building that mapping once and maintaining it turns a monthly research project into a routine review.

Physical Inventory vs Metrc

A system quantity is what the records say should be there. A physical count is what is actually there. Comparing them is the only way to test whether the operational records reflect reality.

• Receiving recorded in a different period than the physical arrival
• Transfers in transit at the count date
• Sales recorded just before or after the count
• Waste and disposal activity
• Adjustments recorded in one system only
• Unit conversions between packaging levels
• Damaged or unsellable product
• Data-entry mistakes during receiving or counting
• Movement that occurred but was never recorded
• Product mapping differences between systems

Physical inventory answers how much product exists. Accounting inventory answers what that inventory is worth. A variance between a count and a system quantity should be investigated on its facts; it is not evidence of theft, and it is not a regulatory conclusion. Recurring variances in the same product category usually point to a process or mapping issue rather than anything else.

Cannabis Inventory Reconciliation

Beyond any single software platform, inventory reconciliation is an arithmetic relationship that should hold in every system that tracks product.

Once expected ending inventory is calculated, it becomes the reference point for four separate comparisons:

Inventory reconciliation becomes more useful when discrepancies are classified by type rather than simply forcing one system to equal another. The point of running the comparison four ways is to isolate where in the process the difference entered — receiving, movement, counting or valuation.

Inventory Quantity vs Inventory Value

Operational systems establish what and how much product moved. Accounting establishes the financial value associated with that inventory, which requires information the tracking system does not hold.

That relationship looks simple and rarely is. Supported unit cost depends on what the business actually paid or incurred, which costs are properly included in inventory under the method applied, how production costs are absorbed for cultivators and manufacturers, and how the costing method treats units acquired at different costs over time.

• Purchase cost from vendor invoices
• Freight and inbound costs where included under the method applied
• Production and conversion costs for manufactured product
• Allocation methodology applied consistently
• Costing convention applied across periods
• Adjustments for damage, waste or unsellable product
• Documentation supporting the cost assigned
• Consistency between periods so results stay comparable

None of that lives in a quantity-tracking system. Valuation requires accounting information and accounting judgment, applied consistently and documented well enough that someone else can follow it later.

Purchasing & Receiving Reconciliation

Purchasing is where quantity and cost enter the business at the same moment, which makes it the highest-leverage place to catch inventory error early.

• Received quantity differs from the invoiced quantity
• An invoice exists but no receiving record does
• A receiving record exists but no invoice has arrived
• Product mapped to the wrong item in one system
• Unit cost entered incorrectly or in the wrong unit
• Duplicate invoice recorded against a single receipt
• Timing difference between receipt and invoice periods
• An internal transfer recorded as an outside purchase

Each of these flows downstream. An incorrect unit cost produces an incorrect inventory value and an incorrect cost of goods sold when the product sells. A missing receipt understates inventory and overstates margin until it is found. A transfer recorded as a purchase inflates both purchases and inventory across the company. Reconciling receiving to invoices monthly keeps those errors from compounding.

Cannabis Bookkeeping Services

Transfer Reconciliation

Transfers move product between locations, facilities, departments and, in some structures, entities. They create a window where product belongs to neither the origin nor the destination.

Both the quantity and the accounting treatment need review. Quantities transferred out should tie to quantities received in, with in-transit product accounted for at period ends. On the accounting side, movement within a single legal entity is not revenue and not a purchase; movement between separate entities is a different question that depends on the structure and the arrangements between them.

• Transfer out recorded with no corresponding transfer in
• Transfer in recorded with no corresponding transfer out
• Quantity received differs from quantity sent
• Product in transit across a period cutoff
• Internal movement recorded as a sale or a purchase
• Inter-entity movement recorded without a documented basis
• Cost not carried consistently across the transfer
• Location inventory balances that never return to reconciled

Whether a particular transfer is permitted, and what operational documentation applies, are regulatory questions for the operator and its counsel. Our scope is whether the transfer reconciles and whether the accounting treatment is supportable.

Inventory Adjustment Reconciliation

Adjustments are how systems absorb the difference between what was recorded and what is true. That makes them the single most informative category in a reconciliation.

• Count corrections following a physical inventory
• Waste and disposal activity
• Damaged or unsellable product
• Returns where the business accepts them
• Unit and packaging conversions
• Data corrections reversing an earlier entry
• Other operationally supported adjustments
• Adjustments with no attached documentation

Not all adjustments have the same accounting treatment. A count correction, a waste record and a unit conversion affect the financial records differently, and applying one blanket treatment to all of them produces inventory and cost of goods sold that cannot be explained. Large or recurring adjustments deserve investigation on their own — a category that is adjusted every month is usually describing a process problem, not a series of unrelated events.

Dispensary Reconciliation

Retail reconciliation runs on two chains that start in different places and end in the same accounting records.

The operational chain proves that product moved as recorded. The financial chain proves that the money arrived as expected. Both terminate in the general ledger, and a dispensary is only reconciled when both do. A store can have a perfectly balanced drawer and still be carrying an unexplained inventory variance, or count inventory exactly and still be short on deposits.

This page covers the operational and inventory reconciliation layer. Full retail financial accounting — the chart of accounts, revenue recording, cash accounting, payment activity, close and reporting for a dispensary — is covered in depth on our dispensary accounting page, which remains the primary resource for that work.

Dispensary Accounting Services

Dispensary Shift Reconciliation

Where a retailer operates in shifts, closing each one out is the shortest feedback loop available for catching problems while they are still investigable.

• POS activity for the operating period
• Sales totals by payment type
• Cash collected during the shift
• Other payment activity the store accepts
• Returns and adjustments where applicable
• Product movement recorded during the period
• Physical cash count at close
• Drawer close documentation
• Deposit preparation for the period

Not every dispensary uses a shift-based reconciliation process, and the structure depends on staffing, hours and how the store is organized. Where one exists, the value is speed: a variance identified at close can be traced to specific transactions and specific staff while everyone still remembers the day. The same variance discovered six weeks later at month end usually cannot be explained at all.

Dispensary Cash Reconciliation

Cash reconciliation and inventory reconciliation answer different questions, but they frequently reveal the same underlying operational problem.

Inventory reconciliation asks whether product moved as recorded. Cash reconciliation asks whether the money arrived as expected. When a store shows a consistent inventory variance in the same category and a consistent cash variance on the same shifts, those two facts are worth reading together — not because either proves anything alone, but because the intersection narrows the investigation considerably.

Deep cash accounting for dispensaries — recording cash activity, deposit timing, bank reconciliation, undeposited funds and the controls around them — is covered on our dispensary accounting page. This page addresses cash only where it intersects with operational and inventory reconciliation.

Dispensary cash and retail accounting

Dispensary Cash Workflow

At a conceptual level, the cash workflow for an operating period is a closed arithmetic loop. Where it does not close, the gap is the variance.

The accounting objective is that every step is documented and traceable: the count supports the deposit, the deposit supports the bank activity, and the bank activity supports the ledger. Cash-handling procedures, security arrangements and any related operational requirements are business and regulatory matters outside our scope; what we address is whether the resulting records reconcile.

Metrc Reconciliation & Cannabis Bookkeeping

Reconciliation is not a parallel exercise to bookkeeping. It is the step that makes the accounting entries defensible.

Unresolved operational differences do not stay operational. They flow into inventory, then into cost of goods sold, then into gross margin, then into the balance sheet, and finally into financial statements that management and outside parties rely on. Each month a difference goes uninvestigated, the population of possible explanations grows and the chance of resolving it falls.

Monthly cannabis bookkeeping and close

Metrc Reconciliation & COGS

Cost of goods sold is derived from inventory, which means the reliability of one determines the reliability of the other.

If inventory quantities or values are unreliable, cost of goods sold becomes unreliable as well. The symptom operators usually notice first is gross margin that moves between periods without any operational explanation — a strong month followed by a weak one, with no change in pricing, mix or purchasing to account for it. That pattern often traces back to inventory that was never reconciled.

Reliable inventory supports reliable COGS and gross-margin reporting. Operational tracking records contribute quantity information to that process; they do not determine cost of goods sold for tax purposes, and operational categories do not automatically determine accounting or tax treatment.

Metrc Reconciliation & Section 280E

Where Section 280E applies, the quality of inventory and cost records can matter more than it would in an ordinary business.

Amounts properly included in inventory and recovered through cost of goods sold are treated differently from other expenses under Section 280E, so inventory documentation frequently becomes part of the tax workpaper support. Reconciliation contributes to that documentation by establishing that the inventory figures can be traced to underlying activity.

What is properly included, and how the analysis is performed, depends on the facts of the business, the inventory method applied and applicable federal tax treatment. Those questions are addressed on our 280E tax compliance page rather than here.

280E Tax Compliance Services

Metrc Reconciliation for Cultivators

Cultivation reconciliation follows product through growth, harvest and processing, where quantities change form rather than simply moving.

• Plant and product movement through operational stages
• Harvest quantities recorded against expectations
• Production and conversion quantities
• Waste and disposal activity
• Transfers to processing or other facilities
• Finished inventory available for sale or transfer
• Physical counts at each stage where practical
• Accounting inventory carried for each category

The reconciliation complication in cultivation is that a unit at one stage is not the same unit at the next. Wet weight is not dry weight, and dry weight is not finished packaged product. A reconciliation that ignores those conversions will generate variances that are entirely artificial, while a reconciliation that documents expected conversion ranges can flag the ones that are not.

Cultivation Accounting Services

Metrc Reconciliation for Manufacturers & Processors

Production reconciliation compares what went into a batch with what came out of it, then compares the output to the inventory records.

• Input quantities consumed by batch
• Batch and production run records
• Yield relative to expected ranges
• Waste and loss during production
• Packaging and unit conversion
• Finished product quantities by SKU
• Transfers to distribution or retail
• Accounting inventory for inputs, work in process and finished goods

Once output is established, it is compared to accounting inventory. This is where production cost absorption matters: the value assigned to finished goods should reflect the inputs and conversion costs actually consumed, applied through a method used consistently across batches. Yield that consistently falls outside expected ranges is worth investigating as both an operational and a costing question.

Manufacturing Accounting Services

Multi-Location Metrc Reconciliation

Company-wide totals can reconcile while individual locations do not. Reconciliation that only runs in aggregate hides exactly the problems worth finding.

• Inventory tracked by location, not only in total
• Transfers out and in matched between sites
• Receiving reconciled at the location that received
• POS activity separated by store
• Physical counts performed and reviewed by location
• Location-specific variance patterns identified
• Accounting inventory maintained by location
• Location-level margin reviewed against the reconciliation

A shortage at one store and an overage at another can net to zero at the company level. The consolidated inventory balance looks correct, the reconciliation appears clean, and the underlying transfer or mapping problem continues indefinitely. Running the comparison at each location — with Metrc, physical inventory and accounting records aligned per site — is what surfaces it.

Multi-State and Multi-Location Operators

Common Metrc Reconciliation Problems

Most reconciliation work resolves into a familiar set of situations. Recognizing the pattern shortens the investigation considerably.

Why Reconciliation Differences Happen

Identifying the type of difference makes investigation dramatically more efficient than working through variances one transaction at a time.

Most reconciliation work that feels overwhelming is overwhelming because every difference is being treated identically. Sorting the population into these categories first typically eliminates the large majority mechanically and leaves a short list that genuinely requires judgment.

Metrc Reconciliation Cleanup

Where operational and accounting records have not been reconciled for some time, cleanup follows a defined sequence rather than an attempt to fix everything at once.

Historical reconciliation almost always requires prioritizing material differences. Working a two-year backlog at the same level of detail as a current month is rarely worth the cost, and in many cases the underlying source records no longer support that level of review.

We do not promise that every historical variance can be reconstructed. Where records are incomplete, the honest outcome is a documented explanation of what could be established, what could not, and what the accounting records now reflect — followed by a recurring process so the same gap does not reopen.

Monthly Metrc Reconciliation

A recurring monthly reconciliation tied to the close keeps differences small and recent. Cadence and scope vary by business; not every operation needs every step every month.

1. 01Establish the period cutoff across all systems.
2. 02Review receiving activity for the period.
3. 03Review transfers in and out, including in-transit items.
4. 04Review POS and product movement records.
5. 05Review inventory adjustments and supporting documentation.
6. 06Review physical counts where they were performed.
7. 07Compare operational tracking quantities.
8. 08Compare accounting inventory balances.
9. 09Investigate material variances by category.
10. 10Document legitimate differences and their explanations.
11. 11Correct accounting and source records where appropriate.
12. 12Review resulting inventory value and cost of goods sold.
13. 13Close the period with the reconciliation documented.

Financial reporting built on reconciled inventory

Reconciliation Exception Reporting

Rather than examining every transaction with equal attention, organize discrepancies into exception categories and work the categories that carry risk.

• Quantity mismatch between two systems above a threshold
• Receiving recorded with no matching invoice
• Invoice recorded with no matching receipt
• Transfer out with no corresponding transfer in
• Unmatched SKU or product identifier
• Adjustment above a defined size or without documentation
• Negative inventory in any system
• Unit cost outside the expected range for a product
• Gross margin movement without an operational explanation
• Unexplained cash variance at a location or shift

Exception reporting is what makes reconciliation sustainable at volume. A dispensary processing thousands of transactions a month cannot review them individually, but it can review the two dozen items that fall into defined exception categories — and that review catches materially more than a general scan of the whole population would.

Thresholds should be set deliberately and revisited. A threshold set too high hides real problems; set too low, it generates a queue nobody works, which produces the same outcome.

How Our Metrc Reconciliation Process Works

Engagements are scoped to the systems and issues a business actually has, so not every engagement follows exactly the same path.

1. 01Identify the operational systems in use.
2. 02Review Metrc and operational tracking reporting.
3. 03Review the point-of-sale system and its exports.
4. 04Review purchasing and receiving processes.
5. 05Review how inventory is maintained day to day.
6. 06Review the physical-count process and its documentation.
7. 07Review accounting inventory and how it is maintained.
8. 08Review the chart of accounts supporting inventory and COGS.
9. 09Establish common reporting periods across systems.
10. 10Identify discrepancies across the record set.
11. 11Classify differences by type.
12. 12Investigate material exceptions.
13. 13Correct accounting records where appropriate.
14. 14Document the reconciliation and its conclusions.
15. 15Establish a recurring process the team can maintain.

The deliverable is not a clean spreadsheet. It is a reconciliation that someone else can follow: what was compared, what differed, why, what was corrected and what remains open with a stated reason.

Fractional CFO support where reporting needs go further

Metrc Reconciliation Services Across Ohio

We support licensed Ohio cannabis operators with operational and inventory reconciliation statewide, including Columbus, Cleveland, Cincinnati, Toledo, Akron and Dayton, as well as cultivation and production facilities outside the major markets.

Engagements are handled remotely with secure document exchange and scheduled review calls, so the same reconciliation standard, exception thresholds and documentation apply regardless of where the business operates. Ohio-specific tax considerations are covered in our educational tax resource, which we maintain as requirements change.

Read the Ohio Cannabis Tax Guide