Controller
John's desk. Is the month accurate and reconciled, and what needs action this week?
Data status: QuickBooks + Cascade Bank feed through 2026-09-15 (34 days ago). Stale — upload the latest export to refresh these numbers.
Monthly close →Live cash (BoA)
$142,000
bank feed, currentA/R overdue (31+ days)
$294,035
DSO 35 daysA/P due in 30 days
$96,000
of $117,500 total30-day cash coverage
$361,500
cash + collections vs A/P + payroll dueBank-to-book reconciliation
| Live bank balance (BoA feed) | $142,000 |
| Book cash (latest Balance Sheet) | $142,000 |
| Variance | $0 |
Bank and book tie within tolerance. Clean to close.
Close status by month
| Month | P&L | Balance Sheet | Bank feed |
|---|---|---|---|
| 2025-10 | ✓ | ✓ | ✕ |
| 2025-11 | ✓ | ✓ | ✕ |
| 2025-12 | ✓ | ✓ | ✕ |
| 2026-01 | ✓ | ✓ | ✕ |
| 2026-02 | ✓ | ✓ | ✕ |
| 2026-03 | ✓ | ✓ | ✕ |
| 2026-04 | ✓ | ✓ | ✓ |
| 2026-05 | ✓ | ✓ | ✓ |
| 2026-06 | ✓ | ✓ | ✓ |
| 2026-07 | ✓ | ✓ | ✓ |
| 2026-08 | ✓ | ✓ | ✓ |
| 2026-09 | ✓ | ✓ | ✓ |
Collections · who's late
| Client | 31-60 | 61-90 | 90+ | Total |
|---|---|---|---|---|
| Cedar Ridge Corporate Campus | $34,100 | $17,050 | $9,300 | $11,450 |
| Meridian Medical Plaza | $27,900 | $13,950 | $6,200 | $114,050 |
| Brightwell Office Tower | $21,700 | $10,850 | $7,750 | $96,800 |
| Oakline Business Park | $17,050 | $7,750 | $4,650 | $75,450 |
| Northgate Logistics Center | $13,950 | $6,200 | $3,875 | $64,025 |
| Summit Retail Group | $10,850 | $5,425 | $3,100 | $52,375 |
| Evergreen Athletic Club | $9,300 | $4,650 | $2,790 | $45,240 |
| Ironwood Tech Center | $7,750 | $3,875 | $4,340 | $40,465 |
| Larkspur Apartments | $6,200 | $3,100 | $2,325 | $31,625 |
| Willow Creek School District | $4,960 | $2,325 | $1,550 | $25,035 |
| Aspen Grove Medical | $4,030 | $1,860 | $1,395 | $20,085 |
| Maplewood Commons | $2,945 | $1,395 | $1,085 | $14,925 |
| Riverbend Distribution | $2,170 | $1,085 | $775 | $11,330 |
| Stonegate Plaza | $1,395 | $620 | $465 | $6,680 |
$294,035 sitting past 30 days. Chase the 90+ first.
Payables · what's due
| Vendor | Current | 1-30 | Total owed |
|---|---|---|---|
| Vantage Facility Services | $22,000 | $18,000 | $52,000 |
| Cedar Ridge Janitorial Co | $16,000 | $11,000 | $32,000 |
| Meridian Building Care | $14,000 | $6,000 | $23,000 |
| Brightwell Maintenance | $6,000 | $3,000 | $10,500 |
$96,000 due inside 30 days. Mostly subcontractor labor.