Accounting and Account Management

Earlier the office authorities were using log books as well as registers to maintain cash records. To get rid of this the TS v1 software was designed.

The main interface consisted of options like account creation, submission, loan sanction, loan installment payment, searching all types of information, viewing the transactions carried out in the software, viewing the statement of an account or loan and an option to back up the database.

The PR Account section consists of new account creation, account info modification and account deletion. At the time of creating the new PR account, details such as the name of the area, district, place, post office, police station and division are also to be entered. Modification of the PR account details are possible by entering the PR account number. But the PR account number cannot be modified so in case of some error in the PR account number the PR account is to be deleted first and then a new PR account has to be created.

The Submission section consists of new submission, modifying submission and deletion of submission. The submission is made against the existing PR accounts in the database. Each submission is made unique by entering a specific voucher number. Then this submission information is saved in the database as a unique record of the PR account. Modification of the submission is possible by entering the unique voucher number. Similarly the submission delete option also works by entering the unique voucher number.

The Loan section consists of new loan account creation, loan account info modification and loan account deletion. At the time of creating the new loan account, details such as the name of the person, loan amount, and interest rate, loan period in months or year, number of payments per year, starting date of loan, scheduled payment and scheduled number of payments are also to be entered. Modification of the loan account details are possible by entering the loan account number. Similar to the PR account the loan account number cannot be modified so in case of some error in the loan account number the loan account is to be deleted first and then a new loan account has to be created.

The Installment section consists of new installment, modifying installment and deletion of installment. The installment is made against the existing loan accounts in the database. Each installment is made unique by entering a specific payment number. Then this installment information is saved in the database as a unique record of the loan account number. Modification of the installment is possible by entering the unique payment number. Similarly the installment delete option also works by entering the unique payment number.

The search section consists of search options based on account number, voucher number, and payment number. Account number of both PR Account as well as Loan Account are accepted. The payment number of loan installment and the voucher number of PR account submission.

The Transactions option provides viewing of all transactions based on PR account created, PR account modified, PR account deleted, PR account submission created, Pathian ram account submission modified, PR account submission deleted, Loan account created, Loan account modified, Loan account deleted, Loan account closed, Loan account installment created, Loan account installment modified, Loan account installment deleted, Loan account installment (s) cleared and Scheduled backup

In the Statement section we can view both PR Account statement as well as Loan Account statement of the given date range.

In the System section there are utilities like calculator and notepad. It provides an option for Logout and Exit. It also consists of the about section where software’s development details as well as developer details are available.

Add caption

Bank-Transaction-Monitoring-System

Introduction:
A software which could help the monitoring of Company Accounts is the need of time. The fund transfer between different fixed/current/savings accounts was to be monitored. The main aim of this project is to keep record of Fixed Deposit, Savings Account, and Current Account and to provide maturity alert for fixed deposits and details about current status of all accounts. The software is having the specialty to alert the authority about the maturing Fixed Deposit in 7 days, 30 days, and 90 days. By using this software the accountant of the Company Ltd. reduces paper work and efficiently does his job. The project is done by Visual Studio 2008 and Microsoft Access 2003 and we used OLEDB for creating connections between Visual Studio 2008 and MS Access. The developers involved in this project were Subhajit Debnath, Sampa Deb and Ankita Saha.
 
Objectives were:
1) Development of a software which could help the monitoring of Company fund. Monitor the fund transfer between different fixed/current/savings accounts. Keep a track of different kinds of bank transactions. A system to provide alert, week(s) before the maturity of fixed deposit. Keep all the details of fixed deposit, current account and savings account for any future reference.
2) It is a time saving operation as there is no need for going through the old records in order to find out the maturity dates of the fixed deposits. Rather looking at the maturity alert the organization gets time to decide as to where the money is to be reinvested.
3) The software also keeps all transaction records for the savings accounts and the current accounts. So there is no need for any other documentation for the transaction records. When fund transfer takes place from any current/savings account to any fixed deposit then all the records are updated at the same time i.e., debit from current/savings and credit to fixed deposit. This helps in saving time and reducing paper work as well as less human effort.
4) Modernization of office works: shifting from old office paper work documentation to computerized data entry and monitoring system leading to overall development employees.

Advantage of the Proposed System:
1) It helps in quick access of account information. Account information can be accessed by the application instead of going through all paper records.
2) It helps in choosing database from anywhere in the computer system. In case the database is not found during startup then the administrator can select the database from previous backup location and selected database is then used in this system
3) Keeps the backup of original database. It helps administrator to keep backup of original database in any desired location.
4) Secured system: Only authenticate user can access the application after valid login.

Given below are the screenshots of the software:

Credit record in current account

Credit record in savings account

Current status of different accounts in different banks

New fixed deposit record

Transactions carried out in a particular period

Home page with alerts on the top right corner

LOGIN SCREEN

Code is available in GitHub

PC Info v1

The PC Info Software is helpful for us to know some system details of the PC. The code behind file contains few function written in VB to retrieve those information. This information’s can be used as authentication validation on a machine. I have prepared this with the intention of adding it to any software which requires machine authentication as a security feature. I am ready to share it with anyone who needs this feature/code.

The information that are fetched by the machine are

1. Computer Name
2. User Name
3. Operating System
4. Platform
5. Version
6. Language
7. Processor ID
8. MAC Address
9. HDD Volume Serial
10. MotherBoard ID

Given below are the screen shots of Its working:

Start Up Page

Info shown after Find Info Button Click