We use multiple currency. When vendor invoice us in foreign currency, we use QB rates. I realise that when payment is done QB calculates its own exchange gain or loss. how do i reverse this or cancel it.(where is the transaction?)
Note : I pass the difference in exchange manually when payment is done.Also change the rate according to payment conversion (this is done when buying in another currency to pay particular foreign currency) ie. Buy EURO in USD (using USD Bank Account), to pay EURO - these are foreign currency . Home currency is SGD.
Is there any other effective way to post the transaction.
Good day ! i'm here to help :)
The exchange gain or loss in QB is recognised via the exchange rate field in the vendor invoice. For example, when we record the vendor invoice at a rate of 1:1.5 and subsequently, we record the payment at 1:2.0, there will be an exchange gain or loss based on the vendor invoice value X the difference in exchange rate (0.5 difference here).
We can avoid the exchange gain or loss by making sure the exchange rate is the same for the invoice and payment. To do this, we open the payment transactions, and edit the exchange rate to be the same as the vendor invoice exchange rate. The exchange gain or loss will be cancelled/removed.
Thanks for joining this conversation, @dtherrien.
I'm here to help get this taken care of, but I have some questions about your concern first.
To ensure that I'm on the same page, may I know where you want to assign a class? Is it for a specific transaction? Any additional information will be much appreciated. This will help me make sure that I can provide you with the best information.
In the meantime, I'm including these articles for additional information:
I'm looking forward to your response, @dtherrien. Take care always.
I also would like to know how to assign a class to the account "Exchange Gain Or Loss"
You asked "Where", well I would like to assign a class every time, but at this moment the most important is at the time of the payment, I mean, when the account appear in a cash movement (I am only using multi-currency in sales) because we use Cash Accounting Method. But it could be necessary also at the time of the invoice.
Thanks for your help.
Hey there, qbo2.
Allow me to provide additional information regarding adding a class to the Exchange Gain Or Loss account in QuickBooks Online.
Adding a class to the Exchange Gain Or Loss account is currently unavailable in QuickBooks Online. The Exchange Gain Or Loss is calculated once the payment is applied. You can only assign a class in the invoice and not at the time of payment.
These articles are a good reference:
For additional help, you can also reach out to our QuickBooks Online Support.
Feel free to get back to me if you have additional questions about Exchange Gain Or Loss in QuickBooks Online. Have a good one.
Thanks for joining the thread, @a-smith.
I'll share some information about adding a class to the exchange gain or loss account. Exchange gain and loss in QBO are calculated automatically and separately from the source transaction. Thus, adding it isn't possible.
To learn more about this feature, see the following links below:
If you have other questions or concerns about your exchange gain or loss account, please let me know. I'm more than willing to answer them for you. Have a great rest of the week.
Glad to have you back, @a-smith.
Currently, we don't have any update if this feature will be added soon. You can visit out blog site to stay current on the latest product updates. This way, you'll know what's new in QuickBooks Online.
Here's the link to our site: The QuickBooks Blog
Feel free to message me anytime if you need help with anything else. I'll be around for you. Take care.
I used a JE to move the exchange gain/loss from the unspecified class to the class where I wanted it to appear:
For a gain:
Debit unspecified (leave class blank)
Credit class where you want the gain to appear
For a loss
Debit class where you want the gain to appear
Credit unspecified (leave class blank)
Hi there, Anonymous2021.
I'm here to share some insights about attaching class to the exchange gain or loss account.
Currently, we're unable to add a class to these accounts since the amounts are calculated separately from the source transaction. As a workaround, you can follow the steps provided by O2Nicole to move the exchange gain/loss to your desired class using a journal entry.
I also understand how important this option to your business, especially if you have a lot of segments you want to keep a close eye on. Rest assured, I'll take note of your ideas and suggestions to help improve your experience in QuickBooks.
I'm also adding these articles to help manage your classes in the program:
If I can be of any additional assistance, please don't hesitate to reach out to me again. Stay safe and have a great rest of the day.
I can share the steps in handling the currency exchange difference, CCR1.
You can write it off as bad debt in QuickBooks Desktop. This way, you'll be able to close the invoice. First, you'll have to add an expense account to track the bad debt. I'll show you how:
When you're ready, here's how to close out the open invoice:
I also recommend checking our Accounts Receivable Workflow Guide to learn more about the different ways of tracking customer transactions.
We're open here 24/7, so please don't hesitate tp visit us again if you have any other concerns or questions. Have a good one.
Thanks for joining this thread, JMG6.
In QuickBooks Desktop (QBDT), when the invoice you send is uncollectible you have to record it as bad debt to write them off. This process ensures that your accounts receivable and net income stay up to date. To know more information about this, feel free to visit this article: Write off bad debt in QuickBooks Desktop.
Also, in QBDT, monitoring your business income and accounts receivable is a breeze. The program has ready-made customer reports you can open at any time and customize depending on your business needs.
Don't hesitate to post again here if you have any other QuickBooks concerns. I'm always around to assist you. Take care.
Good day, @gigiblewis.
Before we proceed, I'll have to ask for more information to understand the situation. Additional insight on this matter is greatly appreciated.
Our Community Help Articles page contains resources, video tutorials, and tips to manage your company files. If you need more information, feel free to visit the site.
I'll be here to help if you need further assistance. You can notify me by clicking the REPLY button below. Have a great day and keep safe!