iif import gst code not showing

  • 1
  • Problem
  • Updated 3 months ago
I am trying to import a credit card transaction into Reckon Accounts Enterprise 2018.

The iif file import all worked except it didn't bring over the GST codes.  this is the import template I used.  I first tried to have the SPL line as nett of GST but that didn't import saying the transaction was out of balance.



when I imported this file it looks like this:



Am I missing something??

Thanks in advance.
Photo of Felicity Van

Felicity Van

  • 1,076 Points 1k badge 2x thumb

Posted 3 months ago

  • 1
Photo of Linda Putland

Linda Putland, Accredited Partner

  • 6,284 Points 5k badge 2x thumb
Hi Felicity - drop the Tax Item... stick with TAXCODE TAXAMOUNT  columns only - then in the above example - the SPL line under AMOUNT - should be 99.09?  The import will be out of balance if the total of the AMOUNT cells plus the total of the TAXAMOUNT cells is not exactly 0.00
Photo of Felicity Van

Felicity Van

  • 1,076 Points 1k badge 2x thumb
Hi Linda,

that didn't work.  looks exactly the same as per my above pics.

Also, any transactions that were split between classes or GST codes will not import at all.
Photo of Linda Putland

Linda Putland, Accredited Partner

  • 6,284 Points 5k badge 2x thumb
OK - add a SPL line for TAXAMOUNT and try again - the Reckon Point of Sale iif files include this amount too?
Photo of Felicity Van

Felicity Van

  • 1,076 Points 1k badge 2x thumb
thanks Linda, I've fixed the issue.  I had TAX CODE, not TAXCODE

That's all that was needed.