Practice Assignment

 

ASSIGNMENT

 

Session 01: Ledger Creation

GATEWAY OF TALLYðCREATE ð LEDGER

Create the following ledgers and assign opening balance

F11 features to maintain bill wise details for debtors & creditors turn the option

Maintain bill wise details :Yes

 

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

View the report (from gateway of tally)

Display more reports →Statement of Accounts→ Outstanding→<Receivables or Payables>

 

Session 2: Inventory Creation

Stock Group Creation:-

Gateway of tally → Create → Stock Group

 

Name

Under

CDMA

Primary

GSM

Primary

 

Stock Category Creation:-

Gateway of tally → Create→ Stock Categories

 

Name

Under

Nokia

Primary

Tata indicom

Primary

Motorola

Primary

G phone

primary

 

Godown creation

Gateway of tally → Create →Godown

 

Name

Under

Kolkata

Primary

Howrah

primary

 

Unit of measure Creation:-

Gateway of tally → Create → Unit

Type

Symbol

Formal

Dec

Simple

Pcs

Pieces

0

Simple

Pks

Packets

3

Simple

Bxs

Boxes

3

 


Stock item Creation:-

 

Gateway of tally →Create → Stock items

Item name

Group

Category

Quantity

Rate

Value

Nokia N70

Gsm

Nokia

7

14500

101500

Godown name

Quantity

Rate

Per

Amount

 

Kolkata

4

14500

Pcs

58000

 

Howrah

3

14500

Pcs

43500

 

 

Item name

Group

Category

Quantity

Rate

Value

Tata c168

Cdma

Tata indicom

11

1400

15400

Godown name

Quantity

Rate

Per

Amount

 

Kolkata

6

1400

Pcs

84000

 

Howrah

5

1400

Pcs

7000

 

 

Item name

Group

Category

Quantity

Rate

Value

Nokia E60

Gsm

Nokia

5

28000

140000

Godown name

Quantity

Rate

Per

Amount

 

Kolkata

3

28000

Pcs

84000

 

Howrah

2

28000

Pcs

56000

 

 

Item name

Group

Category

Quantity

Rate

Value

Nokia 6600

Gsm

Nokia

5

7000

35000

Godown name

Quantity

Rate

Per

Amount

 

Kolkata

3

7000

Pcs

21000

 

Howrah

2

7000

Pcs

14000

 

 

Item name

Group

Category

Quantity

Rate

Value

Nokia N72

Gsm

Nokia

4

14950

59800

Godown name

Quantity

Rate

Per

Amount

 

Kolkata

2

14950

Pcs

29900

 

Howrah

2

14950

Pcs

29900

 

 

Item name

Group

Category

Quantity

Rate

Value

Tata 1255

Cdma

Tata indicom

10

1900

19000

Godown name

Quantity

Rate

Per

Amount

 

Kolkata

5

1900

Pcs

9500

 

Howrah

5

1900

Pcs

9500

 

 

Item name

Group

Category

Quantity

Rate

Value

Moto1255

Gsm

Motorola

10

10000

100000

Godown name

Quantity

Rate

Per

Amount

 

Kolkata

6

10000

Pcs

60000

 

Howrah

4

10000

Pcs

40000

 

 


 

Item name

Group

Category

Quantity

Rate

Value

Moto 75

Gsm

Motorola

6

4000

24000

Godown name

Quantity

Rate

Per

Amount

 

Kolkata

3

4000

Pcs

12000

 

Howrah

3

4000

Pcs

12000

 

 

Item name

Group

Category

Quantity

Rate

Value

G4070

Gsm

G phone

8

2000

16000

Godown name

Quantity

Rate

Per

Amount

 

Kolkata

4

2000

Pcs

8000

 

Howrah

4

2000

Pcs

8000

 

 

Item name

Group

Category

Quantity

Rate

Value

G9920

Gsm

Gphone

5

5000

25000

Godown name

Quantity

Rate

Per

