Data Import caused quantity adjustments

Thanks for getting in touch with the Community, KFlash.

Since your data import caused invalid quantity adjustments, you can restore to a backup if there's one available.

To experience a smooth import with Excel data, you'll want to make sure of the following:

• Delete hidden columns
• Remove empty rows and columns
• There should be no dashes in empty excel fields
• Use “clear contents” instead of deleting info separately
• Don't use formulas, hyperlinks, and special characters i.e.: @,#,$,%,&,*

If you have difficulty importing specific columns from your spreadsheet, verify that their cells are formatted correctly to work with the Data Import wizard.

Here's an example:

Additionally be sure to do a quick scan through your entire worksheet before mapping. Look for any anomalies, strange data, etc. You can open .CSV spreadsheets in the Notepad app to identify irregularities.

I've included a detailed resource about working with your Data Import wizard that may come in handy moving forward: Import and export data in QuickBooks Desktop.

I'll be here to help if there's any questions. Have a lovely day!

Hi Zack,

Thanks for the response.   I didn't realize the import had entered the Qty Adjustments.  By the time I discovered this, several days had elapsed which rendered any backups useless for this purpose.  

The reason for my post is to determine why the system would make quantity adjustments when the only field being updated was the Order Cost field.  As I said, there were only three fields from the Excel file mapped in the import:  Item #, Item Name, Order Cost.   

I'm at a loss.

Thanks,

Keith

Thanks for coming back, KFlash.

By default, QucikBooks Point of Sale creates an account named POS Inventory Adjustment. Users can use this account to send transactions when:

• You have created inventory items with associated cost and quantity manually
• Deleted the inventory item including cost and quantity 
• Creating the cost adjustment memo.
• When changing the quantity of an item or manually created a quantity adjustment memo.
• When the user reversed a quantity or cost adjustment memo.
• When changing the physical inventory via Point of Sale Physical Inventory process.

The QuickBooks POS inventory adjustment is used as a Holding Account. You can use General Journal Entry to change and remove balance. Since you already performed the troubleshooting steps provided by ZackE, we can run the Verify and Rebuild Utility tool to resolve any damaged data on your company file. Just follow the steps and details in the Resolve Potential Data Issues in QuickBooks Desktop article. 

Once done, importing the data gain in QuickBooks POS. If the same thing happens, I'd suggest contacting our QuickBooks POS Support Team. They'll pull out your account in a secure environment and investigate what's causing this issue. 

I'd like to know how you get on after contacting our support or trying the steps, as I want to ensure this is resolved for you. Just leave a comment below and I'll get back to you. Have a great day ahead.