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.
File your business taxes with confidence thanks to our 100% accurate guarantee.
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
These cookies are strictly necessary to provide you with the services and features available through our site. Because these cookies are strictly necessary to deliver the site, you cannot refuse them without impacting how the site functions.
These cookies are used to make advertising messages more relevant to you and your interests. They also perform functions like preventing the same ad from continuously reappearing, ensuring that ads are properly displayed, and in some cases selecting advertisements that are based on your interests.