Controller Lens
Reconciliation Trust Strip
Source freshness, recon pass/fail pills with editable tolerances, and GL period state. Phase 2 layers AR aging, AP aging, cash-by-account, vendor concentration, and payroll cadence on top of this strip.
Phase 3
Loading controller view…
Recon
-
GL Period
-
LOC Utilization
-
Open AR
-
Open AP
-
Reconciliation
Tolerances
GL Period
Cash & LOC by GL Account
Current ending balances as of the latest closed GL period, for the bank accounts mapped to cash and line-of-credit scopes. Refreshed nightly. JR&CO runs operating cash near $0 by design — the LOC carries the working-capital float, so operating-cash totals close to zero (or slightly negative) are expected, not an alarm.
Operating cash
| Account | Name | Balance | GL Rows |
|---|---|---|---|
| Total | - | ||
Line of credit
| Account | Name | Balance | GL Rows |
|---|---|---|---|
| Total drawn | - | ||
LOC borrowing cap
-
From
cash_forecast_assumptions.loc_borrowing_cap.Capacity remaining
-
Cap minus current LOC drawn.
Utilization
-
% of borrowing cap currently drawn.
AR Aging
Aging buckets for open AR. Click any bucket to drill into the AR Collections page (filter to follow once that page accepts a query param).
Future
-
- invoices
Overdue 0-30
-
- invoices
Overdue 31-60
-
- invoices
Overdue 61-90
-
- invoices
Overdue 90+
-
- invoices
Total Open AR
-
Active Overrides
-
Follow-ups due in 7 days
-
Payroll Cadence
Next payroll run, total payroll across the horizon, and the largest single-week run. Projected weeks use a trailing-average from
accounting_gldetail_latest_v.Next Payroll
-
-
13-Week Total
-
-
Largest Weekly Run
-
-
Avg Projected Run
-
Trailing-week average used for projected rows
AP Aging
Open vouchers grouped by days past due. Discount-eligible and stretched cards highlight time-sensitive cash decisions.
Current
-
- vouchers
1-30 Past
-
- vouchers
31-60 Past
-
- vouchers
61-90 Past
-
- vouchers
90+ Past
-
- vouchers
Discount-eligible (next 7 days)
-
-
Stretched AP $
-
-
Likely outstanding checks
-
Issued in last 14 days · proxy until bank rec lands
Total checks issued (60d)
-
Avg - days since issue
Vendor Concentration
Top vendors by share of open AP and trailing-13-week paid. Rows shaded amber when a vendor crosses 15% of either pool.
| Vendor | Open AP | % of AP | Last 13w Paid | % Paid | Open Vouchers | Next Due |
|---|
Job Data Quality
Customer-facing project jobs with anomalous totals, missing contract values, or unmatched GL accounts. Indirect/overhead cost-collection buckets (training, warehouse, close-out, etc.) are hidden by default.
-
| Job | Contract | Billed | Cost | Unmatched GL | Flags |
|---|
▾ Payroll Cash-Out Triangulation
Diagnostic. Independent fiscal-YTD payroll cash-out estimates from
cash_forecast_payroll_cash_out_candidates_v.
When multiple independent methods converge on the same number, the underlying payroll data is trustworthy.
Methods labelled prledgergl_* use the GL-side payroll ledger we cleaned tonight; pr_* methods
use the source-tagged payroll lines; prtppaydet_* and prledger_joined_* require the
prtppaydet detail table, which is currently unused in this CE module.
Methods reporting
-
-
Median estimate
-
Used as the reference point for variance.
Tight-cluster band
-
Range of methods within ±10% of median.
| Method | Source | Amount | Variance vs. median | Status |
|---|
▾ Forecast Confidence Map
Diagnostic. Where the 13-week forecast transitions from CE-live scheduled activity (high confidence) to model-projected assumptions (sanity-check first). Weeks with zero forecast activity are hidden.
Live forecast horizon
-
Consecutive weeks anchored in CE-live data.
First modeled week
-
After this week, the forecast relies on assumptions.
Modeled $ share
-
% of 13-week activity that is model-projected.
-
| Week | CE-Live $ | Modeled $ | Manual $ | Confidence |
|---|