Profit and Loss Reporting Issue in Multi Currency

Thank you for the reply. 

We did test with a sample company data per your suggestion. The P&L displayed with the correct USD in multi currency mode on the sample testing. We then ran data verification on the our company data, but it found no problems. Should we uninstall and reinstall?

Hi Nagakambing,

There are some things that we need to consider when creating foreign-currency transactions. Let me share them with you so can get this resolved.

• You don't assign a currency to sales and purchase transactions because they are assigned the currency of the customer or vendor you entered on the form.
• Exchange rates are part of each transaction and determine the home currency value of the transaction.
• Amounts on sales and purchase transactions are in the customer's or vendor's currency and the home currency equivalent is listed for the transaction total.
• Reports will always reflect the home currency regardless of the currency used in transactions.

Before we start our troubleshooting, make sure you have transferred or deposited the customer payment correctly to your bank. This way, it'll post the correct amount in your reports.

1. Go to Banking.
2. Click Make Deposits.
3. Make sure to enter the correct exchange rate.
4. Click Save and Close.

If you've already verified the deposits and you're still getting the same results, you can continue performing reinstall using a super clean install of QuickBooks.

Once done, open your QuickBooks and check your report again.

I've got this article about reports and accounting for future reference.

Reach out to us anytime if you have other concerns. We're always here to help.

@Nagakambing ,

I am agreed to QuickBooks team. You have to run clean install to verify your problem. If the error still persists, call and ask Intuit Data Service to check your QBW file. Otherwise, you may purchase a 3rd party repair service.

Anyway, what is the home currency setup in your QuickBooks? USD or else (e.g IDR) ?

As mentioned in the original posting, the wired transfers or deposits were correctly adjusted. The home currency has been USD from the initial multi currency setup. 

So, we did the PITA uninstallation and performed the "clean install". We had to uninstall and reinstall the other PSA/CRM as well that synched with QuickBooks. 

We ran P&L and now it's correctly displaying the amount. 

Thanks for the help! 

My P&L is not converting Yen to USD.  I am having this issue in QB 2021 Desktop. I've check company file for errors - none were reported. I've completely removed QB and did a clean install, with no change. the P&L is still wrong. How to I fix this? I have to get this done for yearly financials.

Hi GTSI!

Thanks for reaching out to us. Allow me to assist you with the P&L.

It's great that you tried to check if there's damage on your company file and reinstalled QuickBooks Desktop. However, since you're still experiencing the same behavior, it's best to reach out to our Support Team so they can further investigate it and see what's causing this issue.

1. Go to Help, then select QuickBooks Desktop Help.
2. Select Contact Us.
3. Enter "Multi-Currency P&L", select Let's talk and then choose a way to connect.

I added some articles you can check to learn more on how to manage your foreign currency and how to customize financial reports:

• Set up and use Multicurrency

• Customize reports in QuickBooks Desktop

I'm only a post away if you have more questions. Have a great day!