Clancy Construction

SSG Project Case Study

A Strategic Transformation with
Advanced Business Manager (ABM) Accounting System

Clancy Construction has a rich history dating back to 1947. With over 75 years of experience, the company has built a reputation for delivering services that are tailored to meet specific client needs. Their extensive portfolio spans a range of sectors including:


  • Residential
  • Student Accommodation
  • Commercial
  • Healthcare
  • Conservation and Restoration
  • Education
  • Hospitality


This broad range of expertise has been key to their growth, always aligning with their core values: Safety, Professionalism, Collaboration/Teamwork, Quality, Commitment/Loyalty, and Sustainability.



Challenge


In 2006, Clancy Construction faced a significant challenge: their legacy accounting software was becoming obsolete and could no longer meet the company's growing needs. The existing system lacked sophisticated job costing features and wasn't compatible with Windows, creating inefficiencies that were increasingly difficult to manage. Furthermore, the payroll system required manual input, which was time-consuming and error-prone. The company’s structure—with multiple companies under its umbrella—also meant diverse reporting requirements at both the office and site levels, making the need for a new system even more pressing.


The specific challenges included:


  • Lack of Integration:
    The existing system did not integrate payroll costs with the job costing ledger, creating inefficiencies.

  • Multi-Company Reporting:
    The legacy system couldn't handle the reporting needs across multiple companies and management levels.

  • Data Migration:
    Migrating a vast amount of historical data to a new system was a daunting task.

 

 

Solution


Clancy Construction decided to implement the Advanced Business Manager (ABM) Accounting System in 2006. This solution was chosen for its robust functionality, including job costing, multi-company database structures, and seamless integration with payroll systems.


Key steps in the solution implementation included:


1. Multi-Company Database Structure:

  • Established several companies within the ABM system.
  • Structured databases to ensure reports were accessible at both office and site levels, allowing real-time access to costing information.
  • Enabled budget tracking against actuals at daily, monthly, yearly, or job levels.


2. Database and Data Migration:

  • Created a comprehensive database within ABM Accounting.
  • Imported Masterfile data and outstanding balances into the new system, ensuring full reconciliation with existing ledgers.
  • Deployed the ABM Accounting database on-site, providing a robust and scalable solution.


3. Quantum Payroll Integration:

  • Introduced in 2015 to replace the outdated payroll system from 2006.
  • Developed an integration that met the growing needs of Clancy Construction, ensuring payroll costs automatically uploaded into the job costing ledger.



Results


The transition to the ABM Accounting system, with the Quantum Payroll integration, provided Clancy Construction with a scalable solution that not only met their immediate needs but also offered additional functionalities:


Improved Efficiency: The integration of payroll with job costing eliminated manual data entry, reducing errors and saving time.


Enhanced Reporting: The multi-company database structure allowed for more precise and timely reporting across all management levels.


Long-term Access: ABM’s integration with Microsoft SQL and Microsoft Office 365 provided Clancy Construction with easy access to transaction data dating back to 2006, enhancing their ability to generate detailed reports.


In conclusion, Clancy Construction successfully modernized its accounting and payroll systems, significantly improving operational efficiency, reporting capabilities, and data management. This strategic transformation has positioned the company to continue delivering high-quality construction services, aligned with its core values, for years to come.

 


Share by: