Tally Prime Full Notes Nipt

Fundamental of Accounting and Tally Prime Notes Tally Prime Full Notes Nipt

Fundamental of Accounting and Tally Prime Notes for Self Study and Computer Coaching classes. Step by Step training Notes with Practice assignment.

Definition of Accounting

Accounting is the process of identifying, recording, classifying and reporting information on financial transactions in a systematic manner for the purpose of providing financial information for decision making.

Types of Accounts

There are basically three types of Accounts maintained for transactions

  • Personal Account
  • Real Account
  • Nominal Account

Personal Account: Any individual person or any firms or any company or a bank is considered in a Personal account. For example:-   Rajesh Singh, Muna Enterprise,    Wipro Pvt Ltd, PNB Bank, Capital etc.

Real Account: Account of any physical things. The cash account or goods account are examples of Real account. For example:-   Cash, Land, Building, Furniture, Computer etc.

Nominal Account: Account of any invisible things that means that things are in terms of cash are examples of Nominal account. For example:-  Discount, Commission, Salary, Wages, Freight etc.

Golden Rules of Accounting

Personal Accounts

The ReceiverDebit (Dr)
The GiverCredit (Cr)

Real Accounts

What comes inDebit (Dr)
What goes outCredit (Cr)

Nominal Accounts

All Expenses or LossesDebit (Dr)
All Income or GainsCredit (Cr)

Entries in Account Book

1. Suresh started a business with cash Rs 1,80,000

Cash a/c  Dr180000
To Capital a/c           180000

2. Cash deposited into PNB bank Rs 55000

PNB bank a/c  Dr55000
To Cash a/c        55000

3. Purchase goods for cash Rs 22000

Purchase a/c Dr22000
To Cash a/c        22000

4. Bought goods fromSona Enterprise Rs 72000

Purchase a/c Dr72000
To Sona a/c        72000

5. Sold goods for cash Rs 16200

Cash a/c Dr16200
To Sales a/c        16200

6. Paid rent for the year by PNB bank chequeRs 6000

Rent a/c Dr6000
PNB bank a/c        6000

7. Withdraw cash into PNB bank Rs 40000

Cash a/c Dr40000
To PNB bank a/c        40000

8. Purchased furniture for cash Rs 5000

Furniture a/c Dr5000
To Cash a/c        5000

9. Sold goods to SuperRs 12700

Super a/c Dr12700
To Sales a/c        12700

10. Received cash from SuperRs 12446 and allowed him discount Rs 254

Cash a/c Dr12446
Discount allowed a/c    254
To Super a/c             12700

11. Paid wages Rs 1800

Wages a/c Dr1800
To Cash a/c        1800

12. Paid cash for trade Expenses Rs 2000

Trade Expenses a/c Dr2000
To Cash a/c        2000

13. Withdraw cash for private Expenses Rs 8000

Drawings a/c Dr8000
To Cash a/c        8000

14. Depreciation on Machinery Rs 50000

Depreciation a/c Dr50000
To  Machinery a/c        50000

Financial Year Start 1 April To 31 March

Thanks for study the Fundamental of Accounting and Tally Prime Notes

Introduction of Tally Prime Notes

Introduction of Tally Prime : Training Notes with Practical Assignment for Self study of Tally and computer Coaching Classes. Step by Step tally training study material.

Tally Prime is accounting software, used in business to record, summarize and maintain business transactions. Tally was developed in 1984 by Shyam Sunder Goenka in Bangalore.

Download Tally Prime

Download Tally Prime from https://tallysolutions.com/download/

Install in your PC / Laptop

Use Educational Mode of Tally Prime : Free

For Training purpose : Most of the computer training Institute use Educational Mode: It is free and work without license.

Available Date in Tally Educational Version

Tally Prime- educational mode work without a license, where you can input data only on the first, second, and last days of the month.

Start Tally Software

Open Tally > W: Work in Educational Mode

Create a Company

F3 :(Company) > Create Company

Company Name : Super Traders
Fill up : Address,  State and other optional details.
Accept  

Company Created Successfully,
(Enable features as per your business need)

Accounting
Maintain Account                                      : Yes
            Enable bill wise entry                    : Yes

Inventory                                                     : No
Enable Goods and Service Tax (GST)    : No
TDS                                                                 : No

Accept

Shut Company

F3 > Company  > Shut Company

Alter Company

Go To > Select Company > Super Traders

F3 : Company > Alter Company
Change your address or any other data
 Accept

Delete Company

Go To> F3 (Company) > Alter Company > Alt + D

Company Super Traders has been deleted

Again Create Company Super Traders

(Follow the steps mentioned in Create Company)

Thanks for study the Introduction of Tally Prime Notes

Groups and Ledgers in Tally Prime Notes

Groups and Ledgers in Tally Prime computer training class Notes. Pre defined Groups and Ledgers, Create New, Alter, Credit and Debit amount. Step by Step Notes for Tally training.

Groups in Tally Prime

Pre-Defined Group

