1 of 29

Create That Spreadsheet

Communicating Deductions Clearly Seals the Deal

2 of 29

Deduction Spreadsheet Purpose

Clearly communicate to the bookkeeper the pre- & post tax deductions.

3 of 29

How to Make a Spreadsheet

  • Always click on the link to have the most up-to-date sheet.
  • Title the sheet:�“Deduction Spreadsheet for [Company Name]”

4 of 29

How to Make a Spreadsheet

5 of 29

How to Make a Spreadsheet

When do these deductions start?

09/01/2024

6 of 29

How to Make a Spreadsheet

What is your title?

Agent, Supervising Agent, etc.

7 of 29

How to Make a Spreadsheet

What is your FULL name?�Amanda Rohland

8 of 29

How to Make a Spreadsheet

What is your phone number?�(###) ###-####

9 of 29

How to Make a Spreadsheet

What is the account number?�#####

10 of 29

How to Make a Spreadsheet

What is the number of pay periods?�weekly=52

biweekly=26

semi-monthly=24

monthly=12

11 of 29

How to Make a Spreadsheet

What is the employee name?�Doe, Jane

12 of 29

How to Make a Spreadsheet

GT65/100 for employee only

13 of 29

How to Make a Spreadsheet

Pre-Tax Health & Accident: Employee covered w/ Cancer Endurance, AxMax, or ICP

14 of 29

How to Make a Spreadsheet

Post-Tax Life: employee GT65 or GT100 over 50K, dependent/spouse GT65 or GT100, CLP, ALX, 10 Yr RC

15 of 29

How to Make a Spreadsheet

Post-Tax Health & Accident: Critical Illness, Cash Cancer, non-employee AxMax, ICP, or Cancer Endurance

16 of 29

How to Make a Spreadsheet

Type in the information from each SRF on one line for each employee.

17 of 29

How to Make a Spreadsheet

Click on the 3 lines in the filter by employee.

18 of 29

How to Make a Spreadsheet

Click on Sort A → Z

19 of 29

How to Make a Spreadsheet

  1. Select blank rows.
  2. Select Hide Rows.

20 of 29

How to Make a Spreadsheet

Click file.

21 of 29

How to Make a Spreadsheet

Click download.

22 of 29

How to Make a Spreadsheet

Click PDF (.pdf).

23 of 29

How to Make a Spreadsheet

Landscape.

24 of 29

How to Make a Spreadsheet

Uncheck show gridlines..

25 of 29

How to Make a Spreadsheet

Export.

26 of 29

How to Make a Spreadsheet

27 of 29

Email OR Deliver?

BOTH

  • Email to bookkeeper & QM ASAP

28 of 29

Email OR Deliver?

BOTH

  • Email to bookkeeper & QM ASAP
  • Deliver printed copy to bookkeeper w/ Bluebook

29 of 29

Create That Spreadsheet

Go make the spreadsheets you need to make for your new enrollments & re-enrolls.