Learn the basics of using Google Sheets for your small business’ bookkeeping, templates to use, and how the cash bookkeeping cycle works. Read more.
Accounting Instructor with more than 5 years of experience in management and financial accounting, financial planning and reporting, database administration, and QuickBooks.
Access all courses in our library for only $9/month with All Access Pass
Get Started with All Access PassBuy Only This CourseAbout This Course
Who this course is for:
- Small business owners
- Anyone interested in using Google Sheets for bookkeeping
What you’ll learn:Â
- Which businesses can use cash bookkeeping
- How the cash bookkeeping cycle works
- Google Sheets templates for bookkeeping
- The chart of accounts and its meaning in cash accounting
- How to set up the profit and loss report to automatically pull information from the Revenue Book and Expense Book
- How to create charts and visualize financial information in Google Sheets
Requirements:Â
- Must have a Google account
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 clarify which businesses can use cash bookkeeping.
Second, I will explain how the cash bookkeeping cycle works.
After that, 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 the chart of accounts and its meaning in cash accounting and how to add it to 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.
As a bonus video, you will have the opportunity to see how to create charts and visualize financial information in Google Sheets.
I hope this course will be useful for you and your small business.
Our Promise to You
By the end of this course, you will have learned bookkeeping using Google Sheets.
10 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.
Get started today and learn more about Google Sheets.
Course Curriculum
| Section 1 - Bookkeeping With Google Sheets | |||
| Introduction | 00:00:00 | ||
| Google Sheets Users | 00:00:00 | ||
| Cash Bookkeeping | 00:00:00 | ||
| Advantages | 00:00:00 | ||
| Chart Of Accounts | 00:00:00 | ||
| Templates View | 00:00:00 | ||
| Invoice Template | 00:00:00 | ||
| Creating A Revenue Book | 00:00:00 | ||
| Creating An Expense Book | 00:00:00 | ||
| Creating The Profit And Loss Statement | 00:00:00 | ||
| Making Records In The Revenue Book | 00:00:00 | ||
| Making Records In The Expense Book | 00:00:00 | ||
| How The Profit And Loss Statement Updates | 00:00:00 | ||
| Section 2 - Bonus Videos | |||
| Data Visualization | 00:00:00 | ||
| Create A Chart | 00:00:00 | ||
| How To Read Charts | 00:00:00 | ||
About This Course
Who this course is for:
- Small business owners
- Anyone interested in using Google Sheets for bookkeeping
What you’ll learn:Â
- Which businesses can use cash bookkeeping
- How the cash bookkeeping cycle works
- Google Sheets templates for bookkeeping
- The chart of accounts and its meaning in cash accounting
- How to set up the profit and loss report to automatically pull information from the Revenue Book and Expense Book
- How to create charts and visualize financial information in Google Sheets
Requirements:Â
- Must have a Google account
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 clarify which businesses can use cash bookkeeping.
Second, I will explain how the cash bookkeeping cycle works.
After that, 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 the chart of accounts and its meaning in cash accounting and how to add it to 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.
As a bonus video, you will have the opportunity to see how to create charts and visualize financial information in Google Sheets.
I hope this course will be useful for you and your small business.
Our Promise to You
By the end of this course, you will have learned bookkeeping using Google Sheets.
10 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.
Get started today and learn more about Google Sheets.
Course Curriculum
| Section 1 - Bookkeeping With Google Sheets | |||
| Introduction | 00:00:00 | ||
| Google Sheets Users | 00:00:00 | ||
| Cash Bookkeeping | 00:00:00 | ||
| Advantages | 00:00:00 | ||
| Chart Of Accounts | 00:00:00 | ||
| Templates View | 00:00:00 | ||
| Invoice Template | 00:00:00 | ||
| Creating A Revenue Book | 00:00:00 | ||
| Creating An Expense Book | 00:00:00 | ||
| Creating The Profit And Loss Statement | 00:00:00 | ||
| Making Records In The Revenue Book | 00:00:00 | ||
| Making Records In The Expense Book | 00:00:00 | ||
| How The Profit And Loss Statement Updates | 00:00:00 | ||
| Section 2 - Bonus Videos | |||
| Data Visualization | 00:00:00 | ||
| Create A Chart | 00:00:00 | ||
| How To Read Charts | 00:00:00 | ||
Course Review
5.0
4 RatingsRelated Courses
Are you interested in higher education?
All Rights Reserved
Basic and to the Point.
Great for those with little to no experience using Google Sheets. She explains things very well her templates are easy to understand and use. Even advanced Google Sheets users will find this very helpful and maybe learn something from this short course.
Straightforward and easy
Love how she kept it very simple and straight to the point!
Great course
This course was an excellent refresher for me, someone who has been away from bookkeeping for a while and is looking to rekindle my passion for the field. I feel confident that the information and skills reignited by this course will be invaluable in my future endeavors.
A grear way to begin with Google Sheets
Hello this course helped me a lot understanding Google Sheets for accounting!