Gateway of Tally  > Chart of Account > List of Masters >Groups

There are 28 predefined groups in Tally

15 groups are Primary Groups and the remaining 13 groups are Sub-Groups

1. Branch / Divisions (P)15. Direct Expense (P)
2. Capital Account (P)16. Direct Incomes (P)
3. Reserves & Surplus17. Fixed Assets (P)
4. Current Assets (P)18. Indirect Expenses (P)
5. Bank Accounts19. Indirect Incomes (P)
6. Cash-in-Hand20. Investments (P)
7. Deposits (Asset)21. Loans (Liability) (P)
8. Loans & Advances (Asset)22. Bank OD A/c
9. Stock-in-Hand23. Secured Loans
10. Sundry Debtors24. Unsecured Loans
11. Current Liabilities (P)25. Misc. Expenses (Asset) (P)
12. Duties & Taxes26. Purchase Accounts(P)
13. Provisions27. Sales Accounts (P)
14. Sundry Creditors28. Suspense A/c (P)

Creating Group

Gateway of Tally > Masters > Create > Accounting Masters > Group  

Group NameUnderNature of Group
BuildingFixed Assets
Office EquipmentPrimaryAssets
DeprecationPrimaryExpenses

Check on Gateway of Tally > Chart of Account> Groups

Ledgers

Creating Ledger

By default there is two ledgers

  1. Cash
  2. Profit and Loss A/c

Check the default ledgers Gateway of Tally>Charts of Accounts>Ledgers

Gateway of Tally > Masters  > Create >Ledger

Ledger NameGroup Under
Punjab National BankBank Account
State Bank of IndiaBank Account
Petty CashCash in Hand
Opening StockStock in Hand
Suresh SinghSundry Debtors
National Pvt. Ltd.Sundry Debtors
Building CostBuilding (Fixed Assets)
Building Accrued DepBuilding (Fixed Assets)
Office Equipment CostOffice Equipment (Assets)
Office Equipment DepOffice Equipment
Sales TaxDuties & Taxes
T.D.SDuties & Taxes
Shivam KumarSundry Creditors
Sona EnterpriseSundry Creditors
Education Loan Secured Loan
Bill ReceivableCurrent Assets
Computer SalesSales Accounts
Software SalesSales Accounts
Parts SalesSales Accounts
Bank InterestIndirect Incomes
PurchasePurchase Accounts
WagesDirect Expenses
FreightDirect Expenses
SalariesIndirect Expenses
Office ExpensesIndirect Expenses
AdvertisementsIndirect Expenses
Bank ChargesIndirect Expenses
Building DeprecationDeprecation
Office Equipment Accrued DepDeprecation

Ledger Alteration

Gateway of Tally > Masters  > Alter >Ledger

ParticularsDebitCredit
Punjab National Bank35000 
State Bank of India40000 
Petty Cash500 
Opening Stock50000 
Suresh Singh15000 
National Pvt. Ltd.5000 
Building Cost75000 
Building Accrued Dep 6000
Office Equipment Cost25000 
Office Equipment Dep1000 
Sales Tax 9000
T.D.S 4500
Shivam Kumar 32000
Sona Enterprise 20000
Education Loan 60000
Bill Receivable 14000
Computer Sales 72000
Software Sales 75000
Parts Sales 35000
Bank Interest  
Purchase120000 
Wages10000 
Freight500 
Salaries20000 
Office Expenses3500 
Advertisements2000 
Bank Charges2500 
Building Deprecation2500 
Office Equipment Accrued Dep 80000
  Total  407500  407500

Trial Balance

Gateway of Tally > Display more Reports> Trial Balance > Press F5 (Ledger wise and Group wise)

Voucher Entry in Tally Prime Notes

Voucher Entry in Tally Prime : Computer Training Notes with exercise / assignment for practice. Sample entry for Self study and computer coaching Classes.

Create New Company  : Super_Voucher : As per the procedure mentioned in Introduction of Tally Prime Notes

Voucher in Tally Prime

All entries which you made in these given accounting vouchers are effect on your current accounting of your business.

  • F4: Contra : Cash deposited into bank and cash withdrawn from bank entries.
  • F5: Payment : Cash and cheque payment including cash and bank purchase entries.
  • F6: Receipt : Cash and cheque received including cash and bank sales entries.
  • F7: Journal : All non-cash transactions entries.
  • F8: Sales : Only credit sales entries.
  • F9: Purchases : Only credit purchase entries.
  • Alter + F7: Stock Journal : Stock transferred and production entries.

Gateway of Tally > Transactions > vouchers

Vouchers Mode Entries

