Free Excel download · For fractional CFOs & bookkeepers

Rebuilding every client's cash by hand, every Monday morning?

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.

No newsletter. No sales calls. The Excel workbook, in your inbox in under a minute.

On its way.

Check — 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 automatically

Prefer to grab it directly? Download the Monday Cash Close (.xlsx)

The Portfolio tab

Your whole book on one screen.

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.

Example clients and numbers. Your real book replaces them in seconds.

The Delta

The cash that cleared the bank — but isn't in QuickBooks yet.

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.

How it works

Three tabs. Ten minutes a week.

1
Start Here

Read the one-minute setup.

What each tab is for and the order to use them. No formulas to wire — the math is already built in.

2
Client Board

Build one client's 13-week board.

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.

3
Portfolio

See your whole book at a glance.

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.

What's inside

The workbook, in one glance.

  • Portfolio tab — every client on one row, your whole book at a glance
  • Client Board tab — a full 13-week cash board for one client
  • The Delta — live bank balance vs QuickBooks, calculated for you
  • Duplicate-per-client design — one board, copied for each client
  • Cash-floor alert — any week below the client's floor turns red
  • 13 weeks of expected inflows and outflows, with auto-projected balance
  • 13-week read — lowest balance, the week it hits, weeks below floor
  • Notes column per week — for the context behind every number

Love the board? Hate rebuilding it every Monday for every client?

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.