ToolActive

GTA-RP-Bankverwaltung

Web-based credit management system for GTA RP banks – multiple banks in parallel, own staff, own conditions.

About this Project

GTA RP Banking System is a complete credit management solution for GTA RP banks. Multiple banks can operate in parallel, each with their own staff, borrowers and individually configurable conditions. The system covers the entire credit lifecycle – from application and approval through to collections.

The system features a role-based permission model with seven levels from Director to Support, a complete loan workflow including competency limits and approval processes, automatic bank statement import via CSV, and a multi-stage collections process with configurable deadlines, fees and default interest. Additional modules for customer accounts, safe deposit boxes and insurance make it the central banking platform for RP communities.

Architecture

PHP Backend (OOP, modular)

The backend is built entirely in object-oriented PHP without external frameworks. 72 PHP files with over 24,000 lines of code form a clear MVC-like layer model.

Class-based structure with clear separation of responsibilities
14 independent modules (banking, collections, insurance, ...)
No framework dependencies – complete control

MySQL Database (28 tables)

The normalized database schema supports any number of banks in a single instance – with complete data isolation per bank.

Full normalization for multiple parallel banks
Transaction audit trail for every administrative operation
Optimized queries for reports and real-time overviews

CSV Import Pipeline

Bank statements are imported via CSV upload and automatically matched to active credits. Unmatched transactions are flagged for manual review.

Automatic detection of loan repayment payments
Matching logic via reference and amount
Manual processing interface for exceptions

Role-Based Permission Model

Seven permission levels from Superadmin to Support – finely configurable and bank-specifically assignable. Critical actions require higher competency levels.

Bank-specific role assignment per employee
Competency limits for credit approvals
Complete activity log per user

Umfang & Zahlen

0Datenbanktabellen

0PHP-Dateien

0Module & Bereiche

0+Codezeilen

0Berechtigungsstufen

0Kredittypen

1 / 13

Core Features

Multi-Bank Operation

Multiple banks run independently from each other – each with own staff, conditions and settings.

Run any number of banks in parallel
Name, abbreviation, main account and primary color per bank
Automatic default policies on bank creation
Superadmin manages all banks centrally

Roles & Permissions

Seven roles from Director to Support – fine-grained and bank-specific.

Director – full control over credits, approvals and settings
Senior Loan Officer – create, approve, import, collections
Loan Officer – create and edit credits
Collections – collections process and credit terminations
Auditor – read access and reports
Support – read-only access

Credit Workflow

Complete process from borrower creation to approval.

Create borrowers with income and account data
Credit types: Auto, Personal, Business
Live check of minimum equity for auto loans
Interest rate suggestion from policy, manual override possible
Competency limit – large credits require Director approval
Credit check (SCHUFA-style) with credit score

Import & Collections

Automated processing of incoming payments and multi-stage collections.

Bank statement import via CSV
Automatic matching of payments to credits
Manual review queue for unmatched transactions
Three collection stages with configurable deadlines
Collection fees and default interest per policy
Automatic termination suggestions on overdue credits

Additional Modules

Supplementary features for a complete banking operation.

Customer Accounts – current account overview with transaction history
Safe Deposit Boxes – rental management for bank vaults
Insurance – health insurance including damage settlement
Reports – credit overviews and support cases
Text Templates – templates for collection letters and notices

Challenges & Solutions

Problem

Multiple banks – complete data isolation in one instance

Solution

Consistent bank-ID filtering at all database layers: each bank sees only its own borrowers, staff and conditions – without separate database instances.

Problem

Complete credit lifecycle with exception handling

Solution

State machine approach for credit status with automatic transitions: from application through review and approval to collection stages and termination – with configurable deadlines and thresholds.

Problem

Reliably processing CSV imports from various sources

Solution

Flexible import pipeline with configurable column mappings. Automatic matching via reference and amount, manual processing interface for unassignable transactions.

Technologies

PHPMySQLGTA RP

Vision

Our goal is for the GTA RP Banking System to become the standard for professional banking in GTA RP communities – realistic, structured and fully administrable.

Changelog

2026-06-27v1.3
Safe deposit box module expanded (terms, automatic termination). Reports section redesigned, new export function for credit overviews.
2026-06-01v1.2
Insurance module: health insurance with damage settlement and contribution history. Collections performance optimized, collection stage configuration improved.
2026-04-15v1.1
Customer accounts module: current account overview with transaction history. CSV import pipeline implemented. Credit check (SCHUFA-style) with credit score.
2026-02-10v1.0
Initial release. Multi-bank operation, complete credit workflow, role-based permission model with 7 levels.