Template Information
File Information
File Name: Ultimate Excel Personal Budget
File Author: The Office Lab
File License: With the purchase of this template you have one license for your personal
use. This license covers all members of your household.
However, an unauthorized redistribution of this file or any sort of derivate of
this file for commercial gain is not permitted.
Documentation & Help: excelfind.com/documentation/ultimate-excel-personal-budget
Disclaimer: No liability is taken for any damage that might arise related to the use of this
template in a business or personal context.
Other Templates
We invite you to take a look at our most popular Excel template for project
management: The Ultimate Excel Gantt Chart.
It's the most advanced Excel Gantt Chart template on the market that allows
you to create a complex project schedule with dynamic task dependencies,
automatic coloring, actual vs base plan comparison, and many more features.
Open Template Page
Quick Start Help
Template Structure:
Budget Planning:
Budget Tracking:
More information:
Quick Start Help
This template has two relevant worksheets:
- Settings: Set the most important parameters for your personal budget
- Budget Planning: Define your custom Income, Expense, and Savings categories and create a multi-period budget plan
- Budget Tracking: Track your actual money flows and assign them to your defined custom categories
- Budget Dashboard: Monitor and analyse your budget performance for the current and historic months and years
You should always start by (1) setting the starting year in the Settings sheet, then (2) defining your custom categories and (3) setting up a budget plan in th
Budget Planning sheet.
Adding New Categories
To add a new categorry in any of the three sections (Income, Expenses, Savings), unhide the empty placeholder rows in column C and overwrite the
placeholders right below the respective section table. As soon as a category is part of the respective section table in column C, it will be considered and
displayed in all sheets of the workbook.
Creating a Zero-Based Budget Plan
When you plan your budget values for all categories in a month, the goal is to allocate every disposable dollar from income to either categories or savings,
that in the end Income - (Expenses + Savings) = 0 for each individual month. In the upper section (row 6 & 7) you will always see how much of your planne
income is still left to be allocated for each month.
Tracking Money Flows
You can add a new record to the Tracking table by entering a date, then selecting a type (income, expenses, or savings), choosing one of the respective
categories, entering the amount (as an absolute number for all types) and the details of the transaction. Your records do not necessarily have to be entere
sorted in chronological order for the template to function correctly. That means, you can always enter "older" transactions at the bottom of the table and
bring them to the chronologically correct position simply by sorting the Date column.
For more detailed information on all features and how they were built, take a look at the 'Documentation & Help' page (link on the left).
Settings
General
Starting Year: 2022
Budget Tracking & Dashboard
Late Monthly Income
Shift late income: Inactive
Starting on day x in month: 20
KPI Calculation in Dashboard
Savings Rate as % of Income: % allocated to Savings
General
Set the starting year (yyyy) once at the beginning and do not change it again.
Budget Tracking & Dashboard
Activate this option to treat late income received on or after a certain day of the month as income for the next month. This is
especially recommended in case you receive your monthly paycheck towards the end of the month and prefer to consider
this income as the disposable income for the next month.
Choose how you want the savings rate (SR) to be calculated in the dashboard KPI tiles:
1) Active Option (% allocated to Savings): SR = Savings / Income
2) Passive Option (% not allocated to Expenses): SR = (Income - Expenses) / Income
Budget Planning
Define starting year in Settings ➜ 2022
Jan ✓ Feb ✓ Mar ✓ Apr ✓ May ✓ Jun ✓
To be allocated: - - - - - -
Income Jan Feb Mar Apr May Jun
Enter Income Category…
Enter Income Category…
Enter Income Category…
Enter Income Category…
Enter Income Category…
Enter Income Category…
Enter Income Category…
Enter Income Category…
Enter Income Category…
Enter Income Category…
Total - - - - - -
Expenses Jan Feb Mar Apr May Jun
Enter Expenses Category…
Enter Expenses Category…
Enter Expenses Category…
Enter Expenses Category…
Enter Expenses Category…
Enter Expenses Category…
Enter Expenses Category…
Enter Expenses Category…
Enter Expenses Category…
Enter Expenses Category…
Enter Expenses Category…
Enter Expenses Category…
Enter Expenses Category…
Enter Expenses Category…
Enter Expenses Category…
Enter Expenses Category…
Enter Expenses Category…
Enter Expenses Category…
Enter Expenses Category…
Enter Expenses Category…
Enter Expenses Category…
Enter Expenses Category…
Enter Expenses Category…
Enter Expenses Category…
Enter Expenses Category…
Enter Expenses Category…
Enter Expenses Category…
Enter Expenses Category…
Enter Expenses Category…
Enter Expenses Category…
Enter Expenses Category…
Enter Expenses Category…
Enter Expenses Category…
Enter Expenses Category…
Enter Expenses Category…
Total - - - - - -
Savings Jan Feb Mar Apr May Jun
Enter Savings Category…
Enter Savings Category…
Enter Savings Category…
Enter Savings Category…
Enter Savings Category…
Enter Savings Category…
Enter Savings Category…
Enter Savings Category…
Enter Savings Category…
Enter Savings Category…
Total - - - - - -
2022 2023 2024
Jul ✓ Aug ✓ Sep ✓ Oct ✓ Nov ✓ Dec ✓ Total ✓ Total ✓ Total ✓
- - - - - - - - -
Jul Aug Sep Oct Nov Dec 2022 2023 2024
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - - - - - - - -
Jul Aug Sep Oct Nov Dec 2022 2023 2024
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - - - - - - - -
Jul Aug Sep Oct Nov Dec 2022 2023 2024
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - - - - - - - -
2025 2026 2027 2028 2029 2030 2031
Total ✓ Total ✓ Total ✓ Total ✓ Total ✓ Total ✓ Total ✓
- - - - - - -
2025 2026 2027 2028 2029 2030 2031
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
2025 2026 2027 2028 2029 2030 2031
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
2025 2026 2027 2028 2029 2030 2031
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
Budget Tracking
Date of Today Date of Last Record N° of Tracked Records
25-Jan-23 0-Jan-00 0 (0 this year)
Date Type Category Amount
f Tracked Records Total Tracking Balance
(0 this year) - of tracked income left to be allocated
Details Balance Effective Date
- 30-Dec-99
Budget Dashboard
Selected Year & Period Period Compl. Period Tracking Balance
2023 January 81% - of tracked income left to
Breakdown - August 2024
Income Tracked Budget % Compl. Remaining Excess
Enter Income Category… - - - - -
Total - - - - -
Expenses Tracked Budget % Compl. Remaining Excess
Enter Expenses Category… - - - - -
Total - - - - -
Savings Tracked Budget % Compl. Remaining Excess
Enter Savings Category… - - - - -
Total - - - - -
d Tracking Balance Period Savings Rate
of tracked income left to be allocated You are saving - of your income
Summary - August 2024
Income Categories (Tracked) Tracked (vs. Budget)
Total -
-
Jan Feb Mar Apr May Jun Jul
Expenses Categories (Tracked) Savings Categories (Tracked)
Total -
Year
Select the year to view ➜ Current Year
Period
Select the period to view ➜ Current Month
24
acked (vs. Budget) ✘ Budget ✘ Income
✘ Expenses
✘ Savings
an Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
vings Categories (Tracked)
Total -
