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

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
Controls
|||
ALL TIME
JAN
FEB
MAR
APR
MAY
JUN
JUL
AUG
SEP
OCT
NOV
article

1264-UC Catching Billing Errors Before They Reach Accounting

Patrick Barrios, Kaeden Lee, Kabya Mugdho, Jaleelah Bachou et al.
DigitalCommons - Kennesaw State University (Kennesaw State University)
Engineering and Information Technology
article

1264-UC Catching Billing Errors Before They Reach Accounting

Patrick Barrios, Kaeden Lee, Kabya Mugdho, Jaleelah Bachou, Connor Perestuk
article en

Abstract

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.

DigitalCommons - Kennesaw State University (Kennesaw State University)
Engineering and Information Technology
AI Navigator

Ask Laika to Summarize, Analyze, and Connect papers live on the map.

Summarize Papers & Methodologies

Extract key findings, datasets, and comparative methods across publications.

Benchmark Rankings & Visual Analytics

Rank top research institutions, authors, funders, topics, and journals by Field-Weighted Citation Impact (FWCI) and paper volume with instant charts.

Connect Distant Disciplines

Bridge topological clusters on the map to find hidden collaborative intersections.

Laika access coming soon