Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Get 50% OFF QuickBooks for 3 months*
Buy nowI’m trying to find out whether QuickBooks Desktop still supports importing .IIF files to adjust inventory quantities.
Or is there any way to modify the quantity in batches?
Can someone from Intuit please confirm the current status of IIF inventory adjustment support and the best practice for bulk inventory updates?
You need to use an importer tool to do so. You can prepare your data with the following template
| RefNumber | Account | Transaction Date | Memo | Item | New Qty | New Value | Adj Qty | Adj Value | Customer | Class |
| 1231-1 | Cost of Goods Sold | 31/12/2020 | Year End Inventory Adjustment | Hardware | 10 | |||||
| 1231-1 | Cost of Goods Sold | 31/12/2020 | Year End Inventory Adjustment | Door Frame | 10 | |||||
then purchase TP Importer to proceed. It's a $199 one time license.
https://get.transactionpro.com/qbd
If your company is located in the US, you can get the license for free from a partner. Contact @Fiat Lux - ASIA via email directly for details.
Greetings, justin00195.
It seems you've posted twice in the Community forum about your concern with the IIF file, which my colleague Tori B already answered.
To view the response, check out this link: https://quickbooks.intuit.com/learn-support/en-us/other-questions/re-can-quickbooks-desktop-import-a....
Have more questions about managing your inventory? Visit our Community Forum for expert help. Our team is ready and waiting to provide all the support you need.
Yes, this is possible. QuickBooks can import inventory adjustments for quantity adjustments, value adjustments, or both.
You can use our BRC IIF Transaction Creator Pro to do it, or at least use it to figure out the IIF file format for these transactions. It can be download in trial mode - no charge. You might even like using it instead of writing your own IIF files, which can be rather complicated.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here