Financial Management & Project Costing System

This comprehensive financial calculation system enables project-based businesses to accurately track costs, manage budgets, and analyze profitability across multiple currencies with automatic historical exchange rate conversion.

1. System Overview

The financial management system provides end-to-end calculation and tracking of project costs, from individual employee hours to complete project profitability analysis. All monetary values can be displayed and calculated in any supported currency, with automatic conversion based on historical exchange rates.

What This System Does

• Internal Resource Costing - Calculates the true cost of employee time spent on projects, including base salaries, overhead expenses, and indirect costs
• External Service Tracking - Monitors all external expenses (contractors, materials, services) associated with projects
• Budget Management - Compares actual costs against planned budgets for both internal resources and external services
• Profitability Analysis - Calculates Gross Profit Margin (GPM) by comparing project income against total costs
• Multi-Currency Support - All financial data can be viewed in any currency with automatic historical conversion
• Automated Monthly Updates - System automatically calculates and stores monthly rates for overhead and indirect costs

2. Core Financial Concepts

Understanding how project costs are calculated requires knowledge of several key components that work together to produce accurate financial reports.

Employee Classification

Employees are categorized into two types, which affects how their costs are calculated:

The Three Components of Hourly Rates

Every hour worked by direct cost staff has three cost components:

Total Hourly Rate = Base Hourly Rate + Overhead Rate + Indirect Cost Rate

Where:
├─ Base Hourly Rate   = Employee's salary + social security / working hours
├─ Overhead Rate      = Infrastructure costs / total working hours / direct staff count
└─ Indirect Cost Rate = Indirect staff costs / total working hours / direct staff count

Employee Grades

Employees are assigned grades (e.g., Junior, Mid, Senior, Lead) which determine their base hourly rate. This allows for:

• Standardized pricing across employees of similar experience levels
• Simplified budget planning using grade-based rates
• Historical tracking of rate changes over time
• Flexible rate overrides when needed

3. How Costs Are Calculated - The Complete Flow

The system calculates project costs through a series of interconnected steps. Here's how everything flows together:

Step 1: Foundation - Salary & Expense Data

EXPENSE DATA (stored in configurable categories)
│
├─ Salaries & Social Security (e.g., account codes 9604, 9605)
│  ├─ Employee salaries
│  ├─ Social security contributions
│  ├─ Stored with: amount, currency, date, employee
│  └─ Used to calculate: Base hourly rates
│
├─ Infrastructure Overhead (configurable categories, e.g., excluding 602/1, 402/1, 604%, 605%)
│  ├─ Office rent
│  ├─ Utilities
│  ├─ Equipment
│  ├─ Software licenses
│  └─ Used to calculate: Overhead rate
│
└─ External Project Costs
   ├─ Contractors
   ├─ Materials
   ├─ Third-party services
   └─ Used in: External services cost

Step 2: Calculate Base Hourly Rates for Direct Staff

FOR EACH DIRECT COST EMPLOYEE, FOR EACH MONTH:

1. Get salary expenses (account codes 9604, 9605) for that month
2. Calculate working hours:
   
   Working Hours = (Calendar Days × 8 hours/day)
                   - Weekends
                   - Public Holidays
                   + Working Saturdays (if configured)
                   - Vacation Days
                   × Utilization Factor (optional)

3. Calculate base hourly rate:

   Base Hourly Rate = Total Salary Expenses (converted to target currency)
                      ─────────────────────────────────────────────────
                      Working Hours

4. Group by employee grade and calculate average per grade

Step 3: Calculate Overhead Rate

OVERHEAD CALCULATION (Infrastructure costs distributed across direct staff):

1. Sum all infrastructure expenses for last 12 months (configurable categories)
   - Exclude: Salaries, social security, and other configured categories
   - Include: Office costs, utilities, equipment, etc.

2. Calculate annual working hours:
   Annual Working Hours = (Working days in year) × 8 hours/day

3. Count direct cost staff currently active

4. Calculate overhead rate:

   Overhead Rate = Total Infrastructure Expenses (converted to target currency)
                   ─────────────────────────────────────────────────────────
                   Annual Working Hours × Number of Direct Staff

Note: This distributes infrastructure costs evenly across all direct staff hours

Step 4: Calculate Indirect Cost Rate

INDIRECT COST CALCULATION (Support staff costs distributed to direct staff):

