Do Bookkeeping Using Excel To Keep Your Records& Earn Money

How to keep accounting records for a small business using just excel. no need to buy accounting programs .

What you'll learn

Be able to keep accounting records for a service company and a merchandise company.

Know how to use excel in recording business transactions.

Complete two case studies where you keep the accounting records - one for a service company and one for a merchandise company. Using excel you record journal entries, summarize in the ledger, take a trial balance, do adjusting entries and present an income statement and balance sheet for each company.

Requirements

Everything will be provided

Description

Learn and Master the Accounting  ( Bookkepping) Process.Understand that accounting is the language of business.Know business terminology (biz speak).Understand the difference between a corporation and a single proprietorship.Know the three forms of business - service company, merchandise company and a manufacturer.Understand an Income Statement and how to prepare one.Understand a Balance Sheet and how to prepare one.Know how to analyse and record business transactionsLearn how to use debits and credits to record business transactions.Know how to use the accounting journal and ledger,Complete a set of accounting records for a service business using excel spreadsheets.Complete a set of accounting records for a merchandise company using excel spreadsheets.Understand LIFO and FIFO.Understand how to use the accounting system for Internal Control.Understand the different methods of depreciation.This course is unique in that it contains a number of excel projects on using a set of accounting records first for a service company and then a merchandise company. There are  practice midterm and final exams with marking keys that highlight where an exam marker will award you marks.Bookkeeping is the recording, on a day-to-day basis, of the financial transactions and information pertaining to a business. It ensures that records of the individual financial transactions are correct, up-to-date and comprehensive. … Bookkeeping provides the information from which accounts are prepared.

Overview

Section 1: Overview of this course

Lecture 1 Overview of this course

Section 2: Introduction to Business

Lecture 2 Three form of business

Lecture 3 Financial Accounting overview

Lecture 4 Accounting the Language of Business

Section 3: Know how to present the Income Statement and Balance Sheet

Lecture 5 Lecture on Financial Statements

Section 4: Analyzing business transactions.

Lecture 6 Analyzing and recording business transactions

Section 5: Know how to use Debits & Credits

Lecture 7 Lecture Debits and Credits

Section 6: Know how to Journalize Business Transactions

Lecture 8 Lecture - Know how to Journalize Business Transactions

Section 7: Know how to Adjust the Accounts & Complete the Accounting Cycle

Lecture 9 Lecture on Adjusting Entries

Section 8: Know how the Accountant Uses the Worksheet

Lecture 10 Lecture on the worksheet

Section 9: Know how to Close the Books

Lecture 11 Lecture - Closing the Books

Section 10: Fraser's Golf Academy Practice set of Accounting Records

Lecture 12 Fraser's Golf Academy accounting records

Lecture 13 Introduction to Fraser's Academy Case

Section 11: Fraser's Excel and video solution

Lecture 14 Fraser's Excel and video solution

Section 12: Recording business Transactions for a Merchandise Company

Lecture 15 Recording the purchase of merchandise

Lecture 16 Recording journal entries for a business that sells merchandise.

Section 13: Excel entries problem on merchandise

Lecture 17 Introduction to problem

Section 14: Mullti Step Income Statement

Lecture 18 Lecture on Multi Step Income Statement

Section 15: Tom's Pro Golf Shop - Practice set for a Merchandise Company

Lecture 19 Tom's Golf Shop

Lecture 20 Tom's Golf Part 1

Lecture 21 Tom"s Golf Part 2

Section 16: Depreciation

Lecture 22 How to calculate depreciation

People interested in doing bookkeeping