Quickbooks - Common IIF Import Errors

Common IIF Import Errors

In this Article

1.  Must "Specify A Sales Tax Agency" error.

2.  Transaction split lines to accounts receivable must include a customer on that split line.

1. How to fix the "You must specify a sales tax agency for the sales tax account." error in QuickBooks.

This error occurs when you have not specified the name of the tax agency you would like to use in Quickbooks.

A. Start by going into the Manage Sales Tax window in QuickBooks.  To get there, Select Sales Tax then, Manage Sales Tax... from the Menu bar in QuickBooks. 

B. This window will show you a list of the available tax agencies.  Either you or your account will need to determine which agency you are using to process your Sales Tax.

C. Once you have determined which agency you use, you need to enter this information into the General Ledger settings in Amber POS.

D. In AmberPOS go into the General Ledger settings.  From here, enter in the name of the tax agency under QB Name.  In our example, the agency name is Receiver General.  You must put the name in for each tax you use.  We are only using Tax1 in this setup. 

E. Once this is done, go back into day end and re-save. This will add the new Tax Agency name into the .IIF file for import.  Go back into QuickBooks and import the .IIF file again.  It should now import correctly!

 

In QuickBooks Desktop Pro 2024 you can also go to Items List, Click your sales tax to open it then edit your sales tax. Once this loads the sales tax agency should be on the bottom of the window. Copy the complete sales tax agency name exactly as is written and add this to the QB Name box of your tax account in AmberPOS General Ledger window.

2. Transaction split lines to accounts receivable must include a customer on that split line.

The record at (or starting at) this line could not be imported. There was an error when saving a Deposit.  QuickBooks error message: Transaction split lines to accounts receivable must include a customer on that split line.

This error is caused when an IIF file tries to import a figure into an account setup as "Accounts Receivable".

QuickBooks does not allow importing IIF files into “Accounts Receivable” based accounts.  Please import to a different, perhaps “Income” based account, to avoid this problem.

Please see image below, it shows (in a red rectangle) the account being used that causes the error.

 3. The account you entered is already used in one of the deposit lines.

This error is caused when the customer has the same account number for both A/R payments received and Total A/R made. This is resolved by changing one of the account numbers.

Here are the screenshots of the error messages:

Quickbooks Account types:

• Asset (10000 – 19999)
  • Current Asset (1000-1499) - Assets that you can easily turn into cash such as checking accounts, savings accounts, money market and CD accounts, accounts receivable and inventory.
  • Fixed Asset (1500-1999) - Items with a minimum cost that you have to sell in order to generate cash. Example of this are automobile, equipment and land. Consult your accountant or tax preparer to determine the actual minimum cost that you should use to determine fixed asset.
• Liabilities (20000 – 29999)
  Funds the company owe.
• Equity (30000 – 39999)
  The account that represents the health of your business.
• Income/ Revenue (40000 – 49999)
  Money that you get from your normal day to day business task such as sales revenue, professional fees, reimbursable expense or income for services rendered.
• Cost of Good Sold/ Job Costs (50000 – 59999)
  These are the cost associated with your line of business. If you are a home builder, the job cost are whatever it cost you to build a home. Example are materials, subcontractor, and equipment rental including direct labor. If you sell product, this includes cost on inventory, raw materials, freight charges and any labor cost that you incurred to finish the product.
• Expense/ Overhead Costs (60000 – 69999)
  Fixed costs your business have even if you run out of work. Examples include rent, telephone, insurance, and utilities.
• Other Income (70000 – 79999)
  Income you earned outside of the normal business process like rent for a building you own, stock sale, insurance settlement and interest income.
• Other Expense (80000 – 89999)
  Expenses that's outside of your normal business, such as a loss on the sale of an asset or stockbroker fees.

https://community.intuit.com/articles/1502203-overview-of-the-chart-of-accounts

Related Articles:

Importing General Ledger Info Into Quickbooks