0% found this document useful (0 votes)
24 views18 pages

Child Expense and Payment Summary 2014-2022

Uploaded by

moonlightsshadw
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
24 views18 pages

Child Expense and Payment Summary 2014-2022

Uploaded by

moonlightsshadw
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

John 2014

Date Child Expense Total Cost 50% Of Cost Payments Balance


1/1/2014 Prior Year Balance $ (32.15)
1/2/2014 John Payment - 100.00 (132.15)
1/6/2014 Daycare 165.00 82.50 (49.65)
1/7/2014 John Payment - 75.00 (124.65)
1/13/2014 Daycare 165.00 82.50 (42.15)
1/15/2014 Health/Dental/Vision 17.18 8.59 (33.56)
1/20/2014 Daycare 165.00 82.50 48.94
1/27/2014 Daycare 165.00 82.50 131.44
1/31/2014 Health/Dental/Vision 17.18 8.59 140.03
1/31/2014 John Payment - 100.00 40.03
2/3/2014 Daycare 165.00 82.50 122.53
2/3/2014 John Payment - 100.00 22.53
2/10/2014 Daycare 165.00 82.50 105.03
2/15/2014 Health/Dental/Vision 17.18 8.59 113.62
2/17/2014 Daycare 165.00 82.50 196.12
2/21/2014 John Payment - 200.00 (3.88)
2/24/2014 Daycare 165.00 82.50 78.62
2/28/2014 Health/Dental/Vision 17.18 8.59 87.21
3/1/2014 Rachel Amoxicillin 9.20 4.60 91.81
3/3/2014 Daycare 165.00 82.50 174.31
3/5/2014 John Payment - 200.00 (25.69)
3/5/2014 John Payment 100.00 (125.69)
3/10/2014 Daycare 165.00 82.50 (43.19)
3/14/2014 Health/Dental/Vision 17.18 8.59 (34.60)
3/17/2014 Daycare 165.00 82.50 47.90
3/22/2014 John Payment - 150.00 (102.10)
3/24/2014 Health/Dental/Vision 17.18 8.59 (93.51)
3/31/2014 Daycare 165.00 82.50 (11.01)
3/31/2014 John Payment - 100.00 (111.01)
Charge Covered Our Cost
Exam 165 -155 10 copay
Refraction 44 -44 0 part of exam
Frame 180 -156 24 Frame Allowance+20% Off
SV Essilor 125 -25 100 20% discount
Polycarbonate 55 -11 44 20% discount
Aspheric 25 -25 0 Single lens
AR-Crizal 130 -26 104 20% discount
724 -442 282
John 2022

Date Child Expense Total Cost 50% Of Cost Payments


1/1/2022 Previous Balance
1/1/2022 Medical, Dental, Vision 85.10 42.55
1/9/2022 John Payment - 150.00
1/31/2022 Rachel Meds 10.00 5.00
2/1/2022 Medical, Dental, Vision 85.10 42.55
2/26/2022 Rachel Meds 10.00 5.00
3/1/2022 Medical, Dental, Vision 85.10 42.55
3/26/2022 Rachel Meds 10.00 5.00
4/1/2022 Medical, Dental, Vision 85.10 42.55
5/1/2022 Medical, Dental, Vision 85.10 42.55
5/2/2022 Rachel Meds 10.00 5.00
5/24/2022 John Payment - 150.00
5/26/2022 Rachel Eye Dr. & Glasses 284.40 142.20
6/1/2022 Medical, Dental, Vision 85.10 42.55
6/9/2022 Rachel Meds 10.00 5.00
7/1/2022 Medical, Dental, Vision 85.10 42.55
7/7/2022 Rachel Meds 10.00 5.00
7/9/2022 John Payment - 200.00
8/1/2022 Medical, Dental, Vision 85.10 42.55
8/9/2022 Rachel Meds 10.00 5.00
8/11/2022 Rachel Dr. - Catalpa Health 55.00 27.50
8/12/2022 John Payment - 100.00
8/17/2022 Pictures 26.00 13.00
9/1/2022 Medical, Dental, Vision 85.10 42.55
9/19/2022 Rachel Meds 10.00 5.00
10/1/2022 Medical, Dental, Vision 85.10 42.55
10/4/2022 John Payment - 100.00
10/1/2022 Rachel Dr. - Catalpa Health 55.00 27.50
10/19/2022 Rachel Meds 10.00 5.00
11/1/2022 Medical, Dental, Vision 85.10 42.55
11/8/2022 John Payment - 100.00
12/1/2022 Medical, Dental, Vision 85.10 42.55
Balance
$ 39.20
$ 81.75
$ (68.25)
$ (63.25)
$ (20.70)
$ (15.70)
$ 26.85
$ 31.85
$ 74.40
$ 116.95
$ 121.95
$ (28.05)
$ 114.15
$ 156.70
$ 161.70
$ 204.25
$ 209.25
$ 9.25
$ 51.80
$ 56.80
$ 84.30
$ (15.70)
$ (2.70)
$ 39.85
$ 44.85
$ 87.40
$ (12.60)
$ 14.90
$ 19.90
$ 62.45
$ (37.55)
$ 5.00
Charge Covered Our Cost
Exam 175 -165 10.00 copay
Refraction 46 -46 - part of exam
Frame 291 -178.2 112.80 Frame Allowance+20% Off
SV Essilor 140 -28 112.00 20% discount
Polycarbon 55 -11 44.00 20% discount
Aspheric 25 -25 - Single lens
AR-Crizal 140 -28 112.00 20% discount
872 -481.2 $ 390.80
2013 Employee Employee/Child Difference
Medical UHV/HSP 26.79 54.92 28.13
Dental 8.98 20.89 11.91
Vision VSP Full Feature 3.67 7.86 4.19
Total 44.23

