Canonical page: https://bokeping.com/solutions/integrations/import/

Markdown page: https://bokeping.com/solutions/integrations/import.md

Text version of the public page. Check the canonical page for current terms and interactive features.

# Import from QuickBooks or CSV

Bring your records over, one import at a time.

Import customers, vendors, items, invoices, and bills from separate CSV/XLSX files. Bring bank transactions in through CSV/XLSX or bank files such as .qbo. Review the preview and results for each import.

[Start for free](<https://app.bokeping.com/auth/signup>)[All connections](<https://bokeping.com/solutions/integrations/>)

CSV/XLSX for supported records

Import customers, vendors, items, invoices, and bills separately, using the supported fields for each record type.

.qbo for bank transactions

Web Connect files contain bank or credit-card activity, not customer lists, vendor lists, invoices, or a complete QuickBooks company.

Review what the import accepts

Check supported fields, mapping, preview warnings, and the final import results. Unsupported source fields need to stay in your own archive.

Export supported records and reports

Export options and fields vary by module. An export is not a complete copy of the original import file or a full company backup that can be restored.

The mapping screen

## Your columns, our fields, one honest preview

CSV and XLSX exports name their columns differently — “Client,” “Customer Name,” “Bill To.” Bokeping suggests column mappings for you to review and previews the rows before import. Check required fields and any unsupported data before confirming. Structured bank files such as .qbo have a fixed format: Bokeping reads their transaction fields automatically, without custom column mapping.

-   Column mapping guessed, then shown for approval
-   A live preview of real rows before anything posts
-   Check unmapped columns and keep unsupported data separately
-   Cancel at any point — the books are untouched until you confirm

The import report

## Check the results before importing again

Read the final result to see which records were created, skipped, or rejected. Row-level errors include details to help you correct the affected records. Duplicate checks depend on the record type and its identifiers; importing the same business data in a different file is not guaranteed to be duplicate-free. Correct the failed records, preview them again, and avoid re-importing records that already succeeded.

-   Review created, skipped, and rejected records
-   Check duplicate warnings and document identifiers
-   Correct the row errors shown in the result
-   File format or parsing errors may stop the import

How it works

1

Prepare separate files

Export the lists and documents you need from your old tool as CSV/XLSX. Download bank activity separately from your bank as .qbo or another supported bank format.

2

Choose the matching import

Select the record type and review the preview. Map CSV/XLSX columns to supported fields; .qbo files belong in bank transaction import.

3

Read the result and reconcile

Review created records, skips, and errors. Compare document balances and bank balances with your source reports before relying on the imported books.

FAQs

## Fair questions

### What exactly can I import?

Customers, vendors, items, invoices, and bills use separate CSV/XLSX files with the fields supported by each import. Bank transaction import also accepts .qbo, .ofx, and .qfx files. A .qbo file contains bank or credit-card activity only, not a full QuickBooks company. Import the required contacts and items before their documents, then review bank activity and reconcile balances.

### Is there a file size limit?

The web upload accepts files up to 5 MB. For larger files, split records into separate batches without splitting the lines of a single document across files. Keep track of which records have already succeeded and review the preview and result for each batch.

### Can I re-run an import after fixing errors?

Yes. Read the previous result first, correct the failed records, and preview the retry before confirming. For documents with multiple lines, keep all lines of each affected document together. Avoid re-importing successful records; duplicate checks are not a guarantee that every repeated business record will be skipped.

### Will I get duplicates if I import twice?

Duplicate checks exist, but their behavior depends on the record type, file, and identifiers. Changed files or records with different identifiers may create additional records. Review duplicate warnings and the final result rather than assuming any repeat import is safe.

### Do my opening balances come across?

Opening balances need to be prepared and reconciled as part of the move. Decide which history and open documents you will import, then enter only the opening balances still needed. Do not count the same receivable or payable both in an imported document and again in an opening balance. Compare the trial balance, customer and vendor balances, and bank balances with your source reports.

### What if my file has errors?

Many record-level errors are reported against the affected rows, allowing valid records to be processed. A file format, parsing, or other file-level error can stop the import. Check its final status and results before correcting the file or retrying.

### Can I export everything back in the original format?

You can export supported records and reports using the options in each module. The available fields and formats vary. Exports do not guarantee the original file layout, every source field, attachments, or a complete company backup that can be restored. Keep your original files and source reports.

## Bring your books over

File import has no additional fee. Start with supported records, review the results, and reconcile before switching your daily work.

[Start for free](<https://app.bokeping.com/auth/signup>)

[The full switching guide →](<https://bokeping.com/solutions/switching/>)

## Ready to know your money?

Free plan, no card needed. Bring your QuickBooks or spreadsheet history, invite your accountant, and start reading your own books today.

[Start for free →](<https://app.bokeping.com/auth/signup>)
