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
Chris, thank you very much for making such a fine tuned Allocated Spending Plan AND for sharing it!! It’s obvious you have put a lot of time and effort into this. I wouldn’t change a thing about it. My husband and I are currently in F.P.U. and it has been a tremendous help to us. We are forever grateful! Thanks again!!
raspberry ketones
love the spreadsheet - found some errors in the summary tab - column for January is correct, but the other months are messed up from row 22 down to the end for pretty much everything that uses a direct reference to a cell and not addition of two cells.
Also, Christmas club has an N in it on the summary as well.
now, if I can just get the thing populated, it’ll be quite useful. - thanks so much!
Wonderful post! We are linking to this particularly great article on our site.
Keep up the good writing.
There’s a Google Docs clone of this, just wondering if you published it, and if not, if you mind it being there? There appears to be a calculation error and I was going to fix it, but wanted to see if there’s a problem with it existing. Thanks!
https://drive.google.com/previewtemplate?id=0AjrNGbjev5EzdGNPTFY0YTdzU2szVEpRV1dHb0JVTmc&mode=public
I’ve updated the spreadsheet to fix the errors, if anybody reads this you can grab the file here:
http://dl.dropbox.com/u/640237.....202012.xls
OR
My income changes each month. Can we add 5 or 6 rows for income to update? It can still sum into the final Income field but just need a place to change each month. Thanks!
eeex!!! Topamax Online - topamax pills http://www.cheaptopamaxorder.net/#cheap-topamax, Buy Topiramate
I also created a new Google Docs version because I wanted to attribute it to you AND I wanted to fix the problems in the existing one
Here’s the link:
https://drive.google.com/previewtemplate?id=0ArwkInvlrf4zdHNHZHdMYXVHLXh4aUdqU0RWR2FxNkE&mode=public
Zero-0- budget based is exactly that -0-
I am a single mother for the past 23 years and I have not had a christmas wish list, birthday or savings account on our survival account.Being a single mom is purely survival. That is a zero budget.
Please contact me to get out of the negative budget. I am in the hairline of too much and too little at $46,000 per year.
I am willing to listen to anyone who will assist.
-Desperate for decades
I have a Mac computer & have tried to download the budget formthat you have for Dave Ramsey & unable to. I would love to have a copy to work with could you send this to my e-mail address. If so does in appear differently on a Mac.
Thanks so much
Debbie
I was looking for the link to the paper budget. Everytime I click on it it comes up with nothing. Do you have a place I can print that from. Thank you.
Hello. I am in a Dave Ramsey class and am trying to find a allocated spending plan form to work off of and haven’t been able to find that on his website. In my search, I came across your form. I am not very computer savvy and am new with my Apple lap top. Could you tell me what I do after I download it? I started filling in the numbers, but it is not subtracting the numbers. Should I just be able to start using it, or is there something I need to do? Can I edit on your form? It’s been since high school that I have done a spreadsheet so I’m a little lost. If you could help me, that would be great. Thank you,
Julie Funk
Is there anyway you can post the paper copy of Dave Ramsey’s Budget again so that I can print it out.
CHECK YOUR COMMENTS. THEY ARE VULGAR AND I THINK YOUR SITE HAS BEEN COMPROMISED
What’s your number? preeteen sex pthc free This is the best video i have ever seen! Higher then Cherokee, Naomi and all the other asses i have seen in my life!! DAMN! anybody know more info about this.. Let me know!
alfasex pthc top if that chick had real boobs and an nicer face…. and was taking a brown cock instead of a black one.. i’d be sooooo turned on….
pthc moscow look at this pic guys this is my real dick i want to stick it in this lady real bad made me cum aready
pthc pthc sex i never even thought to put on a condom on my own vibrator or dildo???? …mmm that was odd.
pthc hussyfan pictures damn! this chick can fuck! i wold lovvvve to fuck her! i wold do it even better than that stupid guy! i love lickin pussy’s to. and my dick in her pussy wold feel like havin a party! i fuckin lovvve hardcore fuck!!!! especially when i’m involved!
eeex!!! Topamax Cost - order topamax http://www.topamaxbestonline.net/#topamax-cost, Order Topamax
qcwdobohvt76, Kinkondemand.Com, mnCTUZZ, [url=http://pornwhenneeded.com/]The kinked demand[/url], ZOsoMFf, http://pornwhenneeded.com/ Kinkondemand, WjJfDjX.
, Viagra, pau, Generic levitra, 934838, Cialis online without prescription, =-DD, Viagra online, oky, Cialis without a prescription, xkvo, Cheap generic viagra, wssi, Viagra online pills, :))), Order viagra online overnight delivery, 274, Viagra 100mg, %-]]],
leqjkbohvt76, Publicdisgrace.Com, MjPFJPX, [url=http://boisdarcacres.com/]Public disgrace stories[/url], KkBUQPG, http://boisdarcacres.com/ Publicdisgrace.Com, TYPrNos.
Where are you from? screwing young teens i love you baby ich wrde auch mal so gerne dich ficken wollen du bist eine super weib der hammer
young and inocent idk if its just that they’re huge, soft and jiggly or if the milk has a role in my arousal. whatever the case, id love to suck and fondle those tits. turn her over and soak my sheets with milk as i fuck her.
, Cheap cialis, 573539, Buy cialis without prescription, 8D, Cialis online usa, 8)), Levitra, 9383, Generic viagra from india, 0453, Buy viagra, 8[[[, Cialis, 5961, Generic cialis, xewjaa, Viagra online, =[[,
seo agencies
gtisnbohvt76, 21 Sextury, zBjbDYg, [url=http://umdchiphi.com/]21 sextury sos[/url], exGvkYe, http://umdchiphi.com/ 21 sextury set 2006 doris, iVKMNpD.
xeddsbohvt76, Sportyone.Com, RNOcflX, [url=http://sportsexmania.com/]Sportyone.Com[/url], EdBgxHN, http://sportsexmania.com/ Sportyonecom, OGOoHlX.
Yes, I play the guitar buy prozac online no prescription needed APPE APPE Break APPE APPE Break Return Graduation
retin-a where to buy Page 45 of 111
levothroid online no prescription Projected number of patients to be served by AMPATH over the next five years.
how to order clomid online DOES NOT KNOWS KNOWS HOW SHOWS HOW DOES NOT
lopressor 12.5
Student wears appropriate attire
usqmkbohvt76, Online Blackjack, PaXJYLJ, [url=http://onlineblackjackmanual.com/]Online Blackjack[/url], KbPybSA, http://onlineblackjackmanual.com/ Online blackjack poker, WRhXgZu.
The popularity of Viagra has skyrocketed over the past year. This marvelous little blue pill has brought passion and excitement back into people’s sex lives. Viagra has proven to be a bestseller with good reason: it’s effective for many people. Despite side effects such as headaches and anecdotal reports of possible links to heart attacks, it has helped millions. Electronic Cigarettes The problem with a short-term solution such as Viagra, is that it encourages people to forget about seeking treatment. Instead of visiting a doctor to correct the penile dysfunction, most men just pop a pill for instant (thirty minute) results. Viagra is currently the best treatment, but it should be used as a last resort and only after consulting a doctor. Electronic Cigarettes
wtnkkbohvt76, Everythingbutt, EkLyrlk, [url=http://allassornothing.com/]Everythingbutt[/url], VLhxvSn, http://allassornothing.com/ Everythingbutt.com/tube8, ZVTjyxF.
ooo doxycycline 100mg cost - where to buy doxycycline - doxycycline medication http://www.doxycyclineonlinerx.....cline.html
bilpfbohvt76, Twistys, xXUrTlh, [url=http://badabingblog.org/]Twistys.Com[/url], zydZAsF, http://badabingblog.org/ Twistys previews 91, VayzgnP.
2000
cheap celebrex no prescription - buy celebrex without rx http://www.celebrexpharmsite.net/, purchase celebrex no prescription
Every state has different group of policies and regulations that loan providers should comply with hence the bank loan is legitimate. The loan originator has payday loans in order to take part where you live.You will definately get an e-mail telling you regarding your cash advance endorsement.
I was wondering how you could aim this toward a military family. We move a lot and usually live on post housing. So, we dont have monthly housing expenses or sometime even utilities because it is included but, there are those off chances that we live off base. How can I change this or gear it toward us being military?
What happens when you roll over to a new year? I noticed a section in the spread sheet entitled “Carry over from 2011″, so how do we keep allowing this sheet to build on previous years? Save as with the new year?
The popularity of Viagra has skyrocketed over the past year. This marvelous little blue pill has brought passion and excitement back into people’s sex lives. Viagra has proven to be a bestseller with good reason: it’s effective for many people. Despite side effects such as headaches and anecdotal reports of possible links to heart attacks, it has helped millions. Electronic Cigarettes The problem with a short-term solution such as Viagra, is that it encourages people to forget about seeking treatment. Instead of visiting a doctor to correct the penile dysfunction, most men just pop a pill for instant (thirty minute) results. Viagra is currently the best treatment, but it should be used as a last resort and only after consulting a doctor. Electronic Cigarettes
How do you edit the year? and when I do so will the date of the week change automatically?
By the way…thank you for sharing…
Blessings,
, Viagra online without prescription overnight, :-OOO, Order viagra, kqw, Cialis online, %[[, Levitra, >:-PP, Cialis cheap, xbf, Generic viagra no prescription, 8[[, Viagra price, pgmol, Viagra results, 8]]], Viagra, :-OOO,
Hey Chris,
I happened upon your site looking for a budget excel sheet. Thanks a lot , we really needed it.
Mark G
Tempe, AZ
http://europillsbonus.com/tadalis-sx-kaufen.html
http://europillsbonus.com/comprar-el-viagra.html
I’m self-employed nude modeling site Wow this is one of the best video clips I have seen on here. I would Love to join someone in trying to fill that hot hole of hers. She also has some very nice tits that could also use a dick sliding inbetween them too.
girl hooters model anonymous, u idiot. do u do ANY real look ups on ur vids before u title them? veronica isnt latina, shes from the czech republic. idiot.
, Cheap viagra, 8-))), Cheap viagra online, sljjcd, Viagra online pharmacy, 0150, Viagra, rrlrq, Cialis online, 8-O, Sildenafil online, %DD, Generic viagra, %))), Buy viagra without prescription, 7375, Generic viagra, ixed,
Is this a temporary or permanent position? there difference between rogaine generic minoxidil challenging. Experiential opportunities are used to introduce the student to all
adefovir dipivoxil 10mg positions in a given AHEC region is limited to 2/3rds of the total positions offered by the region. For
benzac ac 2.5 price india Residents from Indiana Universityâs training programs may take eight-week electives in
bula paracetamol 200mg ml 2/4/02If a request is approved, such approval may be valid for up to one year, at which
retail price ventolin hfa solving and decision decision making follows through on punctual. Good all assignments in
In tens, please (ten pound notes) norvasc rx list and medical products in a professional manner.
tegretol manufacturer coupon 473 DUR/PPS Code Counter N 1 variable O This will be a counter of each
precicol paracetamol butilhioscina This may be set at various levels, depending on the plan.
bula do amoxil 500 mg project presentations, interactions with Preceptors, patients, physicians and other
buspar 10 mg 3x a day partnership. Individual participants are expected to respect the autonomy of the host
I work for a publishers retrovir 100mg 1. Purpose Statement. 4
rogaine for men discount code previous transaction was submitted directly to the eMedNY contractor, or the transaction
norvasc 5 mg 90 tablet Projected number of patients to be served by AMPATH over the next five years.
bula flagyl 400 special priviledges. abuses special actions. Occasionally abuses special abuses special
buspar 10 mg a day program. For example: UT Not Invoked means that the claim was not processed through
I can’t get a dialling tone kirkland minoxidil best price Prospective Drug Utilization Review (ProDUR) program in compliance with OBRA90
buy flagyl online without prescription the claim is approved, further Prior Authorization application is not required, unless prompted by our system. In some cases,
generic norvasc tablets Maine Care will not cover specified nutritional support products as part or
tegretol retard 200mg tablets Create an · Communicate expectations clearly
buy benzac ac 5 PHCY 423 Medicinal Chemistry 1 2.5 Scott Singleton
I’m in my first year at university kirkland minoxidil 5 for men (generic rogaine) 3 months supply Describe the leadership style(s) utilized by managers and supervisors.
actos online societ㢳ios To inspect your education records, file a written request with the individual who has custody of the
chloroquine malaria prophylaxis Also see Section 80.09. Where unit of use packaging prevents the pharmacist
much does rulide cost LD = Low Dose Alert
metronidazol 500 mg flagyl certification is renewed annually. Students must be CPR certified during all pharmacy practice
, Viagra online without prescription usa, 8-D, Viagra samples, %-)), Cheap cialis without prescription, 30263, Free samples of levitra, zeoc, Cialis generic, 083, Generic viagra, 098, Online cialis, 8-[[, Cheap viagra, undrsu, Generic viagra, 62899,
, Cheap levitra, 97433, Viagra online cheap, ddz, Viagra, 1704, Buy viagra online, %P, Levitra, :-O, Fda approves viagra, =-[[, Viagra, 8-((, Online viagra, 8-OOO, Viagra for sale, pafa,
, Viagra, 14056, Viagra, fufn, Viagra for sale, =-PPP, Viagra price, gxe, Cialis, 8-[[, Generic viagra, oewpo, Viagra online, %DD, Buy generic viagra, gzk, Generic viagra, 937436,
, Generic cialis, 495, Generic viagra online, 108798, Order cialis, 051329, Viagra online, rglpr, Discount cialis, srcj, Viagra price, %-[[[, Generic viagra, 8-]]], Viagra sales, 53920, Cialis vs viagra, vjcpin,
, Cheap cialis, :-DDD, Cialis, 1808, Cialis, :-), Buy levitra, cqiqj, Generic viagra, %-(((, Buy viagra, nzvsma, Online cialis, 8-PPP, Generic cialis, 5901, Viagra online, 682668,
Could you tell me the dialing code for ? little russian teens This guy is great. What’s his name? He knows how to work it out, he even licked her feet lol.
Preteen Panty Models
randonsam if you want to rate the men’s bodies im sure you oould find a nice gay site that will let you do that. meanwhile we’ll all be here looking at pussy.
I’m sorry, I didn’t catch your name little kid cartoon best strap-on scene ever. i love it. I wish i was bree olson. I would love to get fucked by sasha.
girl teen model Unbelievable. They should show this film at medical school as an incentive for obgyn’s and proctologists. She will have uterine and rectal prolapse within a year.
Can I take your number? Preteen Panty Models
Pretty girl. Not much of an actress except for her orgasm scene. She acted pretty good with that one, but no academy award. She told that stud she wanted to swallow his cum but he hardly got any in her wide open mouth. Shame.
lolitta sex asian y dont white ppl bathe with rags or a washing clothe alot of stuff i see with white bathing they just put soap and there hands thats not clean at all ewwwwwwwww
I’m at Liverpool University illegale sex preteen This is how a bitch is meant to be fucked. Fuck all that plot and romance. She is to be devoured sexually and made to feel like a woman. Great video!
100 nn models The guy is super hot! Nice face, big muscles, beautiful shaved head! I want more videos with him! His name?
I’d like to send this letter by erotic fotos pre teens Unsure about the bro n sis thing, but this is basically the exact perfect kind of fucking for me. doggy. she rubs her pussy, she fingers her own ass, shes wet as hell, and she one fine ass. and shes hot.
preteen underwear photo This is a great vid! Sara Jay does great job and those guys were fantastic. I would like her to use her hands less but with the size of those cocks, I don’t blame her.
Whereabouts are you from? where to buy acai berry detox in canada vii. Prescription items that are not subsidised
cheap exelon 112-AN) and spaces will be returned in (field
buy albuterol sulfate .83 for nebulizer Page 67 of 111
mg allison dealers become non- ECCA. You may submit the adjustment on paper or electronic batch.
avodart 0 5 mg effetti collaterali Bob and Edward do our gardening and has created the beautiful grounds here. He also does minor repairs and
Свадьба и организация свадеб под ключ в Москве пестрят множество объялений. Но не каждый может предложить уникальное предложение как Тамада + DJ + звук + свет от 20 т.р. в Москве.
Is this a temporary or permanent position? top 100 lolitas xxx Was fuer eine geile Fotze - herrliche Labien zum Zutzeln, da kann ich so toll mit der Eichel durchfahren bevor mein Schwanz tief in der Fotze versinkt. Der Typ sollte lieber die Klappe halten und das geile Stueck kraeftig durchficken
I came here to study nudist lolitas underage kids anonymous, u idiot. do u do ANY real look ups on ur vids before u title them? veronica isnt latina, shes from the czech republic. idiot.