Creating a simple budget using excel might LOOK hard, but it isn’t. Today I’ll show you how to build the budget sheet above, step by step!

I chose this type of budget sheet for these reasons:

• The sheet lists Income less deductions and monthly debt payments on the left
• The sheet lists household expenses on the right
• The sheet has two projected columns to compare and contrast changes you WANT/PLAN to make to your budget, but cannot do yet.
• The sheet has a built in Cushion – for those nickels and dimes that add up and catch you by surprise…this means there is less room for financial accidents.
• It only uses TWO very straightforward formulas.

The ONLY formulas you need to know for this sheet:

SUM: =SUM(COLUMNROW:COLUMNROW) ex: =SUM(B15:B30)

Difference: =COLUMNROW-COLUMNROW) ex: =B5-F15

 

Step 1: Start with a new sheet and label it “My Budget” (or anything else you want to call it). Save your document.