Adjustment Report Tool

Overview

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.

Single-click processing takes over entire workflow—produces Google Sheet documentation plus all database statements (INSERT, rollback, verification) for DB Access.

Features

Core capabilities for adjustment processing.

• Request Standardization - Normalizes various input formats
• SQL Generation - Creates INSERT statements automatically
• Rollback Statements - Generates undo scripts for safety
• Verification Queries - Confirms changes were applied correctly
• Google Sheet Documentation - Matches required format
• Single-Click Processing - Complete workflow automation

Usage

Streamlined operation.

• Paste or enter adjustment request data
• Click "Process" button
• Review generated SQL and documentation
• Copy SQL to DB Access, documentation auto-saved to Sheet

Results

Efficiency improvements.

Technology Stack

Technologies used.

• Google Apps Script - Backend
• HTML5/CSS3 - Interface
• JavaScript - Logic
• SQL - Statement generation