Aflac

TRACKING AFLAC WITHHOLDING

Open the Deductions and Deposits sheet and click on the Aflac tab

Open the payroll total cost report

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

TO PAY THE BILL

Log in to the Aflac account

Note the amount of the invoice

Go to the 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 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

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 will auto populate 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