Do Bookkeeping using excel to keep your records& Earn Money

Do Bookkeeping using excel to keep your records& Earn Money

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 transactions

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

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

Url: View Details

What you will 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.

Rating: 3.95

Level: All Levels

Duration: 3 hours

Instructor: Dr. John Daniel Mclellan