Government – Financial Reconciliation

BPKAD Kabupaten Tanah Laut

The previous SIREKA system had generic upload scheduling, limited user guidance, no document status visibility, manual admin monitoring, unstructured document management, and inefficient one-by-one document downloads.

Metric

21 new features across 5 capability areas

Result

Transformed SIREKA into a configurable, period-based, and organization-aware document submission platform with scheduling engine, document matrix, monitoring workspace, checklist-based upload, and batch operations.

Product Used

SIREKA 2.0

Highlights

Period-specific upload scheduling (monthly, quarterly, semester, yearly)
Dynamic document matrix by period and applicability
Organization-based monitoring workspace for SKPD and BLUD
Checklist-based upload status with deadline countdown
Manual upload and bulk upload with file naming guide
Batch document selection and download

SIREKA 2.0 is an upgraded financial reconciliation and reporting platform developed for BPKAD Kabupaten Tanah Laut. The project evolved the existing SIREKA system from a general document upload tool into a structured, period-aware, and organization-specific reporting platform.

The upgrade focused on solving operational gaps in upload scheduling, document governance, user guidance, admin monitoring, and document access — transforming SIREKA into a more complete financial reporting management system.

The Problem

SIREKA 1.0 already supported digital document submission for financial reconciliation. But as reporting requirements grew more complex, several limitations became clear.

Generic upload scheduling

The previous upload schedule model was too broad. In practice, BPKAD manages reports across monthly, quarterly, semester, and yearly cycles — each with different deadlines and document requirements. The old system could not represent this complexity.

Limited user guidance

SKPD and BLUD users had no clear view of which reporting period was active, what deadline applied, which documents were required, or which had already been uploaded. They relied on manual follow-up from BPKAD.

No document status visibility

The system lacked visual indicators to show whether each required document had been uploaded or was still missing. Users had to guess their completion status.

Manual admin monitoring

BPKAD administrators could not quickly answer basic questions: which SKPD has uploaded? Which BLUD has not? Which documents are complete? Every check required manual investigation.

Unstructured document management

Document types were not grouped by reporting period or organization applicability. SKPD and BLUD may have different reporting requirements, but the system did not distinguish between them.

Inefficient document downloads

Downloading submitted documents one by one was time-consuming, especially when reviewing or archiving across many organizations and periods.

The Solution

Scheduling engine

Period-specific upload scheduling

4 period types

BPKAD can create upload schedules based on actual financial reporting cycles — each with its own name, year, period type, start date, end date, and active status.

Period 1

Monthly

Upload windows for monthly financial reports. Each month gets its own schedule with specific deadlines.

Period 2

Quarterly

Covers Q1 through Q4 reporting. Each quarter can have different document requirements and deadlines.

Period 3

Semester

For mid-year and end-of-year consolidated reports. Supports semester-based document grouping.

Period 4

Yearly

Annual reporting period for comprehensive financial statements and year-end documentation.

Active schedule controls when users can upload

SIREKA 2.0 redesigned the reporting workflow into a configurable, period-based, and organization-aware platform. BPKAD administrators can now manage upload schedules based on specific reporting periods, configure document types with precise rules, monitor upload progress per organization, and download selected documents in bulk.

Period-specific scheduling

The scheduling engine supports four period types: monthly, quarterly, semester, and yearly. Each schedule has its own name, reporting year, start date, end date, and active status. This gives BPKAD precise control over when each type of report can be submitted.

Dynamic document requirements

Document requirements are generated dynamically based on organization type, reporting period, document category, and document applicability. Users only see documents that are relevant to their organization and the current reporting period.

Document governance

Document matrix by period and applicability

Dynamic rules

Each document type is configured with period applicability and organization applicability — the system only shows relevant documents to each user.

Document TypeMonthlyQuarterlySemesterYearlySKPDBLUD
RKA SKPD
DPA SKPD
RKBLUD
Document TypeMonthlyQuarterlySemesterYearlySKPDBLUD
Laporan Realisasi Belanja
SPJ Belanja
Laporan Operasional BLUD
Document TypeMonthlyQuarterlySemesterYearlySKPDBLUD
Laporan Realisasi Pendapatan
SPJ Penerimaan
RequiredNot required

Each document type can be configured to apply to:

  • SKPD only — documents required only for SKPD units
  • BLUD only — documents required only for BLUD units
  • Both SKPD and BLUD — shared document requirements

Documents can also be grouped by category (planning, expenditure, revenue) and filtered accordingly.

Admin Monitoring

Admin workspace

Organization-based monitoring

SKPD & BLUD

Admins can select an organization from a side panel and view its complete reporting status — uploaded documents, missing documents, and progress across all periods.

Organizations

Search SKPD or BLUD...

Dinas Pendidikan

SKPD · 2025

partial

Uploaded

12

Missing

3

Completion

80%

Progress Per Period
Jan
3/3
Feb
3/3
Mar
2/3
Apr
3/3
May
1/3

SIREKA 2.0 provides a dedicated monitoring workspace for BPKAD administrators. Admins can browse organizations from a side panel and view document status in the main workspace.

For each organization, admins can see:

  • Organization profile and type (SKPD or BLUD)
  • Reporting year and available periods
  • Uploaded documents and missing documents
  • Document status per period
  • Progress indicators across monthly, quarterly, semester, and yearly cycles

The workspace supports both high-level summary views and period-specific detail views. Admins can switch from summary into a specific month or quarter to review submitted documents.

Multiple document selection and batch download

Admins can select multiple submitted documents and download them together. This is especially useful for periodic review, internal archiving, offline validation, and audit preparation.

User Upload Experience

User experience

Upload workflow with document checklist

Guided upload

SKPD and BLUD users see a clear upload interface with active schedule info, deadline countdown, required document list, and checklist-based status tracking.

Active Schedule

Monthly — June 2025

Upload Deadline

30 Jun 2025, 23:59 WITA

Document Status
22

Laporan Realisasi Belanja

Expenditure

Uploaded

SPJ Belanja

Expenditure

Uploaded

Laporan Realisasi Pendapatan

Revenue

Not Uploaded

SPJ Penerimaan

Revenue

Not Uploaded

Laporan Arus Kas

Planning

Ready to Upload

Manual Upload

Upload one document at a time with card-based interface

Bulk Upload

Upload multiple files with automatic name-based matching

For SKPD and BLUD users, SIREKA 2.0 provides a more guided upload experience with:

  • Active schedule information — which reporting period is currently open
  • Deadline countdown — real-time timer showing remaining days, hours, minutes, and seconds
  • Upcoming schedule list — future upload periods so users can prepare early
  • Document status checklist — visual indicators showing uploaded, missing, and ready-to-upload documents
  • Category filtering — focus on relevant document categories

Upload methods

SIREKA 2.0 supports two upload methods:

Manual upload provides a card-based interface where each required document has its own upload area. This is useful for submitting a specific report or replacing a single file.

Bulk upload allows users to submit multiple documents at once. The system uses a file naming convention to match uploaded files to predefined document types. The naming guide modal explains the required format:

[Document Number]-[Document Name]
Example: 01-Laporan Realisasi Belanja.pdf

Supported separators include hyphens, underscores, and dots.

Key Features

Capabilities

Key features of SIREKA 2.0

21 features

SIREKA 2.0 introduces a comprehensive set of features covering scheduling, document governance, monitoring, upload experience, and admin operations.

Monthly Schedules

Upload windows for monthly financial reports

Quarterly Schedules

Q1 through Q4 reporting periods

Semester Schedules

Mid-year and year-end consolidated reports

Yearly Schedules

Annual reporting for comprehensive statements

Deadline Countdown

Real-time countdown showing remaining time

Document Type Management

Admin-configurable document types and rules

Period Grouping

Documents grouped by applicable reporting period

Applicability Grouping

SKPD-only, BLUD-only, or shared documents

Category Filtering

Filter by planning, expenditure, revenue categories

Organization Workspace

Side panel with SKPD and BLUD selection

Summary View

Progress across multiple periods per organization

Period Detail View

Switch to specific month, quarter, or semester

Dashboard Monitoring

Overview of compliance rates and activity

Checklist Status

Visual indicators for each required document

Manual Upload

Card-based upload for specific documents

Bulk Upload

Multiple file upload with name-based matching

Naming Guide

File naming convention for auto-recognition

Batch Download

Select and download multiple documents

Simplified Interface

Streamlined admin dashboard and navigation

Role-Based Access

Separate access for admin, SKPD, BLUD roles

Before vs After

System upgrade

SIREKA 1.0 vs SIREKA 2.0

Generic Schedule

One broad upload schedule for all periods

Basic Upload

Simple file upload without document structure

Limited Visibility

No checklist or completion tracking

Manual Monitoring

Admin checks each SKPD individually

Single Download

Download documents one by one

Fixed Configuration

Document types hardcoded in system

SIREKA 1.0 handled basic document upload but lacked period-specific scheduling, document governance, and structured monitoring.

The upgrade transformed SIREKA from a basic document upload system into a comprehensive reporting management platform:

Before SIREKA 2.0

  • One generic upload schedule
  • No period-specific configuration
  • No document status indicators
  • Manual admin monitoring per SKPD
  • One-by-one document downloads
  • No document applicability rules
  • No category-based filtering

After SIREKA 2.0

  • Four period types with independent schedules
  • Configurable document matrix by period and applicability
  • Checklist-based upload status with countdown
  • Organization-based monitoring workspace
  • Batch document selection and download
  • SKPD and BLUD document separation
  • Category filtering (planning, expenditure, revenue)

Impact

More accurate schedule control

BPKAD can manage upload windows based on actual financial reporting cycles instead of using one generic schedule.

Better reporting governance

Document types can be configured based on period, category, and applicability — making requirements more structured and easier to maintain.

Clearer user guidance

SKPD and BLUD users can see active schedules, deadlines, required documents, and upload status without needing manual confirmation from BPKAD.

Faster document submission

Manual upload supports specific document submission, while bulk upload speeds up multi-document reporting.

Reduced manual follow-up

Checklist indicators, deadline information, and status panels reduce the need for repeated confirmation through WhatsApp, email, or phone calls.

Easier admin review

Admins can monitor organization status, view uploaded documents, select multiple files, and download them in bulk — reducing operational friction.

Improved compliance monitoring

BPKAD can quickly identify organizations that have uploaded, not uploaded, or partially completed their reporting obligations.

Better audit readiness

Structured document storage, period-based grouping, and batch download make it easier to prepare documents for review, reconciliation, and audit processes.

Technical Highlights

Configurable Scheduling Engine

Each schedule is stored and managed independently, allowing BPKAD to activate different upload windows according to administrative needs.

Dynamic Document Requirement Engine

Document requirements are generated based on organization type, reporting period, document category, document applicability, and active schedule — ensuring users only see relevant documents.

Organization-Aware Reporting Model

The system separates SKPD and BLUD reporting flows while keeping them under one unified platform.

Status Tracking System

Each document has a submission status displayed to both users and admins, supporting completion indicators, missing document detection, and progress monitoring.

Bulk Upload Mapping

Bulk upload uses a file naming convention to map uploaded files to predefined document types, reducing manual selection and improving efficiency.

Batch Document Operations

Admins can perform batch actions such as selecting multiple documents and downloading them together, improving efficiency when handling large volumes of files.

Role-Based Access Control

Access is separated by user roles: Admin BPKAD, SKPD user, BLUD user, and monitoring user. Each role receives access to features matching its responsibility.

My Role

As the solution architect and full stack developer, I was responsible for designing and implementing the SIREKA 2.0 upgrade, including:

  • Business process analysis and upgrade planning
  • Period-based upload schedule design and implementation
  • Document type management with period and applicability rules
  • SKPD and BLUD monitoring interface
  • Organization-based reporting workspace
  • Summary and period-specific report views
  • Upload status tracking with checklist indicators
  • Manual and bulk upload flows
  • File naming guide for automatic document recognition
  • Multiple document selection and batch download
  • Dashboard monitoring
  • Role-based access control
  • Backend workflow implementation
  • Database structure design
  • UI/UX improvement
  • Deployment and maintenance

Summary

SIREKA 2.0 transforms the original SIREKA platform into a configurable, period-aware, and organization-specific reporting system. The upgrade introduces configurable upload schedules, a dynamic document matrix, organization-based monitoring, checklist-based upload status, flexible upload methods, and batch document operations.

The platform helps BPKAD improve reporting governance, reduce manual follow-up, accelerate document review, and monitor compliance across government organizations more efficiently — turning a basic upload tool into a complete financial reporting management system.

Have a workflow or system to build?

Let's discuss your current operational challenges and how software can help.