2014 Employee Employee/Child Difference


Medical UHV/HSP 33.42 68.5 35.08
Dental 9.53 21.72 12.19
Vision VSP Full Feature 3.75 8.02 4.27
Total 51.54

2014 - COBRA & Badger Employee Employee/Child Difference


BadgerCare 0 69 69
Dental 38.88 88.62 49.74
Vision VSP Full Feature 7.64 16.36 8.72
Total 127.46

2015 Employee Employee/Child Difference


Medical High Deductible (HRA-NonTobacco) 154.76 250.42 95.66
Dental 17.7 41.08 23.38
Vision VSP Full Feature (COBRA) 3.75 8.02 4.27
Total 123.31

2016 Employee Employee/Child Difference


Premier HAS 197.70 324.78 127.08
Delta Dental 18.06 41.90 23.84
Superior Vision 12.50 25.00 12.5
Total 163.42

2017 Employee Employee/Child Difference


BadgerCare - - -
Delta Dental 19.14 44.42 25.28
Superior Vision 13.00 26.00 13.00
Total 38.28

2018 Employee Employee/Child Difference


BadgerCare - - -
Delta Dental 21.44 49.74 28.30
Superior Vision 13.00 26.00 13.00
Total 41.3

2018-June Employee Employee/Child Difference


BadgerCare - - -
Delta Dental 21.44 49.74 28.30
Superior Vision 13.00 26.00 13.00
Total 41.3

2019 Employee Employee/Child Difference


BadgerCare - - -
Delta Dental 23.36 54.22 30.86
VPS 9.88 25.52 15.64
Total 46.5

2020 Employee Employee/Child Difference


BadgerCare - - -
Delta Dental 23.36 54.22 30.86
VPS 9.82 25.52 15.70
Total 46.56

2020-November Employee Employee/Child Difference


UHC Traditional 167.00 315.00 148.00
Delta Dental 23.36 54.22 30.86
VPS 9.82 25.52 15.70
Total 194.56

2021 Employee Employee/Child Difference


UHC Traditional 167.00 315.00 148.00
Delta Dental (Family Rates) 12.42 20.76 8.34
Eyemed 5.40 10.26 4.86
Total 161.2

2022 Employee Employee/Child Difference


UHC Traditional 177.00 334.00 157.00
Delta Dental (Family Rates) 12.42 20.76 8.34
Eyemed 5.40 10.26 4.86
Total 170.2

2023 Employee Employee/Child Difference


UHC Traditional 186.00 350.00 164.00
Delta Dental (Family Rates) 12.42 20.76 8.34
Eyemed 5.40 10.26 4.86
Total 177.2

2024 Employee Employee/Child Difference


UHC Traditional 194.50 366.50 172.00
Delta Dental (Family Rates) 12.42 20.76 8.34
Eyemed 5.40 14.86 9.46
Total 189.8
1/3 of Premium Parent Portion
9.38 4.69
3.97 1.98
1.40 0.70
14.74 7.37

1/3 of Premium Parent Portion


11.69 5.85
4.06 2.03
1.42 0.71
17.18 8.59

1/3 of Premium Parent Portion


23.00 11.50
16.58 8.29
2.91 1.45
42.48 21.24

1/3 of Premium Parent Portion


31.88 15.94 ***Rates listed on form are per pay period (24 per year)
7.79 3.90 ***Rates listed on form are per pay period (24 per year)
1.42 0.71
41.10 20.55

1/3 of Premium Parent Portion


42.36 21.18 ***Rates listed on form are per pay period (24 per year)
7.95 3.97 ***Rates listed on form are per pay period (24 per year)
4.17 2.08 ***Rates listed on form are per pay period (24 per year)
54.47 27.23

1/3 of Premium Parent Portion


- - *Copays for Visits and Medication
8.43 4.21 ***Rates listed on form are per pay period (24 per year)
4.33 2.17 ***Rates listed on form are per pay period (24 per year)
12.76 6.38

1/3 of Premium Parent Portion


- - *Copays for Visits and Medication
9.43 4.72 ***Rates listed on form are per pay period (24 per year)
4.33 2.17 ***Rates listed on form are per pay period (24 per year)
13.77 6.88

1/2 of Premium Parent Portion


- - *Copays for Visits and Medication
14.15 7.08 ***Rates listed on form are per pay period (24 per year)
6.50 3.25 ***Rates listed on form are per pay period (24 per year)
20.65 10.33

1/2 of Premium Parent Portion


- - *Copays for Visits and Medication
15.43 7.72 ***Rates listed on form are per pay period (24 per year)
7.82 3.91 ***Rates listed on form are per pay period (24 per year)
23.25 11.63

1/2 of Premium Parent Portion


- - *Copays for Visits and Medication
15.43 7.72 ***Rates listed on form are per pay period (24 per year)
7.85 3.93 ***Rates listed on form are per pay period (24 per year)
23.28 11.64

1/2 of Premium Parent Portion


74.00 37.00 ***Rates listed on form are monthly
15.43 7.72 ***Rates listed on form are per pay period (24 per year)
7.85 3.93 ***Rates listed on form are per pay period (24 per year)
97.28 48.64

1/2 of Premium Parent Portion


74.00 37.00 ***Rates listed on form are monthly
4.17 1.04 *Rates listed on form are monthly. Discounted out my portion.
2.43 1.21 ***Rates listed on form are monthly
80.60 40.30

1/2 of Premium Parent Portion


78.50 39.25 ***Rates listed on form are monthly
4.17 1.04 *Rates listed on form are monthly. Discounted out my portion.
2.43 1.21 ***Rates listed on form are monthly
85.10 42.55

1/2 of Premium Parent Portion


82.00 41.00 ***Rates listed on form are monthly
4.17 1.04 *Rates listed on form are monthly. Discounted out my portion.
2.43 1.21 ***Rates listed on form are monthly
88.60 44.30

1/2 of Premium Parent Portion


86.00 43.00 ***Rates listed on form are monthly
4.17 1.04 *Rates listed on form are monthly. Discounted out my portion.
4.73 2.36 ***Rates listed on form are monthly
94.90 47.45
John 2023

Date Child Expense Total Cost 50% Of Cost Payments


