Step-by-step Guide to Creating a Personal Budget Template in Excel:

 

1. Open Microsoft Excel and create a new workbook.
2. Rename the first sheet "Income" and the second sheet "Expenses."
3. In the Income sheet, create a table with the following columns: Date, Income Source, Income Amount.
4. In the Expenses sheet, create a table with the following columns: Date, Expense Category, Expense Amount.
5. Under the Income table, create a cell with the formula "=SUM(C2:C<lastrow>)" where last row is the last row of your income table. This will calculate the total income for the month.
6. Under the Expenses table, create a cell with the formula "=SUM(C2:C<lastrow>)" where last row is the last row of your expenses table. This will calculate the total expenses for the month.
7. Create a new sheet named "Summary."
8. In the Summary sheet, create a table with the following columns: Category, Amount.
9. In the Category column, enter the following categories: Income, Expenses, Savings.
10. In the Amount column, enter the following formulas:

• For Income: "='Income'!C<lastrow>+0" where last row is the last row of your income table.
• For Expenses: "='Expenses'!C<lastrow>+0" where last row is the last row of your expenses table.
• For Savings: "=SUM(B2:B3)" where B2 is the Income total and B3 is the Expenses total. This will calculate the amount left for savings.

11. Create a cell below the table with the formula "=SUM(B2:B4)" where B2 is the Income total, B3 is the Expenses total, and B4 is the Savings total. This will calculate the total budget for the month.

You can then use this personal budget template to track your income and expenses, and ensure that you're staying within your budget.