Finance Admin Portal & Automated Reconciliation System

Portfolio project

Finance Admin Portal & Automated Reconciliation System

Project Overview

Designed and built a comprehensive finance operations admin portal that enables internal teams to manage users, accounts, and financial transactions while automating transaction reconciliation between external banking data and internal records.

The platform acts as a central operational hub for finance teams, combining advanced data management tools, real-time transaction monitoring, reconciliation automation, and workflow scheduling within a scalable internal tool built in Retool.

In addition to providing full visibility into financial data, the system includes custom reconciliation algorithms that automatically match transactions from external banking integrations with internally recorded financial events.

Key Outcomes

Automated ~90% of transaction reconciliation

Reduced manual reconciliation workload dramatically

Created a centralized finance operations admin portal

Enabled teams to manage users, accounts, and financial records

Built scalable tools for handling large financial datasets

The Challenge

The client needed an internal system to manage a growing financial platform.

Key operational challenges included:

Managing multiple financial data tables across the system

Reconciling external bank transactions (via Plaid) with internal financial records

Monitoring account balances and transaction activity

Giving finance teams the ability to review, edit, and investigate records quickly

Handling large datasets without performance issues

Existing workflows relied heavily on manual processes and spreadsheets, which created operational inefficiencies and increased the risk of reconciliation errors.

The goal was to build a robust internal admin portal that could serve as the operational backbone of the financial system.

Key Technical Milestones

1. Full Finance Admin Portal

Built a feature-rich admin portal in Retool to manage the entire financial data ecosystem.

The portal provides tools for managing:

Users

Accounts

Transactions

Financial reconciliation

Operational workflows

Key capabilities include:

Advanced Data Tables

Complex relational tables for financial records

Inline editing for quick updates

Customizable table views

Collapsible rows for nested data

Dynamic filtering and sorting

This allows internal teams to explore and manage financial data efficiently without engineering support.

2. Financial Transaction Monitoring & Visualization

Implemented transaction analytics and visualization tools within the admin portal.

Features include:

Transaction volume monitoring

Account-level activity tracking

Financial data charts and visualizations

Real-time transaction inspection

These dashboards provide quick operational insights into financial activity across the platform.

3. Automated Reconciliation Engine

Developed a multi-layer transaction reconciliation system that automatically matches external banking transactions with internal records.

Custom reconciliation algorithms were written in JavaScript and Python, running as scheduled processes to reconcile transactions daily.

Matching Logic

Deterministic Matching Transactions are matched using:

Transaction amount

Transaction date

Reference IDs

Keyword Matching Transaction descriptions are analyzed to improve match accuracy when reference identifiers are missing.

Fee-Tolerant Matching Transactions are allowed to reconcile when small differences exist due to processing fees within a defined threshold.

Partial Match Detection Transactions that partially match are automatically flagged for review within the admin portal.

4. Bulk Reconciliation & Operations Workflows

The portal enables finance teams to perform operational actions efficiently.

Capabilities include:

Bulk reconciliation actions

Transaction approval workflows

Manual reconciliation overrides

Investigation of unmatched transactions

These workflows significantly reduce manual effort for financial operations teams.

5. Performance Optimization for Large Datasets

Since financial data volumes grow rapidly, performance optimization was critical.

Key improvements included:

Query Optimization Optimized database queries and API calls to reduce response time.

Server-Side Filtering & Pagination Large transaction tables are filtered directly at the backend to maintain fast UI performance.

Reusable Retool Modules Built modular UI components reused across multiple admin pages.

Scheduled Workflows in Retool Automated tasks run periodically to reconcile transactions and update financial records without manual intervention.