Skip to content
Open Bokeping

Prepare your records for import

Move supported records and bank activity without duplicating your books.

By

Last updated:

Import records by type rather than treating one file as a complete company backup. Customers, vendors, items, invoices, and bills have different fields and should be prepared separately.

RecordsWhere to begin
Customers or vendorsContacts → Customers or Vendors → Import
Products or servicesProducts & Inventory → Items → Import
Customer invoicesSales & Receivables → Invoices → Import
Vendor billsPurchases & Expenses → Bills → Import
Bank or credit card activityBanking → Bank transactions → select an account → Import

A .qbo file contains bank or card activity, not a complete QuickBooks Online company. It does not move every customer, invoice, attachment, or setting. Use the bank-file import guide for statement formats.

Keep your original export and agree on a cutover date with your accountant. Decide whether you need full historical transactions or just the records and balances required to start from that date.

Import supporting records, such as customers, vendors, and items, before documents that refer to them. Use the target screen’s template and supported fields, rather than assuming your previous software uses the same format. The import field reference lists every field each import accepts.

  1. Open the matching list and choose Import.
  2. Review the accepted formats and size limit. Use Download template if you need a starting point, replacing its sample rows with your own data.
  3. Select the file. On Mapping, match columns with the requested fields; column order alone is not enough.
  4. Check dates, amounts, account names, contact names, and document references. Resolve the errors shown in the review before submitting.
  5. Read Results, then open the relevant list and compare the imported records and totals with your source file.

Start with a small, identifiable batch. If a job reports errors or partial results, inspect what was created before retrying the file.

Customer import screen showing Display Name as required, CSV/XLSX/XLS formats, a 5 MB limit, and a template download.

Open full-size screenshot ↗

Actual customer-import entry screen. No contact file was uploaded for this image. This workflow accepts spreadsheets; the bank-specific OFX/QFX/QBO formats belong to Bank transactions.

The customer template requires Display Name. Customer type accepts Business or Individual; if omitted or blank, the import uses Business. Review this column when your customers include individuals rather than companies.

For example, import Willow Creek Property Management as a Business before preparing an invoice file that refers to it. Check the saved contact before continuing with invoices. A successful contact import does not import that customer’s unpaid invoices or payment history.

Do not import a customer’s unpaid invoices and also enter their combined amount as the customer’s opening balance. Apply the same rule to vendor bills and inventory.

For bank activity, check overlapping date ranges if you also connect a feed. Match imported activity to existing payments rather than posting it as new income or expense.

Finish by comparing the financial reports with your previous records and reconciling bank accounts.

If only part of a file imports, follow recover a failed or partial import before retrying.

Use the detailed walkthrough for customers and vendors, items and opening stock, multi-line invoices, or multi-line bills. Each includes a small fictional CSV example and the checks to make after import.

Frequently asked questions

Can I move my whole QuickBooks Online company with a .qbo file?

No. A .qbo file contains bank or card activity, not a complete QuickBooks Online company. It does not move every customer, invoice, attachment, or setting. Import it through the bank-file import for that account, and import customers, vendors, items, invoices, and bills separately by record type.

In what order should I import customers, items, and invoices?

Import supporting records first: customers, vendors, and items, then the invoices and bills that refer to them. Check the saved contacts before continuing with invoices. A successful contact import brings in the contact only; it does not import that customer's unpaid invoices or payment history.

What file types can I use to import customers into Bokeping?

The customer import accepts CSV, XLSX, and XLS spreadsheets up to 5 MB, and Download template gives you a starting point. Display Name is required. Customer type accepts Business or Individual and uses Business when blank. OFX, QFX, and QBO files belong to the Bank transactions import instead.

What should I do if only part of my import file went through?

Inspect what was created before retrying the file, so you do not import the same records twice. Read Results, open the relevant list, and compare the imported records and totals with your source file. Then follow the recover a failed or partial import guide. Starting with a small, identifiable batch makes this easier.

Will importing a bank statement duplicate payments I already recorded?

It can if you post the rows as new income or expense. Match imported activity to the payments you already recorded instead. If you also connect a bank feed, check for overlapping date ranges between the feed and your imported file before reviewing.

Screenshot