Skip to main content

Data Import overview

Data Import moves spreadsheet data into Biznsbook: parties, products, employees, chart of accounts, opening balances and stock, finance vouchers, CRM records, real estate projects and units, bookings, service jobs and more. You upload a CSV or Excel file, match its columns to Biznsbook fields, review a preview, and run the import in the background.

What you get​

  • Templates built from your own data. The Excel template has dropdowns of your company's real product groups, warehouses, units, tax groups, suppliers and departments.
  • Smart column matching. Headers from other systems usually match themselves, and Biznsbook remembers your matching for the next file with the same columns.
  • Clear errors. Each rejected row names the column, the value and what was expected. You can download only the rejected rows, fix them and upload again.
  • Safe running. Every row is checked before anything is written. A trial run attempts the import for real and saves nothing.
  • Reversible. A finished import can delete the records it created.

Data Import is for structured spreadsheets. For scanned receipts and invoices use OCR Data Entry; for ongoing automatic sync use the Integration Hub.

Before you start​

  1. Data Import is included in every plan. The Import menu is the last item in the navigation.
  2. You only see import types for the modules your company has. For example, items need Inventory, employees need HR and accounting types need Accounting. Parties, countries and currencies are always available.
  3. Company Admins can always import. Other users need permission: see Permissions and troubleshooting.
  4. Files can be CSV or Excel (.xlsx) up to 20 MB, with up to 50,000 rows (10,000 for finance vouchers and opening balances).
  5. Only one import per company can be in progress at a time.

Getting started​

  1. Open Import → Dashboard and read the Getting started checklist.
  2. Decide your load order.
  3. Open Import → New Import, pick the first type and download its Excel template.
  4. Fill in 5 to 10 rows and run a small test import first.
  5. Check the result, then load the full file.

:::tip Start small A 5 to 10 row test import shows you the whole journey before you commit the full file. :::