Webinars On-Demand

Back

---

Online Trainee Accountant Bootcamp Bookkeeping on MS Excel 1

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.