Assignment 3

  

Assignment 3              (Ledger Creation with opening Balance}

 

Q. 1 Create a new company Swastik- Your Name- A3" (e.g., Swastik-Shilpa-A3) & create the required ledgers from the below mentioned Trial Balance.

Particulars	For 31-03.2020
	Opening balance
	Debit	Credit
Share capital		322000.00
General Reserve		80000.00
Vehicle	90500.00
Machinery	112000.00
Cash	16200.00
Petty Cash	1000.00
Loan from Anil		16500.00
Loan from HDFC		115000.00
Furniture	110000.00
Corporation Bank (A/C No. -257896452013458)	240000.00
Outstanding Electricity Bill		20600.00
Prepaid Rent	3500.00
Investment at IDBI	7800.00
Drawing	12000.00
Computer	25200.00
Profit & Loss A/C		64100.00
Grand Total	618200.00	618200.00

 

Q. 2 Now create another ledger as Provision for Depreciation with opening balance 9500.

Q. 3 Change the ledger 'Machinery' as 'Plant & Machinery' and 'Furniture' as 'Furniture & Fixture'.

Q. 4 Now delete the ledger 'Provision for Depreciation'

Q. 5 Now change the opening balance of Plant & Machinery as 111000 and investment as 8800.

Q. 6 Check the Trial Balance and Balance Sheet.

Q. 7 Take back up of your company in "D:\ Your Name with last 4 digit of mobile no.".

Assignment 3.1              (Ledger Creation with opening Balance)

 

Q. 1 Create a new company Swastik- Your Name- A3.1" (e.g., Swastik-Shilpa-A3) & create the required ledgers from the below mentioned Trial Balance.

Sl.no	Ledger Name	Ledger Group	Debit Amount	Credit Amount
1	Capital	Capital account		1000000
2	General Reserve	Reserve & surplus		50000
3	Capital Reserve	Reserve &surplus		30000
4	Profit & loss	Primary		46000
5	Loan from HDFC	Secured loan		1800000
6	Sbi (o/d)	Bank o/d		25000
7	Signus InfoTech	Sundry creditor		30000
8	Anirban pvt ltd	Sundry creditor		32000
9	O/S AMC charge	Outstanding exp		25000
10	O/S rent	Outstanding exp		12000
11	Furniture	Fixed assets	1500000
12	Computer	Fixed Assets	135000
13	Machinery	Fixed Assets	1000000
14	Nsc	Investment	75000
15	Adv salary	Loan & Advance	5000
16	Roy InfoTech	Sundry Debtor	38000
17	Globe infosys	Sundry Debtor	32000
18	Cash	Cash in hand	35000
19	State bank of India	Bank account	230000

    

Balance sheet 3050000

These ledger are already created just alter and put the opening amount

Signus InfoTech		30000
Date	Name	C.days	Amount	Dr/Cr
1/4/2013	Sg/101	15	12000	cr
1/8/2014	Sg/102	15	18000	cr

Anirban pvt ltd		32000
Date	Name	C.days	Amount	Dr/Cr
1/9/2013	Ar/202	15	17000	cr
1/1/2014	Ar/208	15	15000	cr

 

Roy info tech		38000
Date	Name	C.days	Amount	Dr/Cr
1/9/2013	Rt/121	15	18000	Dr
1/1/2014	Rt/122	15	12000	Dr
	On Account		8000	Dr

 

Globe infosys		32000
Date	Name	C.days	Amount	Dr/Cr
1/9/2013	Gl/001	15	12000	Dr
1/1/2014	Gl/002	15	19000	Dr
	On Account		1000	Dr

Session 3:- Voucher entry: Pass journal entry

 

GOT à Voucher → Payment mode (Press F5)

 

1. paid outstanding Amc charge Rs25000 on 1.4.2013 from sbi chq no100001
2. paid outstanding rent Rs12000 on 1.4.2013 from sbi chq no100002
3. company clear the due of signus info tech of rs 20000 from sbi chq(100003)on 1.4.2013 against the bill no sg/101 and sg/102
4. payment made for advertisement of Rs 5000 to Arnab publisher on 1.4.2013
5. purchase furniture for cash 5000 on 1.4.2013
6. paid rent rs 5000 for sbi chque (ch no:4209211) on 1/4/2013

 

GOT à Voucher → receipts mode (Press F6)

 

1. received Rs 31000 from Globe infosys against their pending bills by an uti cheqe and deposited into SBI Bank on the same day (chq no: 123456 ,date 2/4/2013)
2. Received a cheque of Rs 30000 (chq no654321) on 2/4/2013) of Allahabad bank from Roy info tech against their pending bills and deposited into SBI Bank on the same day.
3. NSC matured and get a cheque of Rs 100000(ch no:234564) on 2/4/2013 and deposited into company bank account (SBI)
4. a loan of Rs 200000 is taken from kunal (uti bank chq no:256891 date 2/4/2013) and deposited into SBI bank .
5. Received 5000 from ram info tech for cash on 2/4/2013.

 

GOT à Voucher → Contra mode (Press F4)

 

1. withdrawn cash Rs 15000 from sbi bank on 1/5/2013
2. Deposited 5000 to SBI bank on 1/5/2013
3. Cash Rs 4000 transferred to petty cash account on 1/5/2013.
4. cash Transfer from SBI bank to HDFC bank Rs 10000 on 1/5 /2013

 

GOT à Voucher → Journal mode (Press F7)

 

1. Adjust the advance salary Rs 5000 with current salary on 2/5/2013.
2. Purchase furniture worth of Rs 10000 from Durian furniture on 2/5/2013.
3. purchase Two Pcs computer from national electronics Rs 30000 on 2/5/2013

Assignment 3.2   

Q. 1 Create a new company Swastik- Your Name- A3.2" (e.g., Swastik-Shilpa-A3)

SN Transaction	Amount
1 Started Business with cash	2,50,000/-
2 Deposit Cash in to HDFC Bank	50,000/-
3 Purchased Good From Ajay Distributors, Noida on Credit	35,000/-
4 Bought Furniture for office use by cheque	25,000/-
5 Sold Goods in cash to Gopal	10,000/-
6 Paid Carriage in cash	12,000/-
7 Paid to Ajay Distributor by cheque	25,000/-
8 Sold Goods To Deepak on Credit	15,000/-
9 Purchased Computer From Royal Computers	25,000/-
10 Received cheque from Deepak	15,000/-
11 Paid to Royal Computer in cash	25,000/-
12 Paid Electricity Charges by cheque	2,200/-

Assignment 3.3  

Q. 1 Create a new company Swastik- Your Name- A3.3" (e.g., Swastik-Shilpa-A3)

SN Transaction	Amount
1 Mr. Rohit Started Business by bringing cash.	5,00,000/-
2Deposit Cash in to Axis Bank by opening a new Account.	1,50,000/-
3 Purchased Good From Ajay Distributors, Noida on Credit.	1,35,000/-
4 Bought Furniture for office use by cheque	40,000/-
5 Sold Goods in cash to Vijay	20,000/-
6Paid Transport Charge in cash	12,000/-
7 Paid to Ajay Distributor by cheque	50,000/-
8 Sold Goods To Harry on Credit	25,000/-
9 Purchased Computer From Laxmi Computers by cash	25,000/-
10 Received cheque from Harrry	25,000/-
11 Paid to Ajay Distributor by cheque	85,000/-
12 Withdraw of cash for personal use	2,000/-