Payroll Framework!
 

The Integral Accounting Enterprise 2007 Payroll Framework is a simple payroll system that was designed to allow the easy implementation of any local jurisdiction's payroll rules into the Integral Accounting Enterprise 2007 accounting system.

The system allows the customization of four levels of tax tables (Country, State, County, City), a separate table for payroll items which are fully customizable, and will create a standard payroll register and allow for the creation of payroll checks.

All of the payroll business logic is implemented in easy to understand and modify SQL Server stored procedures. The stored procedure code is clean and heavily commented so that you can easily implement whatever rules you need for your locality or make any modifications necessary for it to meet your payroll needs.

For more information on this system and how it works, please read below.

 
Integral Accounting Enterprise 2007 Payroll Framework Details!
The Integral Accounting Enterprise 2007 Payroll Framework was designed to give developers and consultants a simple payroll program that is easily modified to allow them to implement their localities payroll within. The system uses pre-configured tax tables and payroll items tables and the basic US Payroll tax rules implemented in SQL Server Stored procedures, and these tables and rules can then be easily modified to meet any tax authorities particular payroll processing requirements.

For example, during Payroll processing taxes are calculated, both federal and local. A flexible tax calculation rules specification mechanism is provided. For each tax class (Country, State, County, and City) a pair of tables is provided describing the set of taxes of that class. 

Let’s take a look at State taxes:

All of the state tax authority information is stored in two tables, the State Tax Table and the State Tax Detail Tables.

The first table (Payroll State Tax) contains a list of states and values of rates for calculation of taxes associated with each state. This list can be extended and modified as necessary, moreover, it can be replaced by a completely different region list based on regional division of employees’ countries.

Each row of the second table (Payroll State Tax Detail Tables) describes a calculation rule used for some specific state and when several criteria are met for given Employee (State, Withholding Status (Married, Single), Status Type, Payroll Year, Pay Frequency (Biweekly, Monthly, Semimonthly or Weekly)). In order to enter a new State Tax, it’s necessary to fill these fields and also fields used for the calculation itself (Tax Bracket, Over Amount, Not Over, Cumulative).

This way, if some Employee’s settings match some records in Payroll State Tax Tables table, these records will be used for tax calculation.

Similar principles are used for Country, County, and City taxes.

If these rules are not sufficient, it’s possible to directly alter the stored procedures used for Tax Calculation:

Payroll_WithholdingTax – The root tax calculation procedure
Payroll_WithholdingTax_City - City tax calculation procedure
Payroll_WithholdingTax_County - County tax calculation procedure
Payroll_WithholdingTax_State - State tax calculation procedure
Payroll_WithholdingTax_Fed - Federal tax calculation procedure

These procedures are written with modification in mind, they are simple, clear, use plain-English variables and are easy to understand. 

If you would like to see payroll source code samples, please fill out the NDA Agreement at http://www.stfb.com/ndf.pdf and scan it and email it to sales@stfb.com or fax it to 1-954-986-1399

For more information about the Integral Accounting Enterprise Payroll Framework, please email sales@stfb.com or contact STFB Inc. using the information in the left frame.
 
 
We Sell World-Wide! World-Wide Accounting! Multi-Currency & VAT tax! Email sales@stfb.com for International Ordering Instructions.