Thank you for reaching out regarding your QuickBooks 2016 software, @Ty00.
I understand you're experiencing difficulties mapping custom fields in the Excel item import feature. I'll do my best to assist you with this issue.
In QuickBooks Desktop, we can only import Customer, Vendor, Items, and Chart of Accounts from an Excel spreadsheet. There are several options available when importing Excel files from QuickBooks. I understand the significance of mapping custom fields, but currently, QuickBooks Desktop (QBDT) only allows the use of standard fields.
For additional insights and information, I encourage you to explore this article: Import or export MS Excel files.
Moreover, I'll be adding these resources to help manage your custom fields in QBDT. It includes insights on how to effectively utilize custom fields and shed light on the maximum number of list entries that QuickBooks can accommodate:
If you have any further questions or need assistance with any other aspect of QuickBooks, please don't hesitate to reach out. I'm here to help you anytime.
