This program provides practical training in essential accounting and financial management tasks. Participants will learn how to manage Accounts Payable and Accounts Receivable, including setting up suppliers and customers, creating invoices, processing payments, and generating reports. The Payroll module covers setting up employees, processing pay runs, managing leave payments, and issuing payslips. Training in Microsoft Excel focuses on key functions like VLOOKUP and Pivot Tables. Participants will also gain skills in Bank Reconciliation, Tax Accounting (BAS, GST, and tax returns), and Fixed Assets Accounting, including tracking and depreciation of assets. The program concludes with lessons on Accruals, Prepayments, and Budgeting, providing the tools needed to handle everyday accounting tasks effectively. The primary goal of this program is to equip participants with practical skills, knowledge, and confidence to succeed in banking, accounting and financial management roles.
Course Structure
The course covers 9 modules to be run over 8 weeks and each module is broken down into 4 sections:
- Theoretical Overview
- Technical Applications in XERO
- Assignment
- Interview Questions (Technical plus Behavioral)
Course Modules
Week 1 & 2: Accounts Payable (Approx 6 hrs)
- Journal entries
- Setting up suppliers in the system
- Creating Purchase Orders
- Entering Bills
- Making payments
- Sending the Remittance Advice to the supplier
- Supplier reconciliations
- Generating the financial reports
Week 2 & 3: Accounts Receivable (Approx 4 hrs)
- Journal entries
- Setting up customers in the system
- Creating sales orders
- Creating Invoices
- Sending invoices to the customer
- Setting up invoice reminders
- Setting up repeat invoices
- Customer reconciliations
- Generating the financial reports
Week 3 & 4: Payroll (Approx 4 hrs)
- Journal entries
- Setting up the employees in the system
- Creating Employee cardfile
- Creating pay runs as per the pay calendar
- Annual Leave, Sick Leave payment
- Generating payment ABA files
- Issuing the Payslips
- Making the payments
Microsoft Excel: Week 4 & 5 (Approx 4 hrs)
- VLOOKUP, SUMIF/S, Pivot Table, COUNTIF/S, CONCATENATE, Conditional formatting, etc.
- Practical exercises on the above functions
Bank Reconciliation: Week 5 (Approx 2 hrs)
- Loading the bank statement
- Reconciling the bank statement against the invoices/bills
- Allocating transactions to the relevant account heads
- Running the Reconciliation report
Tax Accounting: Week 6 (Approx 2 hrs)
- Preparing the Business Activity Statement (BAS) report
- Insights on company tax return and individual tax return
- Running GST and other tax reports
Fixed Assets Accounting: Week 6 (Approx 2 hrs)
- Setting up the FA register in Xero
- Creating the Assets type
- Assigning assets to relevant asset types
- Registering the Assets
- Running Depreciations as per the depreciation schedule
Accruals & Prepayments: Week 7 (Approx 2 hrs)
- Creating manual journals for accruals and prepayments
- Running the amortization/prepayment schedule
Budgeting: Week 7 (Approx 2 hrs)
- Understanding Budgeting Basics
- Identifying Income and Expenses
- Setting up the budget
- Using Tools and Techniques for Budget Management
Career Counselling
- Resume, Cover Letter Building & Review
- LinkedIn Profile Optimization
- Job Strategy & Assistance
- Mock Interview Session: Behavioral & Technical
- Interview Preparation
- Assistance with Business and Professional Email Writing
