Preserve both the invoice currency and a dated home-currency view when forecasting foreign-currency receivables. Do not replace the source transaction rate with a current rate without labeling the change. The operational question is expected receipt timing; the exchange-rate question is how that expected amount is presented and reconciled.

Intuit's Multicurrency guidance explains that QuickBooks converts foreign transactions into home currency and assigns a currency to customers and accounts. Intuit's exchange-rate guide describes the transaction's foreign amount and home-currency amount as separate values derived through an exchange rate.

Lock four source fields

For every foreign-currency invoice, retain:

  • original invoice amount and currency;
  • open amount in that currency;
  • transaction or report exchange rate and its date;
  • home-currency amount shown by the dated source report.

Also preserve invoice date, contractual due date, report cutoff, customer, and payment evidence. If the export omits currency or rate, mark the home-currency presentation as incomplete rather than assuming all rows are in the same currency.

Separate timing from valuation

First decide whether the invoice has enough evidence for a collection week. Use the foreign-currency open amount for the customer obligation. Then choose a documented presentation rule for the management forecast.

A team might preserve the source-report home value for reconciliation and show a separately labeled current-rate scenario for planning. That scenario is not a new accounting entry and should not overwrite the source row. Record the rate provider or system, rate date, preparer, and calculation.

The due-date-versus-expected-date guide keeps contractual and forecast dates separate. The AR forecast template provides weekly timing fields. The cash-receipt cutoff checklist prevents later receipts or rate changes from silently rewriting the starting snapshot.

Use a reconciliation bridge

Build a compact bridge from foreign open amount to source home value, then to any planning-rate view. Show the exchange-rate difference separately from payment, credit, dispute, or write-off changes. Do not describe an unrealized translation movement as cash collected or lost.

Flag invoices when the customer currency is missing, rate dates are inconsistent, the source home value cannot be reproduced, or a payment currency differs from the invoice currency. Route accounting adjustments to the company's accountant; the collections forecast should preserve evidence rather than prescribe entries.

Decision rule

Keep one source truth and one clearly labeled planning view. Assign expected timing only from collection evidence, and identify any currency translation separately. AR Pulse analyzes an authorized QuickBooks receivables export without changing the books. Finance owners can view the example report after currency and rate fields are made traceable.