Amount

 

Kolkata

2

5000

Pcs

10000

 

Howrah

3

5000

Pcs

15000

 

 

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

 

Session 4: Cost center and cost categories

 

Go to company features (F11) → Activate the following option:

a)     Enable cost center →yes

 

Create the following cost categories

 

GOT → create → cost categories

 

Categories name

Revenue items

Non- Revenue item

Phone no

Yes

No

Agent

Yes

No

Advertisement

Yes

No

Printing & stationery

Yes

No

 

GOT → create → cost center

 

Category

Center name

Under

Phone no

2289-0043

Primary

Phone no

2289-4477

Primary

Agent

Vinay

Primary

Agent

Soumen

Primary

Advertisement

News paper

Primary

Advertisement

TV

Primary

Advertisement

Banner

Primary

Advertisement

Poster

Primary

Printing & stationery

Paper

Primary

Printing & stationery

Stapler & pin

primary

 


Voucher entry

  1. paid a consolidate telephone bill of rs 2500 on 31/5/2013 (Rs 1500 for 2289-43 and of Rs 1000 for 2289-4477) by cheque no 100004 of SBI.
  2. Paid agent commission of Rs 3500 on 31/5/2013 (Rs 2500 for vinay and rs 1000 for soumen).
  3. paid 20000 to ram for advertisement ( 6000 for TV 3000 for news paper 6000 for banner  and 5000 for poster)
  4. Paid a Rest of 2000 for printing & stationery (1500 for paper and 500 stapler & pin).

 

Session 5: Purchase Entries

 

Create the following ledgers:-

 Gateway of tally → create → ledger

Ledger name

Under group

Inventory value are affected

Purchase

Purchase account

Yes

Purchase return

Purchase account

Yes

Sales

Sales account

Yes

Sales return

Sales account

yes

 

Purchase order entry

To pass the entry without rate activate the following options:

GOT à Alter à voucher type à select (Purchase order)

Activate this voucher : yes

Allow zero valued transactions : yes

 

GOT à Vouchers→ Purchase order (Press Ctrl + F9)

 

  1. place an order for 4 Pcs Nokia 6600 and 3 Pcs  Tata C 168 to Signus info tech.(order no:- ord/sit/01 Dt. 2/7/2013)
  2. place an order signus info tech 3 Pcs Tata 1255 and 2 Pcs Nokia N72 (order no. ord/sit/02 Dt 2.7.2013)
  3. place an order for 4 Pcs Nokia N70 to Signus info tech (order no ord/sit/03 Dt.2.7.2013)

 

Display more reports→ inventory books→ Stock item

Display more reports →inventory books → Group Summary

 

Purchase challan entry

GOT à Alter à voucher type à select (Receipt note)

Activate this voucher : yes

Allow zero valued transactions : yes

 

GOT à Vouchers→ Receipt note (Press Alt + F9)

 

  1. Received the challan from Signus info tech (ch no: ch/sit/01 Dt.31/7/2013) against the order (order no ord/sit/01) for 4 Pcs Nokia 6600 and Pcs Tata C168 at kolkata godown.
  2. Received another challan from Signus info tech (ch no ch/sit/02 Dt. 31/7/2013) against the order (ord no ord/sit/02 and ord/sit/03) of 3 pcs Tata 1255 and 2 pcs Nokia N72 4 pcs Nokia N70 at Howrah godown.
  3. Received a challan (ch/tat/01) from Tata India pvt ltd of 5 pcs Tata 3018 at Howrah godown on 31/7/2013.

 

Rejection entry

GOT à Alter à voucher type à select (Rejection Out)

Activate this voucher : yes

Allow zero valued transactions : yes

 

GOT à Vouchers→ Rejection Out (Press ctrl + F5)

 

1.     2 pcs Tata C168 return to signus info tech against challan no ch/sit/01 on 1.8.2013 from kolkata godown.

 

Purchase bill entry

 

GOTà vouchers →Purchase (press F9)

 

1.     received a bill from signus info tech against all previous challans( ch/sit/01, ch/sit/02) with 4 pcs Nokia 6600@7000 ,4 pcs Tata C168 @1400 , 3 pcs Tata 1255@3000 , 2 pcs Nokia N72 @155000, 4 pcs nokia N70@ 15000 (bill no bl/shi/01 Dt 2/8/2013)

2.     received a bill from Tata India pvt ltd on 2/8/2013 against the challan(ch/tat/01) for 5 pcs Tata 3018 @7000 bill no. bl/tat/01

3.     purchase 5 pcs Tata 1255 @3200 from Anirban Pvt ltd in cash(bill no. bl/csh/01) at kolkata godown 2.8.2013

 

  Session 6: sales entry

To pass the entry without rate activate the following options:

GOT à Alter à voucher type à select (Sales order)

Activate this voucher : yes

Allow zero valued transactions : yes

 

GOT à Vouchers→ Sales order (Press Ctrl + F8)

 

1.     received an order from Roy info tech (ord/rit/01) for 5 Pcs Nokia 6600 and 6 Pcs Tata C168 from kolkata godown date(31.8.2013)

2.     received an order from hi tech pvt ltd for 2 Pcs Nokia N72 from Kolkata Godown (order no ord/hpl/01) on 31.8.2013

3.     received an order from globe infosys (ord/gl/01) for 5 Pcs Tata 1255 and  Tata  C168 2 Pcs from howrah godown date 31/8/2013

 

Sales challan entry

GOT à Alter à voucher type à select (Delivery note)

Activate this voucher : yes

Allow zero valued transactions : yes

 

GOT à Vouchers→ Delivery note (Press Alt + F8 )

 

1.     goods delivered to Roy info tech against the order (order no:-ord/rit/01) of 5 Pcs Nokia 6600 and 6 Pcs Tata C168 on 1.9.2013 (challan no. ch/rit/01)

2.     goods delivered to hi tech pvt ltd against the order (order no ord/hpl/01) of 2 Pcs Nokia N72 on 1.9.2013 (challan no. ch/hpl/01)

3.     Goods delivered to globe infosys against the order (ord/gl/01) for 5 Pcs Tata 1255 and 2 Pcs Tata c168 from Howrah godown DT. 1.9.2013 (challan no ch/gl/01)

 

Sales rejection entry

GOT à Alter à voucher type à select (Rejection In)

Activate this voucher : yes

Allow zero valued transactions : yes

 

GOT à Vouchers→ Rejection In (Press Ctrl + F6)

 

1.     Roy info tech returned 2 Pcs Tata C168 due to some problem against the challan(ch/rit/01) on 2.9.2013

 

Sales bill entry

 

Got àVoucher → sales (Press F8)

 

    1. Invoice send to Roy info tech on 1.10.2013 against the previous challan(challan no. Ch/rit/01) with the rate of 5 pcs  Nokia 6600@ 10000, 4 Pcs Tata C168 @ 1900 (bill no.bl/rit/01)
    2. Invoice send to Hi tech pvt ltd against the (challan no. Ch/hpl/01) of 2 Pcs Nokia N72@ 165000 with 5% trade discount on 1.10.2013(bill no. Bl/hpl/01)
    3. Invoice send to Globe infosys against the challan(challan no. Ch/gl/01) of  5 pcs Tata 1255@4000 and 2 Pcs Tata C168@ 5000 with 2% trade discount on 1.10.2013(bill no. Bl/gl/01)
    4. Sold 5 Pcs of Tata 1255 @4500 in cash bill no bl/sal/01 on 1.10.2013 from kolkata godown with 2% trade discount.

 

 Session 7:- Billing term with purchase and sales entry

 

Go to Company Features (f11) →Activate :                                                               Enable goods and service tax (GST) : yes

 

Fill in the following details given below.

State: Jharkhand

Set /Alter Tax rate details : yes

     Tax rate : 18 %

     Tax type : taxable

 

Modify the following ledgers

GOT → Alter → ledger

Ledger name

Under Group

Type of Duty/Tax

Percentage of calculation

Input gst@18%

Duties & Taxes

GST

18%

Output gst@18%

Duties & Taxes

GST

18%

 

 

Voucher Entry with Vat and CST

    1. Change all purchase and sales bill and add GST.
    2. purchase 5 Pcs Nokia 6600 @8500 for howrah  godown from Donald PVT Ltd on 2.10.2013 with 18% GST(bill no:- bl/dpl/01)
    3. sales 2 pcs Nokia N70 @ 16000 form kolkata godown and 2 pcs nokia N72@ 16500 from Howrah godown to Royal info com on 2.10.2013 with 18% GST (bill no. bl/ric/01)
    4. sales 4 pcs Nokia N70@5000 from kolkata godown from ram info tech on 2.10.2013 with 18% GST (bl/ri/01)

 


Session 8:- Free Goods Treatment

Go to Company Features (f11), activate:

 Use different Actual and billed Quantity : yes

 

1.     purchased 2 pcs Tata C168 @1500 in cash with 18% GST for Howrah 

           Godown on 31.10.2013 and got one Pcs completely free bill no                    bl/csh/02

2.     Sold 2pcs Nokia E60 29000 with 18% GST in cash with 1 pcs Nokia 6600                                                                                                                                         absolutely free on 31.10.2013 (bl/sal/02) goods were sold from Howrah        godown.

3.     sold 4 pcs Tata 1255 mobile @7000 in cash with 18% GST for Howrah godown on 31.10.2013 and got 1 pcs tata C168 completely free bill no bl/csh/02

 

Debit note (Alt + F5) and Credit note(Alt +F6)

 

1.     On 1/11/2013 1 pcs Nokia 6600 @7000 returned to Signus InfoTech from Kolkata godown with 18% GST against the bill bl/shi/01. Debit note no. db/si/01

2.     On 1.11.2013 Roy InfoTech returns 1 pcs Tata C168@ 1900 at Kolkata Godown with 18% GST against the bill on bl/rit/01 credit note no cr/ri/01

 

Session 9: Manufacturing

 

Gateway of Tally → create → stock group

Name

Under

Raw Material

Primary

Finished goods

primary

 

Gateway of Tally →create →stock item

Item name

Group

Unit

Bom

Facia

Raw material

Pcs

No

Lcd

Raw material

Pcs

No

Keypad

Raw material

Pcs

No

Circuit

Raw material

Pcs

No

Battery

Raw material

Pcs

No

Charger

Raw material

Pcs

No

Sim connector

Raw material

Pcs

No

Mobile software

Raw material

Pcs

No

Mouthpiece

Raw material

Pcs

No

Nokia 6282

Finished goods

Pcs

yes

 

Create a Manufacturing Unit (Godown)

                       Haldia                                    

 Name of Bill of Material : Nokia 6282

Components of Nokia6282

Unit of Manufacturing

1

Item

Godown

Qty

Facia

Haldia

1 pcs

Lcd

Haldia

1 pcs

Keypad

Haldia

1 pcs

Circuit

Haldia

5 pcs

Battery

Haldia

1 pcs

Charger

Haldia

1 pcs

Sim connector

Haldia

1 pcs

Mobile software

Haldia

1 pcs

Mouthpiece

Haldia

2 pcs

 

Create purchase voucher entry

 

1.     purchase 30 pcs Battery@220, 30 pcs charger@120, 200 pcs circuit@30, 30 pcs facia@35, 30pcs keypad@60, 30 pcs lcd@200,60 pcs mouthpiece@40, 30 pcs sim connector@45 and 30pcs mobile software @3200 from Rishi Trader with input vat@4% at haldia godown on 2.12.2013 (invoice no bl/rit/01)

 

Create a voucher type based on stock journal

 

Gateway of Tally → Create → Voucher Types

Name

Type of voucher

Abbr

Use as a Manufacturing journal

Manufacturing journal

Stock Journal

Mfg jrnl

yes

 

  1. Transferred all the raw materials purchased on 2.12.2013 to kolkata on same day.
  2. Product 20 pcs Nokia 6282 at the haldia on 31.1.2013 with wages 3000 and packing charge 200. (cost price:- 4270)
  3. Expenses incurred during manufacturing paid through cash on the same day.
  4. Transferred 15 pcs Nokia 6282 from Haldia to Kolkata godown on 31.12.2013
  5. sales 10 pcs Nokia 6282 @4500to Akash pvt ltd with 18% vat from kolkata godown on 31.12.2013 (bill no.bl/apl/01)

Bank Reconciliation

Got à Banking à bank reconciliation → <Select the bank name (SBI)>

Bank name : SBI                                                      opening Balance                228000

Date

Cheque no

Clearing date

Withdraw

Deposit

Balance

1.4.2013

100001

2.4.2013

25000

 

203000

1.4.2013

100002

2.4.2013

12000

 

191000

1.4.2013

100003

2.4.2013

20000

 

171000

2.4.2013

123456

1.5.2013

 

31000

203000

2.4.2013

654321

1.5.2013

 

30000

232000

2.4.2013

234564

1.5.2013

 

100000

332000

2.4.2013

256891

1.5.2013

 

200000

532000

1.5.2013

cash withdraw

1.5.2013

15000

 

517000

1.5.2013

Cash deposit

1.5.2013

 

5000

522000

31.5.2013

100004

1.6.2013

2500

 

519500

1.7.2013

100005

2.7.2013

24000

 

518933

1.7.2013

100006

2.7.2013

2000

 

518800

1.7.2013

100007

2.1.2013

20000

 

516800

 

Session 10:- Price Levels & Pos invoice

 

Press f11→ Enable multiple Price levels : yes

Got à create à Price level

 

Price level

Retailer

Wholesaler

 

Got à create → price list(Stock group) → <Select Finished Goods>

 

Under Group

Finished Goods

Price Level

Retailer

Applicable From

1.3.2014

S.no

Name of item

           Quantities

Rate

Discount(%)if any

from

Less than

1

Nokia 6282

 

2

4700

 

 

 

2

4

4650

2%

 

 

4

6

4600

3%

 

 

6

 

4560

5%

 

Got à create → price list(Stock group) → <Select Finished Goods>

Under Group

Finished Goods

Price Level

Wholesaler

Applicable From

1.3.2014

S.no

Name of item

           Quantities

Rate

Discount(%)if any

from

Less than

1

Nokia 6282

 

5

4600

 

 

 

5

10

4580

2%

 

 

10

20

4500

3%

 

 

20

 

4400

4%

 

1. To Create POS Invoice without Voucher Class

Go to Gateway of Tally → Create → Voucher type

 

Name                                 : - POS Invoice

Type of Voucher                : - Sales

Use for POS invoicing      : - yes

Class Name                            POS invoice

 

Set the following Default Ledger Accounts for POS invoice Voucher Class

 

 

Enable

Ledger name

Gift Voucher

No

 

Credit/ debit Card

Yes

SBI credit card

Cheque

Yes

SBI

Cash

Yes

cash

 

Pass the following entries POS invoice.

1)    Sold 5 pcs Nokia 6282 to Bj.Ltd (wholesalers) on 2.3.2014 from haldia godown with 18% GST (bill on bl/csh/03)

2)    Sold 4 pcs Nokia 6282 to XYZ ltd (Retailer) on 2.3.2014 from Kolkata godown. With 18% GST (bill no:-bl/csh/04)

3)    Sold 10 pcs Nokia 6282  mobile to Ram ltd (wholesaler) on 2/3/2014 from haldia godown with 18% GST (bill no:- bl/ram/09)

 

Post a Comment

Previous Post Next Post