1. For each indirect cost employee in the month:
   
   a) Get salary expenses (account codes 9604, 9605)
   
   b) Calculate working hours (WITHOUT utilization factor):
      Working Hours = Calendar Days × 8
                      - Weekends
                      - Holidays
                      - Vacation Days
   
   c) Calculate hourly rate:
      Indirect Employee Rate = Salary Expenses / Working Hours

2. Sum all indirect employee costs for the month

3. Get count of direct cost staff

4. Calculate indirect cost rate:

   Indirect Cost Rate = Total Indirect Staff Costs (converted to target currency)
                        ────────────────────────────────────────────────────
                        Number of Direct Staff × Average Working Hours

Note: This distributes support staff costs across billable staff

Step 5: Calculate Final Hourly Rates by Grade

COMPLETE HOURLY RATE PER GRADE:

For each employee grade (Junior, Mid, Senior, Lead, etc.):

   Final Rate = Base Hourly Rate (for that grade)
                + Overhead Rate
                + Indirect Cost Rate

These rates are:
├─ Calculated monthly
├─ Stored in the database for historical tracking
├─ Used for budget planning
└─ Can be overridden manually if needed

Rate Priority System:
When calculating costs, the system uses rates in this order:
1. Finalized rate for exact month (if exists)
2. Last finalized rate before the target month
3. Calculated rate based on current expenses

Step 6: Calculate Project Internal Costs

PROJECT INTERNAL RESOURCE COST (Actual time worked):

For each time tracking entry:

1. Get employee's hourly rate for that month (from stored rates)
2. Convert rate to target currency using transaction date
3. Add overhead rate for that month (if applicable based on methodology)
4. Add indirect cost rate for that month (if applicable based on methodology)
5. Multiply by hours worked

   Entry Cost = (Hourly Rate + Overhead Rate + Indirect Rate) × Hours Worked

Sum all entries for the project = Total Internal Cost

Step 7: Calculate Project Budgets

INTERNAL RESOURCE BUDGET (Planned hours):

For each budget line:
1. Get planned hours by grade (e.g., "50 hours of Senior Developer")
2. Get rate for that grade (using priority system: exact month → last finalized → calculated)
3. Convert rate to target currency
4. Calculate budget line:

   Budget Line = Planned Hours × Grade Rate (converted to target currency)

Sum all budget lines = Total Internal Budget


EXTERNAL SERVICES BUDGET:

Sum all planned external service costs (converted to target currency) = Total External Budget

Step 8: Track External Costs and Income

EXTERNAL SERVICES COST (Actual):
Sum all expenses assigned to project (converted to target currency)


INCOME:
Sum all invoice line items for project (converted to target currency)


CONTRACTED AMOUNT:
Sum all contract amounts for project (converted to target currency)

Step 9: Calculate Final Project Metrics

COMPLETE PROJECT FINANCIAL STATUS:

Total Cost = Internal Cost + External Cost

Total Budget = Internal Budget + External Budget

Remaining Internal Budget = Internal Budget - Internal Cost

Remaining External Budget = External Budget - External Cost

Budget Utilization % = (Total Cost / Total Budget) × 100

Gross Profit Margin (GPM) % = ((Income - Total Cost) / Income) × 100

4. Complete System Flow Diagram

Here's how all components connect to produce the final financial reports:

