bnkSEPA v 2.0
This is an engine written in Python that takes a Microsoft Excel spreadsheet and converts into a file that will be processed by the Financial Institution. Other financial institutions that use the same format may also benefit from this ETL ( Extract Transform Load ) engine. The Excel workbook consists of the following worksheets: Payment Information Record — This sheet holds information of the payee account. This will be entity that will upload the file to the bank Credit Instruction Record — This sheet contains the transactions that are to be processed. The maximum number of transactions can be increased (this has already happened). An increase in the number of transactions will require changes to both the Excel and the Python code. Control — This worksheet performs the following functions: It stores within it the password provided by the bank to encrypt the transmission It stores the filename that will be used to package the transmission It provides a summary ...