As per office memorandum vide F. No. 3/13/2022-P& PW(F) (8353) Government of India, Ministry of Personnel, PG & Pensions Department of Pension & Pensioners' Welfare dated 11.10.2022,it was directed for strict compliance in order to maintain the yearly total accumulation of subscriptions in GPF (General Provident Fund) in such a way that the total yearly subscription amount along with all arear subscriptions in a financial year ,should not exceed the limit of rupees five lakh ,at present which is the threshold limit. So, since this time, the necessity of checking the yearly sum of total subscription for each GPF subscriber is urgently needed, before the end of each financial year, so that the accumulation of total subscription may not exceed ceiling limit. The request of subscription change is incorporated in MS-Excel file for each applicant, maintained throughout the whole year ,as per applications received and the csv file mode of which, later-on is analysed by python-AI to check ceiling limit on that platform .This is one part of analysis with the help of python code on the google collaborator platform to sort and adjust the amount of subscription accordingly so that the total amount of subscription in every financial year can be adjusted to satisfy the ceiling limit restriction. Apart from this, i.e. the compliance of ceiling restriction, this paper is also based on another application in MS Excel software to check and compare yearly cumulative balance in General Provident Fund (GPF) after each withdrawal in any financial year for any GPF subscriber when applies for withdrawal from GPF account. Application in MS-Excel, to prepare approval format of claim with the help of MS-Excel formula along with checking and comparison of GPF balance in a financial year using MS-Excel formula as well as using python collaborator platform to check GPF ceiling limit, GPF total withdrawal and total balance for a financial year, all of these applications help to run smoothly, the procedural work for General Provident Fund, with minimum effort to get output with maximum accuracy.
Article DOI: 10.62823/IJGRIT/3.1(II).7313