Altair > Case Studies > Automated Data Preparation: A Game Changer for Marbridge Foundation

Automated Data Preparation: A Game Changer for Marbridge Foundation

Altair Logo
Technology Category
  • Cybersecurity & Privacy - Security Compliance
Applicable Industries
  • Finance & Insurance
Applicable Functions
  • Quality Assurance
Use Cases
  • Leasing Finance Automation
  • Time Sensitive Networking
Services
  • Training
About The Customer
The Marbridge Foundation is a nonprofit community for developmentally disabled adults. Recognized for its groundbreaking approach to serving people with special needs, the Foundation provides housing, training, and a wide range of services to nearly 250 residents. As an employer, Marbridge is required to provide the IRS with detailed reporting on insurance coverage provided to full-time employees and their dependents. As a nonprofit serving intellectually challenged adults, Marbridge needs to be careful stewards of every dollar spent, making cost-effective and efficient solutions a priority.
The Challenge
The Marbridge Foundation, a nonprofit community serving developmentally disabled adults, faced a significant challenge due to new IRS regulations mandated by the Affordable Care Act. These regulations required the Foundation to provide detailed reporting on current and past payroll data. However, the Foundation's existing systems were not equipped to provide the necessary information, and the data output was only available in PDF format. The Foundation needed to analyze hours worked for over 300 employees to determine eligibility, calculate the employee share for each person offered coverage, and more. Hiring a temp agency to manually input the necessary payroll data was not a viable option due to cost constraints and the risk of errors, which could lead to substantial IRS penalties.
The Solution
The Foundation turned to Altair for an automated data preparation solution. Altair enabled the Marbridge team to access information locked in PDFs and generate reports without the need for system upgrades or contracting temporary help. A customized Altair template was used to extract the IRS-required information, allowing Marbridge to access and clean current and historic payroll information previously locked in PDF files. The preparation was quick and automatic, saving an estimated 2,000 to 3,500 man-hours of manual reentry. Altair's unique ability to automatically pull and prepare data from a wide range of difficult-to-access report formats, such as PDF, XML, HTML, text, spool, and ASCII files, enabled the organization to pull in structured and unstructured data from payroll records, invoices, sales reports, balance sheets, and more.
Operational Impact
  • With the implementation of Altair's automated data preparation solution, the Marbridge Foundation has been able to efficiently meet IRS reporting requirements with confidence. The accuracy of their submissions has increased, reducing the risk of costly government audits - a significant benefit for a risk-averse nonprofit organization. The Foundation is now planning to use Altair to scan all employees’ past W-2 forms and link them to HR files, creating a central repository for all payroll information. They are also exploring how Altair can assist in instituting a new 401(k) program. As they become more familiar with the platform, Marbridge is finding opportunities to use Altair capabilities to save time and money and enhance accuracy across a variety of HR and financial processes.
Quantitative Benefit
  • Saved an estimated 2,000 to 3,500 man-hours of manual reentry.
  • Minimized costs associated with system upgrades or contracting temporary help.
  • Reduced risk of penalties for errors in IRS reporting.

Case Study missing?

Start adding your own!

Register with your work email and create a new case study profile for your business.

Add New Record

Related Case Studies.

Contact us

Let's talk!
* Required
* Required
* Required
* Invalid email address
By submitting this form, you agree that IoT ONE may contact you with insights and marketing messaging.
No thanks, I don't want to receive any marketing emails from IoT ONE.
Submit

Thank you for your message!
We will contact you soon.