Please ensure Javascript is enabled for purposes of website accessibility
Bookkeeping For Small Businesses Using Google Sheets
5.0( 3 REVIEWS )
79 STUDENTS
49m

Learn the basics of using Google Sheets for your small business’ bookkeeping, templates to use, and how the cash bookkeeping cycle works.

Read more.
Course Skill Level
Beginner
Time Estimate
49m

Instructor

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 Course

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

5.0
3 Ratings
  1. Anonymous

    Straightforward and easy

    5.0

    Love how she kept it very simple and straight to the point!

  2. Anonymous

    Great course

    5.0

    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.

  3. Anonymous
    Françoise Del Socorro May 17, 2023 at 00:57 AM

    A grear way to begin with Google Sheets

    5.0

    Hello this course helped me a lot understanding Google Sheets for accounting!

4764597

Join our newsletter and get your first course free!

4764598

Join our newsletter and get your first course free!

Congratulations! You get one free course of your choice. Please check your email now for the redemption code

Are you interested in higher education?