QuickBooks CSV import format and template from your company

There is no single universal QuickBooks CSV layout for every import. Customer, supplier, item, chart-of-accounts, bank, invoice, and journal workflows can ask for different columns. QuickBooks Online and desktop products also differ, and available imports can change by country or subscription. A header list copied from an unrelated tutorial can therefore be perfectly formatted and still be wrong for your screen.

Use this guide as a preparation method, not as a substitute for Intuit's current instructions. Sign in to the intended company, open the exact import workflow, and download its sample file when one is offered. That sample is your target contract.

Identify the exact import job

Write down the QuickBooks product, company, country, and record type before editing data. Confirm whether you are adding new records, updating existing records, or importing transactions. Those jobs carry different risks. A customer list may rely on names and contact details, while a transaction import may depend on account names, dates, amounts, and balancing rules.

Back up or export the relevant QuickBooks data before a material import. If a test company or sandbox is available, use it first. Imports can create records that take time to reverse even when the CSV itself is easy to regenerate.

Build the target from the current template

Copy the template header row exactly. Keep its order unless the import screen explicitly says order does not matter. Mark required fields, supported date forms, character limits, and lists of accepted values. If the screen lets you map columns during import, the template still helps you understand which destination fields exist and which are mandatory.

Do not assume that familiar labels are interchangeable. Name, Company, Display Name, and Customer may describe different fields. Account names can require an exact existing value. Tax and currency choices may be limited by company settings. MapMyCSV can place a source value under a requested header, but it cannot decide which QuickBooks account or tax treatment is correct.

QuickBooks starter headers

MapMyCSV can fill the target header row with one of six starter lists so mapping can begin. These are starting headers, not a guaranteed import contract. Product, region, and record type still vary. Headers observed August 2026. Re-check in your company.

Each pack below is labeled starting headers - confirm against the sample in your company.

• Bank 3-column (Intuit-documented): Date, Description, Amount. starting headers - confirm against the sample in your company.
• Bank 4-column (Intuit-documented): Date, Description, Credit, Debit. starting headers - confirm against the sample in your company.
• Customers: Full Name, Company, Email, Phone, Mobile, Fax, Website, Street, City, State, ZIP code, Country, Opening Balance, Opening Balance Date, Resale Number, Currency. starting headers - confirm against the sample in your company.
• Vendors / suppliers: Full Name, Company, Email, Phone, Mobile, Fax, Website, Street, City, State, ZIP code, Country, Opening Balance, Opening Balance Date, Tax ID, Currency. starting headers - confirm against the sample in your company.
• Chart of accounts: Number, Name, Type, Detail Type. starting headers - confirm against the sample in your company.
• Products / services (items): Name, SKU, Type, Sales Description, Sales Price/Rate, Income Account, Purchase Description, Purchase Cost, Expense Account, Quantity on Hand, Inventory Asset Account, Quantity as-of Date. starting headers - confirm against the sample in your company.

A starter list only fills the mapper's target box. Paste or replace those names with the header row from the sample in your own import screen before you treat the file as ready.

Map source fields carefully

Start with exact matches, then review clear business synonyms. A source Customer Email may map to a target Email. A source Invoice Total should not automatically map to an amount field until you confirm whether the destination expects gross, net, tax-exclusive, debit, or credit values.

Read several values beneath every proposed match. Column names can be misleading. A field called Ref might contain invoice numbers in one export and internal database keys in another. The general CSV column mapping guide provides a review sequence for uncertain matches.

Handle dates, numbers, and identifiers

Use the date format stated by the current import instructions and consider locale. The text 03/04/2026 can mean March 4 or April 3. An unambiguous year-first value such as 2026-04-03 is easier to review, but you should use it only when the target accepts it.

Keep identifiers separate from amounts. Invoice code 000129 should usually retain its zeros. Amounts need a consistent decimal separator, and currency symbols or thousands separators may or may not be accepted by a particular workflow. Parentheses for negative values are readable to people but are not guaranteed to parse as negative numbers. See the CSV dates and leading zeros guide for preservation checks.

Validate with a small import

Compare the prepared header row against the downloaded template. Count source and output records. Check required fields for blanks and inspect names containing commas or apostrophes. Select a small, representative batch that includes ordinary records and one or two edge cases. If the workflow provides a preview, inspect each mapped destination field there.

After the test import, open the created records in QuickBooks. Confirm dates, amounts, account assignments, names, references, and tax behavior. A message saying the file was accepted does not prove that every semantic choice was right. Review the import log and save any rejected row details before retrying.

Use MapMyCSV for the structural step

When the source and target headers differ, MapMyCSV can rename, reorder, and map the columns in your browser. If the source is still an Excel workbook, drop the spreadsheet; do not save-as-CSV first. Paste the header row from your current QuickBooks sample as the target, inspect suggested matches, correct any wrong pairing, and review the first ten rows free. Mapping and preview stay in the browser. A one-time $29 payment unlocks the full mapped CSV download.

The final responsibility remains with the importer. Review the output, follow the current QuickBooks instructions, keep a backup, and test a small batch before using the complete file.