• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. 6
  7. 7
  8. 8
  9. 9
  10. 10
  11. 11
  12. 12
  13. 13
  14. 14
  15. 15
  16. 16
  17. 17
  18. 18
  19. 19
  20. 20
  21. 21
  22. 22
  23. 23
  24. 24
  25. 25
  26. 26
  27. 27
  28. 28
  29. 29
  • Level: GCSE
  • Subject: ICT
  • Word count: 2520

Billing System

Extracts from this document...


USER SPECIFICATION INTRODUCTION Mr. Atchuthan Narayanan, Mr. Thamotharan Atchuthan and Mr. Ramesh Atchuthan are the partners in a firm called "VEEYEN MILLS". This mill is situated in Grandpass. This mill was opened on the 6th of February in the year 1984. This mill is dealing in oils such as Coconut oil, Sesame oil and Pulses, which was manufactured in the mill itself. This mill also mills flour such as Kurakan flour, Orid flour and Rice flour. This mill has various machines, it takes 85-horse power to run these machines. EXISTING SYSTEM The existing system, the accountant writes down the sales of goods roughly on A4 papers. At the end of the day the accountant writes down the sales of goods on three accounts books and he calculates the profit and the loss of the day, he does this every day. This is a very long process because he had to write the sales of goods in three accounting books, therefore it consumes a long time to finish the calculating and balancing. DISADVANTAGES OF EXISTING SYSTEM Presently the way of calculating the profit is done manually. This done by using calculators. This leads to some disadvantages. They are as follows: Human Errors:- This is a common disadvantage, where they misplace the A4 papers which contain the record of sales of goods and also sometimes the accounts books. ...read more.


It needs a Main Memory of 16MB Ram and a monitor. These are the 1minimum requirements needed for to run Microsoft Excel. Minimum requirements needed by Microsoft Excel MB Hard Disk space 1.21GB MB Ram 16 MB Clock Speed 65 KHz Intel 486 MMX Monitor 16 Colors DATA CAPTURE I captured the relevant data in 3 main ways. They are as follows. 1) Going through the past Accounting books and Backup files. 2) Questioning the Accountant. Going through the past Accounting books and Backup files The accounting books contain details on the goods sold. These details are like the invoice number, quantity of the product sold and the grand total. The backup file contains an overall description of the goods sold for a day. The overall description contains informations like the invoice numbers of a day and grand totals of each invoice. When I went through the accounting books. I found out that there were a lot of details missing. I suppose that they must be omitted because the quantity bought should have be less than two. Hence this gave a false record in the backup file. An invoice of the firm VEEYEN MILLS. Questioning the Accountant I asked the accountant some questions on the Invoicing System. A few important questions are: 1) How is your firm's invoicing system? ...read more.


.LineStyle = xlContinuous .Weight = xlThin .ColorIndex = xlAutomatic End With With Selection.Borders(xlEdgeTop) .LineStyle = xlContinuous .Weight = xlThin .ColorIndex = xlAutomatic End With With Selection.Borders(xlEdgeBottom) .LineStyle = xlContinuous .Weight = xlThin .ColorIndex = xlAutomatic End With With Selection.Borders(xlEdgeRight) .LineStyle = xlContinuous .Weight = xlThin .ColorIndex = xlAutomatic End With With Selection.Borders(xlInsideVertical) .LineStyle = xlContinuous .Weight = xlThin .ColorIndex = xlAutomatic End With With Selection.Borders(xlInsideHorizontal) .LineStyle = xlContinuous .Weight = xlThin .ColorIndex = xlAutomatic End With ActiveCell.Select End Sub The Marco To Go To Invoice Sub viewInvoice() Sheets("Invoice").Select End Sub The Marco To Go To Codes Section Sub viewcodes() Sheets("codes").Select End Sub The Marco To Go To Backup Section Sub viewbackup() Sheets("Backup").Select End Sub The Marco To Return To Main Menu From The Invoice Sub intomm() Sheets("Main Menu").Select End Sub The Marco To Return To Main Menu From The Codes Section Sub cotomm() Sheets("Main Menu").Select End Sub The Marco To Main Menu Form The Backup Section Sub butomm() Sheets("Main Menu").Select End Sub EVALUATION OF MAN/MACHINE INTERFACE This system is 100% efficiency, easy and helps any user who has a little knowledge on computer or to the ones who don't have any thing at all. I say it because I have created a main menu which guides the user to go to the invoice, to the codes section and to the backup section. This is done by macros. Hence this saves time when doing the billing system on a computer using excel other than writing on bill books and accounts books ?? ?? ?? ?? ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our GCSE ICT Systems and Application section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related GCSE ICT Systems and Application essays

  1. Computerised accounting

    for their customers as the computerised accounting system can hold the same amount as hundreds of filing cabinets.

  2. Creating a computer system for a video rental shop

    Security Security is provided by making sure there are safeguards to ensure that data is not accidentally or maliciously corrupted. Passwords The system will have a password, which prevents the user from changing the design or appearance of forms. All the user will be able to do is enter the appropriate information in the right sections.

  1. Creating a computer system.

    and when they click the OK button, their details will be copied into the invoice. The designer will also need a form to add a product to invoice. On this form the customer will choose a product from a drop down list, and then click the quantity that he/she want.

  2. Producing documents for a company. Spreadsheet, Invoice and Website.

    * Posters (A3 or Bigger) The primary way to present the output will be the Monitors. This will be used by employees and customers. The secondary way to present the output will be the A4 paper. This will be used for the invoice.

  1. System requirements analysis

    This will be imported from the (.txt format based) software to the excel sheet by the name of 'patients. \ This screen shot is of the (.txt based) database. It is imported to the excel spreadsheet via the process of importing data. The patients page is a form of input and output.

  2. Benefits of using my IT system in the Travel Agents.

    After that I am going to click on Subscription Start/End. Finally I will click on input mask and type in (00/00/0000;0;). The process for using formats worked really well. The only change should be that it would be easier if there was screenshots or images.

  1. I.T. System for a Newsagents

    What do you now anything about computers, do you have any knowledge? A) Yes I know how to work on the Microsoft word processor and the Internet. 6) Would any of your business partners have trouble using the computer, and are they all familiar with Microsoft excel?

  2. ICT Job Applications - Enricé's Tapas Bar.

    The data source is a database stored in MS Access, which I can select certain parts of the applicant's data and mail merge it onto the following letters: * Interview * Success * Rejection * Rejection but hold In order to mail merge certain bits of data successfully on each

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work