Tag: CBN ADRAPS FTR Report

This operation involves downloading foreign transaction reports. The processes and operations outlined in this report are similar to those described in the CTR FTR Report. Here is how to schedule and download ADRAPS FTR:

NOTE: Only person(s) profiled and assigned the right to ‘Process FTR Reports’ will be able to carry out this operation.

Step 1: From the app dashboard, click on “REGULATORY REPORTS” as in Fig. 3.4a below.

Fig 3.4a

Step 2: Click on “CBN ADRAPS FTR” on the drop-down list, and this displays the ADRAPS FTR page as in Fig. 3.4b below.

Fig 3.4b

Step 3: From the menu, click “Download Report” as shown in Fig. 3.4c below.

Fig 3.4c

A console will be displayed on the screen as in Fig. 3.4d below, for you to fill in the details and parameters for your report.

Fig. 3.4d

STEP 4: Click on “SET START DATE“ and “SET END DATE” to specify the beginning and the end of the period (respectively) for which report(s) to be generated. A calendar drops below the date box, like in Fig. 3.4e and Fig. 3.4f.

Fig. 3.4e

Fig 3.4f

Take a look at the arrows labelled a to d in Fig. 3.4g to study the calendar.

1. Click on the given year to change it to your year of choice.
2. Click on the given month to change it to your month of choice.
3. Then, click on the date of the month.
4. You can also click on the angle brackets on the calendar [ ‘<’ or ‘>’ ] to go backward or forward.

Fig. 3.4g

STEP 5: Select the transaction(s) you wish to process by marking their checkboxes. You can select one or more, as in Fig. 3.4h.

Fig 3.4h

You can select all transactions by clicking on ‘Select all transaction types’ as in Fig. 3.4i for processing at once.

Fig 3.4i

You can also select the “Uncategorized” option, which will give you all reportable transactions (irrespective of the transaction type) for the specified date range, as shown in Fig. 3.4j below. This type of report does not include external customer data.

Fig 3.4j

STEP 6: Click on ‘SUPPLEMENTARY REPORT CONSOLE’ as in Fig 3.4k below to download the report on the Specific account number(s) only within the period selected.

Fig 3.4k

• This displays a text box where the account number(s) are to be entered. Note that each account number is to be separated by a comma. See an example in Fig. 3.4l below.

Fig 3.4l

STEP 7: Select the document type; there are two options: Excel or XML. So, tick either of the two or select both. See Fig. 3.4m for an example.

Fig 3.4m

STEP 8: Tick the document split option(s). This step is optional. It all depends on whether you want to combine all the selected FTRs that you wish to process into one file or produce the reports for each FTR in separate files. By clicking on the document split options for either the Excel file or the XML, the software will generate individual reports for the different transaction types. For instance, in the fig. 3.4n, marking the split option will result in the planet generating each ADRAPS FTR file separately. Reports can be exported in Excel format and XML format without any additional steps.

Fig 3.4n

STEP 9: Click on “Process Report” to generate files as in Fig. 3.4o below.

Fig 3.4o

To make changes to your report settings on the ADRAPS FTR Console, click on Cancel. This will take you back to the scheduler.

Click on “Confirm” to confirm your answer.

Fig 3.4p

• The signal console shows ongoing processes. An example of a signal console is fig. 3.4q below.

Fig 3.4q

• You can terminate unfinished processes by clicking CANCEL OPS.
• To minimize the signal console, click on “DISMISS CONSOLE“. This button is next to the CANCEL OPS button.

Here, the software can generate graphs with the value and/or volume of transactions plotted against the time or period in which they occur. To get the planet to give you an analysis of any ADRAPS FTR type over a period of time, here is how to go about it.

NOTE: Only person(s) assigned right(s) to ‘process FTR Reports’ will be able to carry out this Operation.

STEP 1: From the left hand side menu, Click on ‘REPORTS’ as shown below

• This will display a drop down . The dropdown lists the report types available on the compliance planet software.

STEP 2: Click ‘CBN ADRAPS FTR’ on the drop down list. See an example below.

• This will display the ADRAPS FTR page as shown below

STEP 3: From the Top menu, click “Business Analysis” as shown in fig 3.6a below

(fig. 3.6a)

This displays a page as in fig. 3.6b below.

(fig. 3.6b)

STEP 4:          Click on SET START DATE and SET END DATE to specify the beginning and the end of the period the analysis will cover. You must set your date parameters before selecting any transaction type for analysis. Take a look at fig. 3.6c to see how to set the date. Fig. 3.6d shows a labelled calendar next.

(fig. 3.6c)

Take a look at the arrows labelled a to d in fig. 3.6d to study the calendar.

1. Click on the given year to change it to your year of choice.
2. Click on the given month to change it to your month of choice.
3. Then, click on the date of the month.
4. You can also click on the angle brackets on the calendar [ ‘<’ or ‘>’ ] to go backward or forward.

(fig. 3.6d)

STEP 5:          Tick the checkbox ◻ of the FTR type(s) you want to view. As soon as you select a transaction type, the software processes it and displays a graph instantly. Fig. 3.6e below is an example for Cash Deposit ADRAPS FTR for 1st of June, 2017 to 30th of June, 2016.

(fig. 3.6e)

• More than one transaction can be selected. You can select all if you wish. See fig. 3.6f below for an example of graph analysis for more than one transaction.

(fig. 3.6f)

