1 / 29

Public Financial Management System (PFMS) Excel User Guide

Learn how to manage vendors and customize bulk transactions in PFMS using Excel. Fill, rename, and upload Excel sheets for seamless financial management. Detailed instructions provided step by step.

chamberlaine
Download Presentation

Public Financial Management System (PFMS) Excel User Guide

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Salary Payment in PFMSUsing Excel Public Financial Management System(PFMS)

  2. Login With Data Operator User’s Credentials: Public Financial Management System(PFMS)

  3. Goto: Masters>Vendors>Upload Vendors Data Public Financial Management System(PFMS)

  4. Goto: Upload Vendors Data > Public Financial Management System(PFMS)

  5. After Download Template, Fill Excel Sheet (In Sheet1) With Following Instructions: For Full Instructions: Public Financial Management System(PFMS)

  6. After Filling Excel Sheet, Rename File and Upload: Public Financial Management System(PFMS)

  7. After Uploaded Successfully Status will be Shown As ‘Successfully Complete’ Public Financial Management System(PFMS)

  8. After Uploaded File Successfully. Goto:Masters>Vendors>Manage Public Financial Management System(PFMS)

  9. After Uploaded File Successfully. Goto:Masters>Vendors>Manage Public Financial Management System(PFMS)

  10. Please Note the Following Details, For Future Use: • Unique Code of Vendor, Highlighted in Below Image. (Unique Code will Use as ‘Receiving Party Code’ in Excel) • Vendor’s A/c No. or Aadhaar No. • Vendor’s Name. • Note: Bank Status should be ‘Success in Bank’ for further payment Process Public Financial Management System(PFMS)

  11. After Prepared the Vendor’s Information. Goto: Masters>Bulk Customization>Bulk Customization Using Excel Public Financial Management System(PFMS)

  12. Follow the Steps, As Highlighted in Image: Public Financial Management System(PFMS)

  13. After Download Template, Fill Excel Sheet With Following Instructions: Yellow Marked Filled Are Not Mandatory. (But If Filled, It will be Checked with Masters) Yellow Marked Filled Are Mandatory. Public Financial Management System(PFMS)

  14. Main Instructions For Excel Fields: Receiving Party Code: [Mandatory] Beneficiary Code or Vendor Code or Agency Unique Code depending upon the transaction type. [See Slide-10] Receiving Party Name: [Mandatory] It is for specifying Beneficiary Name or Vendor Name or Agency Name. Transaction Code: [Not Mandatory] It is for specifying Beneficiary Name or Vendor Name or Agency Name. Expense Type: [Mandatory for Expenditure Type Transactions] Allowed values are 'R' for Revenue and 'C' for Capital. Applicable only for 'Expenditure' type transactions. Action Type: [Mandatory for Editing of Bulk Customization] A' for Addition of Transaction, 'U' for Update and 'D' for Deletion of Transaction. Public Financial Management System(PFMS)

  15. Contd.. Main Instructions For Excel Fields: Component Code: [Mandatory if the Transaction Code is ‘GP’] Component Code to be used for crediting this amount, Applicable for Credits only i.e. Code 'GP'. How to Find Component Code.? • Login With Agency Admin • Goto MySchemes>View Scheme Component • Copy Component Code, As Highlighted in Image. Public Financial Management System(PFMS)

  16. Filled Demo Excel File: Public Financial Management System(PFMS)

  17. After Filling Excel Sheet, Rename File and Upload: Public Financial Management System(PFMS)

  18. After Uploaded Successfully Status will be Shown As ‘Successfully Complete’ Public Financial Management System(PFMS)

  19. After Uploaded Successfully.. Goto: Masters>Bulk Customization>Manage You can Modify Your Customization Here: Public Financial Management System(PFMS)

  20. After Creating Customization. Goto: Expenditures>Add New Public Financial Management System(PFMS)

  21. After Creating Customization. Goto: Expenditures>Add New Public Financial Management System(PFMS)

  22. After Click on Customization Name, Please Fill The Details: Public Financial Management System(PFMS)

  23. After Verification of Vendors’ Details. Click On ‘Process and Save’ Public Financial Management System(PFMS)

  24. After Click On ‘Process and Save’.. Record Will be Submit Successfully. Public Financial Management System(PFMS)

  25. After Submit Successfully. Login With Agency Data Approver’s Login. Goto: Fund Expenditures>Manage Bulk Fund Expenditure Public Financial Management System(PFMS)

  26. After Logged in With Agency Data Approver’s Login. This Screen Will Appear. Status will be shown as ‘Submitted’, Click on Letter No. to Approve Expenditure. Public Financial Management System(PFMS)

  27. After Logged in With Agency Data Approver’s Login. This Screen Will Appear. Click on ‘Approve’ Button to Approve Expenditure Entry. Public Financial Management System(PFMS)

  28. After Approve the Entry with Agency Data Approver. Click on ‘Print Payment Advice’ to Generate PPA For Payment. Public Financial Management System(PFMS)

  29. After Click on ‘Print Payment Advice’ PPA will Generate For Payment. Take a Print Out of PPA for Further Bank Process. Public Financial Management System(PFMS)

More Related