System and maintenance

Export your company's data (spreadsheet files)

Your data is yours. Maintenance → Export company data downloads your customers, suppliers, items, chart of accounts and every transaction as spreadsheet files — a ZIP of CSV files that Excel, Google Sheets or LibreOffice open directly. Use it to keep your own copy, to hand the figures to your accountant, or to move to another system.

It keeps working when the workspace is read-only (for example after a free trial or subscription has ended), so you can always take your data with you.

Before you start

  • You need to be the Administrator, or have the System access right. Others do not see the page.
  • The export is a copy for reading and importing elsewhere. To keep a copy that can be restored into BusinessSensor exactly as it is, take a backup instead (Maintenance → Backup & Restore).

Steps

  1. Open Maintenance → Export company data (or, on a read-only workspace, click export company data in the red panel at the top of the page).
  2. Check the list under What is in the ZIP — each file with the number of rows it will hold.
  3. Click Download ZIP. Keep the page open while it prepares; a large company can take a minute or two.
  4. Open the ZIP from your browser's downloads. Start with README.txt, which lists every file and what it contains.

What the ZIP contains

File What is in it
01-customers.csv Customers
02-vendors.csv Suppliers
03-items.csv Items (products and services)
04-chart-of-accounts.csv Chart of accounts
05-invoices.csv, 06-invoice-lines.csv Sales invoices and their lines
07-purchases.csv, 08-purchase-lines.csv Purchases (bills) and their lines
09-receipts.csv, 10-receipt-lines.csv Customer receipts and the invoices they paid
11-bill-payments.csv, 12-bill-payment-lines.csv Payments to suppliers and the bills / expenses they paid
13-expenses.csv, 14-expense-lines.csv Expenses and their lines
15-journal-entries.csv General journal entries
16-customer-journals.csv, 17-vendor-journals.csv Customer and supplier adjustments
18-stock-movements.csv Every stock in and out
19-ledger.csv The general ledger: every posting, debit and credit

The first row of each file holds the column names. Lines point to their document by its number (for example invoice lines carry the invoice's InvoiceID). Dates are written 2026-11-10; numbers use a dot for decimals.

Tips

  • Every download is recorded in the Audit Log (action Export) with who downloaded it and how many rows it held.
  • To total a customer's balance in a spreadsheet, filter 19-ledger.csv on ObjectType = Customer and that customer's id, then sum Debit minus Credit.

Common problems

  • I can't see Export company data in the menu → The Maintenance menu shows only to the Administrator. A user with the System access right can open the page directly from the red read-only panel or at /maintenance/export-data.
  • "Only the Administrator … can export" → Sign in as the Administrator, or ask them to give your group the System access right.
  • Names with accents look wrong in Excel → The files are UTF-8. In Excel use Data → From Text/CSV and choose 65001: Unicode (UTF-8) if the characters look garbled.
  • Pictures are missing → Item and customer pictures, signatures and passwords are left out on purpose. Take a backup if you need everything.
  • The download stopped part-way → Check your connection and click Download ZIP again; nothing is changed by an export, so it is safe to repeat.

See it working on your own business

Start a 45-day free trial — no card needed — and follow this guide in your own practice company.