cancel
Showing results for 
Search instead for 
Did you mean: 
lora
Level 1

warning message

When I try to import from a payroll software I get a warning message "You must assign an account for this transaction."   If I click OK then I get the next warning "Error on line 12: can't record invalid transaction."  Sometimes I click OK then the next warning is Error on line 15, then 18.  This time though, the warning is "General Journal transactions require an account on each line with an amount."  What do I need to do?  I use this payroll software for another company and have never had this problem.

1 Comment 1
Jovychris_A
Moderator

warning message

Hi ,@lora.

 

I'll help you sort this out. Make sure that you have already created the accounts used in the company file. Also, you can check the amounts if these are entered correctly. This way, the General journal transactions IIF file will be imported seamlessly to another company.

 

Before importing IFF files, I'd suggest creating a backup file so that you can easily undo the changes.

 

If you've received an error message "File not imported", QuickBooks gives you the option to review and resolve the errors found in the .IIF file. Here's how:

  1. Choose Review now.
  2. Look for ERROR to see what the problem(s) with the file is.
  3. Correct the errors and Save.Important: If asked if you want to keep the file type, select Yes.
  4. Close the File not imported window.
  5. Import the new, corrected.IIF file.

Save the IIF file on the computer. Then, import it. Here's how:

  1. Go to the File menu, select Utilities then Import then IIF Files.
  2. Select Import IIF.
  3. Locate the file, then select OK. We don't recommend the option Import it for me. I'll fix it later. Since this option bypasses data review, some of the info may not be correct or complete for your books. It also requires that you switch to a single user.
  4. Once the import is successful, you'll see the numbers of lists and transactions imported. Press Done.

 

I recommend the following articles for even more information on this process:

 

Also, for the improved IIF import in the later versions of QuickBooks, see this article.

 

Get back to me if you have any other with importing journal entries. I'm a few clicks away to help. Have a great weekend!

Need to get in touch?

Contact us