Excel to FEP Conversion Automation
Budget: $10 – $30 USD
I need a script or program to automate the conversion of an Excel file into the FEP format required by the bank for processing payments. The Excel file contains client details, including descriptions, payment amounts, and client or business names.
Project Details:
I will provide the Excel file with the necessary fields (e.g., client name, payment amount, description, etc.).
The goal is to convert the data into the FEP file format, which includes:
File Header (FH)
Transaction Detail (HT)
Transaction Addenda (TA)
Transaction Summary (TS)
Requirements:
The generated FEP file must match the exact structure and field requirements as outlined by the bank (including specific formatting for amounts, dates, and account information).
The script should be able to process multiple rows of data from the Excel sheet (one row per transaction).
The output file must be ready for upload directly into the bank's system for client payments.
Skills Needed:
Experience with Python, Excel VBA, or other relevant scripting languages.
Understanding of financial file formats (specifically FEP or similar formats like ACH).
Ability to handle text manipulation and formatting to match bank specifications.
Deliverables:
A fully functional script or program that reads from the provided Excel file and generates the FEP formatted file.
Clear instructions on how to use the script for future uploads.
Please provide a brief description of your experience with similar projects, and feel free to ask for any clarifications.
This should help convey your needs clearly and attract the right freelancer for the task.
Project Details:
I will provide the Excel file with the necessary fields (e.g., client name, payment amount, description, etc.).
The goal is to convert the data into the FEP file format, which includes:
File Header (FH)
Transaction Detail (HT)
Transaction Addenda (TA)
Transaction Summary (TS)
Requirements:
The generated FEP file must match the exact structure and field requirements as outlined by the bank (including specific formatting for amounts, dates, and account information).
The script should be able to process multiple rows of data from the Excel sheet (one row per transaction).
The output file must be ready for upload directly into the bank's system for client payments.
Skills Needed:
Experience with Python, Excel VBA, or other relevant scripting languages.
Understanding of financial file formats (specifically FEP or similar formats like ACH).
Ability to handle text manipulation and formatting to match bank specifications.
Deliverables:
A fully functional script or program that reads from the provided Excel file and generates the FEP formatted file.
Clear instructions on how to use the script for future uploads.
Please provide a brief description of your experience with similar projects, and feel free to ask for any clarifications.
This should help convey your needs clearly and attract the right freelancer for the task.