Personal Budget Template

Manage your finances and track your monthly financial

obligations with our Personal Budget Template.
Monitor your income and expenses, sorted by
categories and subcategories. Analyze your financial
habits and their impact on your bank balance through
monthly reports and dashboards with multiple charts.
Additionally, track payments still pending and what had
been settled with a customizable calendar in the
template.
Start today

EXPLAINER
 Watch video

We value your input. If you have any comments,

questions, or suggestions on how to improve this
business resource please let us know.

Feedback

Errors and omissions liability (E&O): You Exec LLC makes no guarantee that the formulas, models, analysis, financial
projections, estimates, graphs, reports, numbers, and any derivatives sourcing from this model are free of errors and
omissions. Our financial modelers have audited this model to the best of their capabilities, yet You Exec LLC assumes no
liability for erroneous outcomes derived from this financial model.

Copyright © You Exec LLC. All rights reserved.

TABLE OF CONTENTS

Sheet 1 Cover

Sheet 2 Table of contents

Sheet 3 Fields

Sheet 4 Income

Sheet 5 Expenses

Sheet 6 Financial report

Sheet 7 Payment schedule Paid

Sheet 8 Dashboard Paid

Sheet 9 Analysis (Hidden)

COLOR KEY
Types Example Description
General user inputs $3,400 General inputs to customize the model

Important user inputs $3,400 Very important user inputs

Dropdown selector Select a dropdown entry

Calculations $3,400 Formula results

Results

Good results $3,400 Favorable outcomes

Bad results $3,400 Unfavorable outcomes

Overwritable (Overwritable) User can overwrite formula

FIELDS
2024

CUSTOMIZABLE DETAILS

CALENDAR
Current year 2024
Start week on Sunday

LANGUAGE SETTINGS

# Month name Month abreviation

1 January Jan
2 February Feb
3 March Mar
4 April Apr
5 May May
6 June Jun
7 July Jul
8 August Aug
9 September Sep
10 October Oct
11 November Nov
12 December Dec

CATEGORIES

ACCOUNT DETAILS
Account name Initial balance
Savings account $1,000
Joint account $3,500
Checking account $1,150
INCOME DETAILS
Income type Monthly expected ($)
Salary $3,500
Freelancer $1,650
# Weekday name Weekday abreviation
1 Monday Mon
2 Tuesday Tue
3 Wednesday Wed
4 Thursday Thu
5 Friday Fri
6 Staturday Sta
7 Sunday Sun
 EXPENSES DETAILS
Deposit to... Expenses type Monthly budget ($)
Savings account Bills $1,200
Joint account Subscriptions $60
Housing $1,600
Credit card $550
NOTES

Enter the current year

Select the weekday to start the calendar in the "Payment sc

Enter the months and weekdays in your language to be use

Enter the starting balance to analyze future projections bas

 Enter the categories to be used in the 'Income' and 'Expens

Withdraw from... Set the "Monthly Expected" and "Monthly Budget" values to
Savings account
Savings account
Joint account
Checking account
o start the calendar in the "Payment schedule" tab

weekdays in your language to be used throughout the template

ance to analyze future projections based on your transactions

o be used in the 'Income' and 'Expenses' tab

ected" and "Monthly Budget" values to contrast actual results with expectations on the dashboard
INCOME
2024

DETAILS

Categories Due day Jan Feb

- # Total ($) Done Total ($)

Company 1 8 $3,500 ✔ $3,500
-
-
-
-
-
-
-
-
-
Total deposited ($) $3,500 $3,500

- # Total ($) Done Total ($)

Upwork 25 $1,000 ✔ $1,350
Workana 25 $500 ✔ $600
-
-
-
-
-
-
-
-
Total deposited ($) $1,500 $1,950

- # Total ($) Done Total ($)

 -
-
-
-
-
-
-
-
-
-
Total deposited ($) $0 $0

- # Total ($) Done Total ($)

-
-
-
-
-
-
-
-
-
-
Total deposited ($) $0 $0

- # Total ($) Done Total ($)

-
-
-
-
-
-
-
-
-
-
Total deposited ($) $0 $0

- # Total ($) Done Total ($)

