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 .

Learn and Master the Accounting  ( Bookkepping) Process.

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

Course Content

  • Overview of this course –> 1 lecture • 1min.
  • Introduction to Business –> 3 lectures • 18min.
  • Know how to present the Income Statement and Balance Sheet –> 1 lecture • 13min.
  • Analyzing business transactions. –> 1 lecture • 15min.
  • Know how to use Debits & Credits –> 1 lecture • 7min.
  • Know how to Journalize Business Transactions –> 1 lecture • 16min.
  • Know how to Adjust the Accounts & Complete the Accounting Cycle –> 1 lecture • 18min.
  • Know how the Accountant Uses the Worksheet –> 1 lecture • 15min.
  • Know how to Close the Books –> 1 lecture • 8min.
  • Fraser’s Golf Academy Practice set of Accounting Records –> 2 lectures • 6min.
  • Fraser’s Excel and video solution –> 1 lecture • 15min.
  • Recording business Transactions for a Merchandise Company –> 2 lectures • 21min.
  • Excel entries problem on merchandise –> 1 lecture • 1min.
  • Mullti Step Income Statement –> 1 lecture • 6min.
  • Tom’s Pro Golf Shop – Practice set for a Merchandise Company –> 3 lectures • 27min.
  • Depreciation –> 1 lecture • 5min.

Do Bookkeeping using excel to keep your records& Earn Money

Requirements

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.

Get Tutorial