Simple way to track your personal finances and budget in Google Sheets & Excel

[@mistydavis4746]

I like your opening: "What gets measured, gets improved." That is so true!!! Your Finance/Budget sheet is super clean and tidy. I've been working with Excel, and it has made a huge difference. I just found your video and subscribed to your channel. I followed your video to create a sheet and it worked perfectly! Although I figured out, I need to add multiple dependent lists because I have ten main categories which I further break down within each category. However that made a huge drop down list. I was able to add a column with Catagory and one with Line Items the drop downs work, but I am not sure how to link them all up. I've watched other videos, and they just confused me. What I really liked about your sheet is how you have all your accounts running in one sheet! I hope that you will post more videos like this. Thank you for the awesome video. Have a great day!!! :)

[@DataAnalytics2486]

you are my hero!!! no joke - I didn't know how to track my budgets before and you saved my life!!!

[@TucsonArizona]

Great content here! We use Excel right now for our budgeting and goals finance sheets, but we are slowly making the transition to google spreadsheets. I appreciate you showing the two. I also appreciate your insight that you are a little hesitant having personal finance info on an app; I never thought of it like that but it makes sense to use the spreadsheet instead of the app. Keep this important content coming! Subscriber #533 here!

[@cpaexplains1287]

Thanks! Glad it was helpful.

[@TucsonArizona]

@@cpaexplains1287 Looking forward to following your channel!

[@rooseveltdeleon5348]

Excellent video... Thanks for including banking & credit cards.

[@Shawnston11]

I appreciate you taking the time to make this video, I spend a few hours Pausing & & going back step by step to make a duplicate of this spreadsheet. I learned a lot. Thank You

[@Canoejerry]

Extra little trick, you can use =TEXT(B4,"mmmm") so the month is automatically selected from the date for you. This is a great SIMPLE video for most of us though, thank you for taking the time.

[@patrickshishivenivanwyk1843]

Thanks will try that if I understand what your saying?

[@SantiYounger]

This is amazing, thank you so much for making this, would it be possible to have access to an example file. It'd be extremely useful! Thanks

[@johnschulte5820]

Thank you so much! I loved how you showed your formulas so it was so easy.

[@maryharvey724]

Ill watch your video over and over until I can put my budget together. Thanks so much!

[@eddiecenteno8]

This is exactly what I'm looking for. Thank you, now I just have to follow how you set this up.

[@patrickshishivenivanwyk1843]

I tried but I didn't seem to work. Should be the Formula to automate the Account and the categories?

[@sharemind]

Thanks! Great budget template and tutorial.

[@kimcaballero_]

This video is so helping and so easy to follow. Thank you so much!!

[@DreamLauncherAcademy]

Super helpful! Thank you, I followed all the steps and looking forward to better financial understanding.

[@sergiog2930]

Amazing! the best I have seen, please keep uploding, we need the one you use to track financial investments :)

[@MrWanenglee]

Simple and easy to understand and follow. Superb.

[@cassandra.ogbozor]

Life saver!! Thank you so much for this! I needed it

[@tylerharris3266]

By far the best video I have seen on this yet! keep up the good work

[@imasava3560]

awesome job, thanks from Indonesia❤

[@fmly7]

This a great budget. I took the challenge of a monthly budget indicator. I made a column next to the annual budget for my monthly budget adding up a total monthly budget at the bottom. Below each month I made a budget compare row where I subtracted the monthly budget from the sum of the actuals. Then below that I made a sparkline chart for win loss. =sparkline(L29,{"charttype","winloss";"color","green";"negcolor","red"}) L29 is the budget compare number. If it is negative you are over budget and the chart shows red. If you are in budget the chart shows green. Copy for each month.

[@stephaniewhiddon7790]

@fmly7 Interested in this could you show this?

[@bengleason9664]

This is amazing. Building this step by step is incredibly helpful thank you!

[@matet87]

Nice tutorial. Very helpful! I'm so happy I have made a new cashflow system ! Thank you!

[@joshuaozigi3]

This was truly helpful. Thank you for taking the time to do so.

[@richardstefan3904]

Thanks, this is very well explained.

[@spectrumstudios4941]

Finally I found really helpful tutorial. Thank you for your work!

[@raulplus100]

You are the best. So simply so easy so useful. You are awesome.

[@the24hourmarketer]

Wait a minute, debit means you are deducting from the account and credit means that you are adding to the account. So why are you doing it backwards?

[@2NormalHuman]

The money deposited into your checking account is a debit to you (an increase in an asset)

[@2NormalHuman]

And an increase in a Liability account is a credit.

[@mayham2k]

