The Client Monthly Account Balance report is easily accessible and provides you snapshot of the account for the prior month.
Column Definitions (for a report run for balances on a specific date):
B - Location - If the employer has multiple locations, they will be listed here
C - Plan - This is the plan type for which the employee is enrolled
F - Employee’s Social Security Number
H - Employee’s Name (Last, First)
I - Plan Effective Date - This is the employee’s plan start date
J - Plan Termination Date - This is the date the employee was terminated from the plan (if applicable) or their plan end date
K - Plan status - This shows if an employee is active or terminated from the plan
L - Annual Election - This is the annual amount the employee elected for the plan year, including employer contributions (if applicable)
N - Employee Deposits - This column shows the total contributions paid to date by the employee
M - Employer Deposits - This column shows the total contributions paid to date by the employer
O - Rollover Deposits - If an employees had rollover funds from the prior year, the balance would be listed here
Q - Total Deposits - This is the year-to-date amount deposited into the account between the employee, employer, and rollover deposits
R - Total Disbursed - This is the year-to-date amount the employee has been reimbursed or has spent from the account
S - Forfeiture Balance - While this is a column on the report, the forfeiture balance will not populate until the end of the plan year. Forfeitures are unknown until both the plan year and the runout period is over. Forfeitures are calculated by taking the total contributions and subtracting the disbursed amount. Since contributions and disbursements are changing throughout the plan year, accurate figures cannot be provided.
U - Available Balance - The employee’s year-to-date available balance
Column Definitions (for a report run for balances as of right now):
B - Location - If the employer has multiple locations, they will be listed here
C - Plan - This is the plan type for which the employee is enrolled
F - Employee’s Social Security Number
H - Employee’s Name (Last, First)
J - Plan Effective Date - This is the employee’s plan start date
L - Plan Termination Date - This is the date the employee was terminated from the plan (if applicable) or their plan end date
K - Plan status - This shows if an employee is active or terminated from the plan
M - Annual Election - This is the annual amount the employee elected for the plan year, including employer contributions (if applicable)
N - Employee Deposits - This column shows the total contributions paid to date by the employee
O - Employer Deposits - This column shows the total contributions paid to date by the employer
P - Rollover Deposits - If an employees had rollover funds from the prior year, the balance would be listed here
Q - Total Deposits - This is the year-to-date amount deposited into the account between the employee, employer, and rollover deposits
R - Total Disbursed - This is the year-to-date amount the employee has been reimbursed or has spent from the account
U - Available Balance - The employee’s year-to-date available balance
