Part One: 实战课程-Practical Technical Accounting Procedure Training
Section 1: 会计事务所(Public Practice Accounting -Business Services Accounting):
Case one:
Business activity: Bread shop - a purchased franchise business
Business structure: Partnership
Cash basis for both income tax & GST
Job description:
Based on client's bookkeeping records in excel file, analyzing coding and processing the records into handiledger system on quarterly basis.
Reconcile payroll, GST account and other balance sheet items. Preparation of quarterly BAS for lodgment
At the annual trial balance stage: reconcile payroll, cash at bank, GST account, non-current asset's value in balance sheet vs. depreciation schedule
Preparation of financial statements including P & L, balance sheet, notes to the accounts, depreciation report etc.
Preparation of partnership tax return
Preparation of partner's individual income tax returns incl. rental schedule, capital gain schedule etc.
Case two:
Business activity: Real estate company
Business structure: private company
Accrual basis for both GST & income tax
Job description:
Process bank statements into the system according to bank statements and cheque butts provided by the client on the quarterly basis.
Reconcile payroll, GST account and other balance sheet items. Preparation of quarterly BAS for lodgment (1st year option one, 2nd year option three with PAYG installment and annual GST return)
Preparation of depreciation schedules
At the annual trial balance stage: reconcile payroll, cash at bank, ATO integrated client account, non-current asset's value in balance sheet vs. depreciation schedule
Motor vehicle log book, private portion (potentially FBT)
Preparation of financial statements including P & L, balance sheet, notes to the accounts, depreciation report etc.
Preparation of company tax return including franking accounts, tax break concession.
Preparation of director's individual income tax returns incl. rental schedule, capital gain schedule, managed funds investments etc.
Case three:
Business activity: Real property (rental property) and share investment
Business Structure: Discretionary family trust
Job description:
Process bank statements into the system according to bank statements, dividend slips (cash payments and dividend reinvestment plan)
Share purchase, sale contract notes and rental statements etc
Preparation of share trading, dividend and rental schedules in excel file
Bank reconciliation; cross check/reconcile ledger account with excel schedules
Preparation of financial statements including P & L, balance sheet, notes to the accounts, trust distribution statements etc.
Preparation of trust tax return including trust distribution to beneficiaries
Preparation of beneficiary's individual income tax returns including the distribution received from the trust.
Case four:
Business activity: Grocery retail shop (also deliver the goods to restaurants)
Business structure: private company
Cash basis for both income tax & GST
Job description:
Process bank statements into the system according to bank statements and cheque butts provided by the client on the quarterly basis.
Process client's cash book records into the system on the quarterly basis.
Recording client's commercial vehicle hire purchase (GST treatment, unexpired interest amortization, current vs. non-current lease liability)
Reconcile payroll, ATO integrated client account and other balance sheet items.
Preparation of quarterly BAS for lodgment (1st year option one, 2nd year option three with PAYG installment and annual GST return)
Preparation of depreciation schedules
At the annual trial balance stage: reconcile payroll, cash at bank, GST account, non-current asset's value in balance sheet vs. depreciation schedule & hire purchase amortization accounts
Preparation of financial statements including P & L, balance sheet, notes to the accounts, depreciation report etc.
Preparation of company tax return including franking accounts (dividend payments to shareholders )
Preparation of director's individual income tax returns incl. share trading schedule
Case Five: Tax returns for individuals
Tax return for indivual including work related expense,employee share scheme ,reportable fringe benefit ,lum sum payments
Tax return for senior including centrelink allowance and pensions ,tax offset, investment property and other investment
Section 2: 公司会计(Commercial Accounting-Financial Reporting)
Session 1:
DNC Commercial Accounting Course Introduction
Commercial Accounting Job Examples
Common Finance Team Structure (SME and Corporation)
Accounting Software vs ERP
General Ledger and Accounts List 101
Introduction of GST and related accounts
Month-End Procedures (AR, AP, Banking, Payroll and Financial Reporting)
Case Study Background Introduction
Overview of MYOB Accountright Plus
Company Data File Set-up in MYOB
Account List & Trial Balance Set-up
Session 2:
AP Procedure Overview
New Credit Trading Account Application
Supplier Creation & Maintenance in MYOB
Purchase Orders & Invoice Conversion
Inventory /Cost of Sales Invoices
Fixed Assets Invoice
Expense Invoices
Case Studies – Different Scenarios
Credit Note/Statement Invoice
Cash Purchase/Staff Reimbursement
Supplier Statement Reconciliation
AP Invoice Payment Processing
Credit Card Processing
AP Invoice Entry Reversal
Cheque Writing
Invoice Filing
Session 3:
AR Procedure Overview
New Accounts Application Reference Check
Accounts Receivable Position & Duties
Customer Creation & Maintenance in MYOB
Invoice/Credit Note Creation and Handling
Income Types (Revenue, Pre-Billed Revenue & Deferred Revenue)
Cash Sales
Payment Allocation
Cheque Deposit
Trade Debtor Collection Roadmap (Real Example)
Session 4:
Payroll Procedure Overview
National Employment Standards (NES) and Awards Introduction
TFN Declaration Form
Superannuation Set-up Form
Payroll Set-up (Link to Balance Sheet & Profit/Loss Statement)
Employee Set-up (Perm vs Perm Shift Worker vs Casual)
Government Paid Leave
Permanent Payroll Processing (Penalty Rate, Overtime, etc.)
Casual Payroll Processing (Casual Loading, Penalty Rate, etc.)
Time Billing (Project-Based)
How to Adjust Payroll Error
How to Process Rejected Payment
Payroll Activity Summary and its interpretation
Payroll Advice Report and its interpretation
PAYG Summary (Formerly known as Group Certificate)
Session 5:
Month End Reporting Procedure Overview
Bank Reconciliation
Trade Debtor/Trade Creditor Reconciliation
End of Month (EOM) Journals (Prepayment, Deferral & Accrual, Depreciation, Expense Recharge, Inventory Reserve, Bad Debt Provision, etc.)
Balance Sheet Reconciliation
GST Submission (Paper Form vs BAS Link)
Employee PAYG Submission
Payroll Tax in NSW
Summary of MYOB Course
Section 3: Introduction to SAP
大型跨国公司会计(Commercial Accounting- Multinational company)
Session One:
Introduction to SAP the company & SAP ERP Core Modules
Introduction to SAP Screens & Menu
SAP General Ledger account master record overview
Profit Centre Accounting
Cost Centre Accounting
Cost Element Accounting
SAP General Ledger Processing
Introduction to Management Accounting Process
Introduction to Management Reporting
Session Two: SAP AR and AP
Accounts Receivables (Credit Controller) Introduction:
Role Description of the AR (Credit Controller)
Company Policy(AR) and procedures detailed explanation (multinational company real case)
Some key definitions
Authorisation and Responsibilities
Policies (open new account, Debt collection, Credit limit, Credit Applications, DSO)
Key performance dressed and explanation
Workflow chart process explanation
GL JOUNRNAL
SAP Example: Customer set up, Invoice Enter, Credit limit Set up
Accounts Payable Introduction:
Role Description of the AP
Company Policy(AP) and procedures detailed explanation (multinational company real case)
Key performance dressed and explanation
Workflow chart process explanation
GL JOURNAL
SAP Example: vendor set up, Vendor invoices Enter
Section 4: Interview Preparation & CV 精修班
Part 1: Interview Preparation
Introduction:
Company Structure
HR’s Functions
Job Interviews / Resume
How to find the ideal job:
Identify yourself
What is your objective?
Channels for job information
Understand Job Description & Requirements:
Company background research
Understanding the industry knowledge
Think as you are the employer
Part 2: Resume/CV
Cover Letter:
Purpose of Cover Letter
How to write a fascinating letter
Resume:
Why you need a resume
Structure your CV / Resume Formats
Key Words
Including the right information
How to developing your resume
Most common mistakes & how to avoid
Part 3: Interviews
Get yourself ready for the interview
Types of Interviews
Telephone Interview
One to One Interview / Individual Interview
Panel Interview / Group Interview
Common Questions in different stage of interviews
Section 5: 办公室软件Microsoft Excel Modeling
课程设置:
本课程适合对Excel有一定初级基础的同学;
全英文教学,6hours per day/2days;
6大经典报表案例贯穿课程,倾述本人亲身经历,让你看透Excel;
独创6大情景,体会Excel在面试与职场中的巨大威力;
课程鼓励互动式教学,激发学生思考与对Excel用法的创新;
对Excel功能覆盖全面,包括高级函数,透视表,条件格式,复杂数据导入,数据整合,报表仪表盘,高级图表设计,表格排版以及少量对VBA的运用,让你大幅提高工作效率;
Case one:Tele-communication
Advanced Data Delimitation
Advanced Functions VLOOKUP + OFFSET
Advanced Text Functions LEFT + FIND + SERACH
Intermediate Data setup for Dashboard
Case Two:Airline company
Advanced SUMIFS, COUNTIFS, SUMPRODUCT
Intermediate ARRAY formulas
Advanced Sorting
Advanced Report printing set up
Advanced Pivot Table manipulation
Case Three:Retail
Advanced UDF
Immediate VBA editor navigations
Understanding of Excel Objects
Basic Looping
Basic VBA Macro recordings
Case Four:IT
Advanced Excel Theme and Colour manipulation
Advanced Charting manipulation
Advanced dynamic object manipulation
Advanced layout analytical mind
Advanced Data validations
Case Five:Banking
Advanced web link to RBA for interest base rate
Advanced conditional formatting
Advanced Protected controls
Advanced Data validation for controls
Immediate Goal Seek Analysis
Print objects manipulation
Advanced data formatting manipulation
Advanced Excel VBA looping methods
Advanced Short Cut Keys Usages
Part Two: 猎头面试训练-Local HR recruiter mock interview and feedbacks
远大强强联手Local 猎头服务公司推出年度最Valuable PCD Workshop,为优秀的你带来VIP式优质就业指导以及职位引荐服务,手把手带你走上澳洲职场
我们的Career workshop为行业首创的真实面试模拟及上市公司面试Assessment center 的形式。相信大部分同学都有过面试失败经历,但你是否得到正确的反馈,了解自己为何而失败呢?我们的模拟面试采用现场录像模式,对我们的后期反馈留下了最真实的一刻。在我们的冬令营中,此部分课程成为学生最收益,也最难忘的部分,真实看到了与HR面试后种种失败的具体原因。
课程内容
Session 1: It’s all about you
找工作期间,你的简历将是你踏入职场的第一印象,这取决于你是否会让未来的雇主或中介对你产生兴趣从而联系进行进一步的面试。那到底什么才是雇主愿意看到的简历呢?这是一个很puzzle的问题,是不是你常常疑惑为什么我投了这么多简历但是依然没有任何回复?而我们的任务就是帮助你投出最有目标性的简历,以最快的速度得到雇主的回复!
更为创新的是,我们运用猎头模拟面试的方式,还原每一个学员面试的真实场景,给予正确的反馈,让同学们真正认识到海外留学生澳洲就业存在的普遍问题,更可以给从未有过澳洲面试经验的同学一个真实的面试流程,真正认识到自己在面试时存在的问题。
What you’ll learn:
Resume and cover letter writing
Basics of resume writing
Different kind of resumes and which one to use
Dos and Don’ts
How to summarize your school/work history in less than 2 pages
How to tailor your resume and cover letter to specific jobs and companies
Resume rescue workshop
Practical hands on resume writing activity
How to brainstorm ideas for showcasing yourself in the best light
How to identify and highlight your achievements on paper
What’s missing from your resume and what you should include
One on one help and review by career coach
Section 2 : 1 to 1 Mock interview and video taking
Section 3 : 1 to 1 interview feedbacks
Section 4: Group interview assessment center
Section 5 : Group interview feedbacks