Dashboard
Your financial position at a glance — this month’s activity, what’s due, and where the close stands. Read-only.
Automated Builds
Sub Req Tracker
—
Loading…
Sub Pay Apps — G702 draws
—
Loading…
Staging lane — keying a draw feeds the normal Intake rail (SUB badge). Nothing here posts or pays.
Payroll
Labor mix & burden — latest run
Roll-ups
Pay runs—
Read-only. Recomputes each PR tab's cash ties (net / tax / trust) and benefit-recon checks from the workbook. Nothing posts — the wire is still keyed & sent by a human.
Delivery Print
Ticking “Printed & Placed for Delivery” on the Shipping Look Ahead report prints that row’s attached PDFs on the shop Sharp — shipping ticket and bolt list on Letter, 24×36 erection drawings scaled to 11×17, simplex. Jobsite photos are never printed. Each row prints once; use Reprint below for another copy.
Shop Flow
Production scopes and the hours logged against them, from the Shop Flow ledger. The age of an open ASAP is the number Smartsheet cannot show you: once a scope completes, its row is moved to an Archive sheet and the ASAP history collapses to a single automation event dated the move. The ledger snapshots every 15 minutes to keep it. Read-only — it never writes to Smartsheet.
Loading…
Bank Recon
The monthly BES 8008 reconciliation staged by APEX-BANKREC. CM wires get a running wire # and post via Data Exchange; manual checks are auto-detected against the Spectrum check register and clear via A/P (no wire #). Read-only — a human keys & posts. Nothing here moves money.
Run for month
confirm start #
Loading…
AP Payments
What's due, grouped by job, against the reconciled cash balance — so you can see whether cash covers the payables. Open A/P + retention come from the latest A/P Aged Payables export; cash is the last reconciled BES 8008 statement. Read-only — nothing here moves money or posts to Spectrum.
All open
Past due only
Click a job to expand invoices · click a column to sort
Loading…
Live: cash floor + due-by-job (Phase 1), projected gross-profit per job (Phase 2), and a check-run builder (Phase 3).
Tick invoices in any job to build a check run grouped by vendor, then export or print it to hand-write the checks. Staging only — Qori never releases funds or posts to Spectrum.
Needs Review
—
On Hold
—
Ready to Post
—
Management
—
Posted · MTD
—
Invoice Queue — Needs Review
—
Recent activity
Loading…
Batch Runs
Loading…
Purchase Orders
Purchasing Log — click a bucket to drill in
—
Need Review
—
Open on PLOG
—
Posted
—
Posted by APEX — all time
Needs Review
—
| Loading… |
PO Chase — Last Run
Subcontracts & Change Orders
Sub gate — click a bucket to drill in
—
Subs Posted
—
COs Posted
—
Outstanding
—
Total Committed
Posted
—
| Loading… |
System Health
Loading…
Recent Activity
Loading…
Certificate of Insurance Status
—
Loading…
Active Jobs — COI & Tax
Loading…
Certifications
The certification roster reconciled against the Cert Vault. Coverage is
computed per person from the roster's own cells — anything marked N/A is excluded, not chased.
Coverage
Needs mapping
Exceptions
Loading…
AP Pipeline
Every invoice that has arrived but isn't in Spectrum yet — from the moment it hits the inbox to the moment it posts. Age = days since the invoice date (how overdue it is to the vendor); anything over 30 days is a red flag. Sorted oldest-first — the worst offenders are always on top.
Project Cash
Where every job's cash stands — billed vs collected, cost vs paid, what's still owed in each direction, and what's ordered but not yet invoiced — with the unposted invoices behind it. Scope it to one Project Manager, to all of them, or to a company book.
Pick a Project Manager above to open their desk.
Data Sources
Drop a Spectrum export here. Qori parses it into structured data and stamps it with an upload time, so every reconciler reads the authoritative record instead of parsing PDFs. Watch the freshness pill — if a source goes stale, downstream jobs hold instead of reconciling against old data.
Loading…
Claude Usage
What Claude costs BES and what it produced, per member. Read-only. Only Seats and Console API are amounts BES pays — everything else is value at pay-as-you-go rates.
Statement Recon — command center
The living state of every vendor statement: the latest recon per vendor, where each invoice sits, and what’s stayed unresolved month over month so nothing slips.
Drop a new statement below to reconcile it live and update the board.
Statement coverage — top vendors by open A/P
Ranked by what we owe (Spectrum A/P Aged Payables — the authoritative open balance). A gap is a large balance with no current statement on file; request one so nothing slips through the cracks.
Loading…
Tax exemption exposure — what a vendor may ask us to prove
Sales tax we short-paid on tax-exempt jobs, biggest first, with the certificate position beside it. A row with no certificate is money we withheld and cannot yet evidence — get the ST-5C/ST-2 before the vendor asks.
Loading…
Latest recon by vendor
Loading…
⚠ Open items — fall-through watch
Oldest first. Invoices unresolved on the latest statement — a red age chip means it carried over from a prior one.
Loading…
Reconcile a new statement
Reads Spectrum & Smartsheet live — runs on the office PC. The board above you can view from anywhere.
Vendor hint (optional)
AP Ask Queue
Every email in the AP inbox, worst first — what the vendor is asking for, and whether the invoice
they sent became an Intake row. Mail that asks for nothing still matters: an invoice that never
became a row is the thing no other check in APEX can see.
The queue
Worst first: credit holds, then certificates, then everything else. A repeat chip means the vendor has already asked more than once.
Loading…
JE Command Center
Every recurring journal entry in one place. Each tile shows the last run and amount; open one to build this month’s entry. Nothing posts — you review and post to Spectrum yourself.
Loading…
WIP Report
Loading…
Management
Overhead and service invoices — awaiting approval, ready to post, and what has already reached Spectrum.
Loading…
Month-End Close
—
Tick each item as it's completed — the state is shared with the cloud portal, so you can check things off from your phone. Add or remove items and sections as the close evolves. Interco & WIP are gated to run after AP is closed per the CFO. Recurring GL clean-up tasks are tracked separately below — they don't gate the close.
—
Loading…