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

	Automated Data Preparation: A Game Changer for Marbridge Foundation Altair

Automated Data Preparation: A Game Changer for Marbridge Foundation

Altair

Technology Category	Cybersecurity & Privacy - Security Compliance
Applicable Industries	Finance & Insurance
Applicable Functions	Quality Assurance
Use Cases	Leasing Finance Automation Time Sensitive Networking
Services	Training
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. Read More
About 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. Read More
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. Read More Log in to view content
Contents

Technology Category

Cybersecurity & Privacy - Security Compliance

Applicable Industries

Finance & Insurance

Applicable Functions

Quality Assurance

Use Cases

Leasing Finance Automation

Time Sensitive Networking

Services

Training

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.

About 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.

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.

Impact #1	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.

Impact #1

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.

Benefit #1	Saved an estimated 2,000 to 3,500 man-hours of manual reentry.
Benefit #2	Minimized costs associated with system upgrades or contracting temporary help.
Benefit #3	Reduced risk of penalties for errors in IRS reporting.

Benefit #1

Saved an estimated 2,000 to 3,500 man-hours of manual reentry.

Benefit #2

Minimized costs associated with system upgrades or contracting temporary help.

Benefit #3

Reduced risk of penalties for errors in IRS reporting.

Download PDF Version

Overview

Automated Data Preparation: A Game Changer for Marbridge Foundation

Operational Impact

Quantitative Benefit