logo.gif (2680 bytes) banleft.gif (971 bytes) Financial Management banrighttop.gif (8491 bytes)
topgraf.gif (667 bytes) clearban.gif (979 bytes) banrightbot.gif (2320 bytes)
Home
Up
Service Orders
Projects
Preventative Maint.
Management Info.
Inventory Control
Purchase Requistion
Purchase Orders
Personnel
Overhead Tracking
Timesheets
Financial Management
Vehicle Maintenance
Office Equipment
Gvmt. Furnished Equip.
Cont. Furnished Equip.
Report Writer
Documentation
botgraf.gif (4005 bytes)
12.gif (44 bytes)

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:

  1. Payroll Processing

  2. Payroll Adjustment Processing

  3. Materials Costs Processing

  4. Contract Modifications Processing

  5. Government Invoice Processing

  6. Project Billing Processing

  7. Posting To Accounting

Payroll Processing

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

Payroll Adjustment Processing

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 Cost Processing

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 Modifications Processing

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

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

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.

Posting To Accounting

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.

 

STN, Inc.
2127 Espey Court, Suite 100
Crofton, MD 21114
Voice: (800) 321-1969 or (410) 721-4004
Voice - DC Metro Area: (301) 858-0110
Fax: (410) 721-9011

Copyright © 2000.  All rights reserved.
Revised: January 16, 2004