That would be fine with me Dr. Del! Thanks so much! Here is a link to it via "4shared.com"
http://www.4shared.com/file/qLSCzN0L..._Template.html
Just click download and wait. If you don't feel comfortable downloading off of that site, I'm still leaving my email open to you guys but for those who are downloading, here are some basic instructions I've come up with for it:
First column = prior spending (input numbers from previous month)
Second column = proposed budget for the month (project what you are going to spend for the month based on prior records)
Third column = what you actually spent during the month (it's easiest to do this part at the end of the month but I do opt to track throughout the month because I don't want to hold onto a grip of receipts)
THE COLUMNS IN BLUE AUTO-CALCULATE (NO NEED TO INPUT ANY NUMBERS) This auto-calculation depends on the numbers you enter in the 1st-3rd columns. Some of the blue column may not auto populate if you haven't spent anything in that category.
Important Note: when entering numbers, you DO NOT have to put positives or negatives; depending on what category you put it in, the worksheet will figure out whether it is a loss or profit. I.E. the first section of the worksheet "Sales Revenue" is profit from sales (what you earned in snakes this month which will be represented positively), the section right below that one is the "cost" of sales (numbers entered here will always be negative).
Also, you can add or delete rows as you wish; the auto-calculate boxes will adjust accordingly. A tab at the very end of the worksheet is your year end worksheet. I'm still working on making that easy to use by auto-calculating all of the months together but haven't gotten around it it. For now (or should I say, in Dec 2012) you will have to take all the totals of each month and put them in manually. This shouldn't be too time consuming and considering you only have to do it once a year, it's less tedious then a lot of other things.
If you have any more questions don't hesitate to ask.










Reply With Quote