┌─────────────────────────────────────────────────────────────────────────────────┐
│                            RAW DATA SOURCES                                     │
└─────────────────────────────────────────────────────────────────────────────────┘
                                        │
              ┌─────────────────────────┼─────────────────────────┐
              │                         │                         │
              ▼                         ▼                         ▼
      ┌─────────────┐          ┌─────────────┐          ┌─────────────┐
      │   SALARY    │          │ OVERHEAD    │          │  INDIRECT   │
      │  EXPENSES   │          │  EXPENSES   │          │   STAFF     │
      │  (9604/05)  │          │ (infra cost)│          │  SALARIES   │
      └─────────────┘          └─────────────┘          └─────────────┘
              │                         │                         │
              │                         │                         │
              ▼                         ▼                         ▼
      ┌─────────────┐          ┌─────────────┐          ┌─────────────┐
      │   BASE      │          │  OVERHEAD   │          │  INDIRECT   │
      │   HOURLY    │          │    RATE     │          │  COST RATE  │
      │   RATE      │          │ CALCULATION │          │ CALCULATION │
      │             │          │             │          │             │
      │ Salary/Hrs  │          │ Infra/      │          │ Support/    │
      │ per employee│          │ (Hrs×Staff) │          │ DirectStaff │
      └─────────────┘          └─────────────┘          └─────────────┘
              │                         │                         │
              └─────────────────────────┼─────────────────────────┘
                                        │
                                        ▼
                        ┌───────────────────────────┐
                        │   RATES PER GRADE TABLE   │
                        │                           │
                        │  Grade  │  Complete Rate  │
                        │─────────┼─────────────────│
                        │ Junior  │  Base+OVE+ICR   │
                        │ Mid     │  Base+OVE+ICR   │
                        │ Senior  │  Base+OVE+ICR   │
                        │ Lead    │  Base+OVE+ICR   │
                        │                           │
                        │ Stored monthly            │
                        │ Can be finalized          │
                        │ Includes currency info    │
                        └───────────────────────────┘
                                        │
                ┌───────────────────────┼───────────────────────┐
                │                       │                       │
                ▼                       ▼                       ▼
        ┌─────────────┐     ┌─────────────┐     ┌─────────────┐
        │   TIME      │     │  INTERNAL   │     │  EXTERNAL   │
        │  TRACKING   │     │   BUDGET    │     │   BUDGET    │
        │             │     │             │     │             │
        │ Hours × Rate│     │ Planned Hrs │     │ Planned $   │
        │ + OVE + ICR │     │ × Grade Rate│     │ for external│
        │             │     │             │     │ services    │
        └─────────────┘     └─────────────┘     └─────────────┘
                │                       │                       │
                │                       │                       │
                ▼                       ▼                       ▼
        ┌─────────────┐     ┌─────────────┐     ┌─────────────┐
        │  INTERNAL   │     │  INTERNAL   │     │  EXTERNAL   │
        │   ACTUAL    │     │   BUDGET    │     │   BUDGET    │
        │    COST     │     │             │     │             │
        └─────────────┘     └─────────────┘     └─────────────┘
                │                       │                       │
                └───────────────────────┼───────────────────────┘
                                        │
                                        ▼
                        ┌───────────────────────────┐
                        │                           │
                        │  PROJECT FINANCIAL STATUS │
                        │                           │
                        │  • Total Cost             │
                        │  • Total Budget           │
                        │  • Budget Utilization %   │
                        │  • Income                 │
                        │  • Contracted Amount      │
                        │  • Gross Profit Margin %  │
                        │                           │
                        │  All in selected currency │
                        └───────────────────────────┘

5. Multi-Currency Support

One of the most powerful features of this system is the ability to track and report all financial data in multiple currencies with automatic conversion based on historical exchange rates.

How Currency Conversion Works

CURRENCY CONVERSION PROCESS:

For each monetary value (expense, salary, invoice, etc.):

1. Original amount is stored with:
   ├─ Amount (e.g., 1000)
   ├─ Currency (e.g., EUR)
   └─ Transaction date (e.g., 2024-06-15)

2. When displaying in target currency (e.g., USD):
   
   a) Look up exchange rate for transaction date (2024-06-15)
   b) Convert: EUR → USD using historical rate
   c) Display converted amount

3. For fixed exchange rates (e.g., BGN ↔ EUR = 1.95583):
   Use the fixed rate (Bulgarian Lev is pegged to Euro)

4. For other currencies:
   Use historical exchange rate table with daily rates

Where Currency Information Is Stored

Every financial record includes currency information:

• Expenses - Each expense has a currency field (e.g., office rent in EUR, contractor in USD)
• Time Tracking - Hourly rates stored with currency (from system settings at time of entry)
• Budgets - Budget lines stored with currency (internal and external)
• Invoices - Invoice amounts stored with currency
• Contracts - Contract amounts stored with currency
• Calculated Rates - Monthly overhead, indirect cost, and grade rates stored with currency

System Currency Setting

A system-wide setting determines the default currency for new entries:

Viewing Reports in Different Currencies

All financial reports accept a currency parameter, allowing you to view the same data in different currencies:

EXAMPLE: Project Financial Status in Different Currencies

View in BGN (Bulgarian Lev):
projects_financial_status(currency_id = 1)

View in EUR (Euro):
projects_financial_status(currency_id = 2)

