How to Make a Budget in Microsoft Excel

Money management can be easier by use of tools to track and organize your expenses and income. Simple budgets on…

how to make a budget in excel

Money management can be easier by use of tools to track and organize your expenses and income.

Simple budgets on Excel are a great starting point, as you can choose to use an existing template or create one of your own to suit your needs.

Table of Contents

Step 1: Open a blank worksheet on Microsoft Excel

XRbjQYPmhzZpWL534S6ceIjT7Y da8jKe2qNrp6PKGFDzKvrzgIQILUcCNxNm CfyRBcrwJNt8LWSVeiSQO7C1fvkMS7ZElidbHg kP2QxU AknlU0te86ZfKvkkz 1hRW5HoQt1c01n SyzKqpnlID33QrZpxhIGf7

Step 2: Give your worksheet a title and create categories for income and expenses.

You can further subcategorize the generic income and expense lists, to create a more organized and a specific view for your budget. This is optional, as you can choose to keep broad categories for your budget as well.

OSXhPAVXd3NQiagsZBzgGuTOKHg8GSqGbhUlKxt Fa01NCx4nUwX6FiMWxyrPm0J6ZX8pldA1kiYwF5YXpQTfdXE4zC86qeLZUCOvwBlKtHS1kRlUB4b DcC868hFM314R03UxNfBzTNwqSYY2QKGAuiEYATooy7X5hl B7OYk KbtwIFGb gSTVGSwlsB TzNNnw2 EqA
NTV4K7RC1kASNKT4LWkRra9xpYNSOTgYp5Npa sdvJevMjf8z64YLdaj7rwSxIeW9BpXSi1nNhIDZAxIlKF0iOZwXwqqOoG1TqVyt9W NqfFRLk22t643xSCwEt9v1pLzkgBJ12ck9cJutZ eLUj62WkBKs60eGKhHbZXtjssym2AQUug1wVn2ZjNRo5Q nKcVeUvNpTDA

Step 3: Determining the period for your budget

You can choose whether to have to a daily, weekly, bi-weekly, monthly or an annual budget. It depends on several factors including the frequency of your salary remittance, your financial activity, and how often you are likely to update the budget.

YpPJYqYFceeITDAUVMRNXH6WCiCrQBZ7tD G9o8QOGu1 J7yggsIBxjWIOlNOMWvoK3hStQXhJ06wqLbzb0vyhXjCaM5grl3jiGqy4oLzztqKuX0 pUWqYZ27UBiooGPuev3CIXER4gxp0RIK rWh TFCpGmJxqiEx

Step 4: Setting up the budget to see a difference between actual and budgeted income/expense

Regardless of the period you use for your budget template, divide each time period into three parts:

  • Budgeted income/expense
  • Actual income/expense
  • Difference between the budgeted and actual income/expense
mtXEMu1iz8CE q3k6A5KVPo UhFeKERWeZhfSeWuuF38BTgoCt5N1mKQuUsmC6oE0mHPm7UXJCR6 6SKWH9nFwZccEqc8DOBfXWuBkvEOPgHNiluph8uhKeEsnEFGrkrqnKCndBzdn7tdXDaBRmn1fuufn

Step 5: Using formulae to streamline your budget

Using simple formulae in the budget template will enable you to conduct accurate computations, will minimize redundancies and create efficiency.

  • To calculate the difference between actual and budgeted income/expense, use the following formula:
vd4 h j0Hxgq7gF 0RhOGsESEsHbTn7UyoUK45CFCPKia1UZJm1DrWlzv08kcKETQgIZOUu6FsICTzPgry2dl8rV590xom3CS43EcsHzTZKfRiaLasdfNSplYrN5UWMvC2
  • To find out the total values for your income and expenses, use the SUM formula
  • Use AutoFill to drag and copy the formulae to the other cells

Step 6: Fill/Update your budget with actual and budgeted numbers

Using your previous bank data and receipts, input the required numbers into your budget. This exercise will need to be repeated based on the selection of your time period for the template. 

ZOLlr2xloQE FIhH4ilqwQ3KTJ9lgiK1vbcIlAXD1uoIlMkAsyjvhSk AJRfJ6h C1TXnqHGaIwBgWPzHeJzJgp9hXWUvTeocczrYGERiX3zluZbfa7Q QunKDcmfMwZqByn YFbUqIOvNCWCCmFYchY3QoIFD JcyaQF6jr4MpnM 0urt9aUkU1v8sZhJsq2RWB Oncw

Step 7: Analyze your budget

As you go through the numbers, you will be able to see the discrepancies easily in the difference column, which will tell you how to budget and spend appropriately for the next time period. This is a great first step towards personal money management and gives you a snapshot of where the changes need to be made or if you need to account for other unforeseen expenses over time.

