Aflac

Open 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