The verdict in three sentences
A FileMaker or Access database from 2009 that only one employee can maintain is an operational risk, not just an IT nuisance: one corrupted file or one resignation can disrupt two weeks of business. Replacing it with a six-module web sales app costs, as a 2026 order of magnitude, 40,000 to 70,000 CAD for a 25-person SME, delivered in about four months. The make-or-break item is migrating 15 years of data, which alone takes 15 to 20 % of the budget.
The real cost of staying on FileMaker, Access and spreadsheets
Across the Greater Toronto Area, many wholesale and distribution SMEs share the same setup: a desktop database built in 2009 by a contractor who has moved on, scripts nobody understands, daily spreadsheet exports for follow-ups, and one person, often the office manager, who knows how to bring it back to life.
Warning signs: an Access file approaching the 2 GB limit, FileMaker licences renewed on old versions, no mobile access for field reps, and backups on a USB drive.
| Risk | 3-year likelihood (estimate) | Quantified impact |
|---|---|---|
| Database file corruption | Medium | 3 to 10 days of re-keying |
| Only expert employee leaves | Medium to high | Up to 2 weeks of slowed operations |
| File size limit reached | High after 15 years | Forced archiving, lost customer history |
| Spreadsheet follow-up errors | High | 1 to 3 % of revenue collected late |
| Unsupported Office or FileMaker version | Certain | Broken scripts and integrations |
| Unencrypted data leak | Low to medium | PIPEDA breach reporting obligations |
For an SME doing 9 million CAD in revenue, two weeks of slowed operations put roughly 350,000 CAD of sales flow at risk. The case for migrating exists well before the outage.
The six modules of a web sales app
| Module | Key functions | Share of budget |
|---|---|---|
| Customers and contacts | Single record, history, segments, price agreements | 15 % |
| Catalogue and pricing | Items, customer-specific prices, discounts, supplier updates | 15 % |
| Quotes | Fast creation, branded PDF, open tracking | 15 % |
| Orders and deliveries | Quote to order, packing slips, backorders | 20 % |
| Follow-ups | Automatic quote and invoice reminders, overdue dashboard | 15 % |
| Reporting and accounting export | Revenue by rep, margin, export to QuickBooks or Sage | 20 % |
Invoicing can stay in your existing accounting software with a clean export. That keeps the budget down and avoids disrupting your accountant's workflow and HST reporting.
Migrating 15 years of data safely
Migration runs in four steps: inventory of tables, layouts and scripts; customer de-duplication (often 10 to 20 % of records); field mapping to the new model; then two dry runs before a Friday-evening cutover. Plan a double-entry period of two weeks at most and keep the old database read-only for 12 months.
Timeline and funding
A typical four-month plan: 3 weeks of discovery and mock-ups, 9 weeks of iterative development, 2 weeks of migration and acceptance testing, 2 weeks of training and support. On funding, federal and Ontario digital adoption programs change frequently, so check current eligibility before signing; some require an application before work starts.
After go-live, application maintenance is essential. Kolonell offers three plans at 35,000, 75,000 or 120,000 FCFA per month (53, 114 or 183 EUR).
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.
Daniel, managing director of an industrial supplies distributor in Mississauga (25 staff, 9 million CAD revenue), invests 60,000 CAD in a web app.
- Time saved on quotes: 4 reps × 3 h per week = 12 h per week.
- Time saved on follow-ups and spreadsheet exports: 5 h per week for the sales assistant.
- Total: 17 h per week × 46 weeks = 782 h per year, at 55 CAD loaded cost, so 43,010 CAD per year.
- Faster collections: 1 % of revenue collected 15 days earlier, freeing 90,000 CAD of cash.
Payback is about 17 months on time savings alone, before counting the avoided two-week outage.
FAQ
Can we keep spreadsheets for some tasks?
Yes, the app exports to Excel on demand for one-off analysis. What disappears are the spreadsheets used as databases, which cause most errors.
How long does data migration take?
Allow 2 to 3 weeks within the four-month plan, including two dry runs. With 15 years of history, de-duplication usually touches 10 to 20 % of customer records.
Why not an off-the-shelf sales or CRM tool?
Standard tools cost roughly 40 to 120 CAD per user per month in 2026, so 12,000 to 36,000 CAD a year for 25 people. They fit standard processes; custom is justified when customer pricing, backorders or approval flows are specific.
Will field reps work on mobile?
Yes, the web app is responsive for customer lookups and quotes on a phone. Full offline mode adds 10 to 15 % to the budget.
Is our data safe in the cloud?
Hosting in a Canadian region, encryption in transit and at rest, and role-based access cover PIPEDA expectations for most SMEs. A breach response procedure should be documented at go-live.
Let's scope your project. We audit your FileMaker or Access database, scope the six modules and plan a four-month cutover without downtime. 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.
