--- title: "Import Customers & Vendors Into QuickBooks | MCC Solutions" description: "Clean your list, avoid duplicates and import contacts from a spreadsheet. Worked example and a post-import check." url: "https://mcc-solutionsnj.com/bookkeeping/guides/import-customers-and-vendors-into-quickbooks" --- Bookkeeping guide · Updated October 12, 2026 # Importing Customers and Vendors Into QuickBooks Typing a few hundred contacts by hand is tedious and error-prone. QuickBooks Online lets you import them from a spreadsheet, but the import is only as clean as the file you start with. By [Matthew Coleman](/about), MCC Solutions **Quick answer.** To import customers or vendors into QuickBooks Online, choose the import, download the sample file, use its column headings exactly and copy your contact list into those columns. The import is only as clean as the file you start with. Want this handled for you? Monthly bookkeeping, cleanup and year-end close for small businesses. Start with a free health check of your books. [Free health check](/bookkeeping/health-check)[Get a quote](/bookkeeping/#interest) **Related:** [Closing entries and retained earnings](/bookkeeping/guides/closing-entries-and-retained-earnings) · [Void vs delete a transaction](/bookkeeping/guides/voiding-vs-deleting-transactions) · [NJ 1099 contractor rule (ABC test)](/bookkeeping/guides/nj-independent-contractor-rule-abc-test-2026) **Free tools:** [Was that craft fair worth it?](/bookkeeping/craft-fair-profit-calculator) · [Free invoice template](/bookkeeping/free-invoice-generator) [![Intuit ProAdvisor Gold tier badge](/img/credentials/intuit-proadvisor-gold.png)](https://proadvisor.intuit.com/app/accountant/search?searchId=matthew-coleman77)Gold tier in Intuit's ProAdvisor program. [See my Intuit listing](https://proadvisor.intuit.com/app/accountant/search?searchId=matthew-coleman77) Keeping your own books? Tallyfinch does invoices, bank import and reports on your computer. [See Tallyfinch](/bookkeeping/mcc-books-downloadable-bookkeeping-software) ## Start with the template In the import data area, choose customers or vendors and download the sample file. Use its column headings exactly. Copy your contact list into those columns. Common fields include display name, company, first and last name, email, phone, billing address and notes. Tax identification numbers for vendors can be stored where the product allows. ## Clean before you import Remove duplicates, fix capitalization, standardize business names and delete test entries. Decide on a naming rule, such as company name first for businesses and last name first for individuals. Make sure each display name is unique, since QuickBooks requires it across customers, vendors and employees. Add the same email format and phone style to every row. ## Handle opening balances separately Do not put amounts owed in the contact import unless you are sure of how they will post. A cleaner approach is to import contacts and then enter open invoices and bills as real transactions with their original dates, so aging reports are correct. Opening balance entries that lump everything together hide which invoice remains unpaid. ## Map and review Upload the file and map each column. Preview the rows, fix errors the tool lists, and import a small batch of five or ten first. Open a few of the new records to see whether addresses and emails landed in the right fields. Then import the full list. ## After the import Run the customer contact list and vendor list. Check counts against the original spreadsheet. Merge any duplicates created by earlier manual entries; merging a contact moves its transactions, so be careful about which name remains. Mark vendors who need a 1099 and collect missing W-9 forms. Archive or inactivate contacts that you do not expect to use. Keep the cleaned spreadsheet as your master, along with the date of import. If you later migrate to another system, you will have a ready list in a tidy format. ## Sources for your contact list Your list may live in email contacts, a CRM, an old accounting file, a spreadsheet or a stack of invoices. Export from the most complete source, then fill gaps from the others. Combine lists in one spreadsheet and sort by name to catch near duplicates, such as an abbreviation in one place and a full name in another. A few minutes at this stage prevents hours of merging later. Typical rejections include a display name that already exists, an email address with a typo or two addresses in one cell, a state or country that does not match the allowed values, and special characters such as colons in names. Fix the rows the tool lists and import again. If a field like phone has mixed formats, standardize it first. Import errors are usually minor and are easier to fix in the spreadsheet than in the software afterward. ## Worked example with numbers You have 220 contacts in a spreadsheet. Sort by name and find 18 duplicates, leaving 202. Unify state codes (NJ, N.J., New Jersey become NJ). Import the 202 rows, then spot check ten and confirm the count in QuickBooks. ## Mistakes that cost money Importing duplicates. Mixing customers and vendors in one file. Putting opening balances in the contact file. Skipping a backup. ## Check your work After import, run the customer list and vendor list and compare counts to your cleaned file. ## Common questions **Can I update existing records by import?** Some versions allow updates by matching names, but test with a small sample first. **What file format is accepted?** CSV or Excel files in the layout of the sample template. This guide is general information, not tax, legal or accounting advice. Rules, fees and due dates change; check with the IRS, the NJ Division of Taxation or a licensed professional for your situation. Let us handle it [### Monthly bookkeeping Categorizing, reconciling and monthly reports, with cleanup, payroll and NJ filings available. Bookkeeping →](/bookkeeping/) [### QuickBooks Online Monthly bookkeeping, cleanup and reconciliation in QuickBooks Online for New Jersey small businesses. Your account stays in your name. QuickBooks →](/bookkeeping/software/quickbooks-online) More guides - [Moving From QuickBooks Desktop to QuickBooks Online](/bookkeeping/guides/migrate-quickbooks-desktop-to-online) - [How to Clean Up a Messy QuickBooks File](/bookkeeping/guides/how-to-clean-up-a-messy-quickbooks-file) - [How to Choose Accounting Software for Your Business](/bookkeeping/guides/how-to-choose-accounting-software) - [QuickBooks Online vs Xero: Which Fits Which Business](/bookkeeping/guides/quickbooks-online-vs-xero) Free tool - [Bookkeeping health check](/bookkeeping/health-check) [All guides](/bookkeeping/guides) Reach small business owners, freelancers and bookkeepers who read this guide: [advertise here](/advertise#bookkeeping). Do it yourself ### Chart of Accounts and QuickBooks Import Pack Start your books with an account list built for your type of business, instead of the generic default, and compare it with the accounts you already have. [See what's inside ($24)](/toolkits/chart-of-accounts-quickbooks-import-pack)14-day full refund Tallyfinch ### Books you keep on your own computer Tallyfinch does invoices, bills, bank import, reconciliation and the main reports, in a file you own. $99 once, then $5 a month for updates; the app keeps working if you stop the plan. It does not do payroll or sales tax filing. The free download records up to 60 entries. [See Tallyfinch](/bookkeeping/mcc-books-downloadable-bookkeeping-software) [Download it free](/tools/pro/trial/mccBooks) [Compare the three apps](/software) ## Rather have us keep the books? Ask for a quote. [Get a Quote](/bookkeeping/#interest)[Call (908) 444-6373](tel:+19084446373)