Integrated Accounting System
Disclaimer: This work has been submitted by a student. This is not an example of the work written by our professional academic writers. You can view samples of our professional work here.
Any opinions, findings, conclusions or recommendations expressed in this material are those of the authors and do not necessarily reflect the views of UK Essays.
Published: Mon, 5 Dec 2016
Term Paper of DBMS on Integrated Accounting System
Relational Model table
Integrated Accounting System: – Integrated accounting system is application software or a system of accounting where the cost and financial accounts are kept in the same set of books. It avoids the need for separate set of books for financial and costing purposes. Able to provides or meets the information requirement for costing plus financial accounts.
Need of integrated accounting system: – Before integrated accounting system was made; non-integrated accounting systems or also known as interlocking systems were used. Then why the need of integrated accounting system arrived? First of all an interlocking system is defined as when a business keeps its cost accounts separate from the financial accounts such system is called interlocking accounts
Now in interlocking or non-integrated systems as there were to maintain two different financial books so it created a lot of confusion which also lead to error in records.
Basically, in an integrated accounting system, the financial and cost transactions are recorded in an integrated ledger which is self balancing. The advantages are as follows:
1. It saves the clerical work because only one set of account is needed to keep the records.
2. No need to reconcile financial and cost profits;
3. No confusion arises from different stock valuations, method of depreciation and profits
4. It lessens the probability of error because recording takes place in one set of accounts and
Information produced on an integrated system is quicker, thus helping management in decision making.
Requirement of an Integrated Accounting System: –
ü Top management needs to decide the extend of integration of the two set of books to integrate until the stage of primary cost or factory cost or full integration
ü A suitable coding system must be developed to serve the purposes of both financial and cost accounting
ü An agreed routine, with regard to the treatment of provision for accruals, prepaid expenses, other adjustments necessary for the preparation of interim accounts
ü Proper coordination should exist between the staff responsible for the financial and cost aspect of the accounts
Modules of an Integrated Accounting System: –
* Interactive input vendor invoices
* Credit and debit memos
* Check reconciliation
* Open item or balance forward
* Cash receipts register
* Supplier of product
E-R diagram: –
Below E-R diagram is the basic structure which is including the core modules. Further the core modules have a lot of processes which are to be completed. In an E-R diagram there is relation between entities. An entity is denoted by a rectangle. Relationship is denoted by a diamond. Property of an entity is called its attributes and these are denoted by an ellipse.
Entities: – 1. Suppliers
1. Vendor Invoices
2. Credit & debit memos
4. Cash receipts
1. Amounts Payable
2. Amounts Receivable
Tabular form showing integrated accounting system: –
Amount receivable (in rs.)
Amount payable (in rs.)
Big chill ad agency
Goel cables wires
Relational Model table:-
The Relational Model uses the concept of a relation using a table rather than a graph or shapes. The information is put into a grid like structure that consists of columns running up and down and rows that run from left to right, this is where information can be categorized and sorted.
The main significance of the relational model is the absolute separation of the logical view and the physical view of the data. The physical view in relational model is implementation dependent and cannot be further defined.
v The different relational tables for integrated accounting system are:-
Table for Sales: –
Above is the -1 which is describing that the values are being are inserted in the table named “Sales”. The query used for this is called insert query. The syntax for insert is: –