Lending organizations consolidate daily debit transactions into auto-generated files (typically Excel format). With thousands of machines and hundreds of thousands of records per day, manual reconciliation to the balance level is laborious and error-prone.