Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Skillshare

Using Google Sheets for Your Small Businesses

via Skillshare

Overview

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.

Syllabus

  • 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

Taught by

Vicky Nedelcheva

Reviews

Start your review of Using Google Sheets for Your Small Businesses

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.