Tag: NFIU Currency Transaction Report

The CTR/FTR process panel presents all the transaction types and their date range, and the number of transactions under each transaction type that have been processed on the Compliance Planet.  The date range on the planet refers to the earliest and latest dates of transactions processed in the Compliance planet.

Note: Only persons assigned the right(s) to ‘view CTR reports’ and ‘process CTR reports’ will be able to carry out this operation.

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

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

Fig

From the menu, click on “Process Panel”, and this will display all the transaction types, date range, total records, and status as in Fig below.

Fig

For further enquiries: 
Tel: +234(0) 816 555 9818
Email: solutions@efuelite.com 
Web: https://solutions.efuelite.com

The CTR/FTR Transaction Report can be scheduled and downloaded instantly at any period/time. Reports can be exported in Excel format and XML format without the need for additional conversion. Here is how to schedule and download CTR FTR transactions:

NOTE: Only the 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:

Fig

• This will display a drop-down, as shown in Fig. below. The drop-down menu lists the report types available on the Compliance Planet software.

Fig

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

Fig

STEP 1: From the menu, click “Download Reports,” as shown in Fig 2.3a below

Fig 2.3a

The download reports display all the different types of transactions as shown in Fig. 2.3b below

Fig 2.3b

STEP 2: Click ‘Set Start Date’ and ‘Set End Date’ to specify the periods you want the software to download reports for.

• This will display a calendar dropdown as if Fig 2.3c and 2.3d below

Fig 2.3c

Fig 2.3d

• Take a look at the arrows labelled a to d in Fig. 2.3e to study the calendar.
• Click on the given year to change it to your year of choice.
• Click on the given month to change it to your month of choice
• Click on the day of the month
• You can also click on the angle brackets on the calendar ( ‘<’ or ‘>’ ) to go backward or forward.

Fig 2.3e

STEP 3: Tick the checkbox of the transaction type(s) you want to process, as in Fig 2.3f below. You can tick as many transaction types as you want. To deselect any of the transaction types, untick their checkboxes.

Fig 2.3f

• You can select all transaction types listed on the console by ticking the ‘Select all transaction types’ checkbox, as shown in Fig 2.3g below. Also, you can deselect all transaction types listed by unticking the ‘Select all transaction types’ checkbox.

Fig 2.3g

• You can also select the “Uncategorized” option, which will display all reportable transactions (regardless of the transaction type) for the specified date range, as shown in the image below. This type of report does not include external customer data.

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

Fig 2.3h

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

Fig 2.3i

STEP 5: Select the preferred file DOCUMENT TYPE(S) you want the report exported by ticking either the Excel or XML checkbox. Select Excel to export the report as an Excel file, or select XML and XML Preview to export reports to XML. See an example in Fig. 2.3j below.

Fig 2.3j

STEP 6: Choose the EXCEL FILE TYPE that the software should process. There are two Excel file types: one for Transaction details and the other for the details of the Account involved in the transaction(s). You can select one or both.

Fig 2.3k

STEP 7: Tick the DOCUMENT SPLIT OPTION(S). This step is optional.

By clicking on the document split option(s) for either Excel file or XML, the software will generate separate transaction or account files for each transaction type.

For instance, not ticking the document split in Fig. 2.3l below will result in the software combining all the transaction details of each transaction type and exporting them into a single Excel sheet. In this instance, the name of such a file will start with ‘CTR Account,’ in the case of the Transaction Excel file, type the file name with ‘CTR Transaction’. If you select ‘split Excel transaction file’ as in Fig. 2.4j below, the Software will write the transaction details of each transaction type in separate Excel files. This is also the case for XML. The different files will bear the name of each transaction type.

Fig 2.3l

STEP 8: Click on the “PROCESS REPORT“ button to generate the report. To cancel the schedule, click the “DISMISS CONSOLE“ button. These buttons are at the bottom-right corner of the console.  (see Fig. 2.3l above)

• Clicking ‘Process report’ displays a confirmation console as in Fig. 2.3m.

Fig 2.3m

