METRC and Seed-to-Sale Reconciliation for Oklahoma Cannabis Businesses

A licensed cannabis business runs on several record systems at once, and each of them is telling a version of the same story. Reconciliation is the accounting work of comparing those versions and resolving the differences. Depending on the operation, the records involved may include:

• METRC or the applicable seed-to-sale tracking data
• Accounting software and the general ledger
• Inventory records and subledgers
• Point-of-sale reports
• Purchasing records and open purchase orders
• Vendor invoices and accounts payable
• Production and batch records
• Inbound and outbound transfer records
• Physical inventory counts
• Cost of goods sold schedules

The objective is not to make two totals appear equal. Forcing agreement with a plug entry hides the underlying problem and guarantees it returns next period. The objective is to understand why a discrepancy exists, whether it represents a data error, a process gap, a timing difference or a real inventory loss, and then determine how it should be recorded in the financial records with documentation behind it.

Seed-to-sale reconciliation compares operational and compliance inventory data with the business and financial records to identify inconsistencies. It looks at quantities on hand, movements during the period, adjustments and conversions, and asks whether the accounting records describe the same activity in the same periods.

That is the accounting definition. Readers looking for broader background on what seed-to-sale tracking is, how the systems work and what they are used for will find that in our METRC guide, which is the informational companion to this service page.

A recurring source of trouble is treating the compliance system as if it were the books. It records real and important information, but it was never designed to produce financial statements, and it does not carry the information a financial statement needs.

The systems overlap because they observe the same business activity, but they answer different questions. Reconciliation is the bridge between them, not a replacement for either one.

Comparing operational inventory information against the financial inventory accounts follows the same roll-forward logic used for any inventory balance. Each component is tested against a source rather than accepted because the total looks reasonable.

Quantity-level accuracy does not automatically produce a financially accurate inventory balance. The compliance system may show exactly the right number of units while the ledger carries them at the wrong cost, in the wrong period, or in the wrong account. Both the count and the cost have to be right for the balance sheet to be right.

Reconciliation and inventory costing are related but separate disciplines. Together they determine whether an inventory balance can be supported.

• Inventory quantities confirmed against operational and count records
• Inventory valuation applied through a documented costing method
• Product costs traced to invoices, freight and applicable landed costs
• Production costs assigned to work in process and finished goods
• Cost of goods sold derived from the roll-forward rather than plugged
• Adjustments recorded with an explanation and supporting evidence
• Physical counts used to test the perpetual records
• General ledger balances tied to the subledger detail
• Period-end balances that can be reproduced later from the workpapers

Reconciliation supports inventory accounting; it does not replace a complete inventory costing methodology. Costing policy, standard costs, variance review and valuation are covered on the inventory and cost accounting page.

Retail is where discrepancies surface fastest, because a dispensary posts hundreds of transactions a day across at least three systems. Each system can be internally consistent and the three can still disagree, which is what makes dispensary reconciliation a recurring discipline rather than a one-time fix.

• Seed-to-sale records for packages, sales and adjustments
• POS reports for sales, discounts, voids and refunds
• Purchasing records and open orders with vendors
• Vendor invoices and the amounts actually payable
• Receiving activity and the date inventory was accepted
• Transfers in from other locations or affiliated entities
• Customer returns and how they re-enter inventory
• Inventory adjustments and documented waste
• Physical inventory counts and cycle counts
• Sales and revenue as recorded in the accounting system

Differences occur even when each system appears correct because the systems record events at different moments and through different processes. A package received on the last day of the month, a refund processed in POS but not reversed in tracking, or a product mapped to the wrong catalog item all produce a difference no single system can detect on its own. Broader retail accounting is covered on the dispensary accounting page.

Most cannabis operators face a three-system problem: transaction records in the POS, operational records in the seed-to-sale system, and financial records in accounting. Every pair of systems can drift, and the drift compounds when it goes unexamined.

Sales reconciliation confirms that revenue recorded in the books matches what the store actually sold and what the bank actually received. It runs parallel to inventory reconciliation and often explains differences the inventory work surfaces.

• POS daily and period reports compared to recorded revenue
• Bank deposits and cash records traced to the sales they represent
• Seed-to-sale sales activity compared where the data is relevant
• Taxes collected recorded as a liability rather than revenue where applicable
• Timing differences between sale date, deposit date and posting date
• Refunds and their effect on both revenue and inventory
• Discounts and promotional pricing recorded consistently
• Voided transactions that should not reduce inventory
• Cash overages and shortages identified rather than absorbed
• Payment settlement timing for electronic methods in use
• Journal entries that summarize daily activity into the ledger

Purchasing is the most common source of inventory differences we find, because receiving is a physical event that has to be recorded in several places by people who are busy doing something else.

• Vendor invoices matched to what was ordered and what arrived
• Purchase records reconciled to receiving documentation
• Receiving dates that determine which period the inventory belongs to
• Inventory additions posted at the correct cost, including applicable charges
• Accounts payable balances that agree with vendor statements
• Cash payments applied against the correct invoices
• Seed-to-sale receipt of transferred packages
• Accounting inventory reflecting the same receipt in the same period

