Multi-Currency Exchange-Rate Adjustment Review and the Realized-Unrealized Boundary: October 2 Control Review

October 2, 2026

Research question and thesis

What evidence should a QuickBooks Online reviewer inspect before approving multi-currency exchange-rate adjustments and the boundary between realized and unrealized gains or losses on October 2, 2026? A foreign-currency invoice can have a transaction-date value, a period-end home-currency value while still open, and a settlement-date result when paid. If those events are compressed into one adjustment, the reviewer cannot tell whether the change reflects an open monetary balance, a completed settlement, a source-rate choice, or a correction.

The thesis is that foreign-exchange review should use an event ledger. The ledger preserves the foreign-currency amount while recording the rate source and home-currency measurement at each relevant event. Unrealized and realized labels follow the status of the underlying item and the authorized accounting policy; they should not be inferred from whichever QuickBooks report row contains the amount.

This is an evidence design, not a determination of functional currency, applicable accounting framework, tax treatment, or hedging. Those judgments require the accountant and, where needed, other professionals.

Method and source boundary

This review synthesizes authoritative public guidance checked October 2, 2026. FASB Accounting Standards Codification Topic 830 addresses foreign-currency matters; FASB’s Codification is the authoritative source of nongovernmental U.S. GAAP. IRS yearly average exchange-rate guidance explains that the Service has no single official exchange rate and generally accepts consistently used posted rates for relevant conversions, while particular transactions may require the rate applicable on the transaction date. The Federal Reserve publishes H.10 foreign exchange rates and describes the release. Intuit documents QuickBooks Online multicurrency, user-entered rates, and home-currency adjustments, including product behavior around realized and unrealized gains and losses.

No client currency policy, QBO file, invoice, bank account, rate table, or live adjustment was reviewed. Examples are hypothetical and omit complexities such as hedges, nonmonetary assets, translation of foreign operations, and tax reporting. The method assesses traceability, not compliance.

Facts, analysis, and inference

Fact: Intuit allows supported QuickBooks Online editions with multicurrency to use supplied rates or user-entered exchange rates. Its home-currency adjustment guidance describes revaluing foreign-currency balances and distinguishes product treatment for open receivables or payables from certain foreign bank accounts.

Analysis: The reviewer needs to know whether a rate was system-supplied or manually entered, its effective date, quote direction, and source. A rate displayed in QBO is not self-documenting when policy requires a specific source or convention.

Fact: The Federal Reserve’s H.10 release provides foreign exchange rate information, while IRS guidance says no single official exchange rate exists for all federal tax purposes and stresses consistent use of an accepted rate appropriate to the transaction.

Analysis: “Official rate” is too vague for a workpaper. The policy should name the source, date convention, treatment of weekends or holidays, quote convention, and whether spot, average, or another approved rate applies to a given event.

Fact: Foreign-currency accounting distinguishes measurement changes on items that remain open from exchange effects crystallized through settlement, subject to the applicable accounting framework and facts.

Analysis: The open or settled status must be proved using invoice, payment, credit, and bank evidence. A period-end remeasurement should not be carried forward as though it were a new foreign-currency principal amount.

Inference: An unusual gain or loss may result from market movement, a reversed quote, wrong date, partial settlement, duplicated home-currency adjustment, or incorrect open-item status. Magnitude alone cannot identify the cause.

Build the foreign-currency event ledger

Each ledger row begins with a stable source-item identifier and records entity, counterparty, transaction type, foreign currency, foreign amount, home currency, transaction date, initial rate, quote direction, initial home amount, and QBO identifier. Subsequent event rows refer back to that source item rather than overwriting it.

Relevant events include invoice or bill recognition, credit memo, partial payment, full settlement, refund, period-end remeasurement, reversal of a prior remeasurement where policy requires it, and correction. For each event, record event date, foreign amount affected, rate, rate source, home-currency value, item status after the event, proposed realized effect, proposed unrealized effect, QBO entry, and approval.

The ledger should always retain foreign units. Home-currency totals alone can appear to reconcile even when the wrong foreign amount or quote direction was used. It should also identify whether rates are quoted as home currency per foreign unit or the inverse. A simple reasonableness check converts one unit in both directions and compares with the source convention.

Hypothetical invoice example

Assume a EUR 10,000 customer invoice is initially measured at USD 1.10 per EUR, producing a USD 11,000 home amount. At period-end it remains wholly open and the approved closing rate is USD 1.08, producing a USD 10,800 remeasured amount. The USD 200 change is a proposed unrealized effect under the assumed policy; the packet preserves the invoice, open-item proof, both rates, and calculation.

The customer later pays the full EUR 10,000 when the approved settlement-date rate is USD 1.12, and bank evidence supports the received amount before bank fees. The settlement review distinguishes the movement from the original carrying amount and any prior period-end adjustment according to the accountant’s policy. The preparer should not simply label the entire difference from the invoice date “realized” without accounting for prior remeasurement entries.

For a partial payment of EUR 4,000, only the settled portion crosses the realization boundary. The EUR 6,000 remainder stays in the open-item population for closing-rate review. The event ledger makes that split explicit and prevents the invoice from being treated as entirely open or entirely settled.

Hypothetical foreign bank example

Assume a foreign bank account holds CAD 20,000. The statement proves the foreign-unit balance. A period-end home-currency adjustment changes its reported home value. Intuit’s product treatment may present effects for foreign bank accounts differently from open receivables and payables. The reviewer should reconcile the CAD units to the statement first, then review the approved rate and QBO presentation. Product labeling should be documented rather than generalized into an accounting rule for every asset.

