Financial data pipeline — per-entity wiring (internal)¶
Internal appendix
This page holds the bookkeeping-system wiring that used to sit on the entity pages. It is internal plumbing — entity pages reference financial figures only through the rendered data layer, per the lender & underwriter writing standard.
Each company keeps its own QuickBooks file on the QuickBooks host server
(\\SEQ-QBHOST\Quickbooks Company Files\). The qb-bridge job syncs every file into the group's
Postgres data warehouse daily. (The former per-entity DuckDB files were deleted 2026-06-21;
Postgres is the only warehouse.)
| Company | QuickBooks file | Warehouse sync |
|---|---|---|
| Superior Equipment | Superior Equipment.qbw |
daily via qb-bridge |
| Superior Truck & Equipment | Superior Truck & Equipment.qbw |
daily via qb-bridge |
| Superior Water Truck Parts | Superior Water Truck Parts.qbw |
daily via qb-bridge |
| Cactus Truck Parts | Cactus Truck Parts.qbw |
daily via qb-bridge |
| Sedona Jeep Builders | Sedona Jeep.qbw |
daily via qb-bridge |
| Cactus Truck Rebuilder | file being set up | qb-bridge integration pending |
Intercompany invoicing (for example shop-to-dealership build invoices) is standard receivables/payables between separate corporations — no special intercompany journal logic anywhere in the pipeline.