iif import gst code not showing

Felicity Van
Felicity Van Member Posts: 64
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:

image

Am I missing something??

Thanks in advance.

Comments

  • Linda ABC
    Linda ABC Accredited Partner Posts: 1,131 Accredited Partner Accredited Partner
    edited June 2020
    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
  • Felicity Van
    Felicity Van Member Posts: 64
    edited October 2018
    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.
  • Linda ABC
    Linda ABC Accredited Partner Posts: 1,131 Accredited Partner Accredited Partner
    edited June 2020
    OK - add a SPL line for TAXAMOUNT and try again - the Reckon Point of Sale iif files include this amount too?
  • Felicity Van
    Felicity Van Member Posts: 64
    edited August 2018
    thanks Linda, I've fixed the issue.  I had TAX CODE, not TAXCODE

    That's all that was needed.