cancel
Showing results for 
Search instead for 
Did you mean: 
dvillamil
Level 2

Financial Reports in USD for Files with multi-currency activated

Hi, I need help :

 

I have a multi-currency company file with a home currency different than the US dollar (MXN - Mexican peso, for example). Only have transactions in a home currency and USD.
Daily, I manually set the exchange rate from USD to MXN, I want to get the financial reports in USD and also in the home currency. But I did not find how to get those reports in USD.

 

I appreciate if someone can help me.

 

 

14 Comments 14
MJoy_D
Moderator

Financial Reports in USD for Files with multi-currency activated

I can help you generate the report that you need, @dvillamil.

 

When generating the report that you need, you can filter or customize the report to display amounts in your home currency or the transaction currency.

 

Here’s how:

  1. Go to the Reports menu and generate the report that you need.
  2. Click on the Customize Report button.
  3. Go to the Display tab and proceed to the Display amounts section and set it either Home currency only or The transaction currency.
  4. Select OK once you’re done.

 

Here's the customize reports in QuickBooks Desktop article for more information. 

 

You can also refer to the following articles for more information about company and financial reports as well as customer, job, and sales reports in QuickBooks Desktop.

 

I'm always here if you need more help in generating the report that you need. Let me know by leaving a reply below. Take care and have a great rest of the day!

dvillamil
Level 2

Financial Reports in USD for Files with multi-currency activated

Thanks, @MJoy_D 

 

However, this option does not appear on the balance sheet or profit and loss reports.

I specifically need those two reports in USD, independently of the home currency, using the exchange rate that is entered daily.

 

We have several companies and need to consolidate the financial statements in a single currency.

Angelyn_T
QuickBooks Team

Financial Reports in USD for Files with multi-currency activated

Thank you for getting back, @dvillamil.

 

With the Profit and Loss and Balance Sheet reports, you can add the Amount (home currency) and Foreign Amount (transaction currency) columns to get the information you need. I can guide you with the process.

 

  1. From the report's page, go to the Customize Report tab.
  2. Click on Display.
  3. Add the Foreign AmountAmount, and other columns you want to display on the report.
  4. Hit OK.

 

Once done, you can now see both currencies from the report's page.

 

Here's an article you can read more about running and customizing reports in QuickBooks Desktop.

 

Aside from your reports, you can also open the topics from our help articles for more resources while working with QuickBooks in the future.

 

If you have any other questions about the multi-currency transactions, notify me by adding a comment below. I'm more than happy to help. Keep safe!

dvillamil
Level 2

Financial Reports in USD for Files with multi-currency activated

Thanks, but it doesn't satisfy my need.

I contacted Quickbooks online support and their response was:

"For now, you can only pull up the Profit and Loss report in your home currecy."

In short, what I need can not be.

ZackE
Moderator

Financial Reports in USD for Files with multi-currency activated

Thanks for following up with the Community, dvillamil.
 

I can certainly understand how an ability to generate a Profit and Loss report in different currencies could be useful and have submitted a suggestion about it as of today.
 

You can also submit your own feature requests while using QuickBooks Online (QBO).
 

Here's how:

  1. Use the Gear (⚙️) icon, then go to Feedback and enter any suggestions/comments.
  2. Hit Next to submit your message.


If you're working with QuickBooks Desktop (QBDT), the steps are a bit different:

  1. In your top menu bar, go to Help, Send Feedback Online, then Product Suggestion....
  2. Choose a Type of Feedback and Product Area (optional) from the available drop-down menus.
  3. Enter any suggestions/feedback in your Here is my suggestion: field.
  4. If you'd like, include your name/email in the My name is: (optional) and My e-mail address is: (optional) fields.
  5. Select Send Feedback.


Your feedback's definitely valuable to Intuit. It will be reviewed by our Product Development team and considered in future updates. Feature requests for QBO can be tracked through our Customer Feedback website. To stay up-to-date with Intuit's latest news about QBDT, you can review the QuickBooks Blog.

 

