How do you manage a number of employers, members, and union dues in a quick and efficient manner? By using a custom database solution, of course!


Unions must collect dues from employers, which means tracking how much they should pay, for whom and when. This union was using an antiquated system that would cost too much to upgrade.


The system was simply not designed to handle the needs of the union and was actually costing them money in lost dues. A new system was needed that could track cash flows and reconcile employer checks.


IT Impact, Inc. created a Microsoft Access database linked to a SQL Server for data storage. The system allows the union to track if the employers owed them union dues by reconciling an employer check against what the dues should have been for the payroll period. It also provides membership information to all union members which is great when handling calls.


Sometimes the best way to handle a company’s business is through a custom solution. In this case it not only made economic sense, but the union also gained an application designed for their specific needs.