Mode Change for Purchase and Sales voucher
Ctrl +L           : Accounting Invoice       :As voucher

  1. Started Business with cash Rs500000                           (Receipt.F6)
  2. Open bank account in PNB bank with cash Rs 25000  (Contra.F4)
  3. Purchased goods for cash of Rs 50000                         (Payment.F5)
  4. Purchased Machinery for Cash Rs 100000                    (Payment.F5)
  5. Purchase goods on credit from Mr. Pawan Kumar Rs 60000 (Purchase. F9)
  6. Paid discount Rs 2000                                                   (Payment.F5)
  7. Sold goods on credit to Mr. SameerAlamRs 72000      (Sales. F8)
  8. Purchase goods on credit from Super Pvt. Ltd. Rs 16000  (Purchase. F9)
  9. Received cash from Mr. SameerAlamRs 72000              (Receipt. F6)           
  10. Paid cash to Mr. Pawan KumarRs 60000                        (Payment.F5)
  11. Commission received Rs 5000                                       (Receipt. F6)
  12. Electricity bill paid Rs 1000                                            (Payment.F5)
  13. Purchased goods on credit from Sona Enterprise Rs 14000  (Purchase. F9)
  14. Purchased computer for cash Rs 21000                         (Payment.F5)
  15. Deposited cash into PNB bank Rs 10000                       (Contra.F4)
  16. Sold goods for cash Rs 80000                                        (Receipt.F6)
  17. Paid cash to Sona Enterprise Rs 14000                          (Payment.F5)
  18. Depreciation on 10% for Machinery Rs 5000                 (Journal.F7)
  19. Interest paid cash on loan Rs 1000                                 (Payment.F5)
  20. Withdraw cash into PNB bank Rs 25000                         (Contra.F4)
  21. Received Service Charge Rs 18000                                (Receipt.F6)
  22. Paid cash to Super Pvt. Ltd. Rs 16000                             (Payment.F5)

Voucher Entry in Tally: Step by Step

Create the required Ledger directly

Press Alt+C after reaching in the entry box below Particulars.
Example : Create Capital Ledger under Capital Account Group
PNB Bank Ledger under Bank Account and so on.

(Receipt.F6)

Cr Capital500000Capital Accounts
Dr Cash         500000Cash in Hand

(Contra.F4)

Cr Cash25000Cash in Hand
Dr PNB Bank         25000Bank Accounts

(Payment.F5)

Dr Purchase50000Purchase Accounts
Cr Cash         50000Cash in Hand

(Payment.F5)

Dr Machinery100000Fixed Assets
Cr Cash         100000Cash in Hand

(Purchase. F9)    

Cr Pawan Kumar60000Sundry Creditors
Dr Purchase         60000Purchase Accounts

(Payment.F5)

Dr Discount2000Indirect Expenses
Cr Cash         2000Cash in Hand

(Sales. F8)

Dr SameerAlam72000Sundry Debtors
Cr Sales         72000Sales Accounts

(Purchase. F9)  

Cr Super Pvt Ltd16000Sundry Creditors
Dr Purchase         16000Purchase Accounts

(Receipt.F6)

Cr Sameer Alam72000Sundry Debtors
Dr Cash         72000Cash in Hand

(Payment.F5)

Dr Pawan Kumar60000Sundry Creditors
Cr Cash         60000Cash in Hand

(Receipt. F6)

Cr Commission5000Indirect Incomes
Dr Cash         5000Cash in Hand

(Payment.F5)

Cr Cash1000Cash in Hand
Dr Electricity Bill         1000Indirect Expenses

(Purchase. F9)

Cr Sona Enterprise14000Sundry Creditors
Dr Purchase         14000Purchase Accounts

(Payment.F5)

Cr Cash21000Cash in Hand
Dr Computer         21000Fixed Assets

(Contra.F4)

Cr Cash10000Cash in Hand
Dr PNB Bank         10000Bank Accounts

(Receipt.F6)

Cr Sales80000Sales Accounts
Dr Cash         80000Cash in Hand

(Payment.F5)

Cr Cash14000Cash in Hand
Dr Sona Enterprise         14000Sundry Creditors

(Journal.F7)

Dr Depreciation5000Indirect Expenses
Cr Machinery         5000Fixed Assets

(Payment.F5)

Cr Cash1000Cash in Hand
Dr Interest on Loan         1000Indirect Expenses

 (Contra.F4)

Cr PNB Bank25000Bank Accounts
Dr Cash         25000Cash in Hand

 (Receipt.F6)

Cr Commission18000Indirect Income
Dr Cash         18000Cash in Hand

 (Payment.F5)

Cr Cash16000Cash in Hand
Dr Super Pvt Ltd         16000Sundry Creditors

Balance Sheet : Gateway of Tally > Reports > Balance Sheet

Cash in Hand400000
Bank Accounts10000
Net Profit26000
Balance Sheet526000

Show all Vouchers Entries : Gateway of Tally> Transaction  > Day Book

Create Stock Item in Tally Prime Notes for Practice

How to create Stock Group, Unit, Godown and stock item in Tally Prime. Step by Step Notes with practice assignment for Computer Training Institute and Self Study of learners.

Create a New Company for Practice the creation of Stock Group, Godown, Unit and Stock Item
F3  : (Company) > Create Company

Accounting :

                Maintain Account                            :Yes

                Enable bil wise entry                      : Yes

