The problem
Implementing precise FIFO logic for fluctuating currency rates without degrading performance or breaking consistency across hundreds of daily transactions.
What I built
Developed optimized SQL functions that maintain FIFO stacks and reconcile discrepancies automatically through a “self-healing” routine. Combined with rate caching and lightweight reporting views to ensure instant updates.
- Secure
- RLS
- Mobile Friendly
- Google Oauth
- Fast Loading
- Automate Report Generation
- FIFO COGS calculation
- True to accounting
Results
PT JPB gained audit-grade accuracy in cost and valuation, real-time visibility of daily forex positions, and simplified workflows. The design reduced human error and training time, turning a manual ledger operation into a robust, automated system.
Screens
The system as the team uses it. Click a screen to see it full size.
Stack
Click a tool to see everything else I've built with it.
