Importing from an Excel Spreadsheet to QuickBooks Desktop for Mac 2019
I am trying to move from QuickBooks Online to Desktop for Mac 2019.
I've followed the instructions in the Guide and tried to "import" (or copy & paste) my lists a few ways, but I've not been successful.
I'm having these issues. Using the Customer Contact List as an example:
1. OPTION 1 - TRYING TO IMPORT WHOLE SPREADSHEET: File/Utilities does not show an "Advanced Import"; not able to import an Excel spreadsheet and/or File/Import does not show a "from Excel Spreadsheet" option
2. OPTION 2- TRYING TO COPY & PASTE FROM EXCEL SPREADSHEET: If I export Customer Contact List from Online (and reorder the columns like the Guide says to), I am not able Copy & Paste them into the Customer Center/Add Contacts window...it won't paste correctly
3. Even if I just try to Paste the information column by column (as it says) - there is no way to select an individual column on the "Add Contact" screen in the Customer Center, to paste it (see screen shot).
Thanks for any direction you can give, incase I'm missing something?
Thanks for taking the time to reached out to us. I'm here to help provide some insights about importing transactions to QuickBooks Desktop for Mac.
If you're trying to import a list from an Excel to Quickbooks Desktop Mac, the best way to do this is to copy and paste it into Quickbooks by column. By doing this, you need to make sure that there are no blank boxes on the Excel spreadsheet when pasting it to Quickbooks Mac. In a case like this, it won't paste it correctly since QuickBooks won't recognize the blank box in Excel.