Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
The company has CDN and US vendors and customers. When the Balance Sheet report is run both bank accounts are displayed in CDN value. How do you run a report that shows the USD value (foreign currency) not converted to CDN (home currency). And how do you run a Profit & Loss to show only foreign currency value not the CDN converted value?
Hi there,
Thanks for reaching out to the Community.
At this time, QuickBooks Online will only show you the home currency on your reports. I know how useful this feature is to you and I encourage you to leave Feedback about this to our engineers. You can do this by clicking the gear icon and looking for feedback. New product ideas are based on the feedback we get from other users like you. Let me know if you've got questions. I'm here to help.
JamesM thank you for your quick reply. I'm using QBDesktop and not Online. Is this the same for Desktop?
My mistake. The same applies with QuickBooks Desktop. Reports will always reflect the home currency regardless of the currency used in transactions. I encourage you to check out this article for more info https://quickbooks.intuit.com/community/Getting-Started/Set-up-and-use-Multi-currency/m-p/262250http.... Feel free to ask questions.
In QBO how do I see the foreign balance on my foreign accounts? In QB Desktop it can be done in a number of ways, including by viewing the GL register but there is no balance other than home currency in QBO. This is a significant issue with QBO. I know i can get the bank by going into the bank rec function but that's a real pain.
Other ways I could get this balance was in Transaction Reports (versus repots like BS, P&L, and TB. The register balance only worked for bank accounts though. For AR & AP I had to use the Summary reports in the Transaction Currency.
There also isn't good documentation on how to run the Summary reports using the correct period end rate. In QB Desktop you simply did a HC adjustment. In QBO it appears you have to use the report that shows Unrealized Gains? I'm a CPA and find this confusing let alone your average user. By any chance is there a QB Desktop to QBO difference tutorial? Now THAT I could use. It would be nice to stop searching for things that just aren't there or have a quick refence to the new ways to do something you've done for 30 plus years in Desktop.
I do like some of the improvements to some major Desktop flaws in QBO but for the most part I hate using it. the only reason I do for clients where simple remote access is the priority.
Hope you can help with the foreign balance problem because so far I haven't found a solution except to export the entire account detail and create my own Foreign Balance column.
Marnee
Hi MarneeF,
Thanks for joining us here. Although the Balance sheet shows amounts in your home currency, you can run the Balance Sheet Detail report to see amounts based on the account currency. Here's how;
1. Open Reports from the left menu
2. In the Search field, enter Balance Sheet Detail
3. Click the small Gear ⚙ in the top right of the report and then Show more
4. Select the Currency and Foreign amount checkboxes
5. Hit Run Report.
Please feel free to let us know if this has been solved. Your success is our number one priority and we're always glad to help!
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