📖 generic · CBSE Class 11 English medium · ACCOUNTANCY · Page 44question

the basis of creating collection of data items on which these functions are · Part 4

Chapter 14: Structuring Database for Accounting · ACCOUNTANCY

711003 Rent Account 711005 Insurance Premium 711006 Discount Account 811001 Sales Account Show how will these transactions appear as accounting data in following vouchers table. Vno : Identity of a transaction stored through a voucher. Vdate : to date of transaction Debit : to code of account being debited Amount : Amount of transaction Credit : Code of account being credited Narration : Narration of transaction. (iii) M/s Soumya Exports set up a garments export business on March1, .

Their transactions for the month ending March , are given below : March Capital brought in cash by proprietor, Rs. , , , out of which deposited into a bank account Rs. , , Received Cheque for Rs. , from Kailash Nath & Co.

as advance account Issued Cheque for Rs. , to Jackson Bros. as advance for supplies Payment of rent for the month Rs. , Purchased Computer system for office use Rs.

, , payment for which made by Cheque Goods purchased Rs. , , , payment made by Cheque. Goods purchased from Jackson and Bros. for Rs.

, Goods sold to Rajeshwar & Sons Rs. , Purchased Furniture for office use Rs. , Paid fire insurance premium by Cheque Rs. , Paid Cash To Jackson Bros.

Rs. , in full settlement of their outstanding balance of Rs. , Payment of salary to staff Rs. , All these transactions have been stored in database tables as shown below under (Model-I of database design).

Data in Accounts table appears as follows: Accounts Code Name 110001 Capital Account 221019 Jackson Bros. 411001 Furniture Account 413001 Office Equipment 621001 Kailash Nath & Co 621002 Rajeshwar & Sons 631001 Cash Account 632001 Bank Account 641001 Salary in Advance Account 711001 Cartage Account 711002 Salaries Account 711003 Rent Account 711005 Insurance Premium 711006 Discount Account 811001 Sales Account Show how will these transactions appear as accounting data in following accounting data tables. Vno : Identity of a transaction stored through a voucher Vdate : date of transaction : code of account being debited or credited Code : Codes of accounts being credited or debited, depending on

Related topics

Have a question about this topic?

Get an AI answer grounded in your actual textbook — with the exact page reference.

Ask AI about this topic →