Recalculate VAT in bulk

Hello Arthur Gotz, 

Welcome to the Community page, 

There unfortunately is not, with iif files not supported on Quickbooks Desktop there is nothing we can do you would need to update each one individually to correct it and there will be no further updates to correct this due to the imminent discontinuation of the Desktop Product,. 

Oh dear. I hope you realize that discontinuing the desktop version will cost you customers. I tried the online version, even had a subscription for a few months, but abandoned it and bought the desktop version. The online version is way too slow, cumbersome, inflexible, in short and in English, it sucks. It's built on the premise that a stable, fast Internet connection is available anywhere in the world, and this simply isn't so.

Anyway, this issue is bigger than you or me, and I thank you for the fast reply.

As a workaround: Would it work to export the transactions in Excel format, import them in Online (I suppose this would fix the error), export it in any legacy format from Online, import back into desktop? Cumbersome, but still faster than the alternative?

Hello Arthur, thanks for sharing this feedback, we have passed this on to the relevant team.  In regards to your workaround. So you import into online, but not sure how that would fix you getting the data to Desktop as there is no way to get the data from Online to desktop and you can't import data into Desktop via Excel.

Hi @Arthur Götz 

It's been a while since I used QB Desktop but I seem to remember that VAT was always a problem when importing IIF files - certainly after 2007-8 or whenever the VAT Handling method was changed in the codebase.

IIF is an Intuit format so you'd be forgiven for thinking that it would work with an Intuit product!

However, it was considered to be old & creaky and the new kids didn't want to play any more.

Sorry - I digress.

Your best bet will probably be a third-party link that will update the QBD datafile directly.

Take a look at https://www.zed-systems.com/axis-import.html or https://www.transactionpro.com/importer-for-desktop/

Hope this helps.

No, if Online and Desktop cannot talk directly to each other, this wouldn't help either.

Hi @paul72 

Yes there are a few ways to fix this with Zed Axis.

1. Axis can read IIF files and convert them into qbXML which it imports directly into QuickBooks desktop or Online, when importing this way it will import the VAT code and whether the amounts include or exclude VAT, when it send that to QuickBooks it calculates the VAT correctly.
2. If you want to "fix" transactions in QuickBooks desktop or online that have incorrect tax amounts on them then Axis can export those out to Excel where you can fix them and then reimport back in and modify the existing transaction.

I hope that gives a bit more detail and explanation to your answer about how Axis can help in this scenario. :)