cancel
Showing results for 
Search instead for 
Did you mean: 
lrhmail451
Level 3

bank file import

PREMIER MANUFACTURING AND WHOLESALE EDITION 2019

 

 

need help post file from bank

why is it questing my vendors that i have in QB  already 

 

i put them in the file so it would not create new vendors by the bank name that was given by the bank

 

i think i have an idea on the ones for deposit but still i want some input incase i am wrong

 

;-----------------------------------------------------------------------------       
;        
;*** YOUR IIF FILE COULDN'T BE IMPORTED ***          
;        
;Some of your records have errors.       
;        
;1. Search for the errors by typing "[ERROR]" to see only the failed records.      
;        
;2. Fix the errors and try to import the file again       
;        
;-----------------------------------------------------------------------------       
;        
;        
!TRNSDATETRNSTYPEACCNTNAMEAMOUNTDOCNUMMEMOCLEAR
!SPLDATETRNSTYPEACCNTNAMEAMOUNTDOCNUMMEMOCLEAR
!ENDTRNS        
; [ERROR] The record at (or starting at) this line could not be imported. There is an invalid reference to QuickBooks Account "45000" in the Deposit.  QuickBooks error message: The specified account is invalid or of the wrong type. [3140]   
TRNS1/7/2020DEPOSIT45000Alpha Visions Learning Academy, Inc.A248ETFRegular Deposit 
SPL1/7/2020DEPOSIT10000Alpha Visions Learning Academy, Inc.A-248ETFRegular Deposit 
ENDTRNS        
; [ERROR] [Larry Williamson] There is already another entity in Quickbooks by this Name [10143]       
;[Larry Williamson] Invalid Customer Name on the distribution line [11114]       
TRNS1/7/2020CHECK67200Larry Williamson-307.33693Check    3693 
SPL1/7/2020CHECK10000Larry Williamson307.33693Check    3693 
ENDTRNS        
; [ERROR] The record at (or starting at) this line could not be imported. There is an invalid reference to QuickBooks Account "45000" in the Deposit.  QuickBooks error message: The specified account is invalid or of the wrong type. [3140]   
TRNS1/9/2020DEPOSIT45000Alpha Visions Learning Academy, Inc.A2000ETFRegular Deposit 
SPL1/9/2020DEPOSIT10000Alpha Visions Learning Academy, Inc.A-2000ETFRegular Deposit 
ENDTRNS        
; [ERROR] The record at (or starting at) this line could not be imported. There is an invalid reference to QuickBooks Account "45000" in the Deposit.  QuickBooks error message: The specified account is invalid or of the wrong type. [3140]   
TRNS1/9/2020DEPOSIT45000Alpha Visions Learning Academy, Inc.A9000ETFRegular Deposit 
SPL1/9/2020DEPOSIT10000Alpha Visions Learning Academy, Inc.A-9000ETFRegular Deposit 
ENDTRNS        
; [ERROR] [Jacob Ferrell] There is already another entity in Quickbooks by this Name [10143]       
;[Jacob Ferrell] Invalid Customer Name on the distribution line [11114]       
TRNS1/9/2020CHECK67200Jacob Ferrell-1203694Check    3694 
SPL1/9/2020CHECK10000Jacob Ferrell1203694Check    3694 
ENDTRNS        
; [ERROR] The record at (or starting at) this line could not be imported. There is an invalid reference to QuickBooks Account "69100" in the Deposit.  QuickBooks error message: The specified account is invalid or of the wrong type. [3140]   
TRNS1/10/2020DEPOSIT69100State-TN Payment17065.54ETFSTATE-TN PAYMNTSTN PAYMNTS 
SPL1/10/2020DEPOSIT10000State-TN Payment-17065.54ETFSTATE-TN PAYMNTSTN PAYMNTS 
ENDTRNS        
; [ERROR] [Paychex] There is already another entity in Quickbooks by this Name [10143]       
;[Paychex] Invalid Customer Name on the distribution line [11114]        
TRNS1/10/2020CHECK69020Paychex-466.47ETFPAYCHEX CGS     GARNISH 
SPL1/10/2020CHECK10000Paychex466.47ETFPAYCHEX CGS     GARNISH 
ENDTRNS        
; [ERROR] [Paychex] There is already another entity in Quickbooks by this Name [10143]       
;[Paychex] Invalid Customer Name on the distribution line [11114]        
TRNS1/10/2020CHECK69010Paychex-1968.68ETFPAYCHEX TPS     TAXES 
SPL1/10/2020CHECK10000Paychex1968.68ETFPAYCHEX TPS     TAXES 
ENDTRNS        
; [ERROR] [Paychex] There is already another entity in Quickbooks by this Name [10143]       
;[Paychex] Invalid Customer Name on the distribution line [11114]        
TRNS1/10/2020CHECK66100Paychex-7197.35ETFPAYCHEX-RCX     PAYROLL 
SPL1/10/2020CHECK10000Paychex7197.35ETFPAYCHEX-RCX     PAYROLL 
ENDTRNS        
; [ERROR] [Federal Alarm Company] There is already another entity in Quickbooks by this Name [10143]       
;[Federal Alarm Company] Invalid Customer Name on the distribution line [11114]       
TRNS1/10/2020CHECK67400Federal Alarm Company-653640Check    3640 
SPL1/10/2020CHECK10000Federal Alarm Company653640Check    3640 
ENDTRNS        
; [ERROR] [Federal Alarm Company] There is already another entity in Quickbooks by this Name [10143]       
;[Federal Alarm Company] Invalid Customer Name on the distribution line [11114]       
TRNS1/10/2020CHECK67400Federal Alarm Company-2553641Check    3641 
SPL1/10/2020CHECK10000Federal Alarm Company2553641Check    3641 
ENDTRNS        
; [ERROR] [ALERT 360] There is already another entity in Quickbooks by this Name [10143]       
;[ALERT 360] Invalid Customer Name on the distribution line [11114]        
TRNS1/10/2020CHECK67400ALERT 360-31.953643Check    3643 
SPL1/10/2020CHECK10000ALERT 36031.953643Check    3643 
ENDTRNS        
; [ERROR] [Paychex] There is already another entity in Quickbooks by this Name [10143]       
;[Paychex] Invalid Customer Name on the distribution line [11114]        
TRNS1/13/2020CHECK62500Paychex-573.8ETFPAYCHEX EIB     INVOICE 
SPL1/13/2020CHECK10000Paychex573.8ETFPAYCHEX EIB     INVOICE 
ENDTRNS        
; [ERROR] [Norma Brown] There is already another entity in Quickbooks by this Name [10143]       
;[Norma Brown] Invalid Customer Name on the distribution line [11114]       
TRNS1/13/2020CHECK67205Norma Brown-1703644Check    3644 
SPL1/13/2020CHECK10000Norma Brown1703644Check    3644 
ENDTRNS        
; [ERROR] [Brandy Boyland] There is already another entity in Quickbooks by this Name [10143]       
;[Brandy Boyland] Invalid Customer Name on the distribution line [11114]       
TRNS1/13/2020CHECK30705Brandy Boyland-20003645Check    3645 
SPL1/13/2020CHECK10000Brandy Boyland20003645Check    3645 
ENDTRNS        
; [ERROR] [Brandy Boyland] There is already another entity in Quickbooks by this Name [10143]       
;[Brandy Boyland] Invalid Customer Name on the distribution line [11114]       
TRNS1/13/2020CHECK30705Brandy Boyland-11553646Check    3646 
SPL1/13/2020CHECK10000Brandy Boyland11553646Check    3646 
ENDTRNS        
; [ERROR] [Brandy Boyland] There is already another entity in Quickbooks by this Name [10143]       
;[Brandy Boyland] Invalid Customer Name on the distribution line [11114]       
TRNS1/13/2020CHECK30705Brandy Boyland-14123647Check    3647 
SPL1/13/2020CHECK10000Brandy Boyland14123647Check    3647 
ENDTRNS        
; [ERROR] [waste connection] There is already another entity in Quickbooks by this Name [10143]       
;[waste connection] Invalid Customer Name on the distribution line [11114]       
TRNS1/14/2020CHECK67310waste connection-222.9ETFWASTE CONNECTIONWEB_PAY 
SPL1/14/2020CHECK10000waste connection222.9ETFWASTE CONNECTIONWEB_PAY 
ENDTRNS        
; [ERROR] [Cornelius Otis] There is already another entity in Quickbooks by this Name [10143]       
;[Cornelius Otis] Invalid Customer Name on the distribution line [11114]       
TRNS1/14/2020CHECK67200Cornelius Otis-2033695Check    3695 
SPL1/14/2020CHECK10000Cornelius Otis2033695Check    3695 
ENDTRNS        
; [ERROR] [Larry Williamson] There is already another entity in Quickbooks by this Name [10143]       
;[Larry Williamson] Invalid Customer Name on the distribution line [11114]       
TRNS1/14/2020CHECK67200Larry Williamson-100.283696Check    3696 
SPL1/14/2020CHECK10000Larry Williamson100.283696Check    3696 
ENDTRNS        
; [ERROR] [Church Health Plan] There is already another entity in Quickbooks by this Name [10143]       
;[Church Health Plan] Invalid Customer Name on the distribution line [11114]       
TRNS1/15/2020CHECK63320Church Health Plan-50ETFCHURCH HEALTH CEMPHSPLAN 
SPL1/15/2020CHECK10000Church Health Plan50ETFCHURCH HEALTH CEMPHSPLAN 
ENDTRNS        
; [ERROR] [Learning House] There is already another entity in Quickbooks by this Name [10143]       
;[Learning House] Invalid Customer Name on the distribution line [11114]       
TRNS1/15/2020CHECK62000Learning House-268.33642Check    3642 
SPL1/15/2020CHECK10000Learning House268.33642Check    3642 
ENDTRNS        
; [ERROR] The record at (or starting at) this line could not be imported. There is an invalid reference to QuickBooks Account "45000" in the Deposit.  QuickBooks error message: The specified account is invalid or of the wrong type. [3140]   
TRNS1/17/2020DEPOSIT45000ALPHA AND OMEGA1864.75ETFALPHA AND OMEGA Dec19-CTRS 
SPL1/17/2020DEPOSIT10000ALPHA AND OMEGA-1864.75ETFALPHA AND OMEGA Dec19-CTRS 
ENDTRNS        
; [ERROR] [James Skefos] There is already another entity in Quickbooks by this Name [10143]       
;[James Skefos] Invalid Customer Name on the distribution line [11114]       
TRNS1/17/2020CHECK30702James Skefos-20003698Check    3698a 
SPL1/17/2020CHECK10000James Skefos20003698Check    3698a 
ENDTRNS        
; [ERROR] [James Skefos] There is already another entity in Quickbooks by this Name [10143]       
;[James Skefos] Invalid Customer Name on the distribution line [11114]       
TRNS1/17/2020CHECK30702James Skefos-70003698Check    3698 
SPL1/17/2020CHECK10000James Skefos70003698Check    3698 
ENDTRNS        
; [ERROR] The record at (or starting at) this line could not be imported. There is an invalid reference to QuickBooks Account "45000" in the Deposit.  QuickBooks error message: The specified account is invalid or of the wrong type. [3140]   
TRNS1/22/2020DEPOSIT45000Alpha Visions Learning Academy, Inc.A667.5ETFRegular Deposit 
SPL1/22/2020DEPOSIT10000Alpha Visions Learning Academy, Inc.A-667.5ETFRegular Deposit 
ENDTRNS        
; [ERROR] [Larry Williamson] There is already another entity in Quickbooks by this Name [10143]       
;[Larry Williamson] Invalid Customer Name on the distribution line [11114]       
TRNS1/22/2020CHECK67200Larry Williamson-1003701Check    3701 
SPL1/22/2020CHECK10000Larry Williamson1003701Check    3701 
ENDTRNS        
; [ERROR] The record at (or starting at) this line could not be imported. There is an invalid reference to QuickBooks Account "69100" in the Deposit.  QuickBooks error message: The specified account is invalid or of the wrong type. [3140]   
TRNS1/23/2020DEPOSIT69100State-TN Payment11888.25ETFSTATE-TN PAYMNTSTN PAYMNTS 
SPL1/23/2020DEPOSIT10000State-TN Payment-11888.25ETFSTATE-TN PAYMNTSTN PAYMNTS 
ENDTRNS        
; [ERROR] [Paychex] There is already another entity in Quickbooks by this Name [10143]       
;[Paychex] Invalid Customer Name on the distribution line [11114]        
TRNS1/24/2020CHECK69020Paychex-562ETFPAYCHEX CGS     GARNISH 
SPL1/24/2020CHECK10000Paychex562ETFPAYCHEX CGS     GARNISH 
ENDTRNS        
; [ERROR] [Paychex] There is already another entity in Quickbooks by this Name [10143]       
;[Paychex] Invalid Customer Name on the distribution line [11114]        
TRNS1/24/2020CHECK69010Paychex-2626.84ETFPAYCHEX TPS     TAXES 
SPL1/24/2020CHECK10000Paychex2626.84ETFPAYCHEX TPS     TAXES 
ENDTRNS        
; [ERROR] [Paychex] There is already another entity in Quickbooks by this Name [10143]       
;[Paychex] Invalid Customer Name on the distribution line [11114]        
TRNS1/24/2020CHECK66100Paychex-10173ETFPAYCHEX-RCX     PAYROLL 
SPL1/24/2020CHECK10000Paychex10173ETFPAYCHEX-RCX     PAYROLL 
ENDTRNS        
; [ERROR] [Brandy Boyland] There is already another entity in Quickbooks by this Name [10143]       
;[Brandy Boyland] Invalid Customer Name on the distribution line [11114]       
TRNS1/24/2020CHECK30705Brandy Boyland-15003650Check    3650 
SPL1/24/2020CHECK10000Brandy Boyland15003650Check    3650 
ENDTRNS        
; [ERROR] [Paychex] There is already another entity in Quickbooks by this Name [10143]       
;[Paychex] Invalid Customer Name on the distribution line [11114]        
TRNS1/27/2020CHECK62500Paychex-222.8ETFPAYCHEX EIB     INVOICE 
SPL1/27/2020CHECK10000Paychex222.8ETFPAYCHEX EIB     INVOICE 
ENDTRNS        
; [ERROR] [philadelphia insurance] There is already another entity in Quickbooks by this Name [10143]       
;[philadelphia insurance] Invalid Customer Name on the distribution line [11114]       
TRNS1/27/2020CHECK63310philadelphia insurance-1003.32ETFPHILA INS CO    INS IN 
SPL1/27/2020CHECK10000philadelphia insurance1003.32ETFPHILA INS CO    INS IN 
ENDTRNS        
; [ERROR] [Consolidated Poultry & Egg Co] There is already another entity in Quickbooks by this Name [10143]      
;[Consolidated Poultry & Egg Co] Invalid Customer Name on the distribution line [11114]       
TRNS1/27/2020CHECK64310Consolidated Poultry & Egg Co-4053651Check    3651 
SPL1/27/2020CHECK10000Consolidated Poultry & Egg Co4053651Check    3651 
ENDTRNS        
; [ERROR] [Larry Williamson] There is already another entity in Quickbooks by this Name [10143]       
;[Larry Williamson] Invalid Customer Name on the distribution line [11114]       
TRNS1/27/2020CHECK67200Larry Williamson-227.723702Check    3702 
SPL1/27/2020CHECK10000Larry Williamson227.723702Check    3702 
ENDTRNS        
; [ERROR] [comcast] There is already another entity in Quickbooks by this Name [10143]       
;[comcast] Invalid Customer Name on the distribution line [11114]        
TRNS1/28/2020CHECK68600comcast-294.69ETFCOMCAST 8396522 [removed] 
SPL1/28/2020CHECK10000comcast294.69ETFCOMCAST 8396522 [removed] 
ENDTRNS        
; [ERROR] [Norma Brown] There is already another entity in Quickbooks by this Name [10143]       
;[Norma Brown] Invalid Customer Name on the distribution line [11114]       
TRNS1/28/2020CHECK67205Norma Brown-3403649Check    3649 
SPL1/28/2020CHECK10000Norma Brown3403649Check    3649 
ENDTRNS        
; [ERROR] [Jacob Ferrell] There is already another entity in Quickbooks by this Name [10143]       
;[Jacob Ferrell] Invalid Customer Name on the distribution line [11114]       
TRNS1/29/2020CHECK67200Jacob Ferrell-1503703Check    3703 
SPL1/29/2020CHECK10000Jacob Ferrell1503703Check    3703 
ENDTRNS        
; [ERROR] The record at (or starting at) this line could not be imported. There is an invalid reference to QuickBooks Account "45000" in the Deposit.  QuickBooks error message: The specified account is invalid or of the wrong type. [3140]   
TRNS1/31/2020DEPOSIT45000Alpha Visions Learning Academy, Inc.A829.5ETFRegular Deposit 
SPL1/31/2020DEPOSIT10000Alpha Visions Learning Academy, Inc.A-829.5ETFRegular Deposit 
ENDTRNS        
         

 

