Welcome to Deadbeef.com
Articles and tips on software from authored by Jeremy Bettis.

Search

XML Feed RSS

What is RSS?

Who's Online?

  • Guest Users: 7

Bi-weekly pay period blank Excel budget form

06/18/07

Permalink 09:02:07 pm, by Jeremy Email , 509 words, 42809 views   English (US)
Categories: Money

Bi-weekly pay period blank Excel budget form

Back in February, I promised a bi-weekly version of my Excel budget form. Now it is available in two juicy flavors:

It is very much like the paper budget forms provided by Dave Ramsey. Column B is the category, and columns C-E are how much you have budgeted for that pay period. Place a 1 in the first cell of each column to activate that pay period, or put in a 0 if the pay period is still in the future. That will affect the amounts in the green column. Column F in the auto-calculated total budgeted for the month. Column H is how much you have spent so far this month, so at the beginning of the month these will be all zero. Now column H is all formulas, since I didn't want to do math every time I wrote a check. So if you look at the second sheet "Actuals" you see a similar chart showing the same first columns. Starting in column D, you can just enter one check per cell. So for example if you have spent $5, $20, and $15 on food, go to the food line and put 5 in column D, 20 in E and 15 in F etc. The total will automatically show up on the "Budget" sheet in column H.

Column I is simply a formula letting you know how much is left in that "envelope" for that category: i.e. Budgeted(F) - Actual(H).

The balances at the bottom are just for checking your math: Balance F should always be zero if your budget is balanced. Balance H should be exactly the same as the balance in your checkbook. Balance I should be the same as Balance H but reversed. If it is not, then there is a broken formula in the spreadsheet somewhere.

The tables on the right side:
The allocated savings register for you to record all of your savings goals, there is a formula for percent there but that is all.

The next table is the debt snowball table. The first column is the name of the debt, then the original amount, which is not really needed except that when you call in to scream "I'm debt free", Dave will ask you how much debt you paid off, and if you didn't write it down you won't know. The next column is how much the current principle balance on that debt is, and then you have a nice little percent.

The Upcoming table is a list of infrequent bills that I always forget about. I don't think that Dave has a form for this, but I needed it so that I remember to save up for big annual bills like car registration or quarterly insurance payments.

The next section in the black box, is what I call the motivating statement. It is what encourages me to keep going, when I can look at the budget taped to the side of the fridge and see in huge letters: "We saved $3,963 and paid off $16,883 in debt" it keeps me focused on the goal.

Comments, Pingbacks:

Comment from: A-train [Visitor] Email
Could you make a weekly budget form?
My Excel skills are teh sucks.
Thanks :)
PermalinkPermalink 07/13/07 @ 18:30
Comment from: Effie Webb [Visitor] Email · http://www.myspace.com/thisiseffie
I just wanted to say a quick thank you for the budget sheet. I'm one year out of college and my credit is a mess. I'm on a spending diet and your template saved me a good long time on the computer!
PermalinkPermalink 11/19/07 @ 23:02
Comment from: clive [Visitor] Email
Thanks for the blank budgets! I made one in excel but your looks so much nicer. Nice job.

/cs
PermalinkPermalink 05/04/08 @ 08:54
Comment from: kp [Visitor] Email
Thank you for your help, I am just beginning to save at 31 years old. I need every bit of help I can find as I finally begin to make steps to secure my families future. Your budget sheet looks great and your explanation is straight forward. Thank you for taking your time to help others.
Best
KP
PermalinkPermalink 05/24/08 @ 00:40
Comment from: AJ [Visitor] Email
Do you have a daily spending tracking format such as the monthly excell sheet?

AJ
PermalinkPermalink 10/07/08 @ 15:08
Comment from: tl [Visitor] Email
thank you so much for your spreadsheets...th
they are wonderful. i need your help
though. i am not able to pull up the
biweekly one. it goes to that page
but there is no link like for the
monthly. thanks again. tl
PermalinkPermalink 12/01/08 @ 17:42
Comment from: jrucker [Member] Email
how do you download this spread sheet
PermalinkPermalink 01/18/09 @ 22:19
Comment from: Ydnic [Visitor] Email
Thanks!
PermalinkPermalink 01/19/09 @ 15:41
Comment from: Ty [Visitor] Email
Thanks. Been looking for a bi-weekly budget template.
PermalinkPermalink 01/30/09 @ 22:39
Comment from: Char [Visitor]
Thank you for sharing! I just started to program and this will be of great help. I work with Excel a lot, but you did way better than I did.
PermalinkPermalink 02/04/09 @ 10:23
Comment from: Jose Valdez [Visitor] Email
Hi Jeremy, thank you so much for these two spreadsheet, you rock bro. I am also going through FPU right now and am amazed of all things I didn't know and should before getting in so much trouble.