Thanks for this, I enjoyed the tutorial. My spreadsheet was getting crazy. My question is what do you do next month? Do you make a new sheet each month? How do you keep the expense data each month? Also, would you record your investment and 401k accounts here as well or separately on another sheet? Currently II have it all on one and it's getting out of hand.

[@lucyamargaretha7697]

This is the system i have been looking for. Thank you!!

[@juliooliveira6102]

Don't think I'm not aware...

[@abdesamad6616]

thank you so much for your amazing work. I can't really thank you enough for what u have provided for us. I think u need to add donation button so we can support u. u the best ❤

[@bellabethany9]

What do you do when your expenses on the left hand side have gotten way too long? Do you copy the spreadsheet into a new tab and start fresh?

[@Willyboyog]

tag me when you get answer

[@josey1966]

Put the table on another sheet. Them just hide the previous months so you dont have to scroll down

[@2NormalHuman]

would be perfect if there was some sort of option to expand/collapse the transactions of every month

[@jakeerickson9081]

Bethany. I'm an accountant as well. But also a freelance solopreneur. This is a beautiful way to track your monthly personal finances and also if you run a small freelancing practice. But honestly, there's a better way with a simple small adjustment. We're gonna kill seven birds with one stone. Imagine what it'd feel like if.. You had.. 1) Cleaner data 2) You won't have a long list of expenses 3) You don't have to redo the over budget formula 4) You don't have to redo the chart 5) And if you want to reconcile from the bank month to month you can, cause I'd go nuts if I had to reconcile a full years worth of bank statements anyway lol 6) And if you get a little more advanced with excel, you can create an EOY (end of year sheet) that takes from all your monthly sheets so you have an annual summary 7) Now you can delete column A and redo the sumifs and you have less friction to add transactions during your day to day What I did was just lay it out monthly rather than annually (to fix your problem) and create a new sheet for every new month during my monthly review much like I track my weekly/monthly caloric intake. Simply just have one template you can duplicate over and over. BAM. At the end of the year just create a whole new spreadsheet and start over with your annual review. If you don't do journaling or monthly reviews look into Getting Things Done by David Allen, they are paramount to success.

[@CarmenMedellin-u8i]

@@Willyboyog I definately want the answer too, i used this all of 2024 and the transactions list got extremely long

[@CarmenMedellin-u8i]

I love this but how can I put the Account and Catergories on a separate sheet

[@IsabelJanice]

hi, thanks for this. but for some reason the sumifs formula doesnt work for me. its does not populate the other cells even though i locked the cell. do you have any idea why?

[@Hesed6]

Slow the video down and watch how he does it. $ in between the letters

[@brendennimmonsjr.6692]

@@Hesed6 I tried that, didn't work for me. Thanks though

[@brendennimmonsjr.6692]

Yeah I get an array error message.

[@luccccyxox]

Thank you for the great content, this is perfect for me :D

[@johndoan6683]

What happens when a new year rolls around? Will I need to do a "start over"?

[@DiegoParra-up4yv]

16:29 I am from Colombia and I use Google sheet setted up to work in Spanish. The translation to the formula =sumifs is deferent to what you are showing that happens. Could you please help me around this one? Thanks!

[@DiegoParra-up4yv]

Also, if you have a link to make a copy of the whole sheet would be highly appreciated!

[@surajbhondave2617]

Amazing. Great content. Could you please share the file.

[@lanatudor5331]

Thank you, this was very helpful.

[@weebstudio7305]

Shouldn't you have sum up the beg. balance with the months @17:24 bcuz that is what will reflect in our account. or am i understanding it wrong what ending balance is. pls do answer if it was a mistake or i didn't get it.

[@kandelabcn]

I also don't get it :/

[@jacobmicu3945]

@@kandelabcn I also dont get it smh

[@2NormalHuman]

yes, that's also what he said, he's adding the beginning balance and all of the months. Him not adding the beginning balance in the video is very likely a mistake he overlooked

[@stephaniewhiddon7790]

@weebstudio7305 what would the formula be for this including the beg. Balance?

[@maryharvey724]

Me again. I got it! I anchored my cells correctly! I copied what you anchored.

[@mrm8818]

I was hoping you would have done a sheet that moved a csv file in. I like to know what im spending my money on i just don't want to be updating the thing daily.

[@rhianmarie6837]

Please create a video of how to add grants and fringe rates on google sheets.

[@colleennorris8402]

okay want to know if you offer a free spreadsheet to copy as you go way too fast for the sum ifs sections

[@tebzamowandi9013]

Great insight and the content is well explained. How do i access the draft sheet? Can you please share this sheet? Thanks

[@cuddledog142]

14:38 How can you make these alternating colors in Excel? Can't find a simple way to do it. EDIT: Nevermind. You can do it by highlighting the data then pressing CTRL + T to make it a table

[@meredithhurston]

Super helpful! Thank you!

