Overview
The Pre-tax Account Report provides details for each pre-tax account your employees are enrolled in, including elections, contributions, and transactions for a given date range.
Here are a few key details to keep in mind when creating Pre-Tax Account Reports:
-
The report will only include accounts for employees who started on or before the report's start date. For example, if generating a report for February, it will not include employees with start dates in April.
-
Balance, total contributions, total spending, and rollover will reflect only the transactions within the specified date range.
-
Report generation may take up to 30 minutes, depending on the amount of data. Once ready, it will appear under “Ready to Start” for download.
The sample Pre-tax Account Report outlines what information can be included on this report.
How to create a Pre-tax Account Report
To get started, log in to Forma Admin and click “Reports” from the menu on the left. Click the "New Report" button, select "Pre-tax Benefits" report type, and select "Pre-tax Account Report" from the list of templates.
Next, select the reporting period and optional columns to include in your report.
Included columns: These columns will always be included on the Pre-tax Account Report and can’t be deselected.
- External Employee ID
- Account Type
- Account Status
- Account Start Date
- Account End Date
- Employee Status
- Employee Pay Period Election
- Employer Pay Period Election
- Employee Annual Election: Applicable to FSA, LPFSA, DCFSA, HSA only.
- Employer Annual Election: Applicable to FSA, LPFSA, DCFSA, HSA only.
- Total Employee Payroll Contributions: Employee payroll contributions within the report date range.
- Total Employer Payroll Contributions: Employer payroll contributions within the report date range.
- Total Rollover Contributions: Rollover processed within the report date range.
- Total Spending: Spendings made within the report date range.
- Account Balance: Balance as of the report end date
- Balance Due: Balance due as of the report end date. It will show as a negative amount.
Optional columns: By default, these columns will be included in the report. You can exclude columns by unchecking the box.
- Primary Email: Email employees use to log into Forma, usually the work email. If the employee is terminated, the email will be updated to personal email.
- Full Name
- Pay Group
- Department
- Entity
- Auto-Deposit: If you enable auto-deposit on Forma for the plan.
- Employee Post-tax Pay Period Election: Transit and Parking only if you allow post-tax contributions.
- Employer Post-tax Pay Period Election: Transit and Parking only if you allow post-tax contributions.
- Total Employee Post-tax Payroll Contributions: Transit and Parking only if you allow post-tax contributions. Employee post-tax payroll contributions within the report date range.
- Total Employer Post-tax Payroll Contributions: Transit and Parking only if you allow post-tax contributions. Employer post-tax payroll contributions within the report date range.
- Forfeiture Balance: the amount of unspent pre-tax funds
- Total Funds Reset
Click “Run Report” to create the report.
While the report is being created:
When the report is ready to download:
Report generation time depends on the amount of data in the report. If the download button isn't available, try refreshing the page.
