FOREIGN PRIVATE LOANS - State Bank of Pakistan
Contents
1. Mincccccccosscccceccccccossccssecs 14 LOAN INFORMATION eee eene eren ree 16 LOAN PARTIES i eere eene eee NOD eene hern ence 18 SCHEDULE TAB O eerte eee eere 19 TRANSACTION LIST itascsscesessescess 20 POSITION sscscsscescocsesascescecosseesescescuscescosececonsnssescess 20 ASSIGN AGREEMENT NO E4 P4 OR J O3 SCHEDULES ccccccccccccccccccccccccccccccccccccccccccees 21 BOX 1 WHERE ARE ITRS TRANSACTIONS HOW CAN I ASSIGN TRANSACTIONS TO LOAN AGREEMENT FOR REPORTING FPL STATEMENT 2 cccccccccsccccceccccccccccccccccccccccccccccccccccccccccees 23 A ITRS AND FPL DATASET ARE REPORTED BY DIFFERENT ORGANIZATIONAL UNITS t 23 B BOTH ITRS AND FPL ARE REPORTED FROM SAME UNIT MA CHINE 0 ccecccecccccceccceccesccusceeccesceuses 24 EXPORT DATA TO S9 0 e oet ee e ee pete ee ee Pee e eee eee eoe ee eee eee esee eee esee eee sees 25 DATA EXPORT TO SBP WITH DEPENDENCIES itw cascdubesssscccssccnscccussccesscecescscnscscussecssceeescscnscscussecesseneescnes 26 MANAGE OFFSHORE OTHER TRANSACTIONS ccccccccccccccccccccc2. There are usually two types of schedules Disbursement and Repayment There may be multiple installments both for disbursement and repayments Other fields are Due date Currency Principal Amount Interest Amount and Status If any payment or disbursement is cancelled or rescheduled then the status column is changed accordingly Data for these schedules must be reported as soon as available with the AD This data is important and is used for future projections of payment receipts of foreign private debt It is not mandatory for generating and exporting data file to SBP if schedule is not available Note Schedule does not define or represent actual transactions so it should not be confused as transactions 19 Transaction List tab All foreign exchange transactions which are identified as receipts payments of foreign private debt and assigned to this loan agreement are presented here assignment of transaction is covered later in this manual All transactions are displayed under this tab as read only fields It contains all inflows outflows of private loans reported through ITRS during each month It also includes other transactions entered by the bank in offshore other transaction menu of the system this topic is covered later in this manual Microsoft Access tiw File db Exit Manage Private Loans CNT 2 TSU REPAT 110 06 CNT 3 TSU REPAT KHI 11 001 CNT 4 TSU REPAT LHR 0 1 2009 CNT 5 TSU REPATLOAN 125 20
3. Balan Disbursed Principal Interest Charges Closing Balance o 0 119 985 119 985 899 985 After adding and viewing loan data in Manage Private Loans click OK to save the changes addition for the loans and Close the window 20 Assign Agreement No to E4 P4 or J o3 Schedules Old reporting of foreign private debt consists of subset of foreign exchange transactions reported through ITRS with its own extended data variables such as agreement loan parties schedule etc To facilitate the reporting institutions and to reduce data compilation efforts errors and reconciliations issues this application is developed by extending the foreign exchange reporting application ITRS Private loan monthly transactions are captured in the system by assigning agreements loan agreement numbers and their installments to the transactions captured in ITRS It can be performed by selecting the Assign agreement No to E4 P4 or J O3 schedules option from main FPL window Foreign Private Loans External Debt Version 4 3 3 Current Period July 2012 Manage Loan Information Assign Agreement ta E 4 P4 ar 03 Schedules Manage Offshore Other Transactions Manage Project Information Export Data To SBP Reports Setup Back This will bring up the following screen t frmContractSchedulesMain Schedule Transactions for the Perio 201203 Schedule Type E A P 4 Schedule v Currency
4. Export Data to SBP After setup merging ITRS data loan information data entry and assignment of ITRS transactions to loan agreements check the balances generated by the system with the actual ones If it reconciles then create a data file for submission to SBP For this purpose go to main FPL window and select option Export Data to SBP Es Foreign Private Loans External Debt Version 3 3 3 Current Period July 2012 Manage Loan Information Assign Agreement to EA P4 of JOS Schedules Manage Offshore Other Transactions Manage Project Information Export Data To SBP Reports Setup Back A csv file is generated by the system Ensure that all transactions are assigned agreement number and all loans are assigned parties lenders and borrowers Foreign Private Loans External Debt xX Export Data Current Period March 2012 Please select the data file by clicking on the Export button 1D External Debt CITIBank External_Debt_Export_46_70_201203 csv 46 incidents of Unassigned Agreement on Schedules 0 incidents of Undefined Lender Borrower Information File name and location can be changed if required 25 T 152 External Debt CITIBank 4 Search ay Organize Views New Folder Date Type EM Borrower csv Citibank M Pakistan Dec 2011 csv EM Citibank Pakistan Feb 2012 csv CITIBANK Pakistan JAN 2012 csv Bo E
5. Setup Back Clicking on Manage Project Information presents you with following screen Proyecthtarn gt Description Status Start Date End Date Opened Below is the list of attributes with descriptions Project Code Code allotted to the project by the reporting AD Name Name of the project Description Brief description of the project Status Select opened or closed Start Date Date when the project was started End Date Date at which project was closed completed 29 Reports The application comes with two useful reports for banks to verify the quality of data with official books of accounts These reports should be used to ensure that correct data is submitted to SBP Foreign Private Loans External Debt Current Period July 2012 Manage Loan Information Assign Agreement Ho ta EA P4 ar 03 Schedules Manage OffshoreOther Transactions Manage Project Information Export Data To SBP Reports Setup Back Es Fareign Private Loans External Debt Generate Reports m Darganization Periodi 46 BANK N A March 2012 Loan Position for the Period Loan Transactions for the Period Select period and generate the reports to view transactions and positions for each loan Sample output reports are appended below 30 Report 1 Loan Position for the Period This report displays
6. Purpo Transaction Amo Amount In Base Curr ent Nc Installment Agreement Bank S DOLLA 1564 119 985 119985 46 CITI BANK N DOLLA 1311 DOLLA 1641 DOLL 1436 DOLL 1641 R DOLL 1436 DOLLA 1641 DOLL 1436 DOLLA 1436 DOLLA 1641 DOLL 1436 R DOLL 1528 DOLLA 1436 1528 1436 DOLL 1528 DOLL 1436 R 1 293 545 455 61 132 500 000 5 332 3 571 429 121 924 16 316 925 000 685 25 000 000 521 15 000 000 217 17 000 000 100 1 293 1 545 455 61 132 500 000 5 332 3 571 429 121 924 16 316 925 000 685 25 000 000 521 15 000 000 217 17 000 000 100 21 46 CITI BANK N 46 CITI BANK N 46 CITI BANK N 46 CITI BANK N 46 CITI BANK N 46 CITI BANK N 46 CITI BANK N 46 CITI BANK N 46 CITI BANK N 46 CITI BANK N 46 CITI BANK N 46 CITI BANK N 46 CITI BANK N 46 CITI BANK N 46 CITI BANK N 46 CITI BANK N The above screen displays the period for which the data is been browsed and the schedule type The schedule type contains two data values i e E4 P4 and J O 3 The grid shows all the transactions reported during the month shown above under the selected schedule type First three columns are read only whereas last four columns are in editable mode Here the user can assign loan agreement and install
7. is a next available loan number in the database generated sequentially The loan number will be available in the list of loans with all other available loans Miannmage Private Loans Loan Tope Buyer credit Loan Category Bank Borrowing Long Term Loam Statis pened Select Loan Acres No eee The same procedure can be applied to find an existing loan in the database Once desired new or existing loan agreement is found select it from the Select loan Agreement Registration No and click on Edit button This will bring following screen on your computers Here you can add modify other information for the loan Manage Private Loans Loan Information Loan Parties Schedule Transaction List Position Loan Type Buyer Credit Loan Registration No Is Registered with EPD Loan Category BORRLT Bank Borrowing Long Term Project optional Name Description Signing Date Loan Maturity Date First Disbursement Date Starting Period March 2012 Starting Period Opening Balance 0 Loan Status Opened Closing Period The loan information is divided into five tabs each for managing loan s master information its parties schedule transactions and position The section below discusses each tab in more details 15 Loan Information Tab This is the first tab where master level loan information is maintained It contains various fields some of which are mandatory and others are optiona
8. loan wise position including summary of transactions if any for the reporting month ass GSE BORRLT CNT 27 00 1 AMRELIO788 10 2 922 345 9 0 9 9 2 944 34 CNT 28 002 AMPRELIO788 10 6 689 945 9 2 2 6 293 945 CNT 29 003 A55AS10798 D 398 895 9 9 2 9 398 834 CNT 30 904 SHAYAN 0756 5090 9 9 9 23 020 31 005 SHABEIR 9786 11 4439927 9 9 9 9 lt 3 027 22 De ALI ASGHAROTSE 418 634 9 9 4138 23 008 BADRUDDIN 90786 197 393 9 9 9 9 197 3823 CNT 907 HADIOT785 11 2138 595 9 9 9 2218 50 BPD PU 22 50 DATED 50 000 000 9 9 9 50 000 000 ICLT 1 00 1 078607 9 9 9 9 9 9 CNT 19 HBL 1712160012008 204222 9 9 9 9 204 234 CNT 1 MBL 549 200801 DAT 422 309 9 9 9 9 2 CNT 12 BL 549 2008 02 DAT 2 367 90 9 9 9 9 2 367 90 CNT 13 EL 540 2008 03 DAT 1 803 100 9 9 9 803 100 CNT 14 HEBL 1242 REG 09 01 519 975 9 9 9 9 519 975 CNT 29 1216992 2009 299 9009 9 9 9 9 299 000 CNT 2 HBL1F12160023 2010 39 980 9 9 9 9 39 989 INT R 13511 DATED 390 000 9 9 9 9 399 000 CNT 3e HBL 529 291101 DAT 122 939 9 9 9 9 22 939 CNT 37 280 900 229 NN The report groups all loans based on their category Following columns are displayed 1 Loan Category 2 Code System generated loan agreement number 3 Reference code AD s allotted unique number to each loan agreement 4 Opening Balance as of start of reporting month for each loan 5 Total Amount disbursed during the reporti
9. may ignore the following six windows asking for currencies and balances for S 1 S 4 and S 6 by clicking Next for each subsequent step of the wizard till its completion za Setup Wizard The setup wizard is successful Please chick Finish to continwe Upgrade from Previous Version For upgrading from an earlier version of ITRS you would need to select Upgrade from Previous Version Browse and select the old ITRS mdb file to fetch data from old version and click Next On successful upgrade the following window appears Welcome to ITRS Setup Wizard This wizard will guide you through the setup process Incase of an upgrade please select the existing mdb file Select Installation Type ERI SR ee ea International Transaction Reporting System se Upgrade was successful za Setup Wizard The setup wizard is successful Please click Finish to continue Setup is complete now Click Finish to start the data entry Upgrade Install Foreign Private loans Once the installation of ITRS is completed you would need to setup foreign private loan application for your bank This step is available and required only for head office level setup The following window appears after setup wizard The same screen appears whenever the application is started Select Period Please select period from the list below Select period month for
10. other Resident Bank 33 This will enable the authorized dealer to correctly calculate and report the closing balance for the contract and record the transaction which is missing in ITRS 2 Balance Correction adjustment Banks may need to correct opening balance for historical loans if the mistake is identified after reporting data to SBP through this application It is not practical to change the opening balance in the first period and subsequently generate and report the data for all subsequent periods Balance can be corrected by selecting balance correction receipts payments from same Manage offshore other transactions menu All other fields in the screen should also be filled specially purpose code and amount in base currency Example AD had a loan in USD with opening balance of 20 000 and reported 10 000 principal repayment through ITRS in December 2011 Closing balance in that month will be 10 000 This closing balance was carried forward with other inflows outflows in subsequent months In June 2012 the AD identifies through any source that actually 1000 were remitted instead of 10 000 incorrect reporting in December 2011 Now the AD can adjust its closing balance for June 2012 by selecting balance correction receipts and enter and amount of 9000 being the contra entry It will not affect its ITRS transactions and balance will be corrected Important Note This feature is provided in the application
11. path of the file Click OK followed by clicking on Close to go back to setup menu Data Export To SBP Includes dependencies All loans information till to date are exported in this option as backup Importing Borrower and Lender Master Files Borrowers and Lenders are the two main parties involved in private foreign debt besides authorized dealers Each Bank would need to maintain the list of borrowers and update the application with the same on continual basis The application supports maintaining the lists in a csv file with a simple structure consisting of two fields Code and Name The csv option is chosen to facilitate the banks to extract the same information from their own banking application database Otherwise the same can be maintained by the reporting units using MS Excel which also supports csv files For maintaining borrowers list NTN of borrower will be used entered under Code column whereas Borrower s Company will be entered in Name column All authorized dealers are required to maintain an updated list of their customers with their complete 8 digit NTN for reporting of foreign exchange transactions and foreign private loans data Important Note While maintaining the list of NTN due care must be exercised while recording the same Special care may be given to incorporate the leading zeroes as also depicted in the picture below Sample borrower and lender file is shown in the picture be
12. 009 5 TSU REPATLOAN 125 2006 NT 6 TSU REPAT 06 2008 CNT 7 TSU REPAT KHI 10 002 INT C 295 07 NT 9 TSU REPAT 12 2008 10 INT C 281 06 11 INT C 278 06 INT C 299 07 13 INT C 319 10 22 Box 1 Where are ITRS transactions How can I assign transactions to loan agreement for reporting FPL statement All foreign exchange transactions including private debt transactions are captured through ITRS A data file csv generated through ITRS is submitted to SBP by 5 of the following month to which it relates There can be two types of setups in a bank for reporting FPL and ITRS to SBP a ITRS and FPLs are reported by different organizational units b Both ITRS and FPL are reported from same organizational unit a ITRS and FPL dataset are reported by different organizational units If the two datasets are reported by two different units then ITRS data file will not be available with FPL reporting unit ITRS file will required to be merged in the private loan system You may obtain ITRS file submitted to SBP from ITRS reporting unit every month Place the ITRS data file anywhere on your computer or network drive where you ve access to Select Merge Export Data option from main ITRS switchboard as presented in the picture below Main Switchboard Version 4 3 3 Current Period July 2012 Data Entry Print Reports S wich Period Pernod Maintenance Menge Export Data Setup Jg BULL LU Wiew V e
13. 06 CNT 6 TSU REPAT 06 2008 CNT 7 TSU REPAT KHI 10 002 CNT 8 INT C 295 07 CNT 9 TSU REPAT 12 2008 CNT 10 INT C 281 06 CNT 11 INT C 278 06 CNT 12 INT C 299 07 CNT 13 INT C 319 10 1 Loan information Loan Parties Schedule Transaction List Position a question for help Position Tab Period Purpose _ 201201 1564 1201201 1311 46 6004 201112 1564 46 9 46 6003 X Serial No Agreement Instal Country x T Position tab shows opening and closing balances of a loan for each reporting period month It also shows disbursement principal amount received and repayments principal interest and charges paid during the reporting period The data in the fields are read only and is calculated automatically by the system VIICTOSOTE ACCESS tox Eile Exit CNT 2 TSU REPAT 110 06 CNT 3 TSU REPAT KHI 11 001 CNT 4 TSU REPAT LHR 0 1 2009 CNT 6 TSU REPAT 06 2008 CNT 7 TSU REPAT KHI 10 002 INT C 295 07 CNT 9 TSU REPAT 12 2008 CNT 10 INT C 281 06 CNT 11 INT C 278 06 CNT 12 INT C 299 07 CNT 13 INT C 319 10 CNT 5 TSU REPATLOAN 125 2006 3 1 C NT 1 Loan Information Loan Parties Schedule Transaction List Position IP Period 1201112 1201201 1201202 1201203 899 985 899 985 0 0 119 985 1 293 0 119 985 0 0 0 0 lo 399 985 0
14. 2 it would use 1 1 101 11 2012 If the loan was created by another bank called owner bank and reporting bank only makes transaction for the loan then it will create a loan in its database CNT and use the same reference number obtained from the owner bank Is registered with EPD Yes No Whenever the loan is registered with Exchange Policy Department this flag should be marked as Yes Loan registration reference number would not be changed in any case Loan Category Select from eight categories as per list It is already selected while adding loan information It can be changed any time if needed 16 Project Optional There may be projects for which loans are received from abroad Select the project for the loan here from the drop down list of projects The list of projects can be maintained through this application through a separate menu discussed later in this manual Name Optional A user friendly name of loan This field should not be confused with borrower or lender name Description Optional Describes the loan briefly Signing Date Optional Date of signing the loan agreement Loan Maturity Date Enter the date at which loan will be matured First Disbursement Date The date at which first inflow is received Can be a past date for all previous active loans Starting Period Reporting month from which data is first reported through this application Starting Period Opening Balance Here opening balanc
15. NT 2 TSU REPAT 110 06 B 99941 2 DUPONT PAKI CNT 3 TSU REPAT KHI 11 001 CNT 4 TSU REPAT LHR 0 1 2009 B 2958769 JOTUN CNT 5 TSU REPATLOAN 125 2006 B 225862 NESTLE CNT 6 TSU REPAT 06 2008 B 6564666 ERICSSON P ld A na Nene TIR B 20713297 Warid teleco CNT 8 INT C 295 07 UT CNT 9 TSU REPAT 12 2008 B 28295935 Mitsui O S K CNT 10 INT C 281 06 B 2486636 Tameer Micro pie D lies B 8003831 ENGRO VOP CNT 13 INT C 319 10 B 15431371 KARACHI EL E L 460029 JOHN HARGRE meu 18 Schedule Tab Schedule tab is used for data entry of repayment and disbursement schedules Fa Microsoft Access Xx File amp Exit Type a question for help Im Fa Microsoft Access ix File amp Exit Type a question for help Manage Private Loans t No CNT 1 SS Loan Information Loan Parties Schedule Transaction List Position T ScheduleType installment Nc Due Date Currency Principal A Interest Loan Status Disbursement S 1 25 Sep 2007 1 05 DOLL 899 985 Se Repayment Sched 1 13 Dec 2011 1 U S DOLL 899 985 Cu CNT 2 TSU REPAT 110 06 3 CNT 3 TSU REPAT KHI 11 001 CNT 4 TSU REPAT LHR 01 2009 CNT 5 TSU REPATLOAN 125 2006 CNT 6 TSU REPAT 06 2008 CNT 7 TSU REPAT KHI 10 002 CNT 8 INT C 295 07 CNT 12 INT C 299 07 CNT 13 INT C 319 10 Record M 4 1072 WK No Filter i
16. S These are very rare transactions Private loans offshore inflows outflows are captured through this option Other transactions are those transactions which are used for adjusting calculation of closing balances and these transactions are not reported by owner bank through ITRS Manage Offshore Other Transactions menu provides an option to record these transactions and report the same to SBP Version 4 5 3 Current Period July 2012 Manage Loan Information Assign Agreement to EA4 P4 of JOS Schedules Manage Offshore Other Transactions Manage Project Information Export Data To SBR Reports Setup Back On main FPL switchboard select Manage Offshore Other Transactions The following window appears for data entry of offshore other transactions 8J Trmurrsnorevtner iransacuoniviain X Schedule Transactions for the Perio 201207 Agree Agreement C Agreement Insallmen CNT 1 54 HABIBBAN 54 HABIB BANI Balance Correction Payment Balance Correction Receipt Offshore Payment Offshore Receipt Remittances made by other Resident Bank Paym Ramittanrac mara hu nthar Racidant Rank Roaroi Agreement No Select the Contract Number from the list of available contracts Agreement Organization This is the bank that actually created and owns the contract for the first time 27 Transaction Type Select a relevant type from the list Available list of values are as follows Other Transactio
17. Volume2 INTERNATIONAL TRANSACTIONS REPORTING SYSTEM ITRS version 45x FOREIGN PRIVAIE LOANS Data Warehouse State Bank of Pakistan User Manual Contents INTRODUC TION U H 2 OBTAINING THE TWA ER 2 MOINS 2 E _ E 4 UPGRADE FROM PREVIOUS VERSION ccceccsscssccccescasccsscesccccccceccescasses MMMM csccsccvcccccesccscencasccnsccscescesceesansaeseess 6 UPGRADE INSTALL FOREIGN PRIVATE LOANS 22 2 ccccccccccccccccccccccccccccccccccccccccccccccccccccccccceces 7 SETUP FOREIGN PRIVATE LOANS 9 IMPORTING BORROWER AND LENDER MASTER FILES Miness svetecccceccsccsccctaecsetincsccsceccsccsccececceccsccsccececcesssceececs 10 DATA ENTRY PRIVATE LOANS ccsccossccscososhecastentescoccesccoscsccccecccosscccccectagsaatMecccossccccccccossccsccccccccossccssees 14 MANAGE LOAN INFORMATIONN eee eoo oe Eee onere eene rete
18. and make a contract CNT against this loan Citibank will also assign ITRS transaction to the loan agreement Flows data in SBP will be compiled from transaction reported by Citibank HBL on the other hand will adjust closing balance of this loan agreement by using options Remittances made by other banks receipts payments in Manage offshore other transactions menu 34 Important Note In cases where ownership of the loan agreement has been shifted to the new AD the previous owner may close the loan agreement without changing the balances of that loan by changing the status of loan through Loan Information window The new owner will be required to keep the balances up to date for future reporting 4 Transactions taking place in other currency than what mentioned in loan agreement Receipts payments may be made in currency other than that of loan currency e g loan is in USD and transaction is made in GBP These types of transactions occur quite often due to shortage of nostro balances of that party in a particular currency at a specific point of time In all such situations amount in base currency actual currency as per loan agreement is needed It appears in two places 1 In assigning ITRS transactions 2 in data entry of offshore other transactions Amount in base currency is critical for calculation of closing balance for a contract then it is required to enter equivalent amount in base contract loan currency both in assignin
19. cccccccccccccccccccccccccccccccccccccsccees 27 MANAGE PROJECT INFORMATION ccccccsccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccceccccccecs 29 ge eeee 30 REPORT 1 BOAN POSITION FOR PERIOD NGG ity ccccccececcoccscsccscecceccssscescecsesssceececcnsessaecescecnssasseececcnsnssaecess 31 REPORT 2 LOAN POSITION FOR THE PERIOD cscceceececceccecceccscescccsccscscesceccecescescssescescscsscsseeceecesctsescescescuss 32 IMPORTANT EXCEPTIONAL SCENARIOS ccccccscccsccssccssccccesscessccccesccoscccccosscccscossccccccccosscessccscossccscccsces 33 1 REPORTING UIT SHORE TRAN ACTIONS 33 2 BALANCE CORR I UBTMENT ccsccccocsscssccscsccsscscescescnscssescescsccscessesceccnsessustescessssescessscossesseeees 34 3 TRANSACTIONS REPORTED BY AUTHORIZED DEALER ccceccecosccscecceccecceccececcecceccscescesceccscesceseecosceeees 34 4 TRANSACTIONS TAKING PLACE IN OTHER CURRENCY THAN WHAT MENTIONED IN LOAN AGREEMENT 35 OTHER IMPORTANT NOTES asvessvstiveveis vebnVe ve VEHI EVER ER TEES EVERY EUR ERU VER EE FER XE ER ERES EUER VER VE EEER EE EIE Es 36 REPORTING OF BUGS 1550 6 NS E EIE NS D Veo 36 Introduction This document provid
20. ces of the loans through the system 1 Reporting offshore transactions 2 Balance correction adjustment 3 Transactions of a loan reported by other bank 4 Transactions taking place in other currency than what mentioned in loan agreement base currency 1 Reporting Offshore Transactions Transactions that take place between lender and borrower outside Pakistan are called offshore transactions These payments receipts are not reported through ITRS and hence cannot be assigned to any loan agreement through the standard user interface of this application Since the system calculates closing balance of a loan by addition subtraction of ITRS transactions during a month an offshore transaction results in the mismatch of loan balance amount with the records of AD and the borrower To report these transactions the application provides a separate menu of Manage offshore other transactions on main switchboard of private loan application All necessary fields of the transaction are given in the data entry screen Offshore transaction is entered by the authorized dealer by going to offshore payments or receipts window as shown in the picture below Schedule Transactions for the Perio 201207 Agree Agreement C Agreement Insallmen CNT 1 54 HABIB BAN A 54 HABIB BAN Balance Correction Payment Balance Correction Receipt Offshore Payment Offshore Receipt Remittances made by other Resident Bank Paym Remittances made by
21. d by clic ng in the impart Borrower Information menu item rs Setup External Debt zn Merge Data File Please select the Borrower data file or type in the path of the f 13 Data Entry Private Loans The picture below shows main menu for Foreign Private Debt data capturing application Foreign Private Loans External Debt Current Period July 2012 Manage Loan Information Assign Agreement to E4 P4 03 Schedules Manage Offshore Other Transactions Manage Project Information Export Data To SBP Reports Setup Back The menu option Manage Loan Information is used for data entry of loan information including types maturity loan names parties loan terms payments amp disbursement schedules etc It also provides read only view of ITRS assigned transactions and opening closing balances for each loan To start data entry click on this option A window as shown in picture below would appear Manage Private Loans Loan t Show all TS Loan Category Shows All Loan Status Select Loan Agr Reg No 14 Loan type option lets the user select the type of loan Next category will need to be selected by the user followed by loan status Select relevant option from available list in all these three fields and press Add New button to add loan contract information This will create a new loan in the application with a convention of CNT X where X
22. e amount as of Starting Period must be defined for the loan This is very important as all future calculations are based on this opening balance Loan Status Open means payment or disbursements are outstanding for the loan and ownership of this loan agreement rests with the reporting authorized dealer Closed means the loan has been repaid or converted into equity or waived Another status Deleted is used for deleting a loan that was erroneously entered by the user No loans once created in the database can physically be deleted Closing period Reporting month in which the loan is closed Ensure that this field remains blank for all open loans Loan Currency also called base currency Currency mentioned in loan agreement List of currencies is available in the system Total Loan Amount Total loan amount to be disbursed and agreed in the agreement in the loan currency Payment Term It may include rate of interest e g LIBOR 1 or a fixed interest rate or any other term Disbursement term The terms of loan receipts It may include bullet number of installments one time inflow or other terms as per agreement 17 Loan Parties Tab A loan agreement involves multiple parties having different roles These roles are Lender Borrower and Authorized Dealer There may also be more than one party under each role This tab lets the user define these parties for a loan Manage Private Loans CNT 1 L
23. es step by step guidelines to officials of authorized dealers to record all transactions and related data pertaining to debt on resident private sector entities of non resident entities This document may be followed independently However it is suggested that readers go through the complementing volume 1 User Guide for INTERNATIONAL TRANSACTIONS REPORTING SYSTEM ITRS Volume 1 of this user guide is available with ITRS download Obtaining the Software The ITRS software can be downloaded from knowledge center of SBP s Data Acquisition Portal https dap sbp org pk as well as SBP website http www sbp org pk departments stats datasoft htm Disclaimer The data capturing application software is provided by SBP to facilitate the reporting of subject data on prescribed data format for which specifications are also available separately SBP is not responsible for any misreporting of data due to any bug or otherwise that arises out of usage of this application Nor does SBP provide any warranty against any damage caused to the hardware software or network appliances that arise out of the usage of the software Installation To facilitate the reporting of foreign private loans data and to reduce data reporting errors resulting due to separate reporting of foreign exchange transactions and the private loan data SBP has upgraded ITRS software For software hardware and other requirements to run the software please consult volume 1 of
24. g mdb file Select Installation Type a New Setup Upgrade from Previous Version revious rmapj Fie The two options A New Setup B Upgrade from Previous Version are described as follows New Setup Select New Setup if you are installing ITRS application for the first time and click Next Setup Wizard Select Branch Organization Please Select Branch Please Select wt Branch Type Simple Branch wt Select your Organization Authorized Dealers branch name and the type of branch Head Office and click next Setup Wizard Define New Period Month Mar Year 2007 Define Branch Status Balanced Branch for Statement 5 1 E Balanced Branch for Statement 5 4 Balanced Branch for Statement 5 6 Select the Month and Year for the new open period for which you will enter the data Note For banks having separate data entry desk for reporting Foreign Exchange Transactions and Foreign Private Loans data branch s balancing status is not required while setting up the application for capturing private loans transactions However it is recommended to duplicate the structure of head office level reporting setup here ADs may also need to review their setup to consolidate their reporting operations to enhance the quality of data reported to SBP and to enhance their operational efficiency Click Next For setting up the foreign private loan application independently of ITRS users
25. g ITRS transactions for the month and in managing offshore other transactions Example HBL has a loan in USS An outflow of GBP 6 000 is reported by the bank for the loan in ITRS during a month Let s assume that GBP6 000 were equivalent to USD10 000 on that particular day While assigning ITRS E 4 and Schedule J transaction the AD will enter equivalent USD let s say 10 000 GBP6 000 S10 000 in amount in base currency for GBP6 000 The loan balances stock will now be calculated by using outflow of S10 000 instead of GBP6 000 35 Other Important Notes Parties lender borrowers must be defined accurately for each loan While defining the repayment disbursement schedules the installment numbers in the schedule for a loan should not duplicate All mandatory fields should be filled selected from list properly Avoid Enter Spaces or Tabs after completing the text in a field Reporting of Bugs Issues Send all your queries bugs reports to data warehouse support housed in Statistics amp Data Warehouse Department of State Bank of Pakistan at dwhsupport sbp org pk Other contact details may be found under the contact information on Data Acquisition Portal https dap sbp org pk 36
26. l Loan Information Loan Parties Schedule Transaction List Position Loan Type Buyer Credit Loan Registration No Is Registered with EPD Loan Category BORRLT Bank Borrowing Long Term Project optional Name Description Signing Date Loan Maturity Date First Disbursement Date Starting Period Starting Period Opening Balance Loan Status Closing Period Loan Currency Loan Type This will be selected from the given list It be changed when if needed Loan Registration Reference No Each loan must be identifiable by a unique number in authorized dealer s book Once a reference number is assigned to a particular loan and reported to SBP it will not be changed in any case All loans will be traced through this number If the bank owns the loan contract then Format for registration reference is bank code AD branch code and a unique identifier consisting of any text number date of bank choice but that will remain unique for all future reporting of a particular loan These three parts must be separated by hyphen For example if a loan is created by Foreign Exchange Branch AD code 13 of HBL bank code 54 with a loan registration number 101 11 2012 then a reference number 54 13 101 11 2012 would need to be reported and maintained throughout Similarly if Barclays bank Bank code 1 and branch code 1 had to report a loan with a reference number 101 11 201
27. low 10 SAIF HOLDINGS LTD Name 22936432 DEWAN PETROLEUM PVT LIMITED 15431371 M S THE KARACHI ELECTRIC SUPPLY CORPORATION LTD 27272672 BOSICOR OIL PAKISTAN LIMITED 5 06981879 HABIB BANK LIMITED 21435308 NEW TOYO PAKISTAN ALUMINIUM PRIVATE LIMITED 21384169 LARAIB ENERGY LIMITED 22775994 SAIF POWER LIMITED Lender csv would also have two fields Code and Name ill be updated by gt on continual e 7 _ basis and would be available DAP f nload Each bank download and link it to the application Sample of the file is shown in the fo wi g picture 10002 ABN AMRO BANK A SYNDICATE OF IBRD US EXIM BANK FACILI 10005 ABN AMRO BANK CONSORIUM OF ABN amp STANDARD CHARTEF 10006 ABN AMRO BANE N V NETHERLAND 10007 ABN AMRO N V amp CITIBANK N A NETHERLAND 10009 ASKARI BANK LIMITED BAHRAIN debt click import lender information and import borrower information separately to link borrower and lender files to the system Lender and borrower CSV files can be maintained in any folder of your computer or network drive 11 Setup External Debt Current Period July 2012 Upgrade From Previous Version Data Export To SBP include
28. ment number to each transaction Assign CNT number in column Agreement No to transactions The list of agreement numbers will be displayed CNT 1 to CNT n These are the CNT numbers already entered in the system through Manage Loan Information Installment No can also be entered but list for these Nos is not available One important assignment is Amount in Base Currency If currency of loan agreement is different than that of ITRS transaction then Amount in Base Currency must be entered for calculation of balances of the loan in loan currency E g if loan currency is USS and the transaction in that loan is reported in Euro then equivalent USS in Amount in Base Currency column should be mentioned for the transaction For ease of reporting the system assigns transaction amount as the amount in base currency Note Base currency is the same as entered in the loan information tab for that loan Go back to manage loan information and check transactions assigned to particular loan and its positions balances by clicking edit button Loan Information Loan Parties Schedule Transaction List Position Period Opening Balan Disbursed Principal Interest Charges Closing Balanc 201112 899 985 0 899 985 0 0 0 201201 0 0 119 985 1 293 0 119 985 201202 119 985 0 0 0 0 119 985 _ 201203 899 985 0 119985 0 0 780 000 CNT 1 TSU REPAT 207 07 2 TSU REPAT 110 06 3 TSU REPAT KHI 11 001 4 TSU REPAT LHR 0 1 2
29. ng month for each loan 6 Total amount remitted for principal repayment during the reporting month for each loan 7 Total amount remitted for payment of charges during the reporting month for each loan 8 Total amount remitted for payment of interest during the reporting month for each loan 9 Closing Balance as of start of reporting month for each loan 31 Report 2 Loan Position for the Period This report displays loan wise transactions all inflows and outflows during the reporting month FE Loan Transactions PROJECT CNT 4 1447 INT C 283 06 DATED 16 12 i 522 s5s22552 54 540 2100 15 000 15 000 The report groups all loans based on their category Following columns are displayed 1 Loan Category 2 Code System generated agreement number starting with CNT 3 Loan Reference bank s allotted unique number to each loan 4 Transaction Date 5 Org code reporting bank code 6 AD Code AD branch code 7 Country code 8 Currency code 9 Amount in transaction currency and 10 amount in base loan currency 32 Important Exceptional Scenarios Most of the time routine business flow suffices However sometimes some events occur requiring exception handling Same is also true while compiling and reporting foreign private debt Following are some exceptional situations that an authorized dealer may face rarely These are not routine transactions and due care should be taken to report actual closing balan
30. ns Transaction Types List of value Balance Correction Payment Balance Correction Receipt These transaction types are discussed in a separate section where important exceptional scenarios are discussed The section can be located towards the end of this manual Agreement Installment No Enter installment no if any in the disbursement payment schedule Purpose Select purpose code from the list of codes for private loans Serial No Enter serial no starting from 1 Transaction Date Enter date of transaction By default it shows current date in DD MMM YYYY format Transaction Period The month to which the transaction pertains in YYYYMM format Transaction Authorized Dealer Select from available list Transaction Country Country where the transaction took place Select from the pre defined list of countries Transaction currency Currency of transaction from a pre defined list of currencies Transaction Amount Enter amount in transaction currency Amount in Base Currency equivalent in base currency as per loan agreement 28 Manage Project Information Project information is maintained separately by each bank The same serves as the master list of projects and used in loan information for all project loans Version 4 3 3 Current Period July 2012 Manage Loan Information E Assign Agreement Ho to E4 P4 03 Schedules Manage OttshorerOther Transactions Manage Project Information Export Data To SBP Reports
31. oan information Loan Parties Schedule Transaction List Position Party Role gt Party Details Contribution in Lender 100 0 Borrower 100 0 100 0 CNT 2 TSU REPAT 110 06 CNT 3 TSU REPAT KHI 11 001 CNT 4 TSU REPAT LHR 0 1 2009 CNT 5 TSU REPATLOAN 125 2006 CNT 6 TSU REPAT 06 2008 CNT 7 TSU REPAT KHI 10 002 CNT 8 INT C 295 07 CNT 9 TSU REPAT 12 2008 CNT 10 INT C 281 06 CNT 11 INT C 278 06 CNT 12 INT C 299 07 CNT 13 INT C 319 10 Record 14 of 2 gt bl b i Search Lenders and borrowers list linked up in setup please see previous section will appear here for selection in Party Code NTN The columns Party Role and Party Code NTN are mandatory while Party Details and Contribution in are optional fields If there are more lenders or borrowers for a loan then Contribution in 96 is mandatory This tab must be filled by the AD before submitting this data to SBP Manage Private Loans Loan Information Loan Parties Schedule Transaction List Position Party Role Party Code NTN Party Details Contribution in Lender L 460047 RJ TRADING AND Authorized C AD 70 1 1 Chundrigar Road Borrower B 29075815 Oracle B 698175 Orix 1 B 10007105 ENGRO ASA B 12794147 Lotte Pakista eci B 2846119 ACUMEN FUI CNT 1 TSU REPAT 207 07 B 100493 TERA DATA P C
32. rficatian Aeports m Foreign Private Loans External Debt E xit This will present you with a list of menu items as below Merge Export Switchboard Current Period July 2012 Export Data To SBP 1 Merge Branch s Data Export Balances Export Transactions Merge Department s Data J pm mm Back 23 From the above screen select Merge Branch s Data Merge Export Switchboard x Merge Data File Please select the data file or type in the path of the file lt start Merging Browse ITRS file from your system saved earlier Merge Export Switchboard x Merge Data File Please select the data file or type in the path of the file Browse _ Export Transactions Back Click on Start Merging button to import ITRS transactions in FPL application On successful import the following message should appear Progress Information 93 95 completed iux Gea gt 7 5 tion Reporting System EX f Data imported sucessfully Do you want to import another file Click No and then Close to finish import process b Both ITRS and FPL are reported from same unit machine If ITRS and FPL both reported by the same organizational unit then ITRS data is already available in the same FPL application provided same database mdb is used 24
33. s dependencies Import Lender Information Import Borrower Information HUOUS Back Clicking on Import Lender Information will present the followin g reen from where a user can browse the file by clicking on Browse button s Setup External Debt x Merge Data File Please select the Lender data file or type in the path of the f lt lt Externsi Debt gt CITIBank gt 4 Search Ss Views 4 Favorite Links Name Date modified Type Size E Documents Si Borrower csv i Citibank N A Pakistan Dec 2011 csv 21 Recent Places Gy Citibank N A Pakistan Feb 2012 csv EE Desktop i CITIBANK N A Pakistan JAN 2012 csv SEO Computer i citisIT RSChent madb wy Recently Chang CAJSExternal Debt Export 46 70 201112 zip Pictures Externsl_Debt_Export_46_70_201201 csv EP Music external_Debt_Export_46_70_201201 zip me Searches Lender csv U Public lt ITRSClient idb ig sITRSClient mdb Folders File Borrower Tee Click on Open will take you the previous screen Click on Start Merging Following success message should appear on your screens 12 Setup External Debt x Progress Information 100 completed Please note that this operation will remove all entrie internal lender database and new list is imported from the csv file 4 Similarly Borrower s file can also be importe
34. this user guide Below is the step by step guideline for the first time installation of the software First ITRS version 4 3 3 or later should be installed for private loan application Download and save the sITRSClient mdb file from DAP knowledge center or SBP website Double click the file from windows explorer to run the setup On running the application the following security warning screen may appear on some computers Fo sITRSClient Database Access 2000 file format Microsoft Access Macro Name Click on Stop All Macros and then click ng window would appear next WEA Macro Access has disabled potentially harmful content in this database If you trust the contents of this database and would like to enable it for this session only cick Enable this content Warning It is not possible to determine that this content came from a trustworthy source You should leave this content disabled unless the content prowides critical functionality and you trust its source More informaton File Path D External Debt sITRSClient mcb Help protect me from unknown content recommended Enable this content Open the Trust Center Select Enable this content option and click OK This should present the following screen to users za Setup Wizard Welcome to ITRS Setup Wizard This wizard will quide you through the setup process Incase of an upgrade please select the existin
35. to report the balances of historical loan agreements which are reported to SBP through an un managed environment and should not be misused Due care should be taken to report correct data to SBP in all instances 3 Transactions Reported by Authorized Dealer There may be cases where a loan transaction receipt payment is made by an authorized dealer other than the owner AD of the loan agreement The owner AD may or may not know this fact for a period of time As such this results in discrepant stock position of that particular loan agreement with the owner AD To resolve the issue options Remittances made by other banks receipts payments in the field transaction type have been incorporated for identification of the payments receipts made by other AD This will calculate actual closing balance for the loan in the record of the owner AD Important Note The AD that is not the owner of a loan contract and makes transaction for the loan of other AD owner AD can create a loan for the transaction but it should get Registration Reference Number of the particular loan from owner AD so that the loan can be tracked by SBP Reporting bank will not create its own reference number for the loan and will use reference number taken form owner of the loan contract Example HBL has a loan with reference 54 13 XXYY A transaction against this loan is made by Citibank For reporting of private loans Citibank will get reference number 54 13 XXYY from HBL
36. which the reporting is required Press OK The following screen appears with a list of menu items Main Switchboard Version 4 3 3 Current Period July 2012 Data Entry Print Reports Switch Period Pernod Maintenance MergeExport Data Setup Wiew Verification Reports Foreign Private Loans External Debt 8 6 Ej E E it Select second last option of Foreign Private lo ns External debt This will lead to private loan application main switchboard Foreign Prrvate Loans External Debt Version 4 3 3 Current Period July 2012 Manage Loan Information Assign Agreement Ma to EA P4 ar 03 Schedules Manage Offshore Other Transactions Manage Project Information Export Data To SBP Reports Setup Back Here any option can be selected according to the requirement Setup Foreign Private Loans Select Setup option if application is being installed for the first time or upgraded to a newer version released by SBP za Setup External Debt Current Period July 2012 3 Upgrade From Previous Version D ata Export To SBP includes dependencies mu Import Lender Information Import Borrower Information mm Back Select Upgrade from Previous Version This option can be used only by those banks where private loans application and data already exist mar b Setup External Debt hTerge Date File Please select the data file cor type in the
37. xternal Debt Export 46 70 201201 csv Recently Chang ENI Lender csv j Pictures s temp march12 itrs csv Music avorite Links Documents Recent Places Desktop Searches Public name Extemal Debt Export File cs Click Open to save the file in the specified location Export Data Current Period March 2012 Please select the data file by clicking on the Export E button _ D External DebtYCITIBank External Debt Export 46 70 201203 csv 45 incidents of Unassigned Agreement No on Schedules 0 incidents of Undefined Lender Borrower Information Si cpa CSRS ARE A CENSUM T rn International Transaction Reporting System Data file has been exported as Debt CITIBankExternal_Debt_Export_46_ 0_201203 cev Data Export to SBP with dependencies This export will be useful when the banks will be reporting their data for the first time This export will include the following Projects all data Loan all data Loan Schedule all data Loan Party all data Loan Transactions only for the specific period Loan Position only for the specific period 26 Manage Offshore Other Transactions Offshore transactions are those which take place outside country s boundary and are not reported through ITR
Download Pdf Manuals
Related Search