The one door for certificates: file here, and it lands in the vault correctly every time.
npm start, then http://localhost:3000/admin/certs). The registry, gap list, and request forms below work here.Saves to C:/Users/reid/Hydro-Wates Inc/Hydro-Wates Files - Documents/Hydro-Wates/Accounting/Tax Exemption Certificates/<Customer>/<issued> <type> <states>.pdf, records it as on-file, recomputes the gap. The certificate must name Scofield Group LLC dba Hydro-Wates as seller.
No harvest yet. Run python scripts/harvest_certs.py (and scripts/harvest_outlook.ps1 for your mailbox).
Hydro-Wates/Accounting/Tax Exemption Certificates/<Customer>/<YYYY-MM-DD> <type> <state>.pdf and recorded in data/exemption-certs.json. Certificates name the seller —
anything issued to Hydro-Wates, Inc doesn't cover the LLC. Process, forms, request template:
docs/EXEMPTION-CERT-PROCESS.md.
| Customer | Status | Type | At stake | Offshore $ | Sales $ | TX untaxed $ | States | Notes |
|---|---|---|---|---|---|---|---|---|
| Transocean Offshore Deepwater Drilling Inc ×3 | reported, not located | offshore-151.324 |
$12,367 | $137,755 | $0 | $12,150 | OFFSHORE,TX | Reid: Transocean has provided exemption certs. Not found anywhere in the share. Locate (email/paper), confirm it names Scofield Group LLC, file it. Also covers whether Houston-performed services and UK repair pass-through are exempt — SALT question. |
| Versabar, Inc ×3 | missing | offshore-151.324 |
$8,944 | $25,872 | $0 | $82,541 | TX,OFFSHORE | Versabar issues a SEPARATE 01-339 offshore exemption cert PER PO (signed Deborah Crawford). Found by the harvest (in the review queue): PO H-44309 (Feb 2024, Green Canyon 563; covers inv 24015, 24029) and PO H-45838 (Oct 2024, names Scofield Group LLC; covers inv 24169). STILL MISSING: POs H-47142, H-47284, H-47813, H-48428, H-48356 = $76K of TX-delivered untaxed rentals (inv 24320-24512). Request one cert per PO. (The 2011 TX Resale Cert, Versabar file is Hydro own cert TO Versabar - outbound.) |
| Floatel | missing | offshore-151.324 |
$2,206 | $26,736 | $0 | $0 | OFFSHORE | Offshore delivery (Reid). Rows already flagged offshore; the cert makes it defensible. |
| Benmar Fabrication | unregistered | $2,010 | $0 | $0 | $24,358 | TX | ||
| Rig Surveys, Inc | unregistered | $1,377 | $0 | $1,481 | $15,440 | TX | ||
| Axess North America Inc ×6 | missing | offshore-151.324 |
$1,123 | $0 | $0 | $13,608 | TX,LA | Offshore-services company; $13.6K TX-delivered rentals untaxed + LA rows. Six duplicate Zoho customer records — merge. |
| TDI-Brooks International, Inc | unregistered | $1,015 | $0 | $11,948 | $2,168 | TX | ||
| ECR Florida Division | unregistered | $843 | $0 | $0 | $10,219 | FL,TX | ||
| Qualitech IRM | unregistered | $817 | $0 | $0 | $9,900 | TX | ||
| Konecranes | unregistered | $668 | $0 | $9,537 | $0 | OH,SC,SD,TX | ||
| Continental Disc Corporation | unregistered | $622 | $0 | $0 | $7,536 | TX | ||
| Hoist & Crane Service Group | unregistered | $547 | $0 | $0 | $6,632 | TX,IN,LA,SC | ||
| Polar Rig Specialties Inc. | unregistered | $495 | $0 | $6,032 | $0 | TX | ||
| Consolidated Rigging & Marine Supply | missing | resale |
$417 | $0 | $5,958 | $0 | Supply house — $6K sale; resale cert candidate. Ship-to unresolved. | |
| Centex Material Handling | unregistered | $403 | $0 | $0 | $4,881 | TX | ||
| Cajun Hydraulics & Crane Services, LLC | unregistered | $384 | $0 | $5,487 | $0 | LA | ||
| Houston Ship Repair | unregistered | $378 | $0 | $0 | $4,587 | TX | ||
| Doc Bailey Construction | unregistered | $370 | $0 | $5,279 | $0 | |||
| Crane Tech, Inc. | unregistered | $290 | $0 | $0 | $3,517 | TX | ||
| Seatrium AmFELS | unregistered | $238 | $0 | $0 | $2,884 | TX | ||
| Gulf Marine Contractors | unregistered | $199 | $0 | $0 | $2,408 | TX | ||
| Infrastructure Services, LLC | unregistered | $195 | $0 | $2,786 | $0 | FL | ||
| Innovative Lifting LLC | unregistered | $179 | $0 | $0 | $2,169 | TX | ||
| Bado Equipment Service Co., Inc. | unregistered | $156 | $0 | $0 | $1,895 | TX | ||
| EBI Cranes | unregistered | $125 | $0 | $0 | $1,511 | LA,MA,TX | ||
| Innonative Lifting LLC | unregistered | $116 | $0 | $0 | $1,400 | TX | ||
| Hoisting Wire Rope and Sling | unregistered | $114 | $0 | $0 | $1,380 | TX | ||
| Consolidated Rig Works | unregistered | $89 | $0 | $417 | $730 | TX | ||
| Subsea 7 | unregistered | $70 | $0 | $0 | $843 | TX | ||
| Baker Construction | unregistered | $45 | $0 | $754 | $0 | ID | ||
| Hydro-Wates Inc | not exempt | resale |
$0 | $0 | $0 | $0 | TX,CA,AL,AR | The predecessor entity billed as a CUSTOMER ($129K, 13 invoices, TX/CA/AL/AR). Related-party — sales are still taxable unless a real resale/transfer exemption applies. CPA question. |
| Kiewit (all entities) ×7 | not exempt | government-federal |
$0 | $0 | $0 | $0 | MD,TX | Contractor on federal/public jobs (IBWC Brownsville levee, etc.) — the CONTRACTOR is the purchaser, so NOT exempt. Seven duplicate Zoho records — merge. |
| USACE | gov't — PO | government-federal |
$0 | $0 | $0 | $0 | US Army Corps of Engineers. Keep the PO. | |
| Mid-Atlantic Regional Maintenance Center | gov't — PO | government-federal |
$0 | $0 | $0 | $0 | US Navy (MARMC, Norfolk VA). Federal purchaser — exempt by law. Keep the POs/contract in the customer folder. | |
| Atlantic Rigging & Heavy Transport | missing | resale |
$0 | $0 | $0 | $0 | VA | Rigging company in VA (part of the VA rental base). If re-renting → VA resale cert (ST-10). Confirm. |
| Prolift Rigging | missing | resale |
$0 | $0 | $0 | $0 | Rigging company; re-rental candidate. | |
| Bishop Lifting | missing | resale |
$0 | $0 | $0 | $0 | TX | Rigging/rental house — if they re-rent Hydro equipment, rental-for-re-rental is exempt with a TX resale cert. $21.6K TX rentals untaxed. Confirm re-rental vs own use. |
| Military Products & Hardware | missing | resale |
$0 | $0 | $0 | $0 | CA | Reid confirmed: bought for resale to the US military. Transaction exempted in exemptions.json (HWI-24-027). Obtain a CA resale certificate (CDTFA-230) or MTC Uniform cert naming Scofield Group LLC to make it audit-proof. |
| USAF | gov't — PO | government-federal |
$0 | $0 | $0 | $0 | UT | Federal (UT). Keep the PO. |
| Kiewit Offshore Services, Ltd. | reported, not located | direct-pay |
$0 | $0 | $0 | $0 | TX | Reid: Kiewit presented their direct-pay certificate with the subcontract. Located 2026-09-27: signed TX Form 01-919 (DocuSign 6/1/2023, direct payment permit 1-47-0822068-7, ACTIVE on the Comptroller's direct-pay list since 2001) is Attachment No. 6 of the HWI-24-092 subcontract (Kiewit Contract.pdf, page 20). File it from the /admin/certs review queue. Covers Kiewit Offshore Services only, not other Kiewit entities. |
| City of Grants Pass WRP | gov't — PO | government-state-local |
$0 | $0 | $0 | $0 | OR | Municipality; OR has no sales tax anyway. |
| Port of Beaumont | gov't — PO | government-state-local |
$0 | $0 | $0 | $0 | TX | Navigation district = TX political subdivision (Tax Code 151.309) — exempt. Keep the PO. Clears $10.9K from the TX under-collection base. |
| NASA | gov't — PO | government-federal |
$0 | $0 | $0 | $0 | MS | Federal (Stennis, MS). Keep the PO. |
| Austal USA LLC | on-file | direct-pay |
$0 | $0 | $0 | $0 | AL | Alabama direct-pay permit found in Agreements/. Verify it's current (AL permits are renewed annually) and that it names the LLC as vendor if required. |
| US Army | gov't — PO | government-federal |
$0 | $0 | $0 | $0 | Federal. Keep the PO. |