field_block:node:page:title
Payment File Formats
field_block:node:page:body
You can submit multiple payments at one time by attaching a payment file in e-Services. The payment file must be in either a delimited tab (.TXT) or comma delimited (.CSV) format.
field_block:node:page:field_paragraph
Payment files must use a specific layout. You can use the Bulk Payment Layout below to help create your file.
You can use the Excel Payment File template to create your payment file. To do so:
- Create your Excel spreadsheet with the required columns.
- Enter the payment information.
- Use "Save As" to save your payment file.
- Select CSV (Comma delimited) as your file type. (This information is in the Save as type field.)
- Select Ok.
- Microsoft will have a warning pop up window. Select Yes.
- Close out of your excel file. (Excel will have another warning window. Select Don't Save.)
Once you have your file created, you can then attach it in e-Services.
You cannot edit your file once it is in a .CVS format. In most cases, any leading zeroes will be dropped. If you need to edit your file, you will need to covert it to a .TXT file format. To do so:
- Right click on your payment file.
- Select Open With from the menu.
- Select Note Pad from the Open With menu. This will open your file in a TXT format.
- Make your edits. (Do not delete the commas that are being used as place holders.)
- Save your file. It will save back to the .CSV file you opened.
- Re-attach (resubmit) your payment file in e-Services