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…
Reconciliation
Tolerances
GL Period
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
-
Cash & LOC by GL Account
Per-account cash and line-of-credit balances from the matched GL account scope. Totals reconcile to the recon panel above.
Operating cash
| Account | Name | Balance | GL Rows |
|---|---|---|---|
| Total | - | ||
Line of credit
| Account | Name | Balance | GL Rows |
|---|---|---|---|
| Total | - | ||
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
Coverage Review Weeks
Weeks most dependent on manual / projected assumptions, ranked by manual-projected dollars. These are the weeks worth a manual sanity check.
| Week | Direct CE / Live | Historical / Modeled | Manual / Projected | Dominant Tier | Manual Share |
|---|
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
Open jobs flagged for unmatched GL accounts, anomalous totals, or missing contract values. These rows feed back to the project accounting team.
| Job | Contract | Billed | Cost | Unmatched GL | Flags |
|---|