Migrate from EQUAL to Dolibarr ERP

EQUAL bank account records map to Dolibarr llx_bank entries representing the bank itself. The account name from EQUAL becomes the label (label) field, and the currency code maps to Dolibarr's currency module configuration. Bank account numbers from EQUAL store in a custom field cf_bank_account_number on llx_bank. Multi-currency accounts use Dolibarr's multi-entity or multi-currency configuration which must be enabled in Dolibarr Setup before migration.

EQUAL transaction records map to Dolibarr llx_bank_line (bank line entries). The debit or credit amount maps to debot and credit fields respectively. The original currency amount from EQUAL's multi-currency transactions stores in a custom field cf_original_amount with the exchange rate in cf_exchange_rate, preserving the original ledger value for audit. The transaction date becomes the dateo (operation date) and datev (value date) fields.

EQUAL virtual card and expense card records map to llx_bank_account entries with card metadata (card type, BIN range, spending limits, status) stored in custom fields on the bank account. The parent llx_bank reference links the card to the issuing bank account. Card assignment (which user or cost center the card is assigned to) maps to the fk_user (user assignment) or a custom fk_expense_category field depending on the customer's cost-center structure.

EQUAL multi-currency ledger balances map to Dolibarr llx_bank_currency records linked to the parent llx_bank account. We preserve the original currency code, balance amount in that currency, and the exchange rate to the base currency as of the migration snapshot date. Dolibarr's currency module must be activated and configured with exchange rate feeds before this object migrates.

EQUAL expense category tags map to Dolibarr llx_categorie entries with type=3 (products/categories). We preserve the category hierarchy if EQUAL supports parent-child tags, mapping it to Dolibarr's fk_parent nested structure. Tags that do not have a direct equivalent in Dolibarr's category system store as custom fields cf_expense_tag on the llx_bank_line record for granular expense reporting.

EQUAL merchant metadata (MCC code, merchant name, merchant category) attaches to llx_bank_line records via a custom field group. Dolibarr's native transaction view does not include merchant metadata fields by default, so we create cf_mcc_code, cf_merchant_name, and cf_merchant_category custom fields on the bank line table. This preserves the full merchant context for expense categorization and policy compliance.

EQUAL transaction counterparties (vendors, suppliers, income sources) map to Dolibarr llx_societe (third-party) records. The company name maps to the nom field, and the counterparty's country and VAT number map to country and tva_intra if present. Customer versus supplier classification uses llx_societe.client (1=customer, 2=supplier, 3=both) which we populate from EQUAL's party type.

EQUAL contact records associated with accounts map to Dolibarr llx_socpeople linked via fk_soc to the corresponding llx_societe record. Email, phone, and address fields migrate directly. The contact's role (billing, technical, primary) maps to the fk_socpeople_role or a custom field cf_contact_role if role-based contact segmentation exists in the source.

EQUAL invoice records (if exported from a connected accounting layer) map to Dolibarr llx_facture. The invoice number becomes ref, the total maps to total_ttc, and tax amounts map to total_tva. Status (paid, unpaid, cancelled) maps to Dolibarr's fk_statut field. Multi-currency invoice amounts store in a custom field cf_original_amount with the applicable exchange rate.

EQUAL products or SKUs referenced in expense transactions map to Dolibarr llx_product if the destination uses inventory or project management modules. The product reference becomes ref, description maps to description, and price maps to price. If the customer does not activate the product module, these records are flagged as optional scope during discovery.

EQUAL user records who own cards or are assigned to transactions map to Dolibarr llx_user. We resolve by email match. Active versus inactive status maps from EQUAL's user status. Admin flag maps to admin=1 in Dolibarr. Users without an email match go to a reconciliation queue for manual provisioning before card assignment records migrate.

EQUAL's historical transaction timestamps migrate to Dolibarr's datec (creation date) and tms (modification timestamp) fields on llx_bank_line. We preserve the original ledger timestamp rather than overwriting with migration run time, maintaining audit continuity. For transactions with no timestamp in EQUAL, we use a default migration-date value and flag the record in the reconciliation report.