Import Excel or CSV files into QuickBooks
from web site
The QuickBooks Import Excel and CSV Toolkit is a software tool provided by Intuit, the company behind QuickBooks. This toolkit is designed to assist users in importing data from Microsoft Excel spreadsheets (XLS, XLSX) or CSV (comma-separated values) files into QuickBooks Desktop.
To import Excel or CSV files into QuickBooks, you can typically follow these general steps:
Open QuickBooks: Launch QuickBooks Desktop or log in to QuickBooks Online.
Access the Import Function: In QuickBooks Desktop, go to the File menu and choose Utilities > Import > Excel Files. In QuickBooks Online, navigate to the Gear icon (Settings) and select Import Data.
Select the Data to Import: Choose the specific data type you want to import, such as customers, vendors, or transactions.
Map the Fields: Map the fields in the Excel or CSV file to the corresponding fields in QuickBooks. This step ensures that the data is properly aligned during the import process.
Import the Data: Follow the prompts and instructions provided by QuickBooks to complete the import process. This may include selecting the file to import, confirming mappings, and reviewing a preview of the imported data.
Verify and Reconcile: After importing the data, review and verify the imported information within QuickBooks. Perform any necessary reconciliations or adjustments to ensure accuracy.
