Importing and exporting data
Recently active
We've assembled some frequently asked questions about importing data to QuickBooks Online. Here is a walkthrough of how to import your data from Excel into QuickBooks. What information can I import to QuickBooks Online? You can import the following information to QuickBooks Online: Bank Transactions Customers Suppliers Chart of Accounts Products and Services Invoices Bills Journal Entries Do I need to import my data in a specific order? Yes. To make sure your data imports correctly, import each spreadsheet in this order: Customer Suppliers Products and services Invoices Bills If you need complete steps, click on the links to learn how to import your customers, suppliers, products and services, invoices, and bills. What file format can I use to import information to QuickBooks Online? You can use a CSV file (Comma Separated Values), Google Sheets, or an XLS/XLSX file to import information to QuickBooks Online. Here's some info about the different formats:
Learn how to check the format of the CSV file you got from your bank to upload transactions to QuickBooks. Instead of connecting your bank and credit card accounts to QuickBooks, you can upload them manually. You usually download this file from your bank. Before you can upload it, you need to make sure the data is in the correct format. Here's how to check the format of bank transactions in a CSV file you plan to upload into QuickBooks. Learn about CSV formats You can upload CSVs with either the following 3-column or 4-column format. These are the only columns QuickBooks can handle and this order. Each bank formats CSV files differently. This means you may not be able to import CSVs from certain banks since files don't have the format QuickBooks needs. The 3 column format This format has a Date, Description, and Amount column. A B C 1 Date Description Amount 2 1/1/2018 Example of a payment -100.00 3 1/1/2018 Exa
Changing the way you manage your business can seem like a big step. By importing your data from another software into QuickBooks using Excel, you can get up and run faster. Learn what data you can bring over to QuickBooks Online, and how to import your data to get started quickly. You can manually import your existing lists (suppliers, customers, products and services, and chart of accounts), as well as your opening balance, invoices and bills from another software into QuickBooks using Excel CSV files. How to import your data into QuickBooks Online Sign in to QuickBooks Online. Go to Settings ⚙ and select Import data. Select the data you wish to import. Note: Once you have selected a data type, you can select Download a sample file. This will help you in formatting your data correctly. To make sure your data imports correctly, import each Excel spreadsheet in this order: Chart of Accounts Customer Suppliers Products and services Invoices Bills Import your Chart of Account
Before conducting an import from Excel, it is important to know which contact fields will be imported and any restrictions, which fields are optional, and best practices before you get started. Best practices There are several things to think about when importing from Excel: Confirm your files contain data. To import multiple pages, save each page as a separate file. Make sure the information you want to import appears on the first page of your workbook. Make sure your spreadsheet has a header row. QuickBooks Online uses the first line for mapping purposes and does not import it. Import field: Full Name The first, middle, and last name must appear in a single column or field before importing. Restrictions: At least one of the name fields in the originating file must contain a name. A name cannot exceed 100 characters. A name cannot include a tab, newline, colon (:), or quotation mark ("). Names must be unique between your contact lists