DPAS Covered-Material Sales, Authorization & Evidence System
DPAS Covered-Material Sales, Authorization & Evidence System
Control domestic sales, manage written BIS exceptions and authorizations, track permitted exports and retain evidence for each covered transaction.
This macro-free Excel workbook connects covered-material classification, buyer and location evidence, written authorization terms, capacity and AES/EEI shipment controls. Updated October 1, 2026.
MANAGE AUTHORIZED EXPORTS, NOT JUST DOMESTIC SALES
Record the actual approval type and BIS number, status, effective and expiration dates, written terms, conditions, correspondence and reviewer. Document each permitted buyer, destination and material combination. Link each transaction to those records and retain its conditions evidence.
Track prior consumption, consumed transactions and active reservations against your documented USD and quantity ceilings. Multiple approved scope records share one authorization ceiling. No standard dollar limit or public company's undisclosed license terms are assumed.
BUILT-IN CONTROLS
PASS — Entered authorization checks are complete.
REVIEW — Resolve missing terms, evidence, usage or determinations before release.
BLOCK — Entered scope, dates, conditions, inactive approval or capacity prevent release.
AUTHORIZED — The underlying covered transaction is supported by checked written authorization terms. The final Sales Register status also requires its applicable AES/EEI gate.
The controls flag missing or duplicate authorization IDs, unmatched buyer/destination/material combinations, dates outside the approval, quantity-unit mismatches, exhausted aggregate capacity and failed conditions. A pending request cannot be used as permission.
12 WORKSHEETS
Start Here — Requirements and operating instructions
Dashboard — Covered sales, domestic share, authorization and shipment indicators
Material Classification — Covered-material determinations
Buyer Diligence — U.S.-person status and supporting evidence
Sales Register — Sales, authorization checks, capacity states and shipment linkage
BIS Requests — Requests, adjustments, exceptions, interim relief and correspondence
Evidence Index — Controlled supporting records and references
Monthly Review — Domestic share, authorized covered sales, exceptions and sign-off
Authority & Change Log — Regulatory sources and updates
AES/EEI Shipment Control — Four-scenario filing and shipment-release gate
Authorization & License Control — Written approval terms, prior use, consumption, reservations and remaining capacity
Authorized Scope — Approved buyer, destination and material combinations
RETAIN THE AES/EEI EVIDENCE
The existing shipment controls retain DPAS and EAR license determinations and numbers, C30/C33 treatments, DPASNO placement, Schedule B use, commodity-line values, accepted filing status, ITN, filing date and release/hold status. A DPAS authorization does not replace separately required EAR permissions.
OPERATIONAL SCOPE
Built for battery recyclers, black-mass processors and sellers, tungsten recyclers, materials brokers, export-compliance teams, logistics and internal audit.
The template supports 100 authorizations, 200 approved scope combinations, 200 sales records and 100 AES records. Values use USD or documented USD equivalents, and quantity ceilings use one unit per authorization. Special sublimits, return obligations and other approval-specific conditions require supporting schedules and a documented conditions review. The workbook flags entered controls; it does not prevent activity outside Excel or certify compliance.
Normal price: $129, one-time purchase
Format: Macro-free Microsoft Excel .xlsx
Delivery: Instant digital download
Release: October 1, 2026
Current allocation-order period: August 27, 2026 through August 27, 2027, unless changed
Operational compliance aid, not legal advice. Confirm current BIS, EAR, Census, CBP, FTR and classification requirements and the full terms of your written approval before release.