Online Trainee Accountant Bootcamp Bookkeeping on MS Excel 1


CPD hours: 7 Hours

Price: R650.00

Video Type: Single

...

Online Trainee Accountant Bootcamp Bookkeeping on MS Excel 1

CPD Hours: 7

Price: R650.00


This is part of a series

Read more about series
Back
Title / Topic

Online Trainee Accountant Bootcamp Bookkeeping on MS Excel 1

Presenters : Innocent Shongedza

This webinar on demand is part of a series of webinars. Click here to read more


Overview   

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


Learning objectives  

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.  


Content 

  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. 

Related Webinars

...

Monthly Compliance and Legislation Update - August


2 Hours
R399.00

...

Monthly Compliance and Legislation Update - May 2022


2 Hours
R380.00

...

Drafting IFRS and Companies Act Compliant Financial Statements


2 Hours
R450.00

Need Help ?

Explore Smarty