How do I create a Transaction Report on Forma Admin?

Transaction Reports track how your employees are spending their account funds.

See the Transaction Report Template to understand what information can be included on this report.

To get started, log in to Forma Admin and click “Reports'' from the menu on the left. Click the “New Report” button, select "Employer Sponsored Benefits" report type, and select “Spending Report” from the list of templates.

Next, select the details for your report:

1. Reporting period: The report start and end date
2. Columns: The fields that will be included in the report. Uncheck columns to exclude them
   • Employee: Demographic information
   • Custom fields: Custom fields included in the demographics file
   • Wallets: A list of all active accounts
3. Filters: Uncheck filters to exclude them
   • Employee status: Active or terminated
   • Countries: Employee's location
   • Transaction type. NOTE: transaction type will appear as "twic claim" , "twic store" or "twic card"
     1. Claims: Reimbursable 
     2. Forma Store: Non-reimbursable
     3. Forma Card: Non-reimbursable
   • Claim status
     1. Pending: Claims that have not been reviewed
     2. Rejected: Claims that were rejected after review
     3. Approved: Claims that were approved and reimbursed in full
     4. Completed: Approved claims that generated a reimbursement plan, which has now been fully paid.
     5. In progress: Approved claims that generated a reimbursement plan, which is in progress
     6. Support action required

When you’re done, click “Update” to save your selections, and the preview screen will update to show you what your data will look like. 

Important: If you don’t click “Update”, your changes will not be saved.

If the preview looks good, click “Run Report” to create the report.

You’ll see a summary of the report details:

1. Report summary
2. Report status
   • Processing: The report is being created. It may take a few minutes to finish.
   • Finished: The report has been created successfully and can be downloaded.
3. New Report: Click this button to create a new report
4. Exit: Exit this page and go back to the main Reports page

Important: You may have to refresh the summary page to be able to click the download button.

Once you’re back on the main Reports page, you’ll see all generated reports available to download. If the newly created report isn’t there, try refreshing the page.