Inventory

                Maintain Inventory                         : Yes

                Integrate Accounts with Inventory : Yes

Taxation :

                Enable GST                                  : No

Create Stock Group in Tally Prime

Gateway of Tally > Masters > Create > Inventory Masters > Stock Group

Stock GroupUnder
SystemPrimary
PartsPrimary
Mother BoardParts
CD RomParts
Eight SpeedCD Rom
Ten SpeedCD Rom
SoftwarePrimary
AceSoftware
KingSoftware
QueenSoftware

Create Godown / Location

Gateway of Tally > Masters > Create > Inventory Masters > Godown
Main Location exists by default.  Create following new Godown

GodownUnder
OnsidePrimary
Ware HousePrimary

Create Unit

Gateway of Tally > Masters > Create > Inventory Masters >Unit

SymbolFormal Name
NosNumber

Type: Simple

Create Stock Item in Tally Prime

Gateway of Tally > Masters > Create > Inventory Masters >Stock item
F12 : Configure  > Show More Configuration : Yes
Inventory details :
Provide Standard Buying and Selling Rates :  (Yes)

During creation of following items use
Units: Nos
Set Standard Rates (Yes) : Provide Rate of respective item from below table.
Opening Balance : Quantity of item
Godown : Onside and Warehouse, as mentioned below (Do’t fill rate here)

Item NameUnderStandard Cost RateSelling Price RateQuantityOnsideWarehouseAmount
P086 MXSystem7509408716000
P092 MXSystem90011301521313500
P110 MXSystem103012901221012360
MBP 133Parts240320220480
MBP 150Parts2853806601710
MBP 166Parts335450101003350
Gold 8Eight Speed456022090
Silver 8Eight Speed5570440220
Brown 8Eight Speed6080440240
Gold 10Ten Speed75100252501875
Silver 10Ten Speed95130202001900
Data Base AAce175250101001750
Speed Short AAce155220151502325
Data Base KKing100150770700
Speed Short KKing1402008801120
Data Base QQueen210306101002100
Speed Short QQueen70100440280

Go To (Alt+G) : Stock Query  : To check individual items
Go To (Alt+G) : Stock Summary >F5 (stock Item wise)

Bill wise entry in Tally Prime

Bill wise entry and details in Tally Prime. Step by Step Training instruction notes for self study and Tally Computer Coaching Classes Institutes. Bill Book PDF for Practice Purchase and Sales entry are provided in this post.

Create New Company

F3  : (Company) > Create Company

Accounting :

                Maintain Account                            :Yes

                Enable bill wise entry                     : Yes

Inventory

                Maintain Inventory                         : Yes

                Integrate Accounts with Inventory : Yes

Taxation :

                Enable GST                                  : No

Bill wise entry in Tally Prime

Create Ledger
Sundry Creditors : For Purchase Party,       
Sundry Debtors :  For Sales Party

Gateway of Tally >  Create > Ledger

LedgerUnder 
Computer WorldSundry CreditorsMaintain balances bill – by bill (Yes)
PurchasePurchase Accounts 
LedgerUnder 
Harish RawatSundry DebtorsMaintain balances bill – by bill (Yes)
SalesSales Accounts 

Gateway of Tally >  Vouchers >F9 Purchase
Ctrl + H Mode Change   1. Voucher Mode / 2. Invoice Mode
1. Voucher Mode

ParticularsDebitCredit
Cr  Computer World 10000
Dr  Purchase10000 

Type of Ref:       New Ref
Name:  1      Amount:      10000 Cr
Narration
Being goods purchased on credit to Computer World
Display > Statements of Accounts > Outstanding > Payables 

Gateway of Tally > Vouchers > F5 Payment

ParticularsDebitCredit
Dr  Computer World10000 
Cr  Cash  10000

Type of Ref:       Agst Ref
Name:  1
Amount:              10000 Dr
Narration
Being Paid cash to Computer World
Display > Statements of Accounts > Outstanding > Payables (Null)

F8 Sales

ParticularsDebitCredit
Dr  Harish Rawat14000 
Cr  Sales  14000

Type of Ref:       New Ref
Name: 1
Amount:              14000 Dr
Narration
Being good sold on credit to Harish Rawat
Display > Statements of Accounts > Outstanding > Receivable

F6 Receipt

ParticularsDebitCredit
Cr  Harish Rawat 14000
Dr  Cash14000 

Type of Ref:       Agst Ref
Name    :               1
Amount:              14000 Cr
Narration Being received cash to Harish Rawat
Display > Statements of Accounts > Outstanding > Receivable – NIL

Create Stock Group
Gateway of Tally > Create> Inventory Masters > Stock Groups

Stock GroupUnder
ComputerPrimary

Create Stock Item
Gateway of Tally > Create> Inventory Masters > Stock  

Item NameUnderUnits
MouseComputerPcs
KeyboardComputerPcs

Create Ledger
Gateway of Tally > Accounts Info > Ledgers > Create

