cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
CCbooks
Level 1

How to view account balances in foreign currency and not in home currency

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?

5 Comments 5
JamesM
QuickBooks Team

How to view account balances in foreign currency and not in home currency

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. 

All about Bookkeeping
Level 2

How to view account balances in foreign currency and not in home currency

JamesM thank you for your quick reply.  I'm using QBDesktop and not Online.  Is this the same for Desktop?

JamesM
QuickBooks Team

How to view account balances in foreign currency and not in home currency

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. 

MarneeF
Level 1

How to view account balances in foreign currency and not in home currency

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

Trish_T
QuickBooks Team

How to view account balances in foreign currency and not in home currency

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!

Need to get in touch?

Contact us