Bi Weekly budget spreadsheet

[pbmom]

Does anyone get paid bi weekly that uses a spreadsheet? If so could you please share it with me, I'm stuck on how to make one. Any help would be appreciated!!

[newmummy]

I'm not quite using it yet since I don't start work for three weeks , but mine's set up this way. I took one from the Dave Ramsey site and just made 2 "zero-balance" budgets based on what my estimated pay will be. Hope that helps.

[taz157]

Congrats on the job newmummy!! ;D

[regina24601]

pbmom - Here's my biweekly budget, scrubbed of all my personal info, and I zeroed out my information. But all of the formulas are still in there, so if you plug in some numbers to the "budget" columns, you should be able to see how it all fits together. Also, you'll notice 2 templates - one for the months in which I receive 2 paychecks (10 months of the year) and one for the months in which I receive 3 paychecks (2 months of the year). Basically, I budget household expenses (groceries, gas, etc.) on a biweekly basis, and bills are on a monthly basis. That way, when I get my third paycheck, I only have to buy groceries, gas, etc., and the rest I can bank.

I'm super anal retentive, so when my employer switched from semi-monthly to biweekly paychecks a couple of years ago, I had a mild panic attack. But I sat down with my good friend Excel for a few hours and banged out a new budget that works for me. I've modified it over the past 2 years, and what I use here works for me.

If you need clarification on anything, just let me know and I'll be happy to explain. Hopefully this gives you a jumping off point to do your own budget. Happy spreadsheeting!!

Attachments:

Biweekly budget.xlsx.jpg (30.69 KB)

[pbmom]

regina-

Thanks so much. That helps me get a great idea. I've never been an excel expert so hopefully I can use this as my jumping off point and can tweak it to fit me. Karma!!