Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
A
abbywwg
December 27, 2018
Question

Foreign Exchange amount on reports

  • December 27, 2018
  • 1 reply
  • 5 views

Does anyone know how to get our foreign exchange amounts onto the report?  Our business is in MXN (Mexican pesos) but we report to US clients who want to see the values in dollars.  We have a foreign currency assigned (USD$) but only pesos shows up in the foreign currency columns.  I called support and they agent wasn't sure.  All he could find out is "that part doesn't work yet."  Anyone have any other useful suggestions?

1 reply

A
AldrinS
Level 4
December 27, 2018

Hi there, abbywwg.

 

You've come to the right place. I have a suggestion on this matter that I'm sure you'll find helpful.

 

I appreciate the screenshot you provided. Just to clarify, have you set your clients to pay with the correct currency (USD)? If you have,  the foreign exchange amount will show up on the report.

 

Now, we just need to customize the General Ledger report correctly to make sure that this will appear. Let me help you with that:

  1. Click Reports in the left navigation menu.
  2. Search for the General Ledger report and select it.
  3. Click the Customize button.
  4. Expand the Rows/Columns menu.
  5. Select Change columns.
  6. Scroll down and check the following options:
    - Foreign Amount
    - Currency
  7. Hit Run report.

All of this information and more is also available in our guide on how to customize reports. I've also included a few screenshots below to guide you with the steps and to show you how the report will look like.

 Foreign Amount.PNG

 

 Foreign Amount 2.PNG

Foreign Amount 3.PNG

Foreign Amount 4.PNG

That should do it! I'm confident that with these resources, you'll be able to get your foreign exchange amounts onto the report like a pro in no time.

 

I always got your back. Don't hesitate to reach out to me here in the Community with any additional questions or concerns you may have. Thanks for dropping in, wishing you and your business only the best.

A
abbywwgAuthor
December 27, 2018

All of our expenses are in pesos so we pay our vendors in pesos.  consequently I don't know how the "set your clients to pay you with the correct currency (USD)" would work.  I enter all of our expenses in MXN$.

 

I figured out to add the columns, as was shown in my screen shot, but the amounts int he columns are still MXN$.

C
Charies_M
Level 9
December 27, 2018

Thanks for getting back, abbywwg.

 

At the moment, the default currency when running General Ledger reports will be your company's home currency. This is why the amounts on your General Ledger report are still showing MXN$.

 

If you wish to have this feature included in the next update, I encourage you sending this great suggestion to our product developers the the feedback feature in QBO. I'll do the same thing on my end.

Here's how:

  1. Click on the Gear icon.
  2. Click Feedback.
  3. Type in your feedback or feature request.
  4. Click Send Message.

If there’s something else you need to find, please don’t hesitate to let me know. I’m always available here for all of your QuickBooks questions. I’ll keep an eye out for your reply.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.
Terms & ConditionsAccessibility statement