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.

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

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 customer. Note: 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.

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

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:

• IIF Overview: import kit, sample files, and headers.
• Tasks you can do with 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!

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?

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!

@CarltonAP 

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

https://get.transactionpro.com/qbd