THANK YOU SO VERY MUCH for this lesson. I am 70 and recently switched from Microsoft to Apple iOS. I was completely at a loss as to how to set up a simple checkbook. And I had no idea of how to input formulas into cells. My husband always did this for me before he passed away. (And he always used Microsoft.) Now I'm having to learn all this tech stuff--and iOS--without him. Your videos are so well done and easy to follow. I can't thank you enough for this help.
Your videos are so easy to follow. You are a real TEACHER and an awesome one. You are direct. straight to the point. no waste of time or unnecessary commentary. THANK YOU.
THIS VIDEO SAVED ME FROM INSANITY !!! I can't say how grateful I'm for your help !!! Thank you so much. I wasted 8 hours trying to figure this out by myself and looking for this answer in other videos.... God bless you
Me too! THANK YOU SO VERY MUCH for this lesson. I am 74. I've had a MacBook Pro since 2009, which I used with Excel for Mac. Even when I got a New MacBook in 2017, I kept on using Microsoft Excel on the old machine until the curser developed a mind of it's own, forcing me to think about Numbers. I did not know where to begin until I happened across your BRILLIANT tutorials. I was up and running confidently inside a couple of hours! As Mavanya says, I can't thank you enough for this invaluable help.
Every time I have an issue with my mac, Gary has the answers. I especially appreciate how he gets right to the point and keeps it simple! (I have never once had to fast forward to get to the content!
I am 65, and didn't realize when I purchased my shiny new Mac Mini Sonoma that I wouldn't be able to port from my older Mac. I haven't lost so much computing capability in my life. Last time I set up a computer from scratch was 1994. They used to have manuals back then. You saved me from going back to printing out a ledger and using a calculator, which, come to think of it, isn't so bad.
Thank you so much for this nice and detailed yet easy lesson. I have never been good with excel but want to get my finances in order and have a Mac a just scrolled until I found something I understood. So simple made a spreadsheet for all my accounts!!
Thank you for this! It was tremendously helpful and really easy to set up! I am absolutely shocked that Apple does not include this as a template within their Numbers app for Mac.
This is a great introduction to Numbers. I I work with Excel so I was reluctant to give it a try, but this tutorial was very helpful. Having a classic checkbook to track spending will be nice. Never could find an app I like.
OMGAWDDDDD I can't thank you enough for this!! I am NOT the most technically inclined individual when it comes to cells/numbers/balance....pretty much anything with numbers, lol. I am amazed that I was able to figure this out. Thank you so very much!
A slight variation could be to add a column for W or D for Withdrawal or Deposit. Then in the Balance calculation, make it the previous rows balance + =IF the types column ="W" then amount = amount*-1, amount. i.e. F2 + (IF D3 ="W", E3*-1, E3) or in column names: Balance + (IF Type="W",Amount * -1, Amount). But as my spouse points out, there are more than one right way to do something! Thanks for the great video tips!
Interesting! You're preaching to the converted. Since the 1980's long before I ever got a computer I used to track my spending and account balance with a small note book which went with me everywhere. Today, I do it with a MacBook, just like you are demonstrating here. It's anal, I know (friends often laugh), but it was all borne of necessity when I found myself in serious financial trouble in the early 1980's. Since I began to track (and manage) my spending, I haven't looked back.
Hi Gary. I appreciate your videos. I had already made a cash-flow table. It was similar to what you did (except only using amount with + or -). I added a cleared column as well. Then I added a column to check if the line item was cleared or not. If it was, then the amount in the amount column was added to the previous running total. If not, then 0 was added. In this way, you know how much money is in your account, based on what has cleared.
Add another old lady that applauds this video, keeping it simple. I already use Sheets to do Monthly ones to make it easier to catch a mistake. Now to try out the one I did on my Imac that to me is simpler.
This is basically like an excel spreadsheet. I'd like this to be able to be reconciled when my bank statement arrives. But I am going to play around in numbers which I had no idea what it was for. Very simple informative video.
This is a fantastic video! May I suggest a slower transition across each component of your training? From one task to the next-it would be great for new learners if you could perform each component a bit slower. Thank you!
One other point, some might not know, that Numbers runs on your Mac and IOS devices (iPad/iPhone). I run a spreadsheet like this and when I have down time sitting in an airport or restaurant. I look at my bank statement and update the info. You can also pull the bank info into the spreadsheet. What’s interesting is when I started this type of spreadsheet I notice several monthly discrepancies with my account. A pie chart is also a great way to see things and trends at a glance which can be added. Maybe a lesson on adding graphs to such a spreadsheet. Thanks again.
This is how I do mine, and from experience it is worth warning that sorting this table can cause the formula in the balance column to become inconsistent, although it is easily fixed. Let’s say you made a bunch of entries in wrong date order then sorted the table by date, this would result in the formula in some cells of the balance column now referencing the wrong cell. The easy way to fix this is to select the first correct cell in the balance column and drag it down to replace the formulas in the rest of the column. Use the handle in the bottom centre of the cell to drag, not the corner handle (dragging this will just select cells without replacing the contents).
I love this video. Thank you for making it so easy. Now do you have another video on how to create a more than basic checkbook on numbers? Or where can I find one?
More basic than this? This is pretty basic. But the idea is to learn some skills here, so take those skills and create the more basic version you want.
@@juliesit5344 Oh, OK. No I don't have anything more complex. But use this video and the other Numbers videos I have (there's a course too if you like) to learn more skills and build it. That's the idea behind spreadsheets -- you can build what you want.
Thank you!!!! I spent almost all day trying to do this since I haven't had to mess with numbers or spreadsheets in 8 months and I lost all of my notes on the subject when I moved.
Awesome tutorial Gary, really appreciate the time you give us. Can this spreadsheet be exported in any way so that we can access it easier on our mobile device while we are on the move?
Is your mobile device an iPhone or iPad? If so, just save the document to iCloud Drive and then open it up in Numbers on that device. No need to "export" or anything.
Thank you for the clear instruction. I went ahead and created multiple accounts on different sheets. Is it possible to create a category summary using a pivot table that would summarize data from multiple sheets? Thank you!
I wouldn't say it is better. Then you have a row that is different than your other rows. It isn't a transaction at all. Doing something like counting the rows (to count the number of transactions) would be off by 1. And it doesn't look as nice.
That’s the way I’ve been doing it for years, in Excel. I was hoping to find a better way because I keep a rolling balance and remove the rows after they’ve cleared my bank account. I don’t care about keeping the history. Instead, I just wanted to make sure I wasn’t forgetting a payment was already being made, thus causing me to have an overdraft. I no longer really *need* that but I still like to keep up with it in a spreadsheet. I guess I’ll keep on doing it the old way, but now I’m using Numbers on my iPad.
GREAT VIDEO!! I’ve been trying to figure this out on my own, and going nuts! Is there a way to add a dividend column, and if so, how would that be accomplished?
Good afternoon Gary, this was a great video on setting up a basic checkbook register. In numbers is there a way to be able to Reconcile the checkbook using the formulas. Do you have a video on this or could you point me in a better direction. Don't want to use Quick Books or any other expensive software for my small business teaching CPR..... Dave
I think most of the work of "reconciling" is what I am showing here, right? Not sure what else you would need. If you want to see if the totals in your spreadsheet match the totals in a statement, I suppose you could select those cells and see the sum of them to check.
@@macmost yes. I think I was highlighting the entire table including the cells that auto calculated below the heading instead of the tables where I actually entered data. Thanks!
Thank you very much for this incredible presentation but i would like to know if you can please make a presentation on how to do the same for multiple account such as credit card or if you have 3 or more different accounts thanks.
You could do each as a separate table on a separate sheet. Or, you could put it all on the same sheet with a column for "account" and then put the account name in that cell. Then you can filter by account to only see one account at a time.
I created a spreadsheet very similar to this but created a Category column for budgeting. I’m having trouble figuring out how to create a Dashboard table the shows the Unique List of Categories and their summed values based on a date range. Do you have a video that may pulls unique values from a column? Thanks for all your videos!
macmostvideo thanks Gary! I suppose if one desired you could also make individual columns for each too but that I think might lead to a wider spreadsheet lol!!! Not really ideal
Great Video! Thank you! If you enter in date that is not sequential by date, and then sort by date, will the running balance automatically adjust so that all balances are correct? I had issues with this in Excel and it took me a while to find the formula to correct this. Thank you!
Hi thank you for this lesson. I’ve been using it for over a year and it works really well. But I’ve run into a problem I can’t solve. Randomly, the sheet has hidden some rows. The rows still show in the formula above and below but when I try to ‘unhide’ the row, that option isn’t available, only hide. I tried hide anyway of the row above and then ‘unhide all rows’ but it still wouldn’t reveal the hidden row. It is noted in the row number column with a tiny thin double line and the number skips from row 385 to 387. Can you help me solve this? Thanks so much
I wrote to you and then I figured it out - I had a filter of a bunch of numbers on. Hmm I’ve been trying to figure it out for quite awhile. You even channel good info 🤣 I’ll keep watching for other Mac tips. Thanks much
Thank you. I have tried to move away from Google Sheets and on to Numbers so many times. I just can't figure number out, apart from the sum function, how it works.
what if you already created a separate expenses list in a different table and different numbers file for each month? how to combine them quickly without adding row 1 by 1 and copy + paste the data 1 by 1?
@@macmost the video you created for the business expenses, can you create a model with the business expenses, the summary, and how each expense was withdrawn from the checking. I guess possibly a third sheet. So when you put in a category, rent let’s say, and it calculates that expense on the business portion, can it also coordinate the expense when entered in as a check?
@@AquaSourceLLC Just add a column for "method" or something like that and put "check" in there. Add as much information as you need to the table by including more columns.
how to make the monthly recurring expense automatically added every month? so that we don't have to type it manually every month (such as software/app subscriptions, insurance premium, bank admin fee, etc)
Why does my account in numbers open to the first entry making it necessary to scroll down to the cell I want to use? This was not always true, but seems to be happening since the last update. Is there a setting to open the spreadsheet to the last entry?
macmostvideo I’m stymied by this change for me. It opens the same way on both my iPad and my Mac Pro laptop. It’s irritating and I’d like to change it back if it is somehow a setting in Numbers.
I really appreciate the effort however I was unable to use it for my checking account, I feel really stupid because I deleted the numbers to put my account information in and it doesn't work. I saved it as a template but it had all the numbers from the video, I suppose that it's just for educational purposes. I wonder if I should try another tutorial. I used linux os and libre office before but I've had no success with a macbook opening it. Thanks anyway.
I'm looking for a way to project an estimate of future account balance by entering recurring withdrawals and deposits (monthly, annually etc). Can this be done with Numbers. Or is there maybe an app for that?
@@macmost I'd like to estimate the future balance of a bank account, ideally as a graph, given the current balance and the recurring expenses. Like this app does: ua-cam.com/video/dQsynp4XJ24/v-deo.html just not for the slightly overheated price of $28. Maybe stuff for a future episode?
I think it's important to say that you need to add the row of information with tab and treat it like a record. When I first created my prototype I entered numbers down each column. When I copy and pasted the formula in F3:F9 it broke I got formula error. Maybe you did that at the beginning but I missed it.
You can build it any way you want and perform calculations any way you want. Continue to learn and experiment in Numbers and you can create a custom system that works just how you want it.
When I hit return after setting up my one time formula in the Balance Row I get an error message, "The operator “-” expects a number, date, or duration, but cell D1 contains a string. Why is this? Thank you! I should add I'm new to Macs.
Hello. I'm new to spread sheets, so I need it broken down. Instead of identifying a specific cell, can a formula use the "cell above" instead of a named cell. In my case, I built a spreadsheet containing all reoccurring expenses and deposits for the month. But, now that I'm adding new rows in between, the math is wrong. Instead of identifying a cell name (like C2), is there a way to say "Cell Above"?
Cell references in spreadsheets are either absolute or relative. By default they are relative. So lets say C2 holds the value 42. If you put a formula is D2 that is =C2+1 then D2 shows 43. If you put the value 100 in C3 and then copy and paste the formula in D2 into D3, that pasted formula now shows =C3+1 instead of =C2+1. It changes relative to where it was put. So if you make a formula in cell G7 and want to refer to the cell above, then just use =G6. That IS a reference to the cell above. If you were to move or copy that formula to H45, it would become =H44. See ua-cam.com/video/KZJ8KqV0rPg/v-deo.html
@@macmost My function is like that : =sum(e3+deposit-withdraw) , when I insert row above and enter my amount in deposit / withdraw , the balance amount not autoupdate, insert rows amount and next below rows amount shows same balance amount , not update.
This formula breaks for me if I insert a row or delete a row (sometimes due to a duplicate entry because I didn't realize I already entered something or the date from receipt didn't match an entry from the bank). If I insert a row the rows below do not properly update and if I delete a row, I get a #REF error and have to manually update the balance entry to point to the correct cell and then the rest update. Weird.
My comment wouldn't post, trying again, sorry if it duplicates it. In this example you gave your F10 shows your running balance at the end. How do I copy that result to another sheet but for it to keep my other sheet updated after I add another row? I got it to copy F10 but when I add another row for another expense it keeps showing F10 results. I want my running balance to stay updated on my budget sheet, if it makes sense.
Put a simple formula. Type = to start a formula. Then, click on that cell in the other sheet to add a reference to that cell. It may look something like Sheet 1::Table 1::F10
I did that, and it works and shows that cell but when I go to the original one and add a row for a new charge then the second sheet still shows F10 and doesn’t update to what would now be the balance on F11
@@melidalatigo7130 Make sure that is shows "F10" and not "F$10" as the cell reference. Or, is it that you have 10 rows and you always want it to point to the last row? So F10 is still F10, but now you want it to point to F11?
THANK YOU SO VERY MUCH for this lesson. I am 70 and recently switched from Microsoft to Apple iOS. I was completely at a loss as to how to set up a simple checkbook. And I had no idea of how to input formulas into cells. My husband always did this for me before he passed away. (And he always used Microsoft.) Now I'm having to learn all this tech stuff--and iOS--without him. Your videos are so well done and easy to follow. I can't thank you enough for this help.
I am 82 old This is very good, It only took over two & a half hours to get it finished I hope I can do it again next time Thank you
Your videos are so easy to follow. You are a real TEACHER and an awesome one. You are direct. straight to the point. no waste of time or unnecessary commentary. THANK YOU.
THIS VIDEO SAVED ME FROM INSANITY !!! I can't say how grateful I'm for your help !!! Thank you so much. I wasted 8 hours trying to figure this out by myself and looking for this answer in other videos.... God bless you
Me too! THANK YOU SO VERY MUCH for this lesson. I am 74. I've had a MacBook Pro since 2009, which I used with Excel for Mac. Even when I got a New MacBook in 2017, I kept on using Microsoft Excel on the old machine until the curser developed a mind of it's own, forcing me to think about Numbers. I did not know where to begin until I happened across your BRILLIANT tutorials. I was up and running confidently inside a couple of hours! As Mavanya says, I can't thank you enough for this invaluable help.
Every time I have an issue with my mac, Gary has the answers. I especially appreciate how he gets right to the point and keeps it simple! (I have never once had to fast forward to get to the content!
I am 65, and didn't realize when I purchased my shiny new Mac Mini Sonoma that I wouldn't be able to port from my older Mac. I haven't lost so much computing capability in my life. Last time I set up a computer from scratch was 1994. They used to have manuals back then. You saved me from going back to printing out a ledger and using a calculator, which, come to think of it, isn't so bad.
Thank you! Thank you! Thank you!
Thank you so much for this nice and detailed yet easy lesson. I have never been good with excel but want to get my finances in order and have a Mac a just scrolled until I found something I understood. So simple made a spreadsheet for all my accounts!!
Thank you for this! It was tremendously helpful and really easy to set up! I am absolutely shocked that Apple does not include this as a template within their Numbers app for Mac.
Thank You. Your explanation and formulas were just what I was looking for.
This is a great introduction to Numbers. I I work with Excel so I was reluctant to give it a try, but this tutorial was very helpful. Having a classic checkbook to track spending will be nice. Never could find an app I like.
Great video, just what I was looking for, thank you!
Very simple, very useful, just what I was looking for! Thank you!
I needed this 20 years ago.... thanks and as always great video.
YOU ARE AWESOME! Thank you for the help, I've been trying to figure this out on my own....you saved my sanity!
OMGAWDDDDD I can't thank you enough for this!! I am NOT the most technically inclined individual when it comes to cells/numbers/balance....pretty much anything with numbers, lol. I am amazed that I was able to figure this out. Thank you so very much!
Excellent tutorial. Thank you for taking the time to put this together. Saved me some brain cells trying to figure it out on my own.
THANK YOU SO SO MUCH FOR THIS VID. EXACTLY WHAT I WAS LOOKING FOR!!!
A slight variation could be to add a column for W or D for Withdrawal or Deposit. Then in the Balance calculation, make it the previous rows balance + =IF the types column ="W" then amount = amount*-1, amount. i.e. F2 + (IF D3 ="W", E3*-1, E3) or in column names: Balance + (IF Type="W",Amount * -1, Amount). But as my spouse points out, there are more than one right way to do something! Thanks for the great video tips!
The best tutorial for this type of spreadsheet!!! You made it so easy.
Fantastic and easy to follow tutorial. Thank you so much!
Thank you so much! I didn’t think I could make a checkbook ledger myself. You made it so easy.
Thank you for showing how EASY it is!!! I love this way better than Excel!!!
Took me a minute, but it's worth it! Thank you for this. Now then... Is there a way to balance using this spreadsheet?
Thank you! I enjoy your videos. Glad to know that UA-cam can be educational.
Interesting! You're preaching to the converted.
Since the 1980's long before I ever got a computer I used to track my spending and account balance with a small note book which went with me everywhere.
Today, I do it with a MacBook, just like you are demonstrating here.
It's anal, I know (friends often laugh), but it was all borne of necessity when I found myself in serious financial trouble in the early 1980's.
Since I began to track (and manage) my spending, I haven't looked back.
Hi Gary. I appreciate your videos. I had already made a cash-flow table. It was similar to what you did (except only using amount with + or -). I added a cleared column as well. Then I added a column to check if the line item was cleared or not. If it was, then the amount in the amount column was added to the previous running total. If not, then 0 was added. In this way, you know how much money is in your account, based on what has cleared.
Add another old lady that applauds this video, keeping it simple. I already use Sheets to do Monthly ones to make it easier to catch a mistake. Now to try out the one I did on my Imac that to me is simpler.
A very usable spreadsheet. Much better than trying to calculate everything manually..
This is basically like an excel spreadsheet. I'd like this to be able to be reconciled when my bank statement arrives. But I am going to play around in numbers which I had no idea what it was for. Very simple informative video.
Thank you! Everything I've needed for the past 5 years, using other apps, in 6 minutes. Wish I would've found this sooner.
Awesome.....So simple, yet my brain simply couldn't do it alone. Thank you for taking the time to post this.
Thank you so much for this!! Just what I wanted
Great Video. Simple, basic instruction. Very easy to follow. I created a simple "Cash Flow" spreed sheet in a minimum amount of time. TY
This is a great help. Thank you very much. How could anyone give it a thumbs down?
Thank you this was very helpful.
Great explanation. I now have my checking/debit register under way. Thank you.
This is a fantastic video! May I suggest a slower transition across each component of your training? From one task to the next-it would be great for new learners if you could perform each component a bit slower. Thank you!
Remember in UA-cam you have speed control and you can pause. You can also go back and rewatch. So everyone can watch at their own pace. Thanks.
you made formulas much easier! :) Thank you!
Thank you for this!! I've been searching for a video about this for quite some time!!
Great video! This really helped. Thank you!
One other point, some might not know, that Numbers runs on your Mac and IOS devices (iPad/iPhone). I run a spreadsheet like this and when I have down time sitting in an airport or restaurant. I look at my bank statement and update the info. You can also pull the bank info into the spreadsheet. What’s interesting is when I started this type of spreadsheet I notice several monthly discrepancies with my account. A pie chart is also a great way to see things and trends at a glance which can be added. Maybe a lesson on adding graphs to such a spreadsheet. Thanks again.
This is how I do mine, and from experience it is worth warning that sorting this table can cause the formula in the balance column to become inconsistent, although it is easily fixed.
Let’s say you made a bunch of entries in wrong date order then sorted the table by date, this would result in the formula in some cells of the balance column now referencing the wrong cell. The easy way to fix this is to select the first correct cell in the balance column and drag it down to replace the formulas in the rest of the column. Use the handle in the bottom centre of the cell to drag, not the corner handle (dragging this will just select cells without replacing the contents).
Very Helpful! Thank you!
I love this video. Thank you for making it so easy. Now do you have another video on how to create a more than basic checkbook on numbers? Or where can I find one?
More basic than this? This is pretty basic. But the idea is to learn some skills here, so take those skills and create the more basic version you want.
I’m sorry. I mean a more complex checkbook.
@@juliesit5344 Oh, OK. No I don't have anything more complex. But use this video and the other Numbers videos I have (there's a course too if you like) to learn more skills and build it. That's the idea behind spreadsheets -- you can build what you want.
thank you great tutorial
Simple. Well done
Thank you so much for this video.
Thank you for your excellent videos!
Thank you!!!! I spent almost all day trying to do this since I haven't had to mess with numbers or spreadsheets in 8 months and I lost all of my notes on the subject when I moved.
Thanks so much! Really useful! Now I can do my accounts!
Awesome tutorial Gary, really appreciate the time you give us.
Can this spreadsheet be exported in any way so that we can access it easier on our mobile device while we are on the move?
Is your mobile device an iPhone or iPad? If so, just save the document to iCloud Drive and then open it up in Numbers on that device. No need to "export" or anything.
Neat! I'm trying that out right now!
OMG! Thank you. Why is something so simple not already a template.
Thank you for the clear instruction. I went ahead and created multiple accounts on different sheets. Is it possible to create a category summary using a pivot table that would summarize data from multiple sheets? Thank you!
No. Create a regular table that summarizes data from multiple sheets. Pivot tables aren't the right tool there.
Would it be possible when you get your bank statement to do reconciliation? Like enter Balance on statement and mark cleared checks.
Thank you!
Isn't is better that the first row shows balance only, then putting the formula in the next rows, instead of adding a new table of starting balance?
I wouldn't say it is better. Then you have a row that is different than your other rows. It isn't a transaction at all. Doing something like counting the rows (to count the number of transactions) would be off by 1. And it doesn't look as nice.
That’s the way I’ve been doing it for years, in Excel. I was hoping to find a better way because I keep a rolling balance and remove the rows after they’ve cleared my bank account. I don’t care about keeping the history. Instead, I just wanted to make sure I wasn’t forgetting a payment was already being made, thus causing me to have an overdraft. I no longer really *need* that but I still like to keep up with it in a spreadsheet. I guess I’ll keep on doing it the old way, but now I’m using Numbers on my iPad.
GREAT VIDEO!! I’ve been trying to figure this out on my own, and going nuts! Is there a way to add a dividend column, and if so, how would that be accomplished?
Good afternoon Gary, this was a great video on setting up a basic checkbook register. In numbers is there a way to be able to Reconcile the checkbook using the formulas. Do you have a video on this or could you point me in a better direction. Don't want to use Quick Books or any other expensive software for my small business teaching CPR..... Dave
I think most of the work of "reconciling" is what I am showing here, right? Not sure what else you would need. If you want to see if the totals in your spreadsheet match the totals in a statement, I suppose you could select those cells and see the sum of them to check.
Thanks ... if you think it's like excel ... the user interface is a LOT different. Thanks for the help ...
Thank you so much, kind Sir!
This was very helpful. How do I clear the cells without erasing the formulas
Do you mean erase the cells with values and keep the cells with formulas? You just have to select the cells that you want to erase and clear them.
@@macmost yes. I think I was highlighting the entire table including the cells that auto calculated below the heading instead of the tables where I actually entered data. Thanks!
Thank you very much for this incredible presentation but i would like to know if you can please make a presentation on how to do the same for multiple account such as credit card or if you have 3 or more different accounts thanks.
You could do each as a separate table on a separate sheet. Or, you could put it all on the same sheet with a column for "account" and then put the account name in that cell. Then you can filter by account to only see one account at a time.
Great job.
I created a spreadsheet very similar to this but created a Category column for budgeting. I’m having trouble figuring out how to create a Dashboard table the shows the Unique List of Categories and their summed values based on a date range. Do you have a video that may pulls unique values from a column? Thanks for all your videos!
Thank you Thank you!!
That’s a great tutorial thank you, now a request, can you make a tutorial on how to email a large file through the icloud? Thanks
Hi Gary! I assume in the first column if you wanted to you could make that a drop down menu so you could enter in a eft or a Mac card or a transfer?
Of course. Or, just leave it as text and use the Numbers autocomplete feature.
macmostvideo thanks Gary! I suppose if one desired you could also make individual columns for each too but that I think might lead to a wider spreadsheet lol!!! Not really ideal
YOU just gave me my sanity back. I wasn't able to get excel to work for me.
Great Video! Thank you! If you enter in date that is not sequential by date, and then sort by date, will the running balance automatically adjust so that all balances are correct? I had issues with this in Excel and it took me a while to find the formula to correct this. Thank you!
Thanks man.
Appreciate if you could go a bit slowly. Thank you. You are awesome 😃
Your name may not be a Harry, but you're definitely a wizard. Thanks for the help!
In this spreadsheet, is there a way to use a filter to see what you're spending on a particular category or type? For budgeting purposes?
Yes, use Smart Categories for that. ua-cam.com/video/Xv5kUn4o1ss/v-deo.html
Hi thank you for this lesson. I’ve been using it for over a year and it works really well. But I’ve run into a problem I can’t solve. Randomly, the sheet has hidden some rows. The rows still show in the formula above and below but when I try to ‘unhide’ the row, that option isn’t available, only hide. I tried hide anyway of the row above and then ‘unhide all rows’ but it still wouldn’t reveal the hidden row. It is noted in the row number column with a tiny thin double line and the number skips from row 385 to 387. Can you help me solve this? Thanks so much
I wrote to you and then I figured it out - I had a filter of a bunch of numbers on. Hmm I’ve been trying to figure it out for quite awhile. You even channel good info 🤣 I’ll keep watching for other Mac tips. Thanks much
Thank you. I have tried to move away from Google Sheets and on to Numbers so many times. I just can't figure number out, apart from the sum function, how it works.
Would be nice if you added a "Current Balance" next to starting balance on the top - for easy viewing/reading
what if you already created a separate expenses list in a different table and different numbers file for each month? how to combine them quickly without adding row 1 by 1 and copy + paste the data 1 by 1?
Do you have a video with correlating the check book with the business expenses?
You'll need to define exactly what you mean by that. Correlating in what way? What is it you are trying to DO, exactly?
@@macmost the video you created for the business expenses, can you create a model with the business expenses, the summary, and how each expense was withdrawn from the checking. I guess possibly a third sheet. So when you put in a category, rent let’s say, and it calculates that expense on the business portion, can it also coordinate the expense when entered in as a check?
@@AquaSourceLLC Just add a column for "method" or something like that and put "check" in there. Add as much information as you need to the table by including more columns.
@@macmost I’ll see if I can figure it out. I want the checkbook, expense sheet, and summary sheet all on one document
how to make the monthly recurring expense automatically added every month?
so that we don't have to type it manually every month
(such as software/app subscriptions, insurance premium, bank admin fee, etc)
Why does my account in numbers open to the first entry making it necessary to scroll down to the cell I want to use? This was not always true, but seems to be happening since the last update. Is there a setting to open the spreadsheet to the last entry?
I haven't noticed a change. There is a spreadsheet I open every day and it always starts at the bottom with my last selection.
macmostvideo I’m stymied by this change for me. It opens the same way on both my iPad and my Mac Pro laptop. It’s irritating and I’d like to change it back if it is somehow a setting in Numbers.
I really appreciate the effort however I was unable to use it for my checking account, I feel really stupid because I deleted the numbers to put my account information in and it doesn't work. I saved it as a template but it had all the numbers from the video, I suppose that it's just for educational purposes. I wonder if I should try another tutorial. I used linux os and libre office before but I've had no success with a macbook opening it. Thanks anyway.
I'm looking for a way to project an estimate of future account balance by entering recurring withdrawals and deposits (monthly, annually etc). Can this be done with Numbers. Or is there maybe an app for that?
Seems like simple math to me. Not sure of exactly what you want, but Numbers should be able to handle it.
@@macmost I'd like to estimate the future balance of a bank account, ideally as a graph, given the current balance and the recurring expenses. Like this app does: ua-cam.com/video/dQsynp4XJ24/v-deo.html just not for the slightly overheated price of $28. Maybe stuff for a future episode?
I think it's important to say that you need to add the row of information with tab and treat it like a record. When I first created my prototype I entered numbers down each column. When I copy and pasted the formula in F3:F9 it broke I got formula error. Maybe you did that at the beginning but I missed it.
How can I save a custom made template with all my heading and formulas installed so that I can start fresh each time and just plug in numbers? Thanks
Create your template, then choose File, Save As Template.
Can I set up recurring payments to automatically fill in on a specific date?
Copy and paste? There's no way to have new rows "automatically" be created or anything like that.
Please explain how this will be created on an iPad
Cyndi Feeney, the process would be very similar, with the additional advantage that you can add a form to make data entry easier.
Can you reconcile with this spread sheet?
You can build it any way you want and perform calculations any way you want. Continue to learn and experiment in Numbers and you can create a custom system that works just how you want it.
When I hit return after setting up my one time formula in the Balance Row I get an error message, "The operator “-” expects a number, date, or duration, but cell D1 contains a string.
Why is this? Thank you! I should add I'm new to Macs.
What do you have in D1 then? If it is a number, like 123, then make sure the cell format is set to Automatic or a number format, not text.
Thank you, that solved the problem. Much appreciated!
Hello. I'm new to spread sheets, so I need it broken down. Instead of identifying a specific cell, can a formula use the "cell above" instead of a named cell. In my case, I built a spreadsheet containing all reoccurring expenses and deposits for the month. But, now that I'm adding new rows in between, the math is wrong. Instead of identifying a cell name (like C2), is there a way to say "Cell Above"?
Cell references in spreadsheets are either absolute or relative. By default they are relative. So lets say C2 holds the value 42. If you put a formula is D2 that is =C2+1 then D2 shows 43. If you put the value 100 in C3 and then copy and paste the formula in D2 into D3, that pasted formula now shows =C3+1 instead of =C2+1. It changes relative to where it was put. So if you make a formula in cell G7 and want to refer to the cell above, then just use =G6. That IS a reference to the cell above. If you were to move or copy that formula to H45, it would become =H44. See ua-cam.com/video/KZJ8KqV0rPg/v-deo.html
How can I set up recurring payments or deposits to automatically fill in on a specified date?
When I hit enter on the balance everything keeps disappearing. What do I do?
cool
If I add row in above and entry receivd or payment , sum not auto update . what to do ?
Make sure your SUM formula is correct. It should refer to the column, not a range of cells.
@@macmost My function is like that : =sum(e3+deposit-withdraw) , when I insert row above and enter my amount in deposit / withdraw , the balance amount not autoupdate, insert rows amount and next below rows amount shows same balance amount , not update.
@@satyajitdas9509 That formula doesn't look right. Inside the SUM function should be a column name, not anything with a +.
This formula breaks for me if I insert a row or delete a row (sometimes due to a duplicate entry because I didn't realize I already entered something or the date from receipt didn't match an entry from the bank). If I insert a row the rows below do not properly update and if I delete a row, I get a #REF error and have to manually update the balance entry to point to the correct cell and then the rest update. Weird.
Update: Solved it by using the OFFSET function. It only took me 5 hours to discover this and get it to work.
I want to add a column with pop up items to categorize my withdrawals so I can pie chart them
You can. You just have to use formulas or a pivot table to do the calculations, then produce a pie chart from that.
Isn’t there a temple for this?
A template? No, but there are some similar things. Still, the idea here is to learn how to create one.
My comment wouldn't post, trying again, sorry if it duplicates it. In this example you gave your F10 shows your running balance at the end. How do I copy that result to another sheet but for it to keep my other sheet updated after I add another row? I got it to copy F10 but when I add another row for another expense it keeps showing F10 results. I want my running balance to stay updated on my budget sheet, if it makes sense.
Put a simple formula. Type = to start a formula. Then, click on that cell in the other sheet to add a reference to that cell. It may look something like Sheet 1::Table 1::F10
I did that, and it works and shows that cell but when I go to the original one and add a row for a new charge then the second sheet still shows F10 and doesn’t update to what would now be the balance on F11
@@melidalatigo7130 Make sure that is shows "F10" and not "F$10" as the cell reference. Or, is it that you have 10 rows and you always want it to point to the last row? So F10 is still F10, but now you want it to point to F11?
Yes, I want it to always show the “last row” and the checkbook will go on for a long time then I want the newest balance to always be reflected
@@melidalatigo7130 You need to use INDEX to get the value of a cell references like that. Use ROWS inside that to get the number of rows in the table.