Create A Bank Log Ledger Sheet in Google Sheets
Вставка
- Опубліковано 22 сер 2024
- Creating Bank Log Spreadsheet
==================
I’m Thom Gibson.
🍎 I teach middle school math, science, and robotics.
🎥Video & 💻Computer Equipment I use - www.amazon.com...
*contains affiliate links*
⏱ What my channel is about in 30 seconds - • A Teacher / Filmmaker'...
💰'How to Teach Kids About Money' online course for teachers - thomgibson.com/...
💻'Create Successful Videos for Distance Learning' 1-hour online course for teachers - thomgibson.com/...
🎤Contact me for speaking / PD training - thom@thomgibson.com
================
Find me on social media :)
Twitter - / gibsonedu
Instagram - / gibsoneducation
Website - thomgibson.com
I just recently found and needed this video (big help!), But here is the formula everyone is looking for =IF(AND(ISBLANK(C3),ISBLANK(D3)),"",E2+C3-D3)
thank you for this formula... it was very helpful
Oh my goodness THANK YOU!
You're good. You're very good!
how tou array this formula?
Hi. Canada here. It's late 2021, and this formula is genius. I have no knowledge of any of this, but I used your formula and populated it into my sheet - and it worked. The first time. Perfectly. Thank you!
OH MY GOD you're a flippin life saver... I don't know why I didn't think of something so simple... I barely started a ledger exactly like this with the help of my stepdad.. and the same night as I was filling it in, I thought of "hm, what if I need to add a row in the middle of the month" and I could've just done the add and subtract thing uuuugh, thanks a lot!!~~
Glad it was helpful Ren!
Awesome! Sure beats having to pay a yearly subscription fee to Quicken. I don't need all the whistles and bells of Quicken, only a checkbook or savings account register. And this simple spreadsheet is perfect!
Right on! Glad you found it helpful Lalo.
I knew how to add a column but nothing else. I went back and forth between the video and my spreadsheet and lo and behold I think I've got it! This was so very helpful to an "older lady". lol Thank you!
Yes! Happy spreadsheeting 😃
Thanks so much! This is so helpful. No more boring and time consuming paper logs!
Glad it was of use to you Wil :)
Thank you ,TG. This video was a life saver. I was over thinking the register. You made it so simple.
Glad it helped!
This was so incredibly helpful! You just made my job so much easier!
Great!
Great video. I'm an old dog that actually learned something... you're a great teacher.
I agree! Every time I need a refresher course, this is my go to!
that was awesome i have applied it just and found thw result ,thanks.
Fantastic!
Thank you. Very helpful video.
Thank you so much for this clear and easy to follow video! Helped me a lot :)
Glad it helped Cedric :)
Thanks for the video. 8.29 is where the formula is that I was looking for!
Excellent! Happy spreadsheeting :)
You are the GOAT. Thank you for the video!
Glad it was helpful Jack!
super helpful! thank you so much for explaining this in such great detail! I can never find an app that does what I want. Now, I can make my own check ledger!
I use the GoodBudget app now. I like it.
Excellent tutorial for those of us who avoid formulas like the plague. :)
Ha! Hey they're not all that bad ;) Glad you found it helpful!
Great video. I'm interested in learning how to make the lines below the last ledger input be blank instead of having the last balance. Have you done a video on this since you made this one? Thanks in advance.
Hey Tom. Haven't done a video on that but you'll need something called an 'if statement' that basically says 'if the withdrawal or deposit columns are empty, then leave this cell blank, otherwise, put the balance in this cell'. This site shows you how to do that - superuser.com/questions/1063762/excel-2013-leave-cell-blank-if-it-has-no-data
@@gibsonedu I tried to follow this but am SO LOST. PLEASE do you have a video made yet to show how to get my checkbook register not showing the last balance value in all future rows of the balance column? PLEASE! - and Thank you :-)
@@christinelehman8890 Hey Christine, I don't have a video for that but I think this website may help with what you're trying to do - superuser.com/questions/1063762/excel-2013-leave-cell-blank-if-it-has-no-data
ok this one here is an excellent video. thank u
Thanks trooper :)
Good video, very clearly laid out. Did you come up with a way of not having a "Balance" showing in that column until there is a transaction (deposit or withdrawal) next to it?
Check some of the other comments as I believe I left a link in some of them to a website on how to do that
Huge help this video too. I knew how to do the first step but didn't know the rest. What I really want to do and wonder if it's even possible.. is to create a balance on a website for example much like my bank account. Maybe on a website I've made for example, once logged in I could reference a single cell where the updated balance would be. The problem there though would become that with what you're doing above the updated cell reference is changing constantly down the page. Is there a way then through a formula to IMPORTRANGE from whatever the most recent changed balance is? So that then whatever is ported to the website would be my updated balance?
Not sure as building out spreadsheets isn't really my expertise.
Thank you I'll already know the process..Great video
Happy spreadsheeting!
This is fantastic thanks for the tutorial
Glad it was helpful :)
Super helpful, thank you!!!!
Sure thing Jon :)
this was great useing it in 2024
Glad to hear it!
Sooo helpful!
Glad to hear it Carolina :)
Super helpful for my checking account thank you!!🙏☺️
Happy money managing!
Excellent. Thank you.
You’re welcome 😃
Wonderful, big help!
Glad it helped!
You da MAN!
Thanks Cronkite!
Great instruction video. Thank you
Glad it was helpful James! Happy money managing :)
I don't know your office hours - but I would like to know how to make it blank! It's what I came to this video for! :)
You'll need something called an 'if statement' that basically says 'if the withdrawal or deposit columns are empty, then leave this cell blank, otherwise, put the balance in this cell'. This site shows you how to do that - superuser.com/questions/1063762/excel-2013-leave-cell-blank-if-it-has-no-data
Very easy to understand
Glad to hear it!
Thank you so much for this video. Really helpful. Got me out of a jam.
+Mike Paternott Excellent! Glad it was helpful :)
How do I add current account balance as opposed to monthly income. (My pay is not monthly it’s lump sum amounts on random dates so it is difficult to calculate a monthly income)
Could you just add them to the sheet as they come in?
Thank you so much. Great video
Glad to hear it sach!
Thank u so much
Sure thing!
Very helpful - thanks for a great video
Glad it was helpful. Happy Thursday!
Very helpful! Thank you!!
Happy banking!
Thanks that was very helpful you're the best.
+Richard Clarke Hey glad you found it helpful Richard :)
Sir , Is it possible to create google form template
for the above transactions?
It is but I do not have this document available to me anymore unfortunately.
Is there a way to reconcile this register with the bank statement?
Automatically? No. You'd have to just manually put them in.
This was so helpful thanks
Hey glad it helps :) Happy money managing!
Very helpful, I just found an algorithm that leaves all the subsequent cells empty until one inputs a value (10:52), found it in spanish... from the Excell syntax at (which work for Google Sheets) : foro.todoexcel.com/threads/funci%C3%B3n-si-esblanco.29859/, the algorithm is: =SI(Y(ESBLANCO(D7);ESBLANCO(E7));"";F6-D7+E7), ESBLANCO is obviously ISBLANK XD, nothing is obvious here XD, hope this helps someone cause I struggled so much. Never give up! Theres always an answer, computers are dumb, but at least they don't lie! Thanks again.
There is always a way! Thanks Eddy 😃
Very helpful, but do you have a video on how to make the balance stay blank until you add a deposit or expenditure?
Haven't done a video on that but you'll need something called an 'if statement' that basically says 'if the withdrawal or deposit columns are empty, then leave this cell blank, otherwise, put the balance in this cell'. This site shows you how to do that - superuser.com/questions/1063762/excel-2013-leave-cell-blank-if-it-has-no-data
Help!! whenever I am trying to get the formula to work and I hit enter, the total will not calculate
I hate when that happens :(
This video is from a while ago, but I found it helpful. However I am having one issue I would like to clean up. When I copied the formula to the other cells in the balance column it copies the same number to every cell containing the formula below the last row where I entered transactions. That result shows up in your video for a second before you cleared the formula from unused rows. Is there any way to make those cells stay blank until I enter a transaction into that row? It is much cleaner to have the last cell containing a value -aka: my current balance. I tried conditional formatting but can't get it to hide text if the value of that cell is equal to the above cell. Thanks in advance.
I believe I left a link to another comment with answer to that but you could also search ‘leave cell empty is value is 0’ and see what comes up
Oh... I was hoping this was more of an advanced video showing how to import your balance
Ryan Newell Ha sorry to disappoint. This was actually a video I made for students in my math class to help them track expenses in our classroom economy.
@@gibsonedu lol, no worries. I did a ton of searching and turns out security does not allow spreadsheets to get past the banks login :(
Great Video!!!!
Thanks Israel. Happy banking :]
I was wondering, I am trying to imitate an actual bank with made up currency, I want to have one cell with the amount of money that the bank holds, and multiple accounts. If I could have every time someone makes a deposit or withdrawal from my spreadsheet it would only affect one cell
Hm, I'm not sure I understand the question. Could you give an example?
Hi. I couldn't get the custom date format to work. anybody knows why?
This may be helpful - support.google.com/docs/answer/56470?hl=en&co=GENIE.Platform%3DDesktop
Too many icon at the bottom of your screen sir.
OK :)
I came here to learn the one thing you didn't show... and I doubt I will be coming to your office for you to show me.
Good luck!
@@gibsonedu I guess I am going to need it since I cannot find out how to have an automatic balance without showing the last total on every line I copied the formula onto.... I know, first world problems.
Thanks so much! Very helpful!