Intercompany reconciliation software
Find the intercompany mismatch before it breaks the statements.
Investigate by entity pair, month, amount, and source record. Tag and net the activity, reconcile it, produce the schedule, and eliminate it at report time with an audit trail.
Good fit: mixed systems, many entities, repeated Excel work-ups.
Intercompany reconciliation
Intercompany reconciliationMar 2026 · Read-only
- Reports
- Consolidation
- Intercompany
- Sources
- Mappings
- Exports
Entity pair
Entity A ↔ Entity B
Period
Mar 2026
Difference
Open
Import complete (read-only)
| Entity pair | Entity A amount | Entity B amount | Difference | Status |
|---|---|---|---|---|
| Entity A ↔ Entity B | $248,350 | $248,150 | $200 | Investigate |
| Entity C ↔ Entity D | $91,420 | $91,420 | $0 | Reconciled |
Source record detail
Read-only provenance
- Source system
- Sage
- Entity
- Entity A
- Counterparty
- Entity B
- GL account
- 2000 Due to/Due from affiliates
- Amount
- $200
- Imported
- Apr 1, 2026
Reconciliation history
Apr 1, 2026 · 10:15 AM
Imported from Sage
Read-only import.
Apr 1, 2026 · 10:20 AM
Matched to counterparty
Entity B record located.
Apr 1, 2026 · 10:35 AM
Difference identified
$200 open for investigation.
No automated GAAP entries. Eliminated at report time with a schedule.
Due to / due from
Mismatch problem
Due-to and due-from balances can fail to net to zero across entities. Month-end investigation often moves into spreadsheets when source records live in different ledgers.
Source-ledger records remain read-only
Inter-company transfers that do not equal zero.
| Intercompany relationship | Accounts | Transactions | Amount | Status |
|---|---|---|---|---|
| Atlantic–Elim. | 1 | 12 | -70,000.00 | Open |
| Quick Construction 2–Elim. | 1 | 96 | 30,000.00 | Open |
| Quick Construction–Elim. | 1 | 78 | 39,800.00 | Open |
| Construction subtotal | 3 | 186 | -200.00 | Needs review |
Open differences need the corresponding entry, not another summary export.
Workflow
Reconciliation workflow
Start with transaction type, entity pair, month, and amount. Then inspect the source transaction, record the correction, and keep the audit trail attached.
Investigate, correct, and schedule at report time.
Intercompany investigation
Read-only
Transaction type
Due to/Due from
Entity pair
Entity A ↔ Entity B
Months
Mar–Apr 2026
Amount search
$200
Status
Open
- 1Pair
- 2Search
- 3Source record
- 4Correction history
| Date | Source | Entity | Account | Memo | Amount | Status |
|---|---|---|---|---|---|---|
| Mar 15 2026 | Sage | Entity A | Due to/Due from affiliates | Shared service fees | $150 | Open |
| Mar 20 2026 | Yardi | Entity B | Due to/Due from affiliates | Intercompany support | $300 | Open |
| Apr 1 2026 | Sage | Entity A | Due to/Due from affiliates | Shared service fees | $200 | Open |
| Apr 5 2026 | Yardi | Entity B | Due to/Due from affiliates | Intercompany support | $200 | Open |
| Apr 12 2026 | Sage | Entity A | Due to/Due from affiliates | Reimbursement | $100 | Open |
Correction history
Selected record · Apr 1 2026 · $200
Apr 1, 2026 · 10:15 AM
Imported read-only
System · Record imported from Sage.
Apr 1, 2026 · 10:20 AM
Matched to counterparty
System · Matched to the Entity B record.
Apr 1, 2026 · 10:35 AM
Status changed to Investigate
Analyst · Difference identified: $200.
Global transaction search
Read-only
Amount
$200
Source detail
Due to/Due from
Period
Mar–Apr 2026
Sources
Yardi, Sage, MRI, QuickBooks, Rails, Other GL
| Date | Source | Entity | Account | Description | Amount | Match status |
|---|---|---|---|---|---|---|
| Mar 2 2026 | MRI | Entity C | Due to affiliates | Management fee | $200 | No match found |
| Mar 4 2026 | QuickBooks | Entity A | Due to affiliates | Reimbursed expense | $200 | No match found |
| Apr 1 2026 | Yardi | Entity B | Due from affiliates | Shared service fees | $200 | Corresponding entry found |
| Mar 10 2026 | Sage | Entity D | Due to affiliates | Consulting services | $200 | No match found |
| Mar 15 2026 | Other GL | Entity C | Due from affiliates | System support | $200 | No match found |
Elimination schedule — printable
Prints to a clean, audit-ready schedule
States
Include
Exclude
Show only
| Entity pair | Relationship | Amount | State | Notes |
|---|---|---|---|---|
| Entity A ↔ Entity B | Due to/Due from affiliates | $200 | Include | Report-time elimination |
| Entity C ↔ Entity D | Intercompany receivable | $0 | Show only | Reconciled |
Source search + schedule
Global transaction search
Search by amount and source detail across connected ledgers, then produce a printable elimination schedule with include, exclude, or show-only states.
Find the matching entry
Search across all connected sources to locate the corresponding entry for the amount and relationship.
Resolve with confidence
Set include, exclude, or show-only states to define the treatment in your elimination schedule.
Produce auditable output
Print a clean schedule that shows entity pairs, amounts, states, and notes for audit-ready transparency.
Combining multiple QuickBooks files is only one way to use Helix.
Group scope + audit
Group scoped elimination
Elimination behavior can follow the reporting group.
A consolidated result stays traceable to source detail, mapping state, correction history, and reconciliation action.
Group scoped elimination
Read-only
- Overview
- Financials
- Intercompany
- Reconciliations
- Audit
- Data
Reporting group
Acquisition group
Compare
All entities
Period
Mar 2026
Intercompany activity
$248,350
Eliminated at report time
$248,150
Open difference
$200
| Reporting group | Entity pair | Account | Amount | Elimination state | Audit status |
|---|---|---|---|---|---|
| Acquisition group | Entity A ↔ Entity B | Due to/Due from affiliates | $200 | Included | Investigate |
| Parent group | Entity A ↔ Entity B | Due to/Due from affiliates | $200 | Show only | Review |
| All entities | Entity C ↔ Entity D | Due to/Due from affiliates | $0 | Excluded | Reconciled |
Audit trail and drilldown
Source detail
- Entity
- Entity A (USD)
- GL account
- 2000 Due to/Due from affiliates
- Amount
- $200
- Document
- JE-10234
- Date
- Apr 1, 2026
Mapping state
- Mapping rule
- IC-DF-AFFIL-USD
- Mapping status
- Mapped
- Counterparty
- Entity B
- Matched account
- Due to affiliates
Correction history
- Apr 2, 2026
- Analyst
- Adjustment
- $200
- Note
- Reclassified to IC elimination
Reconciliation action
- Action
- Report-time elimination
- Rule
- ELIM-IC-STD
- Applied
- Apr 2, 2026
- Result
- Included in consolidation
Eliminated at report time within the reporting group; no GAAP entry is posted to any source ledger.
Fit + product boundaries
Boundaries
Helix is read-only, one-way, GL-based reporting. It does not replace bookkeeping, an ERP, fund administration, or source-ledger writeback.
Pricing starts at $1,000 and is scoped to entity count, source systems, report set, and configuration.
Helix boundaries
Does
- Read-only import
- Full GL reporting
- Intercompany schedules
- Audit trail
Does not
- Bookkeeping
- ERP replacement
- Fund administration
- Source writeback
Fit questions
- Helix works across heterogeneous accounting sources. Combining multiple QuickBooks files is only one way to use Helix.
- No. Helix imports full general ledger data read-only and does not write back.
- The governed reporting definitions can continue while source systems change.
- Helix starts with a 15-minute qualification call before scheduling a 30–60 minute product demo.
Request a 15-minute fit call.
A 15-minute screening call confirms whether Helix fits your entities, systems, and reports before a longer product demo.