Need more, need help now?
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals

foreign exchange transactions

Sage 50 general help forum - Free help and support for all general issues
Post Reply
leftie
User
User
Posts: 4
Joined: 31 Jul 2010, 15:10
Sage Version: v2008 14 UK/Europe/Africa

foreign exchange transactions

Post by leftie » 29 Dec 2010, 14:44

We invoice in Sterling, Euros & US Dollars:

- Sterling & US $ payments are handled via our Sterling a/c whilst Euro's come in / go from our Euro Account

- When setting up Sage I created a dummy $ account so that we can invoice in $ - as well as a Euro Account

Several questions arise:
1) when we receive a $ payment to our bank account, this is converted to £ sterling - how do I key this payment into Sage? (in US $ in full & then some form of dummy inv/cr to balance it or do I just change the exchange rate for the transaction or...?????)
2) When we transfer money in / out of the Euro account to / from our £ account, there are charges & potentially different rates - assume charges go against 7901 but how do you handle exchange rate variance on this?
3) Some suppliers are paid in $ from our sterling account - again, what is the best way to show the charges & exchange rate variances (if any) in Sage?

Thanks in advance

leftie
User
User
Posts: 4
Joined: 31 Jul 2010, 15:10
Sage Version: v2008 14 UK/Europe/Africa

Re: foreign exchange transactions

Post by leftie » 29 Dec 2010, 14:51

Sorry - also just need to check - where we get a payment in & the amount is short because of bank charges, do we process as paid in full & then put a bank charge through for the difference or do we have to do a credit on the account then a bank charge?

User avatar
brucedenney
Site Admin
Site Admin
Posts: 4664
Joined: 28 Feb 2006, 09:56
Sage Version: v30 UK/Europe/Africa

Re: foreign exchange transactions

Post by brucedenney » 10 Jan 2011, 10:25

1/ Receive as dollars in the dummy dollar account, then to a bank transfer to the Sterling account

2/ You set the exchange rate for the transaction so there should be no variance on the transaction, although there is a variance on the value not transferred this variance is handled by the foreign bank revaluation wizard.

3/ Transfer £ from the Sterling Bank account to the $ bank account, then pay form the $ bank account.

4/ Both work, so your choice.
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.

Post Reply

Who is online

Users browsing this forum: No registered users and 5 guests