Blog

Running Your Books in KES and USD: A Practical Guide

11/21/2026•8 min read
Running Your Books in KES and USD: A Practical Guide

Picture a Nairobi importer at month end. The supplier invoices are in dollars, the customer invoices are in shillings, and the bank statement has both. Somewhere between the rate on the invoice and the rate on the day the money moved, a few hundred thousand shillings have appeared or vanished, and nobody is quite sure which account they belong in.

This is one of the most common reasons Kenyan businesses outgrow entry-level accounting software. Multi-currency is not hard in principle, but it has to be set up properly from the start. This guide walks through how it works and how to set it up in ERPNext.

One Company, Two Currencies

Your company reports in one currency: KES. Your financial statements and tax returns are in KES. You can still buy, sell and bank in USD, but every USD transaction is also recorded in KES at an exchange rate.

In practice, that means three things need a currency:

  • Bank accounts. A USD account at your bank becomes a USD account in your books, so its balance matches the statement in dollars.
  • Customers and suppliers. A US supplier you pay in dollars is set up with USD as its currency, with its balance held in a USD payables account.
  • Invoices and payments. Each records the foreign amount and the rate, so the KES value is always known.

Where Exchange Differences Come From

Suppose you receive a supplier invoice for USD 10,000 when the rate is 130, so it goes into your books as KES 1,300,000. A month later you pay it, and the rate is 129. The payment costs KES 1,290,000. The KES 10,000 difference is a realised exchange gain.

In a spreadsheet, someone has to notice that difference, calculate it and post it. In ERPNext, when the payment is matched to the invoice, the difference is calculated and posted automatically to the exchange gain and loss account you set for the company.

At month end there is a second kind of difference. Unpaid USD invoices and USD bank balances are now worth a different amount in KES than when you recorded them. These are unrealised gains and losses. ERPNext's exchange rate revaluation works them out for every open USD balance and prepares the journal for you to check and post.

See KES and USD in One Set of Books

We'll show you multi-currency purchasing, payments and revaluation set up around your own business.

Book a Demo

Setting It Up Properly

  1. Decide your exchange rate policy with your auditor, and write it down.
  2. Create a separate bank account in the books for each currency you hold.
  3. Set up receivable and payable accounts for each foreign currency, such as Debtors - USD and Creditors - USD.
  4. Set each customer and supplier's currency before their first transaction. It is much harder to change afterwards.
  5. Set the exchange gain and loss account on the company, so realised differences have somewhere to go.
  6. Choose whether rates are fetched automatically or entered by your team, and who checks them.

Imports: Getting the True Cost in Shillings

For importers, the supplier invoice is only part of the cost. Freight, insurance, duty and clearing are usually paid in shillings, often weeks later. ERPNext's landed cost feature adds these charges to the items in the shipment, so your stock shows what the goods really cost to bring in.

The result is a cost price you can trust when setting selling prices, instead of a supplier price converted at whatever rate was handy.

Closing the Month

  • Reconcile each foreign bank account against its statement in the foreign currency.
  • Match payments to invoices so realised differences are posted.
  • Run the exchange rate revaluation for open balances at the month-end rate.
  • Review the exchange gain and loss account. A large or unexpected number usually points to a wrong rate on a single transaction.

What Your Reports Show

With currencies set up properly, the general ledger can show any account in its own currency and in KES, customer and supplier statements come out in the currency they trade in, and your financial statements are in KES with exchange differences on their own line. Month end becomes a review of numbers the system already holds.

See everything else in ERPNext Financial Management, or read how to handle invoices between related companies, which often come in a foreign currency too.

Frequently Asked Questions