Naria ERP

Back-Office System

Production

2023

Backend

002

Year

2023

Duration

10 months

Team

4 engineers

Role

Backend Developer & Project Manager

Multi-branch ERP for travel agencies with single-entry accounting

Overview

Naria ERP is a purpose-built back-office system for travel agencies managing multiple branches, hundreds of vendors, and complex inter-company transactions. The accounting engine uses a single-entry model tailored to how travel agencies track money — advances, commissions, refunds, and supplier settlements — rather than forcing double-entry bookkeeping onto non-accountant staff. Real-time dashboards give branch managers instant visibility into cash flow, outstanding balances, and profitability by route or product type. The system handles multi-currency transactions, automated invoice generation, and consolidated financial reporting across all branches.

Key Achievements

Single-entry accounting model designed specifically for travel agency workflows

Multi-branch isolation with consolidated cross-branch reporting

Automated invoice generation from booking data with PDF export

Multi-currency ledger with daily exchange rate sync

Role-based access: branch accountant, manager, and super-admin tiers

Real-time cash flow and outstanding balance dashboards

Technical Challenges

Accounting model for non-accountants

Travel agency staff don't think in debits/credits. Standard double-entry would require accounting training for every operator.

SOLUTION →Designed a single-entry model around travel-specific concepts: advance payments, ticket costs, commission income, and vendor settlements. The system handles the ledger logic invisibly.

Multi-branch data isolation

Branches needed strict financial isolation — one branch should never see another's data — while head office needed consolidated views.

SOLUTION →Implemented a branch-scoped middleware that injects a branch ID into every query. A separate reporting service aggregates across branches only for authorised head-office roles.

Performance on large date-range reports

Generating annual P&L reports across 15 branches with thousands of transactions timed out for large date ranges.

SOLUTION →Moved heavy aggregation to MySQL stored procedures with pre-indexed summary tables. Reports that took 30+ seconds now return in under 2 seconds.

metrics.json

15+

Branches

200+

Active Users

3,000+

Invoices / Month

<2s

Report Generation

Currencies

500+

Vendors Tracked

Technology

Backend

Node.jsTypeScriptExpressKnex.js query builder

Database

MySQL 8Redis sessionsStored procedures

Frontend

React 18Ant DesignChart.jsReact Query

Infra

Docker ComposeNginx reverse proxyLinux VPS

Development Timeline

PHASE 01 — Requirements & Schema

Workflow mappingAccounting model designDB schemaAPI contract definition

Back

trabill ota platform

epaper cms