If the actual balance is much different from the prediction, try to figure out why, and you may want to adjust your worksheet to reflect your actual income and expenses for the month. That makes it easier to compare the spreadsheet to Quicken reports.Īfter each month passes, enter your actual balance in the summary section of the worksheet. Make sure that you set up the Quicken categories the same as in your spreadsheet, or vice versa. I recommend using Quicken to keep track of your expenses, or your budget projections will end up being only wild guesses. For example, I like to use cell comments to explain certain budgeted items in more detail (such as the fact that in May, there is Mother's Day and a couple of birthdays to remember). Why Use Excel for your Family or Personal Budget? I use Excel when working with my budget because that it gives me the flexibility to keep track of the information the way I want to.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |