How To Make A Budget In Excel?

Open Excel and create a new blank workbook

Rename the first sheet to Budget

Create columns for Category, Planned Amount, Actual Amount, and Difference

List income sources in one section

List expense categories in another section

Enter planned amounts for each income and expense item

Enter actual amounts as you spend or earn

Use a formula to calculate Difference as Planned Amount minus Actual Amount

Use a formula to total all income

Use a formula to total all expenses

Use a formula to calculate net budget as total income minus total expenses

Format currency cells as money

Highlight overspending with conditional formatting

Add charts if needed to visualize spending

Save the workbook regularly

Update the budget weekly or monthly

Suggested for You

Trending Today