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

Jessica_9945427
Jessica_9945427 Member Posts: 4
edited June 2020 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 ABC
    Linda ABC Accredited Partner Posts: 1,131 Accredited Partner Accredited Partner
    edited June 2020
    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?
  • Jessica_9945427
    Jessica_9945427 Member Posts: 4
    edited February 2019
    Hi Linda, thanks for your reply. Please see screen shots below. First one is December 
  • Jessica_9945427
    Jessica_9945427 Member Posts: 4
    edited February 2019
    This one i January. 
  • Linda ABC
    Linda ABC Accredited Partner Posts: 1,131 Accredited Partner Accredited Partner
    edited June 2020
    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 Boast
    Graham Boast Accredited Partner Posts: 331 Accredited Partner Accredited Partner
    edited June 2020
    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

    Graham Boast | 0409 317366 | graham@reckonhelp.com.au

  • Jessica_9945427
    Jessica_9945427 Member Posts: 4
    edited February 2019
    Thanks very much Graham, i have created the new account and it worked. 
    Thank you 
  • Linda ABC
    Linda ABC Accredited Partner Posts: 1,131 Accredited Partner Accredited Partner
    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! :)