Payroll.rdlx
4.125in
true
Tax
1.142857in
1.664286in
1.664286in
1.714286in
1.814286in
1.664286in
1.714286in
0.3in
true
=Fields!lastName.Value & ", " & Fields!firstName.Value
3
true
0.25in
true
['fica-ss']
=Fields.Item("['fica-ss']").Value
true
TextBox8
=Sum(Fields!grossPay.Value)
true
TextBox35
=Sum(Fields!grossPay.Value)
true
=Sum(Fields.Item("['fica-ss']").Value*Fields!grossPay.Value)
true
gross Pay
=Sum(Fields!grossPay.Value)
true
TextBox20
=Sum(Fields!grossPay.Value)
true
=Fields.Item("['fica-ss']").Value*Fields!grossPay.Value
0.25in
true
['fica-med']
=Fields.Item("['fica-med']").Value
true
TextBox10
=Sum(Fields!grossPay.Value)
true
=Sum(Fields!grossPay.Value)
true
['fica-med']
=Sum(((Fields.Item("['fica-med']").Value)/2)*Fields!grossPay.Value)
true
gross Pay
=Sum(Fields!grossPay.Value)
true
TextBox21
=Sum(Fields!grossPay.Value)
true
TextBox18
=Sum(((Fields.Item("['fica-med']").Value)/2)*Fields!grossPay.Value)
0.25in
true
['fica-med2']
=Fields.Item("['fica-med2']").Value
true
TextBox12
=Sum(Fields!grossPay.Value)
true
=Sum(Fields!grossPay.Value)
true
['fica-med2']
=Sum((Fields.Item("['fica-med2']").Value))*Fields!grossPay.Value
true
gross Pay
=Sum(Fields!grossPay.Value)
true
TextBox22
=Sum(Fields!grossPay.Value)
true
TextBox31
=Sum((Fields.Item("['fica-med2']").Value))*Fields!grossPay.Value
0.25in
true
futa
=Fields!futa.Value
true
TextBox14
=Sum(Fields!grossPay.Value)
true
=Sum(Fields!grossPay.Value)
true
futa
=Sum((Fields!futa.Value)*Fields!grossPay.Value)
true
gross Pay
=Sum(Fields!grossPay.Value)
true
TextBox23
=Sum(Fields!grossPay.Value)
true
TextBox33
=Sum((Fields!futa.Value)*Fields!grossPay.Value)
0.25in
true
true
TextBox16
=Sum(Fields!grossPay.Value)
true
=Sum(Fields!grossPay.Value)
true
fit
=Sum(Fields!fit.Value)
true
gross Pay
=Sum(Fields!grossPay.Value)
true
TextBox24
=Sum(Fields!grossPay.Value)
true
TextBox34
=Sum(Fields!fit.Value)
0.15in
true
true
true
true
true
true
true
0.25in
true
sit
=Fields!sit.Value
true
TextBox30
=Sum(Fields!grossPay.Value)
true
=Sum(Fields!grossPay.Value)
true
sit
=Sum((Fields!sit.Value)*Fields!grossPay.Value)
true
gross Pay
=Sum(Fields!grossPay.Value)
true
TextBox27
=Sum(Fields!grossPay.Value)
true
TextBox46
=Sum((Fields!sit.Value)*Fields!grossPay.Value)
0.35in
true
true
TextBox32
=Sum(Fields!grossPay.Value)
true
=Sum(Fields!grossPay.Value)
true
sui
=Sum((Fields!sui.Value))
true
gross Pay
=Sum(Fields!grossPay.Value)
true
TextBox29
=Sum(Fields!grossPay.Value)
true
TextBox48
=Sum((Fields!sui.Value))
=Quarter(Fields!payStart.Value)
0.5in
true
TextBox4
Rate
0.5in
true
QTD
Gross Wages
0.5in
QTD
Taxable Wages
0.5in
true
QTD
Taxes
=Year(Fields!payStart.Value)
0.5in
true
TextBox3
YTD
Gross Wages
0.5in
YTD
Taxable Wages
0.5in
YTD
Taxes
=Fields!employeeID.Value
1.571429in
true
employee ID
="Employee ID: " & Fields!employeeID.Value
1.571429in
true
FICA-SS
1.571429in
true
FICA-MED
1.571429in
true
FICA-MED2
1.571429in
true
FUTA
1.571429in
true
FIT
1.571429in
true
1.571429in
true
SIT
1.571429in
true
SUI
true
0.875in
12.95in
2.8in
employeePayroll
0.625in
13in
0.25in
1
true
January 1, 2022 - March 31, 2022
0.125in
13in
0.25in
1
true
Treadstone Financial
0.375in
13in
0.25in
1
true
Payroll Tax Summary - Detailed
0.15in
0.5in
8.5in
14in
0.5in
0.15in
13in
jsondata=[
{
"employeeID": 1,
"firstName": "Lauri",
"lastName": "Tunder",
"hoursWorked": 81,
"grossPay": 4999,
"fit": 599.88,
"sui": 159.7550795114,
"fica-med": 0.029,
"fica-med2": 0.0145,
"fica-ss": 0.124,
"futa": 0.006,
"sit": 0.0375,
"payStart": "October 1, 2021",
"payEnd": "October 15, 2021",
"state": "MI"
},
{
"employeeID": 2,
"firstName": "Hannie",
"lastName": "Cavnor",
"hoursWorked": 81,
"grossPay": 3406,
"fit": 408.72,
"sui": 151.7191208016,
"fica-med": 0.029,
"fica-med2": 0.0145,
"fica-ss": 0.124,
"futa": 0.006,
"sit": 0.0375,
"payStart": "October 1, 2021",
"payEnd": "October 15, 2021",
"state": "MI"
},
{
"employeeID": 3,
"firstName": "Clemmy",
"lastName": "Licciardello",
"hoursWorked": 77,
"grossPay": 2684,
"fit": 322.08,
"sui": 113.4576307621,
"fica-med": 0.029,
"fica-med2": 0.0145,
"fica-ss": 0.124,
"futa": 0.006,
"sit": 0.0375,
"payStart": "October 1, 2021",
"payEnd": "October 15, 2021",
"state": "MI"
},
{
"employeeID": 4,
"firstName": "Katalin",
"lastName": "Nudds",
"hoursWorked": 80,
"grossPay": 1509,
"fit": 181.08,
"sui": 80.4238886856,
"fica-med": 0.029,
"fica-med2": 0.0145,
"fica-ss": 0.124,
"futa": 0.006,
"sit": 0.0375,
"payStart": "October 1, 2021",
"payEnd": "October 15, 2021",
"state": "MI"
},
{
"employeeID": 5,
"firstName": "Tripp",
"lastName": "Noury",
"hoursWorked": 75,
"grossPay": 3462,
"fit": 415.44,
"sui": 159.3663332,
"fica-med": 0.029,
"fica-med2": 0.0145,
"fica-ss": 0.124,
"futa": 0.006,
"sit": 0.0375,
"payStart": "October 1, 2021",
"payEnd": "October 15, 2021",
"state": "MI"
},
{
"employeeID": 1,
"firstName": "Lauri",
"lastName": "Tunder",
"hoursWorked": 81,
"grossPay": 4999,
"fit": 599.88,
"sui": 159.7550795114,
"fica-med": 0.029,
"fica-med2": 0.0145,
"fica-ss": 0.124,
"futa": 0.006,
"sit": 0.0375,
"payStart": "October 16, 2021",
"payEnd": "October 31, 2021",
"state": "MI"
},
{
"employeeID": 2,
"firstName": "Hannie",
"lastName": "Cavnor",
"hoursWorked": 81,
"grossPay": 3406,
"fit": 408.72,
"sui": 151.7191208016,
"fica-med": 0.029,
"fica-med2": 0.0145,
"fica-ss": 0.124,
"futa": 0.006,
"sit": 0.0375,
"payStart": "October 16, 2021",
"payEnd": "October 31, 2021",
"state": "MI"
},
{
"employeeID": 3,
"firstName": "Clemmy",
"lastName": "Licciardello",
"hoursWorked": 77,
"grossPay": 2684,
"fit": 322.08,
"sui": 113.4576307621,
"fica-med": 0.029,
"fica-med2": 0.0145,
"fica-ss": 0.124,
"futa": 0.006,
"sit": 0.0375,
"payStart": "October 16, 2021",
"payEnd": "October 31, 2021",
"state": "MI"
},
{
"employeeID": 4,
"firstName": "Katalin",
"lastName": "Nudds",
"hoursWorked": 80,
"grossPay": 1509,
"fit": 181.08,
"sui": 80.4238886856,
"fica-med": 0.029,
"fica-med2": 0.0145,
"fica-ss": 0.124,
"futa": 0.006,
"sit": 0.0375,
"payStart": "October 16, 2021",
"payEnd": "October 31, 2021",
"state": "MI"
},
{
"employeeID": 5,
"firstName": "Tripp",
"lastName": "Noury",
"hoursWorked": 75,
"grossPay": 3462,
"fit": 415.44,
"sui": 159.3663332,
"fica-med": 0.029,
"fica-med2": 0.0145,
"fica-ss": 0.124,
"futa": 0.006,
"sit": 0.0375,
"payStart": "October 16, 2021",
"payEnd": "October 31, 2021",
"state": "MI"
},
{
"employeeID": 1,
"firstName": "Lauri",
"lastName": "Tunder",
"hoursWorked": 81,
"grossPay": 4999,
"fit": 599.88,
"sui": 159.7550795114,
"fica-med": 0.029,
"fica-med2": 0.0145,
"fica-ss": 0.124,
"futa": 0.006,
"sit": 0.0375,
"payStart": "November 1, 2021",
"payEnd": "November 15, 2021",
"state": "MI"
},
{
"employeeID": 2,
"firstName": "Hannie",
"lastName": "Cavnor",
"hoursWorked": 81,
"grossPay": 3406,
"fit": 408.72,
"sui": 151.7191208016,
"fica-med": 0.029,
"fica-med2": 0.0145,
"fica-ss": 0.124,
"futa": 0.006,
"sit": 0.0375,
"payStart": "November 1, 2021",
"payEnd": "November 15, 2021",
"state": "MI"
},
{
"employeeID": 3,
"firstName": "Clemmy",
"lastName": "Licciardello",
"hoursWorked": 77,
"grossPay": 2684,
"fit": 322.08,
"sui": 113.4576307621,
"fica-med": 0.029,
"fica-med2": 0.0145,
"fica-ss": 0.124,
"futa": 0.006,
"sit": 0.0375,
"payStart": "November 1, 2021",
"payEnd": "November 15, 2021",
"state": "MI"
},
{
"employeeID": 4,
"firstName": "Katalin",
"lastName": "Nudds",
"hoursWorked": 80,
"grossPay": 1509,
"fit": 181.08,
"sui": 80.4238886856,
"fica-med": 0.029,
"fica-med2": 0.0145,
"fica-ss": 0.124,
"futa": 0.006,
"sit": 0.0375,
"payStart": "November 1, 2021",
"payEnd": "November 15, 2021",
"state": "MI"
},
{
"employeeID": 5,
"firstName": "Tripp",
"lastName": "Noury",
"hoursWorked": 75,
"grossPay": 3462,
"fit": 415.44,
"sui": 159.3663332,
"fica-med": 0.029,
"fica-med2": 0.0145,
"fica-ss": 0.124,
"futa": 0.006,
"sit": 0.0375,
"payStart": "November 1, 2021",
"payEnd": "November 15, 2021",
"state": "MI"
},
{
"employeeID": 1,
"firstName": "Lauri",
"lastName": "Tunder",
"hoursWorked": 81,
"grossPay": 4999,
"fit": 599.88,
"sui": 159.7550795114,
"fica-med": 0.029,
"fica-med2": 0.0145,
"fica-ss": 0.124,
"futa": 0.006,
"sit": 0.0375,
"payStart": "November 16, 2021",
"payEnd": "November 30, 2021",
"state": "MI"
},
{
"employeeID": 2,
"firstName": "Hannie",
"lastName": "Cavnor",
"hoursWorked": 81,
"grossPay": 3406,
"fit": 408.72,
"sui": 151.7191208016,
"fica-med": 0.029,
"fica-med2": 0.0145,
"fica-ss": 0.124,
"futa": 0.006,
"sit": 0.0375,
"payStart": "November 16, 2021",
"payEnd": "November 30, 2021",
"state": "MI"
},
{
"employeeID": 3,
"firstName": "Clemmy",
"lastName": "Licciardello",
"hoursWorked": 77,
"grossPay": 2684,
"fit": 322.08,
"sui": 113.4576307621,
"fica-med": 0.029,
"fica-med2": 0.0145,
"fica-ss": 0.124,
"futa": 0.006,
"sit": 0.0375,
"payStart": "November 16, 2021",
"payEnd": "November 30, 2021",
"state": "MI"
},
{
"employeeID": 4,
"firstName": "Katalin",
"lastName": "Nudds",
"hoursWorked": 80,
"grossPay": 1509,
"fit": 181.08,
"sui": 80.4238886856,
"fica-med": 0.029,
"fica-med2": 0.0145,
"fica-ss": 0.124,
"futa": 0.006,
"sit": 0.0375,
"payStart": "November 16, 2021",
"payEnd": "November 30, 2021",
"state": "MI"
},
{
"employeeID": 5,
"firstName": "Tripp",
"lastName": "Noury",
"hoursWorked": 75,
"grossPay": 3462,
"fit": 415.44,
"sui": 159.3663332,
"fica-med": 0.029,
"fica-med2": 0.0145,
"fica-ss": 0.124,
"futa": 0.006,
"sit": 0.0375,
"payStart": "November 16, 2021",
"payEnd": "November 30, 2021",
"state": "MI"
},
{
"employeeID": 1,
"firstName": "Lauri",
"lastName": "Tunder",
"hoursWorked": 81,
"grossPay": 4999,
"fit": 599.88,
"sui": 159.7550795114,
"fica-med": 0.029,
"fica-med2": 0.0145,
"fica-ss": 0.124,
"futa": 0.006,
"sit": 0.0375,
"payStart": "December 1, 2021",
"payEnd": "December 15, 2021",
"state": "MI"
},
{
"employeeID": 2,
"firstName": "Hannie",
"lastName": "Cavnor",
"hoursWorked": 81,
"grossPay": 3406,
"fit": 408.72,
"sui": 151.7191208016,
"fica-med": 0.029,
"fica-med2": 0.0145,
"fica-ss": 0.124,
"futa": 0.006,
"sit": 0.0375,
"payStart": "December 1, 2021",
"payEnd": "December 15, 2021",
"state": "MI"
},
{
"employeeID": 3,
"firstName": "Clemmy",
"lastName": "Licciardello",
"hoursWorked": 77,
"grossPay": 2684,
"fit": 322.08,
"sui": 113.4576307621,
"fica-med": 0.029,
"fica-med2": 0.0145,
"fica-ss": 0.124,
"futa": 0.006,
"sit": 0.0375,
"payStart": "December 1, 2021",
"payEnd": "December 15, 2021",
"state": "MI"
},
{
"employeeID": 4,
"firstName": "Katalin",
"lastName": "Nudds",
"hoursWorked": 80,
"grossPay": 1509,
"fit": 181.08,
"sui": 80.4238886856,
"fica-med": 0.029,
"fica-med2": 0.0145,
"fica-ss": 0.124,
"futa": 0.006,
"sit": 0.0375,
"payStart": "December 1, 2021",
"payEnd": "December 15, 2021",
"state": "MI"
},
{
"employeeID": 5,
"firstName": "Tripp",
"lastName": "Noury",
"hoursWorked": 75,
"grossPay": 3462,
"fit": 415.44,
"sui": 159.3663332,
"fica-med": 0.029,
"fica-med2": 0.0145,
"fica-ss": 0.124,
"futa": 0.006,
"sit": 0.0375,
"payStart": "December 1, 2021",
"payEnd": "December 15, 2021",
"state": "MI"
},
{
"employeeID": 1,
"firstName": "Lauri",
"lastName": "Tunder",
"hoursWorked": 81,
"grossPay": 4999,
"fit": 599.88,
"sui": 159.7550795114,
"fica-med": 0.029,
"fica-med2": 0.0145,
"fica-ss": 0.124,
"futa": 0.006,
"sit": 0.0375,
"payStart": "December 16, 2021",
"payEnd": "December 31, 2021",
"state": "MI"
},
{
"employeeID": 2,
"firstName": "Hannie",
"lastName": "Cavnor",
"hoursWorked": 81,
"grossPay": 3406,
"fit": 408.72,
"sui": 151.7191208016,
"fica-med": 0.029,
"fica-med2": 0.0145,
"fica-ss": 0.124,
"futa": 0.006,
"sit": 0.0375,
"payStart": "December 16, 2021",
"payEnd": "December 31, 2021",
"state": "MI"
},
{
"employeeID": 3,
"firstName": "Clemmy",
"lastName": "Licciardello",
"hoursWorked": 77,
"grossPay": 2684,
"fit": 322.08,
"sui": 113.4576307621,
"fica-med": 0.029,
"fica-med2": 0.0145,
"fica-ss": 0.124,
"futa": 0.006,
"sit": 0.0375,
"payStart": "December 16, 2021",
"payEnd": "December 31, 2021",
"state": "MI"
},
{
"employeeID": 4,
"firstName": "Katalin",
"lastName": "Nudds",
"hoursWorked": 80,
"grossPay": 1509,
"fit": 181.08,
"sui": 80.4238886856,
"fica-med": 0.029,
"fica-med2": 0.0145,
"fica-ss": 0.124,
"futa": 0.006,
"sit": 0.0375,
"payStart": "December 16, 2021",
"payEnd": "December 31, 2021",
"state": "MI"
},
{
"employeeID": 5,
"firstName": "Tripp",
"lastName": "Noury",
"hoursWorked": 75,
"grossPay": 3462,
"fit": 415.44,
"sui": 159.3663332,
"fica-med": 0.029,
"fica-med2": 0.0145,
"fica-ss": 0.124,
"futa": 0.006,
"sit": 0.0375,
"payStart": "December 16, 2021",
"payEnd": "December 31, 2021",
"state": "MI"
}
]
JSON
employeeID
firstName
lastName
hoursWorked
grossPay
fit
sui
['fica-med']
['fica-med2']
['fica-ss']
futa
sit
payStart
payEnd
state
$.[*]
payroll
PaperOrientation
Landscape