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