We do bookkeeping for some of our clients using QuickBooks Premier Accountant Edition. Other clients do their bookkeeping in QuickBooks and bring us an Accountant's Copy. In doing the compilation of the financial statements, we use the CaseWare QuickBooks Export Utility to export the GL from QuickBooks into a format that CaseWare Working Papers can import. At the end of the process, we export from CaseWare the adjusting entries created in CaseWare. CaseWare creates an IIF file that typically needs a bit of tweaking which isn't a problem using Excel. However, there are two issues with the file that I cannot seem to find an answer to.
Being year-end adjusting entries, I would like these general journal entries to be flagged in QuickBooks as adjusting entries as shown circled in purple on the attached screen capture. Is there a field in the IIF spec for general journal entries that allows setting this field in QuickBooks?
The other issue is that when there is an adjustment to GST/HST Payable, a tax item has to be provided. Is there a field for that in the IIF spec for general journal entries?
Presently, I am handling both these issues by making the corrections after the entries have been imported into QuickBooks, but it would be faster if it was something that could be corrected in the IIF file where I do not have to spend time searching for the entry.