8 Comments 8
Pabz_L
QuickBooks Team

bank file import

Hello there, @Irhmail451.

 

When you encounter the error File not imported, QuickBooks gives you the option to review and resolve the errors.

 

 To do that, you can follow the steps below: 

 

  1. Select Review now and look for ERROR to see what the problem(s) with the file is.
  2. Correct the errors and Save. Important. If asked if you want to keep the file type, select Yes.
  3. Close the File not imported window. Then, import the new corrected file.

 

You can use this article for further information if the import is unsuccessful: How to import files.

 

Please stay in touch with me if you have other questions about importing your file in QuickBooks. I am always here to help.

lrhmail451
Level 3

bank file import

i dont think you undetstood what i had asked

 

i know it gave me errors 

i dont understand the errors it gave

 

the file here that i gave have the errors on them

can someone explain them and walk me through fixing the errors

RenjolynC
QuickBooks Team

bank file import

I appreciate your time getting back here, lrhmail451.

 

I'll give details about the error and the steps on how to fix them. When you get an error that says "Status code 3140 or 3120: The specified account is invalid or of the wrong type", this means that the accounts are not mapped properly. 

 

You'll want to open the file and ensure that the accounts are mapped correctly. Note: An account name in brackets ([ ]) indicates that the account is not mapped.

 