View in USD (US Dollar):
projects_financial_status(currency_id = 3)

The system automatically converts ALL amounts:
├─ Internal costs (salary-based)
├─ External costs (expenses)
├─ Budgets
├─ Income
├─ Contracted amounts
└─ Calculated rates (overhead, indirect)

All using historical exchange rates for accuracy.

6. Automated Monthly Processes

The system includes automated tasks that run monthly to keep financial data up-to-date without manual intervention.

Monthly Rate Updates (Recommended: 3rd of each month)

Three automated processes calculate and store rates for the previous month:

Staff Snapshot Creation

At the start of each month, the system creates a snapshot of all active staff members, capturing:

• Personal information
• Current grade and classification
• Calculated hourly rate for that month
• Currency of the rate
• Department and manager information

These snapshots provide historical tracking of employee data and rates over time.

7. Rate Priority System - How Rates Are Selected

When the system needs a rate for calculations (overhead, indirect cost, or grade rate), it uses a three-tier priority system to ensure the most accurate rate is used:

RATE SELECTION PRIORITY (for any given month):

Priority 1: EXACT MONTH FINALIZED RATE
├─ Look for a stored rate for the exact month
├─ Must be marked as "final" (approved/confirmed)
├─ Convert from stored currency to target currency
└─ If found: USE THIS RATE ✓

Priority 2: LAST FINALIZED RATE BEFORE TARGET MONTH
├─ If no exact month rate exists
├─ Find the most recent finalized rate before the target month
├─ Convert from stored currency to target currency
└─ If found: USE THIS RATE ✓

Priority 3: CALCULATE RATE FROM CURRENT EXPENSES
├─ If no finalized rates exist
├─ Calculate rate based on actual expenses
├─ Use formulas described in Section 3
└─ USE THIS CALCULATED RATE ✓

This ensures:
├─ Finalized rates are always preferred (more stable, approved)
├─ Historical rates are used when exact month isn't finalized
└─ System always has a rate even for new months

Example Scenario

8. Configurable Calculation Methodology

The system supports different calculation methodologies to accommodate changing business processes. This allows you to adapt the system as your company evolves.

Methodology Transition Feature

You can configure the system to use different calculation methods for different time periods. For example:

EXAMPLE METHODOLOGY TRANSITION:

Before Transition Date (e.g., before March 2022):
Hourly Rate = Base Rate + Overhead Rate + Indirect Cost Rate
├─ Calculate all three components separately
├─ Add overhead and indirect costs to base rates
└─ Provides detailed cost breakdown

After Transition Date (e.g., after March 2022):
Hourly Rate = Static All-Inclusive Rate
├─ Use pre-defined rates that include all components
├─ Overhead Rate = 0 (already included in static rate)
├─ Indirect Cost Rate = 0 (already included in static rate)
└─ Simplified, more stable pricing

The system automatically:
├─ Applies the correct methodology based on transaction date
├─ Returns 0 for overhead/indirect when using static rates
└─ Maintains historical accuracy for old data

When to Use This Feature

• Switching pricing models - Moving from detailed cost-plus to fixed pricing
• Organizational changes - Restructuring how costs are allocated
• Simplification - Reducing calculation complexity while maintaining historical accuracy
• Compliance requirements - Meeting new accounting or reporting standards

9. Available Financial Reports

The system provides comprehensive reporting capabilities across all financial dimensions:

Main Dashboard: Project Financial Status

The primary financial report showing complete financial overview for all projects or specific projects:

• Internal Resource Budget - Planned cost of employee time
• Internal Resource Cost - Actual cost of employee time worked
• External Services Budget - Planned cost of external expenses
• External Services Cost - Actual external expenses
• Total Cost - Sum of all actual costs
• Total Budget - Sum of all planned costs
• Budget Utilization % - How much of budget has been used
• Income - Revenue from invoices
• Contracted Amount - Total contract value
• Gross Profit Margin % - Profitability percentage

Detailed Drilldown Reports

Internal Resource Drilldown - Shows detailed breakdown of all time worked:

• Project code
• Employee name
• Month
• Hours worked
• Hourly rate (base)
• Overhead rate
• Indirect cost rate
• Total rate (sum of all components)
• Total amount (hours × total rate)
• Employee grade

Infrastructure Expense Drilldown - Shows all overhead expenses:

