InsightsAutomation and integrations

CRM integration with 1C and BAS: what to sync and how it works

Which data to sync between a CRM and an accounting system, in which direction, how to test the exchange before launch and what drives the term and cost

Vitalii Kopach6 min

A typical picture: a manager closes a deal in the CRM, and an accountant types the same order into BAS or 1C by hand. The manager does not see stock and does not know whether the customer paid the invoice. A month later the counterparty lists in the two systems drift apart, and the sales report has to be assembled from two sources. CRM integration with BAS and 1C removes the manual transfer. Below is what exactly to pass and what to watch.

What is synced most often

DataFrom where to whereWhy
OrdersFrom the CRM to accountingNo double entry
CounterpartiesBoth ways, with one main systemOne customer record instead of two
StockFrom accounting to the CRMA manager promises only what exists
InvoicesFrom accounting to the CRM or the other way, by processBoth the manager and accounting see the invoice
Payment statusesFrom accounting to the CRMThe manager knows whether the customer paid

Do not pass everything. Every field needs a direction and an owner.

First decide which system is the main one

For each type of data there must be one source of truth. Counterparties, for example, are often kept in accounting and only pulled into the CRM. If one record can be edited in two places, mismatches are guaranteed. More on the master system and field mapping in CRM integration with accounting and warehouse.

How it works in a project

According to the AKORDO catalogue the work includes:

  1. an exchange scheme with the direction of every field and the source of truth;
  2. a configured exchange of orders, counterparties and stock;
  3. a check of the exchange on test data before launch;
  4. a description of the solution and instructions for the responsible person.

The check on test data matters: errors such as "duplicate counterparty" or "article number does not match" are better seen before the exchange touches the live base.

Where the integration breaks

  • Different identifiers: in the CRM a customer is found by phone, in accounting by tax code, and nobody linked them.
  • Editing in both systems without rules.
  • No error log, so you learn about a failure from the accountant a week later.
  • The integration was built and nobody owns it afterwards.

So the result must include a person who understands the exchange scheme, and documentation. Support after launch can be taken separately if needed.

Terms and cost

In the catalogue, CRM integration with BAS and 1C is a separate piece of work within the business systems integration service: from $1 100 to $3 300 and from 2 to 8 weeks. The price excludes VAT and third-party service costs, and the exact sum is given after a diagnostic. It is affected by the number of exchange objects, the cleanliness of the reference lists and the presence of non-standard accounting configurations.

What to prepare

  1. A list of data that crosses between managers and accounting.
  2. Access to a test copy of accounting, not only the working base.
  3. A responsible person on the accounting side who knows how the reference lists are kept.
  4. Examples of typical and problem orders.

We work with any CRM. More often the limit is not the type of system but the quality of the reference lists. If you first need to sort out the CRM itself, start with A technical brief for a CRM. You can discuss your accounting setup at an AKORDO consultation.