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
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
- - - - - - - - - - - - - - - - - - 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
Re: foreign exchange transactions
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?
- brucedenney
- Site Admin
- Posts: 4664
- Joined: 28 Feb 2006, 09:56
- Sage Version: v30 UK/Europe/Africa
Re: foreign exchange transactions
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.
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.
Who is online
Users browsing this forum: Amazon [Bot] and 1 guest