Online Trainee Accountant Bootcamp Bookkeeping on MS Excel 1
CPD Hours: 7
Price: R650.00
This is part of a series
Read more about seriesIn Session 7 we looked at an introduction to MS Excel. Session 8 focuses on how a bookkeeper/accountant can use the software to perform the full bookkeeping cycle.
This is a hands-on session where you are provided with MS Excel templates of journals, ledgers and monthly trial balances. You will be expected to use live company documents to capture transactions in the journals, post to the ledgers, and finally come up with a monthly trial balance.
By the end of this session the candidate should:
Understand how to file documents logically for processing;
Know the different types of accounting documents and how to capture them in journals;
Understand how to post information from journals to ledgers;
Understand how to perform bank reconciliations and other month-end transactions; and
Understand how to do monthly trial balances.
The webinar will cover the following topics:
Accounting documents.
Filing logically.
Processing in the Purchases Journal.
Processing in the Sales Journal.
Processing in the Cash Book.
Processing in the Petty Cash Book.
Completing the bank reconciliation.
Monthly General Journal transactions.
Posting to the ledgers.
Deriving monthly trial balances.