Failing to Plan is Planning to Fail!

Budget Summary

Sends the budget back into S100C which saves hours of tedious data entry.

A budget is the financial blueprint of a business - a prediction of the future. As a prediction, a budget is not exact or perfect, but it is the best way to compare what you plan and what actually happens. Analysis of the reasons for the variance between the budget and actual provides the business manager with valuable feedback and understanding.

The best way to make a budget for the future is to have a detailed understanding of how you spend your money now. Most business managers understand the importance of budgets, but dread the challenge of creating a detailed budget that is based on the current financial performance of the company.

The Budget Summary makes budgeting easy for S100C users!

Budget Management

The Budget Management tool provides a dynamic canvas which allows users to quickly and easily obtain up-to-date actual data from S100C as the year progresses. This data is presented in comparison to the budget data in grids, charts and graphs that are easy to review. Then the data can be used in the Budget Forecasting tool to update the forecast for subsequent months.

Once you have forecasted a reasonable budget, the next step is to manage the business to stay within that budget. In today's climate of rapid change, preparing a budget is no longer a stagnant once-a-year chore rather it should be a dynamic and continual process. The frequent review of budget to actual data is necessary to stay current with what is going on financially in the business and make any necessary plans and adjustments.

Cash Flow

The Cash Flow tool automatically imports S100C accounts receivable, accounts payable, payroll and cash account balances thus eliminating the need to reenter them. Any non-S100C data can be manually entered, maintained, changed or deleted. If non-S100C data is subsequently entered in to S100C, the Cash Flow tool will recognize this and synchronize the data automatically. This allows the continuity of the information to be maintained. The Cash Flow tool also maintains historical cash flow projections which can be used to improve your cash flow forecasting abilities.

Cash Flow is simply the flow, and timing, of cash IN and OUT of a business. It is used to define liquidity. Being profitable does not necessarily guarantee that a business will successfully continue. Profitable businesses can fail when they do not have the money to meet their current financial obligations. Therefore, Cash Flow projections are an essential part of a business manager's job.

Typically it is troublesome to obtain all the necessary Cash Flow data from a business accounting system, including S100C, because they only record what has already happened. Cash Flow projections also need data about what is going to happen in the next week, month or quarter. For example, on the IN side, a large job has a progress billing, but the invoice will be posted in the future. On the OUT side, payroll has not been posted yet, but is owed to the employees in the next week. Neither of these transactions is available for Cash Flow reporting in S100C.

So, how do business managers track cash flow projections? They use a spreadsheet. While spreadsheets are easy to use and flexible, entering all of the necessary data into a spreadsheet is a tedious, costly, and time consuming process. This is because you must not only enter the data that is not currently in S100C, but you must also needlessly reenter the data that is already in S100C.

Pivot Grid

The Pivot Grid tool allows you to dynamically sort, count, filter and total your S100C data using a drag-n-drop, spreadsheet-like screen. This allows you to easily summarize and analyze large amounts of multidimensional, company information.

By using the Pivot Grid tool, you will be able to answer tough business questions relating to the counts, sums, averages, minimums, maximums, and standard deviations. From "Who is my highest performing sales person this month?" to "What is my average revenue per customer?" the Pivot Grid will provide the answers with the data that matters most to your business and bottom-line.


The Reports tool supports all of the standard S100C data relationships as well as many that S100C doesn't make available to you. This allows you to create reports containing important and revealing business content that you simply don't have access to in S100C's report writer. The Reports tool can even create reports that pull data from your existing company file and multiple archive files simultaneously.

While the Reports tool is certainly more advanced than S100C's report writer, it doesn't require advanced technical expertise to operate. You don't need to understand the S100C database structure or the various relationships within S100C's data. The Reports tool handles all of this for you, allowing you to concentrate on creating and running the reports that your business needs. If you can point-and-click, then you can use the Reports tool.

If you are tired of paying someone else $300, $400, or even $500 for a custom S100C report, then you're ready for the Reports tool. You're going to love how easily and quickly you can create your own reports.

Department Allocation

The Department Allocation tool automates the process of calculating and distributing the department allocation amounts. It is designed for companies who have a departmentalized Income Statement and use, or wish to use, an allocation department. A business typically implements department allocation when it is not possible or practical to initially post income or cost to a real department and yet, it is still very important that the income and/or cost ultimately be posted to a real department.

Department allocations offer a wide-range of benefits for the companies willing to do them: improved management, accurate profit measurement, profitable selling prices, informed decision making, personnel motivation, and more. Given these benefits you would think that most companies using S100C would be more than happy to implement department allocations, but still most do not. The problem is that S100C does not provide automation to calculate and distributed income and expenses across departments, and doing this manually is no small chore. Thus the need for the Department Allocation tool.

Overhead to Direct Cost Allocation

The Overhead to Direct Cost Allocation tool is similar to the Unapplied Direct Cost Allocation tool except that the costs are posted to overhead rather than an 'unapplied cost' job. This tool automates the process of calculating and distributing the cost from overhead to job cost.

The upside of posting to overhead is that it is easier. The job cost record does not need to be entered at the time the transaction is posted. The downside of posting to overhead is that the costs sit in the overhead section of the Income Statement until the allocation is done even though the cost is really direct cost.

Cost Code Conversion

The Cost Code Conversion utility converts all S100C cost codes from existing codes to new codes in every S100C table and field. If you have S100C cost codes that you don't use anymore and you can't delete them because they have been previously used, or if you wish you could redo your cost code list now that you really understand the use of cost codes in SBM, then the Cost Code Conversion utility is for you.

Parts Update

The Parts Update utility will merge duplicate parts in S100C. In addition the Parts Update utility can merge inventory parts, calculate the average cost, and figure the quantity on hand (total and by location). If you have duplicate parts in S100C, but you can't remove them because they have been used in previous transactions, then the Parts Update utility is for you.

Assembly Quick Replace

The Assembly Quick Replace utility can save you time by updating the assembly parts en masse. If you want your Assembly Part detail to match the underlying Part detail or you are frustrated that S100C doesn't update the detail in the Assembly when you make a change to a contained part, then the Assembly Quick Replace utility is for you.

Recalc Assembly Totals

The Recalc Assembly Totals utility is designed to recalculate the Assembly total based on the current default cost. S100C figures the Assembly total when you save the record, but it will not update that total to reflect changes in the part cost until you save the Assembly again. This can be a real problem if you have a lot of Assemblies and want to print out a list of Assemblies with up-to-date totals. The Recalc Assembly Totals utility will make this problem a thing of the past

Find and Replace

Find and Replace allows you to search form information globally through Sage 100 Contractor and change the data to fit your needs. Change statuses on Jobs, Vendors, or Purchase orders easily. Whenever you have data changes that need to be consistent, Find and Replace gives you the functionality you need.

Recall Jobs

The Recall Jobs utility allows S100C users to recall jobs and related information from S100C archive databases back into the current company file at will. Routinely S100C users will close out their year not realizing that jobs with a "Closed" status will be archived and no longer available for lookup within the current company shown in S100C. This can cause frustration whenever the need arises to access an archived job's information, such as when information pertinent to a warranty is needed.

The Recall Jobs utility allows you to search and retrieve previously archived jobs and related information with ease. No longer will you have to go through the tedious task of opening S100C company archives in order to view job information that you wish was still in your S100C current company database.

Company Share

Company Share passes information from one company to create records in another. Whether you need to setup vendors one time and then post them to other companies, or generate estimates from a master company and then pass them to the company that does the work, Company share moves the information easily, seamlessly and identically.