In the West Bank, you sell in shekels, buy from a supplier who prices in dollars, and pay the store rent in dinars. Three currencies in one notebook, and the exchange rate changes every day. For many shop owners, the result is a ledger whose true balance no one knows: a customer says he paid in full and you see the rest on him, a supplier asks you for a price difference that you did not calculate, and a box containing three different banknotes that you do not know how much their total is worth. This guide gives you simple rules to end this chaos.
1. Why do you deal in three currencies in the first place?
It's often not an option. The customer in the market pays in shekels because it is what he receives from his salary. The importer or agent prices in dollars because he buys it from abroad and wants to protect himself from the fluctuation of the shekel. Many lease contracts and some long-term obligations are written in the dinar due to its relative stability. You find yourself, without your decision, managing three currencies in one store.
The mistake is not in multiple currencies, but in trying to convert everything into one currency in the head at each operation. The solution is exactly the opposite: leave each operation in its currency, record with it the exchange rate at which it took place, and let the program collect and convert when needed.
2. Record each transaction in its currency and exchange rate
The first rule, which is the most important thing in this guide: every invoice and every instrument is recorded in the currency in which it was actually made, along with the exchange rate that was in effect at that moment. If you buy goods in dollars, the invoice is in dollars and that day's exchange rate is written on it. If the customer pays you a shekel for an invoice in dollars, the receipt will be in shekels, along with the price you agreed upon.
Why is this important? Because the exchange rate that matters in accounting is the price on the day of the transaction, not the price on the day the account was reviewed. If you convert last month's invoice to today's price, you have changed a number that had settled, and the customer's balance with you will differ from his balance in his book.
Tip: Agree with each customer and supplier on the source of the exchange rate that they rely on, the nearby exchange rate, for example, or a specific price fixed on the invoice, so that there is no disagreement again at each payment.
3. An account for each customer and supplier in their currency
Open the account of each customer and supplier in the currency in which you actually deal with him, and specify that on his card from the beginning. The supplier who prices in dollars has his account in dollars, even if you sometimes pay him a shekel, and the customer who buys in shekels has his account in shekels. Thus, his balance remains fixed and does not move with the market, and his account statement is in a language he understands.
When a customer pays in a currency other than the currency of his account, do not change the account currency, but rather record the payment in its currency and exchange rate, and the equivalent in his account currency is deducted from his balance. The small difference that may arise between the agreed upon price and the invoice price has another place, which we will return to in the sixth paragraph.
Avoid two things: having one customer have two accounts in two currencies, because you will forget which one to register in, and recording a payment in shekels in an account in dollars without an exchange rate, because the balance will become a meaningless number.
4. Separate box for each currency
A box in which currencies are mixed can never be matched. Make a separate drawer or wallet for each currency in the store, and a corresponding separate box account in your book: a shekel box, a dollar box, and a dinar box. At the end of each shift, each box is counted in its own currency and matched with what the program says in the same currency, without conversion.
When you exchange currency, such as exchanging dollars from the cash register to shekels at the cashier, record it as an independent transaction: leaving the dollar fund and entering the shekel fund at the actual exchange rate. Thus, each box remains correct, and any difference appears in its place and not in another place.
The same goes for a bank: a bank account for each currency you hold, not one account where you drop all your transfers.
5. In what currency do you price your goods?
Choose one pricing currency for each group of items. Goods that you buy in dollars and whose prices change with the market, such as imported appliances and spare parts, are easier to price in dollars and sell in shekels at today’s exchange rate. As for daily consumption goods that you buy in shekels, price them in shekels and do not track the exchange rate.
And be careful of the following:
- Determine a clear rounding policy for the selling price in shekels, so that the price does not differ from one cashier to another on the same day.
- Review the prices of goods priced in dollars when the exchange rate moves significantly, not every day.
- If you have more than one price level, such as the wholesale price and the retail price, make them all in the same currency for one item.
6. Currency Spreads: Where Does the Profit or Loss Go?
Suppose you sold goods to a customer for one hundred dollars and recorded them at a specific exchange rate, then he paid you a month later in shekels and the price changed. The amount you received in shekels is now equal to more or less the value of the invoice on the day it was issued. This difference is neither an error nor a discount; Currency difference It is a real profit or loss for your shop.
Example: A bill for $100 was recorded at 3.60 on the day it was issued, which is equivalent to 360 shekels. The customer paid it a month later for $100, but the exchange rate at that time was 3.50, so what he received was equivalent to 350 shekels. The customer's balance in dollars was completely closed, and in your book in shekels, the difference of 10 shekels is a loss of currency, not a debt owed to the customer. The numbers here are for clarification only.
Do not fix it by amending the invoice, nor by leaving a small remainder on the customer forever. Open an account in your chart of accounts called “Currency Differences,” and record these differences whenever they appear, with a simple entry that closes the customer’s balance and charges the difference to this account. At the end of the month, you will see a single number in this account that tells you whether the currency fluctuation is a profit or loss for you, and it is a number worth knowing.
Tip: If the currency spread calculation shows a continuous loss, the problem is most likely in the pricing policy or the length of the credit period you grant, not the market.
7. Monthly review in half an hour
The above remains theoretical unless you review it regularly. Set aside half an hour at the beginning of each month for this list:
- Count each box in its currency and match it to the program, recording any difference on its day rather than at the end of the year.
- Review the balances of customers and suppliers, each in its own currency, and make sure that there is no account in which a payment was recorded without an exchange rate.
- See Calculating Currency Spreads: What is this month's total? Is it understandable?
- Check the exchange rate used in the statements you will send to customers, so no one is surprised by a different number.
- Review merchandise prices priced in dollars versus the last purchase price.
- Take a backup of your data after the review.
After two or three months of sticking to this list, you will find that multiple currencies are no longer a concern, but just an extra column in your bills.
How does Sonbola help you with this?
In the “Accounting” edition of Sonbola, every invoice and every voucher is recorded in its currency, in shekels, dollars, or dinars, with an exchange rate specific to each transaction, and the accounts of customers and suppliers remain in their currencies as specified on their cards. The receipt voucher and the multi-line voucher accept cash, card, transfer, and check on the same voucher, and the cashier’s shift is closed by matching the cashier. Each item has five selling prices, and each customer has a special pricing level. Using the chart of accounts and daily entries, you open a currency differences account and record what appears in it, and the trial balance and income statement display the complete result. Compare versions And read how it works in stores Spare parts And Building materials And Clothes And Maintenance workshops How does the program save your data? Without internet In Palestine . If you have credit customers, read the guide Follow up on customer debts , and before purchasing guide Choose accounting software .