1264-UC Catching Billing Errors Before They Reach Accounting
Our sponsor, a nonprofit serving the affordable-housing industry, prepares client billing in spreadsheets and imports it into Sage 50 accounting. A single malformed row can reject an entire import without saying which row failed. Our team is building a web application that carries billing from work entry through review and approval to export. A validation gate checks every approved line against nine documented import-failure conditions and names each failing row before any file is produced. Receipts are filed by property and merged into one packet with category totals. The validation engine, CSV generation, and receipt handling run today, with a sample-data sandbox for sponsor testing. Hosted integration, role testing, and a real import remain for the final phase.
Authors
- Patrick Barrios
- Kaeden Lee
- Kabya Mugdho
- Jaleelah Bachou
- Connor Perestuk
Publication Details
- Journal
- DigitalCommons - Kennesaw State University (Kennesaw State University)
- Published
- 2026-11-20
- Primary Topic
- Engineering and Information Technology
- Type
- article
- Field-Weighted Citation Impact
- 0.00