Skip to main content
May 27, 2022
Question

My EUR Bank balance is ZERO as on 31-Mar 2022. But my USD equivalent for the EUR bank acct is showing USD 5952.06. Kindly advise on how to make the USD balance ZERO.

  • May 27, 2022
  • 1 reply
  • 0 views
Original commenter did not share additional details

1 reply

May 27, 2022

Let me help you sort this out, @ankur1306.

 

What report are you looking at to see the USD (home currency) equivalent of your EUR account?

 

You'll want to be sure the report covers the date range of the transactions in your EUR account so you'll get the correct equivalence.

 

You can also see this article for more details about customising reports in QBO: Customise reports in QuickBooks Online.

 

I'm also attaching this link that you can read for guidance. This contains details on how to print and export your reports: Run reports in QuickBooks Online.

 

If there's anything else you need help with, please feel free to leave a response. I'd be delighted to help you out anytime. Keep safe and stay healthy!

 

 

ankur1306Author
May 27, 2022

I am looking at the General Ledger where in the USD balance is showing despite the EUR bank being ZERO (already reconciled).

To make it even worse, its even showing on the Trail Balance and the Balance sheet where it should show ZERO.

RenjolynC
May 27, 2022

Thanks for getting back to us, ankur1306.

 

Let me add some additional information about the currency. But before that, I'd like to verify, what is your current home currency? If you want to zero out the balances for the USD currency, you have the option to make adjustments. 

 

When you make adjustments on your home currency, this changes the home currency value of your foreign balances, and will recalculate them based on a new rate. These adjustments affect your balance sheet accounts. Before doing the adjustment, it's always a good idea to consult with your accountant to ensure your books accuracy. If you're not affiliated with one, you can visit our Intuit Find-A-ProAdvisor site to find certified professionals near you. 

 

To create the adjustment, here's how:

 

  1. Go to the Gear > Currencies.
  2. Find the currency you want to adjust.
  3. Under the Actions column, click the small drop-down arrow and select Revalue Currency.
  4. Choose a date (today or a day in the past) to run a currency revaluation.
  5. Select whether you'd like the revaluation to be based on the market exchange rate or a rate you specify.
  6. Choose the account(s) you want to apply the revaluation to.
  7. Click Revalue.

 

For more details about the adjustment process, you can check out these articles:

 

 

Please let me know if you have any additional questions or need help with other features in your QuickBooks account. We're always available to help you out.