https://www.youtube .com/watch?v=RQMhN_R2MfU
Why not keep your Bookkeeping records in a simple Excel Spreadsheet.In this video I will create an easy to use Bookkeeping Spreadsheet that you can both expand and adapt to your specific business requirements.Created using the Excel Table tool, the finished Excel template incorporates a ‘drop down list box’ to select data and uses Excels filtering tool for you to ‘drill down’ into your data.As usual I will provide a link for you to obtain a copy of the finished product.Please use the YouTube messaging facility if you have a questions.
INFORMATIVE VIDEO, THANKS
Glad it was helpful! :-)
I would like a spreadsheet please, this was a great lesson.
Hi Yankho, Please follow the ‘Download’ guide in this link 😊 https://youtu.be/m7Zf8_UWPGQ
I cannot find Define name under formulas on mine where can it be?
Hi Rookie, it’s on the Formulas Ribbon :-)
@Mr.SpreadSheet Thank you for your response I found out that excel online does not support the Define name under the Formulas Ribbon.
Please send all accounting spreadsheet Thank you
easy for a beginner
Well done …
Very helpful. Thanks 🙏
Thank you so much, I learned so much for my own business bookkeeping.
Hi Lizbeth, I’m glad you found it useful :-)
Cool. I really need a cash basis template
Hi Mike, This can be used using Cash Accounting.
Great video thank you. Can you explain what the types of payment are? is a bank payment the same as a BACS transfer?
Hi Annabel, Yes, BACS, Credit Transfers, etc., are all payment types.
@Mr.SpreadSheet thanks so much!
@Mr.SpreadSheet Another question – I’m doing a spreadsheet for a property manager. He uses an estate agent who have rented out one of his flats. The estate agent charge 9% of the rent so how do I enter that in the spreadsheet? Do i put the full rent and then add a minus entry for their fees?
I’ve done as you said on the video but still don’t have a copy of the spread sheet.
Hi Mike, The file you have requested can be obtained by following the guide in this video https://youtu.be/m7Zf8_UWPGQ 😊
This was great and you had a nice voice to listen to lol. Thanks!
Glad you enjoyed it!
A copy please. :)
Please see our ‘Free Mr. SpreadSheet templates’ video 😊 https://youtu.be/m7Zf8_UWPGQ
Very helprful for a newbie small business owner. Thank you!
Hi Clark, I’m glad you found it useful :-)
I’d love a copy, please!
Hi Marie, The file you have requested can be obtained by following the guide in this video https://youtu.be/m7Zf8_UWPGQ 😊
This was very helpful could you kindly give me acces to the spreadsheet. thanks
Hi Thozamile, Please follow the ‘Download’ guide in this link 😊 https://youtu.be/m7Zf8_UWPGQ