Quickbooks Desktop reports not tallying with quickbooks online

Thanks for coming by, @keshav7795.

I'll share some information about reports that have different currencies. Since transactions with multi-currencies won't convert to QuickBooks Online, you'll want to manually set up the rate. This way, your report will balance.

Here's how to do it:

1. Go to Gear.
2. Choose All lists.
3. Select Currencies.
4. Locate the currency and then Edit currency exchange the currency. You can also tick the Add currency to create a new one.
5. Click Save.

Once you're done, go back to the report and check for the transaction in question to manually enter the rate.

I'm attaching these links below to help you manage reports and multi-currencies.

• What to expect when you switch from QuickBooks Desktop to QuickBooks Online.

• Learn about Multicurrency in QuickBooks Online.

• Setting up reports to customise, run, and share.

Please let me know if you still have questions or concerns with the reports. I'll be around to assist you. Take care and have a good one.

Hi Shiella

Thanks so much for you prompt response and it's helping a lot.

I've adjusted the rates for every financial year and as per below exchange difference, this is the difference between my QB desktop and QB online TB. Unfortunately, when I try to revalue and save to clear this exchange difference, it does not action anything and stays the same per below image. Grateful if you could advise on how to clear this.

Thanks a lot

Keshav  

Hi there, keshav7795.

Glad to hear from you again. I hope all is well on your end. QuickBooks offers a versatile multi-currency feature which saves you from manual calculations and conversions. I'd be be glad to share more info on this so you can get back to doing what you love.  

With the help of this feature, user can translate the foreign transactions in home currency and calculate gain or loss due to difference between exchange rates of foreign currency and home currency. As this option will revalue all existing transactions as per exchange rate used, the accountant should be consulted before using this feature.

Note: Home currency adjustments do not affect foreign balance amounts.  They only change the home equivalent of a foreign balance.

To perform a home currency adjustment: 

1. Click the Gear icon.
2. Choose Currencies.
3. Look for the currency you'd like to change.
4. Under the Action column, click the Edit currency exchange link.
5. Select Revalue Currency.
6. Choose a date (today or a day in the past) to run a currency revaluation.
7. Tap whether you'd like the revaluation to be based on the market exchange rate or a rate you specify.
8. Hit the account(s) you want to apply the revaluation to.
9. Press Revalue. 

Let me share these articles with you about home currency adjustments:

• Enter home currency adjustments for your foreign balances
• Frequently Asked Questions about Home Currency Adjustments  
• Learn about exchange rates in QuickBooks Online 

In case you have other questions, feel free to contact our support team using this link here. Otherwise, leave a comment below. I'll be one message away. Stay safe!

Hi AileneA

Thank you for your reply.

I've tried doing the mentioned steps but unfortunately QuickBooks online remains unresponsive when I hit the revalue and save button per the below image.

Grateful if you could advise.

Hello keshav7795, From the screenshot the revalue date you are doing is in 2016 is that correct? Is there a large number of transactions to revalue?

Hi Emma

Yes - I'm trying to revalue for 2016 as my TB for 2016 on Quickbooks online is not tallying with my TB on Quickbooks desktop. I'm proceeding with revaluation with every financial years to tally them with QB desktop before I start using online.

Thanks 

Thanks for that. Can we get you to check if you have a close the books date set as the revalue will not go through if the close the books is on. Can you go to the cog in the top right>account and settings>advanced>accounting>close the books>remove the date temporarily( you can always add it back)save and close.

Hi Emma

Thanks for your response.

Yes, the mentioned settings was off. Please see below.

Hello Keshav7795, we can't see any reason why this would be unresponsive, can we ask you to clear the cache and cookies in your browser selecting all-time in the date range, if you still can not revalue if you can give our care team a call on 08082345337 and they will do a screen share and take a look at your account( we're not able to set one up through this public page)

Hi

Thanks for your response, could you please let me know the country code of the number provided.

I'll be contacting your office from Zambia - I hope that I'm following the proper channel

Regards

Keshav

Hello  keshav7795, You are in the UK Community can we just check that you had a UK version desktop and you are using the UK version of QB Online? The country code is +44 

Hi Emma

Affirmative - I'm using UK verision. Unfortunately i cannot reach the provided number.

Could you please escalate my request to the customer care centre. My contacts are per below;

Phone: +260770762205

Email: [email address removed]

Hello Keshav, This is a public forum so your email has been redacted. Can you contact us on Facebook or Twitter under Quickbooks UK either PM/DM with your email and we'll take that from there and escalate the revalue issue further with our senior team? Thanks

@keshav7795 

If the Support is not able to resolve your issue, I would recommend to migrate your data from QBD UK to QBO Global version for Zambia, if your company is located in Zambia. You may purchase a 3rd party conversion service.

https://quickbooks.grsm.io/Africa