home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Hall of Fame
/
HallofFameCDROM.cdr
/
busi
/
payr222b.lzh
/
PAYUS22B.ZIP
/
SAMP_RPT.TXT
< prev
next >
Wrap
Text File
|
1990-03-05
|
49KB
|
1,135 lines
PAYROLL USA SAMPLE REPORTS, FEB. 1990 - PAGE 1
ANTHISTLE SYSTEMS & PROGRAMMING LTD.
563 Patricia Drive,
Oakville, Ontario,
CANADA L6K 1M4
Telephone (416) 845 7959
8th. February, 1990
SAMPLE REPORTS FROM OUR PAYROLL USA SYSTEM
==========================================
These are sample reports from PAYUSCYC.EXE (Pay Cycle),
PAYUSPRT.EXE (Print Internal Reports) and the PRINTGOV.EXE (Print
Government Reports) programs. You may print these sample reports
if you wish by using the DOS COPY command. Line up your printer
and at the DOS Prompt for \PAYSLIDE type COPY SAMP_RPT.TXT PRN and
press Enter. About 26 pages will be printed.
1. REPORTS FROM PAYUSCYC.EXE (Pay Cycle)
=========================================
When processing a pay cycle the same edits are applied as are
applied when the cursor passes over a field on the PAYUSEDT.EXE
(Employee Add / Update) screens. Instead of pop up windows any
results of those edits are printed out on a status report like
this. Before processing the employees are sorted into
alphabetical order within status and pay method.
PAYROLL CALCULATION - STATUS REPORT Page 1
PROCESSED ON 07-Feb-1990 at 18:31 hrs.
YOUR COMPANY NAME
THE FOLLOWING EMPLOYEES ARE STATUS "A" AND PAY METHOD "H" :
Processing Anderson, Janette SSN 874-04-5116 Empl# 8
Processing Carter, Pauline SSN 368-12-1382 Empl# 10
Processing Davis, George SSN 193-64-3728 Empl# 9
Processing Davis, Gillian SSN 595-27-8117 Empl# 7
Processing Lalonde, Norman SSN 781-08-5653 Empl# 6
PAYROLL USA SAMPLE REPORTS, FEB. 1990 - PAGE 2
PAYROLL CALCULATION - STATUS REPORT Page 2
PROCESSED ON 07-Feb-1990 at 18:32 hrs.
YOUR COMPANY NAME
THE FOLLOWING EMPLOYEES ARE STATUS "A" AND PAY METHOD "S" :
Processing Anderson, Thomas SSN 961-04-8467 Empl# 1
Processing Thompson, Gillian SSN 600-80-7768 Empl# 5
Processing Walsh, George SSN 817-98-2857 Empl# 3
Processing Yates, Susan SSN 974-33-5014 Empl# 4
Processing Zylik, Thomas SSN 170-56-9330 Empl# 2
PAYROLL USA SAMPLE REPORTS, FEB. 1990 - PAGE 3
2. REPORTS FROM PAYUSPRT.EXE (Internal Reports)
================================================
2a. Reports based on PAYUSA.DTA (Employee) file
------------------------------------------------
Each employee's basic information can be printed out in a format
which looks exactly like the first three employee update screens of
PAYUSEDT.EXE . This optional print out is however done from
PAYUSPRT.EXE . You can select to print all employees or skip
printing of terminated employees. You cannot do individual
employees, if you need that bring them up on the PAYUSEDT (Employee
Update) Screens and use the Shift PrtSc feature of your computer.
PAYROLL USA SAMPLE REPORTS, FEB. 1990 - PAGE 4
EMPLOYEE INFORMATION PRINTED ON 07-Feb-1990 at 18:38 hrs.
===============================
SSN 874-04-5116 EMPL NUM 8 PREV EMPL NUM
SURNAME Anderson FIRST NAME Janette
STREET 173 Kerr Street PHONE 416-845-7959
TOWN SACRAMENTO
STATE California ZIP CODE 94299-1234
SEX F MARRIED S YR BORN 1964 MO BORN 7 DAY BORN 10 AGE 25
OCCUPATION Secretary EMPLOYEE TYPE REG EMPLOYEE STATUS A
YR LAST REVIEW 1989 MO LAST REVIEW 4 DAY LAST REVIEW 26
YR NEXT REVIEW 1990 MO NEXT REVIEW 4 DAY NEXT REVIEW 26
PAY METHOD H SALARY TERRITORY II SALARY LEVEL 11 SALARY PERFORMANCE C
ANNUAL SALARY 0.00 HOURLY RATE 9.2500 PAY FREQ 26
OVERTIME PERMITTED TRUE
VACATION ACCRUAL P'CENT 4.0000 VACATION ALLOW 10day VACATION TAKEN
SICK ACCRUAL P'CENT 0.0000 SICK ALLOW SICK TAKEN
START YEAR 1988 START MO 4 START DAY 26
END YEAR 0 END MO 0 END DAY 0 REASON TERMINATED
EXEMPT FED TAX FALSE VOL FED ADDTNL WHOLDG 0.00
NUM OF FED EXEMPTIONS 3
EIC W5 FILED FALSE EIC W5 SPOUSE FILED FALSE
W2 BOX 16 LINE 1 DESC Employer Contrb
W2 BOX 16 LINE 2 DESC 401(k), etc.
EXEMPT SOC SEC FALSE MEDICARE QUALIFIED FED EMPL FALSE
EXEMPT FUTA FALSE
EXEMPT STATE TAX FALSE VOL STATE ADDTNL WHOLDG 0.00
NUM OF REG. STATE EXEMPTIONS 3 NUM OF ADDL. STATE EXEMPTIONS 0
EXEMPT SUTA FALSE
EXEMPT LOCAL TAX TRUE
NUM OF LOCAL EXEMPTIONS 0 NON RESIDENT FOR LOCAL FALSE
PAYROLL USA SAMPLE REPORTS, FEB. 1990 - PAGE 5
We also made provision to optionally print out mailing labels. This
also is done in PAYUSPRT.EXE . You can select to print all
employees or skip printing of terminated employees.
Janette Anderson
173 Kerr Street
SACRAMENTO
California 94299-1234
George Davis
258 Chartwell
SACRAMENTO
California 94299-1234
Gillian Davis
840 White Oakes
SACRAMENTO
California 94299-1234
Norman Lalonde
892 Kerr Street
SACRAMENTO
California 94299-1234
Thomas Anderson
290 Lakeshore Rd. W.
SACRAMENTO
California 94299-1234
Gillian Thompson
422 Bronte Rd.
SACRAMENTO
California 94299-1234
George Walsh
117 Trafalgar Rd.
SACRAMENTO
California 94299-1234
Susan Yates
847 Sandlewood
SACRAMENTO
California 94299-1234
Thomas Zylik
162 Pinegrove
SACRAMENTO
California 94299-1234
PAYROLL USA SAMPLE REPORTS, FEB. 1990 - PAGE 6
2b. Reports based on PAYUSCUR.DTA / PAYUSYTD.DTA files
(The Current and YTD Accounting Extract Files)
-------------------------------------------------------
The Accounting Files extracted by the Pay Cycle, PAYUSCUR.DTA AND
PAYUSYTD.DTA, are used to produce ALL the remaining reports produced
by PAYUSPRT.EXE. These files are sorted on G.L. Account Number,
Branch, and Department so that is the sequence the Employees appear
in on the remaining reports. We have provided a means (in the
Configuration Program) to allow you to change the "Other" type lines
on the checks, pay slips, and pay register to read whatever you wish
- e.g. "Ded. Othr 1" might be changed to read "Calif. SDI". You
may also enter and save your own G.L. Account Numbers, through the
Configuration Program, for printing on the Journal Report.
Except for the W2's the remaining reports are first sorted into
alphabetical order within G.L./Branch/Dept/Project so they can be
sub totalled on G.L./Branch/Dept/Project.
For Companies who have a cash payroll, or who prefer to issue manual
checks, pay slips can be printed as follows. If folded on the
dotted line they will fit into window envelopes for distribution.
Note that only non zero items are printed to reduce clutter. Even
if you are using manual checks we still provide you with a Check
Register, except you have to enter the check numbers yourself.
PAYROLL USA SAMPLE REPORTS, FEB. 1990 - PAGE 7
YOUR COMPANY NAME
EMPLOYEE PAY STATEMENT FOR 16-Feb-1990
Employee Number 7 Social Security No. 595-27-8117
Branch Code SAC Dept. Code ACT
Gillian Davis
840 White Oakes
SACRAMENTO
California 94299-1234
---
CURRENT AND YTD FIGURES:
Hourly Rate 10.75 0.00
Reg Pay Hours 75.00 300.00
Otime 1 Hrs 5.00 20.00
Reg Wages 806.25 3225.00
Otime 1 Amt 80.63 322.52
Shift Premium 24.30 97.20
Tot Actl. Pay 911.18 3644.72
Taxable Pay 911.18 3644.72
Federal Tax 94.27 377.08
State Tax 23.68 94.72
FICA Soc Sec. 69.70 278.80
Ded. Medical 20.00 80.00
Ded. Dental 10.00 40.00
Ded.Soc. Club 5.00 20.00
Calif. SDI 8.20 32.80
Total Deduct 230.85 923.40
Net Pay 680.33 2721.32
Issue Check 680.33 2721.32
PAYROLL USA SAMPLE REPORTS, FEB. 1990 - PAGE 8
PAYROLL CHECK REGISTER Page 1
=======================
PROCESSED ON 07-Feb-1990 at 18:34 hrs.
YOUR COMPANY NAME
Check Check Employee Name Check
Number Date (Payee) Amount
------ ---- ------------- -------
_________ 16-Feb-1990 Gillian Davis 680.33
_________ 16-Feb-1990 Thomas Zylik 1106.54
_________ 16-Feb-1990 Norman Lalonde 800.38
_________ 16-Feb-1990 Gillian Thompson 829.66
_________ 16-Feb-1990 George Walsh 1052.33
_________ 16-Feb-1990 Susan Yates 970.13
_________ 16-Feb-1990 Thomas Anderson 1745.96
_________ 16-Feb-1990 Janette Anderson 593.71
_________ 16-Feb-1990 Pauline Carter 350.80
_________ 16-Feb-1990 George Davis 508.90
Total Checks Issued 8638.74
PAYROLL USA SAMPLE REPORTS, FEB. 1990 - PAGE 9
As an alternative to Pay Slips you may optionally print Checks with
the pay slip information on the tear off stub. The Checks are
formatted to fit on Carbonless Multi-Purpose Check Forms such as
the DeLuxe Check Form #091004 or the Moore Business Products Check
Series 7030. DeLuxe have a toll free order line 1-800-356-7552 ,
please mention our keycode CO5778 (letters CO, numbers 5778) to
ensure fastest service. The employee name and address is in the
correct position for a window envelope. The checks of course are
continuous forms, with tear off tractor feed holes, for your
system printer. This is a very popular 7 inch long form with the
check on the TOP half and a blank stub on the bottom 3 1/2 inches of
the form, there are no pre-printed boxes on the stub so the same
form may also be used for Accounts Payable. If your existing check
form has a blank stub on the top rather than the bottom it may still
be usable by starting the print half way down the first check so the
stub of the second check is used for the first check. Only non zero
items are printed on the Check stubs, and a Check Register is also
printed, like this
FIRST A LINE UP CHECK (Repeats as many times as needed)
CHECKS ARE SPACED 7 INCHES APART (NOT SHOWN HERE)
-------------------------------------------------------
12345678
Six Hundred Eighty and 33/100
16-Feb-1990 $****680.33
**************** ****************,
*********************************,
*********************************,
**********************, *****-****
12345678
CURR. & YTD PAY **************** ****************, 16-Feb-1990, Empl# *********
Hourly Rate 10.75 0.00 Total Deduct 230.85 0.00
Reg Pay Hours 75.00 0.00 Net Pay 680.33 0.00
Otime 1 Hrs 5.00 0.00 Issue Check 680.33 0.00
Reg Wages 806.25 0.00
Otime 1 Amt 80.63 0.00
Shift Premium 24.30 0.00
Tot Actl. Pay 911.18 0.00
Taxable Pay 911.18 0.00
Federal Tax 94.27 0.00
State Tax 23.68 0.00
FICA Soc Sec. 69.70 0.00
Ded. Medical 20.00 0.00
Ded. Dental 10.00 0.00
Ded.Soc. Club 5.00 0.00
Calif. SDI 8.20 0.00
PAYROLL USA SAMPLE REPORTS, FEB. 1990 - PAGE 10
THEN THE ACTUAL CHECKS (Some omitted from here to save space)
FOLLOWED BY THE CHECK REGISTER.
-------------------------------------------------------------
123456
Six Hundred Eighty and 33/100
16-Feb-1990 $****680.33
Gillian Davis,
840 White Oakes,
SACRAMENTO,
California, 94299-1234
123456
CURR. & YTD PAY Gillian Davis, 16-Feb-1990, Empl# 7
Hourly Rate 10.75 0.00 Total Deduct 230.85 923.40
Reg Pay Hours 75.00 300.00 Net Pay 680.33 2721.32
Otime 1 Hrs 5.00 20.00 Issue Check 680.33 2721.32
Reg Wages 806.25 3225.00
Otime 1 Amt 80.63 322.52
Shift Premium 24.30 97.20
Tot Actl. Pay 911.18 3644.72
Taxable Pay 911.18 3644.72
Federal Tax 94.27 377.08
State Tax 23.68 94.72
FICA Soc Sec. 69.70 278.80
Ded. Medical 20.00 80.00
Ded. Dental 10.00 40.00
Ded.Soc. Club 5.00 20.00
Calif. SDI 8.20 32.80
PAYROLL USA SAMPLE REPORTS, FEB. 1990 - PAGE 11
PAYROLL CHECK REGISTER Page 1
=======================
PROCESSED ON 07-Feb-1990 at 18:33 hrs.
YOUR COMPANY NAME
Check Check Employee Name Check
Number Date (Payee) Amount
------ ---- ------------- -------
123456 16-Feb-1990 Gillian Davis 680.33
123457 16-Feb-1990 Thomas Zylik 1106.54
123458 16-Feb-1990 Norman Lalonde 800.38
123459 16-Feb-1990 Gillian Thompson 829.66
123460 16-Feb-1990 George Walsh 1052.33
123461 16-Feb-1990 Susan Yates 970.13
123462 16-Feb-1990 Thomas Anderson 1745.96
123463 16-Feb-1990 Janette Anderson 593.71
123464 16-Feb-1990 Pauline Carter 350.80
123465 16-Feb-1990 George Davis 508.90
Total Checks Issued 8638.74
PAYROLL USA SAMPLE REPORTS, FEB. 1990 - PAGE 12
The Payroll Register can be printed from the current pay period
information or from the YTD information. Sub Totals and Totals are
printed. If printed from the YTD information note that, so current
pay is included, the figures are extracted from PAYUSA.DTA AFTER it
has been updated for the most recent pay cycle. Therefore the pay
date is set up for the next pay AFTER the last one processed. Note
that the YTD figures do not include the pay etc. for the pay date
shown - it has not been processed yet.
This printed report contains essentially the same information as is
in the optional translation to NewViews, dBASE, Symphony, Lotus 123,
or PC-File. The translation programs were provided so people who
use those programs for their Accounting functions can pick up the
figures from the computer file version of this report without having
to re-key them.
PAYROLL USA SAMPLE REPORTS, FEB. 1990 - PAGE 13
PAYROLL REGISTER Page 1
================
PROCESSED ON 07-Feb-1990 at 18:36 hrs.
YOUR COMPANY NAME
SSN 595-27-8117 170-56-9330 SUB-TOTAL 781-08-5653
Empl. Num 7 2 FOR 6
Sur Name Davis Zylik G.L. ACCOUNT Lalonde
First Name Gillian Thomas AND BRANCH / Norman
Annual Salary 0.00 38000.00 DEPARTMENT 0.00
Hourly Rate 10.75 19.49 CODE BREAK 12.25
Pay Day 16-Feb-1990 16-Feb-1990 ************* 16-Feb-1990
G.L. Account
Branch Code SAC SAC SAC
Dept. Code ACT ACT DEV
Charge Projct PAYUSA PAYUSA PAYUSA
Comp.Calc Pay YES YES YES
Comp.Calc Tax YES YES YES
Reg Pay Hours 75.0000 75.0000 75.0000
Otime 1 Hrs 5.0000 5.0000 5.0000
Salary 1461.54 1461.54
Reg Wages 806.25 806.25 918.75
Otime 1 Amt 80.63 80.63 91.88
Shift Premium 24.30 24.30 24.30
Tot Actl. Pay 911.18 1461.54 2372.72 1034.93
Taxable Pay 911.18 1461.54 2372.72 1034.93
Federal Tax 94.27 164.13 258.40 100.14
State Tax 23.68 30.91 54.59 10.93
FICA Soc Sec. 69.70 111.81 181.51 79.17
Ded. Medical 20.00 20.00 40.00 20.00
Ded. Dental 10.00 10.00 20.00 10.00
Ded.Soc. Club 5.00 5.00 10.00 5.00
Calif. SDI 8.20 13.15 21.35 9.31
Total Deduct 230.85 355.00 585.85 234.55
Net Pay 680.33 1106.54 1786.87 800.38
Issue Check 680.33 1106.54 1786.87 800.38
Vac. Accrued 36.45 89.45 125.90 41.40
FUTA Wage 911.18 1461.54 2372.72 1034.93
FUTA Liab 56.49 90.62 147.11 64.17
FUTA State Cr 49.20 78.92 128.12 55.89
SUTA Wage 911.18 1461.54 2372.72 1034.93
SUTA Liab 33.71 54.08 87.79 38.29
941 S.S. Wge 911.18 1461.54 2372.72 1034.93
941 Total 911.18 1461.54 2372.72 1034.93
Amt S.S. Wge 139.41 223.62 363.03 158.34
Amt S.S. Totl 139.41 223.62 363.03 158.34
PAYROLL USA SAMPLE REPORTS, FEB. 1990 - PAGE 14
PAYROLL REGISTER Page 2
================
PROCESSED ON 07-Feb-1990 at 18:36 hrs.
YOUR COMPANY NAME
SSN 600-80-7768 817-98-2857 974-33-5014 SUB-TOTAL
Empl. Num 5 3 4 FOR
Sur Name Thompson Walsh Yates G.L. ACCOUNT
First Name Gillian George Susan AND BRANCH /
Annual Salary 30000.00 36000.00 33000.00 DEPARTMENT
Hourly Rate 15.38 18.46 16.92 CODE BREAK
Pay Day 16-Feb-1990 16-Feb-1990 16-Feb-1990 *************
G.L. Account
Branch Code SAC SAC SAC
Dept. Code DEV DEV DEV
Charge Projct PAYUSA PAYUSA PAYUSA
Comp.Calc Pay YES YES YES
Comp.Calc Tax YES YES YES
Reg Pay Hours 75.0000
Otime 1 Hrs 5.0000
Salary 1153.85 1384.62 1269.23 3807.70
Reg Wages 918.75
Otime 1 Amt 91.88
Shift Premium 24.30
Tot Actl. Pay 1153.85 1384.62 1269.23 4842.63
Taxable Pay 1153.85 1384.62 1269.23 4842.63
Federal Tax 146.67 152.60 135.29 534.70
State Tax 43.87 26.30 20.30 101.40
FICA Soc Sec. 88.27 105.93 97.09 370.46
Ded. Medical 20.00 20.00 20.00 80.00
Ded. Dental 10.00 10.00 10.00 40.00
Ded.Soc. Club 5.00 5.00 5.00 20.00
Calif. SDI 10.38 12.46 11.42 43.57
Total Deduct 324.19 332.29 299.10 1190.13
Net Pay 829.66 1052.33 970.13 3652.50
Issue Check 829.66 1052.33 970.13 3652.50
Vac. Accrued 46.15 84.74 50.77 223.06
FUTA Wage 1153.85 1384.62 1269.23 4842.63
FUTA Liab 71.54 85.85 78.69 300.25
FUTA State Cr 62.31 74.77 68.54 261.51
SUTA Wage 1153.85 1384.62 1269.23 4842.63
SUTA Liab 42.69 51.23 46.96 179.17
941 S.S. Wge 1153.85 1384.62 1269.23 4842.63
941 Total 1153.85 1384.62 1269.23 4842.63
Amt S.S. Wge 176.54 211.85 194.19 740.92
Amt S.S. Totl 176.54 211.85 194.19 740.92
PAYROLL USA SAMPLE REPORTS, FEB. 1990 - PAGE 15
PAYROLL REGISTER Page 3
================
PROCESSED ON 07-Feb-1990 at 18:36 hrs.
YOUR COMPANY NAME
SSN 961-04-8467 SUB-TOTAL 874-04-5116 368-12-1382
Empl. Num 1 FOR 8 10
Sur Name Anderson G.L. ACCOUNT Anderson Carter
First Name Thomas AND BRANCH / Janette Pauline
Annual Salary 70000.00 DEPARTMENT 0.00 0.00
Hourly Rate 35.90 CODE BREAK 9.25 5.15
Pay Day 16-Feb-1990 ************* 16-Feb-1990 16-Feb-1990
G.L. Account
Branch Code SAC SAC SAC
Dept. Code EXE SEC SEC
Charge Projct PAYUSA PAYUSA PAYUSA
Comp.Calc Pay YES YES YES
Comp.Calc Tax YES YES YES
Reg Pay Hours 75.0000 75.0000
Otime 1 Hrs 5.0000 5.0000
Salary 2692.31 2692.31
Reg Wages 693.75 386.25
Otime 1 Amt 69.38 38.62
Shift Premium 24.30 24.30
Tot Actl. Pay 2692.31 2692.31 787.43 449.17
Fringe Auto. 300.00 300.00
Taxable Pay 2992.31 2992.31 787.43 449.17
Federal Tax 572.75 572.75 75.71 24.97
State Tax 157.76 157.76 15.68
FICA Soc Sec. 228.91 228.91 60.24 34.36
Ded. Medical 20.00 20.00 20.00 20.00
Ded. Dental 10.00 10.00 10.00 10.00
Ded.Soc. Club 5.00 5.00 5.00 5.00
Calif. SDI 26.93 26.93 7.09 4.04
Total Deduct 1021.35 1021.35 193.72 98.37
Net Pay 1670.96 1670.96 593.71 350.80
Entertain Exp 25.00 25.00
Busn. Gas/Oil 50.00 50.00
Issue Check 1745.96 1745.96 593.71 350.80
Vac. Accrued 224.27 224.27 31.50 17.97
FUTA Wage 787.43 449.17
FUTA Liab 48.82 27.85
FUTA State Cr 42.52 24.26
SUTA Wage 787.43 449.17
SUTA Liab 29.13 16.62
941 S.S. Wge 2992.31 2992.31 787.43 449.17
941 Total 2992.31 2992.31 787.43 449.17
Amt S.S. Wge 457.82 457.82 120.48 68.72
Amt S.S. Totl 457.82 457.82 120.48 68.72
PAYROLL USA SAMPLE REPORTS, FEB. 1990 - PAGE 16
PAYROLL REGISTER Page 4
================
PROCESSED ON 07-Feb-1990 at 18:36 hrs.
YOUR COMPANY NAME
SSN 193-64-3728 SUB-TOTAL GRAND TOTAL
Empl. Num 9 FOR FOR
Sur Name Davis G.L. ACCOUNT THIS
First Name George AND BRANCH / PAY PERIOD
Annual Salary 0.00 DEPARTMENT
Hourly Rate 7.20 CODE BREAK *************
Pay Day 16-Feb-1990 *************
G.L. Account
Branch Code SAC
Dept. Code SEC
Charge Projct PAYUSA
Comp.Calc Pay YES
Comp.Calc Tax YES
Reg Pay Hours 75.0000 225.0000 375.0000
Otime 1 Hrs 5.0000 15.0000 25.0000
Salary 7961.55
Reg Wages 540.00 1620.00 3345.00
Otime 1 Amt 54.00 162.00 334.51
Shift Premium 24.30 72.90 121.50
Tot Actl. Pay 618.30 1854.90 11762.56
Fringe Auto. 300.00
Taxable Pay 618.30 1854.90 12062.56
Federal Tax 37.65 138.33 1504.18
State Tax 15.68 329.43
FICA Soc Sec. 47.30 141.90 922.78
Ded. Medical 20.00 60.00 200.00
Ded. Dental 10.00 30.00 100.00
Ded.Soc. Club 5.00 15.00 50.00
Calif. SDI 5.56 16.69 108.54
Total Deduct 125.51 417.60 3214.93
Net Pay 492.79 1437.30 8547.63
Advance EIC 16.11 16.11 16.11
Entertain Exp 25.00
Busn. Gas/Oil 50.00
Issue Check 508.90 1453.41 8638.74
Vac. Accrued 24.73 74.20 647.43
FUTA Wage 618.30 1854.90 9070.25
FUTA Liab 38.33 115.00 562.36
FUTA State Cr 33.39 100.17 489.80
SUTA Wage 618.30 1854.90 9070.25
SUTA Liab 22.88 68.63 335.59
941 S.S. Wge 618.30 1854.90 12062.56
941 Total 618.30 1854.90 12062.56
Amt S.S. Wge 94.60 283.80 1845.57
Amt S.S. Totl 94.60 283.80 1845.57
PAYROLL USA SAMPLE REPORTS, FEB. 1990 - PAGE 17
The Summary Journal Report suggest how you may wish to debit and
credit your accounting system. It would normally be produced from
the CURRENT file, but it can also be produced from the YTD file if
for example you wanted to check the balances in some of the G.L.
Accounts. Gross pay is broken out by current employee
G.L./Branch/Dept/Project identification in case you wish to
distribute pay costs between different cost centers within your
organization. These codes are on the current hours entry screen for
each employee and if entered they are concatonated and used as a
sort key on both the Payroll Register (above) and the Journal
(below). In the Journal they appear in the 4 lines starting
**********SACACTPAYUSA**** (the *'s represent unused codes)
PRINTED: 07-Feb-1990 at 18:36 hrs. Page 1
YOUR COMPANY NAME
SUMMARY JOURNAL ENTRIES FROM PAYROLL USA SYSTEM
FOR PAY DATE 16-Feb-1990
ACCOUNT
DESCRIPTION NUMBER DR. CR.
----------- ------ --- ---
Gross Pay Debit split by
GL/Branch/Dept./Project:
**********SACACTPAYUSA**** 5440 2372.72
**********SACDEVPAYUSA**** 5440 4842.63
**********SACEXEPAYUSA**** 5440 2692.31
**********SACSECPAYUSA**** 5440 1854.90
Federal Tax 2510 1504.18
State Tax 2520 329.43
FICA Soc Sec. 2540 922.78
Ded. Medical 2600 200.00
Ded. Dental 2610 100.00
Ded.Soc. Club 2650 50.00
Calif. SDI 2680 108.54
Net Pay 1100 8547.63
----------- -----------
TO RECORD EMPLOYEE PAY 11762.56 11762.56
=========== ===========
^
|___ NOTE, YOUR OWN GL ACCOUNT NUMBERS
CAN BE PRINTED HERE IF ENTERED IN
THE CONFIGURATION SECTION.
PAYROLL USA SAMPLE REPORTS, FEB. 1990 - PAGE 18
PRINTED: 07-Feb-1990 at 18:36 hrs. Page 2
YOUR COMPANY NAME
SUMMARY JOURNAL ENTRIES FROM PAYROLL USA SYSTEM
FOR PAY DATE 16-Feb-1990
ACCOUNT
DESCRIPTION NUMBER DR. CR.
----------- ------ --- ---
Fringe Auto. 5460 300.00
Advance EIC 2510 16.11
Entertain Exp 5760 25.00
Busn. Gas/Oil 5770 50.00
Vac. Accrued 5820 647.43
FUTA less St.Cr. 5840 72.56
COMPANY SUTA 5870 335.59
COMPANY FICA 5850 922.79
Fringe Auto. 2460 300.00
Advance EIC 1100 16.11
Entertain Exp 1100 25.00
Busn. Gas/Oil 1100 50.00
Vac. Accrued 2820 647.43
FUTA less St.Cr. 2840 72.56
COMPANY SUTA 2870 335.59
COMPANY FICA 2850 922.79
----------- -----------
TO RECORD ADDL. EMPLOYEE EXP. 2369.48 2369.48
=========== ===========
^
|___ NOTE, YOUR OWN GL ACCOUNT NUMBERS
CAN BE PRINTED HERE IF ENTERED IN
THE CONFIGURATION SECTION.
PAYROLL USA SAMPLE REPORTS, FEB. 1990 - PAGE 19
3. REPORTS FROM PRINTGOV.EXE
=============================
This program is restricted to REGISTERED USERS ONLY. It prints a
variety of Government Reports, 941, 940, Quarterly State
Unemployment, and W-2's. The 941 and 940 are in the form of
worksheets, the Quarterly State Unemployment is probably usable as
is in most States, and the W-2's follow the layout of the IRS form,
though that form is too thick to print on. If you can obtain
commercial pin feed equivalents with the same spacing you can print
directly on them, multiple times if necessary, else you will have to
transfer the information by hand to the IRS form.
PAYROLL USA SAMPLE REPORTS, FEB. 1990 - PAGE 20
IRS FORM 941 (FICA and FED.TAX) WORKSHEET FOR QUARTER 4 OF 1989
38-0000000
YOUR COMPANY NAME
999 Main Street
Your Co. Town
Your State 12345-6789
2 Wages etc. Subj. Withholding 86046.30
3 Income Tax Withheld 13428.56
5 Adjusted Income Tax Withheld 13428.56
6 Taxable Soc.Sec. Wages Paid 62261.42
Social Sec. Tax on Wages 9526.02
7a Taxable Tips 0.00
Social Sec. Tax on Tips 0.00
7c Taxable Hospital Insc. Wages 0.00
Social Sec. Tax on Hospital 0.00
8 Total Social Sec. Taxes 9526.02
10 Adjusted Social Sec. Taxes 9526.02
14 Total Taxes 22954.58
15 Advance Earned Inc. Credit 80.55
16 Net Taxes 22874.03
17 Total Deposits (add your Federal Tax Deposit Coupons, IRS Form 8109, 941
Taxes for this Quarter, or refer to your Accounting System record of tax
deposits actually made, then also complete lines 18 and 19 of the 941
form).
The following table has details of your Federal Income Tax & FICA liability
as recorded by PAYROLL USA. It corresponds to the table on the 941 form and
the dates will help you verify that this is a complete quarters figures (BE
PARTICULARLY CAREFUL IN THE FIRST QUARTER THAT YOU STARTED USING VERSION 2.0
OR LATER OF PAYROLL USA - FIGURES WILL NOT BE COMPLETE IF YOU STARTED THIS
VERSION PART WAY INTO THIS QUARTER).
It may not be necessary to copy all of this table onto the 941 form, in fact
if line 16 above is less than $500.00 none of it need be copied. What needs
to be copied depends on the amounts - see the IRS rules on deposits if in
doubt. The figures below will need adjustment if you are making any manual
adjustments to the figures above as the total for the quarter (below) must
balance to line 16 (above).
Days First Month Second Month Third Month
1 - 3 A 0.00 I 0.00 Q 0.00
4 - 7 B 0.00 J 0.00 R 0.00
8 - 11 C 0.00 K 2782.13 S 2782.13
12 - 15 D 2782.13 L 0.00 T 0.00
16 - 19 E 0.00 M 0.00 U 0.00
20 - 22 F 0.00 N 0.00 V 8963.38
23 - 25 G 0.00 O 2782.13 W 0.00
26 - 31 H 2782.13 P 0.00 X 0.00
MONTHLY I 5564.26 II 5564.26 III 11745.51
IV TOTAL FOR QUARTER 22874.03
PAYROLL USA SAMPLE REPORTS, FEB. 1990 - PAGE 21
IRS FORM 940 (FUTA) WORKSHEET FOR 1989
38-0000000
YOUR COMPANY NAME
999 Main Street
Your Co. Town
Your State 12345-6789
A All contributions to SUTA paid [X] YES [ ] NO
Amount of SUTA paid 2330.95
B Are ALL SUTA contributions one State [X] YES [ ] NO
State Name CALIF.
State Reporting Number 99-0000000
"A" will be marked NO if there is no Employer SUTA Liability on file.
"B" is based ONLY on this employee file, if you are using multiple employee
files for the same company you may need to modify this answer (and add
figures from the other files)
"C" will be marked YES if SUTA Wage on file is less than FUTA Wage
Please verify the above answers are correct.
PART I
1 Total Wages, etc. 318314.10
2 Exempt Payments 0.00
3 Excess over FUTA max. 255314.10
4 Total Exempt 255314.10
5 Total Taxable Wages 63000.00
"2 Exempt Payments" is determined by summing taxable pay for employees who
have "EXEMPT FUTA" set to TRUE on the tax setup screen. This should be set
only for those who really are exempt, not needed just to stop contributions
when the limit is reached (that is automatic).
Adjust by completing line 6 if necessary.
COMPLETE EITHER (PART II) OR (PART III + PART V), PLUS PART IV
PAYROLL USA ASSUMES YOU ARE COMPLETING PART II, IT DOES NOT HAVE SUFFICIENT
INFORMATION TO PROVIDE THE FIGURES FOR PART III + PART V - IF YOU NEED TO
COMPLETE PART III + PART V (I.E. YOUR ANSWER TO EITHER A OR B IS "NO" OR YOU
NEEDED TO CHECK C) THEN YOU MUST DO IT MANUALLY
PART II
1 FUTA Tax 503.98
3 Total FUTA Tax 503.98
Adjust by completing line 2 if necessary, then complete lines 4, 5, and 6
AFTER referring to your Accounting System to find the deposits of 940 tax
actually made.
PART IV
First Second Third Fourth Total Yr.
Liability for
Quarter 465.75 38.23 0.00 0.00 503.98
PAYROLL USA SAMPLE REPORTS, FEB. 1990 - PAGE 22
Figures shown in PART IV assume that PAYROLL USA Vers. 2.0 or later has been
in use for the full year AND that you qualify to complete PART II AND that
no manual adjustments were made to the figures printed above for PART I line
5 or PART II line 3.
PAYROLL USA SAMPLE REPORTS, FEB. 1990 - PAGE 23
YOUR COMPANY NAME
CALIF. STATE ID 99-0000000 FEDERAL ID 38-0000000
STATE UNEMPLOYMENT QUARTERLY REPORT
WORKSHEET FOR QUARTER 4 OF 1989 PAGE 1
Soc.Sec.Num. First & Last Name Total Wage
------------ ----------------- ----------
874-04-5116 Janette ANDERSON 5543.58
193-64-3728 George DAVIS 4352.78
595-27-8117 Gillian DAVIS 6414.78
781-08-5653 Norman LALONDE 7285.98
961-04-8467 Thomas ANDERSON 23784.88
600-80-7768 Gillian THOMPSON 8123.00
817-98-2857 George WALSH 10510.96
974-33-5014 Susan YATES 8935.40
170-56-9330 Thomas ZYLIK 11094.94
----------
TOTAL WAGES LISTED ON THIS PAGE 86046.30
----------
TOTAL WAGES LISTED ON ALL PAGES 86046.30
==========
PAYROLL USA SAMPLE REPORTS, FEB. 1990 - PAGE 24
YOUR COMPANY NAME
CALIF. STATE ID 99-0000000 FEDERAL ID 38-0000000
STATE UNEMPLOYMENT QUARTERLY REPORT
WORKSHEET FOR QUARTER 4 OF 1989 PAGE 2
NUMBER OF WORKERS LISTED 9
====
TOTAL WAGES PAID 86046.30
LESS WAGES IN EXCESS OF SUTA LIMIT 86046.30
----------
TAXABLE WAGES 0.00
==========
Complete the Calculation on the official form. The above figures
assume you have been using Vers. 2.0 or later of PAYROLL USA
for the whole of this Quarter. According to the calculations done
by PAYROLL USA your Quarterly State Unemployment Liability is:
Employee Paid State Unemployment 0.00
Company Paid State Unemployment 0.00
----------
TOTAL State Unemployment Liability 0.00
==========
PAYROLL USA SAMPLE REPORTS, FEB. 1990 - PAGE 25
W-2 PRINTING.
-------------
Note the SUB TOTAL and TOTAL W2's produced at the end for these 9
employees. The sub total goes to the IRS so it is counted as a W2.
The total is for transfer to the transmittal slip and should not be
sent to the IRS as a W2.
8
YOUR COMPANY NAME 38-0000000 99-0000000
999 Main Street
Your Co. Town
Your State 12345-6789
0.00 0.00
874-04-5116 2166.15 21292.18 1628.89
Janette ANDERSON 21292.18 0.00
Employer Contrb
173 Kerr Street 401(k), etc.
SACRAMENTO
California 94299-1234 477.96 21292.18 CALIF.
9
YOUR COMPANY NAME 38-0000000 99-0000000
999 Main Street
Your Co. Town
Your State 12345-6789
0.00 402.75
193-64-3728 1075.35 16718.78 1278.99
George DAVIS 16718.78 0.00
Employer Contrb
258 Chartwell 401(k), etc.
SACRAMENTO
California 94299-1234 19.99 16718.78 CALIF.
--------
Some W-2 forms included in the following totals were removed from
this file SAMP_RPT.TXT to reduce the size of the print out.
---------
PAYROLL USA SAMPLE REPORTS, FEB. 1990 - PAGE 26
YOUR COMPANY NAME 38-0000000 99-0000000
999 Main Street
Your Co. Town X
Your State 12345-6789
0.00 402.75
43012.76 318314.10 21877.61
** SUB TOTAL ** 285983.02 0.00
YOUR COMPANY NAME 38-0000000 99-0000000
999 Main Street
Your Co. Town X
Your State 12345-6789
0.00 402.75
43012.76 318314.10 21877.61
*** TOTAL *** 285983.02 0.00
10 W2 FORMS, T'FER FIGURES
TO W3 TRANSMITTAL FORM