Envelope Sheet with Funding Template version 1.7

All, I have updated my Envelopes Sheet to version 1.7.

This version has a few more featureas and capabilites, including the ability to fund Envelopes in future months, additional views for Savings Targets and more. I have also updated the envelope tracker sheet. lastly, I have updated the Getting Started Doc to get you started, highlight all of the new features as well as a change log to see what has changed.

let me know your thoughts. - Rich

All, here is a link that will allow you to copy the whole Envelope sheet to your Google Drive.

https://docs.google.com/spreadsheets/d/1HdYN6iGC4eytkIUR45EtA9tfngNrhKYCL_ULsl7m9-E/copy

Hi there! I’m excited to use this. I did try to copy into my spreadsheet but it wouldn’t give me that option. I clicked on Make a Copy but it will only let me download it into my google sheets. I’m supposed to copy this envelope sheet(s) into my existing Tiller Foundation spreadsheet right? The instructions don’t really spell that out well. But again I don’t have an option to copy into a spreadsheet, only into a folder on Gdrive.

Once you open the templae you should be able to just click on the specific tab you want to copy and click Copy To than click existing sheet. Find your tiller sheet and copy to there. Be sure to copy both the envelope and the funding transactions sheets. You will also need to add a fe columns to your categories sheet.

image

Ok thank you! I didn’t know I had to open it up and choose it from the tabs. Thanks

Hi Rich. I just sent you a request to open your sheet to edit. Now I found this which seems perfect. Thanks for sharing. Henry

Glad you got access. Let me know if you have any questions.

Hi richl,
Just wanted to let you know how much I like your Envelope Sheet Template. It’s perfect for me. I’ve added a lot of specialized-to-me functionality to it, especially modifying it to handle credit cards and tracking long term savings for yearly bills. (I didn’t make any changes to the Envelope spreadsheet. It’s all additional sheets using data from the Envelopes sheet).
I do have a question, though. I’d like to reduce the size of the Funding Transactions sheet. (delete a lot of old records). Can you tell me how this best might be done? Thanks!
Jim

1 Like

Hey JIm, I am glad you like the current envelopes sheet. The way the current sheet is built, it needs all funding transactions and actual transactions to determine the envelope balance. But it is something I am looking to solve in an upcoming release. That being said, I can’t imagine you would have a ton of funding transactions. Are you seeing performance impact?

On a side note, I am working on version 2.0 of the envelope sheet that has a bunch of new capabilities and options. Take a look at the screenshot. I am testing it right now and hope to release in the next few weeks. Unfortunately, archiving transactions isn’t on this release, but it will be.

2 Likes

I’m new to using Tiller. I setup the foundation sheet with my custom categories and groups and transactions has been categorized. I copied the envelope and funding transaction sheets to my tiller foundation sheet using “copy to an existing sheet”. I’m having some trouble with this. I’m trying to budget for this month (July).

  1. The script is not present when I go to tools – script editor
  2. When I manually create an Initial balance in the transaction sheet, the envelop sheet doesn’t reflect it. I get the message “All transactions have been categorized this period”.

Hi Rich,
Sorry I took so long to reply! It’s been a busy summer in spite of the pandemic. I only have around 700 funding transactions, and it’s not impacting anything. Since the actual transactions and funding transactions are tied together, it would be a challenging task to archive the funding transactions without archiving the real transactions! I can’t wait to see how you do it. It’s way too complicated for me at this point. I like your new beta updates to the envelope sheet - especially the previous month activity. That would be useful to me.
Jim

This looks great! Very excited for this! :smile:

I saw you took away this post. If you still need help let me know.

Rich

Hi Rich, thank you so much for your follow up. I am still very much lost, but don’t even know if I know what I don’t know :sweat_smile: I withdrew my comment because while I figured out the copy portion, when I go to the Tiller Foundation, I cannot run the script, and the categories are all REF! I deleted my initial Tiller Foundation, and started it from Scratch once I figured out the copy part because I thought that would be better to start from a clean slate.

I have your guide side by side with what I am working on so I can follow it to a T. Is there any further guidance anyone has come up with ? Maybe a version for beginner, beginners?

Are you connecting it to your existing foundation sheet ( transactions, categories, balance) or are you starting fresh with the template I posted?

Hi Rich! Sorry, one of those things I had to put down and revisit later because I had been staring at it too long. I was trying to add it to the existing foundation sheet, because the instructions said it had to be used with that? But I think I’d prefer to start fresh?

agreed if you are doign a fresh start then it shoud be really east to get started. With the copied template, you just need to install the tiller add-on. If you want, you can share the template with me and I can connect and make sure it is working correctly before you start. YOu just need to share with my email - richlscott@gmail.com

also, I am about to release a new version ( once I update the documentation) So you may want to use this link instead to get he version 2.0

Envelopes with Templates 2.0 - Make a copy

1 Like

Hey all, I have launched the 2.0 version. you can view the post here.

Hello,
I grabbed a copy of your version 2 sheet. Wow! The improvements are excellent! Since any of the modifications I’ve made for my own use are within their own spreadsheets, it was fairly easy to add them all back in to the new version 2 sheet. The main addition I add is functionality to have one year or two year envelope goals. It’s set up to tell me what month the money will all be there and also if I don’t have enough money in the envelope. It dovetails with your work really well. All of the parameters to set up the envelopes are in the Categories sheet. Here’s a screen shot of it.


Thanks for your hard work. Know that it is appreciated!
Jim