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

JessicaJessica Member Posts: 4
edited June 30 in Accounts Hosted
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?

Comments

  • Linda ABCLinda ABC Member Posts: 1,171 ✭✭
    edited June 30
    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?
  • JessicaJessica Member Posts: 4
    edited February 2019
    Hi Linda, thanks for your reply. Please see screen shots below. First one is December 
  • JessicaJessica Member Posts: 4
    edited February 2019
    This one i January. 
  • Linda ABCLinda ABC Member Posts: 1,171 ✭✭
    edited June 30
    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?
  • Graham BoastGraham Boast Accredited Partner Posts: 406 ✭✭
    edited June 30
    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 [email protected]
  • JessicaJessica Member Posts: 4
    edited February 2019
    Thanks very much Graham, i have created the new account and it worked. 
    Thank you 
  • Linda ABCLinda ABC Member Posts: 1,171 ✭✭
    edited February 2019
    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! :)
Sign In or Register to comment.