You gained almost 30K subscribers in only about two years. Why? Because you are a REALLY good teacher. WHatever you are doing right now, I hope you are continuing to help others learn. You were born for it!
I don’t ever leave comments, but I wanted to let you know how much I appreciate your teaching technique. You make it very easy to understand and follow!
Ive been looking for a LONG time on a SIMPLE way of just keeping the books at my incredibly simple business. This is MONUMENTALLY helpful, and im convinced, the best in all the internet. THANK YOU!
You can make your formulas on the P&L sheet much easier by using this: sumif(Transactions!D$2:D$1000,A8,Transactions!C$2:C$1000). Rather than having to paste the text into each sumif statement you simply use the text that's already in the cell next to it. This formula takes advantage of the $ symbol to tell google sheets NOT to update that particular part of the formula as you copy it down the column. Each one starts at D2 and ends at D1000 while the A8 will change to A9, A10 and so on as you duplicate that down the column.
Do you think a series of short (3 minute) videos on formulas would be useful? Easier than what I provided in this video, or harder? Thank you for your input :)
@@RealisticBookkeeping OMG, yes, 3-minute videos are great to master one or two tasks then on to the next video. Plus small videos like these are easier to come back to and watch without having to watch at 10-30 video to find exactly what I was looking for.
Thank you! This is a true treasure. Been sitting a couple of days trying to figure out how to do this all over RUclips, since I'll be starting a small business. Finally I have something i can use and understand. Thank you!
Thank you so much for posting this. As a farmer I need something simple to use and can't afford a full Bookkeeper until things are in full swing at our farm. We have spent thousands of dollars on expensive bookkeeping when we were barely making a penny. This system has helped us immensely. Thank you again for posting this. Looking forward to watching the rest of your videos.
Hello. I remember viewing your video a few years ago when I was first thinking about creating a small business. I ended up not starting my new business as I was offered a W-2 position. But recently, I was approached by a potential client so I'm once again thinking about starting a small business. I've been scrambling doing a search on my computer with this video information as I thought it was and is one of the best bookkeeping videos for beginners. I finally found your video! Thank you!
Thank you so much for taking the time to make this detailed video. I am a new business owner; and this information is a lifesaver. I really appreciate you!!
OMG😮. This video came right on time. I am a culinary instructor and I am working on profit & loss statements with students. This is going to be a game changer when they can visualize the amount of money spent on “employee meal” compared to actual sales.
I'm a new small business owner, so I have to learn and understand the basics. Thank you for taking the time to make these videos. Learning is much easier the way you explain things. Much appreciated!
I looooove the way you explain things thank youuuuuu! Finally somebody is talking simple bookkeeping 🥰🥰🥰 Pls keep posting & don’t change your style 🙏🏼🙏🏼🙏🏼
What an incredible yet free resource you have offered. Thank you for making a seemingly daunting task for so many small business owners very achievable!! You are a blessing!
This was AMAZING. I'm a SAHM trying to learn how to do my husband's bookkeeping and also hopefully start my own bookkeeping business soon. I'm taking QBO's ProAdvisor training right now, but with the limited time that I have to go through the courses, I needed something that would allow me to start managing my husband's books until I actually learn QBO better. I think this is it! Thank you so much for the time and effort to make this sheet and the video and for making this a FREE RESOURCE that I can customize as I need. Subscribed for the future for sure!!! God bless.
I'm a small business owner. I have been searching for a simple format, AND YOU DID IT. I love your energy and the way you explained the process. This is so helpful, this is exactly what I needed. I'm so happy to have found you. Thank you so much!
I started a small business last year in OCTOBER, and I've been ignoring bookkeeping for way too long. I still have a long way to go but this was very helpful . I at least got something started, Thank you.
This is so helpful, I literally started crying because this is just what I needed. I am a business owner that needs systems like this to set me up for success. Thank you so much😄!!
This is exactly what I was looking for. Im so sick of the stress using Quickbooks and dealing with their unfixable glitches and terrible customer support! Thank you!
Hey Realistic Bookkeeping, I cannot thank you enough for this video. I started my ebay store in June and with your step by step vid, I was able to enter all transactions and P/L sheets. I'm up to date and I have a Birds eye view of my finances. Two thumbs up :)
Thank you so much! I am a small business owner. I haven't exactly been on top of my bookkeeping. This is actually getting me excited to do my bookkeeping. I cannot thank you enough!!
fking finally. Every bookkeeping tutorial I have found so far was about like very basic tips and constantly referred to quicken or w/e always some kind of software. Since I started my business it's like there are a million things all trying to charge you a monthly fee, and it's at the point where I'm paying so many damn fees It's difficult to even make a profit. So this I NEED to do myself lol. Sheets seems like a viable solution. Yeah it'll take me a solid day or 2 to go through all the statements and everything to get the data, but if I can start doing it on a monthly basis, shouldn't take too long.
This was absolutely the best explanation ever. And I must also thank the lady who said she followed the video as I ended not just watching but following the steps and paused when I needed to. Absolutely easy to understand even for a total beginner.
Rachel - You are awesome! I've learned so much from your simple approach to bookkeeping. This idea is perfect for my small business clients who don't need the bells and whistles of Quickbooks.
OH MY GOSH! You are a life saver. Thank YOU! My quickbooks expired and they wanted me to pay $650 to upgrade to the latest version...but we don't have our complicated businesses anymore. Just my author business. This will save me so much money...and time. Thanks again!
THIS! THIS IS THE VIDEO I'VE BEEN LOOKING FOR A MONTH FOR! Thank you so much for this video. All of the videos I've watched have been so confusing. You are truly amazing at explaining these things where beginners are truly able to understand. I know this video is 2 years old, but I hope you start making more videos like this🙏.
Hello, You are my nr. 10 bookkiping video and yours is the best. Why? Because you are not advertizing anything, you are not asking fo peoples emails and you are very good teacher. Bookkiping is not easy for a person who doesn't know or understand spread shieets and bookkiping for that matter. Thank you for being so transparent and knowledgeble of what you do. Keep up the good work. You are appreciated.
@Rachel Brown aka Realistic Bookkeeping PHENOM!!! You. Are. Straight. FIYAH! Laughing, literally smiling for the answered prayer you have just brought my way! I hope you make many more videos and take that request to offer a paid course seriously! Udemy would be BLESSED to have you! Also, please don't miss your customer base forming right before your eyes...when the entrepreneur is ready her customers appear!!!
THANK YOU!!!!!! I started operating a trucking business this year, subscribed to QuickBooks Bookkeeping, but I did not like it, to complicated to use. I was doing my own thing with spreadsheets, but knew I was not doing it right. I don't have any experience with bookkeeping. But thank God your video came across my search on RUclips. I will totally use your template and of course I will watch more of your videos. THANK YOU SO MUCH, for sharing your knowledge and helping us, that don't know where to start. Hope to find videos that teach more about bookkeeping, end of the month and end of year. Not sure if we need to do something specific.
I recommend going into formatting and using alternating colors for rows to help see things easier. Data validation input has also changed and they made it easier. It pulls up on the right hand side and has advanced options for color coding and style of drop down menu etc. plus IF THAN rule options. This has helped me so much! I just wanted to give a couple of pointers.
Thank you so much for this video! I am reopening my shop after closing it in 2022 due to the stresses of doing all this work! I avoided it & i took this time off to learn how to properly book keep for my business. You are amazing, you've been a great tool for my success. THANK YOU!!!!!!
By WAYYYY FAR the very best video explaining basic bookkeeping, as well as using Excel. As as artist, we are notoriously known for NOT being numbers people. I got the bright idea I was going to prepare my own spreadsheets for my '22 taxes. The stress has literally been keeping me up nights. Even though I recently starting learning to use Excel it's been confusing to me. Today I stumbled across your video and feel like I hit the jackpot! My spreadsheet brain fog is suddenly starting to clear up with just 1 short video. You have an amazing gift for cutting through the geek-speak to provide instant clarity to 'the rest of us'. Thanks so much for sharing your time and expertise. I'm a new subscriber and a fan!
I would say that you are a great teacher. I was a Bookkeeper for years in Canada but when I arrive in the USA I was lost in translation and I couldn't keep up. I am now trying to get my High school diploma and learn my English better to be able to learn the proper "Wording" so I can be a bookkeeper again. Thank you so much for all the information you are giving us today.
After closing 2 businesses due to covid and using online accounting software, I am trying to open a home baking business and didn't want to pay the subscription fee for the online accounting software. I wanted to keep things simple for my micro business. I had started a google spreadsheet on my own but would have been limited in functions because I didn't know how to put them in. You are saving me time and money and the way you explained it was so simple. Thank you for the template! I can't wait to start setting it up to fit my needs. Thank you for explaining all this in less than 20 minutes! You made it so easy to understand! The profit and loss statement will be very useful at the end of the year! Thank you so much!
That's what I'm talking about: straight to the point, no fluff, clear and well-thought-out instructions. I AM LOVING IT . You just won a new subscriber
Dear Realistic Bookkeeping, I can not thank you enough for your videos. They have been the most helpful and easy to understand and get ready for tax season. Well done
This video was exactly what I needed to take control of my business bookkeeping confidently! I am so happy that I found your channel!! Thank you for sharing!
This is Awesome, i used it to give my kids mom the chance to play with some figures to try and motivate her to move forward with her small business idea. its simple enough to make and pass on to someone without them having to be technical. thank you
Thank you, we're starting a B&B, I know excel but not bookkeeping, I've looked at other videos, you are by far the most, clear and concise of them all.
If I could "thumbs-up" twice (or more!) I certainly would. I'm looking to escape the grasp of QB & this simple bookkeeping is just what I think I need to do next. Thank you!
Thank you, Rachael, for this video! Really, as a senior citizen it was one I could follow, it gives me what I need, simply enough, and although I had to figure it out on Excel, I’m still grateful for the setup. You are a great teacher. Wish you’d carried on with these, but I know how hard it is as I’m trying to keep up with my own channel. Thanks again.
One of the BEST intro to a spreadsheet I have seen! I’m sharing this with my high school grandsons to see if this will help them manage their money! THANK YOU!
This was extremely helpful!!! It is so hard to go from a tax accountant to a bookkeeper. Seems like night and day differences. Videos like this are very much appreciated!!! Thanks again for sharing!
This is so helpful, I literally started crying because this is just what I needed. I am a business owner that needs systems like this to set me up for success. Thank you so much!!
Thank you so much. I have lost sleep worrying about how to calculate my contractor pay tax fees. A simple spreadsheet is what I needed and thank you for this video and spreadsheet.
Your explanation and example for sumif was so clear and it was exactly what I was struggling with. I now have an Income statement tab that feeds off other tabs and is always up to date. Thank you so much, I am a fan!!!!
I think you have no idea of how much value you gave me today. I’ve just found you and I immediately fell in love with your way of teaching this. I truly appreciate it. I’m already subscribed and will continue learning from you 🥰. Thank you so much!
Thanks for your teaching. I am from India. I never watch the video of other country people. But fist time i watch your your video from the beginning to end. This may be the charity of your video or its my favourite topic. I will go for your another videos. Love your teaching
This is so awesome! I am so glad I found you! I have been on YT searching for ways to make QB do the things I want it to do for my small business and was just getting more and more frustrated. Now I will be able to search invoices by customer name and this way is so much more user friendly. Now I will be saving $85 month by cancelling QB. Thank you! Thank you! Thank you!
Can I add my 2 cents? An alternative to doing the sum as suggested, you can use Sum(c:c) to add any amount on column c so you don't need to adjust the range. Great video!
You could also make the range dynamic by using a count function i.e. sum(c2:c&count(c:c)). The other thing would be to use named ranges so it is easier to read.
Thank you! This was easy to follow and helped simplify bookkeeping. Other videos made the process feel super complicated and confusing, and you were so clear. Thank you, again. I appreciate you!
Thank you for this video. It made this crystal clear for me. I love this type of video outlining exactly what you can do to organize the books. More hands on tutorials are requested by me and I'm sure other as well. Keep up the good work and May continue to bless you and your family. 💟
I really appreciate you sharing this template! This is my first year opening my own business and was really nervous about bookkeeping but you've made it so easy and organized!!!!
Thank you so much for your generosity in creating this template. I am starting to do my own bookkeeping for my business and this is exactly what I needed.
This is the best thing ever! Thank you so much for taking the time to do this! I was Excel illiterate, now not so much :) Thank you thank you thank you!
GREATFUL!! Thank you so so so much for making this video Realistic Bookkeeper! I just started my online store, and I don't know where and how to start in bookkeeping, grateful for your video!! Super thank you!
Great video! Clear and to the point. I just did a Skill Success class and your video was extremely better. Thanks! Can't wait to watch your other videos.
Thanks for the video. I have just become treasurer for a small non-profit, and I believe I will use your template pretty much as is, at least to start. The previous treasurer just passed away, and he did everything on paper, so this should help me get started.
![Accounting Spreadsheet [Excel Template] Create it in 15 minutes](http://i.ytimg.com/vi/k8VGb21kjAU/mqdefault.jpg)
![BLACK BAG - Official Trailer [HD] - Only in Theaters March 14](http://i.ytimg.com/vi/Du0Xp8WX_7I/mqdefault.jpg)
You gained almost 30K subscribers in only about two years. Why? Because you are a REALLY good teacher. WHatever you are doing right now, I hope you are continuing to help others learn. You were born for it!
I don’t ever leave comments, but I wanted to let you know how much I appreciate your teaching technique. You make it very easy to understand and follow!
Ive been looking for a LONG time on a SIMPLE way of just keeping the books at my incredibly simple business. This is MONUMENTALLY helpful, and im convinced, the best in all the internet. THANK YOU!
You can make your formulas on the P&L sheet much easier by using this: sumif(Transactions!D$2:D$1000,A8,Transactions!C$2:C$1000). Rather than having to paste the text into each sumif statement you simply use the text that's already in the cell next to it. This formula takes advantage of the $ symbol to tell google sheets NOT to update that particular part of the formula as you copy it down the column. Each one starts at D2 and ends at D1000 while the A8 will change to A9, A10 and so on as you duplicate that down the column.
Thanks! Great point
Excellent idea, thank you
thank you so much. I was actually getting an error but with your way it worked :)
What's p&l?
@@robinsonmedina9013 profit & loss
Yass! You should do a series of Excel for bookkeepers. You are a great instructor. I love that you are quick and simple , no fluff just facts.
Do you think a series of short (3 minute) videos on formulas would be useful? Easier than what I provided in this video, or harder? Thank you for your input :)
@@RealisticBookkeeping OMG, yes, 3-minute videos are great to master one or two tasks then on to the next video. Plus small videos like these are easier to come back to and watch without having to watch at 10-30 video to find exactly what I was looking for.
@@StarChaires Good evening friend
I have a spreadsheet for that
Thank you! This is a true treasure. Been sitting a couple of days trying to figure out how to do this all over RUclips, since I'll be starting a small business. Finally I have something i can use and understand. Thank you!
Thank you so much for posting this. As a farmer I need something simple to use and can't afford a full Bookkeeper until things are in full swing at our farm. We have spent thousands of dollars on expensive bookkeeping when we were barely making a penny. This system has helped us immensely. Thank you again for posting this. Looking forward to watching the rest of your videos.
Hello. I remember viewing your video a few years ago when I was first thinking about creating a small business. I ended up not starting my new business as I was offered a W-2 position. But recently, I was approached by a potential client so I'm once again thinking about starting a small business. I've been scrambling doing a search on my computer with this video information as I thought it was and is one of the best bookkeeping videos for beginners. I finally found your video! Thank you!
Thank you so much for taking the time to make this detailed video. I am a new business owner; and this information is a lifesaver. I really appreciate you!!
OMG😮. This video came right on time. I am a culinary instructor and I am working on profit & loss statements with students. This is going to be a game changer when they can visualize the amount of money spent on “employee meal” compared to actual sales.
I'm a new small business owner, so I have to learn and understand the basics. Thank you for taking the time to make these videos. Learning is much easier the way you explain things. Much appreciated!
I looooove the way you explain things thank youuuuuu!
Finally somebody is talking simple bookkeeping 🥰🥰🥰
Pls keep posting & don’t change your style 🙏🏼🙏🏼🙏🏼
What an incredible yet free resource you have offered. Thank you for making a seemingly daunting task for so many small business owners very achievable!! You are a blessing!
This was AMAZING. I'm a SAHM trying to learn how to do my husband's bookkeeping and also hopefully start my own bookkeeping business soon. I'm taking QBO's ProAdvisor training right now, but with the limited time that I have to go through the courses, I needed something that would allow me to start managing my husband's books until I actually learn QBO better. I think this is it! Thank you so much for the time and effort to make this sheet and the video and for making this a FREE RESOURCE that I can customize as I need. Subscribed for the future for sure!!! God bless.
I'm a small business owner. I have been searching for a simple format, AND YOU DID IT. I love your energy and the way you explained the process. This is so helpful, this is exactly what I needed. I'm so happy to have found you.
Thank you so much!
may i know whts ur business about?
I started a small business last year in OCTOBER, and I've been ignoring bookkeeping for way too long. I still have a long way to go but this was very helpful . I at least got something started, Thank you.
Love it! You have simplified all transaction recording instead of having tonnes of ledger accounts, thank you girl
I literally made my spreadsheet while following along! I just paused as I went. Soooo incredibly helpful! Thank you!!!
This is so helpful, I literally started crying because this is just what I
needed. I am a business owner that needs systems like this to set me up for success. Thank you so much😄!!
I appreciate the simplicity of how you are explaining the content, because there are ppl like me that have no clue about bookkeeping. Thank you!
This is exactly what I was looking for. Im so sick of the stress using Quickbooks and dealing with their unfixable glitches and terrible customer support!
Thank you!
Hey Realistic Bookkeeping, I cannot thank you enough for this video. I started my ebay store in June and with your step by step vid, I was able to enter all transactions and P/L sheets. I'm up to date and I have a Birds eye view of my finances. Two thumbs up :)
Thank you so much! I am a small business owner. I haven't exactly been on top of my bookkeeping. This is actually getting me excited to do my bookkeeping. I cannot thank you enough!!
❤️
fking finally. Every bookkeeping tutorial I have found so far was about like very basic tips and constantly referred to quicken or w/e always some kind of software. Since I started my business it's like there are a million things all trying to charge you a monthly fee, and it's at the point where I'm paying so many damn fees It's difficult to even make a profit. So this I NEED to do myself lol. Sheets seems like a viable solution. Yeah it'll take me a solid day or 2 to go through all the statements and everything to get the data, but if I can start doing it on a monthly basis, shouldn't take too long.
This was absolutely the best explanation ever. And I must also thank the lady who said she followed the video as I ended not just watching but following the steps and paused when I needed to. Absolutely easy to understand even for a total beginner.
Rachel - You are awesome! I've learned so much from your simple approach to bookkeeping. This idea is perfect for my small business clients who don't need the bells and whistles of Quickbooks.
OH MY GOSH! You are a life saver. Thank YOU! My quickbooks expired and they wanted me to pay $650 to upgrade to the latest version...but we don't have our complicated businesses anymore. Just my author business. This will save me so much money...and time. Thanks again!
THIS! THIS IS THE VIDEO I'VE BEEN LOOKING FOR A MONTH FOR! Thank you so much for this video. All of the videos I've watched have been so confusing. You are truly amazing at explaining these things where beginners are truly able to understand. I know this video is 2 years old, but I hope you start making more videos like this🙏.
Hello,
You are my nr. 10 bookkiping video and yours is the best. Why? Because you are not advertizing anything, you are not asking fo peoples emails and you are very good teacher. Bookkiping is not easy for a person who doesn't know or understand spread shieets and bookkiping for that matter. Thank you for being so transparent and knowledgeble of what you do. Keep up the good work. You are appreciated.
@Rachel Brown aka Realistic Bookkeeping PHENOM!!! You. Are. Straight. FIYAH! Laughing, literally smiling for the answered prayer you have just brought my way! I hope you make many more videos and take that request to offer a paid course seriously! Udemy would be BLESSED to have you! Also, please don't miss your customer base forming right before your eyes...when the entrepreneur is ready her customers appear!!!
your comment is so sweet. It is my first time to the channel but I feel you
THANK YOU!!!!!! I started operating a trucking business this year, subscribed to QuickBooks Bookkeeping, but I did not like it, to complicated to use. I was doing my own thing with spreadsheets, but knew I was not doing it right. I don't have any experience with bookkeeping. But thank God your video came across my search on RUclips. I will totally use your template and of course I will watch more of your videos. THANK YOU SO MUCH, for sharing your knowledge and helping us, that don't know where to start. Hope to find videos that teach more about bookkeeping, end of the month and end of year. Not sure if we need to do something specific.
I recommend going into formatting and using alternating colors for rows to help see things easier. Data validation input has also changed and they made it easier. It pulls up on the right hand side and has advanced options for color coding and style of drop down menu etc. plus IF THAN rule options.
This has helped me so much! I just wanted to give a couple of pointers.
I have been searching high and low for a simple bookkeeping explanation on excel, and this video was so helpful and easy to learn! Thank you!!
Thank you so much for this video! I am reopening my shop after closing it in 2022 due to the stresses of doing all this work! I avoided it & i took this time off to learn how to properly book keep for my business. You are amazing, you've been a great tool for my success. THANK YOU!!!!!!
By WAYYYY FAR the very best video explaining basic bookkeeping, as well as using Excel. As as artist, we are notoriously known for NOT being numbers people. I got the bright idea I was going to prepare my own spreadsheets for my '22 taxes. The stress has literally been keeping me up nights. Even though I recently starting learning to use Excel it's been confusing to me. Today I stumbled across your video and feel like I hit the jackpot! My spreadsheet brain fog is suddenly starting to clear up with just 1 short video. You have an amazing gift for cutting through the geek-speak to provide instant clarity to 'the rest of us'. Thanks so much for sharing your time and expertise. I'm a new subscriber and a fan!
I would say that you are a great teacher. I was a Bookkeeper for years in Canada but when I arrive in the USA I was lost in translation and I couldn't keep up. I am now trying to get my High school diploma and learn my English better to be able to learn the proper "Wording" so I can be a bookkeeper again. Thank you so much for all the information you are giving us today.
Wow... This is AWESOME! As a clueless startup small business owner you have brought me GOLD! Thank you so much!
I love love love google sheets. I use it to track my personal budgets and it’s actually what got me interested in becoming a bookkeeper.
Same! I actually just made a video on using Google Sheets for personal budgeting!
After closing 2 businesses due to covid and using online accounting software, I am trying to open a home baking business and didn't want to pay the subscription fee for the online accounting software. I wanted to keep things simple for my micro business. I had started a google spreadsheet on my own but would have been limited in functions because I didn't know how to put them in. You are saving me time and money and the way you explained it was so simple. Thank you for the template! I can't wait to start setting it up to fit my needs. Thank you for explaining all this in less than 20 minutes! You made it so easy to understand! The profit and loss statement will be very useful at the end of the year! Thank you so much!
That's what I'm talking about: straight to the point, no fluff, clear and well-thought-out instructions. I AM LOVING IT . You just won a new subscriber
Dear Realistic Bookkeeping, I can not thank you enough for your videos. They have been the most helpful and easy to understand and get ready for tax season. Well done
This video was exactly what I needed to take control of my business bookkeeping confidently! I am so happy that I found your channel!! Thank you for sharing!
I finally sat through my first excel video tutorial. This was done very nicely.
This is Awesome, i used it to give my kids mom the chance to play with some figures to try and motivate her to move forward with her small business idea. its simple enough to make and pass on to someone without them having to be technical. thank you
Thank you, we're starting a B&B, I know excel but not bookkeeping, I've looked at other videos, you are by far the most, clear and concise of them all.
If I could "thumbs-up" twice (or more!) I certainly would. I'm looking to escape the grasp of QB & this simple bookkeeping is just what I think I need to do next. Thank you!
Me too - been using QB for years and now I'm out of there with the charges and inability to buy a package once!
You are a GOD send. Your clarity, pace, simplified teaching skills, and expertise is amazing! Thank you.
Thank you, Rachael, for this video! Really, as a senior citizen it was one I could follow, it gives me what I need, simply enough, and although I had to figure it out on Excel, I’m still grateful for the setup. You are a great teacher. Wish you’d carried on with these, but I know how hard it is as I’m trying to keep up with my own channel. Thanks again.
One of the BEST intro to a spreadsheet I have seen! I’m sharing this with my high school grandsons to see if this will help them manage their money! THANK YOU!
This was extremely helpful!!! It is so hard to go from a tax accountant to a bookkeeper. Seems like night and day differences. Videos like this are very much appreciated!!! Thanks again for sharing!
You're so welcome!
This is so helpful, I literally started crying because this is just what I
needed. I am a business owner that needs systems like this to set me up for success. Thank you so much!!
Thank you so much. I have lost sleep worrying about how to calculate my contractor pay tax fees. A simple spreadsheet is what I needed and thank you for this video and spreadsheet.
Your explanation and example for sumif was so clear and it was exactly what I was struggling with. I now have an Income statement tab that feeds off other tabs and is always up to date. Thank you so much, I am a fan!!!!
Thank you! Exactly what I needed and love the teaching style. I actually understood what was going on. Can’t wait to see more!
You are so welcome! I'm glad my teaching background came through in this video :)
@@RealisticBookkeeping one of the best tutorials
Good evening friend
You are a gifted teacher. Very easy to understand.
Thanks Rachel. 'Sumif' that i learned now is going to take my sheets to the next level.
Thank you so much for this video. May god return what you do for people, and create an abudance of wealth for you and your next generations to come.
Rachel, this is extremely helpful. I agree with everyone else's assessment. You're a great instructor. Thanks
I think you have no idea of how much value you gave me today. I’ve just found you and I immediately fell in love with your way of teaching this. I truly appreciate it. I’m already subscribed and will continue learning from you 🥰. Thank you so much!
You explained it like mother explain to children, really appreciated.thank you. Jaana.
Data validation is much more simpler in Google Sheets, thank you for this.
WOW. I'm not a tech person at all, so I really appreciate how easy you make this to understand. Thanks so much!!
BEST teacher ever. You explain very well and made it so easy. Thank you
Thanks for your teaching. I am from India. I never watch the video of other country people. But fist time i watch your your video from the beginning to end. This may be the charity of your video or its my favourite topic.
I will go for your another videos.
Love your teaching
This was absolutely revolutionary for me. Thank you! You have made me far less fearful about doing my taxes and getting my finances on lock. :)
This is so awesome! I am so glad I found you! I have been on YT searching for ways to make QB do the things I want it to do for my small business and was just getting more and more frustrated. Now I will be able to search invoices by customer name and this way is so much more user friendly. Now I will be saving $85 month by cancelling QB. Thank you! Thank you! Thank you!
OH MY GOODNESS!!! You have an amazing way of wording things to where I can understand. I thank you so very much!!
You honestly have no idea how you have saved me with this video! Thank you
I usually dont leave comment but i really like how u show and explain things here. thank you for your effort and generosity.
BEST tutorial!!! You’re an amazing teacher! This was so valuable to my small business, thank you so much!
Wow!!!!!!! This is such a blessing for me as I am trying to launch a new business! THANK YOU!
Can I add my 2 cents? An alternative to doing the sum as suggested, you can use Sum(c:c) to add any amount on column c so you don't need to adjust the range. Great video!
Thanks was wondering about that as I watch. Great video, do your household expenses and you’ll really see where you spend!
You could also make the range dynamic by using a count function i.e. sum(c2:c&count(c:c)).
The other thing would be to use named ranges so it is easier to read.
Thank you! This was easy to follow and helped simplify bookkeeping. Other videos made the process feel super complicated and confusing, and you were so clear. Thank you, again. I appreciate you!
Thank you so much for making this EASY to follow tutorial. You've changed my life.
Thank you so much for this!! Can’t wait to watch more! Great info!
Thank you for explaining the Google sheet using your Bookkeeping method. Much appreciated!
You are genius. Reading the minds of new business owner's needs. A big thank you.
Thank you so much. You are a brilliant presenter - clear, concise, authoritive. I look forward to seeing more.
You are a LIFE SAVER. Love your easy method of talking
Thank you. You are an excellent teacher. I will use these sheets for my personal “Daily Spending Log”.
Thank you for this video. It made this crystal clear for me. I love this type of video outlining exactly what you can do to organize the books. More hands on tutorials are requested by me and I'm sure other as well. Keep up the good work and May continue to bless you and your family. 💟
Thank you for making it so simple! I'm not so scared to start now. THANK YOU! THANK YOU! THANK YOU! And your video editing was great!
I really appreciate you sharing this template! This is my first year opening my own business and was really nervous about bookkeeping but you've made it so easy and organized!!!!
Thank you, this is brand new to me, thank goodness you are the one teaching it. I can understand you and that's a miracle. Truth! Lol
Thank you so much for your generosity in creating this template. I am starting to do my own bookkeeping for my business and this is exactly what I needed.
😁 Thank you for posting your video and 'tool' download, so helpful. I'll be back to watch more of your videos!
This is the best thing ever! Thank you so much for taking the time to do this! I was Excel illiterate, now not so much :) Thank you thank you thank you!
I need this skills! You don’t know how much I appreciate you for sharing this with us. ❤
You're really good at this - thank you!
GREATFUL!! Thank you so so so much for making this video Realistic Bookkeeper! I just started my online store, and I don't know where and how to start in bookkeeping, grateful for your video!! Super thank you!
Great video! Clear and to the point. I just did a Skill Success class and your video was extremely better. Thanks! Can't wait to watch your other videos.
im so enchanted by your beautiful, cool, accounting help... and your eyes
Thank you for this video! Ive tried quickbooks and I’ve been using google sheets. I liked how you showed how to do the list in the data validation!
You’re making it so easy to understand. Thank you!
Thanks for the video. I have just become treasurer for a small non-profit, and I believe I will use your template pretty much as is, at least to start. The previous treasurer just passed away, and he did everything on paper, so this should help me get started.
Thank you for those great advises, especially the drop-down menu that helps to reduce the length of the sheet
This should have been an entire class at a University. Thank you very helpful! ❤
GREAT VIDEO!!! More please, amazing explanantion and tutorial :)
This is fantastic! I was looking at so many different videos and this one was the friendliest! Thank you soooo much for this info.
I love the way you explained everything.