CSV Payroll
Layout

This CSV layout is basic and easy with only minimal relevant data for batch payments. Please ensure that you select the "CSV PAYROLL" format when using this layout.

html5 templates

 
A=Ref (Employee Number or any number)
B=Name (Employee Name and Surname, no comma) 
C=Amount (Nett. Amount, no comma for cents) 
D=Account No. (Employee Bank Account Number or Short Code) 
E=Branch Code (Bank Branch Code or Short Code) 


None of these fields should exceed 16 characters and all data must all be formatted as text.
Save file as *.CSV with no commas or special characters in text, NO header and NO footer (Total). 
Format cells to "text" before save as *.CSV. 
DO NOT OPEN THE *.CSV FILE AGAIN AFTER SAVED (Excel will add formatting to this *.csv file when opened like dropping zeros etc. and it can alter data)

1Shala Barrera526.56 5651222332 632005
2Jeanna Schmal1002.366253669887051001
3Caren Rials985.251015568988051001
4Leon Rogol9875.5089552110566250655
5Paul Smit875.355896523321470010
Mobirise


File Format

Make sure you select the relevant format from the "File Format" dropdown 

© Copyright 2017 ACBEFT- All Rights Reserved