Project Domain / Category
You are required to develop an accounting system for “AEN Traders”. In this system, business
accounts will be managed. This system will help in managing financial transactions for a small
business. It will save huge time and present clear status of the profit and loss. Moreover, it will help
in accurate decision making and forecasting.
Following are the users of this system. Each user has to log-in first, to use the system.
1. Manager Accounts
Responsibilities and functions of each user are given below:
Manager account can add, delete and update anything in the system.
Accountant only can enter data.
Detail of the system
Student will be given an excel sheet that contains complete accounts that are need to developed.
These accounts will help to make a financial system. All accounts (excel sheet contain all required
formula) you are required to develop these accounts accordingly. Sheet name will be form name in
You are required to generate following reports and integrate in the system as well.
1. Trial Balance
2. Debtor and creditor report
3. Sale report
4. Purchase report
5. Cash and bank report
Excel sheet link: https://drive.google.com/file/d/1j2hlgCzl5J0FJVL2jT2rwt5I6OmQfm5/view?usp=sharing