Attachment 8 - Sample Data File - EFT.docx
DOCX document 22 KB Posted
- Attached to
- Statewide E-Payment Services State and local contract opportunity
- Solicitation number
- 300000210291259
- Issued by
- Missouri
About this file
Summary: Attachment 8 - Sample Data File - EFT
This document is a sample Electronic Funds Transfer (EFT) data file for the State of Missouri's Statewide E-Payment Services contract. The file demonstrates the format and structure required for batch payment processing through the e-payment system. The sample includes multiple payment scenarios: individual tax debt payments from personal checking accounts, credit card payments (VISA), and business tax payments from business checking accounts. The file illustrates how to properly format account information, payment amounts, case numbers, debt identifiers, tax years, and debt periods for submission. The batch begins with a header timestamp (061919 234) and includes standardized field requirements such as account type designation, total payment amounts (formatted as NNNN.NN without dollar signs), taxpayer names, unique tokens defined as varchar(50) strings, CACS case numbers, and specific debt period information.
The sample data shows payment processing across multiple debt periods, including 2017 individual tax obligations and multi-period 2018 business tax payments with varying amounts ($293.11, $365.64, $361.98, and $114.71 for different monthly periods). Each transaction entry includes the account type, payer identification, token reference, case number, payment amount, debt year, and debt month or identifier. The file format demonstrates Missouri's standardized approach to consolidating diverse payment types within a single EFT batch transmission, ending with batch completion notation. This document serves as a technical reference for vendors and agencies implementing the state's electronic payment system to ensure proper data formatting and field structure compliance.
View the file
Other files for this state and local contract opportunity
| File | Type | Posted |
|---|---|---|
| STATE 0000000254SL - Statewide E-Payment.docx | DOCX document | |
| STATE 0000000254SL - Exhibit C - Pricing Page.xlsx | XLSX spreadsheet | |
| Attachment 1 - FY24 E-Payment Transactions and Data.xlsx | XLSX spreadsheet | |
| Attachment 2 - FY24 E-Payment Transactions by Card Type.xlsx | XLSX spreadsheet | |
| Attachment 3 - Sample IVR Script.doc | DOC document | |
| Attachment 4 - Sample Requested Daily Transaction Files Report.xlsx | XLSX spreadsheet | |
| Attachment 5 - Sample Data File Types - Various State Agencies.doc | DOC document | |
| Attachment 6 - Sample Data File Types - DOR.docx | DOCX document | |
| Attachment 7 - Sample Data File Types - DOR Motor Vehicle.xlsx | XLSX spreadsheet | |
| Attachment 9 - Sample Receipts.docx | DOCX document | |
| Attachment 10 - Safeguarding Federal Tax Information.docx | DOCX document | |
| Attachment 11 - Admin Fee Report.xlsx | XLSX spreadsheet | |
| Attachment 12 - Missouri Statewide Contract Quarterly Usage Report.xlsx | XLSX spreadsheet |
Show all 13
On GovTribe
Work with this file on GovTribe
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Attachment 8 – Sample EFT at the top of the batch
-<TRANSACTIONBATCH>
<BATCHDATE>061919</BATCHDATE>
<TRANSACTIONCOUNT>234</TRANSACTIONCOUNT>
then for each account this was a bank account - personal checking
-<TRANSACTION>
| <LINECOUNT>1</LINECOUNT> | total number of items to be paid for | ||
| <PAYMENTMETHOD>1</PAYMENTMETHOD> | this was a bank account - personal checking | ||
| <AMOUNT>NNNN.NN</AMOUNT> | no dollar sign – this is the total to be pull |
<NAME>JOHN Q PUBLIC</NAME>
<TOKEN>NNNNNNa-NfNN-NdNN-NaNN-NNNbcdNfNN</TOKEN> token is defined as varchar(50)-This is an example
-<LINEITEM ID="0">
<PAYMENTID>NNNNNNNNN</PAYMENTID> This is the CACS casenumber
<CUSTOMERPAYMENTTYPEID>1</CUSTOMERPAYMENTTYPEID>
<ITEMAMOUNT>NNNN.NN </ITEMAMOUNT> amount paid on the debt period <PAYMENTID_SECONDARY>2017</PAYMENTID_SECONDARY> debt period – individual tax, so only year
<MISC_THREE/>
<MISC_FOUR>nnnnnnn </MISC_FOUR> debt id
<MISC_EIGHT/>
</LINEITEM>
</TRANSACTION>
this was a credit card - VISA
-<TRANSACTION>
<LINECOUNT>1</LINECOUNT>
<PAYMENTMETHOD>0</PAYMENTMETHOD>
<AMOUNT>NNNN.NN </AMOUNT>
<NAME> JOHN Q PUBLIC </NAME>
<TOKEN> NNNNNNa-NfNN-NdNN-NaNN-NNNbcdNfNN </TOKEN>
-<LINEITEM ID="0">
<PAYMENTID> NNNNNNNNN </PAYMENTID>
<CUSTOMERPAYMENTTYPEID>1</CUSTOMERPAYMENTTYPEID>
<ITEMAMOUNT>NNNN.NN </ITEMAMOUNT>
<PAYMENTID_SECONDARY>2017</PAYMENTID_SECONDARY>
<MISC_THREE/>
<MISC_FOUR> nnnnnnn </MISC_FOUR>
<MISC_EIGHT/>
</LINEITEM>
</TRANSACTION>
this was a business tax payment on 3 periods using a business checking account
-<TRANSACTION>
<LINECOUNT>4</LINECOUNT>
<PAYMENTMETHOD>1</PAYMENTMETHOD>
<AMOUNT>NNNN.NN</AMOUNT> total amount to be paid
<NAME>A BUSINESS</NAME>
<TOKEN>NNfNbfNN-efNe-NNNN-NNNc-NNNNNcNNNNNe</TOKEN>
-<LINEITEM ID="0">
<PAYMENTID>NNNNNNNN</PAYMENTID>
<CUSTOMERPAYMENTTYPEID>13</CUSTOMERPAYMENTTYPEID>
| <ITEMAMOUNT>293.11</ITEMAMOUNT> | amount paid on the 1ST debt period | ||
| <PAYMENTID_SECONDARY>2017</PAYMENTID_SECONDARY> | debt YEAR | ||
| <MISC_THREE>12</MISC_THREE> | debt MONTH | ||
| <MISC_FOUR>NNNNNNN0 </MISC_FOUR> | debt ID | ||
| <MISC_EIGHT>1 </MISC_EIGHT> | ??? |
</LINEITEM>
-<LINEITEM ID="1">
<PAYMENTID>NNNNNNNN </PAYMENTID>
<CUSTOMERPAYMENTTYPEID>13</CUSTOMERPAYMENTTYPEID>
<ITEMAMOUNT>365.64</ITEMAMOUNT> amount paid on the 2ND debt period
<PAYMENTID_SECONDARY>2018</PAYMENTID_SECONDARY>
<MISC_THREE>01</MISC_THREE>
<MISC_FOUR>NNNNNNN9 </MISC_FOUR>
<MISC_EIGHT>1 </MISC_EIGHT>
</LINEITEM>
-<LINEITEM ID="2">
<PAYMENTID> NNNNNNNN </PAYMENTID>
<CUSTOMERPAYMENTTYPEID>13</CUSTOMERPAYMENTTYPEID>
<ITEMAMOUNT>361.98</ITEMAMOUNT> amount paid on the 3RD debt period
<PAYMENTID_SECONDARY>2018</PAYMENTID_SECONDARY>
<MISC_THREE>02</MISC_THREE>
<MISC_FOUR>NNNNNN5 </MISC_FOUR>
<MISC_EIGHT>1 </MISC_EIGHT>
</LINEITEM>
-<LINEITEM ID="3">
<PAYMENTID>NNNNNNNN</PAYMENTID>
<CUSTOMERPAYMENTTYPEID>13</CUSTOMERPAYMENTTYPEID>
<ITEMAMOUNT>114.71</ITEMAMOUNT>
<PAYMENTID_SECONDARY>2018</PAYMENTID_SECONDARY>
<MISC_THREE>03</MISC_THREE>
<MISC_FOUR> NNNNNN4 </MISC_FOUR>
<MISC_EIGHT>1 </MISC_EIGHT>
</LINEITEM>
</TRANSACTION>
AT THE END OF THE BATCH
</TRANSACTIONBATCH>
File details come from the government source that posted it. Updated .