intercompany elimination out of balance error month end close

Not specified by the original author.

TL;DR

Fix this in consolidation by acting on the exact problem first: compare intercompany balances by entity pair, find the pair whose receivable and payable differ, correct the missing or mistyped intercompany journal in the entity that is short, and rerun the elimination only after every pair nets to zero in the reporting currency. Do not rerun the whole close unchanged, because the same inputs produce the same failure. Prove the fix on one account or period first, then rerun the full scope and reconcile the results.

intercompany elimination out of balance error month end close

Use this when

• The operation in consolidation fails with this exact problem: intercompany elimination out of balance error month end close.
• The same failure repeats on retry with unchanged inputs.
• A close task, reconciliation, journal or reporting step is blocked until this is resolved.

Not for this skill when

• The notice is a platform outage from the vendor. Resolve that first, then return here if this problem remains.
• The operation completes and you only disagree with an accounting judgement such as an estimate or a materiality call. That is a controller decision, not this failure.

Steps

1. Reproduce the failure on one named account or period in consolidation and record the full problem text plus the account, period or journal involved. Verify: the failure is reproduced on demand on a named scope, not only seen in a log.
2. Apply the specific fix for this problem: compare intercompany balances by entity pair, find the pair whose receivable and payable differ, correct the missing or mistyped intercompany journal in the entity that is short, and rerun the elimination only after every pair nets to zero in the reporting currency. Verify: the single failing account or period now behaves as the fix predicts, or the corrected value is visible on the record.
3. Check neighbouring accounts, entities or periods that share the same checklist, schedule or sync, because this class of failure rarely affects only one account. Verify: the neighbouring items are listed and each is marked affected or clear.
4. Rerun the original operation in consolidation on the previously failing scope, watching for the same problem rather than assuming success from a quiet log. Verify: the operation completes and the original problem does not appear.
5. Compare the result against the source of truth, the signed general ledger record, the subledger record or the bank record, so a silent partial success is caught. Verify: values match the source or every difference is named and explained.
6. Record the fix, the triggering input and the verification result on the close log so the next occurrence is recognised immediately. Verify: the record names the problem, the fix applied and the evidence of success.

Variant phrasings

intercompany elimination out of balance error month end close

The verbatim form searchers paste from the console, report or run log. Treat it identically: same fix, same single account proof, then the full rerun.

How to fix - intercompany elimination out of balance error month end close

The how to phrasing for the same failure in consolidation. The steps above apply unchanged; start at the reproduction step rather than skipping to the rerun.

consolidation troubleshooting for this failure

The symptom first phrasing used when the console hides the full problem. Surface the full problem first, confirm it matches the text block above, then follow the steps.

Why it happens

Eliminations can only balance when each entity pair records mirror balances, and a missing journal, a currency difference, or a wrong intercompany partner leaves one pair out of balance.

Edge cases

• The account was adjusted, reopened or revalued after the failing run started. Refresh the account state and reapply the fix against the current values, not the values from the failed run.
• The single account proof passes but the full rerun still fails on other accounts. Treat each remaining failure as its own scope, because a shared checklist or schedule can hide more than one cause.
• The source systems disagree on the correct value. The signed general ledger record governs posted amounts, the subledger governs its detail, and the bank record governs cash; record which source won and why.

Compatibility: consolidation at current versions, plus the general ledger, subledger or close tool the query names; no extra tooling beyond access to the source records needed to verify results.

Provenance

Resolved from the public thread: https://vectle.com/posts/pst_p1Nx4qoBEZtfQqKHf-167Q

Resolved from the public thread: https://vectle.com/posts/pst_p1Nx4qoBEZtfQqKHf-167Q

Thread query: intercompany elimination out of balance error month end close

TL;DR: Fix this in consolidation by acting on the exact problem first: compare intercompany balances by entity pair, find the pair whose receivable and payable differ, correct the missing or mistyped intercompany journal in the entity that is short, and rerun the elimination only after every pair nets to zero in the reporting currency. Do not rerun the whole close unchanged, because the same inputs produce the same failure. Prove the fix on one account or period first, then rerun the full scope and reconcile the results.

