Aflac - Revision history

Serenity152102 at 17:57, 24 June 2022

2022-06-24T17:57:31Z

← Older revision		Revision as of 17:57, 24 June 2022
Line 4:		Line 4:
	Open the [https://docs.google.com/spreadsheets/d/1tDV6HZqjGL_NZ2LQCdvbKEufYxwgMut-IdaH0qZdR-k/edit#gid=1357088893 Deductions and Deposits] sheet and click on the Aflac tab		Open the [https://docs.google.com/spreadsheets/d/1tDV6HZqjGL_NZ2LQCdvbKEufYxwgMut-IdaH0qZdR-k/edit#gid=1357088893 Deductions and Deposits] sheet and click on the Aflac tab

	Open the payroll ~~total cost~~ report		Open the payroll details report AI 22, AR 22 and AU22

	Enter the amounts withheld according to the total cost report into columns B-D		Enter the amounts withheld according to the total cost report into columns B-D

Serenity152102: Updated

2022-05-19T17:47:52Z

Updated

← Older revision		Revision as of 17:47, 19 May 2022
Line 1:		Line 1:

			ENTERING AFLAC WITHHOLDING
	~~TRACKING~~ AFLAC WITHHOLDING

	Open the [https://docs.google.com/spreadsheets/d/1tDV6HZqjGL_NZ2LQCdvbKEufYxwgMut-IdaH0qZdR-k/edit#gid=1357088893 Deductions and Deposits] sheet and click on the Aflac tab		Open the [https://docs.google.com/spreadsheets/d/1tDV6HZqjGL_NZ2LQCdvbKEufYxwgMut-IdaH0qZdR-k/edit#gid=1357088893 Deductions and Deposits] sheet and click on the Aflac tab

Serenity152102: update

2022-05-19T17:46:30Z

update

← Older revision		Revision as of 17:46, 19 May 2022
Line 1:		Line 1:
	Open [https://docs.google.com/spreadsheets/d/1tDV6HZqjGL_NZ2LQCdvbKEufYxwgMut-IdaH0qZdR-k/edit#gid=1357088893 Deductions and Deposits]

			TRACKING AFLAC WITHHOLDING

			Open the [https://docs.google.com/spreadsheets/d/1tDV6HZqjGL_NZ2LQCdvbKEufYxwgMut-IdaH0qZdR-k/edit#gid=1357088893 Deductions and Deposits] sheet and click on the Aflac tab

	Open the payroll total cost report		Open the payroll total cost report

	Enter the amounts withheld ~~for~~ columns B-D ~~from~~ the ~~payroll cost report~~		Enter the amounts withheld according to the total cost report into columns B-D


			TO PAY THE BILL

			Log in to the [https://login.aflac.com/?ReturnURL=https://my.aflac.com/portal/sso/SSOLogin.aspx Aflac account]

	Column E is the Church Contribution – refer to Cell H49 (this could change if we ~~have~~ or lose an employee)		Note the amount of the invoice

			Go to the [https://docs.google.com/spreadsheets/d/1tDV6HZqjGL_NZ2LQCdvbKEufYxwgMut-IdaH0qZdR-k/edit#gid=1357088893 Deposits and Deductions] sheet and click on the Aflac tab

			Enter the amount of the invoice in column I of the Deductions and Deposits sheet, next to the appropriate month

			Look at Column J to ensure there is no variance from what was withheld to what we are paying on the invoice

			Review the invoice from Aflac to ensure all listed employees are still actively employed, if an employee is not longer employed (and therefore did not have money withheld), edit the Aflac invoice and select the appropriate reason for the edit (ex: no longer employed)

			Once you have determined that the invoice is correct, you may pay the invoice.

			Enter the amount you paid on the invoice in Column K

			If there was a difference between what was billed on the invoice and what we paid, the difference will appear in column L

			Use column N to note any changes made on this invoice


			EXPLANATION OF SHEET

			Column E is the Church Contribution – refer to Cell H49 (this could change if we gain or lose an employee)

	Column F is the sum of columns B-E		Column F is the sum of columns B-E
Line 13:		Line 43:
	Column H is the Month those withholdings reflect		Column H is the Month those withholdings reflect

	Column I is the amount the [https://login.aflac.com/?ReturnURL=https://my.aflac.com/portal/sso/SSOLogin.aspx Aflac] bills us ~~– Link is also in Cell I1~~		Column I is the amount the [https://login.aflac.com/?ReturnURL=https://my.aflac.com/portal/sso/SSOLogin.aspx Aflac] bills us

	Column J will auto populate if there is a difference between the invoiced amount and the amount we withheld		Column J will auto populate if there is a difference between the invoiced amount and the amount we withheld
Line 19:		Line 49:
	Column K is the amount that we paid [https://login.aflac.com/?ReturnURL=https://my.aflac.com/portal/sso/SSOLogin.aspx Aflac] – this amount is found on the Aflac website		Column K is the amount that we paid [https://login.aflac.com/?ReturnURL=https://my.aflac.com/portal/sso/SSOLogin.aspx Aflac] – this amount is found on the Aflac website

	Column L is the difference between what [https://login.aflac.com/?ReturnURL=https://my.aflac.com/portal/sso/SSOLogin.aspx Aflac] billed and what we paid		Column L will auto populate the difference between what [https://login.aflac.com/?ReturnURL=https://my.aflac.com/portal/sso/SSOLogin.aspx Aflac] billed and what we paid

	Column N is to note any changes that occurred for months that had differences in Column J or Column L		Column N is to note any changes that occurred for months that had differences in Column J or Column L


	[[Category:Finance]]		[[Category:Finance]]

Serenity152102 at 19:11, 22 February 2022

2022-02-22T19:11:21Z

← Older revision		Revision as of 19:11, 22 February 2022
Line 13:		Line 13:
	Column H is the Month those withholdings reflect		Column H is the Month those withholdings reflect

	Column I is the amount the Aflac bills us – Link is also in Cell I1		Column I is the amount the [https://login.aflac.com/?ReturnURL=https://my.aflac.com/portal/sso/SSOLogin.aspx Aflac] bills us – Link is also in Cell I1

	Column J will auto populate if there is a difference between the invoiced amount and the amount we withheld		Column J will auto populate if there is a difference between the invoiced amount and the amount we withheld

	Column K is the amount that we paid Aflac – this amount is found on the Aflac website		Column K is the amount that we paid [https://login.aflac.com/?ReturnURL=https://my.aflac.com/portal/sso/SSOLogin.aspx Aflac] – this amount is found on the Aflac website

	Column L is the difference between what Aflac billed and what we paid		Column L is the difference between what [https://login.aflac.com/?ReturnURL=https://my.aflac.com/portal/sso/SSOLogin.aspx Aflac] billed and what we paid

	Column N is to note any changes that occurred for months that had differences in Column J or Column L		Column N is to note any changes that occurred for months that had differences in Column J or Column L
	[[Category:Finance]]		[[Category:Finance]]

100.6.165.4: Update

2022-02-22T17:45:56Z

Update

← Older revision		Revision as of 17:45, 22 February 2022
Line 22:		Line 22:

	Column N is to note any changes that occurred for months that had differences in Column J or Column L		Column N is to note any changes that occurred for months that had differences in Column J or Column L
			[[Category:Finance]]

100.6.165.4: Created page

2022-02-22T17:41:45Z

Created page

New page

Open [https://docs.google.com/spreadsheets/d/1tDV6HZqjGL_NZ2LQCdvbKEufYxwgMut-IdaH0qZdR-k/edit#gid=1357088893 Deductions and Deposits]

Open the payroll total cost report

Enter the amounts withheld for columns B-D from the payroll cost report

Column E is the Church Contribution – refer to Cell H49 (this could change if we have or lose an employee)

Column F is the sum of columns B-E

Column G is the total withholding for the pay periods each month

Column H is the Month those withholdings reflect

Column I is the amount the Aflac bills us – Link is also in Cell I1

Column J will auto populate if there is a difference between the invoiced amount and the amount we withheld

Column K is the amount that we paid Aflac – this amount is found on the Aflac website

Column L is the difference between what Aflac billed and what we paid

Column N is to note any changes that occurred for months that had differences in Column J or Column L