Keeping track of all the cash transactions of a state is a herculean task. To facilitate the government in keeping a constant eye on its cash position we built an application called the Cash Management System (CMS). Cash Management System (CMS) is a consolidated application that showcases the complete cash flow within the state.
CMS integrates the data received by RBI to present the cash position to that day. CMS also provides information regarding the percentage of expenditure that may be controlled from the dashboard itself, along with approval and reject functionalities of each and every cheque/bill that can be controlled.
The government of Andhra Pradesh faced many problems in verifying its cash position with the help of its old manual system as the government has many systems that work independently within the finance section. Thousands of government cash transactions happen on a daily basis. the verification was done completely manually, laboring in multiple excel sheets in order to form an estimate every time an analysis was needed.
This led to many issues such as:
• Interlinking between existing system not present – this leads to a difference in figures as the formats and structures between each system may vary drastically.
• RBI data is provided every day to each state with regards to their clearance memo. This information is received through email and is processed regularly to observe any kind of analysis with regards to the system indicated balances and the actual state finances. This is done manually and the information is understood by very few individuals.
• During times of financial crisis, it is very important to understand how much expenditure is to be met in the near future so that the state financial heads may make strategized decisions on where to expend the states revenue. These estimates are extremely difficult to produce manually on a frequent basis.
CMS was implemented for the Government of Andhra Pradesh by integrating their internal systems together and presenting the data into a collective dashboard. The first step towards this process was to ensure that data is transferred securely between all the systems to be integrated. Different kinds of systems use different methodologies for accessing their data. With regards to the systems that were to be integrated, some were provided secure services, while others were accessed with different specific methods.
The structure and design of any system varies from another, hence each system was studied before a solution was devised. With regards to CMS being implemented in other states, the same strategy would be implied. So irrespective of the number and type of internal systems present within the state, integration with all of them can be formed. Once connections were established, the approval/reject functionality was built. This ensured that once a transaction is approved/rejected from CMS, the same is done within the internal system that it actually belongs to.
Once the states cash inflow and outflow were produced, integration with RBI was done as well. The data provided by RBI would be done so in a secure SFTP method. Once the data reached the government’s server, it would be read and decoded automatically. Once the dashboard was built, the android and IOS applications were also developed so that the secretaries may access the financial position of the state on the go. The applications were loaded onto their phones individually so as to ensure secure connectivity. The mobile apps are also used for approving/rejecting any transaction available within the dashboard.