Synopsis

Title of Project

“ e-MagnaSoft”

Submitted By
Name	:  Quintus Jerald D’souza
Course	:  BScIT

1. Title of Project

“ Basic Accounts ”

2. Object of Project

A. Goals

• This is software for small scale industries.
• This software has a customize form to customize the company name, Logo and the content of the Home Page. This help the company to visualize as the software is as it is build for the company itself.
• Maintain Accounts even if you don’t know Accounts basics. Enter the account entry just by the knowledge whether the transaction is expense or income to the company.

B. Aim

• The main Aim of building the software is usually we see all A A+ Company have their own software to maintain the records having a lots of price, but the smaller company who cannot effort it but having a dream of having can have this software which include the basic need of the company the Account, the Home Page which they can put their name on it.

C. Details of Maintaining Accounts

• In this software the user has to find whether the transaction is expense or income to the business. He will be having 2 options Official Income and Official Expenses. In each he will be having a choice of category such as bank, purchase, sales return, etc in official expenses and bank, sales, purchase return, etc in official income. And when he selects and of these he will get the type of transactions. For example if the transaction is deposited amount in bank, he will select official income as deposit is an income. Then he will select category as bank. And in type of transaction he will have deposited, interest on bank deposit, etc where he will select deposits and further details the form explains. In this way the entry is entered in the accounts. Here the user has no difficult to find the debit and credit. It’s a simple form fill type.

3. Tools & Technology

• Front End         –          VB.Net
• Back End         –          SQL Server
• Web Page        –          HTML Language (for Help Menu)

4. Complete Structure of the Program

A. Modules Description

• File
• Customized (Maintain details of home Page)
• Employer Detail
• Stock Detail
• Stock Group Creation
• Stock Unit of Measurement Creation
• Stock Item Entry
• Dealers & Costumer Detail

• Accounting

{Note:   Select Official Income or Expenses           }

{              Select Category                                          }

{                              Select Type of transaction         }

• Office Expense
• Purchase a/c
• Sales Return a/c
• Bank a/c
• Interest on Bank Loan
• Withdrawal
• Distribution Expense a/c
• Advertisement
• Travelling Expense
• Commission Paid
• Bill
• Water bill
• Electrical bill
• Rent
• Telephone  bill
• Incurrence
• Duties & Taxes
• Land Tax
• Custom Tax
• Sales Tax
• Purchase for office use

• Office Income
• Sales a/c
• Purchase Return a/c
• Bank a/c
• Interest on Bank Deposited
• Deposited
• Rent Received
• Commission Received

• Salary Slip Payment


• View
• Profit And Loss a/c
• Stock Summary

• Date Management
• Meetings
• Important Dates

B. Backend Design

Database Name          à        QuintusProject

Table                           à        Login

Fields	Data type	Description
LoginName	char
LoginPassword	char

Table                           à        Customize

Fields	Data type	Description
CompanyName	char		Primary Key
CompanyLogo	Image
CompanyContent	Text

Table                           à        BankDetail

Fields	Data type	Description
BankName	char
BankAcc	Number		Primary Key

Table                           à        Designation

Fields	Data type	Description
DesignationType	char		Primary Key

Table                           à        Dealers

Fields	Data type	Description
DealerNo	Char		Primary Key
Name	Char
Address1	Char
Address2	Char
Telephone1	Number
Telephone2	Number
Telephone3	Number
Telephone4	Number

Table                           à        Customer

Fields	Data type	Description
CustomerNo	Char		Primary Key
Name	Char
Address1	Char
Address2	Char
Telephone1	Number
Telephone2	Number
Telephone3	Number
Telephone4	Number

Table                           à        StockGroup

Fields	Data type	Description
Under	Char		Primary Key

Table                           à        Unit

Fields	Data type	Description
UnitName	Char		Primary Key

Table                           à        Item

Fields	Data type	Description
ItemNo	Char		Primary Key
ItemName	Char
Under	Char		Foreign Key related StockGroup table
UnitName	Char		Foreign Key related Unit table
ItemPrice	Money
Warning	Number
StockRemain	Number

Table                           à        EmployerDetail

Fields	Data type	Description
EmpID	Number		Primary Key
EmpName	Char
Designation	Char		Foreign Key related Designation table
DateOfBirth	DateTime
Sex	Char
Address	Char
Telephone1	Number
Telephone2	Number
Telephone3	Number
BloodGroup	Char
Basic	Money
DA	Money
HRA	Money
TotalSalary	Money
Remark1	Char
Remark2	Char
Remark3	Char
SalesIncharge	Bit	à(for customize)

           

Table                           à        PurchaseDetail

Fields	Data type	Description
BillNo	Char
DealerName	Char
BillDealers	Char		Primary Key
Date	DateTime

Table                           à        Purchase

Fields	Data type	Description
BillDealers	Char		Foreign Key related PurchaseDetail table
Item	Char
Qty	Number
Rate	Money
Total	Money

Table                           à        SalesDetail

Fields	Data type	Description
BillNo	Char
CustomerName	Char
BillCustomer	Char		Primary Key
Date	DateTime

Table                           à        Sales

Fields	Data type	Description
BillDealers	Char		Foreign Key related SalesDetail table
Item	Char
Qty	Number
Rate	Money
Total	Money

Table                           à        Bank

Fields	Data type	Description
BankTranType	Char
BankTran	Char
BankAcc	Char		Foreign Key related BankDetails table
Amount	Money
Date	DateTime

Table                           à        Received

Fields	Data type	Description
ReceivedType	Char
ReceivedFrom	Char
BillNo	Char
Amount	Money
Date	DateTime

Table                           à        Duties

Fields	Data type	Description
DutiesType	Char
BillNo	Char
Amount	Money
Date	DateTime

Table                           à        Bill

Fields	Data type	Description
BillType	Char
BillNo	Char
Amount	Money
Date	DateTime

Table                           à        Distribution

Fields	Data type	Description
DistributionType	Char
Amount	Money
Date	DateTime

Table                           à        Meeting

Fields	Data type	Description
Date	DateTime
Time	DateTime
Note	Char
Location	Char
Priority	Char

Table                           à        Important

Fields	Data type	Description
Date	DateTime
Note	Char
Event	Char
Priority	Char

D. Input of the Program (No. of Users)

• Administrator                        -           Administrator can enter into the software only by entering appropriate User Name and Password. He has access in the whole software.
• Account Manager      -           Account Manager can enter into the software only by entering appropriate User Name and Password. He has access in the whole software but not in the customize section.
• Guest                          -           Guest can enter into the software without the Password, just by selecting guest in the user Name. He has access only to check the Stock Summary and Profit and Loss A/C sections.

E. Output of the Program

• Stock Details
• Profit and Loss
• Salary Details
• Sales Slip

F. Limitation of the Project

This software is not used for big companies

5. Future Application

Add Multiple User Diary and Photo Gallery If possible