Do Bookkeeping Using Excel To Keep Your Records& Earn Money

0

1

2

3

4

5

Posted on 01 Dec 11:34 | by mitsumi | 14 views

Last updated 3/2021
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 1.36 GB | Duration: 3h 10m

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