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 Bookkeeping Tutorial/Training Learn more at

31 Replies to “Create a Bookkeeping Spreadsheet using Microsoft Excel – Part 1”

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

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

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

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

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

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

Leave a Reply

Your email address will not be published. Required fields are marked *