Overview
The Pre-tax Card Transaction Report provides information about card spend, auto-substantiation rates, card approval rates, and card rejection reasons. To learn more, see What information can I get from the Pre-tax Card Transaction Report?
Here are a few key details to keep in mind when creating a Pre-Tax Card Transaction Report:
The report includes transactions made within the specified date range (i.e., when a member swiped their Pre-Tax Forma Card). The Transaction Date in the report reflects the creation date.
All dates and times in the report are in PDT.
Transactions declined due to processor errors will not be included.
HSA card transactions are not included in this report.
Pre-tax Card Transaction Report Template outlines what information can be included on this report.
How to create a Pre-tax Card Transaction 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 Card Transaction 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 Card Transaction Report and can’t be deselected.
- External Employee ID
- Transaction Status
- Approved: Transaction is approved and funds will be paid to the merchant when finalized. Purchases with an approved status can still be adjusted, declined, or canceled.
- Processing: Transaction is processed but has not been paid to the merchant. Funds have been deducted from the member’s account balance but have not been taken from the employer deposit account.
-
Declined: Transaction was declined by the card processor, Forma, or by the bank (insufficient funds). The employer deposit account and member account balances will not be deducted.
- If declined:
- Account Type will be blank as there is no account being charged. If the account type is populated, it is because the transaction was in the processing stage before being declined
- Amount Eligible and Amount Ineligible will be $0
- Card Adjudication Status should be blank. If populated, please ignore.
- If declined:
- Transaction Date: When the Pre-tax Forma Card is used at point-of-sale (POS)
- Account Type: Not available if transaction status is declined, as there was no account charged
- Amount Requested: Original transaction amount
- Amount Charged: Actual transaction amount charged
- Amount Eligible + Amount Ineligible = Amount Charged
- When is the amount charged different from the amount requested?
- When the transaction contains both IIAS eligible and ineligible items (ex: a prescription and a pack of gum)
- The final charged amount is less than the originally requested amount, as determined by the merchant.
- NOTE: The amount charged is subject to change. For this reason, Forma recommends this report is not used for reconciliation
- Amount Refunded
- If the transaction is refunded, the Amount Refunded will be populated
- If the transaction is fully refunded, then Amount Charged will equal Amount Refunded
- The adjudication status may still display as “Receipt Not Required”, this field can be ignored for refunded transactions.
- Card Adjudication Status - Receipt status for the transaction. Will be defined as “receipt not required” for processing and declined transactions.
Optional Columns: By default, these columns will be included in the report. Uncheck columns to exclude them from the report.
- Primary Email
- Full Name
- Transaction ID
- Amount Eligible: The eligible amount. Applicable only if Adjudication Status is not “Receipt Not Required”.
- Amount Ineligible: The ineligible amount. Applicable only if Adjudication Status is not “Receipt Not Required”.
- MCC
- Merchant
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.