Incomplete or mistimed receiving creates a difference in both directions: inventory that physically exists but is not on the books, or an invoice recorded without the corresponding inventory. Either one distorts the period's cost of goods sold until it is found.

Transfers move inventory without a sale, which means they change where value sits without changing how much of it exists. That makes them easy to record on one side and forget on the other.

• Transfers between licensed locations of the same operator
• Movement between departments within a facility
• Movement between production stages as material changes form
• Transfers between affiliated entities where applicable
• Open transfers that were initiated but never received
• Quantity differences between what was sent and what was accepted
• Location-level inventory balances after the transfer posts
• Accounting entries that move cost along with the units

Operational transfer procedures are governed by the applicable tracking system and regulatory requirements; those specifics belong in the METRC guide. The accounting question here is whether the financial records follow the same movement in the same period.

When two systems disagree, the cause is almost always on this list. Working through it methodically is faster than searching transaction by transaction.

• Receiving errors in quantity, cost or date
• Timing differences around period cutoff
• Unit-of-measure problems between grams, units and cases
• Transfers completed on one side only
• Customer or vendor returns handled inconsistently
• Waste and destruction recorded operationally but not financially
• Damaged inventory written off without documentation
• Shrinkage that has never been quantified
• Production conversions that change form and cost basis
• Manual adjustments made without an explanation
• POS product mapping that does not match the tracking catalog
• Accounting posting errors to the wrong account or period
• Integration failures that skipped a batch of transactions
• Duplicate transactions from a retried sync
• Missing transactions that never reached the ledger at all

Physical counts are the only independent test of whether the perpetual records reflect what is actually on the shelf. Everything else compares one system's data to another system's data.

• Documented count procedures applied the same way each time
• A clear cutoff so movement during the count is handled correctly
• Count differences quantified by product rather than in total
• Waste and destruction events reviewed against the count variance
• Shrinkage identified and tracked over time as a trend
• Damaged product accounted for separately from unexplained loss
• Unrecorded transfers identified as a cause of apparent shortages
• Receiving timing reviewed for inventory counted but not yet booked
• Adjustments posted only after the difference has been explained

Unexplained physical differences should be investigated rather than forced into agreement. A recurring variance in the same product or the same location is usually telling you something about a process, and that information is lost the moment it is adjusted away.

Cost of goods sold is a derived figure, which means it inherits every error in the inputs. When inventory records are unreliable, the effects show up across the income statement rather than in one place.

• Beginning inventory carrying forward last period's unresolved differences
• Purchases recorded in the wrong period or at the wrong cost
• Production costs assigned inconsistently between runs
• Ending inventory that cannot be traced to counts or tracking data
• Cost of goods sold absorbing whatever the other numbers leave behind
• Gross profit that swings between periods without an operating explanation
• Product-level margins that cannot be relied on for pricing decisions

Cost of goods sold in a production environment is not a single formula applied uniformly; it depends on the costing method, the stage of inventory and the business model. That methodology is addressed on the inventory and cost accounting page, and reconciliation is what makes the methodology trustworthy.

Accurate inventory and cost of goods sold records matter when preparing financial statements and tax records for a cannabis business, because those records are the evidence behind whatever positions the return takes.

What reconciliation contributes is documentation: inventory balances that can be traced, movements that can be explained and schedules that hold up when someone asks where a number came from. Position analysis belongs with 280E tax compliance.

Cultivation reconciliation follows a biological process rather than a purchase order. Inventory is created rather than bought, changes form as it moves through the cycle, and loses weight along the way for entirely legitimate reasons.

• Plant, batch and package activity where the tracking system records it
• Harvest events and the wet-to-dry weight relationship
• Waste and destruction recorded through the cycle
• Movement between production stages and rooms
• Work in process balances that reflect crops not yet harvested
• Finished inventory available for transfer or sale
• Physical counts of packaged and bulk material
• Cost records supporting what was accumulated into each batch
• Accounting inventory that mirrors operational stages

Room-level costing and cultivation accounting practice are covered on the cultivation accounting page.

Manufacturing reconciliation is the most technically demanding version of this work, because inventory is transformed. A quantity of input does not correspond to a quantity of output in any fixed ratio, so a simple in-versus-out comparison never reconciles cleanly.

• Raw material received and staged for production
• Production inputs consumed by each run
• Work in process held between stages
• Finished goods produced and packaged
• Conversions that change both unit of measure and cost basis
• Packaging materials consumed alongside product
• Production runs documented well enough to reconstruct later
• Waste and byproduct handled consistently in both systems
• Yield compared to expectation, with variances explained
• Transfers of bulk and finished goods between facilities
• Inventory costing applied consistently across stages

Process costing, bills of material and yield variance analysis are covered on the manufacturing accounting page.

A vertically integrated operator holds inventory in every stage at once. The same material may be a growing plant, a bulk input, a packaged product and a retail sale over the course of a few months, and the records have to follow it the whole way.

