Using Google Sheets for Your Small Businesses

Hi. I am glad that you are interested in my course. Here you can understand a little more about what you can expect from the course:

First, I will introduce the Google Sheets templates that we will use for this course. 

I will also go through the invoice template and tell you which functions I’ve used for this template.

Next, I will talk about how to create your Revenue Book and Expense Book in Google Sheets.

Last but not least, I will show you how to set up the profit and loss report to automatically pull information from the Revenue Book and Expense Book.

Once we create the Google Sheets templates, I will walk you through their practical use. This means I will show you how to accurately and effectively record and track your business money-in and money-out using all four bookkeeping templates.

The course will conclude with a video that will show you how to read financial information from your Profit and Loss Statement.

If you are still interested keep watching. I hope this course will be useful for you and your small business.

P.S. You can find the templates attached and download them.

• Introduction
• Who can use Google Sheets as a bookkeeping tool
• More about cash bookkeeping
• Why you should use Google Sheets for bookkeeping
• Chart of accounts
• Quick view of the templates we will create
• Invoice
• Revenue Book
• Expense Book
• Profit and Loss Statement
• Add transaction to the Revenue Book
• Add transactions to the Expense Book
• Understand to read the information on the Profit and Loss Statement
• Bonus 1 - Data Visualization
• Bonus 2 - How to Create a Chart
• Bonus 3 - How to Read a Chart