Intercompany Sales Elimination Entry Builder

Illustrative separate consolidation elimination amounts for fully consolidated intercompany sales and caller established ending-inventory unrealized profit; tax/NCI/upstream allocations omitted.

Description

Intercompany Sales Elimination Entry Builder: return debit sales, credit cost of sales, debit cost of sales for unrealized, credit inventory.

Consolidation can require eliminating sales within a group and profit remaining in inventory. The two adjustments affect different account balances.

This tool returns debit sales, credit cost of sales, debit cost of sales for unrealized, credit inventory. Use the stated units and model convention when interpreting these fields.

When to use this tool

Use this tool when the supplied inputs match the specific operation described above and you need a repeatable result under its stated convention.

  • Check the supported input and output contract against an existing calculation or observation.
  • Use the complete example to confirm units, selector spelling and result interpretation.

How to use the tool and how it works

  1. Enter every field in the input table using the stated units and the exact supported selector spelling where applicable.
  2. Run the tool. Correct input errors before interpreting an output.
  3. Read the result fields below; use accompanying flags and the stated sign, boundary or model convention when interpreting a number.

Return an equal sales debit and cost-of-sales credit for intercompanySales, plus a cost-of-sales debit and inventory credit for unrealizedInventoryProfit.1

Input fieldMeaning and unitsAccepted input
intercompanySalesIntercompany sales.Finite number; zero or greater
unrealizedInventoryProfitUnrealized inventory profit.Finite number; from 0 to intercompanySales inclusive
Output fieldInterpretation
resultObject containing the following named result fields.
result.debitSalesDebit sales; use the stated units and sign convention.
result.creditCostOfSalesCredit cost of sales; use the stated units and sign convention.
result.debitCostOfSalesForUnrealizedDebit cost of sales for unrealized; use the stated units and sign convention.
result.creditInventoryCredit inventory; use the stated units and sign convention.
json
{
  "input": {
    "intercompanySales": 100,
    "unrealizedInventoryProfit": 20
  },
  "output": {
    "result": {
      "debitSales": 100,
      "creditCostOfSales": 100,
      "debitCostOfSalesForUnrealized": 20,
      "creditInventory": 20
    }
  }
}

Limitations and assumptions

  • The entered unrealized profit must lie between zero and sales. Tax, ownership and framework-specific consolidation adjustments are not calculated.
  • Every declared field is required and unexpected fields are rejected. Numeric inputs must be finite; input errors are distinct from a valid false result or an explicitly qualified output.
  • Extremely large inputs and nonfinite or excessively large outputs are rejected. List positions reported by the tool use zero-based indices unless stated otherwise.

Alternative or Complementary methods

Check the underlying observations, units and conventions independently before using the result in a larger workflow. The tools listed below address nearby tasks; compare their inputs and scope before substituting one for this operation.

References

  1. Tool behavior and example: Intercompany Sales Elimination Entry Builder — tool.io

Similar or alternative tools

Don't forget to set a bookmark for tool.io!
Privacy | Imprint | Cookies