Cash Accounting - Create a Bookkeeping Spreadsheet in Excel

Hello and welcome to the Mr.SpreadSheet UA-cam Channel.
How to use Cash Accounting to Create a Bookkeeping Spreadsheet in Excel
This presentation is the second video in our 8 video 'Basic Bookkeeping Spreadsheet' series.
In this video we describe the Cash Accounting bookkeeping method and then we start to build our spreadsheet template using this practice.
The eight videos in this series can all be found in our Basic Bookkeeping Spreadsheet Playlist.
This resource is available Free of Charge enabling you to work through the various design stages at your own pace.
The eight videos comprise:
1. Bookkeeping Basics
2. Cash Accounting
3. Chart of Accounts
4. Bank Balances
5. Gross Profit
6. Error Handling
7. Income Statement
8. The Final Spreadsheet Template
As usual we are offering viewers a FREE copy of the completed template.
Details on how to get this are shown during the course of the video presentation.
We hope you enjoy watching.
.............................................................................................................................
Here are the links to the various Mr.SpreadSheet resources available to you.
Please help support our channel by subscribing.
Many thanks
Visit our websites at:
USA & Canada & World - www.MrSpreadSh...
UK & Europe - www.MrSpreadSh...
Our Social channels:-
FaceBook - / mrspreadsheets
Instagram - / mrspreadsheet
Twitter - / mr_spreadsheet
#MrSpreadSheet #Excel #spreadsheet #exceltutorial #msexcel #Accounting

[@nigelphillips2846]

Thanks nice and simple to do

[@MrSpreadSheet]

Most welcome 😊

[@chimbakatongo6649]

Great video, the sequence formula didnt work for me though, does it have to do with the version?

[@MrSpreadSheet]

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

[@user-bs9lp9lk6f]

I did not see the formulas in the video for the totals in the purple area I through M. Is there an additional video with instructions to set up the totals highlighted in purple>?

[@MrSpreadSheet]

Hi, This video is part of an 8 video series. See our Basic Bookkeeping Spreadsheet playlist :-)

[@jonlarge8971]

I don't get it

[@MrSpreadSheet]

Hi, Why not view the first video in the series, this might help :-)

[@jonlarge8971]

@@MrSpreadSheet ok thank you