AI Intercompany Transaction Tracker

Automate the identification, classification, and reconciliation of intercompany transactions for Canadian bookkeeping compliance.

#canadian bookkeeping#intercompany transactions#consolidation#transfer pricing#aspe accounting

Created by PromptLib Team

February 10, 2026

4,131

Total Copies

3.8

Average Rating

You are an expert Canadian bookkeeping specialist with deep knowledge of intercompany transaction accounting, ASPE, and CRA consolidation requirements. ## TASK Analyze the provided transaction data to identify, classify, and track intercompany transactions between related entities for proper consolidation and tax compliance. ## INPUT DATA Company Structure: [COMPANY_STRUCTURE] - Parent Entity: [PARENT_ENTITY] - Subsidiaries/Related Entities: [RELATED_ENTITIES] - Ownership Percentages: [OWNERSHIP_PERCENTAGES] Transaction Period: [TRANSACTION_PERIOD] Transaction Data (provide as list, CSV, or description): [TRANSACTION_DATA] ## REQUIRED OUTPUT ### 1. INTERCOMPANY TRANSACTION IDENTIFICATION For each identified intercompany transaction, provide: | Date | Originating Entity | Counterparty Entity | Transaction Type | Description | Amount (CAD) | Currency (if not CAD) | Exchange Rate Used | Transaction Types to identify: - Sales/Purchases of goods/services - Loans/Advances (principal and interest) - Management fees/Shared service charges - Dividends/Distributions - Royalties/License fees - Asset transfers (inventory, PPE, intangible assets) - Guarantees/Commitments - Other (specify) ### 2. ELIMINATION ENTRIES REQUIRED For consolidation purposes, provide proposed elimination journal entries: | Entry # | Account (Consolidated) | Debit (CAD) | Credit (CAD) | Explanation | Affected Entities | Include specific considerations for: - Unrealized profits in inventory (upstream vs. downstream) - Unrealized gains on asset transfers - Intercompany loan interest - Management fee markups ### 3. CRA COMPLIANCE & TRANSFER PRICING ANALYSIS | Transaction Category | Transfer Pricing Method Suggested | Documentation Required | Arm's Length Range (if determinable) | Risk Level (Low/Med/High) | Flag transactions requiring: - T106 foreign affiliate reporting - IC87-2R International Transfer Pricing documentation - Section 247 recharacterization risk ### 4. RECONCILIATION STATUS | Counterparty Pair | Per Entity A Records | Per Entity B Records | Variance | Variance Explanation | Action Required | ### 5. SUMMARY DASHBOARD - Total Intercompany Revenue to Eliminate: $____ - Total Intercompany Expenses to Eliminate: $____ - Net Intercompany Loans Outstanding: $____ (by counterparty) - Unrealized Profit in Ending Inventory: $____ - High-Risk Transfer Pricing Items: # count - Documentation Gaps Identified: # count ## SPECIAL INSTRUCTIONS - Apply ASPE Section 1591 (Subsidiaries) and Section 1601 (Consolidated Financial Statements) principles - For private enterprises, note if parent-only or consolidated statements are being prepared - Highlight any transactions with non-resident related parties requiring T106 or NR4 considerations - Identify any potential GST/HST implications on intercompany charges (exempt vs. taxable) - Flag any payroll-related intercompany recharges requiring T4/T4A adjustments If transaction data is incomplete, request specific additional information needed to complete the analysis.

Best Use Cases

Monthly consolidation preparation for a Canadian private enterprise with multiple subsidiaries

Year-end audit preparation requiring complete intercompany elimination schedules

Transfer pricing documentation review for CRA compliance or advance pricing agreement negotiation

Post-acquisition integration of a new subsidiary's intercompany transaction flows into existing systems

Investigation of material variances between entity-recorded intercompany balances during reconciliation

Frequently Asked Questions

What if I don't have complete transaction data from all entities?

The prompt will identify gaps and request specific additional information needed. For consolidation purposes, you need both sides of intercompany transactions; one-sided analysis will flag high reconciliation risk.

Does this handle foreign currency transactions?

Yes. The prompt specifically addresses foreign currency transactions, exchange rate applications, and translation differences. Provide the actual rates used in your systems for accurate analysis.

Is this suitable for public companies using IFRS?

This prompt is optimized for Canadian private enterprises using ASPE. For IFRS consolidation (public companies), additional considerations like non-controlling interests, business combinations, and different impairment testing would need to be added.

What transfer pricing methods does this cover?

The prompt identifies appropriate methods per CRA guidance (CUP, resale price, cost plus, profit split, transactional net margin) and flags when documentation may be insufficient. It does not perform detailed comparable searches.

Can this replace my accountant for consolidation?

No. This tool assists with identification and preparation but professional judgment is required for complex eliminations, especially around unrealized profits, tax effects, and non-arm's length pricing adjustments.