ConnectStock now supports multiple currencies, so you can buy and sell in different currencies without converting amounts yourself.
For example, if your company uses US dollars but you buy products from a European vendor, you can enter the bill in euros. ConnectStock automatically converts the cost to US dollars for your inventory.
Example:
Your company currency is USD.
Your vendor sends you a bill for €100.
The exchange rate is €1 = $1.08.
Your bill shows €100, while ConnectStock records an inventory cost of $108.
Your company's main currency is called your home currency.
1. Set up multiple currencies
Go to ConnectStock → File Settings → General.
Turn on Multi-Currency.
Select your home currency.
Click Save.
When adding a new customer or vendor, select their currency from the dropdown.
From now on, bills and invoices will automatically use the currency assigned to that customer or vendor.
Important: Once you enable multi-currency and save, you cannot turn it off or change your base currency. You also cannot change a customer’s or vendor’s currency after saving it.
If you use QuickBooks or Xero, make sure your base currency matches the home currency in your accounting system.
2. Create bills and invoices
Creating bills and invoices works the same way as before, except amounts are entered in the customer’s or vendor’s currency.
For example, if a vendor uses euros, enter the item costs, freight, and other charges in euros.
How exchange rates work:
ConnectStock automatically fills in the exchange rate based on the document's date.
You can change the rate if you need to use a different one.
If no rate is available, you must enter it yourself.
Important: Changing the document's date, customer, or vendor automatically resets the exchange rate, even if you entered it manually. Always review the rate before saving.
3. Where will I see each currency?
ConnectStock keeps your purchasing and sales documents in their original currencies, but uses your base currency for inventory and accounting calculations.
Where | Currency shown |
Bills and purchase orders | Vendor's currency |
Sales invoices | Customer's currency |
Item costs and inventory value | Your home currency |
Inventory, ledger, and aging reports | Your home currency |
P&L and dashboard sales | Currency selected in the report |
For example, you might purchase an item for €10, but your inventory report will show its converted cost in USD.
4. How it works with QuickBooks and Xero
ConnectStock supports exporting transactions whether or not you have multi-currency enabled in your accounting system.
If multi-currency is enabled in QuickBooks or Xero:
Bills and invoices export in their original currency, along with the exchange rate.
If multi-currency is not enabled in QuickBooks or Xero:
ConnectStock converts the amounts into your accounting system's home currency before exporting.
Important: Your ConnectStock base currency must match the home currency in QuickBooks or Xero. If they do not match, all exports will stop before any accounting documents are created.
Cost of goods sold (COGS) always exports in your home currency.
What if an export fails because of a customer or vendor?
QuickBooks does not allow you to change the currency of an existing customer or vendor.
For example, if a vendor already exists in QuickBooks with USD but you now need to export a bill in EUR, the export may fail.
To fix this, create a new vendor in ConnectStock with the correct currency and a different name.
Make sure the name is unique, including when ConnectStock shortens it to meet QuickBooks' name limits.
5. Importing with Excel
Excel templates now support multiple currencies.
Customers and vendors: Use the new Currency column to choose their currency.
Bills, purchase orders, and invoices: Use the Exchange Rate column to specify a rate.
You can leave the exchange rate blank. ConnectStock will automatically use the rate for the document's date.
If no rate is available, you will need to enter one manually.
Supported currencies: USD, CAD, MXN, AUD, GBP, EUR, JPY, AED, BRL, SEK, PLN, and TRY.
Frequently asked questions
Do I need to enable multi-currency if I only use USD?
No. Simply select USD as your company currency. You only need multi-currency if you work with more than one currency.
Can I turn off multi-currency or change my base currency later?
No. Once you enable and save multi-currency, these settings are permanent.
Can I change a customer's or vendor's currency?
No. You will need to create a new customer or vendor with the correct currency.
Why is the item cost empty when I add it to a bill or purchase order?
If the vendor uses a different currency, ConnectStock will not automatically fill in the item's default cost because that cost is saved in your base currency.
Simply enter the cost in the vendor's currency.
Why does my inventory show a different cost from my bill?
Your bill shows the amount in the vendor's currency, while your inventory shows the converted cost in your base currency.
For example, a €100 bill may show an inventory cost of $108.
Why is the exchange rate on my bill different from the purchase order?
Each document uses the exchange rate for its own date.
If you created a purchase order on Monday and received the bill on Friday, the exchange rates may be different.
Why did an exported bill change back to "Changed" after I updated the exchange rate?
Updating the exchange rate changes the converted amounts.
ConnectStock marks the bill as Changed so the updated amounts can be sent to your accounting system.
What happens if ConnectStock cannot find an exchange rate?
You will need to enter the exchange rate manually before saving the document.
Will enabling multi-currency change my existing transactions?
No. Existing transactions and contacts will remain in your base currency. Only new transactions and contacts can use other currencies.