Retail Supply Chain & FMCG85 Retail Store Fronts • 120 Supply Vendors

Securing $240,000 in Vendor Rebate Claims with Immutable Audit Trails

A corrupted 35MB shared spreadsheet destroyed uncollected vendor rebate records, putting $240,000 at risk before an event-sourced procurement ledger restored 100% compliance.

VERIFIED OUTCOME

100%

Audit Trail & Complete Claim Recovery

Before & After Comparison

Unversioned Shared Spreadsheets

Unrestricted shared drive with zero role permissions or logs

BEFORE

File CrashesCorrupted 35MB spreadsheet erased 3 months of rebate claims
Zero Audit LogsImpossible to prove which stores met volume claim thresholds
Rebate Leakage32% of supplier rebates ($240,000) lost to unverified records
Audit DeficienciesFailed internal compliance due to zero financial access controls

Financial Bleed:$240,000 in uncollected supplier rebates + audit failure

Enterprise Procurement Ledger

PostgreSQL event-sourced database with immutable audit logs

AFTER

Immutable LedgerEvery rebate tier and edit logged with timestamp and user ID
Role ControlStore managers order stock; only CFO can modify rebate terms
Snapshot BackupsAutomated database backups eliminate file corruption risk
100% CompliancePassed 4 consecutive audits with zero findings or penalties

Operational Gain:+$240,000 in uncollected rebates secured & 100% audit pass

Audited Numbers & ROI Breakdown

Operational Parameter	Before (Excel Workflow)	After (Lognesia System)	Net Result
Data Loss Incidents	3 corrupted file incidents/yr	0 incidents across 18 mos	100% Data Security
Annual Rebate Claim Collection	68% collected ($240k lost)	100% collected	+$240,000 Recovered
Audit Trail Accountability	0% (No edit history)	100% immutable event logs	Zero Audit Deficiencies
Role Permission Granularity	All users have full edit rights	Strict role-based permissions	Zero Unauthorized Edits

We Know You Are Busy.

If you want to work with us without jumping on a call, we can send our pricing directly to you. Or, book our meeting.