1264-UC Catching Billing Errors Before They Reach Accounting
Location
https://campus.kennesaw.edu/colleges-departments/ccse/events/computing-showcase/fa26-cday-program.php
Document Type
Event
Start Date
20-11-2026 2:00 PM
Description
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.
1264-UC Catching Billing Errors Before They Reach Accounting
https://campus.kennesaw.edu/colleges-departments/ccse/events/computing-showcase/fa26-cday-program.php
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.