Be sure you added your data to the formatted spreadsheet and saved it, and then added the data to QuickBooks before you start this task.
Note: We recommend that you print this topic before you start.
Follow these steps to review errors in your spreadsheet, fix them, and review the data you added to QuickBooks.
To do this task
After you've added data to QuickBooks, you'll see a summary of the results:
If there are errors, click Open Error File.
Your spreadsheet opens with the remaining errors highlighted. Correct the errors, save the spreadsheet, and add your data again.
If there are no errors, only the View button appears.
To see what your data looks like in QuickBooks, click the View button.
Your data appears on the left side of the QuickBooks Center window.
Once your data is in QuickBooks, you can edit records individually to add or change information.
What to expect when using a formatted spreadsheet
Select the type of data to add
Review the results of data you added
What to do if you can't find your saved spreadsheet
Add data from sources other than Excel
Use the Advanced Import feature
Copy and paste your data from Excel directly into QuickBooks