SI Data Ops

One task · From £395 · untested offer price

Make foreign-currency orders create invoices in the right currency, with the right rate

Synthetic orders in the base currency, a two-decimal currency and a zero-decimal currency create invoices with the order currency and amount, and no default or inverted rate is stored.

Request this outcome

Who this is for

A finance manager, bookkeeper or developer whose shop or billing system sells in several currencies and whose synced invoices come out in the wrong currency, with a rate of one, or with a base total that does not match what the payment processor settled.

Invoices for foreign-currency orders show the home currency, an amount a hundred times too big or small, or a base-currency total that disagrees with the settled amount.

The result

For synthetic orders in the base currency, a two-decimal foreign currency and a zero-decimal foreign currency, each invoice carries the order's currency and exact amount, any stored rate is in the target's direction, no default rate of one appears, and an order in a currency not enabled in the file is held.

What is included

  • One sync, one order source and one Xero organisation or QuickBooks Online company
  • An amount contract per source field: minor or major units, decimal places and the currency code carried with each amount
  • A rate rule: omit the rate where no real conversion happened, or set it in the direction the target expects when one did, with the source of the rate named
  • A check that the target file has each currency enabled, with a held list for orders that fail it
  • Tests with invented orders in three currencies on a demo or sandbox file

You receive

  • The change as a pull request or exported configuration with the amount and rate contract written down
  • A test table: each invented order, the invoice currency, foreign amount, stored rate and base total
  • A held list for currencies not enabled and orders with a missing rate where one is required

What is not included

  • Choosing exchange-rate sources or revaluation, or deciding how gains and losses are accounted for
  • Enabling multicurrency in your live accounting system, which your account holder decides and which in QuickBooks Online cannot be turned off once enabled
  • Payments received in a different currency from the invoice
  • More than three currencies in the fixed scope, or historic invoices
  • Bookkeeping, tax, audit or any accounting advice, including deciding how a transaction should be treated in your accounts
  • Changing posted, reconciled or locked-period transactions: your accountant or account holder decides and performs those
  • Live changes: your authorised account holder applies any agreed change and holds the production keys

What we need from you first

  • The currencies you sell in and which is the home currency of the accounting file
  • Three invented orders: one in home currency, one in a two-decimal currency, one in a zero-decimal currency, with amounts
  • Whether the source sends amounts in the smallest currency unit
  • Do not send credentials, bank details, invoices, customer records or confidential code in the first enquiry

Never send passwords, keys, customer records or confidential code in the first enquiry. Secure handover is agreed after scoping.

How we check it is done

  • Three invented orders (home currency, two-decimal currency, zero-decimal currency) each create an invoice whose currency code and foreign amount equal the order's exactly.
  • For the foreign orders the stored rate, when one is set, converts the foreign total to the expected base total within the agreed rounding, and the direction matches the target's documented convention.
  • No foreign invoice carries a rate of one unless the agreed rule names that exact rate.
  • An order in a currency not enabled in the file is held with the currency named and creates no invoice.

You inspect the named test evidence and sign off before payment. Your authorised account holder performs and verifies any live change, and decides what happens to records already posted.

When we would stop or decline

  • The target file does not have multicurrency enabled and your accountant will not enable it
  • Orders are converted by a third system whose rate cannot be read, so the base amount cannot be explained
  • More than three currencies or per-line currencies are needed, which needs a wider quote

Questions

Can you pick the right exchange rate for me?

No. Which rate to use is an accounting decision. The job applies the rule you give it, or omits the rate where no real conversion happened.

Why does the rate direction matter?

The two systems express rates in opposite directions, so copying a value from one to the other can invert it. The test recomputes the base total to catch that.

Does this cover currency gains and losses?

No. Revaluation and gain or loss treatment belong to your accountant.

Price and terms

From £395 · untested offer price. Fixed after the quote is agreed (from £395); payment after the agreed checks pass and you sign off. No payment before sign-off.

This is a new service with no published client results. The price is a starting point we have not yet tested with buyers. Nothing is ordered or charged by the enquiry. The full specification is on the Synthetic Industry catalogue.

Request this outcome

Enquiry about: Make foreign-currency orders create invoices in the right currency, with the right rate. Page: /services/invoice-foreign-currency-rate-and-amount-errors/.

A public HTTPS link only, without login details, query strings or fragments. No code or logs.

Sending emails your enquiry and contact address to our team through our mail provider (Resend). It is not kept in a website database. Do not send passwords, keys, recovery links, confidential code or customer records. Your contact email is unverified; nothing is ordered, charged or reserved. Privacy notice.

An enquiry is not an order. We assess fit and agree scope, safe access and terms before any work. Prefer email? hello@syntheticindustry.ai.