Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Hello everyone
I'm using QBO and multi currency option.
So I made entries for expenses and revenue since 01/2020 but as I'm checking reports the total is not correct as QBO uses rate 1=1. How can I upload or change since the beginning of year all rates so that reports will work properly.
In currency center I didn't find anything at all.
You can export the data out to XLS, modify them, and reimport them back in bulk by using a 3rd party tool.
https:// transactionpro.grsm.io/qbo
Hi there, DiaA1.
Let me share some information on how the multi-currency feature works and why QuickBooks uses the rate 1=1.
I've tried this on my end, and it seems like we have the same outcome. It's because the system depends on foreign exchange. If we want to change all rates from January, we can revalue the old transactions within QuickBooks. We'll only need to make sure that the foreign exchange has been changed. Otherwise, we're unable to modify the rate as it's already using the correct one.
Here's how to do it:
Here are the sample screenshots:
Then, all reports depend on the rate used on the transaction. Aside from that, we can export them to Excel and modify the rate. Then, use a third-party application that integrates with QuickBooks and import them all at once.
Also, you may read through the frequently asked questions about the currency adjustment in QBO. It helps us get more details about the said feature in QuickBooks Online.
Let me know if you have other questions. I'm always here to assist. Have a good and take care always.
Thank you for joining thing thread, slevetin,
QuickBooks Online (QBO) only allows you to enter rates manually.
I'll take note of your concern and pass it to our Product Team. This way, they can take a look at exporting historical rates from QBO to Excel.
For now, you can take a screenshot of the currency list in QuickBooks for your copy.
You can also visit our Firm of the Future page to know the latest updates and improvements in QuickBooks.
Don't hesitate to post again if there's anything else you need. I'm always around here in the Intuit Community to help.
You may export your Invoice data with currency and exchange rate info to XLS as the workaround.
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