For the "Invalid Customer Name" error, it's possible that the name is damaged or duplicate. Please make sure to review the customers, and if there are duplicate names, you can merge them by following the steps below:

 

  1. In the Customer/Vendor Center page, right-click click on the customer name, then select Edit customerNote: If there is a Job under the customer, hover your mouse to the Job and a blank cross will appear. Drag cross and place it under the new customer name.
  2. Replace the customer (vendor) name, type Type Customer, then select OK.
  3. Merge window will show up, then select OK.
  4. Edit the customer (vendor) name by putting in back the original name, then select OK.
  5. Close QuickBooks Desktop, then reopen it.

You can also download the sample IIF file in this article to ensure that you have the correct format: IIF Overview: import kit, sample files, and headers.

 

If you're still unable to import the transactions, I'd recommend reaching out to our Customer Care Team. They can check the file and help you import the transactions.

 

Here are the steps:

 

  1. In your QuickBooks Desktop program, go to Help QuickBooks Desktop Help.
  2. In the Have a Question window, click the Contact Us link at the bottom.
  3. From the Contact Us page, select any topics.
  4. Under Here's how to connect with a QuickBooks expert section, click the Start a Message or Get Phone Number button.

I'm just a few clicks away if you have any follow-up questions or other concerns with QuickBooks Desktop. Thanks.

