cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Everything you need to know about banking in QuickBooks Online - Discover more
David Pearce
Level 1

Re: IIF Importing lack of support and information

Hi,

Thanks for your reply.

 

I've looked at the reference material and it appears to be US relevant rather than UK. I've tried importing the documents in the manner that it suggest and it won't work and as you know the error messages are mostly meaningless so I have reverted to randomly trying different data formats to import. The main issue still resolves around VAT as follows:

 

1) The VAT fields don't appear to exist in the IIF file format any longer;

2) The IIF process will default all SPL lines to the default tax code for the supplier which is not correct in the UK as we have several VAT rates that could be used by the same supplier;

3) The only way I could get an IIF Bill to import is to upload an out of balance Bill (Total Value and SPL value(s) without a balancing line which would be a bit of a challenge if there were a genuine out of balance occurring in an IIF file as almost all Bills wouldn't balance. In relation to this I also found that:

a) QuickBooks is calculating the VAT based on the default VAT rate for the supplier on all lines even if they are not marked as TAXABLE in the IIF file and changing the total value of the Bill during the import process;

b) The VAT amount calculated is often calculated £0.01 different to the amount that appears on the supplier invoice which is also a problem when we are importing thousands of invoices a month.

 

Please advise.

 

Thanks

David

 

 

 

 

3 REPLIES 3
Anonymous
Not applicable

Re: IIF Importing lack of support and information

RE: I've looked at the reference material and it appears to be US relevant rather than UK.

 

That's correct.

 

RE: The VAT fields don't appear to exist in the IIF file format any longer;

 

Yes.  Unfortunately you can no longer specify VAT the way you used to.  For some reason Intuit changed this almost a decade ago.  You can specify tax-ability for each line item, and the total tax, and then QB will auto-select the default VAT code for the taxable and non taxable lines.  It's rather inflexible and weak compared to the prior solution.

 

RE: The IIF process will default all SPL lines to the default tax code for the supplier which is not correct in the UK as we have several VAT rates that could be used by the same supplier;

 

Yes, that's how it works.  No way to make it any smarter anymore (it sucks, basically, and we've heard as much from many of our customers after they upgraded.)

 

RE: The only way I could get an IIF Bill to import is to upload an out of balance Bill (Total Value and SPL value(s) without a balancing line which would be a bit of a challenge if there were a genuine out of balance occurring in an IIF file as almost all Bills wouldn't balance.

 

You're getting it...  The definition of "in balance" is quite odd in these cases.  I forget the details, but it looks like you have it.

 

David Pearce
Level 1

Re: IIF Importing lack of support and information

HI,

 

I'm confused.

 

Does Intuit not provide proper support for their product in the UK?

Are there no user groups that have some influence with them or are they just merrily doing what they  want and ignoring their customer base?

Or is it just the UK that they ignore?

If many customer's had complained how did Intuit respond?

 

This is a real mess. It's shocking that Intuit don't provide a reliable, documented and supported method of interfacing data into their accounts product. 

 

Does anyone from Intuit ever respond to anything on the Community pages?

 

Thanks

David

 

 

 

EmmaM
QuickBooks Team

Re: IIF Importing lack of support and information

Hello David

 

Thanks for reaching out to the Community.

 

We do offer support to our customers either via the help page here in the Community or at our UK based desktop support telephone line on 08081689535.

 

As it states on the article regarding import or export of IIF. Intuit does not offer assisted technical support for creating or importing IIF files, there are resources to help in the article.I understand the article is US based however it is something which is the same in the UK product.

 

We can reach out to the creators of the Community web pages to ask for a specific UK IIF article to be added

 

Emma

 

Need to get in touch?

Contact us