I D H A M .
Published on

iPlan PT. PJB

Budget Management & Monitoring App – PT. Pembangkit Jawa-Bali

This application was built to support the budgeting and budget control process at PT. Pembangkit Jawa-Bali. It serves key divisions such as the budgeting team, control team, and project units, with the main goal of standardizing and simplifying the budget submission process that was previously done manually via various inconsistent Excel templates.

Background and Purpose

Before this app was introduced, each business unit submitted their budget plans using different Excel formats, making consolidation difficult and error-prone. The app solves this problem by providing a standard Excel template for all units, which can be uploaded into the system and processed automatically.

With this system:

  • All units use a standardized budgeting template.
  • File validation occurs upon upload, referencing a configurable Excel Setting.
  • Uploaded data is automatically transformed into dashboards and reports.

Key Features

  • Budget Excel Upload:
    Units create their budget plans using a standard Excel file, then upload it to the system. The system validates the file structure and content based on an Excel Setting configuration. Upload fails if the file does not comply.

  • Dynamic Excel Setting Configuration:
    Admins can define and adjust how the system should interpret incoming Excel files—including which sheets, rows, and columns to read—through SQL-like queries.

  • Monitoring Dashboards:
    The system provides several dashboards for financial and project oversight:

    • Budget Dashboard
    • Control Dashboard
    • Profit and Loss Dashboard
    • Risk Profile Dashboard

  • Integration with External System (Elipse):
    The app integrates with external systems like Elipse to retrieve actual spending data, enabling real-time comparison between planned and actual budgets. Though the technical integration method (possibly via triggers) is not clearly recalled, it was designed to run automatically.

  • Automated Calculations:
    Uploaded data is processed according to the defined queries in the Excel Setting, producing reports and insights without the need for manual recalculation.

Tech Stack

  • Backend: Laravel
  • Database: PostgreSQL

Role and Development

I contributed to this project as a programmer, handling core features such as Excel parsing, validation mechanisms, and dashboard logic. The project was done collaboratively within a development team involving analysts and QA members.

While the current status of the app is unknown (as it's an internal system), the experience of building a large-scale, data-intensive application with integration and automation has been a significant milestone in my development journey.