CSV Creditor
Layout

This CSV layout is the same as the CSV.Payerol layout except for an additional last column that reflect as payment reference on the beneficiary bank statement

how to build a site

 
A=Ref (Customer code or Own Reference)
B=Name (Creditor Name) 
C=Amount (Nett. Amount, no comma for cents) 
D=Account No. (Customer Account number or Short Code) 
E=Branch Code (Bank Branch Code or Short Code) 
F=Ref (Reference to reflect on Customer Bank Statement) 


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 (NO TOTALS). 
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)

1ABC SHOES526.56 5651222332 632005REF 74839033
2MACAAN1002.366253669887051001ACME SOLUTIONS
3ABC RENTALS985.251015568988051001Inv 784944
4INVESTO9875.5089552110566250655REF 8493
5MELNOS875.355896523321470010REF9403445
Mobirise


File Format

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

© Copyright 2017 ACBEFT- All Rights Reserved