How To Use Google Sheets To Do Accounting For Your Small Business
Build An Accurate Bookkeeping System Using Google Sheets
Lectures -16
Duration -49 mins
Lifetime Access
Lifetime Access
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
Course Description
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.
If you are still interested keep watching. I hope this course will be useful for you and your small business.
Goals
- Create a Purchase Book
- Make records in the Purchase Book
- Create a Sales Book
- Make records in the Sales Book
- Prepare a Profit and Loss Statement
- Build financial charts
- And more and more...
Prerequisites
- There is no list of pre-requisits that students should have before they start learning from this course. This course is suitable for people with no accounting or Google Sheets experience, as well as for people who have some experience but want to boost their skills.

Curriculum
Check out the detailed breakdown of what’s inside the course
Basics
4 Lectures
-
Introduction 02:56 02:56
-
Google Sheets Users 03:06 03:06
-
Cash Bookkeeping 04:24 04:24
-
Advantages of Google Sheets as a Bookkeeping Tool 01:51 01:51
Create Your Bookkeeping System Using Google Sheets
12 Lectures

Instructor Details

Viktoria Nedelcheva
A passionate and experienced content creator dedicated to helping aspiring entrepreneurs and business owners bring their online ventures to life. With her extensive knowledge in online business strategies, she empowers individuals to turn their ideas into successful online enterprises.
Viktoria guides aspiring entrepreneurs through every step of the process, from ideation to execution. Through her comprehensive tutorials, practical tips, and real-life examples, she enables individuals to navigate the ever-evolving landscape of online business and harness the power of the digital world.
Course Certificate
Use your certificate to make a career change or to advance in your current career.

Our students work
with the Best


































Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe now
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now