Sage Case Studies Sage Solutions Transform Budgeting and Accounting Process

Edit This Case Study Record

	Sage Solutions Transform Budgeting and Accounting Process Sage

Sage Solutions Transform Budgeting and Accounting Process

Sage

Technology Category	Functional Applications - Enterprise Resource Planning Systems (ERP)
Applicable Industries	Healthcare & Hospitals
Use Cases	Predictive Maintenance
Services	System Integration
Challenge	The Resource Center, a not-for-profit healthcare agency, was struggling with an inefficient and time-consuming manual budgeting process that did not allow for sophisticated analysis and planning. The annual budget process involved the creation of a Lotus spreadsheet for each of more than 200 cost centers, each containing a few years of historical data, as well as last year’s budget and actuals. The budget data was then reentered into a legacy system, with the budget cycle concluding in late December. The process for allocating expenses across the agency was also complex and time-consuming, involving many days each month of manual data entry and rekeying. Read More
About Customer	The Resource Center is a not-for-profit healthcare agency that serves individuals and families with disabilities in upstate New York. The organization relies on a number of funding sources, including Medicaid reimbursements, government contracts for products assembled in one of two workshops staffed by The Resource Center’s clients, and donations and agency grants. These funds are key to building and maintaining new programs. The Resource Center is located in Bensenville, Illinois. Read More
Solution	The Resource Center implemented Sage Budgeting and Planning and Sage Allocations to reengineer its budgeting and cost allocation processes. With Sage Budgeting and Planning, templates in a format similar to Microsoft® Excel® called Plan Sheets, are created for each cost center. All Plan Sheets are linked, simplifying revisions, consolidations, and analysis. Both Sage Budgeting and Planning and Allocations are tightly integrated with the General Ledger database, which eliminates cumbersome downloads or uploads and ensures data accuracy. The previous process required tedious manual updates to more than 2,000 individual line items, which then had to be rekeyed as journal entries to the General Ledger—an error-prone process that used to take four or five days. Read More Log in to view content
Contents

Technology Category

Functional Applications - Enterprise Resource Planning Systems (ERP)

Applicable Industries

Healthcare & Hospitals

Use Cases

Predictive Maintenance

Services

System Integration

Challenge

The Resource Center, a not-for-profit healthcare agency, was struggling with an inefficient and time-consuming manual budgeting process that did not allow for sophisticated analysis and planning. The annual budget process involved the creation of a Lotus spreadsheet for each of more than 200 cost centers, each containing a few years of historical data, as well as last year’s budget and actuals. The budget data was then reentered into a legacy system, with the budget cycle concluding in late December. The process for allocating expenses across the agency was also complex and time-consuming, involving many days each month of manual data entry and rekeying.

About Customer

The Resource Center is a not-for-profit healthcare agency that serves individuals and families with disabilities in upstate New York. The organization relies on a number of funding sources, including Medicaid reimbursements, government contracts for products assembled in one of two workshops staffed by The Resource Center’s clients, and donations and agency grants. These funds are key to building and maintaining new programs. The Resource Center is located in Bensenville, Illinois.

Solution

The Resource Center implemented Sage Budgeting and Planning and Sage Allocations to reengineer its budgeting and cost allocation processes. With Sage Budgeting and Planning, templates in a format similar to Microsoft® Excel® called Plan Sheets, are created for each cost center. All Plan Sheets are linked, simplifying revisions, consolidations, and analysis. Both Sage Budgeting and Planning and Allocations are tightly integrated with the General Ledger database, which eliminates cumbersome downloads or uploads and ensures data accuracy. The previous process required tedious manual updates to more than 2,000 individual line items, which then had to be rekeyed as journal entries to the General Ledger—an error-prone process that used to take four or five days.

Impact #1	Sage Allocations reduced the time required to process allocations from many days a month to about a day a month.
Impact #2	Sage Budgeting and Planning shaved almost two months off the budget cycle.
Impact #3	The integration of Sage Budgeting and Planning and Allocations with the General Ledger database eliminated cumbersome downloads or uploads and ensured data accuracy.

Impact #1

Sage Allocations reduced the time required to process allocations from many days a month to about a day a month.

Impact #2

Sage Budgeting and Planning shaved almost two months off the budget cycle.

Impact #3

The integration of Sage Budgeting and Planning and Allocations with the General Ledger database eliminated cumbersome downloads or uploads and ensured data accuracy.

Benefit #1	Reduced time required to process allocations from many days a month to about a day a month.
Benefit #2	Shaved almost two months off the budget cycle.

Benefit #1

Reduced time required to process allocations from many days a month to about a day a month.

Benefit #2

Shaved almost two months off the budget cycle.

Download PDF Version

Overview

Sage Solutions Transform Budgeting and Accounting Process

Operational Impact

Quantitative Benefit