The verdict in three sentences
When the sales reps of a Toronto SME cannot see customer balances or invoices in Salesforce, they call accounting, chase a client already in dispute or grant a discount to a slow payer. A marketplace connector costs 150 to 550 CAD a month, a custom connector 15,000 to 40,000 CAD, with a rollout of 4 to 8 weeks and a measured gain of around 3 hours per rep per week. The trap is not technical: it lies in duplicate management and in the rule that decides which system is the source of truth for each field.
What to sync, and in which direction
The typical setup: Sage Intacct for finance, Salesforce Sales Cloud for sales, 12 reps, 4,000 customer accounts of which about 15 % are duplicates.
| Data | Master system | Direction | Recommended frequency |
|---|---|---|---|
| Customer record (legal name, tax number, addresses) | Sage Intacct after creation | Bidirectional with approval | Real time or 15 minutes |
| Contacts | Salesforce | Salesforce to Intacct | Daily |
| Opportunities and quotes | Salesforce | Salesforce to Intacct on signature | Real time |
| Sales orders and shipments | Sage Intacct | Intacct to Salesforce | Hourly |
| Invoices and credit notes | Sage Intacct | Intacct to Salesforce | Hourly |
| Balances, due dates, overdue payments | Sage Intacct | Intacct to Salesforce | Daily |
| Price lists and customer terms | Sage Intacct | Intacct to Salesforce | Daily |
Golden rule: each field has only one master. The customer record is born in Salesforce as a prospect but becomes Intacct's property at the first order. Without this written rule, two databases correcting each other produce duplicates within weeks.
Marketplace connector or custom: the 2026 comparison
Sage Intacct exposes a modern REST API and an established Salesforce integration exists. Marketplace and native connectors cover common cases; custom work becomes necessary with custom objects, multiple entities or complex pricing logic.
| Criterion | Marketplace connector | Custom connector |
|---|---|---|
| Initial cost (2026 order of magnitude) | 1,000 to 5,000 CAD of setup | 15,000 to 40,000 CAD |
| Recurring | 150 to 550 CAD a month | 3,000 to 7,000 CAD a year of maintenance |
| Timeline | 2 to 4 weeks | 4 to 8 weeks |
| Custom fields and multi-entity | Limited, depending on vendor | No limit |
| Duplicate handling | Simple rules (tax number, email) | Business rules, assisted merge |
| Error log and replay | Basic | Dashboard, alerts, replay |
| 3-year cost | 6,400 to 24,800 CAD | 24,000 to 61,000 CAD |
For reference, the Kolonell grid for a connector of this kind, treated as a simple application, is 2,500,000 to 4,000,000 FCFA, i.e. 3,810 to 6,100 EUR, delivered remotely, with Kolonell maintenance at 35,000 to 120,000 FCFA a month (50 to 180 EUR).
Five traps that sink the project
First trap, existing duplicates: clean before syncing, count 3 to 5 days for 4,000 accounts. Second trap, customer IDs: Salesforce must store the Intacct customer ID, never recompute it. Third trap, API limits: Salesforce daily API call limits and Intacct transaction volumes must be sized, especially for hourly invoice syncs. Fourth trap, amounts: sync invoices with and without tax (HST), otherwise reps compare different numbers. Fifth trap, confidentiality: not every rep should see every customer's balance, permissions must follow account ownership.
Mini case study
Need a professional website?
Kolonell builds websites that attract clients, optimized for the Sénégalese market. Free quote in 2 minutes.
Ryan, VP of Sales at a distribution SME in Toronto (illustrative example), manages 12 reps who each lose about 3 hours a week calling accounting, looking for invoices or re-keying quotes. Over 45 working weeks, that is 1,620 hours, i.e. 97,200 CAD a year at a loaded 60 CAD per hour. Marketplace option: 3,000 CAD of setup and 350 CAD a month, i.e. 7,200 CAD in year one. Custom option: 28,000 CAD plus 4,000 CAD of maintenance, i.e. 32,000 CAD. In both cases, payback is counted in weeks if only a third of the time is recovered (32,400 CAD a year). The choice rests on duplicate handling and custom fields, not on price.
FAQ
Is the native Sage Intacct and Salesforce integration enough?
Often, for standard objects. As soon as you have custom objects, several entities or specific pricing rules, expect 1 to 3 weeks of custom work on top.
How long does duplicate cleanup take?
About 3 to 5 days for 4,000 accounts, with rules on tax number, name and postal code. Without prior cleanup, the duplicate rate can exceed 20 % after three months.
Can reps create customers in Intacct directly from Salesforce?
It is possible but not advised without approval: a few minutes of review per record by sales operations prevents duplicated or misconfigured accounts.
Does the connector survive software updates?
A marketplace connector is maintained by its vendor. For custom, plan 1 to 3 days of checks at each major release, included in maintenance of 3,000 to 7,000 CAD a year.
What real gain should we expect?
Around 3 hours per rep per week as a 2026 order of magnitude, and above all fewer errors: discounts granted to overdue customers, reminders sent on invoices already paid.
Let's scope your project. Tell us your Intacct and Salesforce editions and the data to sync: we will price the connector, the duplicate cleanup and the go-live timeline. Detailed quote within 48 h. WhatsApp +221 77 596 93 33.
Mohamed Bah
Fondateur, Kolonell
Passionate about digital and entrepreneurship in Africa, Mohamed has been helping Sénégalese businesses with their digital transformation since 2020. Founder of Kolonell, he believes every SME deserves a professional and accessible online présence.