Import Invoices into QuickBooks

[Gary Haberl]

Hi,

I created a quote, and followed the process to importing the final invoice into QUickbooks and I get the following error.

2/3/2018 6:17:41 PM-Invoice# Inv_3 - Failed to Add Line Item (3-Port Hubble wall plate) - Missing Income Account Reference - Check your Billing Configuration.

 

The issue is that I did not use the Inventory to create the quote at first.  I just used Items and filled parts and prices there.  I noticed I can not add Income or Expense accounts to the items I enter under "Items" in the quote.

 

My question.  How to I set a default Income and Expense account for "Items" in a quote so I can import the invoice into Quickbooks?  Or did I miss how to tell the PSA what Income / Expense accounts to?

 

Gary

[Chris]

Hi Gary,

You can do this from the Admin==>Finance-->Billing Configuration where you can assign items Income and Expense Accounts from the Chart of Accounts.

[Gary Haberl]

Thank you Chris.

But, when you do a Product Quote, and do not have inventory items, you can click on the "Items" tab and input items from there " Add/Edit SO Free Item ".  You can give it a name, QTY, price, etc.  But you can not attach it to an Expense or Income account.

Then when you push the Quote to a Sales Order, Post and Invoice all works well. But you can not import that invoice into Quickbooks as the items do not have income accounts associated to them.

I was wondering if there is a way to set a default Income and Expense account that will catch these items so the QuickBooks import will work.

Gary

[Gary Haberl]

Has anyone found a way to import non inventory 'Items' on a product quote into QuickBooks? This is a show stopper for QuickBooks users.

[Chris]

Hi Gary,

Items are made for Free Data Entry and they are not structured and they can not have Expense Account. You will need to create them first in QB before you do the Sync or uses the Product Items as a more structured way of doing this.

[Colm Whelan]

Gary,

How we got around this was by creating  "Miscellaneous Hardware" "Miscellaneous Software" and "Miscellaneous Service" items and changing the Description to suit as we quote and invoice.  Because our income accounts are split in this manner this allow us to quote or invoice for anything by using these items.

 

[Gary Haberl]

Hi Colm,

That is what we are starting to do, but this causes issues on keeping track of what products sell. It is bringing our QuickBooks reports back in time.