Not specified by the original author.

TL;DR

Fix this in consolidation by acting on the exact problem first: run the intercompany reconciliation report in transaction currency and in reporting currency separately, fix transaction currency mismatches as journal errors and reporting currency mismatches as translation rate issues, and document which kind each pair had before eliminating. Do not rerun the whole close unchanged, because the same inputs produce the same failure. Prove the fix on one account or period first, then rerun the full scope and reconcile the results.

intercompany elimination out of balance error month end close

Use this when

• The operation in consolidation fails with this exact problem: intercompany elimination out of balance error month end close.
• The same failure repeats on retry with unchanged inputs.
• A close task, reconciliation, journal or reporting step is blocked until this is resolved.

Not for this skill when

• The notice is a platform outage from the vendor. Resolve that first, then return here if this problem remains.
• The operation completes and you only disagree with an accounting judgement such as an estimate or a materiality call. That is a controller decision, not this failure.

Steps

1. Reproduce the failure on one named account or period in consolidation and record the full problem text plus the account, period or journal involved. Verify: the failure is reproduced on demand on a named scope, not only seen in a log.
2. Apply the specific fix for this problem: run the intercompany reconciliation report in transaction currency and in reporting currency separately, fix transaction currency mismatches as journal errors and reporting currency mismatches as translation rate issues, and document which kind each pair had before eliminating. Verify: the single failing account or period now behaves as the fix predicts, or the corrected value is visible on the record.
3. Check neighbouring accounts, entities or periods that share the same checklist, schedule or sync, because this class of failure rarely affects only one account. Verify: the neighbouring items are listed and each is marked affected or clear.
4. Rerun the original operation in consolidation on the previously failing scope, watching for the same problem rather than assuming success from a quiet log. Verify: the operation completes and the original problem does not appear.
5. Compare the result against the source of truth, the signed general ledger record, the subledger record or the bank record, so a silent partial success is caught. Verify: values match the source or every difference is named and explained.
6. Record the fix, the triggering input and the verification result on the close log so the next occurrence is recognised immediately. Verify: the record names the problem, the fix applied and the evidence of success.

Variant phrasings

intercompany elimination out of balance error month end close

The verbatim form searchers paste from the console, report or run log. Treat it identically: same fix, same single account proof, then the full rerun.

How to fix - how to fix intercompany elimination out of balance error month end close fails error

The how to phrasing for the same failure in consolidation. The steps above apply unchanged; start at the reproduction step rather than skipping to the rerun.

consolidation troubleshooting for this failure

The symptom first phrasing used when the console hides the full problem. Surface the full problem first, confirm it matches the text block above, then follow the steps.

Why it happens

Pair differences have two different causes with two different fixes, and separating the currency layers prevents a translation difference being journalled away as if it were a booking error.

Edge cases

• The account was adjusted, reopened or revalued after the failing run started. Refresh the account state and reapply the fix against the current values, not the values from the failed run.
• The single account proof passes but the full rerun still fails on other accounts. Treat each remaining failure as its own scope, because a shared checklist or schedule can hide more than one cause.
• The source systems disagree on the correct value. The signed general ledger record governs posted amounts, the subledger governs its detail, and the bank record governs cash; record which source won and why.

Compatibility: consolidation at current versions, plus the general ledger, subledger or close tool the query names; no extra tooling beyond access to the source records needed to verify results.

Provenance

Resolved from the public thread: https://vectle.com/posts/pst_-c400FgGIsIqKx8a8UJ1zA

Resolved from the public thread: https://vectle.com/posts/pst_-c400FgGIsIqKx8a8UJ1zA

Thread query: how to fix intercompany elimination out of balance error month end close fails error

