About this course

Course code TPZL1_P8221
Duration 5 Days

This course teaches application developers how to set up a Controller application and effectively use Controller in their organization's consolidation process. Students will also design and generate financial reports using Controller. Through a series of lectures and hands-on exercises, students will set up a Controller application by creating the necessary structures (such as accounts and companies), and then test the application to ensure that it works properly. Students will also learn how to work with currency translation, allocations, intercompany transactions, investments in subsidiaries, advanced formula calculations, and user-defined business rules, as well as define configuration settings and user access to the application.

Outline

  • Create companies, consolidation types, and account structures
  • Create and organize forms for entering data into the Controller application
  • Generate movement accounts to show changes to data over time
  • Create extended dimensions to enhance data analysis
  • Link structures to customize end users' access to Controller data
  • Define and schedule the data entry process
  • Test the Controller application setup
  • Adjust data through journal entries
  • Translate foreign currencies
  • Enable automatically created journal entries
  • Allocate values
  • Reconcile and eliminate intercompany transactions
  • Work with shareholdings and investments in group companies
  • Calculate and eliminate acquisition values
  • Consolidate a group's reported values
  • Define security restrictions to different parts of the application
  • Eliminate intercompany profit
  • Create complex stored calculations
  • Customize the consolidation process using user-defined business rules (UDBRs)
  • Create ad hoc reports to quickly analyze and compare figures
  • Run standard reports to verify and analyze data for consolidation
  • Create custom reports using the Report Generator
  • Create, modify, and run reports in Excel using the Excel Link
  • Run multiple reports simultaneously by grouping reports into report books
  • Identify different consolidation models (Optional)

5 Days

Duration
Delivery Method

Delivery method

Classroom

Face-to-face learning in the comfort of our quality nationwide centres, with free refreshments and Wi-Fi.

Find dates and prices

Online booking is currently not available for this course, to find out more please call us on 0345 074 7998 or email us at info@qa.com to discuss how we can help.

Trusted, awarded and accredited

Fully accredited to ensure we provide the highest possible standards in learning

All third party trademark rights acknowledged.