📊 Position & 13-Week Outlook
Cash Today
$2.80M
Brex live + BOA per NetSuite GL
Projected In (13w)
$5.85M
collections schedule + other inflows
Projected Out (13w)
$4.27M
payroll + cards + vendors/AP
Net (13w)
$1.58M
ending balance $4.38M
Lowest Projected Balance
$2.43M
week of Aug 17
Dark green = committed cash in (collections ledger + Job Complete finals + other inflows) · light green = run-rate top-up (new sales / unscheduled conversions, statistical) · red = projected cash out · gold line = projected balance. Collections "Late" backlog ($1.80M) is NOT projected (timing unknown — upside). Historical 12-week medians for reference: in $450K/wk · out $218K/wk.
🏦 Cash Position Detail
| Account | Balance | Source |
|---|---|---|
| Brex — Primary checking | $261K | Brex API (live) |
| Brex — Sunnova Rebates | $0 | Brex API (live) |
| Brex — Treasury | $1.01M | Brex API (live) |
| Brex — Vault | $0 | Brex API (live) |
| BOA (Main + Orlando) + Takenos | $1.53M | NetSuite GL ⚠ verify reconciliation |
| Total | $2.80M |
📉 Last 8 Weeks — Actuals (NetSuite)
| Week | In | Out | Net |
|---|---|---|---|
| Jun 22 | $680K | $354K | $327K |
| Jun 29 | $453K | $146K | $307K |
| Jul 06 | $341K | $191K | $150K |
| Jul 13 | $341K | $62K | $279K |
| Jul 20 | $464K | $147K | $316K |
| Jul 27 | $697K | $364K | $333K |
| Aug 03 | $447K | $252K | $195K |
| Aug 10 | $595K | $158K | $437K |
⚙️ Model Assumptions
| Lane | Amount | Basis |
|---|---|---|
| Collections cash-in (live jobs) | $2.39M | ledger schedule +7d pay lag; due-now over 3 wks |
| Job Complete finals | $609K | ready $234K over 3 wks · not-ready $376K over 8 wks |
| Run-rate top-up | $186K/wk | hist. median CustPymt $417K/wk − scheduled avg (new sales, statistical) |
| Other inflows | $33K/wk | 12-wk median non-collection inflows |
| Payroll — monthly run | $116K | ~day 26 · median of observed runs |
| Payroll — weekly drip | $6K/wk | 12-wk median small payroll/overseas |
| Card settlements | $147K/mo | ~day 6 · Brex + AMEX median |
| Vendors / AP | $212K/wk | max(12-wk median residual, Bill.com dues that week) |
| Overdue Bill.com AP | $862K | assumed paid in week 1 |
📄 Largest Open Bills (Bill.com)
| Vendor | Invoice | Due | Due $ |
|---|---|---|---|
| SRS Distribution Inc. | 0048282400-004 | Sep 25 | $83K |
| SRS Distribution Inc. | 0048282400-005 | Sep 25 | $69K |
| ORA ET LABORA LLC | CARMEN ASTUDILLO | Jul 17 | $43K |
| ORA ET LABORA LLC | CARMEN ASTUDILLO | Jul 17 | $43K |
| United NRG LLC | 022 | Aug 03 | $36K |
| Ergosun Holdings LLC | 1077 | Mar 05 | $29K |
| CED GREENTECH | 4560-1115889 | May 27 | $28K |
| CED GREENTECH | 8797-1044566 | Jun 23 | $24K |
| CED GREENTECH | 8797-1044982 | Jul 07 | $23K |
| CED GREENTECH | 4560-1117036 | Jun 29 | $22K |
| CED GREENTECH | 4560-1117030 | Jun 26 | $20K |
| Action People Corp. | NSVB210665 | Aug 05 | $19K |
| Action People Corp. | NSVB216121 | Aug 12 | $19K |
| CED GREENTECH | 4560-1117427 | Jul 08 | $17K |
| CED GREENTECH | 4560-1117424 | Jul 08 | $17K |