• Cultivation producing material for internal use rather than sale
• Processing and manufacturing consuming that material as an input
• Distribution activity where the operator moves product between sites
• Retail selling finished goods the same organization produced
• Multiple locations each holding a portion of the total inventory
• Consistent cost carried across stages rather than reset at each handoff
• Internal transfers documented as carefully as third-party ones

Consistency is the whole game here. When each stage keeps records its own way, the consolidated inventory balance becomes an estimate no one can defend.

Adding locations multiplies reconciliation work rather than adding to it, because every transfer creates a matched pair of entries that both have to be right.

• Location-level inventory balances maintained separately
• Inter-location transfers matched on both sides each period
• Central purchasing allocated to the locations that received the goods
• Store-level POS activity tied to store-level inventory
• Shared products mapped identically across every location
• Location dimensions carried into general ledger reporting
• Consolidated reporting that rolls up without manual adjustment

Unresolved discrepancies get harder to diagnose as the organization grows. A difference isolated to one store in one month is a manageable investigation; the same difference spread across four stores and eight months is a project.

Reconciliation belongs in the recurring close, not in the scramble before a tax deadline. Problems found within a month are traceable to specific transactions; problems found a year later often are not.

No single cadence is right for every operator. A high-volume multi-store retailer may need weekly review of some elements, while a smaller single-site business may reconcile fully at each month end. The requirement is that it happens on a schedule somebody owns.

Many operators come to us with problems that have been accumulating for a while. These are the situations cleanup engagements address:

• Tracking and accounting records have not agreed for months
• Inventory on the balance sheet is obviously wrong but nobody can prove by how much
• Cost of goods sold moves unpredictably from period to period
• POS totals do not match recorded revenue or inventory relief
• Old inventory balances sit for products no longer carried
• Transfers are recorded inconsistently between locations
• Adjustments exist with no documentation behind them
• Prior bookkeeping never reconciled inventory at all
• A physical count exposed differences far larger than expected

Cleanup begins by identifying where and when the records first diverged. That means working backward to the last period that can be supported, then rebuilding forward with documented corrections rather than adjusting the current balance to whatever the count says today.

Bookkeeping and reconciliation are different jobs performed on the same records. Bookkeeping records financial activity; reconciliation tests whether that record agrees with the operational reality it is supposed to describe.

• Purchases recorded, then tested against receiving and tracking data
• Sales recorded, then tested against POS and deposit activity
• Inventory posted, then tested against the subledger and counts
• Cost of goods sold derived, then tested through the roll-forward
• Cash and bank activity reconciled to statements
• Vendor bills entered, then agreed to statements and payments
• Journal entries reviewed rather than accepted at face value
• Month-end close that includes reconciliation as a required step

Ongoing close and categorization work is described on the cannabis bookkeeping page, and the reporting built on top of it on the financial reporting page.

Year-round reconciliation changes what tax preparation looks like. Instead of reconstructing inventory in the spring from whatever records survived, the schedules already exist and were tested when the underlying events were still recent.

• Inventory schedules by stage and location, already agreed
• Cost of goods sold support that traces to source documents
• Purchase records matched to invoices and payments
• Adjustments documented at the time they were made
• Ending inventory tied to counts and tracking data
• Supporting workpapers retained and reproducible

Return preparation and the workpapers behind it are covered on the cannabis tax preparation page.

If any of these describe your business, the underlying cause is usually identifiable within a defined review.

Scope varies with the size of the business, the number of systems and the condition of the records. Not every item below is needed in every engagement, and the review is defined before work begins.

• Seed-to-sale reports covering the periods under review
• POS reports including sales, refunds, discounts and voids
• General ledger detail for the relevant accounts
• Inventory accounts and any supporting subledger
• Cost of goods sold accounts and how they are populated
• Vendor invoices for the purchases under review
• Purchasing and receiving records
• Production and batch reports where applicable
• Inbound and outbound transfer records
• Inventory adjustment reports with reasons and users
• Physical inventory count sheets and summaries
• Bank records supporting purchases and deposits
• Prior reconciliations and workpapers if any exist
• Financial statements for the periods involved

Oklahoma cannabis operators run compliance tracking and accounting side by side, and the two only stay aligned when somebody reconciles them deliberately. We work with businesses across the state, including operators in Oklahoma City, Tulsa, Norman, Broken Arrow, Edmond, Lawton and Durant, and with smaller markets served remotely. Reconciliation is report-driven work, so it is handled the same way regardless of where the facility sits.

These questions separate a genuine reconciliation engagement from a bookkeeper who adjusts inventory to whatever the count says.

• Which systems will actually be reconciled, and against what source?
• How do you investigate a discrepancy rather than adjust it away?
• How do you reconcile seed-to-sale data with the general ledger?
• How do you handle differences between POS and tracking records?
• How are inventory adjustments reviewed and documented?
• How does reconciliation affect cost of goods sold and margins?
• Can you help with historical cleanup, and how is that scoped?
• How frequently should our business reconcile, and why?
• How do you work alongside our existing bookkeeper or controller?
• What records will you need from us to start?