BookByte

AI for Accounting

Google Sheets canvas: build a cash flow what-if tool

A client says they’ll pay “next month.” Sales feel slower. A tax payment is due in January. You want to know one thing: will there be enough in the bank?

By: Computatio · Last reviewed 2026-11-05

Quick answer: as of November 5, 2026, Gemini in Google Sheets can turn a sheet into an interactive mini-app called a canvas. Open your cash flow sheet and choose Insert > Create a canvas, then ask for sliders on sales, costs and payment timing. Google lists it for Google AI Pro and Ultra, Workspace Business and Enterprise Standard and Plus, and Google AI Pro for Education, in English, on the web. Start from your reconciled bank balance, and check that the canvas’s base case matches the sheet.

You’re guessing at next month’s bank balance

Your profit and loss shows what happened. It doesn’t show when cash will land or leave. Income can look fine while the account runs thin, because a client pays late or a big bill hits in the same week.

Profit is not cash. A cash flow forecast fills that gap, week by week.

And every “what if” means rebuilding the spreadsheet

What if sales drop 20%? What if the big client pays six weeks late? In a normal sheet, you change cells, copy tabs, and lose track of which version is which. Most owners stop after one try.

What it costs to fly blind

  • Tax dates don’t move. The fourth IRS estimated tax payment for 2026 is due January 15, 2027. California’s fourth payment, 30% of the year’s required amount, is due the same day.
  • Short weeks surprise you. You find out the account is low when a payment bounces, not when you could still plan around it.
  • Bad starting numbers spread. A forecast built on an unreconciled balance is wrong in every week after the first.

Picture this instead

One tab holds 13 weeks of cash in and out, starting from the balance you reconciled. Next to it, a canvas with three sliders. You drag “client pays late” to six weeks and see the lowest week turn yellow. You decide what to delay or chase while there’s still time.

What is Google Sheets canvas?

Google announced Sheets canvas on August 13, 2026. Gemini builds a custom layout, such as a dashboard or a scenario model, on top of one tab of your data. Google calls it read-write: if you have edit access, changes you make in the canvas change the sheet, and changes in the sheet show in the canvas. Google’s help page says access to a canvas is the same as access to the sheet. A Google Workspace post from September 10 lists a financial scenario model, where you adjust key assumptions and see the effect, as one of its examples.

Who gets it: Google AI Pro and Ultra personal plans; Workspace Business and Enterprise Standard and Plus; and Google AI Pro for Education. Google’s help page also says personal accounts may be able to use it up to 3 times a month. It’s English only and not in the Sheets mobile app.

The 13-week method for a Google Sheets canvas cash flow tool

  1. Reconcile first. Reconcile your business bank account through the last statement. That ending balance is your opening cash. Not the bank app’s number today, and not a guess.
  2. Build one tab. Canvas reads one tab, so put everything there: a row of assumptions at the top (weekly sales, weekly costs, sales change %, weeks the big client is late), then 13 rows, one per week, with cash in, cash out and ending balance as formulas. Add fixed items on their dates: rent, loan payments, and the January 15 estimated tax payments. If your forecast is in Excel, use File > Save as Google Sheets first.
  3. Work on a copy. Because the canvas writes to the sheet, make a copy of the file to experiment in. Keep the original as your base case.
  4. Open canvas. Choose Insert > Create a canvas. Google’s help page also lists Tools > Create canvas and the Canvas menu in the bottom bar.
  5. Paste the prompt below, then refine it with follow-up prompts.
Prompt to copy:
Build a cash flow what-if tool from this tab. Show a slider for “Sales change %” (−50 to +20), a slider for “Weekly costs”, and a slider for “Weeks the big client pays late” (0 to 8). The sliders should change only the assumption cells at the top. Do not change any weekly rows or formulas. Show a line chart of ending cash for all 13 weeks, the lowest week and its balance, and color any week below $5,000 yellow and below $0 red. Show the base-case numbers next to the scenario so I can compare.

Don’t put account numbers, client names or anything sensitive in the sheet or the prompt. Use labels like “Client A.” Our guide to keeping financial data safe with AI covers the rest.

Example (made-up data). A one-person agency starts the week of November 9 with $9,200, the reconciled October 31 balance. Base case: $3,800 a week in, $3,300 a week out, rent of $1,800 in weeks 4, 8 and 13, a $6,000 client payment in week 3, and $4,700 of estimated tax in week 10 (the week of January 15).
Base case: lowest week is week 1 at $9,700; week 13 ends at $11,600.
Client pays 6 weeks late: lowest week drops to $9,400 in week 4; week 13 still ends at $11,600.
Late client and sales down 20%: week 8 falls to $3,520 and week 13 ends at $1,720.
What the owner does next: she sends the client a reminder now, moves a planned equipment purchase out of December, and keeps the January tax money in a separate savings account.

How to check the canvas before you trust it

  1. Set every slider to zero change. The canvas’s numbers must equal the sheet’s base case, week by week. Click View data to see the rows behind it.
  2. Tie the opening balance to your last bank reconciliation. If they differ, fix the sheet, not the canvas.
  3. Recalculate one week by hand. Opening cash plus cash in minus cash out should equal the ending balance shown.
  4. Check the sheet after you play. Open the tab and confirm only the assumption cells changed. If a formula was overwritten, undo it or go back to your original.
  5. Each month, compare the forecast to actuals from your profit and loss and bank statement. Adjust the assumptions that were wrong.

What Google Sheets canvas can’t do for your cash flow

Google’s help page says not to rely on Gemini features for financial or other professional advice, so review what it builds. A forecast is a planning tool, not a promise: it’s only as good as the assumptions you type in. It doesn’t replace reconciling, keeping receipts, or making your tax payments on time. Canvas also won’t open if downloading, copying or printing is turned off for the file, and the source data must stay under 1 million cells.

You don’t need formula skills beyond simple addition to start. If the sheet itself is the hard part, see AI for Excel and Google Sheets bookkeeping and our estimated tax guide for the payment amounts.

A forecast is only as good as the books under it. Want those handled?

Short on time? Want books you can forecast from? At Computatio, AI does the first pass and an accountant reviews and reconciles every account each month, so your opening balance is one you can trust. Monthly Books is $500 a month.
Free download: 47 write-offs for the self-employed, a 42-page guide with the IRS rules behind each deduction. Free when you join the Computatio newsletter.

Sources

This guide is general information, not financial, tax or legal advice for your situation. We work hard to get it right, but we can make mistakes, and rules change. Check the official sources above before you act.