If you use inventory or stock tracking in QBO you can use the line item option in AutoEntry to assign each purchase line from an invoice or bill to a specific stock item or service that you buy or sell in QuickBooks.

In order to use this feature, three steps must be undertaken:

  • In QBO, turn on the Items Table in QBO (click on: Settings/Account and Settings/Expenses)
  • Then set up your products/services under Settings - Products and Services.
  • In AutoEntry, under company settings (integrations), disconnect AutoEntry from QuickBooks, wait about 30 seconds then re-integrate (this step will not need to be done if the items table was already in use before first integrating with AutoEntry).

In QBO:

Now, when line item extraction is selected for an Invoice or Bill, when viewing an invoice in AutoEntry, you can select the product/service for that line item from the drop down menu. As the nominal account has already been set up for the product/service in QBO, this is no longer required for line items in AutoEntry.

This is then posted to QBO the relevant stock/inventory item or service :

If you have added new products or services to QBO that they are not in the drop down menu, simply go to the integrations page under company settings in AutoEntry and click on Re-Sync QuickBooks Data: 

This feature can be set to default to either Nominal Accounts or Products/Services for all invoices on the integration page or can be selected per invoice in the line item section on the single invoice view. See Here for more details.

At the minute, AutoEntry cannot extract or remember the stock item selections for line items (recognising a particular item should be mapped to a particular QBO product) but we are working on it! 

Did this answer your question?