Social Security Monthly Allowed

[Robert Wyatt]

I trying to figure out a way to keep track of my monthly Social Security allowed gross wages, I have it figuring the yearly like I need, but I can't seem to figure out a way for the monthly. Is there any way to have it figure it monthly without counting the past pay periods. So I have four checks in April, but now I'm tracking Mays pay how would I do that without having Aprils counting into it?

Book1
	A	B	C	D	E	F	G	H	I	J	K
1		SOCIAL SECURITY REGISTER						Allowed Annually:	$22,320.00	Allowed Monthly:	$1,860.00
2								Multiplied by 52 Pay Periods;	$1,754.51	Estimated Monthly Earnings
3	PP#	Pay Date	Pay	Year-To-Date	Amount Before Penalty's			Amount To Earn before Penalty's:	$20,565.49
4	13	03/29/2024	$239.25	$239.25	$22,080.75
5	14	04/05/2024	$313.50	$552.75	$21,767.25
6	17	04/26/2024	$566.72	$1,119.47	$21,200.53
7	18	05/03/2024	$154.72	$1,274.19	$21,045.81
8	19	05/10/2024	$480.32	$1,754.51	$20,565.49
Sheet1

Cell Formulas
Range	Formula
K1	K1	=ROUND(I1/12,2)
I2	I2	=SUM(C4:C55)
I3	I3	=ROUND(I1-I2,2)
D4:D8	D4	=IF(ISBLANK(B4)," ",SUM(D3,C4))
E4:E8	E4	=IF(ISBLANK(C4)," ",SUM(22320-D4))

 

[Snakehips]

@Robert Wyatt Might this help?

Testing Formula Update.xlsm
	A	B	C	D	E	F	G	H	I	J	K
1		SOCIAL SECURITY REGISTER						Allowed Annually:	22320	Allowed Monthly:	1860
2								Multiplied by 52 Pay Periods;	1754.51	Estimated Monthly Earnings
3	PP#	Pay Date	Pay	Year-To-Date	Amount Before Penalty's	Month Pay		Amount To Earn before Penalty's:	20565.49
4	13	3/29/24	239.25	239.25	22080.75	239.25
5	14	4/5/24	313.5	552.75	21767.25
6	17	4/26/24	566.72	1119.47	21200.53	880.22
7	18	5/3/24	154.72	1274.19	21045.81
8	19	5/10/24	480.32	1754.51	20565.49	635.04
9
Sheet7

Cell Formulas
Range	Formula
K1	K1	=ROUND(I1/12,2)
I2	I2	=SUM(C4:C55)
I3	I3	=ROUND(I1-I2,2)
D4:D8	D4	=IF(ISBLANK(B4)," ",SUM(D3,C4))
E4:E8	E4	=IF(ISBLANK(C4)," ",SUM($I$1-D4))
F4:F9	F4	=IF(MONTH(B4)<>MONTH(B5),SUM(C$4:C4)-SUM(F$3:F3),"")

 

[Robert Wyatt]

I get paid weekly, so I would need it to figure each pay period of the month then figure out when to start new month's figure without adding the previous months. My checks each pay period are not the same. I schedule of work is Friday, Saturday, And Sunday. I might be called in to fill in for some one if they need a day off. But I normally work most of the time one day a week sometime three Friday, Saturday, and Sunday when they work on the weekend that is not all time.

 

[Robert Wyatt]

@Robert Wyatt Might this help?

Testing Formula Update.xlsm
	A	B	C	D	E	F	G	H	I	J	K
1		SOCIAL SECURITY REGISTER						Allowed Annually:	22320	Allowed Monthly:	1860
2								Multiplied by 52 Pay Periods;	1754.51	Estimated Monthly Earnings
3	PP#	Pay Date	Pay	Year-To-Date	Amount Before Penalty's	Month Pay		Amount To Earn before Penalty's:	20565.49
4	13	3/29/24	239.25	239.25	22080.75	239.25
5	14	4/5/24	313.5	552.75	21767.25
6	17	4/26/24	566.72	1119.47	21200.53	880.22
7	18	5/3/24	154.72	1274.19	21045.81
8	19	5/10/24	480.32	1754.51	20565.49	635.04
9
Sheet7

Cell Formulas
Range	Formula
K1	K1	=ROUND(I1/12,2)
I2	I2	=SUM(C4:C55)
I3	I3	=ROUND(I1-I2,2)
D4:D8	D4	=IF(ISBLANK(B4)," ",SUM(D3,C4))
E4:E8	E4	=IF(ISBLANK(C4)," ",SUM($I$1-D4))
F4:F9	F4	=IF(MONTH(B4)<>MONTH(B5),SUM(C$4:C4)-SUM(F$3:F3),"")

 

[Robert Wyatt]

I get paid weekly, so I would need it to figure each pay period of the month then figure out when to start new month's figure without adding the previous months. My checks each pay period are not the same. I schedule of work is Friday, Saturday, And Sunday. I might be called in to fill in for some one if they need a day off. But I normally work most of the time one day a week sometime three Friday, Saturday, and Sunday when they work on the weekend that is not all time.