Wired Church

QuickBooks Desktop Import — CSV Files

Learn how to export reports as CSV from QuickBooks Desktop and import them into Wired Church using the column mapping wizard.

Last updated 2026-03-15

QuickBooks Desktop Import — CSV Files

Not every QuickBooks migration uses IIF files. If you prefer working with CSV exports — or if you are pulling data from QuickBooks Online, which does not support IIF — Wired Church can import your chart of accounts, transactions, and historical data from standard CSV files. This guide covers the full workflow: exporting from QuickBooks, uploading to Wired Church, mapping columns, and confirming the import.

When to Use CSV Instead of IIF

Choose the CSV import path when:

  • You are migrating from QuickBooks Online, which only exports CSV and Excel formats.
  • You want to import a specific report (e.g., Transaction Detail by Account) rather than a full data dump.
  • You need to clean or modify the data before importing — CSV files are easy to edit in Excel or Google Sheets.
  • Your IIF export is producing errors or contains data types that the IIF importer does not support.
Tip

If you are migrating from QuickBooks Desktop and want the most complete data transfer, the IIF import is usually the better choice. CSV imports are more flexible but require more manual column mapping.

Supported Report Types

Wired Church can import CSV files from the following QuickBooks report types:

Report Type What It Contains Best Used For
Chart of Accounts List All accounts with type, number, description, and balance Migrating your account structure
Transaction Detail by Account Individual transactions with date, type, name, memo, amount Importing historical transactions
General Ledger All transactions grouped by account with running balances Full transaction history migration
Trial Balance Account balances as of a specific date Setting opening balances
Profit & Loss Detail Income and expense transactions for a date range Importing a specific fiscal period

You are not limited to these reports. Any CSV file with recognizable financial columns (date, amount, account, description) can be imported using the manual column mapping wizard.

Step 1: Export CSV from QuickBooks

QuickBooks Desktop

  1. Navigate to Reports and open the report you want to export.
  2. Set the date range to cover the period you need.
  3. Click the Export button at the top of the report.
  4. Select Create a comma separated values (.csv) file.
  5. Choose A CSV file (not "A new Excel workbook") to avoid formatting issues.
  6. Save the file to a known location.
QuickBooks Desktop report export dialog showing the CSV file option selected

QuickBooks Online

  1. Navigate to Reports and open the desired report.
  2. Set the reporting period using the date controls.
  3. Click the Export icon (download arrow) in the top-right corner of the report.
  4. Select Export to CSV.
  5. The file downloads to your browser's default download folder.
QuickBooks Online report with the Export dropdown showing Export to CSV option
Warning

QuickBooks Online exports sometimes include header rows, subtotal rows, and summary sections that are not actual transaction data. The Wired Church import wizard handles most of these automatically, but review the preview step carefully to ensure no summary rows were interpreted as transactions.

Step 2: Prepare the CSV File (Optional)

In most cases, you can upload the CSV file as-is. However, some cleanup may be needed:

Removing Merged Cells and Formatting

If you opened the CSV in Excel before uploading:

  1. Check for merged cells — Excel sometimes introduces these. Unmerge any merged cells.
  2. Ensure the first row contains column headers (Date, Account, Amount, etc.).
  3. Remove any blank rows at the top of the file that QuickBooks may have added as report headers.
  4. Save as CSV UTF-8 (Comma delimited) — not as an Excel workbook.

Fixing Date Formats

Wired Church accepts MM/DD/YYYY, YYYY-MM-DD, M/D/YYYY, and MM-DD-YYYY. If your CSV uses DD/MM/YYYY (non-US), convert before uploading.

Note

All dates display in Central Time. Imported dates are interpreted as-is with no timezone conversion.

Fixing Encoding Issues

If special characters appear garbled, open the file in a text editor and verify the encoding is UTF-8. If it is ANSI or Windows-1252, re-save as UTF-8.

Step 3: Upload to Wired Church

  1. Open the admin sidebar and click Finance.
  2. Click Imports in the sub-navigation.
  3. Select the QuickBooks CSV import type.
Finance Imports page with the QuickBooks CSV card highlighted
  1. Drag and drop your CSV file onto the upload area, or click Browse to select it.
  2. Wired Church reads the file and displays initial detection results: the number of rows found, detected column headers, and a guess at the report type.

Step 4: The Column Mapping Wizard

Unlike IIF files (which have a fixed format), CSV files vary in column layout. The column mapping wizard lets you tell Wired Church what each column in your file represents.

How the Mapper Works

The wizard displays a table with three sections:

  • Detected Columns — The column headers from your CSV file (row 1).
  • Sample Data — The first 5 rows of data from each column, so you can see what the values look like.
  • Wired Church Field — A dropdown for each column where you select which field it maps to.
Column mapping wizard showing CSV column headers across the top, sample data rows, and Wired Church field dropdowns below each column

Available Target Fields

Depending on the import type, the following fields are available for mapping:

Field Description Required?
Date Transaction date Yes
Account Account name or number Yes
Amount Transaction amount (positive or negative) Yes, unless Debit/Credit are separate
Debit Debit amount (if separate from credit) Conditional
Credit Credit amount (if separate from debit) Conditional
Description / Memo Transaction description No
Name / Payee Vendor, customer, or donor name No
Check Number Check number for check transactions No
Transaction Type Type code (check, deposit, journal, etc.) No
Account Number Numeric account identifier No
Account Type Asset, liability, income, expense, equity For account list imports
Skip This Column Ignore this column during import N/A
  1. For each column, select the matching Wired Church field from the dropdown.
  2. Wired Church auto-suggests mappings based on column header names. If the header is "Date," it maps to the Date field automatically.
  3. Mark any columns you do not need with Skip This Column.
  4. Columns marked as required will show a red indicator if left unmapped.
Tip

If your CSV has separate Debit and Credit columns (common in General Ledger exports), map both columns. Wired Church will combine them into net amounts for each transaction line. If your CSV has a single Amount column where debits are negative and credits are positive (or vice versa), map just the Amount column and select the sign convention in the options panel.

Sign Convention

After mapping columns, a Sign Convention option appears:

  • Positive = Debit, Negative = Credit — The default for most QuickBooks exports.
  • Positive = Credit, Negative = Debit — Some bank-oriented reports use this convention.

Select the convention that matches your file. The preview step will show you whether amounts are mapping correctly.

Step 5: Preview and Validation

After completing the column mapping, click Preview Import to see the parsed results.

The Preview Table

The preview displays every record that will be imported, organized in a scrollable table:

  • Each row shows the date, account, description, debit amount, and credit amount.
  • Rows with validation issues are highlighted in red with an error description.
  • Rows detected as potential duplicates are highlighted in orange.
Import preview table showing parsed transactions with date, account, description, debit, and credit columns, with one row highlighted in red for a validation error

Common Validation Errors

  • Invalid date — Date could not be parsed. Check format consistency.
  • Missing required field — A required column has an empty value. Fill it or remove the row.
  • Unknown account — Account name does not match your chart of accounts. Map in the next step.
  • Amount is zero — Likely a subtotal row. Exclude it.

Excluding Rows

Click the checkbox on any row to deselect it. Deselected rows appear grayed out and will not be imported. Useful for subtotal rows, headers within data, or duplicates.

Step 6: Account Mapping

If the preview detected account names that do not match your Wired Church chart of accounts, the wizard advances to the account mapping step. This step works identically to the Mapping Accounts During Import process described in its dedicated article.

  1. Each unrecognized account name from the CSV is shown on the left.
  2. Select the matching Wired Church account from the dropdown on the right.
  3. Create new accounts on the fly if needed.
  4. Save the mapping as a template for future imports.
Note

If all accounts in your CSV already exist in Wired Church (matched by name or number), the account mapping step is skipped automatically.

Step 7: Confirm and Import

  1. Review the final summary: total rows to import, any excluded rows, and the account mappings applied.
  2. Click Confirm Import.
  3. The import executes in the background. A progress indicator shows completion percentage.
  4. When finished, a success notification appears with a link to view the imported records.
Import complete notification showing record counts and a View Imported Data link

All imported records are tagged with "CSV Import" as the source, along with the original file name and import date.

Importing Historical Data for Comparison

A common use case is importing historical QuickBooks data not for active accounting, but for year-over-year comparison reporting. To do this:

  1. Export a Profit & Loss Detail report from QuickBooks for prior years.
  2. Import each year as a separate CSV file.
  3. During import, select the Historical Data option in the import settings. This tags the data as historical and prevents it from affecting current-period reporting or open balances.
  4. Historical data appears in comparative reports (e.g., "2025 vs. 2024") but does not flow into active fund balances.
Important

Historical imports cannot be mixed with active-period imports in the same file. If your CSV covers both historical and current periods, split it into separate files at the fiscal year boundary.

Troubleshooting

CSV Opens as a Single Column

  • Cause: The file uses a delimiter other than commas (e.g., semicolons or tabs).
  • Fix: Open the file in a text editor and check the delimiter. If it uses semicolons, use Find & Replace to convert them to commas. If it uses tabs, save the file as a true CSV with comma delimiters.

Special Characters Are Garbled

  • Cause: The file encoding is not UTF-8.
  • Fix: Open in a text editor, confirm encoding is UTF-8, and re-save. See the encoding section in Step 2 above.

Excel Modified My Data

  • Cause: Excel automatically converts values that look like dates or numbers. For example, account number "1-4000" may become a date.
  • Fix: Do not open the CSV in Excel before uploading. If you must edit in Excel, import using the Data > From Text wizard with all columns set to "Text" format.

Large File Upload Fails

  • Cause: The file exceeds the 50 MB upload limit.
  • Fix: Split the CSV into smaller files by date range. Import each file separately.
Previous

QuickBooks Desktop Import — IIF Files
Next

SurePayroll Import

Was this article helpful?

Still need help?

Contact Support