YoVDO

Using Google Sheets for Your Small Businesses

Offered By: Skillshare

Tags

Accounting Courses Data Visualization Courses Google Sheets Courses Invoicing Courses Expense Tracking Courses

Course Description

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

Related Courses

Introduction to Financial Accounting
University of Pennsylvania via Coursera
Accounting Cycle: The Foundation of Business Measurement and Reporting
Utah State University via Canvas Network
La contabilidad, el lenguaje de los negocios
Miríadax
Financial Accounting for Non-Financial Managers
Rollins College via Open Education by Blackboard
Evaluation financière de l'entreprise
HEC Paris via Coursera