Description: The Transaction Fee Extract File contains information on each merchant, including pricing information from the Fee Items defined in the Portfolio Pricing Manager (PPM). The file is used to derive comprehensive totals for volume, income and expense for you at the detail and/or Fee Item level. It identifies activity that has no pricing in place, as well as activity that has been applied within more than one Fee Item for pricing purposes.
For more information on Enterprise Extracts, refer to the Enterprise Extracts Guide.
How to Use the Extract
The extract can be used to perform a high level review of all of the billing elements in a period, which includes interchange, Card Brand Fee, Exception fee, Authorization, Miscellaneous Fixed Fees.
Rather than seeing transactional level data, the extract provides a summary of the fees applied to a merchant. Depending on the size of a merchant’s business, they may wish to review the file on a daily basis. Businesses with lesser volume may wish to review at larger intervals (e.g. weekly / monthly).
The interchange fee column contains duplicated rows allowing a user to import the fees into different areas of their back office system.
To distinguish between the duplicates first filter the data using:
- FeeCategory: 10
- FeeCategoryDescription: Interchange
Once the data is filtered, you will see in the PassThroughFees column that each interchange fee has one entry with a PassThroughFee populated, and one that is blank. Adding the amounts in the InterchangeFees column for each item that has a PassThroughFee of not null will provide you with your correct interchange fee total.
File Name
-
EnterpriseCustomer_YYYYMMDD_Enterprise_TransactionFee_Extract.csv
- EnterpriseCustomer is the given customer’s name
- YYYYMMDD is the given date for the file generated; it is based on the previous day’s date and will represent the data that was provided by the various card acquirer systems within Shift4.
Location
- Shift4 SFTP / Customer-Specific Folder / Prod
File Format
- Comma Separated Values (CSV)
Frequency
- Daily, based on the reception of data from the various card acquirer systems within Shift4. We are currently expecting all data to be available by 4:00 a.m. ET and the extracts should be available within the SFTP sites by 11:00 a.m. EST.
Content
| # | Data Element | Data Type | Description |
| 1 | MerchantId | nvarchar(20) | Your acquirer's identification number |
| 2 | InterchangeDate | date |
Date that the interchange amount was calculated for Format: YYYY-MM-DD |
| 3 | TransactionCount | nvarchar(20) |
Total number of sales transactions used in the fee calculation This count can be equal to or less than the posted Sales Count volume depending on whether the Fee Item was added or expired during the month or if the rate was changed mid-month |
| 4 | TotalAssessmentFee | numeric | Applicable for Card Brand Fees. When Interchange Pass Through Income is broken out from Income Amount, the fee item rate percent can be found in the field Interchange Percent Rate. |
| 5 | PassThroughFees | numeric | This is the interchange Per Item Rate when the “Pass through Indicator =’Y’ |
| 6 | CurrencyCode | nvarchar(3) | International standard 3 digit currency code |
| 7 | FeeCategory | nvarchar(3) | Expected values for the Fee Category: 001 - Authorization Txns 002 - Authorization Other 003 - Data Capture Txns 004 - Data Capture Other 005 - Exceptions 006 - Debit Network 007 - EBT 008 - MISC Per Item Fees 009 - MISC Fixed Fees 010 - Interchange 011 - Individual Plan 012 - Discount 013 - Card Brand Fees 015 - Transaction Method |
| 8 | FeeCategoryDescription | nvarchar(20) | Description of the PPM category |
| 9 | InterchangeFee | Your total amount of interchange on a given date and currency code | |
| 10 | InterchangePercentRate | nvarchar(20) | Card Association Percent Rate (Pass through). Applicable for Interchange, Debit Network (Debit Interchange), and some fee items in Card Brand Fees |
| 11 | InterchangePerItemRate | nvarchar(20) | Card Association Per Item Rate (Pass through). Applicable for Interchange,Debit Network(Debit Interchange), and some fee items in Card Brand Fees |
| 12 | MerchantName | nvarchar(20) | Your name |
| 13 | Provider | nvarchar(4) | Identifies the payment provider |
Please proceed to the next article on this topic: Enterprise Extracts Reference Tables and Extract Samples.
Comments
0 comments
Please sign in to leave a comment.