METRC · Part 6 of 7 · 3 min read

The METRC Reconciliation Workbook

On this page
  1. Preserve the source exports
  2. Match packages before products
  3. Build an exception queue
  4. Review before changing records
  5. Sources

A reconciliation workbook should show where each mismatch came from, not make the systems agree on their own. Keep each export intact, match records on identifiers that refer to the same package or receipt, and send uncertain matches to a person for review.

Preserve the source exports

Keep separate, dated tabs or files for Metrc package history, sales receipts, transfers, physical counts, and POS records. Do not clean up or change values in the source copy. Add cleaned fields in a separate comparison sheet so a reviewer can return to the original value and export time.

Match packages before products

Use the package label or other stable package identifier when both systems expose it. A SKU or product name identifies a catalog item, not a specific package; one product can have multiple packages and histories. If there is no shared identifier, create a possible match from date/time, product, quantity, and receipt total, then mark it for review rather than treating it as a confirmed match.

Build an exception queue

  • Package check: package ID, status, room/location, and quantity by unit.
  • Receipt check: receipt/transaction ID, sale time, line, package, and quantity.
  • Transfer check: manifest ID, package, sent quantity, and receiver's status in Metrc.
  • Count check: physical count, counter, date, and recount result.
  • Action log: what differed, the evidence, who owns the fix, what was corrected, and when it was checked.

Review before changing records

Add a check column to the comparison sheet that highlights rows with a missing or duplicate package ID, a unit count that differs from Metrc, or a sale with no matching Metrc entry. Do not let a spreadsheet post adjustments or choose a correction automatically. The authorized user should check the package history and the source transaction, correct the record in Metrc using the adjustment or sales-history action that fits the error, and spot-check the updated records afterward.

Sources

Let’s work together

Need help with a discrepancy?

I help retail teams resolve METRC issues and build inventory routines that hold.