If there's anything else I can help with, please feel more than welcome to reach out anytime. Have a great day!

dvillamil
Level 2

Financial Reports in USD for Files with multi-currency activated

Thanks @ZackE 

 

I sent the suggestion.

ielayo
Level 1

Financial Reports in USD for Files with multi-currency activated

Hello,

This is helpful, but I can not find the transaction amount on my display tab after generating the report.

 

AlcaeusF
Moderator

Financial Reports in USD for Files with multi-currency activated

Hello @ielayo,

 

I appreciate you for getting back to us about the report you need. Allow me to chime in and provide clarification about the reports in QuickBooks.

 

I know how beneficial being able to generate reports the way you want them in QuickBooks. However, this option is unavailable when running the two reports (Profit & Loss and Balance Sheet).

 

For now, the only workaround is the one provided by my colleague @Angelyn_T. Please know that I appreciate your input on this feature. We always update the features in QuickBooks Desktop, and this preference might be added in the future.

 

As we assess this, I suggest you visit the New Features section to stay updated with all the changes that are being made (see screenshot below).

 

Also, I've attached an article you can use to learn more about the summary reports you can run that display amounts in your home currency (the default) or foreign amounts: Customize company and financial reports.

 

Drop me a comment below if you have any other questions about running reports. I'll be more than happy to help. Wishing you a good one.

Fiat Lux - ASIA
Level 15

Financial Reports in USD for Files with multi-currency activated

@dvillamil 

You may explore a 3rd party analytical app for the time being.

0093773017628
Level 1

Financial Reports in USD for Files with multi-currency activated

Greeting to QB team

 i want to generate the FR in two currency, since u have screened the above guide but in my QB there is no options.  i send u the screen shot as well which is in attach file please help that how generate the Finance report in two currency.

 

MJoy_D
Moderator

Financial Reports in USD for Files with multi-currency activated

Hello, @0093773017628.

 

Can you tell me more about the version of QuickBooks that you're using? That will surely help us provide an accurate solution to the concern that you're having.

 

You can click the Reply button below to add more details and the screenshot you're referring to. 

 

I'm looking forward to hearing from you soon! Take care, and have a wonderful day!

SK58
Level 1

Financial Reports in USD for Files with multi-currency activated

Hello,

 

My home currency is USD, but I wanted to run the Budget vs. Actuals Report in KES (Kenya Shillings).

How do I go about that using Online QuickBooks Plus?

 

 

Warm Regards,

Solomon

4Gal
Level 10

Financial Reports in USD for Files with multi-currency activated

@SK58 

You can only run reports in your home currency. Consider having a BI application as the workaround.

CharleneMaeF
QuickBooks Team

Financial Reports in USD for Files with multi-currency activated

Thanks for reaching out to us, Solomon.

 

I understand the importance of running a Budget vs. Actuals report in a Kenya Shilling (KES) currency. At this time, we can only run the report using your home currency (USD).

 

In the meantime, you'll want to consider utilizing a third-party application that'll give you an overview to help compare your actual income and expenses with your budget in KES. I suggest browsing our QuickBooks App Store page to look for the app that suits your needs. Alternatively, you can also use the Apps menu. Here's how:

 

  1. Go to the Apps.
  2. Select Find apps.
  3. In the Search tab, type in the keyword of an app.
  4. Once you find one, click Get app now.
    Capture.PNG

 

Please know that your ideas and suggestions will help us determine what features our customers need the most. To help improve your experience, I'd recommend sending feedback to our Product Development Team. Here's how:

 

  1. Go to the Gear icon, then Feedback.
  2. Enter your product suggestions.
  3. Once done, hit Next
    Capture.PNG

 

Keep me posted if you have any other concerns or further questions. I'll always have your back.

Need to get in touch?

Contact us