Xls to Mt940
here is video on how to convert Xls excel spreadsheet into Mt940 swift file:
Regarding Transaction Type in Mt940 file: NTRF means Transfer and can be set as default value, I would simply add a new column with NTRF value in it and use it as a type. If you can detect transaction types from your data you can try these ones:
- NTRF = Transfer
- FCHG = Charges and other expenses
- FCHK = Cheques
- FINT = Interest
- FRTI = Returned item
- NBOE = Bill of exchange
- NCHG = Charges and other expenses
- NCHK = Cheques
- NCOL = Collections
- NCOM = Commisions
- NDCR = Documentary credit
- NDDT = Direct Debit Item
- NDIV = Dividends-Warrants
- NECK = Eurocheques
- NEQA = Equivalent amount
- NFEX = Foreign exchange
- NINT = Interest
- NLDP = Loan deposit
- NMSC = Miscellaneous
- NRTI = Returned item
- NSEC = Securities
- NSTO = Standing order
- NTCK = Travellers cheques
more mt940 apps