Budget analysis ASP.NET project is a useful web application that helps all sorts of business firms. The main strategy of the project is to automate the excel data and calculations into RDBMS to make data retrieval and manipulations easier. The application is done using ASP.Net and we have used SQL Server as the back end to make it more powerful.
The application is build kept in mind that many users will find to use it friendlier. We just need to upload the excel file into the application through the friendly user interface provided and the application will parse the excel file into the database for calculations and manipulations.
The users are also given the facility to create a new project by themselves which helps them to handle the excel applications into the database more friendly. The present system is a windows application, in which users can upload data only to that system.
Here the user must enter the rate, quantity, and sales result at each time when the transaction occurs. It is a web application in which users can upload excel file which contains the transaction details. The user can store the details under a project category which helps them to identify daily data. The user can upload the excel file from anywhere at any time. The user can view summary reports of each project between two dates, monthly and yearly report.
In future enhancement, the users can upload only excel file into the DB for calculating profit and loss of products. In future, we can use the facility to upload CSV or XML file into the database for calculation.
Finally concluding, Budget Analysis is an online project that allows the users to calculate profit and loss of products sold and do its analysis. For this, excel based analyzer is created. If the users are provided with the excel files, they can calculate the profit and loss from anywhere in the world and thus a lot of time can be saved. The users are provided with company’s excel files which are stored in administrator’s database.