Bank Transaction Monitoring System

A Windows desktop application built for Tripura Forest Development & Plantation Corporation Ltd. to digitise and centralise bank account management - replacing paper registers with structured account tracking, FD maturity alerts and a full transaction audit trail.

Team
AS
Ankita Saha
· ·

The Problem

TFDPC Ltd., a Government of Tripura public sector undertaking, managed its banking operations entirely through paper registers. The organisation held funds distributed across fixed deposits, current accounts and savings accounts - often across multiple banks. Tracking maturity dates for fixed deposits required manually cross-referencing old records and there was no consolidated view of the company's financial position at any given point.

Core ask: Build a system that alerts the accountant ahead of FD maturity dates, tracks all transactions with an audit trail and provides a current status view of all accounts - eliminating the paper-based process entirely.

This was our MCA first-year summer internship project at ICFAI University, Tripura, completed in July 2012. The client was TFDPC Ltd., guided by Mr. Ranjit Singh (company guide) and Mr. Ashish Chowdhury (academic project guide).


Technology

Visual Studio 2008 VB.NET Microsoft Access 2003 OLEDB .NET Framework 3.5 Windows XP+

The application was built as a Windows Forms MDI (Multiple Document Interface) application using VB.NET, with Microsoft Access as the backend database connected via OLEDB. The choice was driven by the client's existing IT environment - Windows XP machines with Office installed - and the team's familiarity with the Microsoft stack from coursework.


What It Does

🔔

FD Maturity Alerts

Three-tier alert system surfacing fixed deposits maturing within 7, 30 and 90 days - visible on the home screen immediately after login.

🏦

Account Management

Full CRUD for Fixed Deposits, Current Accounts and Savings Accounts - including deposit/withdrawal transactions and automatic balance updates.

📋

Transaction Audit Trail

Every financial event - account creation, fund transfers, debits, credits, FD maturation - is logged to a transaction table with timestamps.

📊

Current Status Report

Consolidated view of all accounts across banks, filterable by account type and bank name, with a print-ready report output.

🔍

Multi-Axis Search

Search accounts by bank name, account number, date of opening, date of maturity, or date of transaction - across all account types.

🔒

Secure Login + Backup

Administrator authentication with credential management and a one-click database backup to any local path - protecting against data loss.

TFDPC Bank Transaction Monitor home screen
Home screen - alert indicators (red/orange/yellow) showing maturing FD counts by time window

The Alert System

The maturity alert was the primary business requirement. On every login and whenever the home form regains focus, the application queries the Accounts table for fixed deposits maturing within three time windows. The colour-coded counters (red for 0–7 days, orange for 8–30, yellow for 31–90) are visible at a glance in the top-right of the home screen.

Matured FDs are automatically moved to the MT (Mature Table) and removed from active accounts - keeping the dataset clean without manual intervention. The corresponding transaction record is written to the TT table with a "ACCOUNT MATURED" remark.

FD Maturity Alert form showing three tiers
Alert form - three grids showing FDs maturing within 0–7 days, 8–30 days and 31–90 days

Application Screens


System Design

The project followed an iterative waterfall model - feasibility study, requirements specification, design, coding and testing, with feedback loops between phases. The design artefacts included Data Flow Diagrams at three levels, an Entity-Relationship diagram and a Use Case diagram covering nine administrator-facing functions.

DFD Level 1
DFD Level 1
DFD Level 2
DFD Level 2
Entity Relationship Diagram
E-R Diagram
Use Case Diagram
Use Case Diagram

Database Schema

Four tables in MS Access covered the full data model:

ACCOUNTS - Core account records (FD, CA, SA)
FieldTypeDescription
acnoNumber (Double)Account number
acctypeTextFIXED DEPOSIT / CURRENT ACCOUNT / SAVINGS ACCOUNT
banknameTextBank name
bnameTextBranch name
opendateDate/TimeDate of opening
maturedateDate/TimeFD maturity date
balanceNumber (Double)Current balance
intrateNumber (Single)Interest rate
matureamtNumber (Double)Maturity value (pre-TDS)
TT - Transaction log (audit trail)
FieldDescription
idnoAuto-incrementing transaction ID
dotDate of transaction
fromSource account or CASH
toDestination account
amtAmount
remarkACCOUNT CREATED / MODIFIED / DELETED / MATURED / DEPOSIT / WITHDRAWL

MT (matured FD archive) and ADMINISTRATOR (login credentials) complete the schema. Fund transfers between accounts update balances atomically - debit from source, credit to FD - with a single transaction record capturing both sides.


Limitations & Outcomes

Known Limitations

  • Single-user, single-machine desktop app - no LAN access
  • Offline only - no cloud backup or remote access
  • Manual data entry throughout - no bank API integration
  • Database stored locally - system crash risk without backup discipline

Outcomes

  • Replaced paper registers with structured digital records
  • Eliminated manual FD maturity date lookup
  • Printable current status reports for management review
  • Full transaction audit trail from day one

The system was delivered to TFDPC Ltd. as a functional desktop application at the end of the summer internship. Future enhancements identified at the time included multi-user network support and online database hosting - problems that would look very different solved with today's stack.


Code

The full source code - VB.NET forms, database and project files - is available on GitHub.

← All Projects SUBHAJITDEBNATH.COM Get in touch →