METRC · Part 6 of 7 · 3 min read
The METRC Reconciliation Workbook
On this page
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.
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.
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.
- 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.
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.
- Metrc Oregon Wiki: Sales — receipt fields and sales-history actions.
- Metrc Oregon Wiki: Frequently Asked Questions — POS API and date/time-format troubleshooting.
- Metrc Oregon Wiki: Correcting Errors — package adjustment reasons.