Personal Finance Tracker

Tracking my finances is one of the best decisions I've made in recent times

So with this spreadsheet, I can track my income, my spending, my debts, and also my savings

So this tracking helps me to make data-driven financial decisions. If I want to record anything, let's say for income, I can just hover on this one

and click income here, or I can just click at the income tab here

So here in this table, that's where I can enter my income. So let's say for September, you can just pick September here and put my income there

Then if I have another type of income, you can just select the month and put it there and select the category and put the amount

So this will reflect here. So you can see this one is for September here

And also they'll be added to this chart there. Then when you scroll down here, you're able to see this is the income for Augustine Green and this is the income for September

When you scroll down further, you're able to see the summary from here and also the categories from here

This one shows you the income, spending and the balance in each of the months

When you go back to the dashboard, you can see the changes here. And this will show you the summary of your best month, your biggest form of income, your income this month and the income all year

The same is true if you go to spending and here you can enter a spending

I'll just enter one for an example. So you pick the month here, then you can choose the category, and you can put the amount

So this will be reflected there, and it will also be added to this chart

And when you scroll down, you're able to see here, and it's also added there

Here you can change the month to see the summary just for the month So if we choose September you able to see we only have which is only expenses and when we go back to our dashboard for spending you able to see september is here and you also

see the expenses oh yeah the month the highest spending where most of your spending is going to

and you're spending this month when you go to dates here in this table you can put all your

debts so here we can choose the debt by double clicking there then i'll just put the description

here then on the type you choose whether it's a loan a personal debt credit card student loan

mortgage and so on just choose personal and here you put the amount if you have paid back a debt

you can go to this table you choose the debt so let's say i paid on 30th i paid james and this was

a personal loan and i paid 500. so this will show you the total debts that you have paid and this

will show you the dates that you have not paid for each of the categories here you can see how much

debt you got how much you have paid and how much you have not paid and lastly for investment you

can also use this table so just choose the month here let's say i bought microsoft shares then here

you can choose the category so to stock for this one and put the price let's say 1000 and you can

see our graphs updates accordingly this one will show us the investment or savings by type and most

of our investment is in stocks and these two tables will show us the summary per month and

the summary by category when you go back to the dashboard all this information is reflected

accordingly and you are able to see how your finances are doing this makes it very very easy

to track your finances so if you are interested in this spreadsheet i'll leave a link in the

description on how you can get it thank you so much for watching i'll see you in the next one