BatchVault — COA Review

California Cannabis Certificate of Analysis Validation Automation

Review Queue

reviewed

—

Incomplete

—

In Review

—

Complete

Customer↕

Responsible

Status↕

Finish By↕

Fields↕

Submitted↕

Loading shipments…

Transport Queue

reviewed

—

Pending

—

In Review

—

Approved

Origin

Destination

Validation

Depart

Review

Uploaded

Loading manifests…

License & Credentials

—

Active

—

Expiring Soon

within 30 days

—

Expired

—

Alerts

unacknowledged

License #

Holder

Type

Expires

Status

Actions

Loading credentials…

Packaging & Labeling

Loading…

—

Draft

—

In Review

—

Approved

—

Validation Fail

SKU / Product Version Type Status Validation COA Linked Uploaded

Loading…

All fields complete — confirm and sign off

Document Verified

Select a document to begin review

Loading PDF…

API grounded

Text match

Search result

Extracted Fields

—

Verified

Batch Context

Select a document to see extracted fields

Transport Manifests

— manifests

— approved

— in review

— validation errors

Manifest #	Origin	Destination	Type	Packages	Validation	Review Status	Uploaded

Intelligence

Compliance Score

Banking Compliance Report — Export your compliance posture for bank onboarding

THC% Distribution

Lab Comparison

Lab	Docs	Fill Rate	Compliance	Avg THC

Customer Overview

Customer	Docs	Avg THC	Fill Rate	Compliance	Signals

Lab reliability scores based on ADE extraction accuracy, DCC license status, and COA pass rate.

Loading lab reliability data…

Loading regulatory changes…

Strict Sign-Off Required

The following fields must be individually approved before this document can be verified. Click the checkmark next to each field in the panel.

Audit Log & Rollback

Who	When	Stem	Field	Old Value	New Value

No entries found. Adjust filters and click Load.

Revert field changes made by a specific user

Username to roll back

Undo changes since

Custom cutoff (ISO date)

Rollback Preview

⚠️ This will permanently overwrite the current field values shown below with the pre-change values. A rollback entry will be logged. This cannot be undone automatically.

Stem	Field	Current (bad)	Will Restore To

When	Who	Document	Field	Action

No entries found. Adjust filters and click Load.

Manifest Review

#	Package UID	Product	Qty	Unit	Weight (g)	Value ($)	COA

Transport Document

Loading PDF…

Extracted Fields

— / —

—

Loading…

Credential Document

Credential Fields

— / —

—

Loading…

The Vault

Customer

Responsible

Status

Report Date

Fields

Submitted

No archived documents yet. Verified COAs move here 18 months after their report date.

Team Management

Username	Name	Role	Email	Status	Actions
Loading…

Upload

Drop your COA here

PDF or photos (JPG, PNG, TIFF, WebP)
Multiple images are combined into one document

Browse Files

Processing COA…

Uploading and parsing document. This takes 30–90 seconds.

Uploading Parsing Extracting Analytes Done

COA Added to Review Queue

The document has been parsed and all 35 fields extracted. Refreshing queue…

Upload Manifest

Drop your file here

PDF or photos (JPG, PNG, TIFF, WebP)
Multiple images are combined into one document

Browse Files

Processing manifest…

Uploading and processing document. This takes 30–90 seconds.

Uploading Parsing Extracting Validating Done

Manifest Added to Review Queue

Fields extracted and validation checks complete. Refreshing queue…

SOP Document Control

HR & Employee Compliance

Audit Readiness

No simulation run yet

COA Coverage

--%

Manifest Coverage

--%

Run a simulation to see category scores.

Top Priority Gaps

Run a simulation to see gaps.

Reports

94.3%

Primary Fields Fill Rate
(24 fields × 77 COAs)

92.0%

Supporting Fields Fill Rate
(16 fields × 77 COAs)

COAs Processed
4 licensees · 3 labs

Extraction Coverage by Schema

Primary Fields (24)94.3%

Supporting Fields (16)92.0%

Field-Level Breakdown — Notable Gaps