Question, do you have a weekly pay period spreadsheet? Me and my wife get paid every other week, but we intercalate, so every week there's money coming in for our household.

Thanks again, God Bless!

Jose.
PermalinkPermalink 02/09/09 @ 17:21
Comment from: Jeremy [Member] Email · http://www.deadbeef.com
It's only a small change to add more columns to make it weekly. I'm sure you'll figure it out.
PermalinkPermalink 02/10/09 @ 10:53
Comment from: Mark [Visitor] Email
your bi-weekly formulas are not working properly. I like the layout but how do you get it to work? in some of the formulas there is an Fcolumn where is it/ help
PermalinkPermalink 03/28/09 @ 18:15
Comment from: lizz [Visitor] Email
Please make a weekly budget for I need help!
PermalinkPermalink 05/16/09 @ 10:19
Comment from: Wenko [Visitor] Email · http://DeathToMyCreditCards.blogspot.com
Hi! Your budget sheet is awesome. I'm going to post it on my blog ok? Thanks!
PermalinkPermalink 06/02/09 @ 08:27
Comment from: Andre [Visitor] Email
These budget sheet are awesome I have just recently decided to take control of my financial life and these tools are going to make it easier to do that. THANKS a million.
PermalinkPermalink 07/29/09 @ 10:44
Comment from: N'Teasha [Visitor]
Thank you so much for this excellent spreadsheet. I have been looking for something like this for the last year. It is excellent!
PermalinkPermalink 09/17/09 @ 21:30
Comment from: LAReed [Visitor] Email
This is exactly what I was looking for!! THANK YOU! I am going to be able to reach my goals faster being able to see where the $$ is going.
PermalinkPermalink 09/30/09 @ 09:59
Comment from: llbean1113 [Visitor] Email
Hi. I would like to say thanks for the great sheet. I have returned 4 books and just saved 66.00 in fees.
I do have a question though.
I get paid every two weeks, if I am trying to plan my budget before my pay check arrives and I base it on say 1300. bring home, do I put that in week two? Also, once my check comes and it is more than the amount of 1300. (I hope) what do I do then? Because my balance will be different than the check book balance, right? I was also trying to love the D ramsey way and with trying to guess about your budget and filling in the numbers it is hard to -0_- out. for planning purposes I plan my checks, and bills, but if there is xtra where do you allocate it? to make it zero?
also if you want to insert a line, how do you make all the formulas go into the new line you have inserted as well as make them work on actuals.

Sorry for all the questions, but I am just trying to use the file correctly as well as understand what I am doing.
thanks in advance
Laura
PermalinkPermalink 01/02/10 @ 00:45
Comment from: Christina [Visitor] Email
Thanks SO much for the bi-weekly budget spreadsheet. This has been an enormous help!
PermalinkPermalink 01/05/10 @ 20:36
Comment from: violetluv15 [Visitor]
thanks a million! there are so few bi-weekly budget templates, and this is one is as detailed as i'd make it myself, if only my excel skills were up to snuff.
PermalinkPermalink 01/07/10 @ 01:46
Comment from: llbean1113 [Visitor] Email
Does H really reflect the balance of your check book? If so then I am doing something wrong.. F has been showing what the balance of my check book is, that is until I allocate ALL the money to a spot.
Also if you are supposed to allocate all your money, then do you have checkbook residual?
PermalinkPermalink 01/16/10 @ 07:54
Comment from: Jeremy [Member] Email · http://www.deadbeef.com
At the beginning of the month put the current balance of your checkbook into Carryover (C5) and then get Budgeted Total (F1) to equal 0, The Actual Total (H1) should match your current checkbook balance.

If you follow your budget 100% then your checkbook should hit $0 on the last day of the month. But normally there are some categories that you will not spend and let build up over time, so in practice you will never hit $0. What I do is leave an extra $500 or so in the checking account, so for me, H1 + $500 == my bank statement.
PermalinkPermalink 01/16/10 @ 12:07

Leave a comment:

Your email address will not be displayed on this site.
Your URL will be displayed.

Allowed XHTML tags: <p, ul, ol, li, dl, dt, dd, address, blockquote, ins, del, span, bdo, br, em, strong, dfn, code, samp, kdb, var, cite, abbr, acronym, q, sub, sup, tt, i, b, big, small>
(Line breaks become <br />)
(Set cookies for name, email and url)
(Allow users to contact you through a message form (your email will NOT be displayed.))

February 2010
Sun Mon Tue Wed Thu Fri Sat
 << <   > >>
  1 2 3 4 5 6
7 8 9 10 11 12 13
14 15 16 17 18 19 20
21 22 23 24 25 26 27
28            

Categories

powered by
b2evolution