cp1472
Level 1

bank file import

i had error code 11114 and 10143 but i have these names in my employees list and they actually are employees but when I download the checks from my payroll company these names are being entered as costumers

JasroV
QuickBooks Team

bank file import

I can provide some insights about the error code you received and how to resolve them, @cp1472.

 

The error code 10143 pops up when there's already an entity by that name in your QuickBooks Desktop (QBDT). While the error code 11114 pops up when the name of the customer is invalid on the distribution line.

 

You'll want to ensure the mapping of your IIF file is accurate to ensure a smooth process. If you have and the issue persists, I recommend updating your software to the latest release. This way, we can guarantee the program is equipped with the latest features and fixes. Let me show you how.

 

  1. Go to the Help menu and select Update QuickBooks Desktop.
  2. Select the Update Now tab. 
  3. Click Get Updates to start the download.
  4. When the download finishes, restart your QuickBooks.
  5. Then accept the option to install the new release.

 

You can also see this link for more insights: Update QuickBooks Desktop to the latest release.

 

Once done, import your IIF files again to double-check. If the issue remains, I recommend contacting our Support team so they can have a look at it. They have the tools to check your account and investigate the cause of the error code. To reach out to them, you can refer to the steps shared by my colleague RenjolynC above.

 

You might also want to check these links to learn more about IIF files:

 

 

