Canada Bookkeeping

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
P
Created by PromptLib Team
Published February 10, 2026
4,131 copies
3.8 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

More Like This

Back to Library

Canadian Employee Benefit Compliance Tracker

This prompt transforms AI into a specialized Canadian bookkeeping assistant that analyzes employee benefit data, determines taxable vs. non-taxable status under CRA guidelines, calculates CPP/EI implications, and generates compliant journal entries. It ensures accurate year-end T4 preparation while flagging provincial variations and missing documentation.

#canada#bookkeeping+3
4,097
3.8

AI Cloud Accounting Migrator

This prompt generates a comprehensive, phase-by-phase migration plan for moving Canadian business accounting data from legacy desktop systems (QuickBooks Desktop, Sage 50, Excel) to modern cloud platforms (QBO, Xero, Sage Cloud). It ensures provincial tax compliance (GST/HST/PST/QST), maintains CRA record-keeping standards, and provides specific data validation protocols to prevent common migration failures.

#gst-hst#canada-bookkeeping+3
2,401
4.7

AI Scientific Research Calculator for Canadian Bookkeeping

This prompt template helps Canadian businesses and bookkeepers accurately calculate Scientific Research and Experimental Development (SR&ED) tax credits, generate compliant documentation, and maximize eligible claims. It transforms complex CRA requirements into structured, audit-ready outputs.

#sr&ed#canadian-tax+6
4,854
4.9
Get This Prompt
Free
Quick Actions
Estimated time:11 min
Verified by94 experts