• ADRAPS FTRs can be analysed by the volume of the selected transactions or the value of the selected transactions. The Volume analysis is the default analysis you will get anytime you want to analyse any transaction. However, you can view both analysis side by side.
• By clicking on the CTR Volume Analysis, the graph analysis will be according to the number of the transactions that occurred in the period you specified in your date settings. Look at fig. 3.6e above for an example.
• By clicking on the CTR Value Analysis, the graph analysis will be according to the amounts (in naira) of the transactions that occurred in the period you specified in your date settings. Look at fig. 3.6g below for an example on value analysis.

(fig. 3.6g)

• By clicking on the Dual View, the planet places both analysis, that is both volume and value, side by side. See an example of a dual view in fig. 3.6h.

(fig. 3.6h)

• To see a bigger view of your graph, click on the ENLARGE button. Check out fig. 3.6i to see the button.

(fig. 3.6i)

• See fig. 3.6j and fig. 3.6k for an enlarged view of a graph (one analysis) and an enlarged view of two graphs together (dual view of the value and volume analysis) respectively.

(fig. 3.6j)

(fig. 3.6k)

• There is a red button at the bottom-right corner of the graph console. It is the DISMISS button for closing the console. Click on it as in fig. 3.6k above and the enlarged view will be closed.

STEP 6: Click on DAILY or MONTHLY or YEARLY to change parameter of the time or period. You can switch these view options to see analyses differently. These buttons are next to the End Date button on the page. See fig. 3.6l below to view them.

(fig. 3.6l)

• By clicking Daily, the value or volume of the transaction type is plotted against each day within the period specified in the date settings. This is the default view setting on the planet for every analysis.
• By clicking Monthly, the value or volume of the transaction type is plotted against each month within the period specified in the date settings. This will have effect on analyses with date settings that spread to two or more months.
• By clicking yearly, the value or volume of the transaction type is plotted against each year within the period specified in the date settings. This feature will have effect if the period specified in your date settings spreads to two or more years.

• Once you select any start date, end date and you mark any transaction for analysis, the software processes the details of the transaction selected right away, so, you cannot undo any setting you have made. You can only switch between volume and value analysis and change your view type. To make new settings for a fresh analysis, click on the RESET button. The software will wipe off all your previous selections. See fig. 3.6l below to view the Reset button. It is next to the View Type buttons

(fig. 3.6m)

XML stands for Extensible Markup 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 that allows users to define their own customized markup language, particularly for displaying 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.

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

The software can help you generate XML files from Excel. Here’s how to proceed.

Step 1: From the app dashboard, click on “REGULATORY REPORTS” as in Fig. 3.5a below.

Fig 3.5a

Step 2: Click on “CBN ADRAPS FTR” in the drop-down list, and this displays the ADRAPS FTR page, as shown in Fig. 3.5b below.

Fig 3.5b

Step 3: From the menu, click “Export Report to XML” as in Fig. 3.5c below.

Fig 3.5c

A ‘Planet ADRAPS FTR XML Console’ as in Fig. 3.5d below will be displayed.

Fig 3.5d

Step 4: Click on ‘Select ADRAPS FTR Transaction File’ to upload an ADRAPS FTR file from your computer, as in Fig. 3.5e. The information in the uploaded file is what Compliance Planet will convert into an XML file. See how to upload a file from your computer.

• Note: if you are uploading a transaction file downloaded from the Compliance Planet, you must

1. Unlock the Excel file; to do this, open the Excel file and click “enable editing” in the Excel editor.
2. Delete the S/N column in the Excel file to be uploaded.

Fig 3.5e

• If you do not have the file specification for uploading the ADRAPS FTR transaction, you can download it from the “SYSTEM DATA SPEC FILES” on the software.
• Go to the Regulatory Report page and click “SYSTEM DATA SPEC FILES” as shown below.

• Click the download button associated with the report type, as shown below.

• An Excel file will be downloaded to your computer with pre-filled titled columns under which the details will be entered. Open the file, fill in the required details of the ADRAPS FTR account data, and save the changes. Renaming the file on your computer is optional. Go back to the software and click on ‘Select ADRAPS FTR Transaction File’ to select the file.
• The file must be unlocked in the Excel editor by clicking enable editing, and data must be filled in, as the software will not process an empty file.

Step 5: Tick ‘Download XML Preview File’ to download the XML preview file. This preview file provides a numerical download report on the XML file generated, including the total number of transactions XML generated, the total number of transactions not generated, and the number of transactions extracted from the ADRAPS file uploaded. It also gives details of transactions with missing information. It is in Excel format. See Fig. 3.5f to see the checkbox.

Fig 3.5f

Step 6: Click on the ‘Export Queue Name’ textbox to set the file name. See an example in Fig. 3.5g below.

 Fig 3.5g

Step 7: Click on “GENERATE XML“. Refer to Fig. 3.5h below to locate the blue button at the bottom-right corner of the console.

 Fig 3.5h

•  This displays a confirmation console as in Fig. 3.5i below.

Fig 3.5i

• To make changes to your report settings on the ADRAPS FTR Console, click on Cancel. This will take you back to the ADRAPS FTR XML Console.
• Click on “CONFIRM “to continue or “CANCEL” to return to the FTR console.
• The Signal console shows ongoing processes as in Fig. 3.5j below

Fig 3.5j

• Click on the “DISMISS CONSOLE“ to close the console.
• Click on “CANCEL” to stop the operation if you do not want to continue with generating the XML file. A confirmation console as in Fig. 3.5k will be displayed. Click on CONFIRM to confirm that you wish to cancel the operation, or CANCEL to return to the XML Console.

Fig. 3.5k