Guidelines on Submission of SIPB Reports thru the LGU Integrated Financial Tools (LIFT) System

September 19, 2019 BLGF MEMORANDUM CIRCULAR NO. 023-19 TO : All BLGF Central and Regional Officials and Employees; All Local Treasurers and Assistant Local Treasurers; and Other Officials Concerned SUBJECT : Guidelines on the Submission of the Statement of Indebtedness, Payments and Balances (SIPB) Reports thru the Local Government Unit (LGU) Integrated Financial Tools (LIFT) System This Memorandum Circular is issued to guide all concerned in complying with the requirements of Department Order (DO) No. 054-2016, 1 issued by the Secretary of Finance, dated 25 October 2016, mandating the submission of the Statement of Indebtedness, Payments and Balances (SIPB) for timely and accurate monitoring of LGU loans and borrowings. CAIHTE The herein attached Annex A provides guidelines on the submission of the SIPB reports under the Local Government Unit (LGU) Integrated Financial Tools (LIFT) System with version 2.23.21, for information and reference. The submission/uploading of the SIPB is on a quarterly basis, and shall be uploaded to the LIFT System on or before the following dates: i. For the first three quarterly reports: On or before the 20th of the month following the end of each quarter; and ii. For the year-end report: On or before March 31 of the subsequent fiscal year. In case the submission date falls on Saturdays, Sundays, Holidays and declared non-working holiday, the submission will be on the following working day. The URL address and official website in encoding and uploading the SIPB reports are as follows: Local System localhost:8080/lguWeb Central System esre.blgf.gov.ph In case of errors/problems which require highly technical assistance from the BLGF Office, same should be reported to the BLGF Local Debt Monitoring and Evaluation Division (LDMED) through (02) 522-8770 or at [emailprotected] . All Regional Directors are hereby instructed to inform, disseminate and cascade the herein guidelines to all concerned. Please be guided accordingly. (SGD.) NIO RAYMOND B. ALVINA Executive Director ANNEX A Guide on the Submission of the Statement of Indebtedness, Payments and Balances (SIPB) Reports thru Local Government Unit (LGU) Integrated Financial Tools (LIFT) System A. CREATING REPORT PERIOD FOR 1ST TO 4TH QUARTERS 1. Click Report Period in the left Menu. Report Period will be displayed. 2. Click Add (+) sign to Add Record. 3. Select Year. (2010 to 2020) 4. Select Quarter. (First Quarter, Second Quarter, Third Quarter, Fourth Quarter) 5. Select Install Type. Check TR (Treasurer) DETACa 6. Select Status. (Open) 7. Click Save. Message box will be displayed. 8. Click OK. 9. Click X to close. 10. After closing, the encoded period will be displayed in the Reporting Period Module. Report Period must be opened first before encoding any information on any of the facilities. B. ENCODING OF SIPB REPORTS All fields with asterisk (*) are required . 1. Click Actual Transaction on the left menu, SIPB Menu will be displayed. 2. Click SIPB on the sub-menu. SIPB page will be displayed. 3. Click Add (+) Sign. Debts window will be displayed. 4. Select Creditor.* 5. Enter Loan Reference Number.* MAJOR DETAILS TAB 1. Select Authorized Depository Bank.* If No. Follow step 2 under Major Details. 2. Enter State DC. No. 01.2017 3. Enter Certificate Number (CNDSBC).* 4. Select Date of Certification (CNDSBC).* 5. Enter Monetary Board (MB) Resolution Number. 6. Select Date of MB Opinion. 7. Enter Amount of Proposed Loan.* 8. Select Date of Approval Loan.* 9. Enter Amount Approved.* 10. Enter Principal Amount of Loan.* 11. Enter Name of LCE at the time of Contract Signing.* 12. Enter National Government Guarantee. 13. Select Type of Indebtedness Instrument.* 14. Enter Please specify Indebtedness Instrument. 15. Select Purpose of indebtedness here.* 16. Please specify purpose of Indebtedness here: 17. Select Included in the Annual Investment Plan. If NO follow step 18. 18. Select Remedy.* 19. Enter Please specify remedy. 20. Enter Council of Resolution Number.* 21. Enter Economic/Useful Life of the Project (Subject of Loan). 22. Select Maturity Date.* 23. Enter Terms of Indebtedness. 24. Enter Number of Years of Indebtedness.* 25. Enter Interest Rate.* 26. Select Frequency of Payment.* 27. Enter Grace Period (Number of Months). aDSIHc 28. Select Starting Date of Payment.* OTHER DETAILS TAB 1. Enter Major Debts Covenants. 2. Enter Collateral Security. 3. Enter If cash deposit, how much? 4. Enter Other relevant terms and conditions (of loan). 5. Enter Annual Budget at the time of Loan. 6. Click Save. Message Box will be displayed. 7. Click OK. PAYMENT DEBT DETAILS 1. Click Add (+). Payment Debt Details window will be displayed. ATICcS 2. Select Period.* (2019-1) 3. Principal Loan Amount,* Term Interest Rate* and Maturity Date* are automatically generated by the System. ANNUAL AMORTIZATION TAB Annual Amortization 1. Enter Principal.* 2. Enter Interest.* 3. Enter GRT. 4. Enter Current LCE (as of date of this report).* 5. Select LCE Position.* 6. Enter Total Amount Released (Availment as of Date)* Cumulative Payment 1. Enter Principal.* 2. Enter Interest.* 3. Enter GRT. 4. If Default* is YES. Follow steps 5-12. 5. Enter COA Audit Report No.* 6. Select Date Related.* 7. Enter Accountant Name.* 8. Enter Treasurer Name.* 9. Enter Reason for Discounting Payment.* Arrears 10. Enter Principal. ETHIDa 11. Enter Interest.* 12. Enter GRT. 13. If Default is NO, steps 5-12 should be disabled. Sinking Funds 1. Enter Deposit to bond sinking fund for the year. 2. Enter Sinking fund balance to date. 3. Enter Current Annual Budget.* 4. Enter Current Budget Allocation for Debt Service.* 8. Select Date Seal of Good Housekeeping is Awarded. FEES TAB 1. Click Fees Tab. Fees tab will be displayed. 2. Click Add (+). Row will be displayed. 3. Select Fee/Cost Type. 4. Enter Amount. 5. Click Add (+) to add more records. 6. Repeat steps 3-4. PROJECTS TAB 1. Click Projects tab. Projects tab will be displayed. 2. Click Add (+). Row will be displayed. 3. Select Project Name. 4. Enter Amount of Obligation. 5. Click Add (+) to add more records. 6. Repeat steps 3-4. 7. Click Save. Message Box will be displayed. 8. Click Ok. a. ENCODING OF SUCCEEDING QUARTER SIPB REPORTS Assuming that the Local Treasurer has already encoded the Reporting Period for the 1st Quarter, the next step is to proceed with encoding. For: 2nd Quarter for the second reporting period 3rd Quarter for the third reporting period 4th Quarter for the fourth reporting period 1. Click Actual Transaction on the left menu, SIPB Menu will be displayed. 2. Click SIPB on the sub-menu. SIPB page will be displayed. cSEDTC 3. Click Edit (Pencil Icon) on the latest quarter previously encoded (latest loan to be edited). Debt Page will be displayed. 4. Click Payment Debt Detail on the sub-menu. 5. Click Add (+) Record. Payment Debt Details window will be displayed. 6. Select the Period. (2019-2) 7. Encode the field with asterisk (*) sign which is required. 8. Click Save. Message Box will be displayed. 9. Click OK. 10. Click X to close. 11. The encoded Period and Remaining Balance is displayed in the Debts sub-module. 12. Click X to close. Footnotes 1. Streamlining the Certification of Net Debt Service Ceiling and Borrowing Capacity of Local Government Units.