Monthly Budget in Excel: Plan Income and Expenses for the Year

Knowing where your money goes is the first step to saving. This template shows a full year on one page: enter income and expenses for each month and the balance and yearly totals appear right away.

What is inside the sheet?

• 12 months in one table
• Ready, editable income and expense items
• Automatic totals for months and items
• A balance row showing surplus or deficit

How to use it

1. Edit the income and expense item names
2. Enter the amounts for each month
3. Review the yearly total of each item
4. Watch the balance row to spot deficit months

Tips for best results

• Start with fixed amounts such as rent and installments
• Update the sheet at the end of every week
• Reserve a savings line before entertainment

Frequently asked questions

Can I add items?

Yes. Insert a row inside the block and copy the formula from the row above.

Does it work with any currency?

Yes, the numbers are not tied to a currency.

Download the sheet

Press the download button at the top of the page to get an Excel file ready to edit. The sheet is also available in Arabic from the language switcher.