Tell me more ×
Answers OnStartups is a question and answer site for entrepreneurs looking to start or run a new business. It's 100% free, no registration required.

I run a small limited company in the UK which requires very simple bookkeeping.

The company sales online services (internet apps) and the only costs the company have are:

  • domain and hosting,
  • transaction fees,
  • director’s salary paid monthly.

I work from home and I made myself all the apps the company sales. I keep a simple cash book and record every transaction.

enter image description here

However, the company operates all over the Europe and accepts payments in Euros and Zlotys.

In this example, let’s say all payments were taken in Zlotys (PLN).

enter image description here

As you can see from the table, the company had two customers and earned 100 PLN in total.

According to the law, all the received amounts must be converted into pounds (GBP). I made a few simple changes to the cash book:

enter image description here

From this table you know that on my bank account there should be two transactions of 50 PLN each.

And now let’s say that 2012-02-12 is the last day of my accounting year.

I have 100 PLN at my disposal (on the bank account), which should equal to 19.59 GBP. However, over the year the pound fluctuated and 100PLN is today worth 19.80 GBP.

This way the company earned 21 pence.

I have another cash book in which I record other incomes (for example bank interests).

enter image description here

And now the basic question – do I do it right?

Is this form acceptable?

How often should I record profits and losses if the currency fluctuates?

Should I do it every time the exchange rate changes or on the last day of my accounting year? (I would opt for the first one.)

Should I have one book for both sales in pounds and zlotys or keep the sales in separate books?

To anticipate your suggestions - yes, I'm going to contant an accountant, but first I would like to get the basics and make sure I understand what I'm doing.

In the meantime, I created another table.

enter image description here

This table shows transactions in both pounds and zlotys. There is also a total amount received in GBP and ammout of assets in PLN. Do you think this is clear to understand? I'm not sure whether this could look like if I had 29GBP and 100PLN on top of that. If so, how can I improve the table?

share|improve this question
1  
Can you not convert to GBP on the day the funds are received and just track everything in GBP? I'd hate to see you spend time on accounting when you could be building your business. – Scott Wilson May 29 '12 at 14:36
Look no further than WHMCS... – Sachin Shekhar Aug 27 '12 at 14:44
1  
Here's an interesting article on multiple currency accounting, using currency trading accounts: mscs.dal.ca/~selinger/accounting/tutorial.html – user Aug 29 '12 at 0:44

1 Answer

If you maintain cash accounts in several currencies, you should maintain financial statements (P&L, BS, Cash flow statements, etc) in each currency.

As and when you undertake an FX transaction to move cash from one currency to another, at that point you should update each set of accounts accordingly, applying the FX rate at the time the transaction was made. This can be done as frequently or as rarely as you determine.

This approach gives you the mechanism of measuring P&L from a particular jurisdiction in the currency of that jurisdiction, and thus obviates the need for you to do anything specific in respect of FX risk at this level.

However, the FX risk must still be managed. You should consider a separate mechanism for doing this, perhaps by converting your PLN P&L to GBP on a periodic basis (say monthly). This can become a complicated endeavour quite quickly, especially if you are sitting on large amounts of currency from different jurisdictions. In this case, it becomes a management (treasury) decision as to how frequently you undertake FX transactions to move money to your base reporting currency. This decision will need to be driven by your capital requirements in each region -- for example, do you need to pay Poles in PLN, if so, leave some PLN in place for that.

If the FX risk gets severe, you may even need to consider hedging mechanisms (FX futures or options) to manage that risk.

You should of course bear in mind that FX rates change continually on a 24x7 basis, and not at discrete periods.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.