1/1/2023 Previous Balance
1/1/2023 Medical, Dental, Vision 88.60 44.30
2/1/2023 John Payment - 100.00
2/1/2023 Medical, Dental, Vision 88.60 44.30
2/17/2023 Rachel Meds 40.00 20.00
2/22/2023 Camp Fee + Bus 525.00 262.50
2/28/2023 John Payment - 100.00
3/1/2023 Medical, Dental, Vision 88.60 44.30
3/9/2023 Orthodontics 3,650.00 1,825.00
3/10/2023 John Payment - 350.00
3/18/2023 Rachel Meds 40.00 20.00
3/28/2023 John Payment - 100.00
4/1/2023 Medical, Dental, Vision 88.60 44.30
4/11/2023 John Payment - 100.00
4/15/2023 Rachel Meds 40.00 20.00
4/25/2023 John Payment - 100.00
5/1/2023 Medical, Dental, Vision 88.60 44.30
5/9/2023 John Payment - 100.00
5/12/2023 Rachel ADHD Med 42.00 21.00
5/23/2023 Rachel Anxiety Med 4.53 2.27
5/23/2023 John Payment - 100.00
6/1/2023 Medical, Dental, Vision 88.60 44.30
6/6/2023 John Payment - 100.00
6/12/2023 Rachel Catalpa Visit (5/23/23) 55.00 27.50
6/13/2023 Rachel Eye Exam & Glasses 390.80 195.40
6/18/2023 Rachel ADHD Med 42.00 21.00
6/21/2023 John Payment - 100.00
6/26/2013 Rachel Anxiety Med 4.69 2.35
7/1/2023 Medical, Dental, Vision 88.60 44.30
7/5/2023 John Payment - 100.00
7/17/2023 Rachel ADHD Med 42.00 21.00
7/18/2023 John Payment - 100.00
7/21/2023 School Pictures 26.00 13.00
7/27/2023 Rachel Anxiety Med 4.69 2.35
8/1/2023 John Payment - 100.00
8/1/2023 Medical, Dental, Vision 88.60 44.30
8/11/2023 John Payment - 200.00
8/15/2023 Catalpa Health 55.00 27.50
8/17/2023 Rachel Anxiety Med 90 Days 12.12 6.06
8/29/2023 John Payment - 200.00
8/30/2023 Rachel ADHD Med 45.00 22.50
9/1/2023 Medical, Dental, Vision 88.60 44.30
9/12/2023 John Payment - 200.00
9/26/2023 John Payment - 200.00
10/1/2023 Medical, Dental, Vision 88.60 44.30
10/10/2023 Rachel ADHD Med 42.00 21.00
10/11/2023 John Payment - 100.00
10/24/2023 John Payment - 200.00
11/1/2023 Medical, Dental, Vision 88.60 44.30
11/3/2023 John Payment - 100.00
11/17/2023 John Payment - 100.00
11/25/2023 Catalpa Health (10/17 Visit) 55.00 27.50
12/1/2023 Medical, Dental, Vision 88.60 44.30
12/1/2023 John Payment 200.00
12/15/2023 John Payment 100.00
Balance
$ 5.00
$ 49.30
$ (50.70)
$ (6.40)
$ 13.60
$ 276.10
$ 176.10
$ 220.40
$ 2,045.40
$ 1,695.40
$ 1,715.40
$ 1,615.40
$ 1,659.70
$ 1,559.70
$ 1,579.70
$ 1,479.70
$ 1,524.00
$ 1,424.00
$ 1,445.00
$ 1,447.26
$ 1,347.26
$ 1,391.56
$ 1,291.56
$ 1,319.06
$ 1,514.46
$ 1,535.46
$ 1,435.46
$ 1,437.81
$ 1,482.11
$ 1,382.11
$ 1,403.11
$ 1,303.11
$ 1,316.11
$ 1,318.45
$ 1,218.45
$ 1,262.75
$ 1,062.75
$ 1,090.25
$ 1,096.31
$ 896.31
$ 918.81
$ 963.11
$ 763.11
$ 563.11
$ 607.41
$ 628.41
$ 528.41
$ 328.41
$ 372.71
$ 272.71
$ 172.71
$ 200.21
$ 244.51
$ 44.51
$ (55.49)
John 2024

Date Child Expense Total Cost 50% Of Cost Payments


1/1/2024 Previous Balance
1/1/2024 Medical, Dental, Vision 94.90 47.45
1/4/2024 Rachel ADHD Med 37.00 18.50
1/30/2024 John Payment 100.00
2/1/2024 Medical, Dental, Vision 94.90 47.45
2/19/2024 Rachel ADHD Med 43.00 21.50
2/19/2024 Catalpa Health 30.00 15.00
3/1/2024 Medical, Dental, Vision 94.90 47.45
3/7/2024 Dental Visit Bill (2/15/2024) 37.40 18.70
4/1/2024 Medical, Dental, Vision 94.90 47.45
4/9/2024 John Payment - 100.00
4/16/2024 Rachel ADHD Med 43.00 21.50
5/1/2024 Medical, Dental, Vision 94.90 47.45
5/7/2024 John Payment - 100.00
5/26/2024 Rachel ADHD Med 42.00 21.00
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
Balance
$ (55.49)
$ (8.04)
$ 10.46
$ (89.54)
$ (42.09)
$ (20.59)
$ (5.59)
$ 41.86
$ 60.56
$ 108.01
$ 8.01
$ 29.51
$ 76.96
$ (23.04)
$ (2.04)

You might also like