How to create a Cash Book in Excel - Step by Step Guide [2021]

[@Anthony-Testicali]

What a polite well spoken young man mr spreadsheet is!

[@MrSpreadSheet]

Thanks, I will let him know, but he might blush :-)

[@marcusfitakec5257]

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!!

[@MrSpreadSheet]

You are welcome! :-)

[@chrisstylianides2507]

Your capability to teach complicated topics in such a simple way to be understood by beginners is amazing

[@MrSpreadSheet]

Thanks Chris, much appreciated :-)

[@olgarogova7057]

excellent. I love this cash book. I have been looking for that so long. Thank you.

[@MrSpreadSheet]

You're very welcome!

[@karonhebron1304]

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

[@MrSpreadSheet]

Hi Karon, Glad it was helpful! The file you have requested can be obtained by following the guide in this video kzbin.info/www/bejne/o2i9l2uViryDfbM 😊

[@TheNIcholasJennings]

Really helpful

[@MrSpreadSheet]

Glad it helped

[@HasanImroz-oi9db]

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. 💚

[@MrSpreadSheet]

Hi, I'm glad you found the content useful, downloads are available at www.MrSpreadSheet.com :-)

[@maiwandtanha5579]

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

[@MrSpreadSheet]

Glad it was helpful! Not sure what you mean about the SUM routines ?

[@arifurrahman7663]

Nicely explained. Thank you. One copy please.

[@MrSpreadSheet]

Glad you liked it :-)

[@sharebridge]

Hi thanks for this useful, concise and precise excel tutorial. I would like a copy of this while trying to create it from scratch.

[@MrSpreadSheet]

Hi Fabrice, Please follow the ‘Download’ guide in this link 😊 kzbin.info/www/bejne/o2i9l2uViryDfbM

[@olayinkayisa2477]

Awesome thanks

[@MrSpreadSheet]

Thanks olayinka :-)

[@mugearmstrong1876]

Am new here and I would love to learn and understand Data Entry.

[@MrSpreadSheet]

Go for it ...

[@turaytalksjourney2024]

Very good

[@MrSpreadSheet]

Thanks

[@logcabinschoolhouse4294]

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!

[@MrSpreadSheet]

Hi, take a look at our 'How to keep your Accounts in Excel' video. This does all of these things. :-)

[@muhammadsani7146]

Very useful

[@MrSpreadSheet]

Thanks a lot

[@venerandaquevedo9186]

Done liked and subscribed

[@MrSpreadSheet]

Hi Veneranda, The file you have requested can be obtained by following the guide in this video kzbin.info/www/bejne/o2i9l2uViryDfbM 😊

[@venerandaquevedo9186]

@@MrSpreadSheet Thank you Sir.

[@lauramccoll9422]

Thanks for your great explanation of the cash book. Please can you send me a copy of the cash book worksheet?

[@MrSpreadSheet]

Hi Laura, Please follow the ‘Download’ guide in this link 😊 kzbin.info/www/bejne/o2i9l2uViryDfbM

[@PopeSama]

just what I wanted, Xero is to complement

[@MrSpreadSheet]

Glad you liked it ...

[@peterc2248]

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?

[@MrSpreadSheet]

Hi Peter, Yes exactly that :-)

[@daveevans4391]

Hi, great tutorial. I have subscribed and liked but still havent received the template. Am I doing something wrong.

[@MrSpreadSheet]

Hi Dave, visit www.MrSpreadSheet.com 😊

[@charlenescholtz3997]

Please help, I tried it over and over...formula error with D5 payments & receipts column. I have done it exactly as instructions?

[@MrSpreadSheet]

Hi, you can check your work against the original. A download is available at www.MrSpreadSheet.com :-)

[@Nazrablaq]

So impressive!can I get a copy please?

[@MrSpreadSheet]

Hi Nazra, The file you have requested can be obtained by following the guide in this video kzbin.info/www/bejne/o2i9l2uViryDfbM 😊

[@asimsiddiq475]

I like it.

[@MrSpreadSheet]

Thanks ...

[@aryemojulia5559]

I would like to learn more

[@MrSpreadSheet]

That's great :-)

[@marklamptey6881]

Very good and understanding. How can i get a template

[@MrSpreadSheet]

