The Monday Cash Close is a free 13-week cash board built for firms that run cash for a whole book of clients. Your entire book on one screen, a 13-week forecast for each client, and the one number a QuickBooks report always gets wrong: the cash that cleared the bank but isn't posted yet.
Check your inbox. The Monday Cash Close should arrive in under a minute. If it doesn't, check spam for "TreasuryFlow".
While you wait → see it filled in automaticallyPrefer to grab it directly? Download the Monday Cash Close (.xlsx)
One row per client: current cash, the 13-week low, how much buffer they have over their floor, and whether the bank still disagrees with QuickBooks. The Monday firm view: who's fine, who needs you, who's out of sync.
| Client | Current cash | 13-wk low | Buffer vs floor | Status | Bank ≠ QBO? |
|---|---|---|---|---|---|
| Coastal Build Co | $842,100 | $310,400 | +$160,400 | On track | N/A |
| Lenity Health PC | $418,900 | $204,700 | +$104,700 | On track | N/A |
| Atlas Logistics | $291,500 | $58,200 | +$8,200 | Watch wk 7 | Δ $15,900 |
| Riverside HVAC LLC | $176,300 | −$12,800 | −$62,800 | Below floor | Δ $28,450 |
| Marigold Catering | $94,600 | $21,300 | +$6,300 | Watch wk 5 | Δ $7,200 |
| Brightline Dental | $233,800 | $119,500 | +$69,500 | On track | N/A |
| Book total | $2,057,200 | $701,300 | N/A | 2 need a call | 4 out of sync |
Example clients and numbers. Your real book replaces them in seconds.
QuickBooks runs a day or two behind the bank. So the balance you re-key on Monday is already stale, and a QBO-only report gets the answer wrong. The Client Board tab puts the live bank balance next to the QuickBooks balance and shows you the gap: the deposits and payments that already moved but aren't posted. That gap is the number your client call actually needs.
What each tab is for and the order to use them. No formulas to wire; the math is already built in.
Type the client's name, today's live bank balance, and their QuickBooks balance. The Delta calculates itself. Fill 13 weeks of expected in and out: any week the balance dips below their floor turns red. Then duplicate the tab once per client.
Every client rolls up to one row. You scan it Monday morning, spot the two clients who need a call, and walk into every meeting already knowing the answer.
That's exactly why we built TreasuryFlow. Same board, same Delta, same portfolio view, except it fills itself in from each client's live bank feed and QuickBooks, refreshed every morning. You review the few that need a call and send the rest. $99/mo per company, 90-day free trial, cancel anytime.