Learn about setting up an analysis when your company data contains multiple subsidiaries or entities. For example, if you are analyzing data for a group. The article talks about how to run an analysis with multiple entities.
If your organization has financial data spanning multiple subsidiaries, there are 3 methods available to complete the analysis.
1. Analyze the complete general ledger data set with all subsidiary data in one combined file, with a subsidiary ID column for reference and sampling
For this method, your data must have a column containing a subsidiary ID for each entry (used for reference and sampling). This column addition produces a combined risk assessment of the fiscal year activity across the entire parent company, compiles the different subsidiary data into one pool for sampling, and shows combined subsidiary trends and ratio behaviours.
2. Analyze the data for each subsidiary under separate analyses (within the same engagement)
This method produces separate risk assessments for each subsidiary and isolates the subsidiary data into separate sampling pools, trends, and ratio behaviours. All samples must be appropriately labeled per subsidiary for MindBridge to successfully distinguish this data in the compiled audit plan for this engagement.
This method requires the subsidiary companies to have either identical or completely different account mappings, as each unique account number can only have one mapping assigned to it per engagement.
3. Analyze each subsidiary as a separate engagement (within the same parent organization)
This method produces separate financial statements, risk assessments, trending reports, and audit plans for each subsidiary.
You must use this method if account definitions interchange between different subsidiaries. For example:
- Subsidiary A: Account 123 = Definition A
- Subsidiary B: Account 123 = Definition B