Skip to main content
J
jimczeb
November 9, 2021
Question

IIF import not findingthe account

  • November 9, 2021
  • 2 replies
  • 0 views

i am attempting to import an IIF file but i am getting an error saying that the account is invalid.  it is possibly a data formatting error but i can't find it.  find attached the IIF file i am attempting to import.

 

Also find a screen shot of the accounts i am attempting to import the deposit transaction into.

the iif file content is here.

;*** YOUR IIF FILE COULDN'T BE IMPORTED ***
;
!TRNS TRNSID TRNSTYPE DATE ACCNT NAME CLASS AMOUNT DOCNUM CLEAR
!SPL SPLID TRNSTYPE DATE ACCNT NAME CLASS AMOUNT DOCNUM MEMO
!ENDTRNS
; [ERROR] The Account does not exist in Quickbooks [11242]
TRNS 22 DEPOSIT 11/01/2021 Jims Bank Testing 400.00 N
SPL DEPOSIT 11/01/2021 Jim Test Sub1 -400
ENDTRNS

 

 

2 replies

R
Rea_M
November 9, 2021

I'm here to ensure you're able to remove the importing/banking error you've encountered in QuickBooks Desktop (QBDT), @jimczeb. This way, you can successfully import your IIF file and keep your account's deposit transactions updated.

 

Web Connect issues (i.e., importing transactions from the bank) can occur for several reasons. Sometimes, files from the bank are incomplete or incorrect format, and changes on their end would be the reason too.

 

To fix this error, I'd first recommend creating a backup of your company file. Then, make sure you're using a supported version of QBDT. Next, download your Web Connect (.qbo) file directly from your bank, not from inside QuickBooks. Then, open your company file and follow these importing steps below:

 

  1. From the Banking menu, select Bank Feeds, then Import Web Connect Files.
  2. Select the QBO file you saved, then select Open.
  3. When prompted to Select Bank Account, select the Use an existing QuickBooks account option since the account you're importing transactions into is already set up in QuickBooks.
  4. Select Continue, then OK.
  5. Go to the Bank Feeds Centre to review and/or categorise your transactions.

 

In case you still see the error, please continue troubleshooting starting with Step 2: Check the file from your bank in this article: Fix Web Connect import errors. It also includes an advanced troubleshooting guide to help resolve the issue.

 

Also, I'd recommend reconciling your accounts every month. This way, you can monitor your deposits/income and expenses and detect errors accordingly. For the step-by-step guide, you can refer to this article: Reconcile an account in QuickBooks Desktop.

 

Please keep me posted on how it goes in the comments below. If you have other banking or importing concerns with QBDT, and I'll gladly help. Take care, and I wish you continued success, @jimczeb.

J
jimczebAuthor
November 11, 2021

Thanks for the response.  Please let me give a clearer description of my issue.

1.  I am not attempting to import from a bank.  I am trying to do a simple test import.

2.  I have created a test IIF file with one deposit transaction.

3.  in quickbooks i have created a test bank and some test accounts for the deposit.

4.  The bank is named Jims Bank

5.   the deposit transaction is as follows

TRNS<tab>22<tab>DEPOSIT<tab>11/01/2021<tab>Jims Bank<tab><tab>50

SPL<tab>23<tab>DEPOSIT<tab>11/01/2021<tab>Jims Test Sub1<tab>-50

ENDTRANS

Note that Jims Test Sub1 is a sub-account if that makes any difference.

6.The error i am getting is

;The Account does not exist in Quickbooks [11242]

7.  If we enter a deposit into Quickbooks into Jims Bank manually it works fine.

 

Hope this clears up my question.

 

Jim Czebiniak

A
Ashleigh1
November 11, 2021

Hello Jimczeb, thanks for coming back to us here on this thread, IIF files aren't really supported despite them being intuit files at the bottom of this link it says. We would advise that you dont use that function as it has not been supported for a while now, if you have a look at the link on for more information if your still stuck i would advise you ring the support line on 0808 168 9535. 

Fiat Lux - ASIA
Fiat Lux - ASIA
November 10, 2021

@jimczeb 

Which QBD year version do you have?

Terms & ConditionsAccessibility statement