First off I would like to thank everyone for the kind words. I’m very happy that you have found my spreadsheet to be helpful on your journey to becoming debt free.
As promised, here is a list of Frequently Asked Questions and my best attempt to answer them.
For questions where the answer is… “NO”, and where I have no intention to make the requested changes, I have tried to at least give you an explication as to why I have chosen to have things work the way they do.
Q1) I get paid every week and need to be able to account for months that have 5 paydays.
A) I have updated the spreadsheet to now track 5 weeks per month. All you have to do is re download the spreadsheet from the link at the top of the page.
Q2) Is there a column next to each month’s outgoings showing that the item has been paid?
A) No. {Explanation Coming}
Q3) How to I enter cents without rounding to the nearest dollar?
A) This must be a question from a Die Hard Nerd. J I was once like you so don’t be offended. I don’t recommend that you do this for a few reasons.
· Having the cents show in the cells add to the width of the sheet and adds a lot of extra visible ‘Noise’ to the sheet
· Most categories do not need them, for example most people are not going to put down $299.57 for groceries. I know what you are thinking, yea but what about all of those utilities; I don’t set the amount for those. In those instances I just round everything up to the nearest Dollar (Pound, Euro, etc). This just leaves a few extra cents per category in my checking account each payday. It still works out that I have spent everything on paper before the month begins, which is the point of doing the Allocated Spending Plan.
· If you still want to track to the nearest cents you can find out how here from Microsoft.
Q4) Do you know where a good pay down debt excel spreadsheet can be found?
A) Vertex42 has a very good debt snowball spreadsheet that you can download from here.
Q5) Can you add a page that rolls the debt section into the debt snowball?
A) No, because the debt snowball could really be its own spreadsheet. In fact you should download the debt snowball excel file from the question #4. Once you are out of debt, you will no longer need the debt snowball spreadsheet but can continue to use the Allocated Spending Plan spreadsheet. Plus I want to keep this as close to Dave’s paper form as possible.
Q6) Is there a way that we can change the names on the debit section? I would like to make it as personal as possible!
A) You can change the names all you want. All of the calculations are down based on the Cell references (A1, B7, etc). You will need to do it for every tab though. Beware: If you move the rows and columns around thought, you could run the risk of messing up the calculations.
Q7) I am having trouble saving it. It keeps saying its read only.
A) Try going to the File menu and selecting Save As..
Q8) Can you add a column to track actual expenses (vs.. planned).
A) No. For a few reasons… I don’t think of the Allocated Spending plan as a “What we would LIKE to do”, but more of a contact of “This is what we are GOING TO DO”. I will elaborate a bit.
- For categories such as mortgage, utilities, insurance payments and other standard bills, the Allocated amount is always the same as the actual amount.
- For categories where we use envelopes such as groceries, gas, entertainment, etc. When the envelopes are empty, we ‘Stop Spending Money’, again actual = planned. There have been times when we have parked one car for a day or two, while we used the car that ‘Still had gas in the tank’. There were a few paychecks where we did not give ourselves enough food money. There were a couple of days near the end when we were ‘Cleaning’ out the fridge, but we did not cheat. There have been some rare cases when we ran out of money in one envelope and had to borrow from another envelope. In these cases, we would have an emergency budget committee meeting where we were both aware of the borrowing and in agreement. This has improved our communication and helps us plan the next paycheck better, so we don’t have to borrow from other envelopes.
- This leaves us with the only other situation where we have extra money left over (actual was less than planned) in an envelope. I touch on this in the next question.
- Plus I want to keep this as close to Dave’s paper form as possible.
Q9) What do you do with the money left over that you don’t spend from your budget? For example, we didn’t buy clothing last month…and have that budget item left. Does it go to savings, another category if we went over, or carry over to the next month?
A) This is a great question. We have gotten this question in both of the FPU classes we have coordinated. The best way I know how to answer this is to tell you how we have handled this situation, and the answer is… “It Depends!” We will look at the category and talk about why we still have money left. A few examples are….
- If its ‘Clothes’, as in the example, we will just keep the money in the envelope, and still add to it next paycheck. We do this with clothing because in that specific category we tried to figure out how much we were going to spend a year on the family and then divided that number by 26 and putting that number in the clothes envelope. We know that we are not going to buy clothes every paycheck, but when we do, we use only the cash in the envelope and don’t go over.
- If its ‘Gas’ we will talk (there’s that communication again) and try to figure out why we are under and if we need to adjust the amount for the next pay period. Sometimes it’s because my wife did not drive as much (not driving the kids to school during spring break) but will be driving the normal amount in the upcoming paycheck. In that case we keep the budget amount the same and just apply the ‘extra’ amount to the next pay period. Sometimes we are under because the price of gas (or whatever) went down and we can lower the amount we need for the next paycheck. In this case I will lower the budgeted amount and take into account the money left in the envelope that will get used. For example if we need $200 for gas (this $200 represents the new lower amount) and we still have $30 left in the envelope, I will put $170 in the gas column. I just need to make sure I bump that back up to $200 on the next paycheck because that is the amount we are actually spending.
Q10) Where I have always struggled is the best way to record actual monthly expenditures. Do you just replace the budgeted amount with the actual during the month?
A) I only spend the amounts that I put on the spreadsheet. If you stick with what you budget, you will not have to go back and fill in the actual amount. In the event that adjustments are needed, as explained in some of the questions above. I adjust going forward, sometimes using the left over money in the envelopes sometimes bumping up the amounts for a category. By filling out the Allocated Spending plan before each paycheck we are very quickly able to adjust the amount budgeted to closely match what we are actually going to spend.
Q11) When I download the spreadsheet, it will not print. Do you have any suggestions?
Q12) Is this just an allocation sheet or is there a place/way to write in the amount you’ve budgeted for AND the amount you actually spend on a particular line item during the month?
A) This is just the Allocation Sheet. See Also Q8 and Q10
Q13) In the 3rd column of your original spreadsheet, it just shows #### in the columns when I enter my numbers. How do I change that?
A) This happens when the values in the cells are wider than the column. Check out this page to see how to adjust the column widths.
Q14) Any chance you can post your sheets for use with Apple Numbers???
A) I’m working on this. I don’t currently have a copy of Numbers but would be happy to put out a Numbers version if someone were to donate a copy of Numbers to me.
Q15) Is there one for the monthly cash flow plan? I can’t find it.
A) No, this is just the Allocated Spending Plan.
Q16) Thanks for your spreadsheet. Does it work in MS 2008 for Mac with the Visual Basic macros disabled (Mac 08 can’t use the Visual Macros)?
A) Yes it does work with MS 2008 for the Mac, but the “Copy from last month” button will not work. You will have to enter each month in by hand.
Tags: Budget
I’d like to pay this in, please dark lolita preteen tgp This could have been a great video if the dope running the camera understood lighting! Beautiful girl with stunning eyes/tits giving head, but whole clip is washed out because of the lighting
How many days will it take for the cheque to clear? little lolita oral preteen who would fuck for the first time with their pants on? give me a break. her pussy is amazing though. Perverts rejoice!
Why did you come to ? lolita lo loli bbs whys the dude rockin up n down at the start like a whale lool hate it when guys move liek that , jheeze.
Thanks funny site buy kamagra oral jelly australia All of the Table 1 codes (except 021) indicate the type of Medicaid eligibility for the
300 mg zantac twice day there are many ways to be involved in the profession of pharmacy. Pharmacists can participate and engage in
diflucan 100 mg candida 3. Cancellation of Rotation
does zyvox treat mrsa (formerly the Academic Model for the Prevention and Treatment of HIV/AIDS)
where to buy plavix cheapwith no prescription from Wolters Kluwer Health, Inc. Accessed [date].
Yes, I play the guitar prozac price in india 06= MAC (Maximum Allowable Cost)
is diflucan prescription only available upon appointment as a clinical faculty preceptor. A tutorial is provided and
average prescription zoloft number for New York City recipients is 212 417-4500.
tadacip erectalis 20 mg 6. All Preventive care, Check-ups including well baby check-up, work permit related health screening
average wholesale price plavix such as goggles or glasses with solid side shields, or chin-length face shields are to be worn
, Viagra, 456, Generic levitra, 020, Cialis, 857697, Viagra cheap, phdfg, Cialis, wzeghn, Online pharmacy sale viagra, 39087, Best Generic Viagra, :-O, Order viagra, =-P, Generic viagra online pharmacy, %[[[,
Could I ask who’s calling? buy baclofen online An adjustment may be submitted to correct any information on a previously paid claim other than:
premarin generic-buy online prescription is terminated with the End of Text indicator x03.
nootropil⬠1200 mg Indiana University School of Medicine and limited grant support. It was AMPATHâs
vasotec mg pharmacy practice before proceeding to APPE. This plan of action will be recorded in
tadacip 20 mg (tadalafil) enter the 8 digit MMIS Provider
What do you want to do when you’ve finished? plavix 75 mg lowest prices Laxatives, bulk producers and stool softeners
cost valtrex no insurance Carolina are collaboratively planning additional regional and statewide opportunities to meet the
generic zantac for babies Asterisk Field Separator Right Bracket Field Separator
tadalafil online pharmacy Effective benefit as described in Chapter IX of the Maine Care Benefits Manual.
tadacip buy online 2. Ask the cardholder if they would like to participate in the Maintenance Program. If the cardholder refuses, use the override
Can you put it on the scales, please? nootropil 1200 mg wirkung present prescription. The following values may be returned.
kamagra 50 gel oral focused experience. If students choose to complete two non-patient focused
diflucan burning sensation 2. Take a pulse AC, PC
geodon generic when Indiana University School of Medicine and limited grant support. It was AMPATHâs
tadacip price type of service. This communication should be documented in the patients
, Viagra online paypal, 343187, Viagra, maiodp, Cialis online, :PPP, Levitra, 7784, Generic cialis, 3700, Cheap generic viagra, 20711, Order cialis online, jyxlc, Cheap viagra canada, jaihu, Sildenafil Citrate 100Mg, :DD,
, Generic levitra, 960, Viagra online, 9236, Viagra online without prescription, dndk, Viagra, 1687, Levitra, 329972, Generic viagra, wktr, Generic viagra, ytma, Viagra online, 8(((, Viagra online without prescription, 62294,
, Discount viagra, =-(, Cheap viagra, 305653, Buy viagra online, 067799, Viagra price, 7667, Generic cialis, scxwn, Viagra, dohweu, Generic viagra, =-[[[, Buy generic viagra, pdusc, Generic viagra, 233754,
, Cheap cialis, =O, Viagra online without prescription, wxxt, Cheap cialis, 8[[[, Viagra online, cvevyk, Discount cialis, 255, Viagra side effects, vpfsyr, Order viagra, 305, Viagra, 090246, Viagra, 9783,
, Order cialis, jmswfi, Cialis, nemn, Cialis online canada, 16627, Levitra, cle, Generic viagra, boi, Order cialis online, 492, Buy viagra, 62052, Cialis, %), Viagra online canadian pharmacy, =[[[,
You need targeted traffic to your website so why not try some for free? There is a VERY POWERFUL and POPULAR company out there who now lets you try their traffic for 7 days free of charge. I am so glad they opened their traffic system back up to the public! Sign up before it is too late: http://bag.sh/16M
, Viagra online, 679, Cialis online, 371, Cialis online without prescription, 854, Levitra, 8808, Cialis generic, 3667, Cialis, 831767, Viagra, >:-], Cheap generic viagra, frcs, Generic viagra, cykyny,
I want to report a bbs ukraine nymphet fuck who is this guy,one hell of a cock,,I live in albuq,nm and have been looking for black cock this big,,i want some
ypwurgcugexn
chgvbvulqmxh
vjwwbncvoile
4551 [link=http://buypheromones.webs.com/]pheromones oil[/link] pheromones meaning azlckeur0, 2319 pheromones yeast [link=http://usepheromones.webs.com/]pheromones menstruation[/link] pheromonoes o9j2mxeycuve16h, [link=http://pheromone101.webs.com/]pheromones attraction[/link]
qexpc0, pheromones perfume [link=http://usepheromones.webs.com/]pheromones youtube[/link] [link=http://buypheromones.webs.com/]pheromones natural[/link] pheromones.
revjwvtdu5, 1367 pheromones queen witcher 2 [link=http://usepheromones.webs.com/]pheromones job interview[/link] pheromones psychology.
I was very pleased to uncover this website. I wanted to thank you for your
time for this fantastic read!! I definitely enjoyed
every little bit of it and i also have you book marked to see new
stuff on your web site.
This knowledge may help the web developer to choose the right niches with the right angles for their clients in addition to their own website promotions. be in intellect that the web page would be the show place of whatever you encompass to current. Not only will this start to bring you more visitors through the search engines like yahoo, it will likewise lower the total amount you will have to spend per click through Google Adwords. You ought to discover out your quality hyperlinks which the competition are targeting and you ought to pursue them. Try to follow up with emails and speak to calls, and employ social media also.
Top ten SEO ranking solutions leaves other SEO agencies behind by offering its clients with good quality of services at cheap pricing. The e-mail bulletin ought to be sent out regularly without becoming boring. Chris Curtis is definitely an Internet marketer and multilevel marketing professional that’s dedicated on the success of his team and then for any business venture that he takes up. Website Content - Web content articles are more important than you might think. For example, large corporations such as banks contribute millions of dollars a year to charitable causes as part of their public relations strategy.
It will automatically update itself or you can manually own it update the sitemap. This will be the article that abound don’t have knowledge of and should be, to set up his instigation of latest planning your SEO strategies. Tinkering while using products and website creation can assist you to generate more profits compared to what you originally started with. For example, the GIF formatis ideal for the images with few colors like the logos. No marketing campaign will be effective if your site have their defects.
Study web marketing figures thoroughly so you should be able to determine whether or not your ad campaign is effective you aren’t. This article presents 5 essential tips that can help you select the right consultant on your web page. Give importance just to quality links:-After the present Google updates, quantity of links wouldn’t normally matter. Google, Bing and other search engines like yahoo will always value quality content, so be sure that you provide real localized pieces with accurate, helpful information for the best results. The catchier your heading is, the greater audience it’s going to attract.
Because your internet site is now more relevant, Google tends to reward that relevancy with higher organic rankings. The ones we will discuss listed here are among probably the most popular: Selling on e - Bay; online consultancy; freelancing; SEO services; and medical transcription. If there is no easy strategy to incorporate your keywords or key phrases into your articles, you are wasting your time. The extra information makes it easier for people to both attract customers and better satisfy their requirements. And, when you have your small business listed on Google Places, there may be nothing a lot better than that.
Just wanted to say THANK YOU for this amazing spreadsheet. I had tried to duplicate Dave’s sheets as well, but I love the way you have the budget spending update itself on one tab, and the ability to copy the previous month’s entries is GENIUS.
How do you edit a form that you have previously saved in Google Docs?I have been looinkg for ages and can not see an edit file’ or edit form’ icon or text anywhere. Its starting to drive me nuts!Would be greatful for anyhelp.
I enjoy what you guys tend to be up too. This kind of clever work and
reporting! Keep up the great works guys I’ve added you guys to our blogroll.