09/12/2025
Proposed LGU Financial & Administrative System Functionalities
(COA-Compliant, Fully Integrated, LGU-Ready)
1. Budget Management
Annual Budget Preparation
AIP (Annual Investment Plan) Encoding
Real-time Budget Utilization Tracking
Registry of Appropriations, Allotments & Obligations
Supplemental Budget & Adjustments
Departmental Budget Dashboard
2. Accounting & Financial Recording
COA-Compliant Chart of Accounts
Automatic Journal Entry Vouchers (JEV)
Accounts Payable & Accounts Receivable
Trust Fund & General Fund Segregation
Financial Ledger & Subsidiary Ledgers
Generation of Financial Statements (FAR, Trial Balance, BIR, COA reports)
3. Procurement & Supply Chain
PR, RFQ, Abstract, PO, Inspection & Acceptance
Supplier Database & Performance Tracking
Transparency Logs (for COA review)
Inventory & Asset Management
Contract Monitoring & Expiry Alerts
4. Disbursement & Payment Processing
Obligation Request (OBR) Automation
Disbursement Voucher (DV) Preparation
Cash Advances, Liquidations & Replenishments
Payroll (Plantilla, JO, COS)
Automated Deduction Computation (GSIS, PHIC, HDMF, Tax)
5. Treasury & Revenue Collection
Official Receipt (OR) Management
Real-time Collection & Deposit Tracking
Cashflow Monitoring
Bank Reconciliation
Daily, Monthly & Quarterly Treasury Reports
6. Internal Audit & Compliance
Audit Trail Logs (User actions & edits)
Document Validation Flow
COA-Compliant Report Generation
Risk Alerts for Duplicate, Over-obligated, or Excessive Transactions
7. Executive Dashboard (for Mayor, Accountant, Budget Officer)
Live Budget vs Actual Spending
Real-time Cash Position
Project Status & Fund Utilization
Department Performance Scores
8. Citizen & Transparency Features (Optional Add-On)
Online Citizen Portal for Requests/Concerns
Public Procurement Transparency Board
Digital Notice of Awards / Purchase Orders
9. HR & Payroll (Optional Expansion)
Plantilla Management
Leave Management
JO/COS Contract Monitoring
Biometric-Integrated Attendance
10. Document Management System
Digital Filing Cabinet
Paperless Routing (Budget → Accounting → Treasury → Mayor)
Document Version Control
Secure Backup & Archiving
