Using Google Sheets for Your Small Businesses
Offered By: Skillshare
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 AccountingUniversity 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