QuickBooks is an all-inclusive application that allows business organizations to manage their operations and funds in a systematic manner. And an important part of running a business is to move your transaction file from one application to another in order to create a sync. However, multiple users have complained about facing an issue while they try to import transactions.
Known as the QuickBooks Error 15113, this issue is not specific to any version of QuickBooks, as it may come up in any. Some users have stated that this error started flashing on their screen with a warning saying, “QNTY column is repeated or empty in the header,” while they were from one QuickBooks variant to another. The top factor from which this error originates is a corrupted company file or an in correction with the file. Below we have elaborated some other causes behind the error, along with the methods to rectify it, read till the end.
Does QuickBooks Error 15113 keep coming back into your computer even after extensive troubleshooting? Speak with our pro-advisors at 1.800.417.5147 and find the root cause of the problem to eliminate it forever
Why Does QuickBooks Error Code 15113 Arise?
Here are some reasons that provoke QuickBooks Desktop Error 15113 to occur in your system without any misconfiguration in your computer device –
- If the file to be imported is corrupted or has been damaged, it will fail to load and lead to this error.
- Invalid transactions are recorded in the file.
- If the file does not include the date in the right format – dd/mm/yyyy, or if the weekday of the transaction is also mentioned along with the date, Transaction error 15113 may come up.
- Saving the file in the wrong format or with a wrong extension can also trigger the issue.
- Working on an outdated software or MS Excel.
Read more :- Quick Guide to Understand QuickBooks Error 1117 in Detail
How to Get Away with QuickBooks Error Message 15113?
We have understood the factors that influence Error 15113 in QuickBooks. Let us now move on to the section where we will be discussing about the process that can be implemented to resolve the issue with the transactions –
Technique 1 – Follow the Correct Way to Import the Transactions
Since you may encounter this error while importing the transactions from one version of QuickBooks to another, try following the process again by applying these instructions –
- Open the QuickBooks version into which you wish to import the transactions.
- Tap on the Lists menu tab and select Items from the given list of options.
- Tick the “All Names” box and hit the Edit button on the top.
- Select Re-sort List and now, press OK to proceed.
- After the process is complete, try importing the transactions again.
Technique 2 – Check if the Issue is with the Company File or QuickBooks
Sometimes the glitch may arise when there is a problem inside your company file. Here, we will check if the file needs to be repaired or not –
- Access the No Company Open window in QuickBooks.
- Tap and hold the Alt key on your keyboard and select the Open option on your screen.
- If you are directed to the QuickBooks Desktop login window, release the Alt key and type in your credentials to authorize the action. If not, proceed to the next step.
- Keep pressing the Alt key, and tap on the OK button until the company file is completely open.
- If the above steps do not open your data file, you must open a sample file. This is how –
- Click on the File tab and select the “Close Company/ Logoff” option.
- While on the No Company Open window, tap on Open a sample file.
- Choose any file from the options and click OK.
- If the sample file opens up, the error lies within your company data file, and you must repair it. But if it doesn’t open, you must fix your QuickBooks program.
Read more :- How to Easily Resolve QuickBooks Error 1326?
Technique 3 – Import the IIF File in QuickBooks
If you are facing the issue of importing with the Intuit Interchange Format (IIF) file, this is how you must import it in order to erase the error –
- In QuickBooks, switch to the single-user mode and log in to your company data file using your admin credentials.
- Tap on the File tab and hover over the Utilities option in the menu.
- Click on Import and further select the Import IIF option.
- Choose the file that you wish to import, hit the Open button and then click OK.
- If you face any issues while doing this, click on the Review Now button.
- Locate and correct the error, and press Save to continue.
- The program will ask if you wish to keep the files; click on the Yes option.
- Terminate the File not Imported screen and try importing the IIF file again.
Technique 4 – Try Importing the Excel File again
For users who are struggling to import their Excel file, apply these steps and check if they help you in importing the file successfully –
- Access QuickBooks and click on the File menu to go to the Utilities option.
- Now, select Import and then choose Excel Files.
- Ensure that the name of the file is tab-separated and not comma-separated. You can alter the name by copying and pasting it to the Notepad.
- If these steps trigger the “Add/ Edit Multiple List Entries” message, press the No button and follow the on-screen instructions to import your files.
From the above blog, we have learned that the most significant factor causing QuickBooks Error 15113 is a damage in the file, and the best way to tackle it is to check if it needs to be repaired by accessing it through an alternate way. We hope that you were able to resolve the error without compromising your data. However, if you require additional support while performing the above steps, feel free to reach out to our experts at 1.800.417.5147 for round the clock assistance.
Read more :- QuickBooks Unrecoverable Error 19743 : General Troubleshooting Steps