The column headings in QuickBooks may be different from your Excel, so you’d need to match them. Mapping your accounts tell QuickBooks how to import the data from your Excel sheet. Note: Before importing, we recommend that you create a backup of your company file. Note: If you need to import additional customer, vendor or item data from excel using this option, you can always go back to this window. Once you have entered your information, saved the file and closed it, you will be given the option to Add My Data Now.
Go to the File menu, select Utilities then Import and then Excel Files.To import Customers, Vendors, and Products you sell When you save and close the file, you can review results and view your data in QuickBooks. QuickBooks opens a formatted Excel spreadsheet where you can enter your information.
