A Gaborone-based lender, off paper.
A collateral lender was running its entire loan book across paper registers and a set of spreadsheets. Codimente replaced it with one system.
Loans were written into a register by hand and tracked in spreadsheets that only one person fully understood. Working out the true position of the book — what was outstanding, what was in arrears, which pledged items were due for redemption or forfeiture — meant a manual reconciliation that took days and was out of date by the time it finished.
The risk was not just inefficiency. Items were being held without a reliable record of their valuation and terms, and arrears were surfacing weeks after they began.
What Codimente builtA collateral-based loan management system covering the full lifecycle: intake and valuation of the pledged item, loan origination against it, the repayment schedule and interest accrual, arrears tracking, and finally redemption, rollover or forfeiture. Every action is recorded against the item and the borrower.
The system was built on open-source technology, so there are no per-seat licence fees, and the data belongs to the client rather than to a vendor.
The resultThe loan book position is now available on demand instead of after a reconciliation. Arrears appear the day they arise. Staff who previously kept their own parallel records work from one shared source, and handovers no longer depend on a single person's memory of how the spreadsheets fit together.
- One register Every pledged item in a single searchable record
- Same day Arrears visible as they happen, not at month end
- Full trail Every valuation, payment and redemption timestamped
Running your business off spreadsheets?
Most of Codimente's work starts exactly there.