How to generate Currency Transaction Report (CTR) XML In Compliance Planet Anti Money Laundering/Core Banking Finance Software

What is XML?

XML stands for Extensible Mark-up Language. It is a markup language that defines a set of rules for encoding documents in a format that is both human-readable and machine-readable. It is a metalanguage which allows users to define their own customized markup language, especially in a way to display documents on the internet. It was designed to store, transport and describe data. It is a flexible way to create information formats and electronically share structured data via both public and corporate networks.
The software generates XML from CTR FTR exported Transaction and Account Excel files. Here is how to go about it.

NOTE: Only person(s) Assigned right(s) to ‘process CTR reports’ will be able to carry out this Operation.

From the app dashboard, click on “REGULATORY REPORTS” as shown below

Click ‘NFIU CTR/FTR’ on the drop-down list. See an example in Fig below. This will display the NFIU CTR/FTR page.

STEP 1: From the menu, Click “Export Report to XML” as in Fig 2.4a below.

Fig 2.4a

• This displays a planet CTR XML console as in Fig 2.4b below

Fig 2.4b

STEP 2: Click on “SELECT CTR TRANSACTION FILE“ to upload the Excel file containing the transaction details, from your computer.

Fig 2.4c

STEP 3: Click “SELECT CTR ACCOUNT FILE“ to upload the Excel file containing the account details, from your computer.

Fig 2.4d

NOTE: The two files are required to generate a CTR FTR XML file; CTR TRANSACTION FILE and CTR ACCOUNT FILE. Both files must be uploaded. None is optional

STEP 4: Click “Export Queue Name” text box to set the name of the document. See this in Fig. 2.4e.

Fig. 2.4e

STEP 5: Tick ‘Download XML Preview File’ to generate and download XML Preview file. See the button in fig. 2.4f below.

Fig. 2.4f

STEP 4: Click on ‘GENERATE XML’. This button is the blue button at the bottom-right corner of the XML console as in Fig.2.4g below.

Fig. 2.4g

• A confirmation console will be displayed as in Fig. 2.4h below

Fig 2.4h

• An Upload report file will be downloaded on your computer at the end of the upload. This file will provide information about the number of transactions extracted, transactions generated, transactions not generated, number of files generated and the file name.

When the operation is complete, you can open the XML files.