LedgerUnder 
Raja TradersSundry CreditorsMaintain balances bill – by bill (Yes)
PurchasePurchase AccountsInventory values are affected (Yes)
LedgerUnder 
Sona EnterpriseSundry DebtorsMaintain balances bill – by bill (Yes)
SalesSales AccountsInventory values are affected (Yes)

2. Invoice Mode

F9 Purchase  > Ctrl +H > Invoice Mode

Purchase No 1.                                                                                                                           1-Apr-2021

Supplier invoice 001                                       Date: 1-Apr-2021                                Thursday

Party A/c Name:   Raja Traders 
Purchase Ledger:    Purchase 
Name of ItemQuantityRatePerAmount
Mouse14 Pcs150.00Pcs2100.00
Keyboard72 Pcs165.00Pcs11880.00
 86 Pcs  13980.00

Type of Ref: New Ref
Name:  1Amount:            13980 Cr
Narration
Being goods purchased on credit to Raja Traders
Display > Statements of Accounts > Outstanding > Payables 

F5 Payment

ParticularsDebitCredit
Dr Raja Traders13980 
Cr  Cash  13980

Type of Ref:       Agst Ref
Name:  1Amount:            13980 Dr
Narration
Being paid cash to Raja Traders
Display > Statements of Accounts > Outstanding >Payables  NIL

F8 Sales

Sales No 1.                                                                                                                                   1-Apr-2021
Supplier invoice 001                                       Date: 1-Apr-2021                                Thursday

Party A/c Name:   Sona Enterprise 
Sales Ledger:    Sales 
Name of ItemQuantityRatePerAmount
Mouse5 Pcs160.00Pcs800.00
Keyboard10 Pcs180.00Pcs1800.00
     
 15 Pcs  2600.00

Type of Ref: New Ref
Name:  1             
Amount:              2600 Dr
Narration
Being goods sold on credit to Sona Enterprise
Display > Statements of Accounts > Outstanding > Receivable – NIL

F6 Receipt

ParticularsDebitCredit
Cr Sona Enterprise 2600
Dr  Cash2600 

Type of Ref:       Agst Ref
Name:  1Amount:            2600 Cr
Narration : Being received cash to Sona Enterprise
Display > Statements of Accounts > Outstanding > Receivable – NIL

Tally Bill Book PDF for Free Download

Purchase Invoice Bills Sundry Creditors Bill Book
Sales Invoice Bills Sundry Debtors Bill Book
Bills Receivable
Bills Payable
Stock Summary
Stock Journal
Transfer of Material

Batch wise Details in Tally Prime Notes

Batch Wise Inventory details in Tally Prime. Training Manual Notes for Tally Prime Computer course with example and sample practice Purchase invoice for a medical agency.

Batch wise maintain inventory or stock items in lots. Batches help in better management of stock items with limited shelf life or perishable goods.
Maintain perishable goods or stock items with limited shelf life
Use batches for rate-wise categorization of stock items:
Identify stock item details from batches:

Batch wise Details in Tally Prime for a Medical Agency

This allow  to track your medicine with a specific code. It also allows you to see and mention your medicine Manufacture date & Expiry date.

Create New Company
F3  : (Company) > Create Company
Show more features                         :Yes
Accounting :
                Maintain Account                            :Yes
                Enable bil wise entry                     : Yes
Inventory
                Maintain Inventory                         : Yes
                Integrate Accounts with Inventory : Yes
                Enable Batches                               : Yes
                Maintain Expiry date for batches   : Yes
Taxation :
                Enable GST                                         : No

For any existing Company :  Press  F11 (Features) > set the option Enable Batches, etc  to Yes.

Create Ledgers : Gateway of Tally > Create > Ledger

Ledger NameUnder 
Shree Medical AgencySundry CreditorsMaintain Balances bill – by – bill (Yes)
PurchasePurchase AccountsInventory values are affected (Yes)
Health Medical StoreSundry DebtorsMaintain Balances bill – by – bill (Yes)
SalesSales AccountsInventory values are affected (Yes)

Create Stock Group : Gateway of Tally > create > Stock Groups

Stock GroupUnder
MedicinePrimary

Create Stock Categories : Gateway of Tally > Create > Stock Categories

Stock CategoriesUnder
PainkillerPrimary

Create Unit : Gateway of Tally > Create >Unit

Type: Simple

SymbolFormal Name
BoxBoxes

Create Stock Item : Gateway of Tally > Create > Stock

F12 > Configuration > Inventory details
Use Stock Category for Stock Items                        : Yes

Item NameUnderCategoriesUnits
CrocinMedicinePainkillerBox

Maintain in batches              Yes
Track date of manufacturing           Yes
Use expiry dates                    Yes

Purchase Entry : Gateway of Tally >  Voucher >Purchase F9

Purchase 1
Supplier Invoice No: 001
Party A/c Name: Shree Medical Agency
Purchase Ledger: Purchase
Name of Item                                     Quantity                     Rate  Per                     Amount      
Crocin                                                  100 Box                       45  Box                        4500
Item Allocations for: Crocin

                Batch No Batch 003  Quantity  Rate  Per  Amount
