Description
Return order value after item returns and shipping refunds.
Business accounting and analytics distinguish gross, net, allocated, recognized and forecast amounts. Currency, period, eligibility and interaction-allocation conventions determine a reported contribution; reconciling one term does not verify revenue, payment rights or future commercial outcomes.
Return order value after item returns and shipping refunds.
When to use this tool
Use Order Basket Return Net Value when reconciling the stated business amount, share, bridge or forecast convention.
How to use the tool and how it works
- Enter itemValues, returnValues, shippingRevenue, refundShipping. Follow any array-alignment requirements below. Use the units and conventions below.
- Run the tool. Correct any format, range, or cross-field input error before interpreting the output.
- Read grossItems, returnedItems, netOrderValue. Use the output convention below.
Return order value after item returns and shipping refunds. Require nonnegative item/return values and shipping/refund amounts; grossItems and returnedItems sum independently, netOrderValue = gross-returns+shipping-refund.1
| Input field | Meaning and units | Accepted input |
|---|---|---|
| itemValues | Item Values | Required. Array of finite number; maximum items 256. |
| returnValues | Return Values | Required. Array of finite number; maximum items 256. |
| shippingRevenue | Shipping Revenue | Required. Finite number; minimum 0. |
| refundShipping | Refund Shipping | Required. Finite number; minimum 0. |
| Output field | Interpretation | Returned shape |
|---|---|---|
| grossItems | Gross Items | Required. Finite number. |
| returnedItems | Returned Items | Required. Finite number. |
| netOrderValue | Net Order Value | Required. Finite number. |
{
"input": {
"itemValues": [
20,
30
],
"returnValues": [
10
],
"shippingRevenue": 5,
"refundShipping": 0
},
"output": {
"grossItems": 50,
"returnedItems": 10,
"netOrderValue": 45
}
}Limitations and assumptions
- Return arrays need not align and net value may be negative; actual order matching, taxes and accounting treatment are not verified.
- Inputs must satisfy both the field types and the cross-field conditions above. Invalid input causes an error; a successful false flag or documented placeholder is a different result.
- Numeric calculations use binary floating point unless exact decimal-integer arithmetic is explicitly stated. No hidden measurement tolerance or decimal rounding is added; nonfinite or out-of-contract results are rejected. Numeric signed-zero results are exported as zero.
Alternative or Complementary methods
Use complete verified accounts and governing commercial terms, and apply the appropriate accounting and financial judgment for actual reporting, payment or investment decisions.
References
Similar or alternative tools
- Basket Return Net Value Cross Term
Return order net value with interacting return/discount shares.
- Net Sales Return Weight
Return weighted gross sales, returns and net sales.