# Budgets History Sheet editing

**URL:** <https://community.tiller.com/t/budgets-history-sheet-editing/692>\
**Category:** Google Sheets\
**Tags:** envelope-budget, how-to, budgeting\
**Created:** [October 11, 2019, 12:18am UTC](https://community.tiller.com/t/budgets-history-sheet-editing/692 "2019-10-11T00:18:47Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![chris1](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/chris1/32/734_2.png) [@chris1](https://community.tiller.com/u/chris1)\
**Post date:** [October 11, 2019, 12:18am UTC](https://community.tiller.com/t/budgets-history-sheet-editing/692/1 "2019-10-11T00:18:47Z")

</div>

I’m relatively new here and trying to find my way after a false start with the Foundation budget I’ve started again with the Tiller Budget. (You guys should come up with more distinctive names - it’s very confusing!) Anyway, I’ve now found my way to the Budgets History Sheet and I’d like to enter my budget for the coming full year by month starting in September. Right now I only have two lines of budget in rows 3 and 4 for September and October. I need rollovers since we often go over on a category in one month and then recover the next month - like buying gift cars on sale for 3 months worth of gas so that eventually it catches up.

With that in mind I’d love to understand the following:

1. Can I add rows to the Budgets History Sheet below row 4 for the rest of the year or will that break something?
2. The columns of all the expenses and Income categories in the Budgets History sheet are seemingly random. Can I re-arrange them without any consequences? It would make pasting my budget from another spreadsheet a whole lot easier?
3. For the Rollover To rows is there a way to automatically make the next month the same as the current month?

Any other tips are appreciated.

Thanks,

Chris

---

<div class="post-metadata">

**Author:** ![heather](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/heather/32/177_2.png) [@heather](https://community.tiller.com/u/heather)\
**Post date:** [October 11, 2019, 11:51am UTC](https://community.tiller.com/t/budgets-history-sheet-editing/692/2 "2019-10-11T11:51:28Z")

</div>

Hi @chris1,

Great questions and we agree on the naming. We’re still in the process of cleaning up/transitioning these tools after some major product updates from the summer.

The guide for the Tiller Budget is here and talks through the way to add future months.

The Rollover To will move from month to month automatically as new months are generated. We just don’t automatically set it for the first period (in your case September) in case you want it to be different in Oct. Whatever is in the Rollover To column on Categories will be used in the current budgeting period so if that doesn’t change, they’ll be exactly the same each month.

I don’t recommend rearranging the columns in that sheet.

> [@Docs: Envelope Budget](https://community.tiller.com/t/tiller-budget-via-tiller-add-on-comprehensive-guide/110#working-with-the-budgets-history-sheet):
>
> What is the Envelope Budget? The Envelope Budget (formerly known as the “Tiller Budget”) is a dynamic spreadsheet budgeting template that allows you to use an envelope or zero sum budgeting style, set and monitor savings goals, and automate many aspects of budgeting. NOTE: This template and it’s functionality do not work with the Tiller Foundation Template. You must start in a new sheet to use these features. There is a newer template for envelope budgeting, the [Savings Budget](https://community.tiller.com/t/add-the-savings-budget-sheet/5165), that does wor…

---

<div class="post-metadata">

**Author:** ![cve](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/cve/32/4388_2.png) [@cve](https://community.tiller.com/u/cve)\
**Post date:** [September 12, 2020, 6:04pm UTC](https://community.tiller.com/t/budgets-history-sheet-editing/692/3 "2020-09-12T18:04:52Z")

</div>

@heather. Hi I can’t seem to figure out how to add a future month to set up my next month’s budget. I’ve followed the instructions of adding another line in Budgets history with the first date of that month as the period and then run the analyze budgets history function. But instead of creating a new line it just deletes the line I created in Budgets history. Any ideas? Thanks! - Colin

---

<div class="post-metadata">

**Author:** ![heather](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/heather/32/177_2.png) [@heather](https://community.tiller.com/u/heather)\
**Post date:** [September 15, 2020, 4:49pm UTC](https://community.tiller.com/t/budgets-history-sheet-editing/692/4 "2020-09-15T16:49:34Z")

</div>

👋 @cve!

Did you also enter the correct period end date and other values from another correctly formatted row?

This video goes over it in the most detail:

[![]( " - YouTube") ](https://www.youtube.com/watch?v=hakX2DMMemk)

---

<div class="post-metadata">

**Author:** ![cve](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/cve/32/4388_2.png) [@cve](https://community.tiller.com/u/cve)\
**Post date:** [September 23, 2020, 7:07pm UTC](https://community.tiller.com/t/budgets-history-sheet-editing/692/5 "2020-09-23T19:07:13Z")

</div>

I was able to figure it out! I’m dumb. I duplicated my budget sheet to test this out as it was suggested and then wondered why the analyze budget history function didn’t work. Got it working though. Thank you!

---

<div class="post-metadata">

**Author:** ![heather](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/heather/32/177_2.png) [@heather](https://community.tiller.com/u/heather)\
**Post date:** [September 24, 2020, 2:13pm UTC](https://community.tiller.com/t/budgets-history-sheet-editing/692/6 "2020-09-24T14:13:20Z")

</div>

Glad to you got it working! Be easier on yourself.
