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
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
| Data | From where to where | Why |
|---|---|---|
| Orders | From the CRM to accounting | No double entry |
| Counterparties | Both ways, with one main system | One customer record instead of two |
| Stock | From accounting to the CRM | A manager promises only what exists |
| Invoices | From accounting to the CRM or the other way, by process | Both the manager and accounting see the invoice |
| Payment statuses | From accounting to the CRM | The 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:
- an exchange scheme with the direction of every field and the source of truth;
- a configured exchange of orders, counterparties and stock;
- a check of the exchange on test data before launch;
- 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
- A list of data that crosses between managers and accounting.
- Access to a test copy of accounting, not only the working base.
- A responsible person on the accounting side who knows how the reference lists are kept.
- 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.