How to Locate and Fix Undefined Items - QuickBooks

This article will walk through how to identify undefined items and apply the appropriate GL codes to report correctly upon the import of your data to QuickBooks Online.

1. In the Admin portal, click on Reports on the left side of the page.

Click on Reports2. Navigate to the Sales and Cash Overview workbook and click on QuickBooks Journal Entry Export at the bottom of the page. 

Screen Shot 2024-01-03 at 10.54.29 AM3. Locate the undefined items within the QBJE report, here you will see undefined accounts in multiple rows. 

QBJE Report - Locate the Undefined Values4. Return back to the Sales and Cash Overview report, at this point you will want to make sure that the "Item GL Code" is selected in the dropdown for Sales Rollup Lvl 2. To find those undefined items notice the dash "-" icon illustrating that there is't an assigned GL Code. 

SCO With Item GL Code as Second Rollup Filter5. Now that you've identified a Food & Beverage Category has a dash "-", expand the third rollup group to show the Product/Rack Rate. Notice in the image below the Hash Brown Bowl & Single Egg are both undefined.

Identify the products that were undefined6. Now that we've identified the two Food & Beverage items that are undefined we need to discover the $15.88 so we will want to look at other sections of the Sales and Cash Overview report to find that value. In this case it was a Tax Name that had the value. You will see that the total tax for that day was $210.56 but on the QuickBooks Journal Entry Export only $194.68 was showing for sales tax.Missing Fee ValueQBJE Sales Tax Value is only $194.687. We will go back into the Admin Portal and click on Inventory then Products.

Select InventorySelect Products8. Upon searching for both products you will see that each product is supposed to be reported to the Breakfast Inventory Category.

Hash Brown Bowl reports to Breakfast Category9. To fix this, start by clicking on Accounting on the left side of the screen, then Category Assignments. Select Accounting

Select Category Assignments10. Once on the Category Assignment screen locate the Breakfast Inventory Category under Food & Beverage. Once located you will see NONE as the GL Code for this category. Input the valid GL Code(s) then click save. Missing GL Codes for the Inventory Categories

Input and Save the added GL Codes11. Now we have to return to Inventory and click on Taxes and Fees to identify how the one Tax was set up.

Select Taxes and FeesClick on the Tax Name in the top right portion of the screen and you will be able to see if it was set as a Tax or Fee. In this case, it was set as a fee thus not reporting as a Sales Tax.

Identify how the Mixed Beverage Sales Tax was configuredThis Sales Tax type is a FEE12. Now that we know it was set as a fee, go back into the Accounting section then select Balance Sheet Accounts. Select Balance Sheet AccountsFees are located under Revenue. You will again see that there isn't an assigned GL Code and will need to input the correct GL Code then click Save.

Click on Revenue to show where FEES are reportedInput the missing GL Code for Fees and Save

Once these corrections are made this will allow those inventory categories and/or balance sheet accounts to report correctly in the import of your data to QuickBooks Online.

If you have any questions, please do not hesitate to reach out to Teesnap Support by emailing us at support@teesnap.com or calling 844-458-1032.