Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Hi - I'm new to QB and just trying to figure out how QB handles currency (in particular for Profit and Loss items) as I'm running into some issues, but don't know if it's just the way I'm doing things.
Background: We operate with just two currencies - CAD is our reporting currency, but daily transactions are done in USD. We have moved from FinancialForce. For Profit and Loss items, we used to wait until month end and run a currency revaluation for the entire month using the average rate - one process and a few minutes to do. I understand QB is based on a daily rate rather than monthly average.
My issue is, if I do not enter a USD > CAD rate in advance, and someone posts a USD entry (e.g. a sales invoice), it will get recorded at a rate of 1:1, or at the last entered rate.
What is best practice here:
Thanks,
Daniel
Solved! Go to Solution.
Hi there, danielk1.
Thanks for reaching out to the QuickBooks Community. Let me help share some insights about the multi-currency in QuickBooks Desktop.
I appreciate the detailed information you've provided. QuickBooks cannot generate the exact conversion in advance since the rate is subject to change. Once you post a USD entry for a specific transaction, it will be recorded at a rate of 1:1 or the last entered rate.
To answer your first question, the option is, you'll need to change the As Of Date and Exchange Rate manually so QuickBooks automatically grab the FX rate at the start of a day (attached screenshot).
For your second question, you can use the home currency adjustments this will calculated based on the difference between the exchange rate recorded with each transaction and the exchange rate as of the home currency adjustment.
It's calculated on:
Lastly, there isn't an option to update the FX rates by batch for a certain period. Instead, you'll need to change it manually.
For additional reference, you can check this article: Set up and use Multi-currency.
If you need further assistance with the process, I encourage you to contact our QuickBooks Desktop Support Team. They have additional tools to pull up your account and do a screen-share.
Here's how you can contact our customer support:
Please know that you're always welcome to post if you have additional questions about the Multi-Currency. Wishing you and your business continued success.
Hi there, danielk1.
Thanks for reaching out to the QuickBooks Community. Let me help share some insights about the multi-currency in QuickBooks Desktop.
I appreciate the detailed information you've provided. QuickBooks cannot generate the exact conversion in advance since the rate is subject to change. Once you post a USD entry for a specific transaction, it will be recorded at a rate of 1:1 or the last entered rate.
To answer your first question, the option is, you'll need to change the As Of Date and Exchange Rate manually so QuickBooks automatically grab the FX rate at the start of a day (attached screenshot).
For your second question, you can use the home currency adjustments this will calculated based on the difference between the exchange rate recorded with each transaction and the exchange rate as of the home currency adjustment.
It's calculated on:
Lastly, there isn't an option to update the FX rates by batch for a certain period. Instead, you'll need to change it manually.
For additional reference, you can check this article: Set up and use Multi-currency.
If you need further assistance with the process, I encourage you to contact our QuickBooks Desktop Support Team. They have additional tools to pull up your account and do a screen-share.
Here's how you can contact our customer support:
Please know that you're always welcome to post if you have additional questions about the Multi-Currency. Wishing you and your business continued success.
If you just want to post a foreign currency sales invoice today that is dated in the future, you may just want to create a recurring template of the invoice dated into the future and set it up so that the invoice will be auto entered in the future. Not sure if this answers your question.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here