A Windows desktop accounting system built for the Tripura Presbyterian Church - replacing manual logbooks with structured, auditable management of congregation funds, loans and financial submissions.
The Tripura Synod office of the Presbyterian Church of India maintained all financial records - membership contributions (Pathian Ram), loan accounts and installment payments - entirely in physical registers. Retrieval was slow, calculation errors were hard to catch and there was no consolidated view of the organisation's financial position at any point in time.
Core ask: Build a system that digitises the full financial workflow - account creation, submissions, loan lifecycle, search and date-range statements - eliminating the paper-based process and providing the first proper audit trail for the Synod office.
This was a freelance engagement delivered under Warlöck Solutions. The software was released on 30 June 2013 as Tripura Synod Version 1.0, built on Microsoft .NET Framework 3.5 SP1 with SQL Server 2005 as the backend.
The stack was chosen for the client's existing environment - Windows machines already in the office with no new infrastructure required. A single-user Windows Forms application with SQL Server as the backend kept deployment simple: one installer, one machine, zero ongoing IT overhead. Crystal Reports handled printable statement generation natively within the .NET ecosystem.
Full CRUD for Pathian Ram accounts with area, district, place, post office, police station and division metadata.
Voucher-keyed submissions linked to PR accounts - create, modify and delete with each record uniquely identified by voucher number.
Structured loan account creation with principal, interest rate, loan period, payment frequency and auto-computed scheduled payments.
Payment-number-keyed installment records tracking beginning balance, scheduled payment, extra payment, interest and ending balance.
Cross-entity search by account number, voucher number, or payment number - returns complete record detail instantly.
Date-range statements for PR and Loan accounts, rendered in a Crystal Reports viewer with print support for management review.
Full audit log of every operation - account created, modified, deleted, submission changes, loan events - with timestamps.
Database backup built directly into the system with keyboard shortcut (Ctrl+B) - protecting against data loss without IT staff dependency.
The loan module was the most technically involved component. At account creation, the system computes the scheduled payment and total number of payments from the loan amount, interest rate, period (months or years) and payment frequency. Each installment record then tracks the full amortisation: beginning balance, scheduled and extra payments, interest accrued and ending balance.
The result is a full amortisation schedule surfaced in the Loan Statement - printable by date range - giving the Synod office a complete repayment history per loan account without any manual calculation.
The system was delivered to the Tripura Presbyterian Church as a fully functional desktop application. Future enhancements identified at the time included multi-user network support and a web-based interface - problems that would look very different solved with today's stack.
The full source code - C# Windows Forms, SQL Server schema and project files - is available on GitHub.