Courses from $19.99

|

Limited time sale ending soon

Bookkeeping Using Google Sheets

Bookkeeping Using Google Sheets

5.0

Created by   Viktoria Nedelcheva

Category   Accounting/Finance   >   Other

Duration 50 minutes
Audience Employees

Description

Hi. I am glad that you are interested in my course. Here you will 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.

P.S. You can find the templates attached and download them.

What you'll learn

Who can use Google Sheets as a bookkeeping tool

How to create an invoice template using Google Sheets

How to create a Revenue book using Google Sheets

How to create an Expense book using Google Sheets

How to create a Profit and loss statement using Google Sheets

How to record revenue in the Revenue book

How to record expenses

How to automate the Profit and loss statement

How to visualize bookkeeping data

How to read charts with bookkeeping data

Languages

English

Details to know

Certificate
Bookmark

Bookkeeping Using Google Sheets

Bookkeeping Using Google Sheets
Bookkeeping Using Google Sheets

Attachments:

Bookkeeping Templates - Google Sheets  (990 KB) Project - try to apply what you have already learned. Create your own bookkeeping templates that fit your business needs. Follow these steps: 1. Create an invoice template. 2. Create a Revenue Book using the drop-down menu to include all revenue categories. 3. Create an Expense Book using the drop-down menu to include all expense categories. 4. Create a Profit and Loss Statement using the SUMIF formula to pull all the information from the Revenue Book and Expense Book. 5. Share your templates with us to see their design and functionality. Please share the templates without any private or business information. To show the functionality use some example numbers, not the real ones. P.S. You can use as a base the templates in the attached file.

Viktoria Nedelcheva

Expertise

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

Background

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.

Services

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.

 

Price per license
$14.99
No. of licenses
Total
$14.99
Get Bulk Pricing
30-Day Money Back Guarantee Full Lifetime Access

Or

Get Coggno Prime Now

Syndication Option

Resold modules appear on your website. You earn syndication share from each purchase. Contact Coggno to learn more on how to embed your own Portable Webshop in your website.

Resell

Sale Share: $3.60

to be added

Courses Handpicked for you

5 Course rating 0 ratings