Error On Line XX?

Posted on May 31, 2013 by

It is the goal of this column to answer questions about QuickBooks and how it is used in the REI arena. Know how to record transactions in the proper way and have your set of books in good shape when it comes time for taxes. It is our intention to do this by you the members submitting questions to, and getting answers here in this column.

Q: Why is it when I export one of my lists and I go to import it into another company data base it comes up with Error on line XX?

A: This error message and root cause will vary based on the information that is being imported. Here are a few examples:

  1. Error occurs when the account name or account number on line xx is already being used in the file and the account is of a different type.
  2. Importing and Invoice or Bill with an account type other than Accounts Receivable or Accounts Payable.
  3. Importing a transaction with an account that has not been created prior to import.

Q: I have used my business checking/debit card to make a number of purchases that were for me personally and have nothing to do with my business – how can I fix this?

A: You have two choices: You can reimburse the company for those expenses and put them in an account (equity) called Personal Expense and then when you make the deposit you apply that to the same account.  Or you can just leave them in the Equity account and this will become income to you at the end of the year.

Q: How can I compare my business P&L of this year to last years’ P&L?

A: When you run you P&L for the period you want to look at you can go up to the tab on that screen that says Modify – go to bottom of screen and choose box that is Last Period Comparison and you can also choose % if you want then you will have a side by side report for the same period last year.

Karen BershadKaren Bershad is The Small Business Advisor. Most small business owners have a challenge handling all the different areas of running a business. The accounting can be a challenge, particularly if the software seems overwhelming. The Small Business Advisor is what you may need to get you to the next level of your business. We work at your office or provide off site assistance in getting things under control by providing a wide variety of services that are specifically for the small business.

Contact Karen Bershad


Leave a Reply