I'm a beginner with Excel and it is my wish to learn on how to operate a simple cashbook using excel for quite awhile. Your video is excellent in this area for a beginner like me. Great many thanks!!
Your videos are so precise as a tutorial for beginners like myself I would love to havea copy or a macros one also. I am just starting a business and need lots of help with setting up a good system for keeping records. Excellent
Hi Karon, Glad it was helpful! The file you have requested can be obtained by following the guide in this video th-cam.com/video/m7Zf8_UWPGQ/w-d-xo.html 😊
What a nicely spoken man! Thank you for making this video. this one really helped me out. Can you please share this file with me? I'd really love to use your file as a sample to learn easily. Thank you so much again. 💚
Liked and subscribed! Thanks for this tutorial! I'm looking to make a balance sheet, cash flow statement, and Profit and Loss spreadsheet. Can you link to each of these if you've made them? Not ready for Quickbooks yet... so trying to create useful spreadsheets!
Very interesting. Presumably the addition of a VAT column (input and output) plus a bank balance brought/carried forward setup would complete the cashbook for a small business?
Hi Sheila, there should be absolutely no problems using Windows 10/Excel. You can check your work against the original. See the download guide video th-cam.com/video/m7Zf8_UWPGQ/w-d-xo.html 😊
What a polite well spoken young man mr spreadsheet is!
Thanks, I will let him know, but he might blush :-)
I'm a beginner with Excel and it is my wish to learn on how to operate a simple cashbook using excel for quite awhile. Your video is excellent in this area for a beginner like me. Great many thanks!!
You are welcome! :-)
Your capability to teach complicated topics in such a simple way to be understood by beginners is amazing
Thanks Chris, much appreciated :-)
excellent. I love this cash book. I have been looking for that so long. Thank you.
You're very welcome!
Your videos are so precise as a tutorial for beginners like myself I would love to havea copy or a macros one also. I am just starting a business and need lots of help with setting up a good system for keeping records. Excellent
Hi Karon, Glad it was helpful! The file you have requested can be obtained by following the guide in this video th-cam.com/video/m7Zf8_UWPGQ/w-d-xo.html 😊
Really helpful
Glad it helped
Thanks for showing how to make cash book this was very good lesson but the only I could worked out that how I can do the total
Glad it was helpful! Not sure what you mean about the SUM routines ?
What a nicely spoken man! Thank you for making this video. this one really helped me out.
Can you please share this file with me? I'd really love to use your file as a sample to learn easily. Thank you so much again. 💚
Hi, I'm glad you found the content useful, downloads are available at www.MrSpreadSheet.com :-)
Nicely explained. Thank you. One copy please.
Glad you liked it :-)
Awesome thanks
Thanks olayinka :-)
Am new here and I would love to learn and understand Data Entry.
Go for it ...
just what I wanted, Xero is to complement
Glad you liked it ...
Very good
Thanks
Very useful
Thanks a lot
Hi thanks for this useful, concise and precise excel tutorial. I would like a copy of this while trying to create it from scratch.
Hi Fabrice, Please follow the ‘Download’ guide in this link 😊 th-cam.com/video/m7Zf8_UWPGQ/w-d-xo.html
Liked and subscribed! Thanks for this tutorial! I'm looking to make a balance sheet, cash flow statement, and Profit and Loss spreadsheet. Can you link to each of these if you've made them? Not ready for Quickbooks yet... so trying to create useful spreadsheets!
Hi, take a look at our 'How to keep your Accounts in Excel' video. This does all of these things. :-)
Thanks for your great explanation of the cash book. Please can you send me a copy of the cash book worksheet?
Hi Laura, Please follow the ‘Download’ guide in this link 😊 th-cam.com/video/m7Zf8_UWPGQ/w-d-xo.html
Done liked and subscribed
Hi Veneranda, The file you have requested can be obtained by following the guide in this video th-cam.com/video/m7Zf8_UWPGQ/w-d-xo.html 😊
@@MrSpreadSheet Thank you Sir.
Very interesting. Presumably the addition of a VAT column (input and output) plus a bank balance brought/carried forward setup would complete the cashbook for a small business?
Hi Peter, Yes exactly that :-)
I like it.
Thanks ...
Hi,
Great Video, Looking for download link?
Hi, Downloads are available at www.MrSpreadSheet.com :-)
So impressive!can I get a copy please?
Hi Nazra, The file you have requested can be obtained by following the guide in this video th-cam.com/video/m7Zf8_UWPGQ/w-d-xo.html 😊
Very good and understanding. How can i get a template
Hi Mark, please see the guide at the end of the video
I would like to learn more
That's great :-)
Hi, great tutorial. I have subscribed and liked but still havent received the template. Am I doing something wrong.
Hi Dave, visit www.MrSpreadSheet.com 😊
Please help, I tried it over and over...formula error with D5 payments & receipts column. I have done it exactly as instructions?
Hi, you can check your work against the original. A download is available at www.MrSpreadSheet.com :-)
Hello please I need more details about cash book excels
Hi, Why not view and follow along the whole series. :-)
I am new to Excell and the first if statement gives me an error warning
Hi, Keep trying ! if you are really stuck then you can download the original from www.MrSpreadSheet.com :-)
Greetings sir. How did your lining clear to blank white? This is new to me.
Hi Klaudia, Page Layout Ribbon, then uncheck the View Gridlines box. :-)
@@MrSpreadSheet Got it. Thank you.
Hey how do I add cash and when I make payments in to bank it deduct and start over
Hi Samuel, Our 'How to create you Accounts in Excel' video covers an opening balance routine. This could easily be applied to the Cash Book. :-)
Hi I'm trying to use the formula but it gives me an error, "there is a problem with this formula" 😩
Hi Kelvin, You can check your work against the original. See the download guide video th-cam.com/video/m7Zf8_UWPGQ/w-d-xo.html 😊
why the amount when im total a DSUM is double
Hi Amirul, Not exactly sure what you mean, can you explain the issue in more detail :-)
Liked and subscribed, please I would like a copy of the spreadsheet.
Hi Nehemiah, please message me on FB :-)
if u give me demo file this...plz
Hi Basir, please follow the guide at the end of the video :-)
i have done this step by step and it says i need to add ' so this did not work for windows 10 at all
Hi Sheila, there should be absolutely no problems using Windows 10/Excel. You can check your work against the original. See the download guide video th-cam.com/video/m7Zf8_UWPGQ/w-d-xo.html 😊
I m not getting the Vlookup function
Hi Suraiza, You can check your work against the original. See the download guide video th-cam.com/video/m7Zf8_UWPGQ/w-d-xo.html 😊
I would like a spread sheet
Hi, please refer to the guide at the end of the video :-)
Sorry....I need further explaining on the analysis table. What's the difference between sales and receipt?
Hi Michael, You can check your work against the original. See the download guide video th-cam.com/video/m7Zf8_UWPGQ/w-d-xo.html 😊
need copy please
Please see our ‘Free Mr. SpreadSheet templates’ video 😊 th-cam.com/video/m7Zf8_UWPGQ/w-d-xo.html
Hi, can you send me copy of the Cash Book in Excel
Hi Thomas, The file you have requested can be obtained by following the guide in this video th-cam.com/video/m7Zf8_UWPGQ/w-d-xo.html 😊
I wonder why I failed to get the totals of the analysis table. I have repeated it several times but I get wrong figures.
Hi Naanlinnya, You can check your work against the original. See the download guide video th-cam.com/video/m7Zf8_UWPGQ/w-d-xo.html 😊
already subscribed please send me the file.
Hi Rashid, Please follow the guide at the end of the video :-)
Please send me a cash log spreadsheet
Hi, Download are available at www.MrSpreadSheet.com :-)
You are just talking to yourself. Mtshwww
Thanks for your insights Abdulsamad :-)
Thank you I liked and subscribed, its awesome and helpful. waiting for your email.
Hi, Thanks, please see my other comment :-)