MAINTAIN MEDICAL CARE HISTORY

Use this screen to view a log or history of medical care FSA transactions by employee for each plan year. If you are using Costpoint Payroll to reimburse, all of the fields on this screen will be automatically populated when requests from the Request Medical Care Reimbursement screen are paid through the Compute Payroll screen in Costpoint Payroll and posted. If you are not using Costpoint Payroll, you can enter transactions manually.

You cannot access this screen unless you selected the Medical Care Flexible Spending Accounts checkbox in the Benefit Settings screen in Costpoint Benefits. If you are using Costpoint Payroll to reimburse, this table will be automatically populated when reimbursements are paid and posted. If you are not using Costpoint Payroll to reimburse, you will use this table when you make reimbursement payments to employees for approved medical care expenses. You can enter payment information at any time, and you can enter an unlimited number of records.

Employee

Enter, or use Lookup to select, the ID number of the employee for whom you want to record medical care reimbursement or make an inquiry. Your entry will be validated against the Employee table in the Basic Employee Info screen. The name of the employee is displayed in the field to the right of the ID. The employee must have an election amount in the entered plan year. This is a required field.

Plan Year

Enter the plan year for which you want to record medical care reimbursement or make an inquiry. Your entry will be validated against the Medical Care FSA Setup table. The employee must have an election in the Employee Medical Care FSA Elections screen for this plan year. This is a required field.

Election Amounts

This non-editable field displays the annual election amount for this employee for this plan year. This amount comes from the Medical Care FSA Setup screen in Costpoint Benefits.

Pay Cycle

This non-editable field displays the employee's pay cycle, as defined in the Basic Employee Info screen. This field is hidden if Costpoint Payroll is not used for reimbursements.

YTD Activity

This group box summarizes the year-to-date activity for this employee for this plan year. These non-editable fields display only when you are querying back a record. What this group box displays depends on whether Costpoint Payroll is being used for reimbursements.

Contributions

If you are using Costpoint Payroll for reimbursements, this field displays the sum of deductions (using the deduction code from the Benefit Settings screen) from the Employee Earnings table for this employee for check dates within the start and end date of the plan year. Employee contribution information is not stored in the Maintain Medical Care History table. It is already stored in the Employee Earnings table.

If you are not using Costpoint Payroll for reimbursements, this field displays the sum of Employee Contributions for all rows in the table that contain a Trans Code of "CNTRB" (Contribution). If you do not use Costpoint Payroll to reimburse, this field is updated whenever new "CNTRB" rows are added to an existing record. Such contributions are stored in this table.

Reimbursements

This field displays the sum of all rows in the table that contain a transaction code of "REIMB" (Reimbursement). If you do not use Costpoint Payroll to reimburse, this field is updated whenever new "REIMB" rows are added to the table.

Balance

This field displays the amount of Contributions less the Reimbursements amount. If you do not use Costpoint Payroll to reimburse, the system updates this field whenever new rows are added.

Table Window

Transaction Date

If your company reimburses through Costpoint Payroll, this field displays the date on which the transaction was entered into the system. Otherwise, select the New Line button on the toolbar, and the current system date will default in. If this date is not correct, enter the correct date in MM/DD/YYYY format. This field is required.

Trans Code

If your company uses Costpoint Payroll to reimburse medical care expenses, this field displays either "REIMB" (Reimbursement) or "CNTRB" (Contribution). If your company does not use Costpoint Payroll to reimburse, enter the transaction code ("REIMB" or "CNTRB") that applies to this transaction. This field is required.

Incurred Date

This field is enabled only when the Trans Code is "REIMB." If your company uses Costpoint Payroll to reimburse medical care expenses, this field displays the date on which the medical care expense was incurred. This date determines into the plan year into which this expense falls. If your company does not use Costpoint Payroll to reimburse, enter the incurred date. Your selection will include dates after the plan year ends. This field is required.

Request Date

This field is enabled and required only when the Trans Code is "REIMB." If your company uses Costpoint Payroll to reimburse medical care expenses, this field displays the date on which the request for reimbursement was made. If your company does not use Costpoint Payroll to reimburse, enter the request date.

Request Amount

This field is enabled and required only when the Trans Code is "REIMB." If your company uses Costpoint Payroll to reimburse medical care expenses, this field displays the dollar amount of the medical care request, regardless of the amount actually paid. If your company does not use Costpoint Payroll to reimburse, enter the request amount. The amount must be greater than zero.

Approved Amount

This field is enabled and required only when the Trans Code is "REIMB." If your company uses Costpoint Payroll to reimburse medical care expenses, this field displays the dollar amount of the medical care request that has been approved for payment, regardless of the amount actually paid. If your company does not use Costpoint Payroll to reimburse, enter the approved amount. The dollar amount must be greater than zero.

Reimbursement Amount

This field is enabled and required only when the Trans Code is "REIMB." If your company uses Costpoint Payroll to reimburse medical care expenses, this field displays the amount that was actually paid, regardless of the request or approved amount. If your company does not use Costpoint Payroll to reimburse, enter the reimbursement amount. The value in this field must be greater than zero.

Hint: The Compute Payroll process in Costpoint Payroll will check the Request Medical Care Reimbursements screen to determine whether there are any unpaid requests with a pay period end date that is earlier than or the same as the current payroll run. If there are, it will pay the approved amount, regardless of whether enough funds have been deducted to cover it. The only limitation is that the Amount Paid + the amounts already paid cannot exceed the plan year election amount. Once the request has been paid and posted, it will be moved from the Request Medical Care Reimbursements table to the Maintain Medical Care History table.

Warning:  If using Costpoint Payroll to reimburse, do not manually edit this table. Use it for inquiry purposes only!

Pay Period End Date

This field displays the date of the end of the pay cycle for which this transaction was completed. If your company does not use Costpoint Payroll to reimburse, this field is hidden.

Check Date

This field is enabled and required only when the Trans Code is "REIMB." If your company uses Costpoint Payroll to reimburse medical care expenses, this field displays the date of the check that was used to make reimbursement. If your company does not use Costpoint Payroll to reimburse, enter the check date.

Comment

Enter up to 256 alphanumeric characters to record any comment you want to attach to this row. This is an optional field.

Table Information

Changes to this screen update the HB_MED_FSA_HS table.