• Recipient (vendor/provider)
• Amount
• Date
• Comment/description
• Project (if assigned)
• Account code
• Expense category
• Paying company

Rate Analysis Reports

Rates per Grade - Shows current average rates by employee grade

Indirect Cost Rate - Shows current indirect cost rate and direct staff count

Employee Salary Reports - Detailed salary breakdowns for direct and indirect staff showing expenses, working hours, and calculated hourly rates

Historical Reports

Rates per Month - Historical view of employee rates over time:

• Employee name and email
• Classification (direct/indirect)
• Grade
• Hourly rate
• Year and month
• All rates shown in selected currency with historical conversion

10. Technical Implementation Guide

This section provides guidance for implementing this financial system for a new client.

System Architecture Overview

The system is built on a layered architecture with clear dependencies:

FUNCTION DEPENDENCY LAYERS:

TIER 1: Foundation Functions
├─ Expense aggregation (infrastructure overhead)
├─ Direct staff salary calculations
└─ Indirect staff salary calculations

TIER 2: Rate Calculations
├─ Overhead rate calculation
├─ Indirect cost rate calculation
├─ Active overhead rate lookup (with priority system)
└─ Active indirect cost rate lookup (with priority system)

TIER 3: Grade Rates
├─ Active grade rate lookup (with priority system)
└─ Grade rate generation for next month

TIER 4: Project Calculations
├─ Internal resource drilldown (time × rates)
└─ Project internal cost summation

TIER 5: Main Financial Reports
├─ Project financial status (complete dashboard)
└─ All supporting reports

TIER 6: Automated Tasks
├─ Monthly overhead update
├─ Monthly indirect cost update
├─ Monthly grade rate generation
└─ Monthly staff snapshot creation

Database Schema Requirements

The following tables require currency columns:

Required Master Data Tables

• currency - List of supported currencies with exchange rates
• bnb_currency_history - Historical exchange rates (optional, can use fixed rates)
• grades - Employee grade classifications
• staff - Employee master data with classification (direct/indirect)
• staff_classification - Direct vs. indirect staff types
• expense_categories - Configurable expense categories
• holidays - Public holiday calendar
• settings - System configuration (including default currency)

Key Configuration Parameters

These settings must be configured for each new client:

Implementation Steps

RECOMMENDED IMPLEMENTATION SEQUENCE:

Phase 1: Database Preparation
1. Add currency columns to all required tables
2. Populate currency master data
3. Set up expense categories and account codes
4. Configure staff classifications
5. Set default currency in system settings

Phase 2: Deploy Foundation Functions (Tier 1)
1. expenses_ipa_infra_last_twelve_months(p_currency)
2. salaries_and_securities_rate_direct_cost_by_date(date, p_currency)
3. salaries_and_securities_rate_indirect_cost_by_date(date, p_currency)
→ Test each function with sample data

Phase 3: Deploy Rate Calculation Functions (Tier 2)
1. overhead_expenses(p_currency)
2. rate_indirect_cost_by_date(date, p_currency)
3. active_ove(date, p_currency)
4. active_icr(date, p_currency)
→ Test rate calculations for accuracy

Phase 4: Deploy Grade Rate Functions (Tier 3)
1. active_rate_per_grade(date, grade, p_currency)
2. Update generate_rates_per_grades() to include currency
3. Update rates_per_grade_custom_bf() trigger
→ Test with actual employee grades

Phase 5: Deploy Project Functions (Tier 4-5)
1. projects_internal_resource_drilldown(p_currency)
2. convert_hours_to_money_by_project(project_id, p_currency)
3. projects_financial_status(p_currency)
→ Test with real project data, verify performance

Phase 6: Deploy Report Functions
1. rate_per_grade(p_currency)
2. rate_indirect_cost_table(p_currency)
3. salaris_and_securities_per_employee_previous_month_direct(p_currency)
4. salaris_and_securities_per_employee_previous_month_indirect(p_currency)
5. expenses_ipa_infra_last_twelve_months_drill_down(p_currency)
6. rates_per_month(p_currency)
→ Test all reports for correct data display

Phase 7: Deploy Automated Tasks
1. icr_monthly_update(rec_id)
2. ove_monthly_update(rec_id)
3. staff_snapshots_monthly_update(rec_id)
→ Schedule for 3rd of each month
→ Run manually first to verify

