Liquidation Tracker

Finance teams managing multiple plant operations often struggle with a fragmented expense management process. Invoices arrive through different channels, cash advances are tracked manually, and liquidation reports require tedious reconciliation — all handled through spreadsheets, email threads, and paper-based forms.

The Check Request Form (CRF) process is particularly labour-intensive. Each recurring bill requires someone to manually fill out a PDF template, verify vendor details, confirm billing periods, route the form through multiple levels of approval, and track payment status — a process prone to delays, lost documents, and inconsistent formatting.

Without a centralized system, there is no visibility into what bills are pending approval, which ones are overdue, or who is responsible for each step. Approval bottlenecks directly impact payment timelines and vendor relationships.

I designed and built a full-stack financial operations platform that centralizes invoice management, cash advance requests, liquidation reporting, and recurring bill processing into a single web application with role-based access control and automated approval workflows.

The system handles the complete lifecycle of financial documents — from initial submission through multi-level approval, CRF generation, payment tracking, and audit logging. Each action is recorded with timestamps and user attribution, creating a full audit trail for compliance.

For recurring bills, the platform implements a structured five-step approval pipeline: an employee submits the bill, a supervisor reviews and approves, a manager provides secondary approval, a CRF Creator generates the official Check Request Form PDF, and the bill moves to payment processing. Rejection at any stage returns the bill with remarks for correction.

The CRF PDF is auto-generated from a standardized template, pulling vendor details, invoice numbers, billing periods, plant codes, and amounts directly from the database — eliminating manual form filling and ensuring consistent formatting across all requests.

A dedicated approval dashboard provides supervisors and managers with real-time visibility into pending approvals, overdue items, and approval statistics. The dashboard is built as a Progressive Web App (PWA), allowing approvers to access it from their mobile devices and install it directly on their home screen without requiring an app store.