[@Lucylu723]

God bless you for making this video

[@maryharvey724]

OK. A year of using this great spreadsheet. I have been entering transactions but it doesnt populate into the yearlong sheet When I copy my formula I get the same amount in each cell? Please help me! I have had to make a new formula for each category/account. sad face

[@jeosy6121]

Thank You...Done perfectly.

[@vigneshn_learning]

In 14:55 you have put Salary in Debit Column and Expenses in Credit Column, can you please explain me the thought process or reason in doing so

[@kodiak90]

In accounting, Debits and Credits aren't always what they seem to be. For example, a Credit transaction can increase the balance of some entries (called "accounts") and decrease the balance of others. Same for Debit transactions. The reason accountants do this is sensible, but it will drive you crazy if you're not familiar with the process. It's not something you can decipher yourself, you have to be taught how to read and write double-entry accounting. It's also not something that's really important for personal bookkeeping, so I wouldn't think about it took much. Focus instead on the general lesson being taught here and apply the methods in ways that make sense to you. Good luck!

[@laurentyson]

I got through most of the SUMIFS thing, but then when I was done I got an error message. I don't know how to exit the cell properly after putting in the formula without getting an error message.

[@vsusanAdmin]

excellent thank you

[@fififinance7469]

Top work! 😀

[@simarryto]

salaries or income supposed to be Debit right? sorry I'm just new with accounting haha

[@simarryto]

wow! that was fast and easy lol but I'm bit of scared with the sumifs formula lol

[@waltergordon4630]

This is very good. The transaction table is going to get rather long over a year. How would to this by having a tab per month of transaction?

[@rayyann00r]

Please kindly share the file sir thank you very much

[@keithlorino5234]

if A had the 12 months, I think you could had the criteria match the 12 months instead of doing separately

[@keithlorino5234]

actually credits are money going in and debits are money going out. worked in accounting in banking industry

[@dg-hughes]

I did it all but I I goofed at 16:55 I anchored all the columns and rows but I should not have, I had $L$1 but it should have been L$1 just the one $ anchoring the 1st row.

[@colleennorris8402]

The sumifs formula did not work on my test sheet I followed exactly your formula.

[@felipemdra]

I just tried to use the SUMIFS formula with all parameters, but I got an error message. Somebody else?

[@pbwake65]

It's best to write down the formulas and also note the alpha-numerical cell references where these "sumif" and "sum" formulas are supposed to be inserted to, and if you start this spreadsheet in column B Row 2, then your "sumifs" will be inserted in the next column and row cell from the one shown in the video. You'll need to go through the video several times to grasp how everything comes together. This is the best approach. Listen to the commentary carefully and pay attention to the actions in detail, you need an eye for detail, if you need this spreadsheet to work. You could also take a transcript from the video's audio track with an app that converts the audio track to text.

[@MrRetroVinyls]

This is the second tutorial of this type that i try to follow up, but my Google Sheets behaviour differs from that in the video. Foe example: On the first formula i type in (=sumifs(H:H,A:A,L1,E:E,J2)) i get '0' and have the same data as the dude from the video wtf how could web app work different for different users !?!?!?!

[@IlvanBriongos]

I just watched this tutorial I find it very helpful but what do I put when I want to do a bank transfer tho?

[@tonedog5356]

Do you offer services?

[@laurentyson]

Is this better than using quickbooks? Looks like maybe it is simpler? Please advise. Thanks.

[@leislylorainelopezlevi]

why do you write expenses on the credit column and incomes on the debit column, i dont understand that.

[@ReinaBenoir]

In accounting, the debit side is the left side of the account. Cash is an asset account and asset accounts increase on the left (debit) side and decreases occur on the right (credit) side of the account.

[@sris0451]

i liked many things about this video but you lost me when you said Paycheck is Debit, when i get salary the bank message says "money credited to your acccount" and not Debited

[@alyssabate2409]

Is it just me who got confused with the anchor Part and couldn't see it?

[@bhavneshparikh8283]

How to download file

[@bhavneshparikh8283]

How can download? File

[@diogomc2821]

can you please share our excel?

[@bhavneshparikh8283]

pl share this file

[@bhavneshparikh8283]

Pl share file

[@loveusoc]

all my moneys goes to restaurants and eating out.

[@laurentyson]

Nothing simple about this.

[@laurentyson]

@@ronizulufineartworks - I agree. I had to slow it down, and even then I got confused. This should be "dumbed down" a bit for people who aren't familiar with these programs.

[@bisonchief304]

Goggle sheets is an app, and we know Google is collecting all your information

[@joecollins1823]

Not helpful

[@88allright]

I got to populate the accounts section but i cant seem to populate categories section 😅 I wonder why... Can you please post your template in the description please 🥹