Mfg Dt.: Apr-2021100 Box
Expiry Date: 1-Nov-2024 45   Box4500

Bill-wise Details for: Shree Medical Agency
Upto ₹ 4500 Cr
Type of Ref          New Ref
Name                   001
Amount               4500 Cr

Sales Entry : Gateway of Tally > Voucher > Sales F8

Sales 1 Reference No: 001
Party A/c Name: Health Medical Store
Sales Ledger: Sales
Name of Item                                     Quantity                     Rate  Per                     Amount         
Crocin                                                  100 Box                       45  Box                        4500
Item Allocations for: Crocin

                Batch No  Quantity  Rate  Per  Amount
Mfg Dt.Batch 003 : Apr-2021
Expiry Date : 1-Nov-2024 20 Box55   Box1100

Bill-wise Details for: Naqvi Medical Store
Upto ₹ 1100 Dr
Type of Ref          New Ref
Name                   001
Amount               1100 Dr

Display More Report>Inventory Books > Batch> Crocin >List of Batches

Batch Wise details Entry in Tally Prime : PDF with Practice Bills

Cost Center in Tally Prime Notes

Cost Center in Tally Prime : Step by Step Training Notes with sample, sample and exercise. Best notes for self study and Tally Computer Training Institutes.

What is Cost Center in Tally Prime?

The cost center is an organizational unit to which costs or expenses can be allocated during recording of transactions in Tally Prime.

F3 Company > Create Company > Demo_Cost Center
Show Moe Features : Yes
Accounting
Maintain Accounts :  Yes
Enable bill wise entry : Yes
Enable Cost Centers  : Yes

Create Ledger
Gateway of Tally Create > Ledger > press Enter.
F12 : Configure > Enter
Apply cost enters for ledgers : Yes

Ledger NameUnder 
RechargeIndirect ExpensesCost centres are applicable(Yes)

Create Cost Centres
Gateway of Tally Create > Cost Centres > press Enter

Cost Centre NameUnder
Mobile RechargePrimary
DTH RechargePrimary
8786456105Phone Recharge
7892561205Phone Recharge
7411089605Phone Recharge
050254895705DTH Recharge
121472789105DTH Recharge
7252367891205DTH Recharge

Payment Entry
Gateway of Tally >  Voucher >Payment (F5)
Account : Cash

Particulars.
Dr  Recharge12000
8786456105          1000 Dr.
7892561205          1000 Dr.
7411089605          4000 Dr.
050254895705             2000 Dr.
121472789105             1000 Dr.
7252367891205           3000 Dr.
Cr Cash.

Gateway of Tally > Display More Reports > Statements of Accounts > Cost Centres > Cost Centre Summary.
Gateway of Tally > Display More Reports > Statements of Accounts > Cost Centres > Ledger Break Up

Exercise :  Cost Center Entry in Tally Prime

Make a Salary ledger under Indirect Expenses (Cost centres are applicable :Yes)
Create following Cost Center under Primary
1. Admin
2. Purchase
3. Store
Create following Cost Center and Payment Voucher

Cost CenterUnder
Mohan LalAdmin
Alam KhanAdmin
BhushanAdmin
AfrozAdmin
ManishPurchase
Yash RajPurchase
IshuPurchase
AskhiPurchase
AnilStore
SaritaStore
ShubhamStore
KomalStore

Paid salary : 190000 as under

Cost CenterUnder
Mohan Lal25000
Alam Khan22000
Bhushan20000
Afroz15000
Manish12000
Yash Raj16000
Ishu14000
Askhi10000
Anil15000
Sarita16000
Shubham15000
Komal10000

Check the Report in Tally

Gateway of Tally > Display More Reports > Statements of Accounts > Cost Centres > Cost Centre Summary and Leger Break Up

Download Notes PDF : Tally Prime from below link:

Export Import Ledger in Tally Prime

Export and Import Ledger Data in XML format from one company to another in Tally Prime. Training Notes, with easy to understand way for Tally learners.

We need to export and Import the data of ledgers of to maintain the same ledgers of a existing company in a new company. Further, copy the transactions up to a specific date from the existing company into the new company. We can export the masters and transactions from the existing company in XML format, and import them into the new company.

Export Masters in Tally Prime (XML Format)

Alt +E > Masters
Export
Type of Masters          :           Ledgers
File Format                  :           XML (Data Interchange)
Export to                     :           Local Drive
Folder Path                  :           C:\Program files\Tally Prime
File Name                    :           Master.xml

Press  E : Send : Data has been exported at desired location. Check the destination folder contains Master.xml file.
Note : Folder Path and File Name may be change by pressing F6    

Import Masters Data in New Company

Create New Company (In which we wat to maintain same ledgers)
Press Alt+O

