IIF transaction Imports - Amounts Include Tax Flag

  • 1
  • Question
  • Updated 1 month ago
  • Answered
Hi,
I'm looking at creating IIF files to import transactions to Recon Accounts. I can't find any information how to set the "Amounts Include Tax" flag in IIF (see the picture).
I am just an IT person with no understanding  Reckon or accounting. I was asked to find a way to automatically import transactions to Recon accounts to avoid manual work.
I know all column headings that I need to define in IIF except for the one that allows me  to set the "Amounts Include Tax" flag.

Does anyone know anything about it? Any help would be appreciated.
Masha

Photo of Masha

Masha

  • 180 Points 100 badge 2x thumb

Posted 1 month ago

  • 1
Photo of Kevin Russell

Kevin Russell, Accredited Partner

  • 35,304 Points 20k badge 2x thumb
Yes. Yes I do. Send me an email kevin@zappy.com.au
Photo of Masha

Masha

  • 180 Points 100 badge 2x thumb
Thank you very much Kevin!
Have you received my email? 
Photo of Kevin Russell

Kevin Russell, Accredited Partner

  • 35,304 Points 20k badge 2x thumb
Just sent that through
Photo of Masha

Masha

  • 180 Points 100 badge 2x thumb
Kevin, thank you so much for your help!!!  You are great!

I am sorry to bother you again, but do you know which particular column headings in IIF file are responsible for "Amounts Include Tax" flag?
May be this is a silly question because of my lack of knowledge in accounting.

This is my IIF file:


When I import IIF file I receive:


but I want to have this: 


Thank very much again
Masha
Photo of paul

paul

  • 150 Points 100 badge 2x thumb
If you set the Amount in the TRNS line to be inclusive of tax and then the AMOUNT in the SPL line to be exclusive of tax then add the tax amount in the TAXAMOUNT column of the SPL line, at least the amounts will balance correctly, so ticking and unticking "amounts include tax" will not try and re-balance things.
(Edited)