Skip to content
Open Bokeping

Import customers and vendors from a spreadsheet

Map contact fields, review duplicate names, and avoid importing opening balances twice.

In BokepingContacts → Customers or Vendors → Import

By

Last updated:

Import customers and vendors separately. A contact record stores who you do business with; it is not their complete invoice, bill, or payment history.

Download the current template from Contacts → Customers → Import or Contacts → Vendors → Import. Use a stable Display Name, not just a person’s first name. Keep customer and vendor names distinct enough to identify the right party later.

FieldWhat to check
Display NameRequired. Compare with existing contacts before importing.
Customer TypeCustomers support Business or Individual; omitted/blank uses Business.
Email and phoneUse the intended business contact. Importing an address does not send an invitation or email.
CurrencyConfirm it before creating documents for the contact.
Billing/shipping addressKeep city, state, country, and ZIP in their matching fields.
Opening balance and opening balance dateUse only when part of your agreed migration. A nonzero balance needs a date.

For US addresses, preserve ZIP codes as text so leading zeroes survive spreadsheet editing. Do the same for phone numbers and any identifiers. Do not add formulas or spreadsheet totals as contact rows.

Download the customer CSV example or vendor CSV example. These contain fictional USD contacts and reserved example email addresses, with no opening balances or Tax IDs. They demonstrate field mapping; they have not been committed to your company as a test import. Replace the examples before a real import.

  1. Choose the correct contact list and Import. Check accepted file formats and size on that screen.
  2. Upload the file, then map its columns to the matching fields. Customer and vendor templates are separate.
  3. Review dates, currency, contact type, and any applied defaults in the preview.
  4. Inspect rows marked Duplicate. A warning is not an update to an existing contact. Do not force a same-name row through unless you intend a separate record and can distinguish it afterward.
  5. Resolve errors, select the intended rows, and complete the import.
  6. Read Results. Open the imported contacts and compare names, currency, addresses, and any opening balances with the source.

Customer import mapping in Bokeping, with required Display Name, Customer Type and Email mapped to file columns.

Open full-size screenshot ↗

Customer example: Display Name is required. Match each file column to the intended field, then choose Review rows. A column left unmapped is not imported.

Bokeping customer import preview showing one Ready row for a fictional business and a warning about one unmapped column.

Open full-size screenshot ↗

The preview shows one fictional business ready to import, but also warns that one column is unmapped. In this example, that column is Currency. Review the warning and confirm currency in the saved contact; Ready is a preview status, not proof of a completed import.

Opening balances and contractor information

Section titled “Opening balances and contractor information”

Do not import open invoices/bills and also enter the same total as a contact opening balance. Choose the approach in opening balances before importing.

Vendor templates may include contractor classification, Tax ID, and W-9 status. Map only verified information and protect the source file. A masked Tax ID from an export is not a valid replacement for the underlying identifier, and a populated field is not proof of IRS verification. See 1099 review.

Use the result list to identify the records already created. Correct and retry the failed or skipped records only after checking existing names. Do not upload the entire file repeatedly or assume it will overwrite previous records. Follow partial-import recovery.

Screenshot