iif import, coming through as a cheque not as a general journal. Reckon Hosted.

  • 1
  • Question
  • Updated 7 months ago
  • Answered
Hi I was hoping some one could help with importing iif files. Each month an external party sends data as in iif file and i upload the file into reckon and it matches up with my accounts. Every time i upload the file it will always appear as a general journal as that’s wat the trans type is in the iif. However all of a sudden when i import this months, its coming through as a cheque instead of a general journal. There is nothing different in the iif file for this month in comparison to previous months, so I’m guessing it might have to do with a setting in my accounts. I use Reckon hosted. Has anyone had this issue before?
Photo of Jessica

Jessica

  • 100 Points 100 badge 2x thumb

Posted 7 months ago

  • 1
Photo of Linda Putland

Linda Putland, Accredited Partner

  • 15,132 Points 10k badge 2x thumb
Hi Jessica - if you can post up a screen image of an iif that went in as a general journal and also the one that went in as a cheque I might be able to spot the reason?
Photo of Jessica

Jessica

  • 100 Points 100 badge 2x thumb
Hi Linda, thanks for your reply. Please see screen shots below. First one is December 
Photo of Jessica

Jessica

  • 100 Points 100 badge 2x thumb
This one i January. 
Photo of Linda Putland

Linda Putland, Accredited Partner

  • 15,132 Points 10k badge 2x thumb
ok - so when you say the January one has come through as a Cheque - can you open the write cheques screen - what is the bank account at the top of the cheque?  and can I see the last few lines of the January import file - does it also finish with undeposited funds and the suspense account?
Photo of Graham Boast

Graham Boast, Accredited Partner

  • 11,634 Points 10k badge 2x thumb
Hi Jessica and Linda

I suspect that 220 Other Income has not been setup, so Reckon has set this up as a Bank Account during the import process.

If you open the Chart of Accounts, you will probably find a new bank account Other Income with a balance of -1187.17. To fix

Double click on the Other Income Bank Account
Open the January transaction and delete it. This should empty the register of transactions.
Close the register, then delete the Other Income Bank Account
Set up a new 220 Other Income Account with the Account Type “ Other Income
Reimport the transaction.

Graham 0409317366
graham@reckonhelp.com.au
Photo of Linda Putland

Linda Putland, Accredited Partner

  • 15,132 Points 10k badge 2x thumb
Great pick up Graham!!!    I would have figured that out when I saw the screen shot of the Write cheque window, but good detective work/intuition that this was the problem! :)
Photo of Jessica

Jessica

  • 100 Points 100 badge 2x thumb
Thanks very much Graham, i have created the new account and it worked. 
Thank you