Financial Accountant Package

一张图了解澳洲财务会计的全部内容

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

Act vs Bud Variance Reporting

  • COA DIMENSIONS & HIERARCHY
  • VOLUME & RATE VARIANCE
  • SALES VARIANCE ANALYSIS
  • STANDARD COSTING ANALYSIS
  • CATEGORY VARIANCE ANALYSIS

Act vs Bud OLAP Modelling

  • Excel OPEX VARIANCE Model
  • DYNAMIC CONTROL & FOMATTING
  • Power BIl OPEX VARIANCE Model
  • Power BI Cubeset Formula  setup
  • Power BI Cube Formula Nesting

Analysing Financial statements

  • INDIRECT CASH FLOW REPORT
  • RESTRUCTURE PROFIT & LOSS
  • BALANCE SHEET RESTRUCTURE
  • DRIVER-TREE ANALYSIS
  • DU PONT SUMMARY

Financial Statements Dashboard

  • B/S DYNAMIC DASHBOARD REPORT
  • P&L DYNAMIC DASHBOARD REPORT
  • CASH FLOW DYNAMIC DASHBOARD REPORT
  • DASHBOARD CONTROL PANEL NAVIGATION DESIGN
  • DASHBOARD MODEL DESIGN PRINCIPLES

Consolidating Financial Statements

  • GLOBAL BUSINESS STRUCTURE
  • INTER-COMPANY TRANSACTION
  • MULTIPLE CURRENCIES
  • MINORITY INTEREST
  • CONSOLIDATING P&L

Time Intelligence Reporting

  • Case 1:Working with Calendar Table
  • Case 2: Calculating Working Days
  • Case 3:Calculate running total
  • Case 4:Calculate YTD, MTD and QTD
  • Case 5: Closing Balance Over Time