Import Masters (Only Tally XML format is supported)
File Path             : C:\Program files\Tally Prime
File to import     :        Master.xml
Behavior of import if master already exists: Select as per your requirement
                           Combine opening balance
                           Ignore duplicate
                           Modify with new data

Press Enter to import the data
Check the ledgers and imported data in
Gate way of Tally > charts of Accounts

Purchase and Sale Order Processing in Tally Prime

Purchase and Sale Order Processing in Tally Prime : Purchase Order Processing is the process of placing orders with suppliers for a purchase to be made from them and Sales Order Processing is the process of receiving orders from customers for the purpose of selling.

Therefore, Order are two type (1) Purchase Order  and (2)  Sales Order. We are going to discuss step by step process for place Purchase and Sales order in Tally Prime. The Notes are very useful for self study of Tally Prime and Computer Training Institutes.

Notes on Order Processing in Tally Prime

Create New Company : F3 : Company : Crate New :

Create Ledger Gateway of Tally > Create > Ledgers

Ledger NameUnder 
Indian ComputersSundry CreditorsMaintain balance bill by bill (Yes)
PurchasePurchase AccountsInventory values are affected (Yes)
Ledger NameUnder 
Naaz TradersSundry DebtorsMaintain balance bill by bill (Yes)
SalesSales AccountsInventory values are affected (Yes)

Create Stock Group > Gateway of Tally > Crete > Stock Groups

Stock GroupUnder
ComputerPrimary

Create Stock Item >Gateway of Tally > Inventory Info > Stock Items > Create

Item NameUnderUnits
MouseComputerPcs
KeyboardComputerPcs

Activate Purchase and Sales Order Vouchers

Gateway of Tally >Vouchers > F10 (Others vouchers)
List of Vouchers: Show Inactive Vouchers

Purchase order: Ctrl + F9 (Press It)
You need to activate Purchase Order Voucher Type: Activate Now: Yes

Sales order: Ctrl + F8 (Press It)
You need to activate Sales Order Voucher Type: Activate Now: Yes

Purchase Order   [Ctrl+F9] in Tally Prime

Purchase Order No.1

Party A/c Name : Indian Computers                      Order No :  TUE121021

Purchase ledger : Purchase

Name of Item                                     Quantity Rate    Per            Amount

Keyboard                                         25 Pcs  125  Pcs                         3125

Mouse                                            25 Pcs  110  Pcs                         2750

                                                                        50 Pcs                                          5875

Display more Report > Statements of Inventory > Purchase Order Outstanding > All Orders

Purchase (F9) against Purchase Order

Gateway of Tally > Vouchers > Purchase F9

F12: Configure:
Provide order details : Yes

Purchase No. 1

Supplier invoice no : 001

Party A/c Name : Indian Computers

Order No :TUE121021

Purchase ledger : Purchase

Name of Item                                     Quantity         Rate    Per                  Amount

Keyboard                                            25 Pcs  125  Pcs                         3125

Mouse                                               25 Pcs  110  Pcs                         2750 

                                                    50 Pcs                                          5875

Display > Statements of Inventory > Purchase Order Outstanding > All Orders (Null)

Sales Order : Ctrl+F8 in Tally Prime

Sales Order No.1

Party A/c Name : Naaz Traders                                              Order No :  Sale001

Purchase ledger : Purchase

Name of Item                                     Quantity         Rate    Per                  Amount

Keyboard                                           10 Pcs  160  Pcs                         1600                                                    10 Pcs                                         1600

Display all reportsd> Statements of Inventory > Sales Order Outstanding > All Orders

Sales against Sales Order

Gateway of Tally >Vouchers > Sales F8

Sales No. 1
Reference no : 001
Party A/c Name : Naaz Traders                                  Order No : Sale001
Sales ledger : Sales
Name of Item                                     Quantity         Rate    Per                  Amount Keyboard                                                         10 Pcs  160 Pcs                          1600                                                                         10 Pcs                                         1600

Display > Statements of Inventory > Sales Order Outstanding > All Orders (Null)

Download Notes PDF : Tally Prime from below link:

Price List Creation in Tally Prime Notes

In the price list lesson, the rates of the items are set on the basis of quantity. It is required, when we are selling the goods to retailers and consumers. Normally, Trading Firm offer, discounted price to retailers on the basis of quantity. We will learn Creation of Price List in Tally Prime. The Computer Training Institute Notes with example, sample and assignment is very easy to understand. Best quality Tally Training Notes for Self Study.

Price List Creation in Tally Prime

Purchase Entry

Purchase No. 1                        Supplier invoice no : 001
Party A/c Name : Isha Enterprise
Purchase ledger : Purchase
Name of Item                         Quantity         Rate    Per                  Amount
Intex Mouse                        150 Pcs            120  Pcs                         18,000
Logitech Keyboard                  180 Pcs            140  Pcs                         25,200       
                                                 330 Pcs                                                43,200

Taking Permission to Enable Multiple Price Level

F11 : Features > Inventory Features
Enable Multiple Price Level                : Yes
Use discount Column in invoices        : Yes