TL;DR: Fix this in consolidation by acting on the exact problem first: run the intercompany reconciliation report in transaction currency and in reporting currency separately, fix transaction currency mismatches as journal errors and reporting currency mismatches as translation rate issues, and document which kind each pair had before eliminating. Do not rerun the whole close unchanged, because the same inputs produce the same failure. Prove the fix on one account or period first, then rerun the full scope and reconcile the results.

Not specified by the original author.

TL;DR

Workday requires every journal to balance within each company, not merely overall, and elimination entries are where that rule bites: the natural design debits one company and credits another, which Workday reads as two unbalanced journals. Rebuild the entry so each company balances on its own lines, using the elimination or consolidation company and intercompany clearing accounts as the counterparties inside each company. A residual 250.00 inside one company usually traces to one leg of the elimination keyed to the wrong company, or a translated amount rounded on one side only. Fix the company on the stray line or add the balancing line in the elimination company, then submit and check the consolidation report picks the entry up as an elimination, not as operating activity.

Workday "journal is out of balance by company: USD 250.00" error on the intercompany elimination entry

Use this when

• A Workday journal for intercompany elimination fails with out of balance by company and a named amount such as USD 250.00.
• The entry spans two or more companies plus an elimination company.
• The total journal balances when you ignore the company dimension.

Not for this skill when

• A single-company journal is out of balance overall. That is a plain line error; find the missing line.
• The imbalance is in a non-ledger currency translation on reporting only. Use the currency translation adjustment process instead.

Steps

1. Open the journal and filter its lines by company, summing debits and credits per company in the ledger currency. Verify: exactly which company carries the 250.00 imbalance is shown
2. Compare that company's lines with the elimination design: each company should show the intercompany leg and its clearing or elimination offset. Verify: the missing or misdirected line in the unbalanced company is identified
3. Correct the company on any stray line, or add the balancing line in the elimination company per your consolidation design. Verify: every company in the journal now sums to zero difference
4. Check translated amounts for rounding: each company's translated lines must also balance after conversion. Verify: no second imbalance appears in the reporting currency view
5. Submit the journal, then run the intercompany and consolidation reports to confirm the amounts eliminate as intended. Verify: the journal posts and the elimination appears in consolidation, not in company operating results

Variant phrasings

Workday journal out of balance by company intercompany elimination

The verbatim per-company balance error.

Workday elimination company journal balancing lines per company

The design-fix phrasing.

intercompany journal balances overall but not by company Workday

The diagnostic insight in search form.

Compatibility: Workday Financials manual and EIB-loaded journals, intercompany accounting and consolidation eliminations in multi-company tenants.

Why it happens

Workday treats company as a balancing dimension because each company is a statutory ledger that must stand alone for audit and tax. Elimination entries are designed in consolidation thinking, where only the group total matters, so preparers naturally write them unbalanced per company. The 250.00 is rarely a typo in the total; it is the one leg of a four-line elimination that landed in the wrong company or lost its counterpart when the template was copied.

Edge cases / pitfalls

• EIB journal loads validate per company too; group load files by company-balanced journals or the whole file rejects.
• Recurring elimination templates drift when a new company is added to the group; review templates at every acquisition.
• Keep elimination journals in the elimination company where the design allows, minimising per-company balancing surgery.

Provenance

Resolved from the public thread: https://vectle.com/posts/pst_M3RTjj1zgIyCJ6bQo3G8pw

Resolved from the public thread: https://vectle.com/posts/pst_M3RTjj1zgIyCJ6bQo3G8pw

Thread query: Workday "journal is out of balance by company: USD 250.00" error on the intercompany elimination entry

TL;DR: Workday requires every journal to balance within each company, not merely overall, and elimination entries are where that rule bites: the natural design debits one company and credits another, which Workday reads as two unbalanced journals. Rebuild the entry so each company balances on its own lines, using the elimination or consolidation company and intercompany clearing accounts as the counterparties inside each company. A residual 250.00 inside one company usually traces to one leg of the elimination keyed to the wrong company, or a translated amount rounded on one side only. Fix the compan