How to Use the Super Deluxe Budget

So you downloaded our premium budget template, the Super Deluxe Budget? Excellent! Here are step by step instructions on how to use it.


Setting up your Budget
Adjusting your Monthly Budgets
Logging your Income
Logging your Expenses
Logging your Transfers
Analyzing your Monthly Spending
Checking the Annual Summary
Frequently Asked Questions


Setting up your Budget

Start with the Setup tab.

Premium Excel Budget Template

It takes seven steps to set up the Super Deluxe Budget.

Step 1: Enable your macros. For details on how to do this, check out this FAQ.

sdb-setup-startdateStep 2: Enter the month and year of when you want to start budgeting. The template will track your spending for a 12-month period starting with this month. There is a dropdown menu for the month. When you put your cursor on the month cell, a small arrow box should pop up next to it. Click on this arrow box, and a dropdown menu will appear.

sdb-setup-currencyStep 3: Select your currency symbol to be used throughout the spreadsheet.

sdb-setup-earnersStep 4: Enter up to 5 income earners for your household. Use the GREY PLUS and MINUS SIGNS to add or remove earner spaces. Use the GREY UP and DOWN ARROWS to move earners. If you don’t want to track income earners, simply click the “Don’t Use Earners” button.

Step 5: Enter up to 5 accounts to track. Next to each account, enter the beginning balance. Use the BLUE PLUS and MINUS SIGNS to add or remove account spaces. Use the BLUE UP and DOWN ARROWS to move earners. If you don’t want to track accounts, simply click the “Don’t Use Accounts” button.

sdb-setup-accounts

Step 6: You have the option of tracking your expenses by categories with subcategories, or by categories only.

If you’re using subcategories, enter your categories and subcategories here. Use the examples or type over them with your own. Next to each subcategory, enter the amount you want to budget each month. Use the GREEN PLUS and MINUS SIGNS to add or remove category or spaces. Use the DARK GREEN UP and DOWN ARROWS to move categories or subcategories.

sdb-setup-subcategories

If you’re not using subcategories, first click the “Don’t Use Subcategories” button. After your template is reformatted, enter your expense categories. Next to each category, enter the amount you want to budget each month. Use the GREEN PLUS and MINUS SIGNS to add or remove category spaces. Use the GREEN UP and DOWN ARROWS to move categories.

sdb-setup-categories

sdb-setup-setbudgetStep 7: Click the “Set Budget” button next to the title.

After your budget is set, you should see blue navigation buttons at the top of the sheet.

sdb-setup-navbuttons

Back to Top


Adjusting your Monthly Budgets

Click on the blue “Monthly Budgets” button at the top of the screen to go to the Monthly Budgets tab.

Super Deluxe Budget Excel Template - Monthly Tab

The budgets you entered in the setup are shown here. As a default, your budget will be the same each month. If you need to make adjustments by month, this is where you would make them.

sdb-monthly-changeIf you need to increase or decrease any of your budgets for specific categories within specific months, simply type in your new budget amount.

Back to Top


Logging your Income

Click on the blue “Income” button at the top of the screen to go to the Income tab.

Super Deluxe Budget Excel Template - Income Tab

Whenever income is earned, log your earnings here.

Entering Irregular Income:

sdb-income-irregularAnything that is not part of a regular paycheck should be logged in the Irregular Income table. Type over the example with the date, description, and amount of your first irregular income item.

sdb-income-irregularearnerIf using earners, there is a dropdown menu for the income earner. When you click on the earner cell, a small arrow box should pop up next to it. Click on this arrow box and a dropdown menu will appear. Select the earner from the dropdown menu.

sdb-income-irregularaccountIf using accounts, select the account from the dropdown menu.

Enter your next irregular income item, right below the first one. Keep adding additional irregular income items, one right below the other.

sdb-income-plusminusUse the PLUS and MINUS signs to add or delete rows as necessary.

Entering Regular Income:

sdb-income-regularIf you earn a regular paycheck, enter those earnings in the Regular Income table. Type over the example with your first regular income item.

sdb-income-regularstartThere is a dropdown menu for the start month and the end month. When you click on these cells, a small arrow box will pop up. Click on the arrow box to reveal a dropdown menu, and choose your month. If your regular income is recurring for all 12 months, select “ALL” for your start month.

Then enter the description and the amount of your regular income item.

sdb-income-calculatorformThere is an Income Calculator to help you calculate your monthly net income. Click the orange Income Calculator button (at the upper-right-hand corner), and a form will pop up. Enter your paycheck amount and choose your paycheck frequency. The Monthly Net Income result is the amount you will enter in the Regular Income Table.

If using earners, select the income earner from the dropdown menu.

If using accounts, select the account from the dropdown menu.

Enter your next regular income item and continue to add new regular income items, one right below the other. Use the PLUS and MINUS SIGNS to add and delete rows.