Gateway of Tally > Create > Price Level

Company Price Levels
Whole sale
Retail sales

Create Ledger : Gateway of Tally > Create > Ledgers

Ledger NameUnder 
Naaz TradersSundry DebtorsMaintain balance bill by bill (Yes)
SalesSales AccountsInventory values are affected (Yes)

Set Price List

Gateway of Tally >Create > Price List (Stock Group)

Price List
Stock Group:             All Items
Price Level:                Whole Sales
Applicable From:            1-Apr-2021
Under Group                              All Items
Price Level                                  Whole Sales        
Applicable From:                        1-Apr-2021

S.NoParticularsQuantitiesRateDisc. % (If any)Cost Price
FromLess than
1.Intex Mouse     
   20 Pcs180. 120.00/Pcs
  20 Pcs40 Pcs1702% 
  40 Pcs60 Pcs1604% 
  60 Pcs100 Pcs1408% 
  100 Pcs    
2.Logitech Keyboard     
   10 Pcs200 140.00/Pcs
  10 Pcs50 Pcs175  
  50 Pcs100 Pcs1605% 
  100 Pcs140 Pcs15010% 
  140 Pcs    

Set Rate of Exchange in Tally Prime

Set Dollar Rate : Create > Rate of Exchange

StandardSellingBuying
DateSpecified RateDate  Specified RateDateSpecified Rate
1-Apr-21₹75/$1-Apr-21₹80/$1-Apr-21₹73/$

Create Ledger : Gateway of Tally > Create > Ledger

Ledger NameUnder
Suresh RawatSundry Creditors
PurchasePurchase Accounts
Haider EnterpriseSundry Debtors
SalesSales Account

Create Stock Group : Gateway of Tally > Create > Stock Group

GroupUnder
FoodPrimary

Create Item : Gateway of Tally > Create > Stock Item

ItemUnderUnits
PizzaFoodPcs
ChipsFoodPkt

Purchase Entry Gateway of Tally > Voucher > F9

Supplier invoice no.: 001
Party A/c name ledger: Suresh Rawat
Purchase ledger: Purchase

Name of ItemQuantityRateAmount
Pizza10 Pcs$2.00 Pcs$20.00
Chips10 Pkt$1.00 Pkt$10.00
$30.00 @ ₹ 73/$ = ₹ 2190.00

Repeat for above step for attendance type : Overtime

Payroll Boucher Creation in Tally Prime

Gateway of Tally > Voucher > F10: Other Vouchers > Payroll vouchers > Payroll
Ctrl +F (Auto fill)

Payroll Autofill window
Process for : Salary
From : 01-05-2021 To: 31-05-2021
Employees Group : All Items
Sort by : Employees Name
Payroll Ledger : Cash
Accept

Display the Salary Information

Gateway of  Tally > Display more report >Payroll reports >
Pay slip
Pay Sheet
Attendance Sheet
Payroll Register
Attendance Register
Employee Profile
Employee Head count

Download PDF : Payroll in Tally Prime

Tally Prime Full Notes NiptTally Prime Full Notes NiptTally Prime Full Notes NiptTally Prime Full Notes NiptTally Prime Full Notes NiptTally Prime Full Notes NiptTally Prime Full Notes NiptTally Prime Full Notes NiptTally Prime Full Notes NiptTally Prime Full Notes NiptTally Prime Full Notes NiptTally Prime Full Notes NiptTally Prime Full Notes NiptTally Prime Full Notes NiptTally Prime Full Notes NiptTally Prime Full Notes NiptTally Prime Full Notes NiptTally Prime Full Notes NiptTally Prime Full Notes NiptTally Prime Full Notes NiptTally Prime Full Notes NiptTally Prime Full Notes NiptTally Prime Full Notes NiptTally Prime Full Notes NiptTally Prime Full Notes NiptTally Prime Full Notes NiptTally Prime Full Notes NiptTally Prime Full Notes NiptTally Prime Full Notes NiptTally Prime Full Notes NiptTally Prime Full Notes NiptTally Prime Full Notes NiptTally Prime Full Notes NiptTally Prime Full Notes NiptTally Prime Full Notes NiptTally Prime Full Notes NiptTally Prime Full Notes NiptTally Prime Full Notes NiptTally Prime Full Notes NiptTally Prime Full Notes NiptTally Prime Full Notes NiptTally Prime Full Notes NiptTally Prime Full Notes NiptTally Prime Full Notes NiptTally Prime Full Notes NiptTally Prime Full Notes NiptTally Prime Full Notes NiptTally Prime Full Notes NiptTally Prime Full Notes NiptTally Prime Full Notes NiptTally Prime Full Notes NiptTally Prime Full Notes Nipt

Tally Prime Full Notes Nipt

COMPUTER ACADEMY Hello, I am Mr. Vivek Sharma, your ADCA (Advanced Diploma in Computer Applications) teacher. With a passion for technology and education, I am dedicated to preparing students for success in the IT industry. Here’s a brief introduction about me:

Leave a Comment