-
-
-
-
-
-
-
-
-
-
Total deposited ($) $0 $0

- # Total ($) Done Total ($)

-
-
-
-
-
-
-
-
-
-
Total deposited ($) $0 $0

- # Total ($) Done Total ($)

-
-
-
-
-
 -
-
-
-
-
Total deposited ($) $0 $0

- # Total ($) Done Total ($)

-
-
-
-
-
-
-
-
-
-
Total deposited ($) $0 $0

- # Total ($) Done Total ($)

-
-
-
-
-
-
-
-
-
-
Total deposited ($) $0 $0
 Feb Mar Apr May

Done Total ($) Done Total ($) Done Total ($) Done
✔ $3,500 ✔ $3,500 $3,500
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
$3,500 $3,500 $0 $0

Done Total ($) Done Total ($) Done Total ($) Done
✔ $1,400 ✔ $1,400 ✔ $1,400
✔ $850 ✔ $850 $850
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
$1,950 $2,250 $1,400 $0

Done Total ($) Done Total ($) Done Total ($) Done
 - - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
$0 $0 $0 $0

Done Total ($) Done Total ($) Done Total ($) Done
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
$0 $0 $0 $0

Done Total ($) Done Total ($) Done Total ($) Done
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
$0 $0 $0 $0

Done Total ($) Done Total ($) Done Total ($) Done
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
$0 $0 $0 $0

Done Total ($) Done Total ($) Done Total ($) Done
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
$0 $0 $0 $0

Done Total ($) Done Total ($) Done Total ($) Done
- - -
- - -
- - -
- - -
- - -
 - - -
- - -
- - -
- - -
- - -
$0 $0 $0 $0

Done Total ($) Done Total ($) Done Total ($) Done
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
$0 $0 $0 $0

Done Total ($) Done Total ($) Done Total ($) Done
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
$0 $0 $0 $0
 Jun Jul Aug

Total ($) Done Total ($) Done Total ($) Done

$3,500 $3,500 $3,500
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
$0 $0 $0

Total ($) Done Total ($) Done Total ($) Done

$1,400 $1,400 $1,400
$850 $850 $850
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
$0 $0 $0

Total ($) Done Total ($) Done Total ($) Done

 - - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
$0 $0 $0

Total ($) Done Total ($) Done Total ($) Done

- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
$0 $0 $0

Total ($) Done Total ($) Done Total ($) Done

- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
 $0 $0 $0

Total ($) Done Total ($) Done Total ($) Done

- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
$0 $0 $0

Total ($) Done Total ($) Done Total ($) Done

- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
$0 $0 $0

Total ($) Done Total ($) Done Total ($) Done

- - -
- - -
- - -
- - -
- - -
 - - -
- - -
- - -
- - -
- - -
$0 $0 $0

Total ($) Done Total ($) Done Total ($) Done

- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
$0 $0 $0

Total ($) Done Total ($) Done Total ($) Done

- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
$0 $0 $0
 Sep Oct Nov

Total ($) Done Total ($) Done Total ($) Done

$3,500 $3,500 $3,500
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
$0 $0 $0

Total ($) Done Total ($) Done Total ($) Done

$1,400 $1,400 $1,400
$850 $850 $850
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
$0 $0 $0

Total ($) Done Total ($) Done Total ($) Done

 - - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
$0 $0 $0

Total ($) Done Total ($) Done Total ($) Done

- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
$0 $0 $0

Total ($) Done Total ($) Done Total ($) Done

- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
 $0 $0 $0

Total ($) Done Total ($) Done Total ($) Done

- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
$0 $0 $0

Total ($) Done Total ($) Done Total ($) Done

- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
$0 $0 $0

Total ($) Done Total ($) Done Total ($) Done

- - -
- - -
- - -
- - -
- - -
 - - -
- - -
- - -
- - -
- - -
$0 $0 $0

Total ($) Done Total ($) Done Total ($) Done

- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
$0 $0 $0

Total ($) Done Total ($) Done Total ($) Done

- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
$0 $0 $0
 Dec Total ($) Mini chart

Total ($) Done $ %

$3,500 $10,500 100%
-
-
-
-
-
-
-
-
-
$0 $10,500 100%

Total ($) Done $ %