Review packet and calculation controls

The packet begins with the approved currency policy: functional and home currency conclusions, rate sources, effective-date convention, fallback for nonpublication days, materiality, covered accounts, remeasurement frequency, reversal practice, and responsible approvers. If that policy does not exist, the VA flags the gap rather than inventing it.

Next comes an open-item inventory by currency that agrees in foreign units and home-currency carrying amount to the relevant QBO subledger and general ledger. Attach the dated rate-source evidence and a rate-control table. Then include event-ledger calculations, proposed adjustments, QBO-generated home-currency adjustment reports where used, and post-entry tie-outs.

Calculation controls should test rate direction, decimal placement, effective date, foreign units, partial settlements, credits, and prior adjustments. Recalculate home value independently for material currencies. Separate rounding within approved tolerance from unexplained differences. Preserve the pre-adjustment report because later QBO reports may reflect the posted adjustment and obscure the starting state.

Statuses should include policy missing; source rate missing; rate date exception; manual rate awaiting approval; open status confirmed; settlement evidence linked; partial settlement split; prior adjustment unresolved; proposed unrealized adjustment; proposed realized classification; product presentation question; posted and tied; or accountant decision required.

Decision boundaries

The VA may assemble open-item reports, preserve rate sources, recalculate conversions, trace payments, split partial settlements mechanically, draft the event ledger, and identify discrepancies. The VA may enter an already approved rate or prepare an adjustment for review when authorized. It should not choose functional currency, accounting framework, rate convention, hedge treatment, realization policy, materiality, or tax conversion method.

The accountant approves policy, scope, realized-versus-unrealized treatment, reversal approach, and entries. Treasury or the owner validates bank receipts, fees, conversions, and settlement dates. Tax advisers decide return translation. Management approves access to currency accounts and any manual-rate override.

Stop and escalate when the rate direction is uncertain, the source item cannot be found, foreign units do not reconcile, a settlement is recorded without bank evidence, prior adjustments appear duplicated, the currency was changed on an existing customer or vendor in an unsupported way, or a proposed entry mixes correction and current-period exchange movement.

Review tests and intended outcome

First prove the population. Compare foreign-currency accounts and open-item reports with the accounts included in the adjustment. Reconcile each foreign bank account in foreign units. Trace sampled receivables and payables to source documents and subsequent settlement evidence.

Second prove the rates. Match each rate to the approved source and date convention, verify quote direction, and independently recalculate selected home amounts. Review all manual overrides and all rates outside a reasonableness range established by the accountant using an independent source.

Third prove the event boundary. For every proposed realized amount, locate settlement or other qualifying evidence and account for prior remeasurements. For every proposed unrealized amount, verify that the relevant foreign amount remained open at the measurement date. Test partial settlements separately. Tie proposed adjustments to QBO entries and the resulting ledger.

Report amounts by currency, account, event type, and evidence state. Identify manual-rate overrides, open-status conflicts, missing settlement links, and prior-adjustment differences. Do not net realized and unrealized exceptions into one foreign-exchange total; netting can conceal opposite errors.

The intended outcome is a reviewer’s ability to reconstruct every material exchange effect from foreign units, dates, rates, and item status. A well-supported packet does not promise that exchange results will be small. It explains why they exist and where judgment entered.

Bounded pilot

Pilot one currency and one month-end using a single transaction class, such as foreign-currency customer invoices. Include the complete open-item population for that currency plus settlements occurring during the review window. The accountant approves the rate source, date convention, treatment of weekends, realization method, and QBO workflow before calculation.

The VA builds the event ledger and independently recalculates the proposed adjustment. A reviewer traces one fully open item, one settled item if present, and one partial settlement if the population contains one. Do not manufacture an edge case; document its absence. Tie foreign units to the subledger before reviewing home-currency effects.

Adopt the method only if a second preparer can reproduce rates and classifications from the packet and the accountant can distinguish current settlement effects from prior remeasurement. Expand by currency or transaction class, not all at once, because bank accounts, receivables, payables, and other balances may behave differently.

Limitations

Foreign-currency accounting is framework- and fact-dependent. This brief does not cover translation of foreign operations, hyperinflation, derivatives, hedge accounting, intercompany matters, nonmonetary items, or tax-specific currency rules. Rate sources differ in timing and purpose. Bank conversion rates and fees may differ from published reference rates. QuickBooks behavior, availability, and labels may change after October 2, 2026.

The design does not validate the economic substance of a transaction or guarantee GAAP compliance. No live data was tested, so there are no findings about accuracy, frequency, savings, or effectiveness. An accountant should approve policy and entries before use.

Conclusion

The realized-unrealized boundary becomes reviewable when foreign units, rate evidence, item status, prior remeasurement, and settlement are organized as events rather than collapsed into a net gain or loss. An event ledger lets a VA perform disciplined preparation while reserving currency policy and accounting conclusions for the authorized reviewer.

References

• FASB: Accounting Standards Codification
• FASB: Foreign Currency Matters, Topic 830 project resources
• Federal Reserve: H.10 Foreign Exchange Rates
• IRS: Yearly average currency exchange rates
• Intuit: Enter and use your own exchange rates in QuickBooks Online
• Intuit: Frequently asked questions about home currency adjustments