The Scenario
Your startup's board deck is due in 10 days. The lead investor wants a 12-month cash flow analysis — operating, investing, and financing broken out — in the financial model workbook. You've been building runway projections there for months. The actuals need to come from QuickBooks.
Last time you assembled this, you exported each month as a separate cash flow report from QuickBooks, opened 12 Excel files, lined up the accounts column by column, and spent two evenings reconciling the fact that QuickBooks renamed an account in month 9 so the rows didn't align.
The bad version:
- Export 12 separate monthly cash flow reports from QuickBooks to Excel — one file per month
- Open each file, copy the operating activities section, paste it into the model workbook in the correct month column, repeat for investing and financing
- On month 7, notice QuickBooks changed an account name mid-year — all the rows are offset by one from that point forward — manually realign
The runway model is the investor's primary ask. The data assembly is getting in the way of the analysis.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook. It connects to QuickBooks and pulls the full 12-month cash flow report into your workbook in one pass — structured by activity type, no month-by-month loop required.
Fetch the QuickBooks cash flow report for the last 12 months and write each activity category, line item, and amount into columns A, B, and C of this sheet
What You Get
- Column A: activity category (Operating, Investing, Financing)
- Column B: line item name (e.g., "Net Income," "Depreciation," "Loan Proceeds")
- Column C: amount for the period as a numeric value
- Sections in standard cash flow order — operating, investing, financing
What If the Data Is Not Quite Ready
You need FY2024 actuals rather than the last 12 rolling months
Pull the QuickBooks cash flow statement for FY2024 and paste the operating, investing, and financing sections with all line items and amounts into this workbook
The model needs each month as its own column rather than one aggregate total
Fetch the QuickBooks cash flow report month by month for January through December 2024 — activity category in A, line item in B, then one column per month (C through N) with each month's amount
The investor wants to see what percentage of operating cash flow each line item represents
Pull the QuickBooks cash flow for the last 12 months into columns A through C, then add a formula in D for each row that calculates the line item's share of total operating cash outflow
You want the actuals and a runway formula using current cash balance in one prompt
Fetch the QuickBooks cash flow for the last 12 months into columns A through C, then in cell E1 write a formula that divides the cash balance in H1 by the average monthly net operating outflow from column C and labels the result Months of Runway
Try It
Get the 7-day free trial of SheetXAI and open the board model workbook — then ask it to pull the 12-month cash flow actuals before you start the runway section. See also Pull a QuickBooks Balance Sheet Into an Excel Workbook or the QuickBooks integration overview.