Let me know in your reply if there's anything else you need assistance in importing IIF files. I'll be around ready to lend a helping hand. Stay safe!

CarltonAP
Level 1

bank file import

Why would you get error code 10143 when you're trying to import transactions NOT new items?

 

For example, I'm trying to import vendor bills for existing vendors but its not letting me because they're already in the system. Is there a different way to do this?

AbegailS_
QuickBooks Team

bank file import

Hello @CarltonAP , thank you for contacting us. I'm here to help you with the error you are encountering while importing your transactions.

 

Since you're encountering the error code 10143 when importing transactions, it's important to double-check the data in your import file to ensure there are no duplicate entries or other errors that could be causing conflicts.

 

I suggest comparing the import file with the existing records in QuickBooks Desktop (QBDT) and making sure that the vendor names and other relevant information match exactly. This will prevent any conflicts during the import process.

 

If you continue to experience difficulties with the import, an alternative approach would be to manually enter the vendor bills into QBDT. By using the Enter Bills feature, you can ensure there are no conflicts with existing data. Although this method may require more time and effort, it provides greater control over the entries and reduces the risk of encountering conflicts.

 

You can also check this link to learn what can be exported and imported in QBDT: Export, import, and edit IIF files.

 

For your next step, check out this article that can walk you through the steps in balancing your finances effectively: Reconcile an account in QuickBooks Desktop.

 

In case you need further assistance with importing your transactions, you can always post in the Community anytime. I’ll be around to help you. Have a good one!

4Gal
Level 6

bank file import

@CarltonAP 

Use the trial version of an importer tool. Did you encounter the same error message?

https://get.transactionpro.com/qbd

 

Need to get in touch?

Contact us