Phase 8: Create Database Indexes
1. Add performance indexes on frequently queried columns
2. Index all foreign key relationships
3. Index currency columns
4. Index date columns used in filtering
→ Test query performance improvements

Phase 9: UI Integration
1. Update reports to call functions with currency parameter
2. Add currency selector to UI
3. Update budget entry screens to capture currency
4. Test all user workflows
→ Verify backward compatibility

Phase 10: Data Migration & Validation
1. Populate currency columns for historical data
2. Run historical calculations for validation
3. Compare new vs old reports for accuracy
4. Fix any discrepancies
→ Get client sign-off on accuracy

Performance Optimization

The system includes several optimizations for handling large datasets:

• Currency Name Caching - Loads all currency names once at query start instead of subquery per row
• Monthly Rate Pre-calculation - Calculates overhead/indirect rates once per month, not per row
• CTE-based Aggregation - Uses Common Table Expressions to batch calculations
• Early Filtering - Filters data at source before expensive calculations
• Strategic Indexing - Indexes on all join columns and frequently filtered fields

11. Adapting the System for Different Clients

While the core calculation logic remains consistent, several aspects of the system can and should be customized for each client's specific needs.

Common Customization Points

Questions to Ask Each New Client

Before implementation, gather this information from the client:

CLIENT DISCOVERY QUESTIONNAIRE:

Financial Structure:
□ What account codes do you use for salaries and social security?
□ What expenses should be considered infrastructure overhead?
□ Do you have different cost centers or departments?
□ How do you currently calculate project profitability?

Currency Requirements:
□ What currencies do you operate in?
□ What is your primary (home) currency?
□ Do you need historical exchange rates or fixed rates?
□ How often do you need to see reports in different currencies?

Employee Structure:
□ How do you classify employees (grades, levels, titles)?
□ Which employees work directly on billable projects?
□ Which employees are in support/overhead roles?
□ How do you calculate working hours? (hours/day, holidays, etc.)
□ Do you use utilization factors or target billability?

Calculation Methodology:
□ How do you currently calculate hourly rates?
□ Do you separate overhead and indirect costs or bundle them?
□ Have your calculation methods changed over time?
□ Do you need to support multiple methodologies for different periods?

Reporting Needs:
□ What financial reports do you currently use?
□ What metrics are most important? (GPM, utilization, etc.)
□ Who needs access to which reports?
□ How often do you review financial performance?

Technical Environment:
□ What database system are you using?
□ Do you have existing integrations (accounting, HR, etc.)?
□ What is your data volume? (number of projects, employees, transactions)
□ What are your performance requirements?

Testing Strategy for New Implementation

Thorough testing is critical for financial systems. Follow this testing approach:

12. Best Practices & Recommendations

Data Entry Best Practices

• Currency Consistency - Enter expenses in their original currency, not converted. The system handles conversion automatically.
• Timely Time Tracking - Encourage employees to log time promptly for accurate project costing.
• Expense Categorization - Properly categorize expenses for accurate overhead calculations.
• Budget Updates - Keep project budgets up-to-date as scopes change.
• Rate Finalization - Review and finalize monthly rates promptly (within first week of new month).

Monthly Maintenance Tasks

Security & Access Control

Financial data is sensitive. Implement appropriate access controls:

• Role-Based Access - Different user roles should see different levels of detail
• Project Managers - Can view financial status of their projects only
• Finance Team - Can view all financial data and finalize rates
• Executives - Can view all reports and profitability metrics
• Employees - Should not see cost rates or profitability data
• Audit Trail - Log all changes to rates and financial data

Common Pitfalls to Avoid

13. Summary

This financial management system provides a comprehensive solution for project-based businesses to:

• Accurately calculate the true cost of employee time including salaries, overhead, and support staff
• Track and manage project budgets against actual costs
• Analyze project profitability with Gross Profit Margin calculations
• Support multiple currencies with automatic historical conversion
• Generate detailed financial reports at project, employee, and company levels
• Automate monthly rate calculations for consistent and timely updates
• Adapt to different calculation methodologies as business processes evolve

The system is built on a solid technical foundation with:

• Layered architecture for maintainability and extensibility
• Performance optimization for handling large data volumes (600,000+ records in ~4 seconds)
• Flexible configuration to adapt to different clients' needs
• Historical accuracy through date-based exchange rate conversion
• Priority-based rate selection ensuring the most accurate calculations