Whoa! Is it my turn already?? :laugh:
For my learn something new entry, I wanted to share a worksheet that I put together several years ago as a budget tool. When I started at the company I'm at, they put me on a monthly salary which was a huge adjustment for me as I was used to getting a weekly paycheck. A budget was something I never really thought about, however at that point there was no choice but to put one together, so I came up with this.
What I do is put my gross in the Check Total field and everything fills in automatically. There are adjustments that do have to be made based on whether it's a four day or five day week. To do this, I go ahead and copy a sheet over (click on the worksheet tab at the bottom, hold down CTRL, drag it over and release). The new sheet will be used for the following month. Go back to the present month, click on the Weekly Allowance dollar amount and change the 4 to 5 or 5 to 4, however many weeks there are in the month. If only 4, click on the Total Amount Left OA (On Account) dollar amount, go to the top of the sheet, and remove "+T28". At this point, I'll also go ahead and delete the last column as it won't be used. I then put all my monthly bills in the blue section with the total of each bill listed in both Amount and Credit column. The weekly allowance will adjust automatically. For each week, I keep up religiously with every penny spent (gas, food, hair cut, cigars, etc), and try not to go below the balance for that week. Again, each dollar amount entered will automatically adjust the totals.
When moving to the next week, I put "Bal Fwd" in the very top field and then do an equal formula (put = in the right field, click on the Balance dollar amount, and hit enter. I then put zero in the field directly below the Balance dollar amount.
Below is a link to the spreadsheet. It's fairly simple, however has worked for me going on almost five years now (first sheet I have is July 04). Without this, I'd be in some seeeerious trouble!
If any questions, lemme know!
Budget Sheet