Скачать или смотреть Bookkeeping for small business DIY | Using excel

Bookkeeping for small business | using excel
Is the topic that we are going to discuss in this video. In the first part of this small business bookkeeping video tutorial, I will show you about 8 functions and formatting tools that you can use to build your first interactive excel spreadsheet for your small business.

In the second, I will be sharing a sharing review a free spreadsheet that you can download. to keep track of invoices that you have sent to your clients. We will create a spreadsheet that will document:

In this video tutorial, we will use colour codes and highlight rows in green which are paid invoices and rows in blue which are still outstanding. This helps us to quickly check outstanding invoices. I will also show you how to use the auto sum function to calculate your total expected income, the total amount paid to date and the total amount which is outstanding.

Using the spreadsheet should also reduce your business accountant costs as you will be able to provide a comprehensive spreadsheet that is fully documented for income into your business. This should save your accountant time and result in lower accountancy fees.
bookkeeping training.

Most important is for you to understand what income is coming into your business and keep track of outstanding invoices which you need to chase up.

Ultimately the goal of this tutorial is to reduce your monthly outgoing fees for accountancy software.

If you're planning on building an online e-commerce store then it may be worth looking at third-party software solutions for bookkeeping such as Xero or Quick Books. Xero or Quick Books and other accountancy software can be easily integrated into e-commerce solutions like woocommerce or Shopify. In the long run, this should save you time so you can focus on your you're my main goal which is to sell products.

Make sure you update bookkeeping spreadsheets on a weekly or monthly basis, trust me it will save you a lot of headaches later. Remember to file hard copies of your invoices and receipts in date order.

Looking for ways to turn your Passion into Money by enhancing you HustleQI subscribe to my channel by clicking the link below.
➢ SUBSCRIBE!: https://www.youtube.com/channel/UCJlY...

Link to FREE Template
https://tinyurl.com/4fsuyv72

Support me
My Gear
www.teespring.com/mykeltheentre

Follow me on Social media
Instagram: @mykel_da_entre
Twitter: @mykeldaentre
Facebook: www.facebook.com/mykellamar
Linkedin: mykel the entreperneur

Filming gear
Nikon 3200 Camera
https://amzn.to/31K6KYR
My Tripod
https://amzn.to/3fU1fvu
Camera monitor
https://amzn.to/33VuvzG
Camera mic
https://amzn.to/3kFBAdF
SD cards
https://amzn.to/30Q153Z

Office set up
My Mac
https://amzn.to/2DMqFyg
Adobe creative suite
https://amzn.to/3fUCRdj
Apple Magic Mouse and Keyboard
https://amzn.to/3kEUEIW
SSD External Drives
https://amzn.to/2PPwFbO


I will see y’all in the next one!

#excelforsmallbusiness #excelforbusiness #excelforbeginners #diysmallbusinessbookkeeping