A four-step framework for CFOs to control AI token costs.

Read Now
Book a Demo

13-week cash flow forecasting

View how to forecast cash week by week, link it to your P&L and balance sheet, and test scenarios.

How 13-week cash flow forecasting works in Drivetrain

Start with real numbers, not a blank sheet. Bring in actuals from your ERP, billing tools and bank statements, then forecast cash week by week and link it to your P&L and balance sheet.

See where your cash stands each week

  • Expand any week to see actuals, plan and variance side by side, so you know where you're on track.
  • Compare ending cash across scenarios in the same report.
13-week cash flow report with one week expanded to show actual, current plan, variance and variance percent for cash in by region

Build your forecast from live data

Bring in actuals from your ERP, such as NetSuite, Sage or QuickBooks, bank statements via Google Sheets or CSV, and billing tools like Stripe.

13-week cash flow model showing beginning cash, cash movements, ending cash and a cash collection assumption with forecast formulas

Forecast cash in from how customers pay

  • Set payment timing by customer, region or segment, for example B2B at 40 days, wholesale at 30 and retail at 60.
  • Run scenarios, such as 75% vs. 95% collections, and see the impact on ending cash.
13-week cash flow model in the High Collections Case scenario with a 95% cash collection assumption for each region

Link cash to your P&L and balance sheet

Build an indirect cash flow inside a three-statement model, so net income comes from the P&L and cash changes roll up to the balance sheet.

Indirect cash flow model with operating activities expanded to show adjustments to profit and loss and net income

Drill into your cash numbers

  • Drill into any line, such as cash in by customer, down to individual transactions.
  • Switch weekly numbers to monthly, quarterly or yearly views in one click.
13-week cash flow report with KPI cards and a weekly table showing current plan, variance and actuals

Collect forecasts from your team

  • Ask colleagues for inputs, such as cash in by country or customer, without giving them access to the model.
  • They get notified in Slack, Teams or email, enter their numbers in the report and the forecast updates for everyone.
Create task panel titled "Input high case numbers for APAC" with an assignee, due date, report and approval workflow

How Drivetrain simplifies 13-week cash flow forecasting

  • Tie your cash flow to your P&L and balance sheet in one model.

  • Answer leadership's cash and runway questions from an up-to-date forecast.

  • See cash week by week, with actuals and forecast side by side.

FAQs

Can I build a 13-week cash flow forecast in Drivetrain?

Yes. You forecast cash week by week across 13 weeks, and each week's ending cash becomes the next week's beginning cash.

Does Drivetrain support both direct and indirect cash flow?

Yes. You can build a direct forecast from cash in and cash out, and an indirect cash flow split into operating, investing and financing activities.

Is the cash flow forecast linked to my P&L and balance sheet?

The indirect cash flow is. It's built inside a three-statement model, so net income comes from the P&L and cash changes roll up to the balance sheet.

Where does the cash data come from?

Actuals come from your ERP, such as NetSuite, Sage or QuickBooks, from bank statements imported through Google Sheets or CSV, and from billing tools like Stripe. Once your ERP and billing tools are connected, new actuals flow in automatically.

Explore more micro demos

Browse all micro demos
03:03ReportingMulti-entity consolidation: Roll up every entity, ERP, and currency04:57PlanningCohort modeling: Spot retention and growth trends instantly04:27PlanningHeadcount planning: Plan, forecast, and reconcile headcount

See Drivetrain in action

Fewer spreadsheets, faster planning, better decisions.

Book a Demo