Skip to main content
P
Paul2017
August 27, 2021
Question

IIF tool to generate iif file with GST Input Tax Credit

  • August 27, 2021
  • 1 reply
  • 0 views

Hi,

I am using Quickbooks Desktop.

I am looking for any tool (3rd party tool) that can generate General Journal IIF files (from an excel file) with GST Input tax credit.

I have been looking for ways to handle GST Input tax credit in journal entries for a few years, but have not been able to find a solution.

Please let me know if there is such a tool.

Thanks

Paul

 

1 reply

Fiat Lux - ASIA
Fiat Lux - ASIA
August 27, 2021

Explore these importer tools. You can import data from XLS format and you don't need converting it to IIF.

https://transactionpro.grsm.io/qbd

https://partners.saasant.com/affiliate/idevaffiliate.php?id=5051_2

 

P
Paul2017Author
August 27, 2021

I looked at those and other tools, but none appears to support "HST/GST Input Tax Credit (ITC)".

 

I have talked to Quickbooks support and currently, there is no way to specify "TAX ITEM" in the IIF file for the general journal entries.  I doubt any of the tools will do what I am looking for.

 

Please let me know if anyone personally experienced a tool that supports ITC.

thanks

Fiat Lux - ASIA
Fiat Lux - ASIA
August 27, 2021

There is no tax field available on JE. As of 2008, Intuit dropped support for setting Tax1Total and Tax2Total via the QBSDK. As a workaround, you may utilize the Sales Tax Code (set to a valid tax or VAT code) on each line in Invoice template prior to importing it into QQBD. You should ask this workaround with Support team of the apps I mentioned earlier.

Terms & ConditionsAccessibility statement