Set Up Foreign Currency in Sage 50: Complete Setup & Exchange Rate Guide

Businesses that work with international customers, vendors, or bank accounts may need to record transactions in currencies other than their home currency. Sage 50 supports foreign-currency transactions by allowing users to configure currencies, maintain exchange rates, and assign currencies to customer and vendor records.

This guide explains how to set up foreign currency in Sage 50, including how to enable foreign-currency transactions, add currencies, enter exchange rates, and assign currencies to customers and vendors. Because available features and menu options can vary by Sage 50 edition and version, verify the steps for your specific installation before making changes to company settings.

What Is Foreign Currency in Sage 50?

Foreign currency in Sage 50 lets businesses record transactions in currencies other than their base currency. Businesses can use foreign currencies for customer invoices, vendor payments, bank accounts, and other transactions while Sage 50 keeps financial statements in the base currency.

Sage 50 uses exchange rates to convert foreign currency amounts into the base currency when businesses record transactions. The software tracks both the foreign currency amount and its equivalent value in the base currency, which helps businesses maintain consistent accounting records.

Changes in exchange rates can create differences between the transaction amount and the settlement amount. Sage 50 accounts for these exchange rate differences to help businesses maintain accurate financial records for foreign currency transactions.

What to Check Before Setting Up Foreign Currency

Prepare the required access, backup, and currency information before you configure a foreign currency in Sage 50. These checks help you complete the setup with the correct permissions and maintain consistent currency settings.

Confirm User Permissions

• Check that your Sage 50 user account has permission to add or modify currencies. Contact your administrator if you need additional access.

Create a Company Backup

• Back up your Sage 50 company data before changing currency settings. Save the backup with a clear name and date for easy identification.

Gather Currency and Exchange Rate Information

• List the currencies your bank accounts, customers, and vendors use. Keep the required currency and exchange-rate information available before beginning the setup.

How to Set Up Foreign Currency in Sage 50?

Before adding foreign currencies, enable foreign currency transactions and set the home currency in Sage 50. The available number of foreign currencies depends on your Sage 50 edition. Here is how to enable foreign-currency transactions in Sage 50:

• Open the company data file as sysadmin in single-user mode.
• Go to Setup >> Settings >> Company >> Currency.
• Select I want to enter transactions using Foreign Currencies.
• Select the required Home Currency.
• In the Enter information about your home currency section, select an Expense Account to track exchange and rounding differences.
• Click OK to save the settings.

Sage 50 may restrict changes to the home currency after transactions have been recorded. Check your edition’s currency settings and create a backup before making changes.

Also Read: How to Switch Sage 50 from Multi-User Setup to Single-User Mode?

How to Add & Modify a Foreign Currency in Sage 50?

You must enable foreign currency transactions before adding a currency. Some Sage 50 editions may also require single-user mode for currency settings.

Add a Foreign Currency

• Open the Setup menu and select Settings.
• Select Company, then click Currency.
• In the Foreign Currency column, select a new line and click Find.
• Select the currency you want to add and click Select.
• Enter an exchange rate if required.
• Click OK to save the currency.

Modify a Foreign Currency

• Go to Setup>>Settings>>Company>>Currency.
• Select the currency you want to modify.
• Update the currency settings available for your Sage 50 edition
• Click OK to save the changes.

How to Set an Exchange Rate in Sage 50?

Sage 50 lets you enter and update exchange rates for the foreign currencies used in your company. You can record the rate with its effective date and optionally use an exchange-rate website to obtain the latest rate. Follow these steps for Sage 50 foreign currency setup:

• Open the Setup menu and select Settings.
• Select Company, then click Currency.
• Click Exchange Rate and select the foreign currency you want to update.
• Enter the Date on a new line.
• Enter the applicable Exchange Rate for that date.
• Click OK to save the rate.

Use a reliable exchange-rate source to determine the applicable rate, then enter the rate in Sage 50 according to the transaction date and your accounting procedures

• Sage 50 also lets you update an exchange rate directly from a transaction window.
• Select the Exchange Rate option, enter the effective date and latest rate, and click OK.

How to Assign a Foreign Currency to a Customer?

Sage 50 assigns the selected foreign currency to a customer record and uses that currency for the customer’s transactions. You must create a new customer record because Sage 50 does not allow you to change the currency of an existing customer.

• Open Customers & Sales from the navigation pane.
• Right-click Customers in the Tasks pane and select Add Customer.
• Enter the customer’s name in the Customer box.
• Open the Options tab and select the foreign currency for the customer’s transactions.
• Open the Sales Taxes tab and select the applicable sales tax.
• Click Save and Close.

Sage 50 automatically uses the customer’s assigned currency when you create an invoice. You cannot assign a foreign currency to a one-time customer.

How to Assign a Foreign Currency to a Vendor?

Sage 50 assigns the selected foreign currency to a vendor record and uses that currency for the vendor’s transactions. You must create a new vendor record because Sage 50 does not allow you to change the currency assigned to an existing vendor.

• Create a new Vendor record.
• Enter the vendor’s name in the Vendor box.
• Open the Options tab and select the foreign currency for transactions with the vendor.
• Click Save and Close.

Sage 50 automatically uses the vendor’s assigned currency when you create an invoice. You cannot assign a foreign currency to a one-time vendor.

Common Problems When Setting Up Foreign Currency in Sage 50

Foreign currency setup issues often result from incorrect settings or insufficient user permissions. The following problems highlight the settings that need correction when you setup foreign currency in Sage 50:

Foreign Currency Option Is Unavailable

Check whether foreign-currency functionality is enabled for your edition and whether your user account has the required permissions. If the option is unavailable after transactions have been recorded, review your edition-specific restrictions before changing company settings.

Exchange Rate Does Not Match the Transaction

Check the exchange rate and effective date when the converted amount looks incorrect. Enter the rate that applies to the transaction date.

Customer or Vendor Currency Cannot Be Changed

Sage 50 does not let you change the currency assigned to an existing customer or vendor. Create a new record and select the required currency.

Foreign Currency Does Not Appear on a Transaction

Check the currency assigned to the customer or vendor. Sage 50 uses that currency for related transactions.

Currency Settings Cannot Be Updated

Check your user permissions and confirm that you opened the company file in the required mode. Review the requirements for your Sage 50 edition before changing currency settings.

Final Words

Sage 50 provides currency settings that help businesses record transactions involving multiple currencies. To set up foreign currency, enable foreign-currency transactions, select the appropriate home currency, add the required currencies, maintain exchange rates, and assign currencies to the appropriate customer and vendor records.

Before changing company currency settings, create a current backup and confirm that the steps and available options match your Sage 50 edition and version. Maintaining accurate currency and exchange-rate settings can help keep foreign-currency transactions consistent with your accounting records.

Frequently Asked Transactions: