TALLY NOTES PART 6

 

         BANK RECONCILATION STATEMENT

A Bank reconciliation Statement is a Statement that reconciles the bank balance in the book of the organization with the bank statement , If is usually prepared at periodical intervals to show the reasons causing disagreement in balances as per the cash Book and Pass book on a Particular data.

LEDGER

Bank   -  Bank A/C   (Amount : 100000)

Commission Received -  Indirect Income

Discount received – Indirect Income

Rent – Indirect Expenses

Salary – Indirect Expenses

 

 

 

ACCOUNTING VOUCHER

press F6 (Receipt )

*Bank A/c…………………Dr.  10000

        To Discount Received A/c  10000

*Bank A/c………………Dr. 12000.

            To commission Received A/c.     12000

Press F5 (payment)

*Rent A/c………………Dr.  15000

         TO Bank A/c.                 15000

*Salary A/c…………….Dr.      25000

         TO Bank A/c.                                25000

GOT – Display –Account Books – Cash/Bank Book (s)(Enter)

Bank Accounts(Enter)

Bank(Enter)

April(Enter)

Press ALT+R (Reconcile)

Enter the Bank Data (like 2-4-2021)

Then

Accept

Then Again Press ALT+R

Then Show Balance as per company Books or Balance as per Bank                                                       82000

will be same.                                    82000

 

 

BUY 1 GET 1 FREE

– press f11 – COMPANY Feature

Set, use Different Actual & Billed Qty ?   yes

 

Stock Group: Food Stuffs

Stock Item

1.Name : Rice

Under: Foodstuffs

Units : kgs

2.Name : Wheat

Under  : Foodstuffs

Units  : kgs

LEDGER

 Parvati Stockers – Sundry Creditor

Purchase – Purchase

GO TO VOUCHER

 - F9 (purchase)

Party’s  A/c Name : Parvati Stockers

Purchase  Ledger : Purchase

Name of Item	Quatity (Actual)	Quantity (Billed)	Rate	Per	Amount
Rice	100kgs	90kgs	10	Kg	900
Wheat	50kgs	50kgs	100	kg	5000
Total					5900

                                                                                                           Accept

Display Stock Summary

Gateway of Tally –Stock Summary – Select Food Stuffs as Stock group and Press Enter.

Stock Summary:-

Particular	Qty	Rate	Value
Rice	100kgs	9	900
Wheat	50kgs	100	5000
	150kgs.		5900

Display 100kgs of rice Stock item because this is the quantity that we have actually recived from the party .In case of Wheat the quantity appears as 50 kg.

GOT- Display – Account Books – Purchase registers

Select April Month (Enter)

Press F12

Show Inventory Details ? Yes

Press Alt + F1 to display the  Stock Summary detailed format Tally.ERP9 displays Voucher Register as Show below :

List of purchase voucher    1Apr2019 to 30Apr.2014

Date        Particular                             Vch NO.   Debit Amt.     Credit Amt.

1-4-14     Parvati Stockers                    1                 Amt                 5900               Purchase      5900 or              Rice    90 kg 10/kg    900            Wheat 50 kg 100/kg 5000

 

The Inventory details display 90 kgs for the Stock item Rice because this quary that the part has billed for us (we have received 100kgs of Rice ie. The actual quantity ) .We will be make the payment for only 90 kg ie. the billed quantity.

Therefore , the actual quantity affects the inventory books while the billed quantity reflects in the accounting books.

 

 

SALES MANAGEMENT

PRICE LEVELS

Price level are useful for order and invoices .An upto data price list help in decision making even at the lower levels of the organisation and quicken the sales process.

Tally. ERP 9 assists in creating quantity based price with a complex discount structure . Price lists are available only for inventory items and hence feature is available only if inventory and invoicing are active for the company.

You can have one or more price list if required . This generally applies when you have different purposes  VIZ , different groups of customes requiring different discount or dealingin different products .

HOW TO ENABLE

 – Press F11 – Company Features – Inventory Fetures

INVOICE

Separate Discount column on Invoice ? Yes

Sales Management

Use multiple Price levels ?

 

Company Price Levels 1.Old Customer 2.New  Customer

 

 

LEDER

Sales – Sales A/c

Mohan – Sundry Debtor ,Price level – New cus

Sagar – Sundry Debtor , Price level – old cus

STOCK ITEM

Keyboard

UNIT  :  Pcs

NOTE : Price list will be visible after define Stock item .

PRICE LIST

Inventory Info – Price list (Enter)

Stock group Name : All Item   Price Level               : New Customer Applicable from       : 1-Apr- 2014

 

Under Group :  All Item

Price level     : New Customer           Applicable From : 1- 4- 14

 

 

S.No	Name of Item	Quantity		Rate	Dis %(if any)
		From	Less than
1.	Keyboard
			5pcs	400/pcs	5%
		5pcs	10pcs	400/pcs	10%
		10pcs	15pcs	400/pcs	15%
		15pcs	20pcs	400/pcs	20%
		20pcs		400/pcs	25%
	End of the list

                                                                                                          Accept

Same process will be followed in old customer. And define the discount as you wish in multi item.

 

ACCOUNTING VOUCHER

Press F8 (sales)

Party’s A/c Name  : Mohan(NEW CUSTOMER)

Sales ledger : Sales

Name of Item     Quantity  Rate   per   Dis%      Amt.

Keyboard                 15pcs     400   pcs      20%   480

                                 15pcs                                       480

Party’s A/c Name  : Sagar

 

Name of Item         Quantity    Rate   per    Dis%   Amt

Keyboard                  15pcs        400     pcs     24%   456

                                   15pcs                                         456