We fix the spreadsheet that runs your business, then build what replaces it.
Polychrome Tech builds Excel and VBA automations, Power Apps on Dataverse and SharePoint, and leads ERP selection and implementation — with the training and change management that make people actually use it.
Three practices, from quick automation to full rollout
Most engagements start where the pain is — a workbook that takes three days to close — and grow into the system that replaces it, only when the numbers justify it.
Excel Macro & VBA Automation
We turn manual, error-prone workbook processes — month-end consolidations, reconciliations, reporting packs — into one-click, auditable macros.
Power Apps on Dataverse
Custom line-of-business apps for approvals, field data capture, inventory and asset tracking, built on Microsoft Dataverse with proper security roles.
SharePoint & Power Automate
Document libraries, approval workflows and list-based apps in SharePoint, wired together with Power Automate flows across Excel, Outlook and Teams.
ERP Solution Selection
Requirements gathering, vendor shortlisting and fit-gap scoring across ERP options for Zambian mid-market firms, with a business case your board can sign off.
ERP Implementation
Configuration, chart-of-accounts design and data migration off legacy Excel, Pastel or Sage systems, through to go-live and hypercare support.
Training & Change Management
Role-based training curricula, super-user programmes and adoption tracking so a new system is actually used three months after we leave.
The Microsoft stack you likely already license
Most clients already own these tools inside their Microsoft 365 or Dynamics licence — we help you use what you're paying for before recommending anything new.
Active engagements by client sector
Share of engagements delivered to date, by industry.
Manufacturing — automobile & hardware
Production & assembly operations
Steel industry
Mills & fabrication
Logistics & distribution
Warehousing & fleet operations
FMCG
Production & distribution
Government
Public sector programme
Assess, build, train, adopt
The same four stages whether it's a two-week macro or an eight-month ERP go-live.
Assess
We sit with the people doing the work today and map exactly where the manual process breaks down.
Build
Macro, app or ERP configuration built and tested against real data, not a demo dataset.
Train
Role-based training and super-user certification before go-live, not a single handover session after.
Adopt
We track usage post go-live and stay on hypercare until the old process is genuinely retired.
"The month-end reconciliation that used to take our finance team four days now runs as a macro in twenty minutes — and our new Dataverse app means the branches stop emailing us Excel files entirely."