https://www.youtube .com/watch?v=LlWADbkGdac

Part 1 of 6 – Learn how to create a bookkeeping spreadsheet using Microsoft excel. In this video I will demonstrate how to create a bookkeeping template using Microsoft excel. Need help with Sage or other accounting software? Drop us an email at [email protected] Take our Online Sage training course https://www.freebookkeepingaccounting.com/free-sage-training Bookkeeping Tutorial/Training Learn more at www.freebookkeepingaccounting.com

### Related posts:

9 Google Ranking Factors (That Actually Matter in 2022)

How To Start Bookkeeping (FREE Template)

The Complete Guide to Locksmiths, Why You Need One and How They Work

Make TONS of Money with SEO in 2023

SEO is Changing - How to Win in 2023

Complete SEO Guide | A Complete SEO Guide & A-Z SEO Walkthrough | Free SEO Course & Guide

15 Powerful SEO Tips for 2022 (Rank #1 on Google Fast)

5 Quick Ways to Improve Your SEO Rankings

Back to the Basics. That is Bookkeeping Basics! An Intro to QuickBooks.

Week #1 of Becoming a Bookkeeper | Realistic Bookkeeping

Bookkeeper DAY IN THE LIFE (bookkeeping job description)

Learn the Basics of Bookkeeping [FREE QuickBooks Training]

Hi Thanks that a big help understanding excel, do you have any information about how to incorporate vat into this as well – Jason

You can simply add a VAT column in the assets and liabilities side of the spreadsheet. If the business is VAT registered though, you may wish to consider accounting software. I hope this helps.

thank you

Thanks for watching and taking the time to comment

Bob loukas?????

No, never heard of him. Thanks for watching.

My favorite YouTuber ever! 🙂 Thanks for sharing your knowledge .

Thanks a lot! Your kind words are very much appreciated.

I can’t work out from watching how you repeat the pattern of 2 merged cells.

I am working on a new series, which will clear this up for you. The series will be uploaded shortly. Thanks for watching.

Hi. The link in the description is broken.

Thanks for letting me know.

You’re welcome 🙂

This helped me so much, thank you!

can i get a full template for your bookkeeping course

Yes, please make a small donation on my website and send me an email. Thanks for watching.

Is it absolutely necessary to make all the entry cells, double cells (2 cells merged into one)? Or will I be fine just making them each 1 cell?

Cheers from Canada!

No it’s not. Thanks for watching.

Thank you for the tutorial, what is a capital account?

The owners investment in the business. I hope this helps. Thanks for watching.

the above link for bpfs-online course is not working…

Here you go… https://www.freebookkeepingaccounting.com/free-bookkeeping-course. Thanks for letting me know

Just so you know we are using this set up for the Brighton Community Workshop Project accounts. I like the videos mainly for the way you talk. I know enough about Excel to make our spreadsheets work best for us but this set up got us heading down the right path so thank you. Maybe you should update these videos, nearly 10 years old now.

It’s on my list. Hopefully early 2022. Thanks for the suggestion and for watching.

I’m learning a lot from your videos. Thank you so much for your great tutorials.

Glad you like them! Thanks for watching

I wish I can do that In open office. Excel is too expensive monthly fees ridiculous.

Sorry to hear that. Thanks for watching

@BookkeepingMaster hey master if you have any muscles do in open office please?

what is product of resale means?

A product that is purchased for resale. Such as a clothes shop that purchases clothes to sell in the shop. I hope this helps. Thanks for watching.