$1,400 $5,150 49%
$850 $1,950 19%
-
-
-
-
-
-
-
-
$0 $7,100 68%

Total ($) Done $ %

 -
-
-
-
-
-
-
-
-
-
$0 $0 0%

Total ($) Done $ %

-
-
-
-
-
-
-
-
-
-
$0 $0 0%

Total ($) Done $ %

-
-
-
-
-
-
-
-
-
-
 $0 $0 0%

Total ($) Done $ %

-
-
-
-
-
-
-
-
-
-
$0 $0 0%

Total ($) Done $ %

-
-
-
-
-
-
-
-
-
-
$0 $0 0%

Total ($) Done $ %

-
-
-
-
-
 -
-
-
-
-
$0 $0 0%

Total ($) Done $ %

-
-
-
-
-
-
-
-
-
-
$0 $0 0%

Total ($) Done $ %

-
-
-
-
-
-
-
-
-
-
$0 $0 0%
NOTES

Set categories in the "Fields" tab

The current month will be highlighted in dark blue

Deposited color-code:

Deposit completed

Deposit due this month

Deposit overdue

Monthly projection:
· The tab automatically replicates the monthly deposit entered in January to other months
· Update the deposit values as the month progresses, if necessary
· Overwritten values will be highlighted in blue
EXPENSES
2024

DETAILS

Categories Due day Jan Feb

- # Total ($) Done Total ($)

Eletricity 8 $100 ✔ $100
Water 9 $20 ✔ $20
Gas 10 $35 ✔ $35
Internet 8 $80 ✔ $80
Phone 8 $80 ✔ $80
-
-
-
-
-
Total deposited ($) $315 $315

- # Total ($) Done Total ($)

Streaming services 8 $50 ✔ $50
Gym membership 10 $25 ✔ $25
Apps subscriptions 10 $30 ✔ $30
-
-
-
-
-
-
-
Total deposited ($) $105 $105

- # Total ($) Done Total ($)

 Rent 10 $1,500 ✔ $1,500
-
-
-
-
-
-
-
-
-
Total deposited ($) $1,500 $1,500

- # Total ($) Done Total ($)

Minimum payment 15 $300 ✔ $300
Interest charges 15 $100 ✔ $100
-
-
-
-
-
-
-
-
Total deposited ($) $400 $400

- # Total ($) Done Total ($)

-
-
-
-
-
-
-
-
-
-
Total deposited ($) $0 $0

- # Total ($) Done Total ($)

-
-
-
-
-
-
-
-
-
-
Total deposited ($) $0 $0

- # Total ($) Done Total ($)

-
-
-
-
-
-
-
-
-
-
Total deposited ($) $0 $0

- # Total ($) Done Total ($)

-
-
-
-
-
 -
-
-
-
-
Total deposited ($) $0 $0

- # Total ($) Done Total ($)

-
-
-
-
-
-
-
-
-
-
Total deposited ($) $0 $0

- # Total ($) Done Total ($)

-
-
-
-
-
-
-
-
-
-
Total deposited ($) $0 $0
Feb Mar Apr May

Done Total ($) Done Total ($) Done Total ($) Done
✔ $100 ✔ $100 ✔ $100
✔ $20 ✔ $20 ✔ $20
✔ $35 ✔ $35 ✔ $35
✔ $80 ✔ $80 ✔ $80
✔ $80 ✔ $80 ✔ $80
- - -
- - -
- - -
- - -
- - -
$315 $315 $315 $0

Done Total ($) Done Total ($) Done Total ($) Done
✔ $50 ✔ $50 $50
✔ $25 ✔ $25 $25
✔ $30 ✔ $30 $30
- - -
- - -
- - -
- - -
- - -
- - -
- - -
$105 $105 $0 $0

Done Total ($) Done Total ($) Done Total ($) Done
 ✔ $1,500 ✔ $1,500 $1,500
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
$1,500 $1,500 $0 $0

Done Total ($) Done Total ($) Done Total ($) Done
✔ $300 ✔ $300 $300
✔ $100 ✔ $100 $100
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
$400 $400 $0 $0

Done Total ($) Done Total ($) Done Total ($) Done
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
$0 $0 $0 $0

