The template Kit also comes with a Excel Template Macro that easily converts excel data into Adjustments
For QuickBooks Desktop (Pro, Premier, Enterprise) 2008 and newer only!
Note: IIF will NOT work with (since its not supported via IIF):
- Multiple Site Locations
- Bin Locations
- Serial Numbers
- Lot Numbers
Purchase Hector’s Inventory Adjustment IIF** Template for $50
(instant download)
NOTE: it is IMPERATIVE that you make sure the account name matching QuickBooks 100% (character by character) otherwise the IIF will create a a new bank account for every non-matching and mess up your chart of accounts. It is also crucial to make sure that the total debits match the credits, otherwise you ma get file corruption
Video explainer:
**Intuit does not support IIF files, use at your own risk! Make sure you always back-up first!