reconcilling a foreign bank account
mc25
Registered Posts: 232 Dedicated contributor 🦉
Hi,
Just need some clarification from those who have dealt with this before. I've got a client who has got a Euro/Dollar account, thy use sage so thy convert the currency on b/statement to sterling pound, as you know you will always have a difference due to timing difference from when the invoice was raised to when it got paid. My question is when you come to reconcile the bank account, could you convert every single item to £ or could you pay out the invoice (to match invoice amount) then work out the difference at the end of the month (use the exchange rate at the end of the month)and post the adjustment to foreign currency adjust.
It will be interesting to hear how different people deal with this.
Thanks
Just need some clarification from those who have dealt with this before. I've got a client who has got a Euro/Dollar account, thy use sage so thy convert the currency on b/statement to sterling pound, as you know you will always have a difference due to timing difference from when the invoice was raised to when it got paid. My question is when you come to reconcile the bank account, could you convert every single item to £ or could you pay out the invoice (to match invoice amount) then work out the difference at the end of the month (use the exchange rate at the end of the month)and post the adjustment to foreign currency adjust.
It will be interesting to hear how different people deal with this.
Thanks
0
Comments
-
Hi
On the occasions I've done this, there haven't been that many transactions, so for every transaction I have used the exchange rate in force one the date of the transactions (use www.xe.com or www.oanda.com or similar).
I then do the same with the ending balance on the statement - and the difference needed to reconcile the bank [nb: because of this you have to be extra careful with bank reconciling as the closing balance can't be a check due to exchange rate differences] is posted to the P&L as Exchange Rate Variance.
With hindsight, I reckon if you use an average exchange rate and are consistent with it, and only pull up a current exchange rate at month/year end, you would be able to rec the bank in the normal manner with fewer adjustments and I think the net result would be the same. Exchange rates confuse the hell out of me though, so I was happier doing each transaction as I went along.
I believe the relevant FRS says use the date in force at the time of the transaction but don't ask me to quote it0 -
monsoon,
thanks for your reply. I will read more about it, i know what you are saying its really confusing and you have got to keep ontop of it all the time.0 -
Our EUR/USD account values the foreign currency transactions in the month by the current HMRC exchange rate in force for that week to get the sterling equivalent. At the end of the month the remaining cashbook balance is revauled at our month end exchange rate to give a sterling eqivalent and the balance written to realised exchange gain/loss.
The EUR/USD invoices outstanding at month end should be revalued for by way of a unrealised revaluation journal, this would be reversed the following period until they were paid.0
Categories
- All Categories
- 1.2K Books to buy and sell
- 2.3K General discussion
- 12.5K For AAT students
- 325 NEW! Qualifications 2022
- 160 General Qualifications 2022 discussion
- 11 AAT Level 2 Certificate in Accounting
- 56 AAT Level 3 Diploma in Accounting
- 95 AAT Level 4 Diploma in Professional Accounting
- 8.9K For accounting professionals
- 23 coronavirus (Covid-19)
- 273 VAT
- 92 Software
- 275 Tax
- 138 Bookkeeping
- 7.2K General accounting discussion
- 202 AAT member discussion
- 3.8K For everyone
- 38 AAT news and announcements
- 345 Feedback for AAT
- 2.8K Chat and off-topic discussion
- 583 Job postings
- 16 Who can benefit from AAT?
- 36 Where can AAT take me?
- 42 Getting started with AAT
- 26 Finding an AAT training provider
- 48 Distance learning and other ways to study AAT
- 25 Apprenticeships
- 66 AAT membership