Back to Top


Logging your Expenses

Click on the “Expenses” button to go to the Expenses tab.

Super Deluxe Budget Excel Template - Expenses Tab

On a regular basis, log your spending on the Expenses tables.

Entering Irregular Expenses:

sdb-expenses-irregularAny expense that does not recur each month should be logged in the Irregular Expenses table. Type over the example with the date, description, and amount of your first expense.

sdb-expenses-subcategoryIf using subcategories, select the subcategory from the dropdown menu. If not using subcategories, select the category.

sdb-expenses-accountIf using accounts, select the account from the dropdown menu.

Enter your next irregular expense, right below the first one. Keep adding additional expenses, one right below the other. Use the PLUS and MINUS SIGNS to add or remove rows.

Entering Regular Expenses:

sdb-expenses-regularEnter your recurring expenses in the Regular Expenses table. Type over the example with your first regular expense.

sdb-expenses-regularstartThere is a dropdown menu for the start and end months. When you click on these cells, a small arrow box will pop up. Click on this arrow box to reveal a dropdown menu, and choose your month. If your expense is recurring for all 12 months, select “ALL” for your start month.

Fill out the rest of the row by entering the description and amount, selecting the subcategory/category, and selecting the account (if using accounts).

Enter your next recurring expense, and continue to add new regular expenses, one right below the other.

Back to Top


Logging your Transfers

If you’re using Accounts, click on the “Transfers” button. If you’re not using Accounts, skip this section.

Super Deluxe Budget Excel Template - Transfers Tab

Enter any movements between your accounts on the Transfers tables.

Entering Irregular Transfers:

sdb-transfers-irregularAny movement that is not recurring should be entered in the Irregular Transfers table. Type over the example with the date, description, and amount of the first transfer.

sdb-transfers-fromaccountUnder “From Account,” select the account that the transfer is leaving from.

sdb-transfers-toaccountUnder “To Account,” select the account that the transfer is going to.

Keep adding additional transfers, one right below the other. Use the PLUS and MINUS SIGNS to add and remove rows.

Entering Regular Transfers:

sdb-transfers-regularLog your recurring transfers on the Regular Transfers table. Type over the example with your first transfer.

Select the start and end months from the dropdown menus, and fill out the rest of the row. Select the account that your recurring transfer is leaving from, and the account that the transfer is going to.

Continue to add your recurring transfers, one below the other.

Back to Top


Analyzing your Monthly Spending

Click the “Month Detail” button to go the Month Detail tab.

Super Deluxe Budget Excel Template - Screen View - Month Tab

After you log your expenses, check this tab to see how you did for the month.

sdb-month-buttonsFirst select the month you want to view, by clicking on a grey button towards the top of the screen. You can also view the Year-to-Date by clicking “YTD,” or the Total for the year by clicking “Total.”

The top section shows you how much you saved for the month, as well as how much you are over or under budget.

sdb-month-summary

If using earners, you will see an income earned section for each earner.

sdb-month-income

If using accounts, you will see a summary of your account balances.

sdb-month-accounts

Finally, there is a section for your spending by category/subcategory.

sdb-month-subcategories

On the right-hand side, you will see three charts.

Budget Spending Pie Chart:

The first chart shows you how much each category’s budget represents to your total budget.
sdb-month-budgetpiechart

Actual Spending Pie Chart:

The second chart shows you how much each category represents to your total actual spending.
sdb-month-actualpiechart

Budget vs Actual Spending Bar Chart:

The last chart shows you a visual comparison of your budget vs actual spending for each category.
sdb-month-barchart

sdb-month-chartviewIf you’re using subcategories, these charts can be drilled-down to the subcategory level. Next to the Budget Spending Pie Chart, you will see a box where you can change the chart view. Select the category from the dropdown menu, and the charts will update to show you the subcategories within that category.

Back to Top


Checking the Annual Summary

Go the Annual Summary tab by clicking on the “Annual Summary” button.

Super Deluxe Budget Excel Template - Annual Tab

Check this tab for a month-by-month view of your savings and spending.

Here you will see a section for savings by month, and budget and actual spending by month. All the way to the far right, you can see your Total, YTD, and Averages.

sdb-annual-summary

If using earners, you will see a month-by-month summary of income by earner.

sdb-annual-earners

If using accounts, you will see a month-by-month summary of your account balances.

sdb-annual-accounts

Below that, you can see your spending vs budget by category. If you are consistently over or under spending in a particular category, you may want to adjust your budget.

sdb-annual-category

That’s it! Just keep logging your income and expenses, check your Month Detail and Annual Summary tabs, and watch your savings grow 🙂

Have an unanswered question? Feel free to post it in the comments below!

Back to Top

No comments yet.

Leave a Reply