Step 8: Formatting tips

  • Select the entire range and use the currency feature to format the cells to $ or currency of choice.
KK8P i8cI 592v9sS8hqyC3 MuaIbuFOxivIwaTg4VWd 5YFBS3nxrbYxHoZoZe9PxGKmLV yujBGWiXI5edDZt9UV4V3VjnZICnUsYAFKPKK7 xniydxsXaguSQRhyvs4MbGhr0GsrGrlc aTmZxStOGgOJXkMVKY9VNV9olGjB588vinriUITZr2WbMlqERnfr VAq4A
  • Use conditional formatting to give a visual representation to your actual and budgeted expenses.
    • Select the column required and click on Conditional Formatting
msb7yqnM8sp5ljkaLPaTv7FEetFst8yPTdjke1bwGgv8DH2OAeMNTjbowC2fmhFF6sZKqHlGykISPrmcQNYsZmRV2Loc5yRlE4J mI5IoxUKgvuYSrwWocFKtB h0l2rZdXf PKLriV0h8NyjihG1Rj 0usml uLzW8oG9twqtovWiAsCeV7TqBiQ7ltue TFKDaY8FkJA
  • Select Highlight Cells Rules 🡪 Greater Than and the formatting rule as per the screenshot below
sE47xDRo0UV86oeY8qiT vsfhbjDVPPemiDqdFXLHBwuPyksK1o8xmkT viityJ8nwEOY3W05sEl7t 0J8l8ON1TApxfc SxPX XqeiFTETGgP2Fe39sbm2cYTHKEobhyrLsqWYirDk3
Graphical user interface, text, application

Description automatically generated
  • Next, select Highlight Cells Rules 🡪 Less Than and the formatting rule as per the screenshot below
XsrETu68RGRUaSCQsNISE5xpfqwMSC2zFSW mVrHiAQZomvk6X0pdugqUDJOpUsIA5 IkZJKa rmBZu5fegfId6Uur VkXJjtpppGpV9OxYtKkYhdihWhU
  • You will have a worksheet that highlights all the exceeded expenses in red and in green if they have been less than the budgeted amount.
s9m3H4MOHsunA3i5pU9MKvToHBnnOl4HZXZiNOialroRcFtyx1 RwlGVNV4MQmAYzbyfPr XwyzHxSvEit65HWvfC2l0kvNZDTc1Bw0sRHc O0mXZKSxYxywkrlukiDrvDWOXo0yGOCDcngY0OfgMqHQxblOt2x
  • Use charts and graphs

This helps give a visual representation to your data. Excel has many kinds of charts and graphs that can be used to visualize the required information.

  • Select the columns/rows 
  • Click on Insert and select the thumbnail for the type of chart you need.
7tKe6HYUj0bhNfR1xF8LgSAjGLAztoUduYJGtYYOOFvpkXKpw05ph4Uyx30g3IvGFgr0nwo75V6KnD0jqBfGXV7wqw41P66tm MCIWIgr1DIxiFwD HJavV2ipDr0S6cKGaYd iazPm2kCCXX2pXv
Graphical user interface, chart, application

Description automatically generated

Bonus: Using a built-in budget template in Microsoft Excel

  • Open Excel, click on File 🡪 New From Template
ShlSnW2oDGPsYCCj2mpAWr6F7fC4VZ0ucMv50BmSA18j567RSz0KmK5B6GupI5Bf27QKf4s8DAgk9X01pvDwi8zfDfw8VY osz3gby8YuwyxdJzYkGFrfux6S emu4TZ2sp5oIE42
5DAjHVRwxkKvkJ7EAwGIAQMRn7AcAQusje2 2 153xc AJzRpgntZ3hclLulnENtMLa5hazsO89P2rgdvub Q6z9zSogVRezeaGMkeu3oMmv2N4 H Qp7emZrddX5a8PCWisKOIUqJnFfmdUq2lB8wfcQbXsn16p8NbolCQ pAdh5f9hKf1Pb1r7tYmf NCvmlcnlJolbQ
  • In the top right Search bar, type “budget” and hit enter to see a list of budget templates available for Excel.
f3E0g2lTl7UHQ HHvoYR Qm2oZ5hFKrAjBoAOUfW5MswfD5963uvyEBeZOghU7iwIJVQd0PZb1EXmzG2YGhgiHrYAz1IqhYUmWDi9GLNQxoKcfZT5jJF3Jhko8bykdnOT8n62TIzuDPR81O7UzLfy8KbXGH8XZcW9sdU7kgbr T0Bj6QhQke78EOLDnWqSGoe GMjjgrDQ
  • You can select one of these templates and fill out your financial information in the pre-made fields, wherein the formulae and the categories have already been set up. These templates can further be edited to suit your needs.

Similar Posts