Skip to main content

Purchase Orders in More Than One Currency

Bookkeep's Inventory does not convert currencies as of yet. Costs enter the ledger as typed, and Shopify reads cost per item in the shop's currency, so every purchase order, receipt, fee, and opening cost is in the shop's currency. Conversion happens before the number is typed, at a rate you choose.

Suppliers who invoice in another currency​

A new purchase order opens in the shop's currency and switches to the supplier's Currency if one is set. There is no picker on the order. Set every supplier's Currency to the shop's currency (base in the supplier CSV).

Convert the invoice before you build the order. Factory unit cost times the rate is what you type on each line. Use the rate on the day you order.

Freight and duty in the foreign currency. Convert them too and enter them as landed cost fees; fees take the order's currency.

The rate moves before the goods land. Edit the line before receiving, or correct the cost after.

Seeding opening costs held in another currency​

A seed is one number per variant, cost only, held until the variant's first Bookkeep receipt. If some costs were kept in another currency:

  1. Export variant IDs and cost per item from Shopify.
  2. Convert the variants whose cost is really in the other currency, at one rate as of the seed date. Leave the rest alone.
  3. Load the file. A variant can be seeded once, so make it final first.

Shopify keeps the old figure until the first receipt. The seed does not rewrite Shopify's cost per item, which Bookkeep writes only on receipt. Until then Shopify uses the unconverted cost for COGS, so correct those variants in Shopify too, with the bulk editor or a product CSV.

Two shops in two currencies​

Each Shopify shop is its own Bookkeep connection, with its own suppliers, cost ledger, and cost per item. A factory that supplies a Canadian shop and a US shop needs a supplier record in each, and its invoice converted once per shop.