ConnectStock 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 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 base currency.
1. Set up multiple currencies
In the left menu, click Stores & Files, open the Inventory Files tab, click your file, then click General.
Turn on Multi-Currency. The Home Currency field is now called Base Currency.
Select your currency in Base Currency.
Click Save, then click Enable.
When you add a new customer or vendor, select their currency from the dropdown. From then on, bills and invoices use the currency of that customer or vendor.
Important: Once you turn on Multi-Currency and save, you can't turn it off or change your base currency. You also can't change a customer's or vendor's currency after you save 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
Bills and invoices work the same way as before, except you enter amounts 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 fills in the exchange rate based on the document's date.
You can change the rate if you need a different one.
If no rate is available, you must enter it yourself.
Important: Changing the date, or picking a customer or vendor with a different currency, resets the rate. This happens even if you typed the rate in yourself. Always check the rate before you save.
3. Where will I see each currency?
ConnectStock keeps your purchase and sales documents in their original currencies, but uses your base currency for inventory and accounting.
Where | Currency shown |
Bills and purchase orders | Vendor's currency |
Sales invoices | Customer's currency |
Item costs and inventory value | Your base currency |
Inventory, ledger and aging reports | Your base currency |
P&L and dashboard sales | Currency selected in the report |
For example, you might buy an item for €10, but your inventory report shows its converted cost in USD.
4. How it works with QuickBooks and Xero
ConnectStock can export your transactions whether or not your accounting system uses multiple currencies.
If QuickBooks or Xero is set up for multiple currencies: bills and invoices export in their original currency, along with the exchange rate.
If QuickBooks or Xero is not set up for multiple currencies: 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 don't match, all exports stop before any accounting documents are created.
Cost of goods sold (COGS) always exports in your base currency.
What if an export fails because of a customer or vendor?
QuickBooks doesn't let you 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
The Excel templates support multiple currencies.
Customers and vendors: use the Currency column to choose their currency.
Bills, purchase orders and invoices: use the Exchange Rate column to set a rate.
You can leave the exchange rate blank. ConnectStock then uses the rate for the document's date. If no rate is available, you need to enter one yourself.
Supported currencies: USD, CAD, MXN, GBP, EUR, INR, AUD, JPY, SGD, BRL, SEK, PLN, AED and TRY.
Frequently asked questions
Do I need to turn on Multi-Currency if I only use USD?
No. Just select USD as your company currency. You only need it if you work with more than 1 currency.
Can I turn off Multi-Currency or change my base currency later?
No. Once you turn it on and save, these settings are permanent.
Can I change a customer's or vendor's currency?
No. 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 doesn't fill in the item's default cost, because that cost is saved in your base currency. 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 got the bill on Friday, the 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 new amounts can be sent to your accounting system.
What happens if ConnectStock can't find an exchange rate?
You need to enter the exchange rate yourself before you save the document.
Will turning on Multi-Currency change my existing transactions?
No. Existing transactions and contacts stay in your base currency. Only new transactions and contacts can use other currencies.