Tripura Synod v1

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.

Developer

The Problem

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.


Technology

C# .NET 3.5 and above Windows Forms Microsoft SQL Server Visual Studio Ultimate Crystal Reports ADO.NET Windows XP and above

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.


What It Does

🏦

PR Account Management

Full CRUD for Pathian Ram accounts with area, district, place, post office, police station and division metadata.

📋

Submission Tracking

Voucher-keyed submissions linked to PR accounts - create, modify and delete with each record uniquely identified by voucher number.

💳

Loan Lifecycle

Structured loan account creation with principal, interest rate, loan period, payment frequency and auto-computed scheduled payments.

📆

Installment Tracking

Payment-number-keyed installment records tracking beginning balance, scheduled payment, extra payment, interest and ending balance.

🔍

Multi-field Search

Cross-entity search by account number, voucher number, or payment number - returns complete record detail instantly.

📊

Statements & Reports

Date-range statements for PR and Loan accounts, rendered in a Crystal Reports viewer with print support for management review.

🔒

Transaction History

Full audit log of every operation - account created, modified, deleted, submission changes, loan events - with timestamps.

💾

Scheduled Backup

Database backup built directly into the system with keyboard shortcut (Ctrl+B) - protecting against data loss without IT staff dependency.

Tripura Synod v1 login screen
Login screen - Tripura Synod · Presbyterian Church of India

The Loan Module

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.

Loan account amortisation statement
Loan statement - full amortisation schedule with scheduled payment, extra payment, interest and ending balance per installment

Application Screens

Search by account and About panel
About panel - Version 1.0 · Visual Studio 2008 · SQL Server 2005

Limitations & Outcomes

Known Limitations

  • Single-user, single-machine - no LAN or multi-user access
  • Offline only - no cloud backup or remote access
  • Manual data entry throughout - no external data integration
  • Windows-only deployment tied to SQL Server 2005

Outcomes

  • Replaced paper logbooks - zero physical registers needed post-deployment
  • First audit trail across all financial activity for the Synod office
  • Loan amortisation computed automatically - eliminating manual errors
  • Record retrieval cut from minutes to seconds via multi-field search

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.


Code

The full source code - C# Windows Forms, SQL Server schema and project files - is available on GitHub.

← All Projects SUBHAJITDEBNATH.COM Get in touch →