Assistant Accountant Package

一张图了解澳洲助理会计的全部内容

100% 还原澳洲上市公司操作场景

General Ledger Journals

  • General Ledger : AP – AR – Payroll related GL JNL
  • Posting Journals in SAP-ERP environment
  • Prepare Journals:  Prepayment, Accrual  & Provision
  • Cost Allocation Journal in Power Query environment
  • Payroll Journal in Power  Pivot  environment

Month End closing procedure

  • AP Cut-off  in SAP-ERP environment
  • AR Cut-off  in SAP-ERP environment
  • Payroll Cut-off  and accrual using Excel Modelling
  • Month end related Data Cleaning in Power Query
  • Month end task list preparation procedures

Balance Sheet Reconciliation

  • GST  &  BAS Return automation in Power Pivot
  • Bank REC and Suspense Accounts REC
  • Works Compensation Premium & Clearing Accounts
  • Provision for FBT & Clearing Account REC
  • Creditor and Debtor Aging Report in ERP- SAP 

Year End close procedure

  • Asset Under Construction year end REC
  • Long Service leave year end  reconciliation
  • Fixed Asset Register & DEPN  in  SAP – ERP
  • Year end balance Sheet REC preparation list
  • Year end prepared by customer Audit List

Excel Data Modelling

  • Tabular format to matrix report
  • Multiple tabular format to matrix report
  • Multiple matrix format to matrix report
  • Consolidation from multiple worksheets
  • Consolidation from dynamic table ranges

Power Query data manipulation

  • Asset Under Construction year end REC
  • Long Service leave year end  reconciliation
  • Fixed Asset Register & DEPN  in  SAP – ERP
  • Year end balance Sheet REC preparation list
  • Year end prepared by customer Audit List