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

Create your own Cash Book to record your business or personal bank and cash transactions.
This easy to use spreadsheet uses Excels superb TABLE Creator tool to create the basic template for you to record your financial data.
In the course of the tutorial I will use and demonstrate a simple IF Statement, I will introduce the VLOOKUP function for easy analysis and use the DSUM command to quantify totals.
The video is designed for you to 'follow' at an easy pace, and once completed you should have a very useful tool, and hopefully you will pick up a few tips on the use of some of Excels powerful commands.
Here are the links to the various Mr.SpreadSheet resources available to you.
Please help support our channel by subscribing.
Many thanks
Free Cash Book Spreadsheet Template - www.MrSpreadsheet.com/product...
You can also visit our websites at:
USA & Canada & World - www.MrSpreadSheet.com
UK & Europe - www.MrSpreadSheet.co.uk
Or our Social channels:
FaceBook - / mrspreadsheets
Instagram - / mrspreadsheet
Twitter - / mr_spreadsheet
#MrSpreadSheet #Excel #spreadsheet #exceltutorial #msexcel #Accounting

[@Anthony-Testicali]

What a polite well spoken young man mr spreadsheet is!

[@MrSpreadSheet]

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

[@chrisstylianides2507]

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

[@MrSpreadSheet]

Thanks Chris, much appreciated :-)

[@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! :-)

[@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 czcams.com/video/m7Zf8_UWPGQ/video.html 😊

[@olayinkayisa2477]

Awesome thanks

[@MrSpreadSheet]

Thanks olayinka :-)

[@TheNIcholasJennings]

Really helpful

[@MrSpreadSheet]

Glad it helped

[@asimsiddiq475]

I like it.

[@MrSpreadSheet]

Thanks ...

[@muhammadsani7146]

Very useful

[@MrSpreadSheet]

Thanks a lot

[@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 ?

[@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 😊 czcams.com/video/m7Zf8_UWPGQ/video.html

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

[@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 :-)

[@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 :-)

[@arifurrahman7663]

Nicely explained. Thank you. One copy please.

[@MrSpreadSheet]

Glad you liked it :-)

[@venerandaquevedo9186]

Done liked and subscribed

[@MrSpreadSheet]

Hi Veneranda, The file you have requested can be obtained by following the guide in this video czcams.com/video/m7Zf8_UWPGQ/video.html 😊

[@venerandaquevedo9186]

@@MrSpreadSheet Thank you Sir.

[@mugearmstrong1876]

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

[@MrSpreadSheet]

Go for it ...

[@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 😊 czcams.com/video/m7Zf8_UWPGQ/video.html

[@PopeSama]

just what I wanted, Xero is to complement

[@MrSpreadSheet]

Glad you liked it ...

[@marklamptey6881]

Very good and understanding. How can i get a template

[@MrSpreadSheet]

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

[@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 😊

[@aryemojulia5559]

I would like to learn more

[@MrSpreadSheet]

That's great :-)

[@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.

[@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 czcams.com/video/m7Zf8_UWPGQ/video.html 😊

[@wiafeosei4935]

Hello please I need more details about cash book excels

[@MrSpreadSheet]

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

[@teredmartin]

Hi,
Great Video, Looking for download link?

[@MrSpreadSheet]

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

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

[@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 :-)

[@heritagesociety3991]

I would like a spread sheet

[@MrSpreadSheet]

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

[@nehemiahoseremen2579]

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

[@MrSpreadSheet]

Hi Nehemiah, please message me on FB :-)

[@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 :-)

[@basirbabu420]

if u give me demo file this...plz

[@MrSpreadSheet]

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

[@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 czcams.com/video/m7Zf8_UWPGQ/video.html 😊

[@nasrullahdaie41]

need copy please

[@MrSpreadSheet]

Please see our ‘Free Mr. SpreadSheet templates’ video 😊 czcams.com/video/m7Zf8_UWPGQ/video.html

[@suraizafpakeer8611]

I m not getting the Vlookup function

[@MrSpreadSheet]

Hi Suraiza, You can check your work against the original. See the download guide video czcams.com/video/m7Zf8_UWPGQ/video.html 😊

[@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 czcams.com/video/m7Zf8_UWPGQ/video.html 😊

[@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 czcams.com/video/m7Zf8_UWPGQ/video.html 😊

[@rashidbhatti1923]

already subscribed please send me the file.

[@MrSpreadSheet]

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

[@plaurx]

Please send me a cash log spreadsheet

[@MrSpreadSheet]

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

[@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 czcams.com/video/m7Zf8_UWPGQ/video.html 😊

[@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 czcams.com/video/m7Zf8_UWPGQ/video.html 😊

[@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 :-)