Test foreign-currency settlement in NetSuite by separating the invoice or bill currency, the subsidiary's base currency and the bank account currency. Then trace the applied payment and realized exchange difference. A customer can settle the exact foreign-currency amount while the base-currency value differs from the original transaction.
This review focuses on settlement. Period-end revaluation of open balances and translation for consolidated reporting are related processes with different purposes. Keep them distinct when investigating a payment discrepancy.
For each test, record the subsidiary, accounting book, transaction currency, base currency and bank currency. Write the exchange-rate direction explicitly, such as USD per EUR. A rate without its units can be accidentally inverted.
Preserve the rate and date on the source transaction and the payment. Distinguish an accounting exchange rate from the amount actually converted by a bank or payment provider. Fees and conversion spreads may create additional differences that need their own evidence.
Use the actual supported transaction route. Customer payments, vendor payments, deposits, credits and cross-currency banking flows can have different restrictions. A test that works for one route should not be generalized to every settlement arrangement.
NetSuite automatically calculates and posts exchange gains or losses when a payment is applied to a source transaction under the relevant foreign-currency process. The original and settlement base-currency values can therefore differ even when the foreign-currency balance is fully paid.
The Realized Exchange Rate Gains and Losses report connects source transactions, payments and realized differences in base currency, with drilldown to transaction and ledger details. Use the correct subsidiary and accounting-book context when applicable.
The report displays exchange rates rounded to two decimal places. For a precise recomputation, inspect the underlying transaction rate rather than relying only on the rounded display. Small apparent discrepancies can originate in that presentation difference.
For a receivable, receiving a higher base-currency value than the original carrying amount generally produces a gain in the simplified scenario. For a payable, paying a higher base-currency value generally produces a loss. Confirm the actual ledger signs and accounts in the configured process.
Do not copy a customer example into a vendor test without changing the direction. Review discounts, credits and partial applications separately. A payment amount can include more than one source transaction, each with its own original rate.
Record the approved expected result before execution. Include the foreign-currency balance remaining, base-currency cash or clearing effect and realized difference. The acceptance test should establish all three, not merely that the invoice status says paid.
Assume a fictional USD-base subsidiary invoices a customer for EUR 10,000 at USD 1.10 per EUR. The initial receivable is USD 11,000. This simplified example assumes no intervening revaluation, tax, credits or rounding complications.
The customer first pays EUR 4,000 at USD 1.12 per EUR. The payment's base-currency value is USD 4,480. The original value of that portion was USD 4,400, so the illustrative realized gain is USD 80. EUR 6,000 remains unpaid.
The customer later pays the remaining EUR 6,000 at USD 1.08 per EUR. That payment is worth USD 6,480 against an original value of USD 6,600, producing an illustrative realized loss of USD 120. The full EUR 10,000 is settled, and the net exchange result across both payments is a USD 40 loss.
Total base-currency receipts are USD 10,960, which is USD 40 below the original USD 11,000 receivable. The arithmetic explains why zero foreign-currency receivables do not imply zero exchange impact.
For a fictional EUR 10,000 payable initially recorded at the same USD 1.10 rate, use the same two payment amounts and rates. Paying the first portion at USD 1.12 costs USD 80 more than its original value, giving an illustrative loss. Paying the second portion at USD 1.08 costs USD 120 less, giving an illustrative gain.
The net result is a USD 40 gain for the payable scenario, opposite to the customer example. Preserve the distinction in the test pack so the team verifies signs rather than only absolute differences.
These are hypothetical accounting illustrations with explicit simplifying assumptions. The accounting owner must approve expected treatment where prior revaluations, multiple books or other transaction features affect the result.
Suppose the first illustrative customer receipt has a gross converted value of USD 4,480 and the provider deducts a USD 20 fee. The bank receives USD 4,460. The fee is a separate component from the USD 80 exchange gain in the simplified example.
Reconcile gross settlement, fees, other adjustments and net bank deposit. Do not force the customer payment exchange rate to absorb every difference merely to match the deposit. That can hide fees and distort the currency analysis.
Where the bank account is itself foreign-currency denominated, review its valuation and subsequent revaluation separately. Where the customer pays in a different currency from the invoice, demonstrate the supported clearing and application process with the accountant before adopting a workaround.
Include a payment applied to several invoices at different rates, a partial credit, an unapplied payment and a payment dated in a different accounting period. Test a reversed application and the approved correction route.
Add a case with a prior period-end revaluation if that occurs in normal operations. Preserve the original, revaluation and settlement entries so the reviewer can explain the cumulative result without counting the same exchange movement twice.
Check permissions and role-specific visibility. The person reconciling settlement needs the appropriate source, payment and ledger evidence. A summarized bank report alone may not reveal which invoice application generated the exchange difference.
Reconcile each source transaction in its transaction currency, then explain the base-currency effects. Tie realized differences to the relevant ledger population and keep bank settlement components separately identified.
Preserve report filters, exact rates, payment applications and the expected-versus-actual result for each scenario. A CuriousRubik NetSuite support review can begin with one unexplained settlement and follow its currencies and applications through to the ledger.
The foreign-currency amount can be fully settled while its base-currency value changes between invoice and payment. The realized difference explains that change under the applicable settlement process.
Check rate direction, underlying precision, applied amount, accounting book and prior revaluation effects. The standard realized report displays rates rounded to two decimal places, so inspect transaction details for precise calculations.
Treat it as a separate identified settlement component under the approved accounting policy. Reconcile gross conversion value, fees and the net deposit rather than hiding every difference in a changed exchange rate.
Yes, in the simplified examples. A stronger settlement currency increases the base-currency value received on a receivable but also increases the cost of paying a payable. Verify the actual ledger signs in testing.
No. Open-balance revaluation and consolidated translation have separate purposes. Reconcile them with settlement where relevant, while preserving their distinct dates, populations and accounting effects.