Financial
Management Module
Overview
The Financial Management Module extracts data from
all other modules to create information needed for financial results
of operations. Each operation is customized to the specfic
needs & requirements for report by each customer. It
consists of seven operations:
-
Payroll Processing
-
Payroll Adjustment Processing
-
Materials Costs Processing
-
Contract Modifications Processing
-
Government Invoice Processing
-
Project Billing Processing
-
Posting To Accounting
Payroll Processing replaces manual calculation of time cards for
payroll operations. It eliminates the time for a payroll clerk
to calculate and submit payroll figures.
Startup is easy; a control file of default values is set up,
allowing the flexibility to calculate pay based on either the labor
code reported on work orders for an individual (which may be
different from his regular labor code) or based on the regular labor
code stored in the worker's personnel file record. Payroll
Processing is performed by simply entering the date range for the
payroll week. This process gathers the work order data from
Service Orders, Project Work Orders, Preventative Maintenance Work
Orders, and Overhead. It takes each work order labor line and
passes it through a series of tests against the Payroll Rules
file. The Payroll Rules file contains the rules for
application of different types of pay. The types of pay
calculated are:
 | Holiday Pay |
 | Sick Pay |
 | Annual Leave |
 | Leave Without Pay |
 | Shift Pay - Night Differential |
 | Shift Pay - Sunday Differential |
 | Regular Pay |
 | Overtime Pay |
 | Doubletime Pay |
 | Miscellaneous Pay |
 | Regular Pay - Davis Bacon |
 | Overtime Pay - Davis Bacon |
 | Doubletime Pay - Davis Bacon |
 | Davis Bacon Health and Welfare Deduction |
 | Davis Bacon Cash Fringe |
Payroll processing takes each individual work order labor line
and passes it through each payroll test. For each test that is
passed, processing creates a separate payroll history element.
This provides powerful reporting on complex, individual types of
pay. Payroll Processing then generates a report that can be loaded
into the company's regular payroll program. This report can
either be in an electronic file, formatted to suit the specific
requirements of the payroll program, or a paper report which can be
sent for keying in at a payroll work station.
Payroll Processing also calculates Earned Vacation. The
payroll clerk enters the date range to calculate and the system
creates the vacation earned by each employee. This process is
based on the employee's date of hire compared to the company's
accrual rules within the Control file.
Payroll Processing provides the following standard reports:
 | Time Worked |
 | Check Receipt Sign-Off Sheet |
 | Fund Source Breakdown |
 | Sick Leave Taken |
 | Vacation Leave Earned |
 | Vacation Leave Taken |
 | Employee Hours Worked (Separating regular work form Davis
Bacon) |
 | Work Order Number Summary |
Because WorkLine's Payroll Processing is based on loaded labor
rates, there may be differences between the payroll
calculated by WorkLineTM
and the actual payroll generated by the
payroll program. The Payroll Clerk prints out a Payroll
Pre-Adjustment Edit List and a Labor Cost Pre-Adjustment Edit
List. These lists show what data is about to be adjusted.
Cost Adjustment Processing takes the final calculated payroll
figure and calculates the percentage difference between the figure
and the total calculated by WorkLine's Payroll Processing.
This percentage is then "back applied" to Payroll history
and Work Order history in WorkLineTM. This results in the
detailed information in WorkLineTM exactly and accurately matching the
actual payroll paid for each period, including the benefits.
A detailed Payroll Memo is printed from the Payroll Data
file. This memo is used for supporting documentation to any
Government invoice generated from the system. Adjustment
Reversal Processing is available for both Payroll and Labor Cost
adjustments.
Materials Costs Processing interfaces, processes, and reports on
material usage for the accounting period. Data is extracted
from WorkLine's Inventory and Purchase Order module. The
interface is performed by simply pressing a button. This
action exports the data and makes it available for materials
processing operations. This data is used throughout Financial
Management Module for reporting on material costs for the accounting
period.
Reports are date range defined. Standard reports include:
 | Detail Material & Supplies Purchased |
 | Summary Material & Supplies Purchases |
 | Purchase Order Breakdown |
Contract Modification Processing keeps track of special funding
for selected individual projects within the Projects Module.
The Contract Administrator receives a modification (mod) to the
contract. This mod contains a list of projects that will be
funded within the mod and for what amount. The Contract
Administrator is responsible for tracking the original funding for
projects as well as tracking the percentage of funding used.
When a project is funded, the user accesses the mod file and adds
the project to the file. Information regarding the project is
calculated and shown. The user has the ability to show the
cost of the project against a particular mod, or applying the
project to a particular bulk fund.
The Contract Mod Reconciliation report is printed for each
accounting period. This shows by mod, by bulk, by individual
project - the funding provided, actual current cost and percent of
funding used. It is automatically calculated from data stored
throughout WorkLineTM.
Government Invoice Processing provides the ability to prepare the
Government Invoice. This includes supplemental reports,
Government Voucher processing, and Invoice Preparation. At the
end of each billing period the user prepares the government
invoice. The user prints the following supplemental supporting
reports:
 | Project Detail Reports |
 | Facilities Maintenance Report |
 | Fund Source Report |
Government Invoice Processing also contains customized processing
to produce documents required to meet the requirements of specific
government agencies. For example, for NASA, Government Invoice
Processing produces all the documents required to generate their
Form 533 Invoice:
 | Yearly Contractor Estimate Data - this file is set up
once a year and contains the estimated hours and cost for each
fund source. |
 | Create Fund Source Actuals - This process gathers the
labor, cost, and time; material cost and equipment cost for each
fund source and places the information into the 533 processing
file. |
 | Create Fund Source Other Data - This process allows the
user to edit the unfilled orders from the Purchase Order module. |
 | Create 533 "What If" Version - This process
copies the actual data into the "what if" file. |
 | Maintain 533 "What If" Version - This allows
the user to update actual information if necessary. |
 | Export 533 What If" Version - This process exports
the user specified "What If" version to a spreadsheet
format. |
The user then prepares the actual voucher. This is
performed by the user entering the header information on the voucher
and pressing a key to prepare Accounts Payable information and
Payroll Information.
Project Billing Processing provides the ability for invoicing
agencies (or customers) for services rendered. This process
includes Billing Edit reports, Invoice Preparation and posting to
Accounting files. Each site has the option of deciding at what
point to bill for work. This process may be performed upon
work order completion or by project completion. The user may
prepare invoices at any time. The user prints the following
Invoice Edit reports:
 | Invoice Summary Report |
 | Invoice Detail Report |
Invoice Preparation processing creates pre-invoiced header and
pre-invoiced detail line items based upon Labor, Parts, Equipment,
and Sub-Contractor detail from the completed project work
orders. The user may then update this detail for any changes
before posting and printing the invoice. The user then prints
a pre-posting report to show the detailed invoice information being
posted into the Accounting Module.
WorkLine's Financial Management Module prepares data for posting
directly into any accounting system. The information is taken
directly from the computer, and can be configured to match the
formats of either existing accounting programs, or any standard
off-the-shelf accounting program designated by the company.
Information is available for Accounts Payable, Accounts
Receivable, General Ledger, Payroll, Inventory and Purchase Order. |