Field	Fill Rate	Why It's Low
Lab License Number	62%	Excelbis Labs does not print their DCC license number on their COA template. All affected documents have been flagged for manual reviewer entry. This is a document design gap, not an extraction failure.
Date Tested	39%	SC Labs and Belcosta Labs fold testing date into the Report Date field — no separate date appears on those COAs. Null values on those documents are expected and correct. Fill rate is ~100% among the 30 Excelbis COAs where the field exists.
Sample Photo Present	74%	ADE returns null instead of false on ~26% of documents where no sample photo is present. The extraction engine should return false when no photo is found — this is a model compliance gap being tracked for schema improvement.
Density (g/mL)	16%	Density is rarely printed on COAs. Only appears on a subset of Excelbis Labs documents. The field is correctly identified as absent on all others.
Total CBD	97%	A small number of COAs report CBD below the limit of detection with no numeric value printed. The field is correctly identified as absent.
ISO Accreditation	97%	Minor formatting variations on 2 documents where the accreditation number appears in an unexpected location.

On "missing" fields: When a field shows null, the extraction engine has determined the information does not appear anywhere in the source document — it does not hallucinate or guess. Every null value is a correct and conservative response. Reviewers should use the manual entry form to supply any information they can locate through other means.

How We Optimized the Schemas

27% → 99% Cannabinoid Panel Status — Initial schema only accepted "Pass" as a valid value. After reading Excelbis Labs' actual COA output, we discovered they use "Complete" instead. Adding "Complete" as an accepted value brought fill rate from 27% to 99%.

Rounded → Full precision Numeric fields (THC, CBD, Total Cannabinoids) — Early extraction rounded values like 0.0127% to 0.013%. Schema descriptions were updated to explicitly preserve full printed precision. Values are now captured exactly as they appear on the document.

1 pass → 2 passes Schema splitting — All 35 fields are extracted in two sequential passes: 23 primary compliance fields first, then 12 supporting fields. Splitting the schema improves per-field accuracy by giving the extraction engine a tighter, more focused context for each group.

Generic → Lab-specific Lab vocabulary grounding — Schema descriptions were updated based on reading actual parsed COA text from each lab. Terms, formatting conventions, and layout patterns are described specifically rather than generically, which reduces misidentification across Excelbis, SC Labs, and Belcosta templates.

Batch Field Correction

Field

From value (leave blank to match all) To value

Label Review

Loading PDF…

—

Profile

Date Format

Time Format

Compliance Calendar

Loading compliance events…

No compliance events in this window.

Testing Workflow

Loading workflows…

—

Chain of Custody Ledger

Total Materials

—

Total Events

—

With Exceptions

—

Pending Attestation

—

Loading…

Select a material to view its custody chain.

Validation Checks

Select a material to see checks.

Track-and-Trace Reconciliation

Last Run Results

Reconciliation History

No runs yet.

Upload Inventory Snapshot

Upload a CSV or paste JSON of your current inventory. Each row/item should have: uid, product_name, quantity, unit, status, location, last_movement

Drop CSV file here or click to upload

Accepts .csv files — columns: uid, product_name, quantity, unit, status, location, last_movement

METRC User Access Log

Select a document

Transport Manifests

Intelligence

Strict Sign-Off Required

Audit Log & Rollback

Transport Queue

Document

Extracted Fields

Credentials

Credential Fields

The Vault

Team Management

New User

Edit User

Upload

Drop your COA here

Files selected

Processing COA…

COA Added to Review Queue

Upload Manifest

Drop your file here

File selected

Processing manifest…

Manifest Added to Review Queue

SOP Document Control

New SOP Version

HR & Employee Compliance

Add New Employee

Audit Readiness

Reports

California DCC Compliance Issues

AI Extraction Accuracy Report

Extraction Coverage by Schema

Field-Level Breakdown — Notable Gaps

How We Optimized the Schemas

Batch Field Correction

Intelligence — Credentials

Audit — Credentials

Batch Field Correction — Credentials

Upload Label Proof

Label Versions

Label Proof

Keyboard Shortcuts

Strict Sign-Off Mode

The Vault — Transport

Reports — Transport

Intelligence — Transport

Batch Field Correction — Transport

Audit — Transport

BatchVault Superadmin

Org detail

Accuracy Threshold for Human Review

Registered States

Account

Your Subscription

Billing & Payment

Profile

Upload License / Credential

Help

Compliance Calendar

Testing Workflow

New Testing Workflow

Chain of Custody Ledger

Validation Checks

Log Custody Event

Track-and-Trace Reconciliation

Drop CSV file here or click to upload