• Click “Confirm” to proceed with the download or “Cancel” to return to the console.
• Clicking confirm displays the signal console as in Fig. 2.3n below, which shows ongoing processes

Fig 2.3n

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

For further inquiries: 
Tel: +234(0) 816 555 9818
Email: solutions@efuelite.com 
Web: https://solutions.efuelite.com

Note:  Only persons assigned right(s) to ‘view CTR reports’ and ‘process CTR reports’ will be able carry out this operation.

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

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

Click ‘NFIU CTR/FTR’ on the drop down list. See an example below.

• This will display the NFIU CTR/FTR page

Fig

STEP 1: From the top menu , Click “Explorer” as in Fig 2.6a below

Fig 2.6a

• This displays a page as in Fig 2.6b below

2.6b

STEP 2: Select the transaction type you want to explore by clicking on the Tran Type box. A drop-down will be displayed under the box as in fig. 2.6c. Select any transaction type of your choice.

(fig. 2.6c)

STEP 3: Click on the filter box to select a particular bank branch you want to see transactions for. (See the example in fig. 2.6d). If you want to see the transactions for all branches, select bank branches. It is the first option on the filter list.

(Fig. 2.6d)

STEP 4: Click on the Start date button and End date button to specify the beginning of the period and the end of the period of the transactions you want to see respectively. A calendar drops below the date box when you click any of the date buttons. (See fig. 2.6e)

(fig. 2.6e)

• Take a look at the arrows labelled a to d in fig. 2.6f to study the calendar.
• Click on the given year to change it to your year of choice.
• Click on the given month to change it to your month of choice.
• Then, click on the date of the month.
• You can also click on the angle brackets on the calendar [ ‘<’ or ‘>’ ] to go backward or forward.

(fig. 2.6f)

STEP 5: Click on the entries box to change the number of transactions you want to see per page. (See the drop-box in fig. 2.6g. below)

(Fig. 2.6g)

STEP 6: To see the transactions, click on PREVIEW as in fig 2.6h.You can change your start date, end date, or bank branch or number of entries per page as you wish but always click on the preview button to see the changes you’ve made. It is the preview button that effects the changes you have made.  See fig 2.6h.

(fig. 2.6h)

• After clicking on the preview button, the transactions appear with their respective details row by row and three (3) action buttons; ‘Tran Details’, ‘Acc Details’ and ‘Delete’.  See an example in fig 2.6i below. White arrows indicate the action buttons.

(fig 2.6i)

• clicking Tran Details button (arrow 1 in fig 2.6i) displays a page with the details of the transaction on that row you clicked on like the example in fig 2.6j. The detail covers information about debit and credit part of the transaction according to the CTR FTR schema.

(fig 2.6j)

• Clicking Acc Details button (arrow 2 in fig 2.6i) displays a page with the details of the account involved in the transaction on that row you clicked on. See fig 2.6k to see an example of a CTR FTR Account details page.

(fig 2.6k)

• To delete the transaction from the compliance planet, click on the Delete button (This is labelled as arrow 3 in fig 2.6i). This will display a confirmation console to confirm your action. It looks like fig. 2.6l. Click on confirm to delete the transaction or cancel to close the console.

                                                                                    (Fig. 2.6l)

For further enquiries : 
Tel +234(0) 816 555 9818
Email solutions@efuelite.com 
Web http://solutions.efuelite.com

The Compliance Planet software can help you with graphs with the volume and/or value of transactions plotted against the time or period in which they occur. Thus, making financial reporting easier. To get the analysis of any transaction type over a period of time, 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 left hand side menu, Click on ‘REPORTS’ as shown below

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

Click ‘NFIU CTR/FTR’ on the drop down list. See an example below.

• This will display the NFIU CTR/FTR page

STEP 1: From the top menu , Click “Business Analysis” as in Fig 2.5a below

• This displays a page as shown in Fig 2.5b below

(fig. 2.5b)

STEP 3: Click on SET START DATE and SET END DATE to specify the beginning and the end of the period (respectively) for which you want to see. You must set your date parameters before selecting any transaction type for analysis.

