CSV layouts

Prepare your payment file correctly.

Choose the layout that matches your payment type. Keep each column in the exact order shown below.

Important: Use the supplied field order. Do not add, remove or move columns. Save the file as CSV before submitting it.

Every field must be formatted as Text and must not exceed 16 characters.
Do not use commas or special characters in text fields.
Format the cells as Text before saving the file as *.CSV.
Do not include a footer or totals. Use a header row only where the selected layout shows one.
Do not open the CSV again after saving. Excel can alter the data, including dropping zeros or applying formatting.

Layout 01

CSV Payroll

For employee payroll payments. This layout does not use a header row.

A Record number	B Employee name	C Amount	D Bank account number	E Branch code
1	John Doe	100.92	12345678900	123456
2	Mary Smit	102.54	12354698007	123456

Layout 02

For creditor or supplier payments. This layout does not use a header row.

A Record number	B Creditor name	C Amount	D Bank account number	E Branch code	F Payment reference
1	AMC Products	100.92	12345678900	123456	ref123
2	Jetstreamers	102.54	12354698007	123456	inv884

Layout 03

For creditor payments where a remittance email address is included. Use one header row exactly as shown in row 1 below.

Column A — Ref Customer code or own reference

Column B — Name Creditor name

Column C — Amount Net amount; no comma for cents

Column D — Account No. Customer account number or short code

Column E — Branch Code Bank branch code or short code

Column F — Ref Reference on the customer's bank statement

Column G — Email Address Beneficiary payment notification

Every field must be formatted as Text and must not exceed 16 characters.
Save as *.CSV, with one header row and no footer or totals.
Do not use commas or special characters in text fields.
Format the cells as Text before saving the file as CSV.
Do not open the CSV again after saving. Excel can alter the data, including dropping zeros or applying formatting.

Contact PayEFT before submitting your first file. We will help you confirm the suitable format for your payment process.