Yes, I said liberating – I believe that budgeting should be fun and if done properly, it really makes your life a whole lot more peaceful.This is my favorite worksheet I have found, but it isn’t really printable.
I found that while I traditionally had been good about paying my bills on time, I was occasionally late on payments – and it wasn’t because I didn’t have the money, but because I didn’t have a good system in place to pay the bills.
So I created a worksheet that I still use 2 times each month that allows me to schedule and pay the bills on time!
I have been noticing more people interested in budgeting – which gets me excited!
If you have been around here for any length of time you know that I was converted to budgeting and have been thrilled at how liberating it has been.
Click the “Left Column" option if categories are listed down the left side of the spreadsheet.
To merge by position and not category, leave the “Top Row” and Left Column” check boxes empty. Click the first cell in the first spreadsheet to be merged, and then drag the cursor over all cells to merge.
After all references from all spreadsheets are listed in the Consolidate Data wizard, click “OK.” The data from the selected spreadsheets is merged into the master sheet.
Be sure to save the master sheet once all data is consolidated.
You can also click another function to perform a calculation on the data as the sheets are merged. Click the “Browse” button and navigate to the workbook containing the first spreadsheet to merge -- this is necessary only if the spreadsheet is in a different workbook.