Docs: Monthly Budget Calendar (Excel)

Microsoft Excel Show & Tell
, , , ,
1

image
image1652×1272 233 KB

Overview

The Monthly Budget Calendar is a minimalist spending tracker and monthly budget for Microsoft Excel— there is also a Google Sheets version. :wink:

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.

Because the Monthly Budget Calendar is powered by Tiller Money Feeds, it shows your actual daily transactions. This free template can now be installed in Google Sheets with the Tiller Community Solutions extension.

:mega: Shoutout to @jpfieber for his work porting this template from Sheets to Excel!

Installation

  1. Confirm that you have Excel Tables implemented in your workbook.
  2. Download the workbook containing the Monthly Budget Calendar v1.01 to your local hard drive.
  3. Open the downloaded XLTX file and also the workbook you’d like to install the template into.
  4. In the Monthly Budget Calendar workbook, right click on the Monthly Budget Calendar sheet tab and click “Move or Copy…”.
  5. In the dialog, choose the destination workbook in the “To book” dropdown and check the “Create a copy” checkbox, then click OK.

Additional Support Content

For background and instructions on this template, refer to the documentation on the looks-like, works-like Google Sheets version.

Changelog

  • v1.01 on March 10, 2023: Fixed bug affecting functionality of uncategorized-transaction options— “All Withdrawals” and “Withdrawals :no_entry_sign:Transfers” and added version number
  • v1.00 on March 9, 2023: Initial release

Questions and Feedback

Share your questions and feedback below.

2

The Monthly Budget Calendar is just what I have been looking for. Unfortunately I have not been able to link the worksheet to my Tiller data because the “edit links” button is greyed out and not accessible in the data ribbon. Any suggestions? I have added and linked other worksheets previously, but I am at a loss now.

3

Good question. We shared this one as an XLTX file and, for me, the Edit Links step has not been necessary.

Can you see that the formulas are still pointing to data in the external sheet?

4

The calendar

Screenshot
Screenshot1627×1144 413 KB

is not working as it’s returning errors.

5

I just installed it in a new workbook and it worked for me, @adekunledauda.

6
  • Yes I have Excel Tables
  • Did you 1. “Move or Copy…” then “Create a copy”? YES
  • Did you see this dialog and click “Yes to All”? YES
  • Photo attached.
    Screenshot
    Screenshot952×515 137 KB
7

It’s odd that the active month in the top left corner of the image is returning an error. Can you look into that?

8

What would you like me to look at? The cell formula in R5 is =DATEVALUE(J2 & " 1, " & J1) . Not sure the reason for the error.

9

Do the date settings in J1 and J2 look reasonable? What happens if you temporarily type over the formula (undo after) in R5 with a date like “1/1/2023”?

10

Hi,

I’m facing the same #VALUE! error when I added the template to my worksheet. Need help to resolve this.

Thanks
Jayesh

11

Can you unhide the columns over on the right, @jayesh.sanghani, like I suggested to @adekunledauda, and see if there are any errors on that half of the sheeet?

12

The monthly budget calendar (Excel) is really nice and useful. A nice addition, if possible, would be a matrix which has the months of a year and a user could input their projected monthly net income. Although we can use an average, those paid every 2 weeks will encounter two months a year with greater income and 10 with lower income against a straight annual average orthose being paid 2x per month. Thank you

1 Like
13

Thanks for your suggestions here!