How To Use Google Sheets To Do Accounting For Your Small Business

person icon Viktoria Nedelcheva

How To Use Google Sheets To Do Accounting For Your Small Business

Build An Accurate Bookkeeping System Using Google Sheets

updated on icon Updated on Oct, 2023

language icon Language - English

person icon Viktoria Nedelcheva

architecture icon Google Sheets,Office Productivity

Lectures -16

Duration -49 mins


30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 19,000+ top Tutorialspoint 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.


What will you learn in this course:

  • 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...


What are the prerequisites for this course?

  • 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. 
How To Use Google Sheets To Do Accounting For Your Small Business


Check out the detailed breakdown of what’s inside the course

4 Lectures
  • play icon Introduction 02:56 02:56
  • play icon Google Sheets Users 03:06 03:06
  • play icon Cash Bookkeeping 04:24 04:24
  • play icon 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

Viktoria Nedelcheva


Viktoria Nedelcheva started her accounting journey when she was at the university, where she interned for an accounting firm. During her internship, she found out that the key to a successful business is the way it organizes its finances. After she graduated with a Bachelor's in Accounting, she worked as a bookkeeper in a small firm. After her Master's in Accounting, she charged her job and worked as a Professor's Assistant. She currently works as an accounting instructor and bookkeeper.

Viktoria specializes in accurately representing financial transactions, preparing financial statements, and analyzing the financial situation of a business.

She is dedicated to helping small businesses achieve success by helping them establish the best bookkeeping processes. Focused on online service businesses, she is committed to delivering financial services that meet each client’s unique objectives: recording and tracking outcoming and incoming transactions, income and expense analysis, and choosing the best bookkeeping software.

Course Certificate

User your certification to make a career change or to advance in your current career. Salaries are among the highest in the world.

sample Tutorialspoint certificate

Our students work
with the Best

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
People having fun around a laptop

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
People having fun around a laptop

Talk to us