Monthly Budget Calendar

Set your monthly spending target, see your daily and cumulative spending, and know what's available until the end of the month.

Functions:Budgeting
From:Edward Shepard

About the Monthly Budget Calendar

The Monthly Budget Calendar is a minimalist spending tracker and monthly budget for Google Sheets. Everything is streamlined in a simple monthly calendar view. Set your monthly spending target, track your daily and cumulative spending, and see how much you have left before the end of the month – or before you hit your spending target.

See the Microsoft Excel version of the Monthly Budget Calendar here

Simple by design

Choose the year.
Choose the month.
Input your Monthly Budget spending target.
Choose how you want to gather your daily expenses.
Watch the magic happen.

Regarding the fourth step, there are four different ways to gather expenses:

“All Withdrawals” will total each day’s negative transactions. You will not need to categorize any data to use this template immediately, but transactions like transfers may make your daily totals inaccurate.
“Withdrawals ≠ Transfers” will total each day’s negative transactions but will ignore any transactions categorized as a Transfer category type. If you haven’t categorized many transactions, but want to exclude a few transactions, just categorize those and let the rollup do its magic.
“Categorized Expenses” totals only transactions categorized to an expense category while ignoring income, transfers, and uncategorized transactions (including positive refunds categorized in expense categories).
“Categorized Group Expenses” allows you to select an expense-category group and will total transactions categorized to that group (including positive refunds categorized in expense categories).

Each calendar day shows:

The date and day of the week
Your spending actuals based on the filter selected above
Cumulative spending for the month
How much is left before you hit your selected spending target
A sparkline visualizing your spending increasing to your target

If you exceed your monthly spending target, your sparkline turns red, and your amount turns negative.

Installation

The Monthly Budget Calendar is now available for free in the Tiller Community Solutions add-on for Google Sheets.

Questions and Feedback

Share your questions and feedback in this thread in the Tiller Community

Powered by Tiller

This template is designed for spreadsheets powered by Tiller, the only personal finance service based on Google Sheets and Microsoft Excel.

The best way to use this template is by trying Tiller free for a month. Your card isn't charged until the end of your trial, and you can easily cancel anytime. Any data and templates you download during your trial are yours to keep.

Try Tiller Free

See the FAQ to download this template without a free Tiller trial.

FAQ

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 spreadsheets automated by Tiller. Additionally, it’s recommended for use within the Foundation Template.

Tiller is the only automated personal finance service for Google Sheets and Microsoft Excel. Tiller automatically imports your daily spending, income, and balances in your spreadsheets, so you can see all your finances in one place and manage your money, your way. Learn more →

Unless otherwise noted above, this free template is installed with the Tiller Community Solutions add-on for Google Sheets. It's an easy way to browse and install dozens of free, prebuilt sheets for tracking budgets, debt payoff goals, net worth, savings, and more, all from the Google Sheets sidebar.

This template for Excel works best when installed in Tiller’s Foundation Template.

Visit the Tiller Community with any questions about this template.