Done Total ($) Done Total ($) Done Total ($) Done
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
$0 $0 $0 $0

Done Total ($) Done Total ($) Done Total ($) Done
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
$0 $0 $0 $0

Done Total ($) Done Total ($) Done Total ($) Done
- - -
- - -
- - -
- - -
- - -
 - - -
- - -
- - -
- - -
- - -
$0 $0 $0 $0

Done Total ($) Done Total ($) Done Total ($) Done
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
$0 $0 $0 $0

Done Total ($) Done Total ($) Done Total ($) Done
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
$0 $0 $0 $0
 Jun Jul Aug

Total ($) Done Total ($) Done Total ($) Done

$100 $100 $100
$20 $20 $20
$35 $35 $35
$80 $80 $80
$80 $80 $80
- - -
- - -
- - -
- - -
- - -
$0 $0 $0

Total ($) Done Total ($) Done Total ($) Done

$50 $50 $50
$25 $25 $25
$30 $30 $30
- - -
- - -
- - -
- - -
- - -
- - -
- - -
$0 $0 $0

Total ($) Done Total ($) Done Total ($) Done

$1,500 $1,500 $1,500
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
$0 $0 $0

Total ($) Done Total ($) Done Total ($) Done

$300 $300 $300
$100 $100 $100
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
$0 $0 $0

Total ($) Done Total ($) Done Total ($) Done

- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
 $0 $0 $0

Total ($) Done Total ($) Done Total ($) Done

- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
$0 $0 $0

Total ($) Done Total ($) Done Total ($) Done

- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
$0 $0 $0

Total ($) Done Total ($) Done Total ($) Done

- - -
- - -
- - -
- - -
- - -
 - - -
- - -
- - -
- - -
- - -
$0 $0 $0

Total ($) Done Total ($) Done Total ($) Done

- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
$0 $0 $0

Total ($) Done Total ($) Done Total ($) Done

- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
$0 $0 $0
 Sep Oct Nov

Total ($) Done Total ($) Done Total ($) Done

$100 $100 $100
$20 $20 $20
$35 $35 $35
$80 $80 $80
$80 $80 $80
- - -
- - -
- - -
- - -
- - -
$0 $0 $0

Total ($) Done Total ($) Done Total ($) Done

$50 $50 $50
$25 $25 $25
$30 $30 $30
- - -
- - -
- - -
- - -
- - -
- - -
- - -
$0 $0 $0

Total ($) Done Total ($) Done Total ($) Done

$1,500 $1,500 $1,500
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
$0 $0 $0

Total ($) Done Total ($) Done Total ($) Done

$300 $300 $300
$100 $100 $100
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
$0 $0 $0

Total ($) Done Total ($) Done Total ($) Done

- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
 $0 $0 $0

Total ($) Done Total ($) Done Total ($) Done

- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
$0 $0 $0

Total ($) Done Total ($) Done Total ($) Done

- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
$0 $0 $0

Total ($) Done Total ($) Done Total ($) Done

- - -
- - -
- - -
- - -
- - -
 - - -
- - -
- - -
- - -
- - -
$0 $0 $0

Total ($) Done Total ($) Done Total ($) Done

- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
$0 $0 $0

Total ($) Done Total ($) Done Total ($) Done

- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
$0 $0 $0
 Dec Total ($) Mini chart

Total ($) Done $ %

$100 $400 32%
$20 $80 6%
$35 $140 11%
$80 $320 25%
$80 $320 25%
-
-
-
-
-
$0 $1,260 100%

Total ($) Done $ %

$50 $150 12%
$25 $75 6%
$30 $90 7%
-
-
-
-
-
-
-
$0 $315 25%

Total ($) Done $ %

$1,500 $4,500 357%
-
-
-
-
-
-
-
-
-
$0 $4,500 357%

Total ($) Done $ %

$300 $900 71%
$100 $300 24%
-
-
-
-
-
-
-
-
$0 $1,200 95%

Total ($) Done $ %

-
-
-
-
-
-
-
-
-
-
 $0 $0 0%

Total ($) Done $ %

-
-
-
-
-
-
-
-
-
-
$0 $0 0%

Total ($) Done $ %

