QuickBooks Error – you cannot have multiple AP or AR accounts (error varies) (SEE attachments for example of updated IIF for import)

If you get this error during an IIF upload it’s generally because you have labeled a Chart of Account in TeamUnify with the name: Accounts Receivable.

  • Did the IIF only download the Deposit Amount? Go to CoA > Accounts Receivable on your QB side and locate the PYM type and the amounts that correspond with the month you are depositing. If you see these right click and delete all payment drops (you could have ACH/CC/Cash/Check so a total of four in this instance)
  • You must change this CoA on your TU side. Go to Billing Admin > Billing Setup > CoA Setup. Click on your bad CoA and rename it to a proper CoA naming convention. Ensure you have the identical CoA on your QB side.
  • TU cannot regenerate your IIF file. The IIF file is just a text based file. You can open it up with a text program and locate your bad CoA and highlight and rename. This will be in the second part of the file (the first part is your money deposit). Ensure you are locating the bad CoA and not the common word account receivable which is used for naming conventions in the file.
  • Save and re-import.

QB Correct

QB Incorrect