Cash Flow Forecast Spreadsheet

The flexible Cash Flow Forecast spreadsheet forecasts your cash flow into the future, so you can project various income/expense scenarios over time.

About the Cash Flow Forecast Spreadsheet

This sheet looks at the long-term picture. Think years, not months. If you are looking for something that looks at the more immediate future, consider the Projected Balances sheet.

Some of the benefits of using this sheet include:

  • Easy to set up
  • Baselines your cashflow with the current-year budget (other ranges can be used)
  • Outputs both chart and tabular data
  • Provides workspace to manually add life events (e.g. children going to college, retirement, etc) with starting/ending years, starting amounts, and growth rates
  • Life events can be activated/deactivated to run scenarios and quickly see long-term impacts
  • Ability to set growth rates for your core income/expenses and life events

How to install this template

Start your free Tiller trial, set up your Foundation Template, then install this template with the free Tiller Community Solutions add-on for Google Sheets.

Tiller Community Solutions FAQ

Is this template free?

This is a free template created by a member of the Tiller Community. While it's free for anyone to use, it's designed for Google Sheets automated by Tiller. Additionally, it's recommended for use within the Foundation Template.

What is Tiller?

Tiller is the only automated personal finance service for Google Sheets and Excel. Tiller keeps all your daily spending, income, and account balances updated in your spreadsheets, so you can easily see where you stand at a glance and gain powerful insights about your money. Learn more →

Does this template have any dependencies or special requirements?

This template for Google Sheets works best when installed in Tiller's Foundation Template.

Have questions about this template?

Visit the Tiller Community with any questions about this template.

Notable Replies

  1. Avatar for jono jono says:

    The Cash Flow Forecast template was updated on Feb 10, 2020 to fix one of the formulas. If you installed it before then, please update it using the Tiller Community Solutions add-on to version 0.91.

    Jon

  2. Avatar for jono jono says:

    On Feb 22, 2021, the Cash Flow Forecast template was updated to Version 0.92 to fix an issue with multiple category overrides to Life Events that matched an existing category name.

    If you downloaded the sheet prior to that date, please update it using Tiller Money Labs add-on.

    Jon

  3. Avatar for jono jono says:

    A revised version of the Cash Flow Forecast sheet has been uploaded. Version 0.93.

    It works with up to 200 non-hidden, income and expense categories.

    You can get it from the Tiller Community Solutions Add-On. Either Add a Solution or use Manage Solutions to update to Version 0.93.

    Jon

Continue the discussion at community.tillerhq.com

Participants