(fig. 2.5c)

• Take a look at the arrows labelled a to d in fig. 2.5d to study the calendar.
• Click on the given year to change it to your year of choice.
• Click on the given month to change it to your month of choice.
• Then, click on the date of the month.
• You can also click on the angle brackets on the calendar [ ‘<’ or ‘>’ ] to go backward or forward.

(fig. 2.5d)

STEP 4: Tick the checkbox ◻ of the transaction type(s) you want to view. As soon as you select a transaction type, the software processes it and immediately displays a graph . Fig. 2.5e below is an example for NIP Inward transaction for 1st of June, 2017 to 15th of June, 2016.

(fig. 2.5e – one transaction type graph)

• Looking at fig. 2.5e above, the time or periods are always labelled on the x axis (horizontal axis) and the volume or values of the transactions are always on the y axis (vertical axis). So, from the example in the fig. 2.5e, about 500 to 600 ‘NIP Inward’ reporting threshold transactions occurred on the 2nd of June, 2017.
• You can see analysis for more than one transaction type. See fig 2.5f and 2.5g to see the analysis for two (2) and three (3) transactions types at the same time on the same graph respectively.

• Two-Transaction Type Graph:

(fig. 2.5f – two-transaction type graph)

• Three-Transaction Type Graph:

(fig. 2.5g – three-transaction type graph)

• You can check all the boxes if you want to see analysis for all. See fig. 2.5h below to see an example.

(fig. 2.5h – All transactions analysed on the same graph)

• You can switch to a larger view of your graph by clicking on the ‘Enlarge View’ button. This button is at the top-left side of the graph, above the selected transaction types.  Check fig 2.5i and fig. 2.5j to see the Enlarge button and the Enlarged view of the graph respectively.

(fig. 2.5i)

• An enlarged view of the graph:

(fig. 2.5j)

• From the fig. 2.5j above, you can see a red button at the bottom-right of the console. It is the DISMISS button to close the enlarged view of the graph. By clicking it, you will be led back to the transaction analysis page as that in fig. 2.5i.
• Once you set your start and end dates and select transaction type, you cannot change the date settings by going straight back to the calendar or deselect any transaction type by unchecking its box. You have to click on the Reset button. Check out fig. 2.5k to see the reset button at the top right area of the transaction analysis page.

(fig. 2.5k)

• As seen in fig. 2.5e, fig. 2.5f, fig. 2.5g, fig. 2.5h, fig. 2.5i, fig. 2.5j and fig. 2.5k, names of the selected transaction types appear with coloured rectangular buttons before each of them. The colours differs from one transaction type to another. The colour of the button before each transaction type represents the colour of the transaction type line on the graph. These coloured buttons appear right above the graph both in the enlarged or normal view. 
• To hide transactions line on the graph, click on the box just before the name of the transaction type(s) you want to hide and click the box again to re-select. See fig 2.5l and 2.5m to see a graph before hiding one of the transactions  and after hiding the transaction type

(fig. 2.5l)

(fig. 2.5m)

STEP 5: 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 reset the parameters on the x axis.

• By clicking Daily, the value or volume of the transaction type is plotted against each day within the period you specify in your date settings. The default view type is ‘DAILY’.
• By clicking Monthly, the value or volume of the transaction type is plotted against each month within the period you specified in your 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 you specified in your date settings . This feature will have effect if the period specified in your date settings spreads to two or more years.

STEP 6: Click on CTR Volume Analysis or CTR Value Analysis or Dual View to see analysis based on volume of transactions or value of transactions or value and volume together. The volume analysis button and the value analysis button only change parameters on the y axis to number or amounts.

• 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. 2.5n below for an example on NIP Inward volume analysis.

(fig. 2.5n)

• 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. 2.5o below for an example on NIP Inward value analysis.

(fig. 2.5o)

• By clicking on the Dual View, the software places both analysis, i.e. volume and value, side by side.

(fig. 2.5p)

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.