In QuickBooks Online, how do I run report in a currency that is Not by home currency? Really need this.

Hello, Dave. 

I'm happy to provide details about how you can run a report in a currency. 

You can pull up the Transactions Detail by Account report, then enable the Currency column. We're unable to filter it to remove the transactions that are using the home currency.

Though, we can use the Customers filter and remove those customers with the home currency. If you'd like to include your vendors, you can also use the Vendors filter. 

I'll elaborate the steps below: 

1. Go to Reports, then search for Transactions Detail by Account in the Search box. Click the result.
2. Click the Customize button.
3. Expand the Rows/Columns section, then click the Change columns link.
4. Check Currency.
5. Go to the Filters section.
6. Check either the Vendors or Customers (you can do both). Then, select the profiles you want to show the report (that aren't using the home currency). 
7. Once done, click Run report.

This isn't limited to the Transactions Detail by Account report. You can pull up something similar like the Transaction List by Customer or Vendor. 

You'll also want to memorize this report if you want to run the same settings in the future. Check this article for a guide: Memorize reports in QuickBooks Online. 

Do you have other reports you need to run? Let me know the data you want to show and I'll help in anyway I can. If you also have other concerns, let's hear them out. 

Thanks Jamespaul. That's kind of helpful. My use case is that I have a parent company in the US with two subsidiaries in other countries with their own local currency. I'm using location to indicate in which subsidiary the transaction took place. I need to run sales reports, and financial statements in the local currency.  In the Sales by Product/Service Detail report for example, I can add the currency column which tells me the currency the sales took place in, but the Amount is still showing in the home currency. 

For something like the P&L, I can filter the report by location, but there is no option to run it in any currency but the home currency. 

Would be great to know how I might handle this or is it best to have 3 separate QB accounts? In yes, how do I handle consolidation?

Thanks!

Thanks for the quick response, dave183.

The Transactions Detail by Account report will show all the transactions with currency. If it's not showing on your side, you'll want to review the transactions to make sure it has the correct currency used. To do this, run the report again using the steps previously shared above and manually clicking the amount of each transaction.

If it's using an incorrect currency, change it from there. This is how your report will look like when currencies are shown.

I have some additional articles about managing a wide range of reports in QBO:

• Run reports in QuickBooks Online
• Memorize reports in QuickBooks Online
• Customize reports in QuickBooks Online.

As always, feel free to leave a comment below if you have any other concerns while working with reports. We're always here to help you. 

I still can't run an A/P vendor summary report filtered by currency.  I don't need all the details, just a summary of our USD vendors to whom we owe money.

Hi there, @casagrande. Thanks for joining the thread. I'd be happy to share more details about the report you can use when looking for a summary of payments you've owed in QuickBooks Online. 

Currently, getting a summary report about Accounts Payable filtered by a currency is unavailable. However, you can run A/P Aging Detail Report. Then, modify the report with its total amount owed per vendor using an Excel app.

Here's how:

1. Go to the Reports menu and look for A/P Aging Detail Report.
2. Customize it and go to the Rows/Column section.
3. Tick the box beside Currency.
4. Choose the 
5. Select Run Report.

Once done, you can export the report by clicking on the Export icon at the upper-right part of the report header. Then, open the file and add the total amount per vendor to get the summary of the payables per vendor.

I've included an article for more details about being effective with modifying your report: Run reports in QuickBooks Online.

Don't hesitate to let me know if you have any additional questions about the report or other concerns. I'm always around to lend a hand. Take care! 

That's rather onerous.  One would think a company the size of QB would be able to product the report I need without making me go through the extra steps.

In Pay liabilities check the currency suddenly change to my home country currency. I want in USD, so how to change back to USD?

Thanks for joining the thread, @daveada.

I'd love to help you achieve your goal, but would you mind telling me more about it? Like, for what transaction is your pay liability check for? Additional information is much appreciated.

I'd appreciate any details you can provide. I’m looking forward to your reply. Have a great rest of the day.

Good day,

I have multi currencies on but when running reports I do not have an option in the customization drop down to select currency. How would I be able to change my report into the currency I want to view it in?

Did anyone on the QB support team answer this question:

For something like the P&L, I can filter the report by location, but there is no option to run it in any currency but the home currency. 

I couldn't find a specific response and I need to know for my own purposes as well. Simply want to download financial reports (P&L) from home currency of NZ to AUD for consolidation into AUD parent co

I am on essential but I do not see the option to add a currency column. I see exchange rate column

Has the name been changed?

but amounts are still in home currency? how can we see both? 

Expenditure report by multiple currency