-
-
-
-
-
-
-
-
-
-
$0 $0 0%

Total ($) Done $ %

-
-
-
-
-
 -
-
-
-
-
$0 $0 0%

Total ($) Done $ %

-
-
-
-
-
-
-
-
-
-
$0 $0 0%

Total ($) Done $ %

-
-
-
-
-
-
-
-
-
-
$0 $0 0%
NOTES

Set categories in the "Fields" tab

The current month will be highlighted in dark blue

Paid color-code:

Deposit completed

Deposit due this month

Deposit overdue

Monthly projection:
· The tab automatically replicates the monthly deposit entered in January to other months
· Update the deposit values as the month progresses, if necessary
· Overwritten values will be highlighted in blue
FINANCIAL REPORT
2024

FILTER

DETAILS
Payment status All

BANK BALANCE

SAVINGS ACCOUNT JOINT ACCOUNT CHECKING ACCOUNT

#NAME? #NAME? #NAME?

OVERVIEW

January
Actual ($) Expected ($)

INCOME
Total ($) #NAME? $0

EXPENSES
Total ($) #NAME? $3,410

Total difference #NAME? -$3,410

BANK BALANCE
Savings account #NAME? #NAME?
Joint account #NAME? #NAME?
Checking account #NAME? #NAME?
- - -
Total balance ($) #NAME? #NAME?

TRANSACTIONS - ACTUAL ($)

January
Actual ($) Expected ($)

INCOME
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -

Total ($) $0 $0

EXPENSE
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -

Total ($) $0 $0
KING ACCOUNT - TOTAL BALANCE ($)

NAME? #NAME? #NAME?

uary February
Difference (%) Actual ($) Expected ($) Difference (%)

+0% #NAME? $0 +0%

0% #NAME? $3,410 0%

+0% #NAME? -$3,410 +0%

#NAME? #NAME? #NAME? #NAME?

#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
- - - -
 +0% #NAME? #NAME? +0%

uary February
Difference (%) Actual ($) Expected ($) Difference (%)

- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -

+0% $0 $0 +0%

- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -

+0% $0 $0 +0%
 March April
Actual ($) Expected ($) Difference (%) Actual ($)

#NAME? $0 +0% #NAME?

#NAME? $3,410 0% #NAME?

#NAME? -$3,410 +0% #NAME?

#NAME? #NAME? #NAME? #NAME?

#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
- - - -
#NAME? #NAME? +0% #NAME?

March April
Actual ($) Expected ($) Difference (%) Actual ($)

- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -

$0 $0 +0% $0

- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -

$0 $0 +0% $0
 April May
Expected ($) Difference (%) Actual ($) Expected ($) Difference (%)

$0 +0% #NAME? $0 +0%

$3,410 0% #NAME? $3,410 0%

-$3,410 +0% #NAME? -$3,410 +0%

#NAME? #NAME? #NAME? #NAME? #NAME?

#NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME?
- - - - -
 #NAME? +0% #NAME? #NAME? +0%

April May
Expected ($) Difference (%) Actual ($) Expected ($) Difference (%)

- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -

$0 +0% $0 $0 +0%

- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -

$0 +0% $0 $0 +0%
 June July
Actual ($) Expected ($) Difference (%) Actual ($)

#NAME? $0 +0% #NAME?

#NAME? $3,410 0% #NAME?

#NAME? -$3,410 +0% #NAME?

#NAME? #NAME? #NAME? #NAME?

#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
- - - -
#NAME? #NAME? +0% #NAME?

June Month name

Actual ($) Expected ($) Difference (%) Actual ($)

- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -

$0 $0 +0% $0

- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -

$0 $0 +0% $0
 July August
Expected ($) Difference (%) Actual ($) Expected ($) Difference (%)

$0 +0% #NAME? $0 +0%

$3,410 0% #NAME? $3,410 0%

-$3,410 +0% #NAME? -$3,410 +0%

#NAME? #NAME? #NAME? #NAME? #NAME?

#NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME?
- - - - -
 #NAME? +0% #NAME? #NAME? +0%

Month name August

Expected ($) Difference (%) Actual ($) Expected ($) Difference (%)

- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -

$0 +0% $0 $0 +0%

- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -

$0 +0% $0 $0 +0%
 September October
Actual ($) Expected ($) Difference (%) Actual ($)

#NAME? $0 +0% #NAME?

#NAME? $3,410 0% #NAME?

#NAME? -$3,410 +0% #NAME?

#NAME? #NAME? #NAME? #NAME?

#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
- - - -
#NAME? #NAME? +0% #NAME?

September October
Actual ($) Expected ($) Difference (%) Actual ($)

- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -

$0 $0 +0% $0

- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -

$0 $0 +0% $0
 October November
Expected ($) Difference (%) Actual ($) Expected ($) Difference (%)

$0 +0% #NAME? $0 +0%

$3,410 0% #NAME? $3,410 0%

-$3,410 +0% #NAME? -$3,410 +0%

#NAME? #NAME? #NAME? #NAME? #NAME?

#NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME?
- - - - -
 #NAME? +0% #NAME? #NAME? +0%

October November
Expected ($) Difference (%) Actual ($) Expected ($) Difference (%)

- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -

$0 +0% $0 $0 +0%

- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -

$0 +0% $0 $0 +0%
 December Mini chart - Actual ($)
Actual ($) Expected ($) Difference (%)

#NAME? $0 +0%

#NAME? $3,410 0%

#NAME? -$3,410 +0%

#NAME? #NAME? #NAME?

#NAME? #NAME? #NAME?
#NAME? #NAME? #NAME?
- - -
#NAME? #NAME? +0%

December Mini chart

Actual ($) Expected ($) Difference (%)

- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -

$0 $0 +0%

- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -

$0 $0 +0%
NOTES

Payment status:
· All: Monitor all payments listed in the 'Income' and 'Expenses' tab—those ma
· Marked as 'Done': Track only the payments that have actually been paid or r

Bank balance from current month

Edit payments received or paid in the "Income" and "Expenses" tabs

verwrite monthly expected values to update results as needed

Overwritten values will appear in blue

and 'Expenses' tab—those made and received, and those pending
at have actually been paid or received in the 'Income' and 'Expenses' tab

Expenses" tabs
PAYMENT SCHEDULE
2024

All these features are included in the complete version

of the spreadsheet. Join today and access our entire
library of business resources.

CALENDAR

FILTER
Month January

Transaction type Expenses

January
2024

SUNDAY MONDAY

6 7
13 14

20 21

27 28
 Start today

TUESDAY WEDNESDAY
1 2

8 9
Eletricity - $100 ✔ Water - $20 ✔
 Internet - $80 ✔
Phone - $80 ✔
Streaming services - $50 ✔

15 16
Minimum payment - $300 ✔
Interest charges - $100 ✔

22 23

29 30
 THURSDAY FRIDAY
3 4

10 11
Gas - $35 ✔
 Gym membership - $25 ✔
Apps subscriptions - $30 ✔
Rent - $1,500 ✔

17 18

24 25

31
 NOTES

Done
11 / 11

STATURDAY
5

12
19

26
DASHBOARD
2024

All these features are included in the complete version

of the spreadsheet. Join today and access our entire
library of business resources.

TOTAL TO DATE

TOTAL RECEIVED ($) 'Total received ($)' vs 'Not received

$17,600

TOTAL PAID ($)

$7,275

BALANCE ($)

$10,325

'Total income ($)' by category

MONTHLY ANALYSIS

Total 'Bank balance ($)' vs. 'Expeceted balance ($)

'Cash flow ($)' by 'Month'

'Received ($)' vs. 'Not received ($)' by 'Month'

BUDGET ANALYSIS

'Received ($)' vs. 'Expected ($)' by 'Month'

From ''

'Paid ($)' vs. 'Budget ($)' by 'Month'

From ''
ACCOUNT ANALYSIS

Savings account

Checking account
 Start today

otal received ($)' vs 'Not received ($)'

'Total paid ($)' vs 'Not paid ($)'

'Total expenses ($)' by category

'Paid ($)' vs. 'Not paid ($)' by 'Month'

'Received ($)' vs. 'Expected ($)' by 'Category'

From ''

'Paid ($)' vs. 'Budget ($)' by 'Category'

From ''
Joint account

-
NOTES