Concordia Systems logoConcordia Systems
Case Studies

Two tools. Real problems, solved.

Case Study 01

Invoice Consolidation Tool

Importers filing IDFs on KRA's iCMS system often deal with invoices containing hundreds of line items — many of them near-duplicates (same product, different color or minor variation). This increases the risk of mismatches, rejections, and slow manual review.

This tool takes a commercial invoice (PDF, Excel, or CSV) and automatically consolidates it down to under 99 line items, as required for iCMS filing. It groups items by HS code, description, origin, and unit of measure — so items like "Hose Pipe Blue" and "Hose Pipe Yellow" become "Hose Pipes ×2," while keeping genuinely distinct items separate.

Every consolidation is checked against the original invoice to guarantee the totals match exactly — nothing is lost or altered in value, only grouped. The result is a clean, compliant, audit-ready invoice, ready for IDF filing, cutting manual prep time and reducing rejection risk.

Frequently asked questions

Case Study 02

Sheetsync

Many business owners track M-Pesa spending manually — going through SMS messages one by one to log expenses. Sheetsync automates this.

The app reads incoming M-Pesa messages, automatically extracts the amount, recipient, transaction type, and time, and organizes them into categories (fuel, supplies, utilities, etc.) based on recipient name keywords. Users can manually override the category on any transaction, and overrides sync back immediately.

Every transaction syncs automatically to the user's own Smartsheet — no manual data entry. The result is a live, organized record of business spending that updates itself.

Frequently asked questions