Hi Mark, please see the guide at the end of the video

[@teredmartin]

Hi, Great Video, Looking for download link?

[@MrSpreadSheet]

Hi, Downloads are available at www.MrSpreadSheet.com :-)

[@wiafeosei4935]

Hello please I need more details about cash book excels

[@MrSpreadSheet]

Hi, Why not view and follow along the whole series. :-)

[@samuelainsah-mensah694]

Hey how do I add cash and when I make payments in to bank it deduct and start over

[@MrSpreadSheet]

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. :-)

[@kelvinleo1262]

Hi I'm trying to use the formula but it gives me an error, "there is a problem with this formula" 😩

[@MrSpreadSheet]

Hi Kelvin, You can check your work against the original. See the download guide video kzbin.info/www/bejne/o2i9l2uViryDfbM 😊

[@nielsmit9835]

I am new to Excell and the first if statement gives me an error warning

[@MrSpreadSheet]

Hi, Keep trying ! if you are really stuck then you can download the original from www.MrSpreadSheet.com :-)

[@klaudianiiipinge2494]

Greetings sir. How did your lining clear to blank white? This is new to me.

[@MrSpreadSheet]

Hi Klaudia, Page Layout Ribbon, then uncheck the View Gridlines box. :-)

[@klaudianiiipinge2494]

@@MrSpreadSheet Got it. Thank you.

[@sheilaestrada4361]

i have done this step by step and it says i need to add ' so this did not work for windows 10 at all

[@MrSpreadSheet]

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 kzbin.info/www/bejne/o2i9l2uViryDfbM 😊

[@suraizafpakeer8611]

I m not getting the Vlookup function

[@MrSpreadSheet]

Hi Suraiza, You can check your work against the original. See the download guide video kzbin.info/www/bejne/o2i9l2uViryDfbM 😊

[@amirulehsan2998]

why the amount when im total a DSUM is double

[@MrSpreadSheet]

Hi Amirul, Not exactly sure what you mean, can you explain the issue in more detail :-)

[@nehemiahoseremen2579]

Liked and subscribed, please I would like a copy of the spreadsheet.

[@MrSpreadSheet]

Hi Nehemiah, please message me on FB :-)

[@basirbabu420]

if u give me demo file this...plz

[@MrSpreadSheet]

Hi Basir, please follow the guide at the end of the video :-)

[@naalinnyamariaconcepta3570]

I wonder why I failed to get the totals of the analysis table. I have repeated it several times but I get wrong figures.

[@MrSpreadSheet]

Hi Naanlinnya, You can check your work against the original. See the download guide video kzbin.info/www/bejne/o2i9l2uViryDfbM 😊

[@heritagesociety3991]

I would like a spread sheet

[@MrSpreadSheet]

Hi, please refer to the guide at the end of the video :-)

[@thomasscott2522]

Hi, can you send me copy of the Cash Book in Excel

[@MrSpreadSheet]

Hi Thomas, The file you have requested can be obtained by following the guide in this video kzbin.info/www/bejne/o2i9l2uViryDfbM 😊

[@michaeladuaboagye124]

Sorry....I need further explaining on the analysis table. What's the difference between sales and receipt?

[@MrSpreadSheet]

Hi Michael, You can check your work against the original. See the download guide video kzbin.info/www/bejne/o2i9l2uViryDfbM 😊

[@nasrullahdaie41]

need copy please

[@MrSpreadSheet]

Please see our ‘Free Mr. SpreadSheet templates’ video 😊 kzbin.info/www/bejne/o2i9l2uViryDfbM

[@plaurx]

Please send me a cash log spreadsheet

[@MrSpreadSheet]

Hi, Download are available at www.MrSpreadSheet.com :-)

[@rashidbhatti1923]

already subscribed please send me the file.

[@MrSpreadSheet]

Hi Rashid, Please follow the guide at the end of the video :-)

[@abdulsamadmuhammedbello2350]

You are just talking to yourself. Mtshwww

[@MrSpreadSheet]

Thanks for your insights Abdulsamad :-)

[@mullerfamilysa8139]

Thank you I liked and subscribed, its awesome and helpful. waiting for your email.

[@MrSpreadSheet]

Hi, Thanks, please see my other comment :-)