Web app that processes financial adjustment requests in a single click, producing both Google Sheet documentation and database INSERT statements with rollback and verification queries.
Stack
Google Apps Script · HTML5/CSS3
Status
Production
Impact
Single Click
Scope
Full Process
The problem
What it replaced.
Team had highly manual process copying bits of data into formula spreadsheets. Many daily requests came in different formats with no standardization.
before · the manual waymanual
›time 10-20 min
›process Manual copy-paste
›format Inconsistent
The work this took off the team’s plate.
The approach
How it works.
Single-click processing that takes over entire workflow—produces Google Sheet documentation they required plus all database statements (INSERT, rollback, verification) for DB Access.
What it does
+Request standardization
+SQL generation
+Rollback statements
+Verification queries
How a run flows
Before / after
Time per request
Proven, not trusted
Verified before it ships.
The rules that produce these numbers are written as tests and run on every change — and every run, success or failure, writes to the record.
vitest run
✓ generates insert, rollback, and verification SQL
✓ writes an audit row on success and on error
every request reproducible from the trail
Built with
The same discipline, this tool’s stack.
Google Apps Script · HTML5/CSS3 · JavaScript · SQL