Cheque Balancing System
A system needed to be written to aid in balancing cheque deposits since there was no accounting system in place and the manual system was too cumbersome. However an existing computer system recorded the expected receivables that would be transmitted by EFT (Electronic Funds Transfer), and exported these transactions into an ASCII file. A second computer system existed that recorded cash receipts and cheques received by mail, and maintained these in a Clipper database. The bank allowed downloading of actual bank transactions.
The system was developed in FoxPro for Windows. It received ASCII transactions from the first system and kept them in a FoxPro database. The database from the Clipper system could be read directly from FoxPro, and new transactions copied into FoxPro. The bank transactions were downloaded and also converted into FoxPro.
At any time, there would always be transactions out of sync, so the new system had to attempt to match as automatically as possible and warn of any unbalanced transactions that were stale dated. In addition the was no way of cross matching the EFT transfers by a transaction number, so the system created matches by using the dollar amounts and the dates to create a best match algorithm. To make the problem more complex, the Clipper system had manual data entry of cheques, and would have data entry errors in the cheque amounts and dates, so the new system also tried to match these also, while allowing operator confirmation of possible matches.
Platform and Tools
Windows 3.1, FoxPro for Windows, Clipper