Google Sheets

Projected Balances Sheet

See an estimate of your daily projected balances based on fixed recurring monthly and yearly income and expenses.

About the Projected Balances Sheet

Curious what the balance of your bank accounts might be on any given day of the month? We’ve built a simple sheet to give you an estimate. Here we share the steps to get this Projected Balances Google Sheet up and running in your Tiller spreadsheets.

The Projected Balance sheet is somewhat manually driven. It’s not dynamically pulling data from your automated balances or transactions and it doesn’t factor in your existing budget amounts.

If you copy it into a Tiller spreadsheet it will pull in your custom categories from your Categories sheet if you have one, but that is the only linked data from other sheets in your Tiller Money spreadsheet.

It’s meant to give you an estimate of your daily projected balance based on fixed recurring monthly and yearly income and expenses.

It’s simply a tool to help guide you, but be aware that other discretionary variable expenses or surprise income throughout the month that aren’t accounted for in this sheet will affect your daily projected balance.

Tiller Community Solutions FAQ

Is this template free?

This is a free template built 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 automatically tracks your daily spending, income, and balances in your spreadsheets, so you can see all your finances in one place with full control of how you manage your money. Learn more →

What is the Tiller Community Solutions Add-on?

The Tiller Community Solutions add-on is an easy way to install dozens of free, prebuilt sheets for tracking your budgets, debt payoff goals, net worth, savings, and more. It also includes several helpful spreadsheet utilities and CSV importers.

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.

Tiller Community Solutions

Browse free budgeting and personal finance templates made by the Tiller Community for spreadsheets powered by Tiller Money Feeds