# Africa Multi-Currency ERP Setup Worksheet > Source: https://netray.co/tools/africa-multi-currency-erp-setup-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer List the currencies your ERP must handle, key a rate and foreign balance, and see local currency value and the effect of a rate move. ## Category cost-finance ## Region Africa ## Audience - Financial controller - ERP administrator - Treasury analyst ## Tool **Kind:** worksheet **Mode:** editable **Currency:** R **Columns:** #### Currency code **Key:** code **Type:** text #### Country or zone **Key:** country **Type:** text #### Used for **Key:** role **Type:** select **Options:** - Sales - Purchases - Bank - Intercompany #### Rate source **Key:** source **Type:** select **Options:** - Central bank - Bank rate - Manual - Feed #### Rate to ZAR **Key:** rate **Type:** number **Format:** decimal #### Foreign balance **Key:** balance **Type:** number **Format:** number #### Value in ZAR **Key:** zar **Type:** number **Expr:** balance * rate **Format:** currency #### Rate move % **Key:** shock **Type:** number **Format:** percent #### Impact in ZAR **Key:** impact **Type:** number **Expr:** balance * rate * shock / 100 **Format:** currency **Rows:** **Code:** USD **Country:** United States **Role:** Purchases **Source:** Central bank **Rate:** 18.2 **Balance:** 120000 **Shock:** 5 **Code:** EUR **Country:** Eurozone **Role:** Purchases **Source:** Central bank **Rate:** 19.8 **Balance:** 45000 **Shock:** 5 **Code:** BWP **Country:** Botswana **Role:** Sales **Source:** Bank rate **Rate:** 1.35 **Balance:** 300000 **Shock:** 5 **Code:** ZMW **Country:** Zambia **Role:** Sales **Source:** Manual **Rate:** 0.7 **Balance:** 800000 **Shock:** 10 **Code:** NGN **Country:** Nigeria **Role:** Sales **Source:** Manual **Rate:** 0.012 **Balance:** 25000000 **Shock:** 10 **Totals:** #### Total exposure in ZAR **Key:** zar **Agg:** sum **Format:** currency #### Total impact of rate moves **Key:** impact **Agg:** sum **Format:** currency **Summary:** #### Impact as share of exposure **Key:** impact_pct **Expr:** if(gt(sum_zar,0),sum_impact / sum_zar * 100,0) **Format:** percent **Primary:** true **Notes:** Rates in the table are illustrative and not market quotes. Replace them with your own source on the day. Positive rate move percent means the foreign currency strengthens against the Rand. ## Content **Intro:** Companies trading across Africa often invoice in dollars, euros and several local currencies, while keeping accounts in Rand or another base currency. Setting that up in an ERP means deciding which currencies, which rate source and when to revalue. This worksheet puts those decisions in one place and shows the exposure behind them. **Sections:** #### How to use the worksheet **Body:** List each currency you buy, sell or bank in. Record the country, what you use it for, and where the rate will come from. Enter the current rate to your base currency and the foreign balance you carry. The sheet calculates the base currency value, and the effect of a rate move you choose, so you can see how much a shift in the Kwacha or Naira could change your reported position. Export it for your finance and IT teams. #### Setup decisions it prompts **Body:** For each currency your ERP needs a code, a rate table, and a decision on how often rates update. It also needs rules for revaluing open items and bank balances at period end, and accounts for realised and unrealised exchange differences. In SYSPRO, Sage Evolution and Odoo these appear as currency master records, rate maintenance and revaluation routines, though the names differ. Settle the policy before configuring the system. #### Reading the exposure **Body:** The impact column multiplies the base value by the rate move you enter. Use a modest move for stable currencies and a larger one for volatile ones. If total impact is a meaningful share of exposure, consider invoicing in your base currency, shortening payment terms, or discussing hedging with your bank. The worksheet does not forecast rates, it only shows sensitivity. #### Common mistakes **Body:** Teams often use a different rate source in sales and finance, forget to update manual rates, or skip revaluation until year end. Others set rates on a single day and never refresh them. For currencies with official and parallel rates, agree which one your auditors accept and document it. Test the setup with a sample invoice and payment before going live. **Cta:** If you want a read-only report that shows open foreign balances and exposure from your ERP every day, Netray can build it over your existing data. **Faq:** #### Which currency should be my base currency? **Answer:** Usually the currency of your statutory reporting, such as the Rand for South African companies. Group reporting needs and lender requirements can also influence the choice. Decide with your auditors before configuring, because changing it later is hard. #### How often should exchange rates update? **Answer:** Daily for active trading currencies, weekly or monthly for minor ones. What matters is a documented source and a consistent method. Manual rates need an owner and a reminder. #### What is the difference between realised and unrealised exchange differences? **Answer:** Realised differences arise when a foreign invoice is paid or received and the rate differs from booking. Unrealised differences arise from revaluing open items and bank balances at period end. Most ERPs post them to separate accounts. #### Does this worksheet give financial advice? **Answer:** No. It is a planning aid that shows sensitivity to rate moves. Speak to your auditor or bank for hedging, tax and regulatory guidance, especially for currencies with controls. ## Search terms multi currency erp setup, erp exchange rate setup, africa currency erp, syspro multi currency, sage evolution foreign currency, odoo multi currency africa, foreign currency revaluation worksheet, zar exchange rate exposure --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json