Abc accounting 11. 0 Reference Guide

Code (K)

Enter a code, up to three digits, you will use to reference the wage, tax, or deduction category. It may be letters, numerals or a combination of both. Do not begin any codes with a zero (0) or number sign (#). These codes are pre-entered, and are used to specify different types of wages, taxes, deductions, and calculations.

Here are codes which have been entered for your convenience:

JLO OVERTIME RT REGULAR TIME

JLP PROPRIETOR'S WITHDRAWAL OT OVERTIME

JLQ PROPRIETOR'S OVERTIME PR PIECE RATE

MA MATERIAL REIMBUSEMENT VA VACATION PAY

SL SALARY SLW SALARY + WAGES

NOTE: If Salary is used with Report # 4-41, PAYROLL FROM TIME CARDS, the codes used MUST be SAL or start with SL to work properly. Do NOT use these codes for anything else but salaries.

You may wish to enter additional information, such as G/L #, Description or Stub Description, in the screens listed above.

Description (K)

Enter a description of the wage, tax, or deduction.

Stub Description (K)

Enter an abbreviated description of the item. This will be used on the paycheck stub, Employee (E) and Paycheck Entry (P) screens, and on some reports.

G/L Account # (K)

Enter the general ledger account number that has been assigned for the wage, tax, or deduction category.

Hours/Unit/Wage (K)

The Employee (E) screen can accumulate and store hours, units, and taxable wages in up to 15 different fields. The code entered here tells the computer in which field to accumulate and store the information specified by this record. Enter the code number as follows:

027 OVERTIME HOURS 034 FEDERAL WITHHOLDING WAGE

028 VACATION HOURS 035 FICA WITHHOLDING WAGE

029 HOLIDAY HOURS 036 STATE WITHHOLDING WAGE

030 SICK HOURS 037 CREDIT WEEKS

031 #1 OTHER HOURS 038 LOCAL WAGE

032 #2 OTHER HOURS 039 MEDICARE WITHOLDING WAGE

040 OTHER WITHOLDING WAGE

Amount/Tax (K)

The Employee (E) store can accumulate and store wage, tax, and deduction information in up to 25 different fields. The code entered here tells the computer in which field to accumulate and store the information specified by this record. Enter the code number as follows:

002 OVERTIME WAGE 014 MEDICARE WITHHOLDING

003 VACATION WAGE 015 OTHER WITHHOLDING TAX

004 HOLIDAY WAGE 016 DEDUCTION/EARNING #1

005 SICK PAY 017 DEDUCTION/EARNING #2

006 #1 OTHER WAGE 018 DEDUCTION/EARNING #3

007 #2 OTHER WAGE 019 DEDUCTION/EARNING #4

008 BONUS & COMMISSIONS 020 DEDUCTION/EARNING #5

009 FEDERAL WITHHOLDING TAX 021 DEDUCTION/EARNING #6

010 FICA WITHHOLDING TAX 022 DEDUCTION/EARNING #7

011 STATE WITHHOLDING TAX 023 TIPS

012 OTHER STATE WITHHOLDING TAX 024 INSURANCE

025 TEMPORARY DEDUCTION

Hours Deduct (K)

The code you enter here tells the computer where on the Employee (E) screen to keep a running total of hours due the employee, such as vacation or sick hours. This total is not cleared at the end of the year. Enter any of the following codes:
096 VACATION HOURS DUE

097 SICK HOURS DUE

098 PERSONAL HOURS DUE

099 OTHER HOURS DUE

Date and Amount (K)

The code you enter here tells the computer where on the Employee (E) screen to store the date and amount of the privilege tax or other annual one- time deduction. The following two number codes may be used:

094 OTHER ONE-TIME DEDUCTION

Labor Type (K)

Enter 1 for wages, D for deductions. With D the deduction is itemized on the right side of the paycheck stub when you print checks with Report # 4-27, PRINT PAYROLL CHECKS. Other available codes:

E for Excused Hours S posts to Subcontract field

U for Unexcused Hours T Taxes Shift+F1

H for Holidays V for Vacation

I for Indirect

F - when a fixed amount of the wages, each pay period, are deducted, exempt from Federal W/H but subject to FICA, Medicare, State & Local taxes. Use K when a percentage of the wage is deducted instead of a fixed amount. F or K are used with 401K Plans. See "401K Plan Setup" in your manual or press Shift+F1, Q, and then K.

M - for Material or Mileage (non-labor reimbursement). M can also be used for a wage or deduction which is nontaxable. Using M, the hours are not included in the Total Hours on the Time Card Screen.

N - for Nontaxable Deduction (such as section 125 plan insurance deductions) not taxed by Fed.W/H, Medicare & FICA, but taxed by State & local. "O" for nOntaxable Deduction (section 125 plan insurance deductions) that are exempt from Fed.W/H, Medicare, Fica, AND State W/H, but taxed by local. For section 125 setup, see FUTA setup on the Emloyee screen by pressing F1 on the FUTA field.

ABC JOB COSTING MODULE - Enter 1, 2, or 3, here, when setting up Labor Categories to specify where it is to post; to Hours 1, Hours 2 or Hours 3, on the Job Detail ('D) screen. It will post to Hours 1 if this field is blank.

401K Plan Setup (K)

401K Plan benefits provided to an employee are exempt from Federal tax only. They are subject to social security, medicare, state and local taxes.

Use 401 as the code on the K screen. Enter the description and stub description that you want. Enter the G/L # that you use for labor. Enter F as Labor Type. On the right side, enter 022 in the Amount/Tax field and enter #29 as the Calculate #. This allows you to specify a certain amount as 401K benefits each pay period.

If the 401K benefits are a percentage of total wages, use a code such as K10 on the K screen. Enter the description and stub description that you want. Enter the G/L # that you use for labor. Enter K as Labor Type. On the right side, enter 022 in the Amount/Tax field. Enter #23 as the Calculate #.

On the E screen of each employee that has 401K benefits, use either 401 or K10 as one of your Cat.(Category) codes. With 401 as the Category, enter the amount of the benefit as a negative figure. With K10 as the Category, enter a positive number to indicate what percentage of the total wage is 401K benefits.

NonTax/Remark (K)

This is an information field for entering a remark. If the calculate # is 30 or greater, the number below for wage or deduction may be entered separated by commas to reduce taxable wages. Example: 5,24 remark. Page 187to learn about setting up taxable wage deductions.

2 OVERTIME WAGE 14 MEDICARE WITHHOLDING

3 VACATION WAGE 15 OTHER WITHHOLDING TAX

4 HOLIDAY WAGE 16 DEDUCTION/EARNING #1

5 SICK PAY 17 DEDUCTION/EARNING #2

6 #1 OTHER WAGE 18 DEDUCTION/EARNING #3

7 #2 OTHER WAGE 19 DEDUCTION/EARNING #4

8 BONUS & COMMISSIONS 20 DEDUCTION/EARNING #5

9 FEDERAL WITHHOLDING TAX 21 DEDUCTION/EARNING #6

10 FICA WITHHOLDING TAX 22 DEDUCTION/EARNING #7

11 STATE WITHHOLDING TAX 23 TIPS

12 OTHER STATE W/H TAX 24 INSURANCE

Setting Up Taxable Wage Deductions.

Category records having a Calculate # greater or equal to #30 may make deductions to the wage before the tax is calculated. The Wage or Deduction number listed on the field help for the Nontax/Remark is placed into the Nontax/Rmk field. Multiple deductions may be entered separated by commas. A Remark may not start with a number from 1 to 25 and must follow the deduction #s.

For example. An annuity reduces the federal and state taxable wage. The annuity category is set up with a 019 DEDUCTION EARNING #4 in the Amount/Tax field on the K screen. The 019 DEDUCTION EARNING #4 is subtracted from the federal wage by entering a 19 on the K screen in the NonTax/Rmk of the FD record. The State is set up the same way. No other category record may have in the Amount/Tax field a 019 DEDUCTION EARNINGS #4 or else those amounts will also be deducted.

Calculate # (K)

The code entered here tells the computer which routine to use to calculate the wage or deduction amount specified by this record. The following calculations are programmed into the system.

The following codes determine how wages are entered on the Paycheck Entry (P) screen:

#22 VAC CR, & NON-PAY HRS Enter the number of hours without entering a rate or amount.

#23 ENTER HR/UNIT WAGE Enter the number of hours and a rate, so that it can multiply the number of hours times the rate to get the amount.

#24 REGULAR HOURLY WAGE Enter the number of regular hours. The rate loads from the first line under EARNING/DED CODE on the Employee (E) screen. The computer multiplies hours times rate to get the wage amount.

#25 OVERTIME HOURLY WAGE Enter the number of overtime hours. The computer gets the rate from the the first line under EARNING/DED CODE on the Employee (E) screen and multiplies it times 1.5 to get the overtime rate. It then multiplies the hours times the overtime rate to get the wage amount.

#26 COMMISION FROM SALES Entered commision sales is multiplied by rate and divided by 100 to get wage.

#29 SALARY WAGES & DEDUCTIONS Enter the amount without entering the number of hours or rate. This is normally used for salaries and deductions.

The following codes determine how taxes are calculated when a record is saved on the Paycheck Entry (P) screen. Taxible wages when calculate# is 30 or greater may be reduced by entering deduction #s in NonTax/Rmk. Page

#30 FEDERAL TAX CALCULATION If the employee is not exempt from Federal Withholding tax, this routine loads the proper single or married tax tables and calculates the Federal Withholding tax to be deducted from the employee's wages. (Deductions with N in Type on the K screen are deducted before the Federal tax is calculated.)

#31 FICA This routine calculates FICA tax for the employee if he has not reached the limit in the first OVER WAGE field. (Any deductions with N in Type on the K file are deducted before the FICA tax is calculated.)

#32 CALCULATE TAX TABLES If the employee is not tax exempt, this routine takes the pay for the period and multiplies it by the number of pay periods in the year to get the yearly pay. It then gets the # of Fed. Dependents from the Employee (E) screen and multiplies it by the amount entered in the Dependent Deduction field. This amount is then subtracted from the yearly pay. Then it scans the ANNUAL TAX TABLES for the highest OVER WAGE amount that is less than or equal to the adjusted yearly wage. The difference of the adjusted yearly wage amount and the OVER WAGE is multiplied by the TAX RATE % on that line. This amount is then added to the AMOUNT TAX on that line to give the yearly tax amount. The yearly tax amount is then divided by the number of pay periods in the year, giving the tax to be deducted for the pay.

#33 PRIVILEGE TAX This routine checks the specified location in the Date & Amt field to see if Privilege Tax has been deducted from the employee's wages this year. If not, it checks to see if his YTD Wage is over the limit entered in the first OVER WAGE field. If his YTD wage exceeds this limit, the amount in the PLUS AMOUNT TAX field is deducted.

#34 PAU TAX & CREDIT WEEK This routine gives one credit week when the employee's gross pay is over $50.00 within one week, or two credit weeks when the employee's gross pay is over $100.00 within two weeks.

#35 AUTOMATIC VACATION CREDIT Automatically applies vacation credits to employees based on Hire Date. Seein help for paycheck entry (P).

#39 KENTUCKY TAX TABLES This routine makes use of the calculate Tax Tables routine (explained in #32 on previous page) to calculate the tax amount. It then gets the # of Dependents from the Employee (E) screen and multiplies it by the amount in the State Tax Credit field. This amount is then subtracted from the tax amount. The difference is the amount of tax to be deducted from the employee's pay. If the difference is less than zero, the amount to be subtracted from the employee's pay is zero.

#40 CALCULATE MARITAL TAX TABLES This routine uses the tax code (usually two digits) and adds the marital status (S or M) to it. Using that code, it loads the proper tax file and calculates the taxes as described in #32 CALCULATE TAX TABLES. Suppose an employee lives in New York (state tax code NY) and is single (S in the Status M/S, P field). The computer will combine these two entries to calculate the employee's taxes from the NYS tax table.

#41 CALCULATE TAX TABLES WITH OTHER DEPENDENTS This routine, using the tax code, loads the proper tax file and calculates the taxes as described in #32 CALCULATE TAX TABLES, except it uses the number of OTHER Dependents as entered in the Employee (E) screen.

#42 CALCULATE MARITAL TAX TABLES WITH OTHER DEPENDENTS This routine, using the tax code, loads the proper tax file and calulates the taxes as described in #40 CALCULATE MARITAL TAX TABLES, except it uses the number of OTHER Dependents as entered in the Employee (E) screen.

#43 CALCULATE MARITAL TAX TABLES WITH 125-PLAN TAX DEDUCTION This routine, using the tax code, loads the proper tax file and calculates the taxes as described in #40 CALCULATE MARITAL TAX TABLES, except it exempts any amounts designated as 125 Plan benefits from Federal, FICA and Medicare taxes. 125-Plan Benefits are usually taxed at the State and Local level.

#44 MISSOURI TAX TABLES This routine, using the tax code, loads the proper tax file and calulates the taxes as described in #40 CALCULATE MARITAL TAX TABLES, except for two things.

1. It uses the number of OTHER Dependents as entered in the Employee (E) screen.

2. It subtracts the amount of Federal taxes from the Employee's wages before the state tax is calculated.

State Tax Credit (K)

This is an information field used with some state tax programs.

Burden - Amount per Hour (K)

ABC JOB COSTING MODULE - Enter the amount per hour that you have to pay out for labor overhead such as worker's compensation, etc. When labor is entered on the Time Card screen (T), the computer automatically calculates the labor burden and adds it to the labor cost. The burden is included in the total labor cost posted to the job.

Burden - Percent of Wage (K)

ABC JOB COSTING MODULE - Enter a percent of wages that you have to pay out for labor overhead such as worker's compensation, etc. When labor is entered on the Time Card screen (T), the computer automatically calculates the labor burden and adds it to the labor cost. The burden is included in the total labor cost posted to the job.

Dependent Deduction (K)

This field is used with federal taxes and some state taxes. Before calculating taxes for an employee, this amount may be deducted from his yearly wage for each dependent he claims.

Tax Rate % (K)

Enter the percent that is to be used to calculate the tax specified by this record. For example, enter 15.00 for 15%.
Anniversary #

If you are entering an automatic vacation credits table, use this field to enter an anniversary number on which an employee becomes eligible for vacation. See in help for paycheck entry (P).

Over Wage (K)

The tax will be calculated on any wage that is more than the amount entered here and less than the amount entered in the OVER WAGE field on the next line. If there is nothing entered here, the tax will be calculated on any wage that is less than the amount entered in the OVER WAGE field on the next line.

Taxes such as Occupational Privilege Tax are exceptions for this field. Such taxes are deducted once a year, when the employee's year-to-date wage exceeds a certain limit. Enter that limit here.

FICA Tax is another exception. Enter the FICA ceiling into this field. Remember that the Social Security part of the FICA Tax has one ceiling and the Medicare portion of it another.

Vacation Hours

If you are entering an automatic vacation credits table, use this field to enter the number of vacation hours to be credited. Seein help for paycheck entry (P).

Plus Amount Tax (K)

After the tax amount has been calculated using the TAX RATE % and OVER WAGE fields, that amount will be added to the amount entered in this field. The total will be deducted from the employee's gross pay.

For taxes such as Fica and Occupational Privilege Tax, this amount will be deducted from the employee's gross pay once a year, when his year-to-date wage exceeds the limit entered in the OVER WAGE field on this line.
Interval (Years)

If you are entering an automatic vacation credits table, use this field to enter the award interval in years. Seein help for paycheck entry (P).

See page 186 for 401K Plan Setup (K)

THE CATEGORY & TAX TABLES SCREEN'S PURPOSE

This file is used to define the various wage categories, tax withholdings, and deductions used in the payroll system, and to accumulate hours and wages or other amounts from the paychecks. Any category used on the other payroll screens - Employee (E) screen, Employer Setup (F) screen or Paycheck Entry (P) screen - must be defined on this screen before they can be used.

NOTE: If you are using Job Costing and not using the optional Payroll module, this file is only used with the Employee (E) screen. Only the first 8 fields of the K screen (the upper left-hand corner) are utilized in this situation.

'E - Employer Setup
EMPLOYER SETUP SCREEN FILE HELP

Clear the screen, without saving or unsaving the current record, and set the reference number to the next available number.
Exit Lookup Close All Lookups

Open Lookup Alternate Lookup

Save Record Delete Record

Selection Screen Go to Menu Bar

Exit One Level Exit ABC

EMPLOYER SETUP SCREEN TOOLS HELP

You will receive a message telling you what entry location and field number your cursor is at. Type in the number of the entry location you want your cursor to be moved to and press enter, and your cursor will be moved to that location.

or This gives you two notepads to keep on file anything that you want to remember about this purchase order. Ctrl+J files it with the date and time, Ctrl+K only with the date. To see what is on file, press Ctrl+J or Ctrl+K. When you are done, press F9.

This places the reference code on Word Processor 'eLIST. To see the list, press F10, W, Ctrl+N (to clear screen) and then type 'eLIST. To learn more, press Page 11.

Undo present changes to line cursor is on.

Start macro from the line the cursor is on. Press F4 and the macro name.

Record macro. Press Shift+F4 to begin recording. Then enter the macro keystrokes. Press Shift+F4 to end the macro. Press Page 12 for more information.

calculator. Use + to add and total and - to subtract. Use / to divide and * to multiply. Use ) to clear and ( for off. Use = or Enter for equals.

Wage Categories # 1 (F)

ABC PAYROLL MODULE - This is one of eight different wage categories that can be entered in this column. These are used to identify the different types of wages the payroll system records. Enter the wage category code as it is set up on the Category & Tax Tables (K) screen. The wage category record that is set up on the Category & Tax Tables (K) screen must have 001 REGULAR WAGE entered in the Amount/Tax field. The stub description of this wage category appears on the Paycheck Entry (P) screen and on Report # 4-24, EMPLOYEE WAGES & DEDUCTIONS, to label the accumulated wage amounts.

Wage Categories # 2 (F)

ABC PAYROLL MODULE - This is one of eight different wage categories that can be entered in this column. These are used to identify the different types of wages the payroll system records. Enter the wage category code as it is set up on the Category & Tax Tables (K) screen. The wage category record that is set up on the Category & Tax Tables (K) screen must have 002 OVERTIME WAGE entered in the Amount/Tax field. The stub description of this wage category appears on the Paycheck Entry (P) screen and on Report # 4-24, EMPLOYEE WAGES & DEDUCTIONS, to label the accumulated wage amounts.

Wage Categories # 3 (F)

ABC PAYROLL MODULE - This is one of eight different wage categories that can be entered in this column. These are used to identify the different types of wages the payroll system records. Enter the wage category code as it is set up on the Category & Tax Tables (K) screen. The wage category record that is set up on the Category & Tax Tables (K) screen must have 003 VACATION WAGE entered in the Amount/Tax field. The stub description of this wage category appears on the Paycheck Entry (P) screen and on Report # 4-24, EMPLOYEE WAGES & DEDUCTIONS, to label the accumulated wage amounts.

Download 1.68 Mb.

Share with your friends: