• Contents

Purchasing in a Foreign Currency

Last updated 22/01/2021

How to make purchases in a foreign currency.

Making a Purchase Order in a Foreign Currency

By default new Purchase Orders use your base currency. To create a Purchase in a Foreign Currency:

  1. From the left navigation select Purchases, then select New Purchase Order.
  2. Enter the Company or Supplier/Vendor name.
  3. If the Supplier/Vendor has been assigned a cost option that is not the base currency, the currency will change automatically.
  4. Enter the products to be purchased in the grid below, and notice that the total is in the foreign currency.
  5. Enter an Estimated Time of Arrival (ETA), Port, and ETD in the boxes provided and then select Approve.
It is strongly recommended to set up a supplier in the CRM module with the applicable cost tier prior to creating a foreign currency purchase order. 

Exchange Rates

Cin7 uses an approximate exchange rate to convert the Purchase Order to your base currency. This provides a working rate until you pay your bill.

Once you have finalized payment through your accounting software:

  1. You'll be required to select a payment type and enter the base currency value into the payment information section on the purchase order. 
    Please note: Modifying the base currency value will update the exchange rate.

  2. Note that the exchange rate changes depending on Final Payment that has been entered.

Implications for COGS

The following information only applies to those using the Perpetual Accounting Method.

COGS for Sales Orders are generated when items have been dispatched, and the order has been invoiced. In some situations you may sell and invoice goods you have received before you have paid for your Foreign Currency Purchase. This is completely fine provided the final payment in your base currency is entered within 6 weeks of the order being received. Cin7 will create initial COGS based on the approximate conversion, and then check for updates periodically for 6 weeks.

If you do not plan to have paid the invoice within the 6 week period, then we recommend entering the closest estimate possible to minimize the discrepancy.


What currencies do you support?

Cin7 supports all major currencies and can add additional currencies upon request. Please contact Cin7 Support for additional details.

How is the approximate exchange rate calculated?

Our exchange rate is pulled daily from XE.com. It is recommended that this rate is only used as an estimate; for greater accuracy, see above.