Start a project

Internal finance system

A bank finance team ran its month-end on spreadsheets and email. One system now holds the figures, the approvals and a record of who changed what.

ClientA major bank · name withheld
WhatSoftware
SectorBanking and financial services
TeamSipho, Lerato
Treasury deskReconciliationJournalsApprovalsReportsAudit trail
Daily reconciliation · 16 SepBalanced
Matched14 206
Unmatched3
VarianceR 0,00
JNL-8812Interbank settlement · ZARR 12 480 000,00Matched
JNL-8813FX revaluation · USD bookR 842 110,50Matched
JNL-8814Card scheme fees · SeptemberR 219 640,00Review
JNL-8815Branch cash · RosebankR 65 200,00Matched
JNL-8816Suspense clearingR 4 310,00Matched
Illustration · the real system is under NDA

What we show here is an illustration of the kind of work. The client’s own screens stay private.

The problem

A finance team inside a major bank ran a core part of its month on spreadsheets and email. Figures were retyped between systems. Approvals were chased by hand. Nobody could say who changed what, or when. In a regulated environment, that missing record is the real problem.

What we did

We built the internal system that replaced it, with the workflow, the permissions and the audit trail the process needs. Every figure has a source. Every approval has a name and a time. The reports come out of the system, not out of somebody’s workbook.

Approval · four eyesaudit trail
Prepared byTreasury · 08:12
Checked byRisk · 08:40
PostedGeneral ledger
Kept for7 years
Illustration
An illustration of the kind of screen the team works in. The client’s own screens stay private.

What changed

Under NDA. The bank is not named, and we publish no screens, figures or internal detail.

What we used
Banking and financial servicesInternal systems