How do I create a Spending Report in Forma Admin?

Spending Reports track employee spend for each of their accounts.

See the Spending 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
   • Spending data
     1. Monthly by account: Monthly spend by account
     2. Total by account: Total spend by account based on the reporting period
     3. Total spending: Total aggregated spend form all selected accounts
   • Default columns (These can’t be unselected)
     1. SPENDING FROM CLAIMS
     2. SPENDING FROM STORE
     3. SPENDING FROM CARD
     4. NON REIMBURSABLE SPENDING
3. Filters: Uncheck filters to exclude them
   • Employee status: Active or terminated
   • Countries: Employee's location
   • Transaction type
     1. Claims: Reimbursable 
     2. Forma Store: Non-reimbursable
     3. Forma Card: Non-reimbursable

Tips:

• To view only reimbursable amounts, select "Claims."

• To see taxable amounts, select "Forma Store" and "Forma Card" (taxability depends on wallet configuration).

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.