How to Forecast Cash When Your History Is Already in QuickBooks

Cash forecasting is projecting how much money will come in and go out over a future period, so you know whether you can cover payroll, debt service, and bills before the shortfall arrives. Flying Ledger’s cash forecasting will do this by reading your actual customer and vendor payment history out of QuickBooks and projecting receipts and payments forward — not from a spreadsheet you retype every month, but from the numbers already in your books.

This is a feature Flying Ledger is building. It’s not open to external users yet. What follows is how it’s designed to work and why we’re building it the way we are.

What is cash forecasting?

Cash forecasting is the projection of future cash receipts and cash payments so you can see your bank balance before it happens. It answers one question a P&L can’t: on any given week, will there be enough cash in the account to meet what’s due?

The distinction matters. Your income statement can show a profit while your bank account is empty, because revenue books when it’s earned and cash moves when customers actually pay. A forecast bridges that gap. It takes what you’re owed and what you owe, applies how quickly money actually moves, and lands on a projected balance.

How does Flying Ledger build the forecast?

Flying Ledger cash forecasting projects receipts and payments from your customer and vendor payment history — the record of when people actually paid you and when you actually paid them. Instead of asking you to guess collection timing, it learns the pattern from what already happened in QuickBooks.

It reads live bank balances as the starting point, and you can override that balance when you need to — for a deposit that hasn’t cleared, or a transfer the sync hasn’t caught. The projection then runs at the account, vendor, customer, and class level, so you’re not stuck with a single top-line number. You can see which customer is driving expected receipts, which vendor is driving payments, and which class code (location, department, or entity) the cash is flowing through.

Why forecast at the vendor and customer level?

Forecasting at the vendor and customer level is what makes the number actionable instead of academic. A portfolio-level figure tells you there’s a problem; a vendor-and-customer-level view tells you which lever to pull.

If the projection shows a tight week, you want to know whether it’s one slow-paying customer, a large vendor payment landing early, or a class code that’s structurally cash-negative. Because the forecast is built from payment history at those levels, you can trace the projection back to the accounts driving it and decide what to do — chase a receivable, time a payment, or move cash between entities.

Does it work across multiple entities?

Yes. Cash forecasting reports at both the company and organization level, so you can see one entity’s projected cash or the whole portfolio’s at once. That matters if you run several businesses on QuickBooks, because cash rarely sits evenly — one entity is flush while another is short, and the portfolio view is where you spot the transfer you need to make.

This fits how the rest of the platform already works. Flying Ledger connects QuickBooks — and, for restaurants and event venues, Toast and Tripleseat — per entity and keeps that data synced. Treasury shows real bank and credit-card balances with a health score and alerts. Cash forecasting takes those same live balances and projects them forward.

Why does this belong in the same tool as the books?

A cash forecast belongs next to the ledger because the moment it lives in a separate spreadsheet, it goes stale. The value of a forecast is that it reflects what’s actually happening — new invoices, new bills, payments that just cleared — and a standalone model can’t do that without someone rekeying it.

Building the forecast on live QuickBooks data means the assumptions come from your own history, not an industry benchmark. If you want to interrogate a number, “Ask Fly” answers financial questions using the platform’s live numbers rather than a guess. The forecast, the drill-down, and the answer all come from the same source of truth.

Who gets the most out of it?

Any business on QuickBooks benefits from a cash forecast built on its own payment history; businesses running multiple entities get the most, because reconciling cash timing across companies by hand is where the work — and the surprises — pile up. A standalone business still gets a live, self-updating view of the weeks ahead.

Cash forecasting is one of the FP&A capabilities that QuickBooks alone doesn’t give you. If you’ve been maintaining the forecast in a spreadsheet, the goal here is simple: let the books you already keep do the projecting.