Intercompany Transactions
Intercompany transactions are business transactions between companies within the same consolidation group. These transactions must be tracked, reconciled, and eliminated during consolidation to prevent overstating the group’s financial position.What Are Intercompany Transactions?
Intercompany transactions occur when related companies do business with each other:- Sales and purchases - One company sells goods/services to another
- Loans - One company lends money to another
- Management fees - Charges for shared services or management
- Dividends - Subsidiary pays dividends to parent
- Capital contributions - Parent invests capital in subsidiary
- Cost allocations - Shared costs allocated across entities
- Royalties - Payments for intellectual property use
Transaction Lifecycle
Transaction Types
The system tracks seven types of intercompany transactions:Sale/Purchase
Description: Sale or purchase of goods or services between group companies. Typical Accounts:- Seller: Intercompany Revenue, Intercompany Receivable
- Buyer: Inventory/COGS, Intercompany Payable
Loan
Description: Intercompany loans including principal and interest. Typical Accounts:- Lender: Intercompany Loan Receivable, Interest Income
- Borrower: Intercompany Loan Payable, Interest Expense
Management Fee
Description: Charges for management services, shared services, or administrative support. Typical Accounts:- Service Provider: Management Fee Revenue
- Service Recipient: Management Fee Expense
Dividend
Description: Dividend distributions from subsidiary to parent. Typical Accounts:- Subsidiary: Dividends Paid (equity)
- Parent: Dividend Income
Dividend eliminations affect the equity section of the consolidated balance sheet and may impact retained earnings calculations.
Capital Contribution
Description: Capital invested by parent in subsidiary. Typical Accounts:- Parent: Investment in Subsidiary
- Subsidiary: Paid-in Capital
Cost Allocation
Description: Allocation of shared costs (rent, IT, HR) across entities. Typical Accounts:- Allocating Company: Cost Allocation Expense (recovery)
- Receiving Company: Allocated Cost Expense
Royalty
Description: Payments for use of intellectual property (trademarks, patents, technology). Typical Accounts:- IP Owner: Royalty Income
- IP User: Royalty Expense
Matching Statuses
The system tracks the reconciliation status of each intercompany transaction:Matched
Status: Both sides agree - entries on both companies match exactly. Indicators:- ✓ Both journal entry IDs are present
- ✓ Amounts match exactly
- ✓ Transaction dates align
Unmatched
Status: Missing entry on one side - only one company has recorded the transaction. Indicators:- ✗ Only one journal entry ID present
- ⚠️ Other side hasn’t recorded transaction yet
Partially Matched
Status: Amounts differ - both sides have entries but amounts don’t match. Indicators:- ✓ Both journal entry IDs present
- ✗ Amounts don’t match
- ⚠️ Variance amount calculated
Variance Approved
Status: Difference accepted - variance has been reviewed and approved. Indicators:- ✓ Both journal entry IDs present
- ⚠️ Known variance with explanation
- ✓ Approved for elimination
Variances may be legitimate (timing differences, FX translation, rounding) or may indicate errors requiring correction. Always document the reason for approving a variance.
Creating Intercompany Transactions
There are two ways to create intercompany transaction records:Automatic Creation (Recommended)
When recording journal entries, flag intercompany transactions:- Create journal entry as usual
- Enable Intercompany transaction flag
- Select Partner company (the related party)
- Choose Transaction type (Sale/Purchase, Loan, etc.)
- System automatically creates intercompany transaction record
Manual Creation
For historical or imported transactions:- Navigate to Consolidation > Intercompany Transactions
- Click Create Transaction
- Fill in:
- From company (seller/lender)
- To company (buyer/borrower)
- Transaction type
- Date and amount
- Link to journal entries (if available)
Reconciling Intercompany Transactions
Regular reconciliation ensures accurate consolidation:Intercompany Transaction Properties
Each intercompany transaction contains:Intercompany Accounts Setup
For effective intercompany tracking, set up dedicated accounts:Recommended Account Structure
Designate account range 9000-9999 for all intercompany accounts: Balance Sheet Accounts:- 9010-9099: Intercompany Receivables
- 9100-9199: Intercompany Payables
- 9200-9299: Intercompany Loans (Receivable)
- 9300-9399: Intercompany Loans (Payable)
- 9400-9499: Intercompany Revenue
- 9500-9599: Intercompany COGS/Expenses
- 9600-9699: Intercompany Interest Income
- 9700-9799: Intercompany Interest Expense
- 9800-9899: Intercompany Dividends
- 9900-9999: Investment in Subsidiaries
Consistent account numbering across all group companies simplifies reconciliation and makes it easier to configure elimination rules.
Viewing Intercompany Transaction Reports
The system provides several reports for managing intercompany transactions:Intercompany Transaction Listing
View all transactions with filtering options:- By company pair
- By transaction type
- By matching status
- By date range
Intercompany Reconciliation Report
Side-by-side comparison of both sides of each transaction:- From company amount
- To company amount
- Variance
- Matching status
Unresolved Variances Report
Highlights transactions requiring attention:- Unmatched transactions
- Partially matched with variances
- Aging of unresolved items
Consolidation Impact
During consolidation runs, the system:- Matches intercompany transactions - Identifies corresponding entries on both sides
- Calculates variances - Determines if amounts match
- Applies elimination rules - Removes matched or approved transactions
- Reports exceptions - Flags unmatched or unapproved variances
Best Practices
Use standardized intercompany accounts
Use standardized intercompany accounts
All group companies should use the same account numbers for intercompany transactions. This simplifies reconciliation and elimination rule configuration.
Reconcile monthly
Reconcile monthly
Don’t wait until consolidation time to reconcile intercompany transactions. Monthly reconciliation identifies discrepancies when they’re easier to resolve.
Document all variances
Document all variances
Every approved variance should have a clear explanation. This creates an audit trail and helps others understand the reasoning.
Establish cut-off procedures
Establish cut-off procedures
Define clear cut-off dates for recording intercompany transactions to minimize timing differences between companies.
Use intercompany flags consistently
Use intercompany flags consistently
Train all users to consistently flag intercompany transactions when creating journal entries. This ensures complete tracking.
Communicate across entities
Communicate across entities
Establish regular communication between accounting teams at different entities to quickly resolve discrepancies.
Common Scenarios
Scenario 1: Intercompany Sale
Transaction: Company A sells $25,000 of inventory to Company B. Company A books:Scenario 2: Intercompany Loan
Transaction: Parent lends $100,000 to Subsidiary at 5% interest. Parent books:- Parent: DR Interest Receivable / CR Interest Income
- Subsidiary: DR Interest Expense / CR Interest Payable
Scenario 3: Dividend Payment
Transaction: Subsidiary declares $50,000 dividend to 100% owner Parent. Subsidiary books:Next Steps
Elimination Rules
Configure automatic elimination rules
Consolidation
Run the full consolidation process
Journal Entries
Create and manage journal entries