How Intercompany Transactions Work in Sage 100
The process starts when one entity provides a product, service, funding, or other resource to another related entity. The accounting team identifies both entities, determines the transaction value, selects the appropriate general ledger accounts, and records the corresponding entries. Depending on the implementation, entries may be entered separately in each entity's company database or coordinated through configured integrations and supported import processes.
A typical workflow includes identifying the transaction, confirming the supporting documentation, recording the seller's and buyer's entries, reconciling intercompany balances, and resolving differences before period-end close. The receiving entity should verify the amount, transaction date, account coding, and any applicable tax treatment. Both sides should retain a common reference so that finance teams can match the entries efficiently.
For example, Entity A provides $25,000 of administrative services to Entity B. Entity A records a $25,000 intercompany receivable and service revenue, while Entity B records a $25,000 intercompany payable and administrative expense. The entries should reflect the agreed transaction terms and applicable accounting policies. If the charge remains unpaid at month-end, both entities should report corresponding intercompany balances.
Common Transaction Types and Accounting Treatment
Intercompany activity can affect several areas of accounting. The appropriate accounts depend on the transaction's substance, the entities involved, and the organization's accounting policies.
- Intercompany sales: The selling entity records revenue and a receivable, while the purchasing entity records the appropriate asset or expense and a payable.
- Shared expense allocations: One entity initially pays a common expense and allocates an agreed portion to other entities using an approved allocation method.
- Intercompany loans: The lending entity records a receivable, and the borrowing entity records a corresponding liability.
- Inventory transfers: The entities record the transfer using agreed valuation and inventory accounting procedures, including any required adjustments.
- Foreign-currency transactions: Entities record transactions in accordance with applicable currency policies and evaluate exchange differences where required.
When transactions involve different countries, tax registrations, or currencies, finance teams should determine the applicable tax rules and exchange-rate treatment. VAT Intercompany Transactions are particularly relevant when related entities exchange taxable goods or services, since the correct VAT treatment depends on jurisdiction, transaction structure, and local regulations.
Reconciliation and Consolidated Reporting
Intercompany reconciliation compares the balances recorded by each participating entity. Differences may arise because entries are posted in different periods, invoices are recorded by only one entity, exchange rates differ, or transactions are assigned to inconsistent accounts. Finance teams should investigate these differences using transaction references, supporting invoices, journal entries, and counterparty statements.
For example, if Entity A reports a $25,000 receivable but Entity B records only a $23,000 payable, the $2,000 difference must be investigated before the balances can be considered reconciled. The cause may be a partial posting, a disputed charge, or an incorrect amount. Correcting the underlying records and documenting the adjustment helps establish consistent entity-level reporting.
During consolidation, qualifying intercompany income, expenses, receivables, payables, and other balances are generally eliminated under the applicable consolidation framework. These eliminations prevent internal group activity from being presented as activity with external parties. Entity-level books should still preserve the original transactions for accountability, audit support, and local reporting.
Controls, Automation, and Data Accuracy
Strong intercompany controls begin with consistent entity identifiers, approved account mappings, documented transaction terms, and clear responsibilities for recording and reviewing entries. Finance teams should establish procedures for matching counterpart entries, reviewing unusual balances, confirming tax treatment, and resolving differences before financial close.
The Hyperbots Platform can support company-specific finance workflows through ERP integrations, configurable roles, approval processes, and general ledger structures. Process Specific Capabilities provide AI automation tailored to finance processes, while Ready to Deploy Capabilities combine pre-trained agents, ERP connectors, and configurable workflows. Self Learning Capabilities help co-pilots refine workflows and coding based on human actions, and Human in the Loop controls allow exceptions to be escalated for review and approval.
When evaluating AI-supported accounting processes, What’s Missing from Financial AI Training Data explores why representative invoices and transaction records matter for finance automation. Organizations using Sage 300 can also examine AI Copilots for Sage 300 to understand how AI copilots can support accounting workflows in that separate ERP environment. Neither capability should be assumed to be natively included in Sage 100; implementation and integration requirements should be verified for the specific system.
Best Practices for Managing Intercompany Activity
A consistent operating procedure helps each entity record transactions using the same underlying information. Finance teams should agree on transaction references, posting deadlines, account mappings, exchange-rate conventions, and reconciliation responsibilities. Navigate Multi-Currency Transactions: Tips for Finance Teams provides relevant guidance on currency selection, purchase order treatment, general ledger recording, and foreign-exchange gains and losses for international finance operations.
- Use consistent transaction identifiers and counterparty records across entities.
- Reconcile intercompany receivables and payables at each reporting close.
- Review Duplicate Transactions to identify repeated postings that could distort balances or expenses.
- Document allocation methods, supporting invoices, and approval evidence.
- Apply appropriate tax and foreign-currency policies for each transaction.
- Maintain a clear distinction between entity-level accounting entries and consolidation eliminations.
These practices improve the reliability of financial statements, support audit readiness, and help management understand how resources and obligations move across the corporate group.
Summary
Sage 100 Intercompany Transactions represent financial activity between related entities that must be recorded consistently and reconciled across their respective accounting records. Accurate account mapping, supporting documentation, timely reconciliation, and appropriate tax and currency treatment help maintain reliable entity-level reporting. With well-defined controls and suitable workflow integrations, finance teams can improve close efficiency, support consolidation, and strengthen financial visibility across the organization.