Read Sample TallyPrime 3

Download as pdf or txt
Download as pdf or txt
You are on page 1of 38

A Practical Hands-on Self-Study Approach TallyPrime Book – Rel.

3 & Higher

TallyPrime Book (Advanced Usage) Page: 1 Visit us: www.TallyPrimeBook.com


– Rel. 3 & Higher
A Practical Hands-on Self-Study Approach TallyPrime Book – Rel. 3 & Higher

No parts of this Book may be reproduced or utilized, in any form or by any means electronics or
mechanical, including photographing, recording or by any means electronic or by any information
storage or retrieval system, without the written permission of www.TallyPrimeBook.Com
Disclaimer
The names of Companies and persons used in this book have been used for illustrative purposes only.
The visitors may visit www.tallysolutions.com, the web site of Tally Solutions Pvt. Ltd. for resolving
their doubts or for clarifications
Trademark:
TallyPrime, Tally, Tally9, Tally.ERP 9, Tally.Server9, Tally.NET & ‘Power of Simplicity’ are either
registered trademarks or trademarks of Tally Solutions Pvt. Ltd. in India and/or other countries. All
other trademarks are properties of their respective owners.
www.TallyPrimeBook.Com is not associated with any product or vendor mentioned in this book.
Notices
Information in this book is subject to change without prior notice and does not represent a
commitment on the part of www.TallyPrimeBook.Com
“While every effort has been made to ensure that this book is free from errors or omissions, the author,
publisher, printer shall not be liable in any manner whatsoever for any material or information
published in this book.”
Forward
This book is self-supporting and are written in easy to follow language and have been blended with
large number of examples. The material is provided in a pleasing-to-eye format so as to retain and
enhance the interest of the learners. We are sure the learners would find these texts by useful.

www.TallyPrimeBook.Com believes in constant improvement of courseware and we welcome


suggestions through our e-Mail ID: [email protected]

For
www.TallyPrimeBook.Com

Sanjay Satpathy
(Author)

TallyPrime Book (Advanced Usage) Page: 2 Visit us: www.TallyPrimeBook.com


– Rel. 3 & Higher
A Practical Hands-on Self-Study Approach TallyPrime Book – Rel. 3 & Higher

Instruction :

All are requested to attempt all Practical Assignment given after every Chapter with the help of your
own TallyPrime Software, otherwise you will not able to display your Reports and Statements. After
going through all the Chapters, you can maintain 100% independently of your Books of Accounts with
Inventory with the help of your own TallyPrime Software.

Practice on your own TallyPrime Software

To get you own version of the original legal version of TallyPrime software to learn and practice at your
convenience , please download the Education Version of the software (Free) from …

https://tallysolutions.com/download

Author:
Sanjay Satpathy
SWAYAM EDUCATION
Mandal Bagicha, Hemkapada,
Sunhat, Balasore,Odisha-756003 (INDIA)
eMail ID : [email protected]
Web : www.TallyPrimeBook.Com
Mob – 9437264738

~~~~~~~~~~

Published & Print with New Update for the Year – 2023-24
Price: `. 700

TallyPrime Book (Advanced Usage) Page: 3 Visit us: www.TallyPrimeBook.com


– Rel. 3 & Higher
A Practical Hands-on Self-Study Approach TallyPrime Book – Rel. 3 & Higher

TallyPrime-Rel. 3.*
Table of Contents
(A) Download and Install TallyPrime-3. Activate/Reactivate License or Migrate your Existing
Company. ............................................................................................................................ 14
(B) Migrate Company Data to TallyPrime-3 ........................................................................... 16

CHAPTER-1
COMPANY CREATION

1.1. Company Creation: ........................................................................................................ 20


1.2. Opening (Loading) the Company in TallyPrime: ............................................................... 25
1.3. Modification | Update | Alter Company Details | Delete Company .................................. 26

CHAPTER-2
GST SETUP USING TallyPRIME-3.*

2.1. Activate GST for Your Company ...................................................................................... 27


2.1.1. Activate GST for Regular Dealers ......................................................................................... 28

CHAPTER-3
SET-UP OF GROUPS/LEDGERS [Charts of Accounts]

3.1. Account Groups in TallyPrime ........................................................................................ 31


3.1.1. Create Account Groups (under Single Group) one-by-one:................................................... 32
3.1.2. Advanced Configurations for Account Groups...................................................................... 33

Practical Assignment - A

3.2. Ledgers in TallyPrime ..................................................................................................... 35


3.2.1. Creating a Single LEDGER : ................................................................................................... 35
3.2.2 Displaying, Altering and Deleting Ledger Accounts................................................................ 37
3.2.3. Creating a Current Liabilities / Assets Ledger ....................................................................... 37

Practical Assignment - 1

3.2.4. Creating Bank Account Ledgers in TallyPrime ................................................................ 39

Practical Assignment - 2

TallyPrime Book (Advanced Usage) Page: 4 Visit us: www.TallyPrimeBook.com


– Rel. 3 & Higher
A Practical Hands-on Self-Study Approach TallyPrime Book – Rel. 3 & Higher

3.2.5. Creating Party Ledgers (Sundry Debtor / Sundry Creditor) ................................................... 40

Practical Assignment - 3

3.2.6. Creating GST Ledger ( CGST / SGST / IGST ) under Duty and Taxes Group. ............................ 44

Practical Assignment - 4

3.2.7. Creating Sales and Purchase Ledgers for GST Compliance: ................................................... 46

Practical Assignment - 5

3.2.8. Creating Expenses and Income Ledgers without GST Compliance ........................................ 49

Practical Assignment - 6

3.2.9. Creating Service Ledger with GST Compliance ..................................................................... 51

Practical Assignment - 7

3.2.10. Creation of Ledger ‘Rounded off (+/-)’ for rounding the Invoice Value automatically. ........ 53

CHAPTER-4
INVENTORY / ITEMS & GOODS / STOCK

4.1. Creating a Stock Group .................................................................................................. 56


4.1.1. Modifying / Deleting a Single Stock Group ........................................................................... 57

Practical Assignment - 8

4.2. Creation of Stock Units of Measure ................................................................................ 59


4.2.1. Simple Units of Measure ..................................................................................................... 59
4.2.2. Compound Units of Measure ............................................................................................... 60
4.2.3. Alternation / Deletion of Stock Units ................................................................................... 61
4.3. Creation of Stock Items .................................................................................................. 61
4.3.1. Apply GST Rate and HSN/SAC Details in Stock Item .......................................................... 63

Practical Assignment - 9

4.3.2. Setting MRP details in Stock Items ....................................................................................... 68


4.3.3. Setting ‘Nil-Rated’ , ‘Exempted’, ‘Zero Rated’ & ‘ Non-GST’ Items & Goods using TallyPrime69
4.3.3.1. Setting Nil-Rated & Exempted items and Goods : .......................................................... 70

TallyPrime Book (Advanced Usage) Page: 5 Visit us: www.TallyPrimeBook.com


– Rel. 3 & Higher
A Practical Hands-on Self-Study Approach TallyPrime Book – Rel. 3 & Higher

Practical Assignment - 10

4.3.3.2. Setting Non-GST Goods : ............................................................................................... 70

CHAPTER-5
VOUCHERS in TallyPRIME-3.*

5.1. Purchase Voucher (F9) ................................................................................................... 72


(A) Local Purchase (within State) ............................................................................................. 72
(B) Interstate Purchase (outside State) .................................................................................... 73
(C) Purchase Voucher with some Additional Charges/ Discount etc. ........................................ 74
>> Creation of Additional Charges Ledger included before GST in Purchase Bill ......................... 74
>> Creation of Additional Charges Ledger included after GST in Purchase Bill ............................ 75
>> Purchase Bill Voucher with Additional Charges / Discount both before and after GST ........... 76

Practical Assignment - 11

5.1.1. Record Expenses with GST in Purchase Voucher (F9) ........................................................... 80

Practical Assignment - 12

5.1.2. Purchase of Capital Goods with GST in Purchase Voucher (F9) ............................................. 83

Practical Assignment - 13

5.1.3. Purchase of ‘Nil-Rated’, ‘Exempted’, Items & Goods using TallyPrime.................................. 85


5.2. Purchase Return / Debit Note Voucher (Alt+F5) .............................................................. 86
(A) Item Invoice Mode : ................................................................................................................. 86
(B) Accounting Invoice Mode :....................................................................................................... 87

Practical Assignment - 14

5.3. Sales Invoice (F8) – ........................................................................................................ 88


5.3.1. Alter Pre-defined ‘Sale’ Voucher Types in TallyPrime ........................................................... 88
5.3.1.1. ‘General’ Setting in Voucher Type ................................................................................. 90
5.3.1.1.(A) Method of Voucher Numbering .......................................................................... 90
5.3.1.1.(B) Configure in Method of Voucher Numbering for GST:................................................ 91
5.3.1.2. A further discussion on these options is necessary. ................................................ 93
5.3.1.3. ‘Printing’ Setting in Voucher Type ................................................................................ 94
5.3.1.4. ‘Name of Class’ Setting in Voucher Type ...................................................................... 95
5.3.2. Voucher Classes for Sale Voucher ........................................................................................ 95
5.3.3. Sale Voucher with Item Invoice for GST Compliance ............................................................ 99

TallyPrime Book (Advanced Usage) Page: 6 Visit us: www.TallyPrimeBook.com


– Rel. 3 & Higher
A Practical Hands-on Self-Study Approach TallyPrime Book – Rel. 3 & Higher

5.3.4. Sale of Goods and Services in a Single Invoice with multiple GST Rate. .............................. 100
5.3.5. GST Sale of a Composite Supply (Sale of Items & Goods with Expenses Apportioning) ...... 102
5.3.6. Sale of ‘Nil-Rated’ , ‘Exempted’, Supplies using TallyPrime-3.*........................................... 105
5.3.7. Ledger to Round-off the Invoice Value Automatically in Sale Invoice. ................................ 106
5.3.8. Zero Valued Entries in Sale Invoice ..................................................................................... 107
Creating Zero Valued Entries ( Sale of Free Product ) ............................................................... 108
5.3.9. Different Actual and Billed Quantities in Sale Invoice ......................................................... 110
5.3.10. Enable Item Rate (Inclusive of Tax) in Sale Invoice ........................................................... 111
5.3.10.1. Enable Item Rate (Inclusive of Tax) at the time of Item Creation / Alternation mode :
............................................................................................................................................... 111
5.3.10.2. Activation of Item Rate Inclusive of Tax in F12: Configuration during Sale Entry. ....... 112

Practical Assignment - 15

5.3.11. Sale Voucher with Accounting Invoice for Service Ledger................................................. 119
(A) Sale Invoice with Service Charges within State (CGST / SGST) ....................................... 120

Practical Assignment - 16

(B) Sale Invoice with Service Charges Outside State (IGST)................................................. 123

Practical Assignment - 17

5.4. Sales Return / Credit Note ( Alt+F6) ...............................................................................124


(A) Item Invoice Mode ............................................................................................................. 125
(B) Accounting Invoice Mode................................................................................................... 125

Practical Assignment - 18

5.5. Contra Voucher (F4) .....................................................................................................128


5.5.1. Voucher Classes for Contra Voucher .................................................................................. 130
(A) For ‘Cash Deposit’ Class under Contra Voucher .................................................................. 131
(B) For ‘Cash Withdrawal’ Class under Contra Voucher ............................................................ 132
(C) For ‘Fund Transfer’ Class under Contra Voucher ................................................................. 132

Practical Assignment - 19

5.6. Payment Voucher (F5) ..................................................................................................134


5.6.1. Voucher Classes for Payment & Receipt Voucher ............................................................... 134

Practical Assignment - 20

TallyPrime Book (Advanced Usage) Page: 7 Visit us: www.TallyPrimeBook.com


– Rel. 3 & Higher
A Practical Hands-on Self-Study Approach TallyPrime Book – Rel. 3 & Higher

5.7. Receipt Voucher(F6) .....................................................................................................142


5.7.1. Voucher Classes for Payment & Receipt Voucher ............................................................... 143

Practical Assignment - 21

5.8. Journal Vouchers (F7): ..................................................................................................146

Practical Assignment - 22

CHAPTER-6
GST REPORTS TO FILE GST RETURNS IN TallyPRIME-3.*

6.1. Track GST Return Activities ...........................................................................................150


6.1.1. Corrections Needed ..................................................................................................... 151
6.1.2. Pending for Export ....................................................................................................... 152
6.1.3. Exceptions in Reconciliation......................................................................................... 152
6.1.4. Pending to be Signed ................................................................................................... 153
6.2. GSTR -1 Report in TallyPrime .........................................................................................154
6.2.1. Return View of GSTR-1 ...................................................................................................... 155
6.2.1.1. Total Vouchers | View Statistics & Verify Details (GSTR-1 Report) ............................... 156
6.2.1.2. Return View | View GST Details in the Portal Format (GSTR-1 Report) ........................ 159
6.2.2. Nature View of GSTR-1 Report ........................................................................................... 163
6.2.3. Export GSTR-1 Report from TallyPrime-3.* in the JSON Format.......................................... 164
6.2.4. Sign GSTR-1 ....................................................................................................................... 166
6.2.4.1. Undo Signing GSTR-1 .................................................................................................. 166
6.3. GSTR -3B Report in TallyPrime .......................................................................................167
6.3.1. View Your GST Details in GSTR-3B Report .......................................................................... 167
6.3.1.1. Header | View Company Information ................................................................... 168
6.3.1.2. Total Vouchers | View Statistics & Verify Details .................................................. 168
6.3.1.3. Return View | View GSTR-3B Details in the Format of the Portal .......................... 170
6.3.2. Nature View of GSTR-3B Report......................................................................................... 172
Liability (Including Inward Reverse Charge Supplies):............................................................... 173
Input Tax Credit:...................................................................................................................... 174
Breakup of Eligible & Ineligible Input Tax Credit: ..................................................................... 175
6.3.3. Export GSTR-3B in the JSON Format to File Return in GST Portal ........................................ 175
6.3.3.1. Sign GSTR-3B .............................................................................................................. 177
6.3.3.2. Undo Signing GSTR-3B ................................................................................................ 177
6.4. GST Annual Computation Report in TallyPrime...............................................................178
6.4.1. Vouchers Recorded for the Period ..................................................................................... 180

TallyPrime Book (Advanced Usage) Page: 8 Visit us: www.TallyPrimeBook.com


– Rel. 3 & Higher
A Practical Hands-on Self-Study Approach TallyPrime Book – Rel. 3 & Higher

6.4.1.1. Resolution of Uncertain Transactions.......................................................................... 180


6.4.2. Liability, Input Tax Credit, HSN/SAC Summary.................................................................... 181

CHAPTER-7
e-Way Bill using TallyPRIME-3.*

7.1. Enable / Setup e-Way Bill in TallyPrime .........................................................................182


7.2. Create e-Way Bill Profile on the Portal. .........................................................................183
7.3. Generate Online e-Way Bill. ..........................................................................................186
7.4. Generate Manual e-Way Bill in Portal. ...........................................................................190
7.5. Print the invoice with e-Way Bill number .......................................................................194

CHAPTER-8
GST on Reverse Charge Mechanism (RCM) in TallyPRIME-3.*

8.1. Set Up Goods / Services Under Reverse Charge Mechanism (RCM) .................................196
8.1.1. Configure Stock Item for RCM ...................................................................................... 197
8.1.2. Configure Service Ledger for RCM ................................................................................ 198
8.1.3. Record inward supply of Goods under Reverse Charge Mechanism-RCM ..................... 198
8.1.4. Record inward supply of Services under Reverse Charge Mechanism-RCM .................. 200
8.1.5. Manage Purchase Returns Under Reverse Charge Mechanism-RCM ............................ 202

CHAPTER-9
ORDER Processing in TallyPRIME-3.*

Order Processing in TallyPrime ............................................................................................203


9.1. Purchase Order (Ctrl+F9) Processing in TallyPrime .........................................................203
9.1.1. Receipt Note Voucher (GRN) (Alt+F9) against Purchase Order ........................................... 204
9.1.2. Purchase Voucher (F9) against Receipt Note Voucher (GRN).............................................. 207
9.1.3. Purchase Order Outstanding ............................................................................................. 210
9.1.3.1. Purchase Order – Stock Group .................................................................................... 210
9.1.3.2. Purchase Order – Stock Item....................................................................................... 211
9.1.3.3. Purchase Order – Group ............................................................................................. 211
9.1.3.4. Purchase Order – Ledger............................................................................................. 212
9.2. Sales Order (Ctrl+F8) Processing in TallyPrime ...............................................................213
9.2.1. Delivery Note (Alt+F8) Against Sales Order ........................................................................ 215
9.2.2. Sale Invoice (F8) Against Delivery Note .............................................................................. 216

CHAPTER-10
Bill of Material (BOM) for Manufacturing

TallyPrime Book (Advanced Usage) Page: 9 Visit us: www.TallyPrimeBook.com


– Rel. 3 & Higher
A Practical Hands-on Self-Study Approach TallyPrime Book – Rel. 3 & Higher

Bill of Materials (BoM) for Manufacturing/Assembling .........................................................218


10.1. Setup Bill of Materials (BOM) ......................................................................................218
10.2. Creating a Manufacturing Voucher ..............................................................................221

CHAPTER-11
Price Levels & Price List

Price Levels & Price List .......................................................................................................223


11.1. Price Levels in TallyPrime ............................................................................................223
11.1.1. Create Price Levels .......................................................................................................... 223
11.1.2. Price List in TallyPrime ..................................................................................................... 224
11.1.3. Assign Price Levels to Ledger Accounts ............................................................................ 227
11.2. Use Price Levels & Price List during Voucher Entry .......................................................229

CHAPTER-12
Cost Center & Cost Categories

Cost Centre and Cost Category ............................................................................................230


12.1. Creating Cost Category and Cost Centre ......................................................................231
12.2. Applying Cost Centres to Ledger Accounts ...................................................................233
12.3. Cost Centres Allocation in Voucher Entry .....................................................................234

CHAPTER-13
TDS (Tax Deducted at Source)

TDS (Tax Deducted At Source) .............................................................................................235


13.1. Enabling TDS in TallyPrime ..........................................................................................235
13.2. Creating TDS Nature of Payment .................................................................................236
13.3. Creating Master Ledger with TDS Transaction i.e. Expenses, Party Ledger, TDS Ledger ..238
Step-1: Alter Expenses Ledger i.e. Rent Paid ............................................................................ 238
Step-2: Alter Party Ledger i.e. N. Jatania & Co ( Under Sundry Creditor) as below : .................. 239
Step-3 : Create TDS Ledger i.e. TDS on Rent ............................................................................. 240
Step-4: TDS Transaction (Accounting for TDS on Expenses) ..................................................... 240
13.4. TDS on Advance Payment against Expenses .................................................................241
13.5. Recording Payment Transaction (TDS) .........................................................................242

CHAPTER-14
Optional & Non-Accouning Vouchers

Optional & Non-Accounting Vouchers ..................................................................................243


14.1. Memo (Memorandum) Voucher ..................................................................................243

TallyPrime Book (Advanced Usage) Page: 10 Visit us: www.TallyPrimeBook.com


– Rel. 3 & Higher
A Practical Hands-on Self-Study Approach TallyPrime Book – Rel. 3 & Higher

14.2. Optional Voucher .......................................................................................................244


14.3. Post-dated Voucher ....................................................................................................245
14.4. Physical Stock Voucher (Ctrl + F7) ................................................................................246
14.5. Stock Journal Voucher (Alt+F7) ....................................................................................247
Additional Cost on Purchase in Stock Journal :............................................................................. 248
14.6. Rejection In Voucher ..................................................................................................249
14.7. Rejection Out Voucher ................................................................................................250

CHAPTER-15
REPORTS in TallyPRIME-3.*

REPORTS IN TallyPrime ........................................................................................................251


15.1. Modifying Reports ......................................................................................................252
15.2. Display Financial Statements in TallyPrime ..................................................................254
15.2.1. Balance Sheet in TallyPrime ............................................................................................. 255
Set Closing Stock Manually in the Balance Sheet ..................................................................... 255
15.2.2. Profit & Loss Account in TallyPrime.................................................................................. 257
15.2.3. Receipts and Payments Report in TallyPrime ................................................................... 259
15.2.4. Trial Balance in TallyPrime ............................................................................................... 260
15.3. Display Books, Registers and Ledgers...........................................................................261
15.3.1. Sales Register Report in TallyPrime .................................................................................. 262
15.3.1.1. Columnar Sales Register............................................................................................ 263
15.3.1.2. Extract of Sales Register ............................................................................................ 263
15.3.2. Purchase Register Report in TallyPrime............................................................................ 264
15.3.3. Cash /Bank Book Report in TallyPrime ............................................................................. 266
15.3.4. Statement of Accounts Report in TallyPrime .................................................................... 268
15.3.5. Journal Register Report in TallyPrime .............................................................................. 269
15.3.6. Day Book Report in TallyPrime......................................................................................... 270
15.4. Display Inventory Reports and Statements...................................................................271
15.4.1. Stock Summary Report in TallyPrime ............................................................................... 272
15.4.2. Stock Items Report in TallyPrime ..................................................................................... 273
Viewing Stock Item Vouchers .................................................................................................. 274
15.4.3. Godown / Location Summary Report in TallyPrime .......................................................... 274
15.4.4. Movement Analysis Report in TallyPrime......................................................................... 275
15.4.4.1. Movement Analysis (Stock Group Analysis) ............................................................... 275
15.4.4.2. Stock Item Movement Analysis ................................................................................. 276
15.4.4.3. Accounts Group Movement Analysis......................................................................... 276
15.4.4.4. Ledger Movement Analysis ....................................................................................... 277
15.4.4.5. Transfer (Movement) Analysis .................................................................................. 277

TallyPrime Book (Advanced Usage) Page: 11 Visit us: www.TallyPrimeBook.com


– Rel. 3 & Higher
A Practical Hands-on Self-Study Approach TallyPrime Book – Rel. 3 & Higher

15.4.5. Stock Ageing Analysis Report in TallyPrime ...................................................................... 278


15.4.5.1. Changing the Default Ageing Period .......................................................................... 279
15.5. Display Management Information System(MIS) Reports ...............................................280
15.5.1. Cost Centre Reports......................................................................................................... 280
15.5.2. Ratio Analysis Reports ..................................................................................................... 280
15.5.3. Cash Flow Reports ........................................................................................................... 282
15.5.4. Funds Flow Statement Reports ........................................................................................ 283
15.5.5. Exception Reports ........................................................................................................... 284
15.5.5.1. Negative Stocks Report ............................................................................................. 285
15.5.5.2. Negative Ledgers Report ........................................................................................... 285
15.5.5.3. Memorandum Voucher Register Report.................................................................... 285
15.5.5.4. Optional Vouchers Register Report ........................................................................... 286
15.5.5.5. Post Dated Vouchers Register Report........................................................................ 286

CHAPTER-16
OTHER UTILITIES in TallyPRIME-3.*

16.1. Security Control ..........................................................................................................286


16.1.1. Set Password in TallyPrime .............................................................................................. 287
16.1.2. Use Security Control ........................................................................................................ 287
16.1.2.1. Creating Users and Passwords .................................................................................. 288
16.1.2.2. Creating and Setting Up Voucher Type Security for Users.......................................... 289
16.1.3. TallyVault Password......................................................................................................... 291
16.2. Year-end Processing & Moving Company Data to Next Financial Year ...........................293
16.2.1. Change Current Period .................................................................................................... 293
16.2.2. Create New Company and Import the Opening Balances ................................................. 293
Export closing balances from old company .............................................................................. 293
Import Masters of closing balances as opening balances in new company ............................... 295
16.3. Splitting Company Data based on Financial Year ..........................................................295
16.4. Group Company in TallyPrime .....................................................................................297
Creating a Group Company ......................................................................................................... 297

TallyPrime Book (Advanced Usage) Page: 12 Visit us: www.TallyPrimeBook.com


– Rel. 3 & Higher
A Practical Hands-on Self-Study Approach TallyPrime Book – Rel. 3 & Higher

Practical Assignments with GST using TallyPRIME-3.*


ASSIGNMENT-1 [COMPANY CREATION] ......................................................................................299
ASSIGNMENT-2 [GST ACTIVATION] ............................................................................................299
ASSIGNMENT-3 [ACCOUNT GROUPS CREATION] ............................................................................300
ASSIGNMENT-4 [CREATING LIABILITIES / ASSETS LEDGER] ...............................................................300
ASSIGNMENT-5 [CREATING PARTY LEDGERS – SUNDRY CREDITOR / SUNDRY DEBTOR] ..........................302
ASSIGNMENT-6 [CREATING GST LEDGERS – ( IGST / CGST / SGST ) ] ..............................................303
ASSIGNMENT-7 [CREATING SALES & PURCHASE LEDGERS ] ..............................................................303
ASSIGNMENT-8 [CREATING INCOME & EXPENSES LEDGERS ] ............................................................303
ASSIGNMENT-9 [CREATING STOCK GROUP ] .................................................................................306
ASSIGNMENT-10 [CREATING UNIT OF MEASUREMENT ] ..................................................................306
ASSIGNMENT-11 [CREATING STOCK ITEMS / PRODUCTS / GOODS ] ...................................................306
ASSIGNMENT-12 [ALTERING VOUCHERS CLASS – SALES I.E . GST ].....................................................307
ASSIGNMENT-13 [ENTERING PURCHASE VOUCHER ] .......................................................................308
ASSIGNMENT-14 [ENTERING PURCHASE VOUCHER TO RECORD EXPENSES] ..........................................309
ASSIGNMENT-15 [PURCHASE VOUCHER OF NIL-RATED, EXEMPTED ITEMS] .........................................310
ASSIGNMENT-16 [ENTER PURCHASE RETURN / DEBIT NOTE VOUCHER] ..............................................310
ASSIGNMENT-17 [ENTER SALE VOUCHER] ....................................................................................310
ASSIGNMENT-18 [SALE VOUCHER OF NIL-RATED, EXEMPTED ITEMS] .................................................312
ASSIGNMENT-19 [ENTER RECEIVED VOUCHER] .............................................................................312
ASSIGNMENT-20 [ENTER PAYMENT VOUCHER] .............................................................................313
ASSIGNMENT-21 [ENTER CONTRA VOUCHER – CASH DEPOSIT, CASH WITHDRAWAL, FUND TRANSFER] .....315
ASSIGNMENT-22 [ENTER JOURNAL VOUCHER] ..............................................................................317
ASSIGNMENT-23 [RANDOM VOUCHER ENTRY MONTH-WISE FROM MAY 2023] ...................................318
MAY - 2023 .........................................................................................................................318
JUNE - 2023 ........................................................................................................................319
JULY - 2023 .........................................................................................................................320
AUGUST - 2023 ...................................................................................................................322
SEPTEMBER – 2023 .............................................................................................................323

TallyPrime Book (Advanced Usage) Page: 13 Visit us: www.TallyPrimeBook.com


– Rel. 3 & Higher
A Practical Hands-on Self-Study Approach TallyPrime Book – Rel. 3 & Higher

(A) Download and Install TallyPrime-3.


Activate/Reactivate License or Migrate your
Existing Company.
You can install TallyPrime on any computer with 64-bit edition of Microsoft Windows 7 or
later.
1. Download the setup.exe file from : https://tallysolutions.com/download/
2. Select the folder where you want to save. Then double-click setup.exe to install
TallyPrime.
3. This will ask for Existing Tally Application(earlier) from Drive or Install New

4. When we Install New, Configure Application Path, if needed.

 So click Application Path.


 Click … and change the path as needed.

 Close the List of Configurations window.


Note: If you are already using TallyPrime, it is recommended that you install TallyPrime in
a different folder. This will allow you to use both the products simultaneously, if needed.
5. Click Install.

TallyPrime Book (Advanced Usage) Page: 14 Visit us: www.TallyPrimeBook.com


– Rel. 3 & Higher
A Practical Hands-on Self-Study Approach TallyPrime Book – Rel. 3 & Higher

The application gets installed, and the following window opens.

6. Click Start TallyPrime to launch TallyPrime.


You can activate the license and start using TallyPrime.

After activating the license, you can create your first Company and start using TallyPrime
for business transactions.
7. In case of Reactivating Existing License, Enter the Tally.NET ID and Password. Select the
required TallyPrime license.

TallyPrime Book (Advanced Usage) Page: 15 Visit us: www.TallyPrimeBook.com


– Rel. 3 & Higher
A Practical Hands-on Self-Study Approach TallyPrime Book – Rel. 3 & Higher

Once the license is configured to the Tally Gateway Server, you will receive the following
message.
8. Select Yes to activate. Select the required Company to continue.

Your TallyPrime application is now licensed. You can start using TallyPrime for business
transactions.
9. Open the required Company.
You will be prompted to do a migration.

Click Migrate.

The Company will be migrated, and will remain open for you to continue.

(B) Migrate Company Data to TallyPrime-3


TallyPrime comes with a reliable tool to migrate your existing company data and make it
compatible. TallyPrime is a significant upgrade to your Tally experience, and therefore it is
essential for you to convert your data.
TallyPrime will detect your data from earlier releases (Tally.ERP 9 to TallyPrime), and guide
you in the migration process. All your transactions, along with your company features,
masters, security settings, and so on, will be carried forward seamlessly.
In TallyPrime, you can migrate a company by selecting a company from the earlier
TallyPrime release or Alt+Y (Data) and select the company to Migrate.

TallyPrime Book (Advanced Usage) Page: 16 Visit us: www.TallyPrimeBook.com


– Rel. 3 & Higher
A Practical Hands-on Self-Study Approach TallyPrime Book – Rel. 3 & Higher

1. Press Alt+F3 (Select Company) to open the List of Companies.


You can see the status Migration Required against the companies which are on a lower
release.

Alternatively, you can also migrate your data from by pressing …


2. F1 (Help) > Troubleshooting > Migrate.

TallyPrime Book (Advanced Usage) Page: 17 Visit us: www.TallyPrimeBook.com


– Rel. 3 & Higher
A Practical Hands-on Self-Study Approach TallyPrime Book – Rel. 3 & Higher

Select the company that you want to migrate and press Enter. If the company has a
username and password, you will be asked to enter the details.
3. Press R (Migrate) to continue. If you want to alter the backup path and data location
before migrating, then press C (Configure).

After migration is complete, your company data is ready to be used in TallyPrime-3.


A summary of the migration is displayed with before and after migration statistics, as all
the masters and vouchers are safely migrated with or without any data exception

The company data in the latest release of TallyPrime will be available as a 6-digit company
number. For your easy reference the, the company number of the source data is prefixed
with a zero (0) so that you can easily identify which company was migrated. In addition, the
5-digit source company is retained in the same data location and renamed as a folder.
For example, if you migrate the company National Enterprises (10000) to TallyPrime Release
3.0, the migrated company data is numbered as National Enterprises (010000), and the
source company is retained but renamed as ‘10000-migrated-to-3.0’.

TallyPrime Book (Advanced Usage) Page: 18 Visit us: www.TallyPrimeBook.com


– Rel. 3 & Higher
A Practical Hands-on Self-Study Approach TallyPrime Book – Rel. 3 & Higher

If there are any issues in the company data, it is recommended that you repair the data
before migrating.

Home Screen :
When you open TallyPrime, you can see a home screen with different items –
 a top menu bar with pull down options,
 the details of the Companies that are open,
 the Gateway of Tally menu, and
 a button bar on the right-hand side of the screen.

TallyPrime Book (Advanced Usage) Page: 19 Visit us: www.TallyPrimeBook.com


– Rel. 3 & Higher
A Practical Hands-on Self-Study Approach TallyPrime Book – Rel. 3 & Higher

CHAPTER-1
COMPANY CREATION
Swayam Sales is one Departmental Store in Balasore, Odisha, with GSTN No - 21AGHPB2764P1ZD
deals with both Whole selling & Trading of different types of Products like … Electronics, Electrical
Home Appliance, Mobiles etc. etc. with the following information’s and will maintain his Books of
Accounts with the help of TallyPrime Accounting Software with effect from 01-04-2023.

Swayam Sales
Balasore, Odisha – 756001 (India)
GSTN - 21AGHPB2764P1ZD
Mob – 9437264738
Website : www.tallyprimebook.com
eMail ID : [email protected]

1.1. Company Creation:


You can create a Company profile by using the following procedure :
1. Press Alt+K > Create.

Alternatively, at the Gateway of Tally, press F3 > Company > Create Company

TallyPrime Book (Advanced Usage) Page: 20 Visit us: www.TallyPrimeBook.com


– Rel. 3 & Higher
A Practical Hands-on Self-Study Approach TallyPrime Book – Rel. 3 & Higher

The Company Creation screen appears.

Note :
In case you want to specify additional details for your Company, press F12 on the Company
Creation screen.

F12 Configure options


 Provide Contact Details – To show the options to capture the company contact
details.
 Set Edit Log Applicability : This is optional, available from TallyPrime Release 2.1 onwards.
You can enable Set Edit Log applicability under F12 and enable Edit Log for the
Company. This will help you to view Edit Log for the future activities that you will
perform in masters and transactions.
 Use TallyVault Password to encrypt Company Data – To show the option to set
TallyVault Password.
 Use User Access Control – To show the option to enable user-based access to the
Company.
 Provide Additional Base Currency details – To show options to specify additional
details of the Base Currency.

TallyPrime Book (Advanced Usage) Page: 21 Visit us: www.TallyPrimeBook.com


– Rel. 3 & Higher
A Practical Hands-on Self-Study Approach TallyPrime Book – Rel. 3 & Higher

Finally, confirm company creation by pressing the ENTER key/ “Y” key or Ctrl+A to accept all
declaration for the Company.
Saving the company takes you to the Company Features screen, which displays that the company is
created successfully.
1. Enable the required features for your Company.

You can enable or disable any of these features later.


2. Press Ctrl+A to save the selected features.
You can press Esc thrice to close the features screen, if you do not need to change any.
Books and Financial Year Details:

 Financial year begins from : TallyPrime pre-fills this field based on the date settings of your
computer and the Country selected in the Company Creation screen.
For example, if your computer date is set to 06-06-2023 and the region is set to India, the financial
year is pre-filled as 01-04-2023.
 Books beginning from : By default, TallyPrime fills this field with the Financial year begins
from date. You can update this, as needed.
For example, you started to maintain your Books of Accounts in TallyPrime from 1-June-2023. You can
update the Books beginning from date to 1-June-2023, while the financial year will be 1-Apr-2023.
(Now you will be able to work with the Current Company)
The first Screen is called Gateway of Tally (Home Screen).

TallyPrime Book (Advanced Usage) Page: 22 Visit us: www.TallyPrimeBook.com


– Rel. 3 & Higher
A Practical Hands-on Self-Study Approach TallyPrime Book – Rel. 3 & Higher

Top Menu :

Top Menu has options to manage your Companies, TallyPrime application, users in your
Companies, and your data storage & sharing. This menu and child items in the menu are
accessible from any screen in TallyPrime.
F1 : Help Menu ..

Help menu has options to launch TallyHelp and to upgrade your application to a newer
release of the product. Availability of a newer release is indicated with a red dot notification
on the menu name Help. Other options under the Help menu include …
 What’s New,
 TallyShop for buying add-ons,
 Troubleshooting to repair your application and data in case there are issues,
 Settings to configure your application,
 TDL & Add-On to manage your extensions/customisations, and an
 About report that shows the details of your TallyPrime installation and its
environment.

TallyPrime Book (Advanced Usage) Page: 23 Visit us: www.TallyPrimeBook.com


– Rel. 3 & Higher
A Practical Hands-on Self-Study Approach TallyPrime Book – Rel. 3 & Higher

G : Go To .. (Alt+G)

 Go To option on the top menu helps you to quickly access any report or feature that
you want to use.
 Any screen that you access using Go To will open on top of the current screen, and
closing the screen will take you back to the screen that was open earlier.
 You can use Alt+G to access Go To.
Right-Button Bar :

Right Button Bar on the home screen of TallyPrime has two buttons F2: Date and F3:
Company.
On pressing Alt key the options change to F2: Period and F3: Select Company.
Pressing Ctrl+F3 keys show the option Shut Company.
Alternatively, you can click the expand option, < next to each button to view the
corresponding options.
Options on the right button bar change based on the screen that is open as per the actions
relevant to the screen or the transaction you are working on.
However, the shortcuts associated with different options are consistent across masters,
vouchers and reports. For example, F2 is always for date, Alt+F2 is for period, F10 in master
screens is for Other Masters & voucher screens is for Other Vouchers, and Ctrl+B in reports
is for Basis of Values.
In a similar manner, there are predefined list of buttons for different actions. Check
different buttons when you are on different screens to know these options better.

TallyPrime Book (Advanced Usage) Page: 24 Visit us: www.TallyPrimeBook.com


– Rel. 3 & Higher
A Practical Hands-on Self-Study Approach TallyPrime Book – Rel. 3 & Higher

1.2. Opening (Loading) the Company in TallyPrime:


Once you have created a company, you can load/open the company in one of the following ways:
1. Press Alt+K > Select ( Alt+F3)

Alternatively, at the Gateway of Tally, press Alt+F3 > Company > Select Company from the List of
Companies.
If you have created more than one company, you can browse to the data path and select
the required company to open.

Load company on Start-up


If you wish to load one or more companies by default, whenever you open TallyPrime, you
can configure the same.
1. Open the Startup Settings screen: Press F1 (Help) > Settings > Startup.

TallyPrime Book (Advanced Usage) Page: 25 Visit us: www.TallyPrimeBook.com


– Rel. 3 & Higher
A Practical Hands-on Self-Study Approach TallyPrime Book – Rel. 3 & Higher

2. Set the option Load companies on startup to Yes, and press Enter on Companies
to load.

3. In the List of Companies to Load on Startup screen, select one or more companies,
based on your need.
4. Select End of List, after your have selected the companies to be loaded on startup.

The companies that you select here will be loaded by default next time you open TallyPrime.

1.3. Modification | Update | Alter Company Details |


Delete Company
If your company address, phone number, or any other contact information was not provided earlier
or has changed, you can update such details in TallyPrime. Any changes made to these details will be
reflected accordingly in your reports and printed invoices.
1. Press Alt+K > Alter

TallyPrime Book (Advanced Usage) Page: 26 Visit us: www.TallyPrimeBook.com


– Rel. 3 & Higher
A Practical Hands-on Self-Study Approach TallyPrime Book – Rel. 3 & Higher

Alternatively, at the Gateway of Tally, press F3 > Company > Alter Company

If you do not need the company anymore, you can delete the company as well by pressing Alt+D in
Company Alternation mode screen and Press Y (Yes).

CHAPTER-2
GST SETUP USING TALLYPRIME
2.1. Activate GST for Your Company
To use TallyPrime for GST compliance, you need to activate the GST feature. Once activated, GST-
related features are available in ledgers, stock items, and transactions, and GST returns can be
generated.
GST Registrations are of two types…
1. GST Regular Scheme ( for Regular Dealer)
The GST regular scheme is for the general taxpayers whose turnover is above the threshold limit.
Under the GST regular scheme, all individuals with turnover above 40 lacs are required to take GST
Registration. They are required to pay GST on goods & services as per the applicable rates and do
regular GST return filing
2. GST Composition Scheme ( for Composite Dealer)
The composition scheme is meant for small businesses whose turnover of taxable goods not more
than ₹1.5 crores (In case of North-Eastern states and Himachal Pradesh, the limit is now ₹. 75*
lakh.), where GST has to be borne by the seller @1% of such turnover by traders, @2%
by manufacturers, 5% for Restaurants & 6% for Service Providers.

TallyPrime Book (Advanced Usage) Page: 27 Visit us: www.TallyPrimeBook.com


– Rel. 3 & Higher
A Practical Hands-on Self-Study Approach TallyPrime Book – Rel. 3 & Higher

A Composition Dealer has to issue Bill of Supply. They cannot issue a Tax Invoice. This is because the
tax has to be paid by the dealer out of pocket. A Composition Dealer is not allowed to recover the GST
from the customers.

2.1.1. Activate GST for Regular Dealers


To use TallyPrime for GST compliance, you need to activate the GST feature. Once activated, GST-
related features are available in ledgers, stock items, and transactions, and GST returns can be
generated.
1. Open the company for which you need to activate GST.
2. Press F11 (Features) > set Enable Goods and Services Tax (GST) to Yes.

3. Press F12 and enable the required options. You will find configurations related to
Place of Supply, Reconciliation, LUT/Bond, and so on.

4. Fill in the relevant details for GST registration:

TallyPrime Book (Advanced Usage) Page: 28 Visit us: www.TallyPrimeBook.com


– Rel. 3 & Higher
A Practical Hands-on Self-Study Approach TallyPrime Book – Rel. 3 & Higher

a. State: The State selected during Company Creation will be reflected here. If you
update the State here, it will also be updated in the Company and existing
transactions.
b. Registration type: You can select the Registration type as Regular, Composition, or
Regular – SEZ, as per your original GST registration with the department.

c. Assessee of Other Territory: If your business is located in an Exclusive Economic


Zone (Other Territory). then you can enable this option. GST details will be applied
accordingly in your masters and transactions.
d. Periodicity of GSTR-1: Select the Periodicity of GSTR1 as Monthly or Quarterly,
based on the annual turnover of your business
e. Reconciliation Configuration: A few options have been provided to help you with a
smooth GST reconciliation. You can enable them based on your business
preferences.

i. Use Voucher No. & Date as Supplier Invoice No. & Date: Once you enable
this option, the Voucher No. and Date will be considered as the Supplier
Invoice No. and Date during reconciliation. In other words, even if you have
not provided the Supplier Invoice No. and Date, then you don’t have to worry,
as the Voucher No. and Date will be considered.
ii. Ignore zero (0) if prefixed in Supplier Document No.: If your business does
not prefix zeroes in the Document No., but your supplier follows this
practice, then this might lead to a mismatch during reconciliation. However,

TallyPrime Book (Advanced Usage) Page: 29 Visit us: www.TallyPrimeBook.com


– Rel. 3 & Higher
A Practical Hands-on Self-Study Approach TallyPrime Book – Rel. 3 & Higher

once you enable this option, then the prefixed zeroes will be ignored, and
you won’t have to worry about a mismatch.
iii. Ignore special characters if used in Supplier Document No.: If your supplier
prefers to use special characters, such as hyphen and slash, in the document
number, then it might cause issues during reconciliation. However, once you
enable this option, such special characters will be ignored and you will have
a smooth reconciliation.
f. Registration Name: This will be derived from the State selected earlier. For example,
if you have selected Karnataka, then the Registration Name will appear as Karnataka
Registration for easy identification. However, you will have the option to rename
the registration, as needed. For example, if you have many branches or GST
registrations in Karnataka, you can name the branches as Bengaluru Branch,
Mangalore Branch, and so on.
g. Create another GST Registration for the Company: Use this option to save multiple
GST registrations within the same company. After saving the details, you can select
the relevant registration while recording transactions, wherever needed. You can
also create multiple registrations for your company from the Gateway of Tally or Go
To > Create Master > GST Registration

5. Press Ctrl+A to save the details.

CHAPTER-3
SET-UP OF GROUPS/LEDGERS [Charts of Accounts]
TallyPrime gives you great flexibility in setting up your chart of accounts. It allows you to
group your ledger accounts right at the time of creating your accounts chart. Your reports
and statements reflect the desired classification at all times.
List of accounts displays the existing chart of accounts, listed as groups, in alphabetical
order.
 Gateway of Tally > Chart of Accounts > select master type you want to see
in Chart of Accounts.

 Alternatively, press Alt+G (Go To) > type or select Chart of Accounts > select master
type you want to see in Chart of Accounts and press Enter.

TallyPrime Book (Advanced Usage) Page: 30 Visit us: www.TallyPrimeBook.com


– Rel. 3 & Higher
A Practical Hands-on Self-Study Approach TallyPrime Book – Rel. 3 & Higher

3.1. Account Groups in TallyPrime


Groups are collection of ledgers of the same nature. Account groups are maintained to determine the
hierarchy of Ledger Accounts, which is helpful in determining and presenting meaningful and
compliant reports. Using this you can generate reports, which are meaningful as well as compliant
with laws.
At the highest level, accounts are classified into Capital or Revenue – and more specifically into
Assets, Liabilities , Income and Expenditure .
TallyPrime provides you with 28 Pre-defined Groups, of these 15 are Primary Groups and 13 are Sub-
Groups . You can also create your own groups, either as Sub-groups or Primary Groups.
The lowest level would be the Ledger Account. All Voucher entries are passed using ledgers.
TallyPrime has Pre-Defined Ledgers for Cash (under Cash-in-hand group) and for the Profit & Loss A/c
(under primary group).

15 Primary Groups 13 Sub Groups

Branch / Divisions

Capital Account Reserves & Surplus

Bank Accounts
Cash-in-hand
Deposits (Asset)
Current Assets
Loans & Advances (Asset)
Stock-in-hand
Sundry Debtors
Duties & Taxes
Current Liabilities Provisions
Sundry Creditors

Direct Expenses

Direct Incomes

Fixed Assets

TallyPrime Book (Advanced Usage) Page: 31 Visit us: www.TallyPrimeBook.com


– Rel. 3 & Higher
A Practical Hands-on Self-Study Approach TallyPrime Book – Rel. 3 & Higher

Indirect Expenses

Indirect Incomes

Investments

Bank OD A/c
Loans (Liability) Secured Loans
Unsecured Loans

Misc. Expenses (ASSET)

Purchase Accounts

Sales Accounts

Suspense A/c

Out of the 15 Primary Groups, 9 Primary Groups appear in the Balance Sheets that are Capital in
nature and 6 Primary Groups appear under Profit & Loss account which are Revenue in nature.

3.1.1. Create Account Groups (under Single Group) one-


by-one:
1. Gateway of Tally > Create > type or select Group and press Enter.
Alternatively, press Alt+G (Go To) > Create Master > type or select Group and
press Enter.
2. After giving Name to the Group, In the field Under , from the List of Groups displayed, select
the parent group under which the group has to be classified.
For example, Manufacturing Expenses under Direct Expenses .

A new group created under primary will not be reflected in reports until you pass masters /
transactions for that group.
You can also View any Groups…
Go to Gateway of Tally > Chart of Accounts > Groups > Enter
You can also Alter / Modify any Groups …
Go to Gateway of Tally > Alter > Groups > Select or type Group Name and Press Enter to Alter .
Delete a Created Group (No Default Group)

TallyPrime Book (Advanced Usage) Page: 32 Visit us: www.TallyPrimeBook.com


– Rel. 3 & Higher
A Practical Hands-on Self-Study Approach TallyPrime Book – Rel. 3 & Higher

Groups can be deleted from the alteration screen, provided no transactions has been made or no sub-
groups has been created .
Just Pres Alt+D in Alternation screen, and press Y.

3.1.2. Advanced Configurations for Account Groups


1. Gateway of Tally > Create > type or select Group and press Enter.
Alternatively, press Alt+G (Go To) > Create Master > type or select Group and
press Enter.
2. Select F12: Configure (Group Configuration) and enable ‘Yes’ - Show more Configurations.
The group creation screen with advanced options is displayed as shown below:

In the Group Creation screen :

TallyPrime Book (Advanced Usage) Page: 33 Visit us: www.TallyPrimeBook.com


– Rel. 3 & Higher
A Practical Hands-on Self-Study Approach TallyPrime Book – Rel. 3 & Higher

1. Enter a name for the group.


2. Enter a group category. If a group is created under Primary you must select from asset,
expenses, income or liability.
3. Select the Nature of Group .
4. Select Yes for the option Group behaves like sub-ledger? to allow groups to act as a ledger.
 When the option Group behaves like sub-ledger? is set to No , all the ledgers that are grouped
is displayed in detailed mode.
 When the option Group behaves like sub-ledger? is set to Yes , the ledgers grouped under the
same is not displayed in detailed mode.
5. Set Nett Debit/Credit Balances for Reporting? to Yes to display net debit or credit balance in
the report (whichever is higher).
6. Set Used for Calculation (e.g. taxes, discounts)? to Yes if ledgers under this group have
percentages for discounts or taxes to be used in invoice entry. This is displayed while passing
voucher in invoice mode and for automatic calculations.
7. Select Method to Allocate when used in Purchase Invoice from the Allocation Methods list to
allocate the expense of the item in the ratio of the quantity or value.

[Practical Assignment-A]
Create the following Accounts Groups as given in respective Under Pre-defined Groups:
Sundry Debtor :
Corporate Customer
Wholesale Customer
Local Customers
Outside Customers (IGST)
Sundry Creditor:
Local Creditor
Other Creditors
Outside Creditor (IGST)
Indirect Expenses:

TallyPrime Book (Advanced Usage) Page: 34 Visit us: www.TallyPrimeBook.com


– Rel. 3 & Higher
A Practical Hands-on Self-Study Approach TallyPrime Book – Rel. 3 & Higher

Administrative Expenses
Salaries & Staff Expenses
Selling & Distribution Expenses
Indirect Incomes:
Interest Earnings
Other Income

3.2. Ledgers in TallyPrime


A ledger is the actual account head to identify your transactions and are used in all accounting
vouchers.
For example, purchase, payments, sales, receipts, and others accounts heads are ledger accounts.
Without a ledger, you cannot record any transaction.
All Ledgers have to be classified into Groups. These groups and ledgers are classified into Profit and
Loss or Balance Sheet.
The creation and usage of Groups in TallyPrime has been explained earlier. Now you will learn how
TallyPrime works with Ledgers.
Pre-defined Ledgers in TallyPrime
There are two pre-defined ledgers available in TallyPrime, they are:
(i) Cash
This Ledger is created under the Group Cash-in-hand. You can enter the opening balance as on the
date of books beginning from. You can also alter the name and even delete the Ledger.
(ii) Profit and Loss Account
This Ledger is created under the Group Primary. Previous year’s Profit or Loss is entered as the opening
balance for this ledger. The balance entered here is treated as the opening profit/loss and shown in
the Balance Sheet as opening balance of Profit and Loss account in the Liabilities side.
You cannot delete this ledger, but you can modify the same.

3.2.1. Creating a Single LEDGER :


1. Gateway of Tally > Create > type or select Ledger and press Enter.
Alternatively, press Alt+G (Go To) > Create Master > type or select Ledger and
press Enter.

TallyPrime Book (Advanced Usage) Page: 35 Visit us: www.TallyPrimeBook.com


– Rel. 3 & Higher
A Practical Hands-on Self-Study Approach TallyPrime Book – Rel. 3 & Higher

2. Name Box : enter the name of ledger, alias is used for short name.
3. Select the group under which the ledger will be created.
4. You can select Tax Registration type : Regular (required GST No) or Unregistered/Consumer
(No GST No require)

5. Enter the Opening Balance.


F12 : Configure ( Ledger)
Configuring F12 (functional key): You can also configure your ledger creation as per your requirement
by using ‘F12’.
To view and show all Configurations…you have to enable Yes of two option inside Configuration screen.
Show more configurations : Yes
Show all configurations : Yes

TallyPrime Book (Advanced Usage) Page: 36 Visit us: www.TallyPrimeBook.com


– Rel. 3 & Higher
A Practical Hands-on Self-Study Approach TallyPrime Book – Rel. 3 & Higher

3.2.2 Displaying, Altering and Deleting Ledger Accounts


You can alter any information of the ledger master with the except for the closing balance under the
group stock-in-hand.
To display/alter a ledger
 Gateway of Tally > Alter > type or select Ledger Name and press Enter to Alter.
Alternatively, press Alt+G (Go To) > Alter Master > type or select Ledger and press Enter.
To delete a ledger
 Press Alt+D and press Y. ( In Alternation mode screen of Ledger)

Note: You can delete the ledger if no vouchers have been created under it. If you want to delete a ledger
for which vouchers have been created, you have to first delete all the vouchers from that ledger and
then delete the ledger account.

3.2.3. Creating a Current Liabilities / Assets Ledger


Accounts like Outstanding Liabilities, Statutory Liabilities and other minor liabilities can be created
directly under Current Liabilities and Assets can be classified as Current assets and Fixed assets.
The Ledger Creation screen appears as shown above in Para- 3.2.1. :

TallyPrime Book (Advanced Usage) Page: 37 Visit us: www.TallyPrimeBook.com


– Rel. 3 & Higher
A Practical Hands-on Self-Study Approach TallyPrime Book – Rel. 3 & Higher

[Practical Assignment-1]
Create the following Assets & Liabilities Ledgers with Opening Balance as given :
In our given Practical Assignment, you must remember all the Bold Letter are Groups (not required to
create) under which you have to create all the Ledgers with given Opening Balance

Note :
1. Don’t Create Closing Stock (Stock in Hand) with Opening Balance of Rs.9,50,000 which will
automatically displayed from Opening Stock of items and goods
2. All Bold Letters are Pre-defined Groups (Not required to be create) to be select while creating
Ledgers.
3. Tax Registration type of all above Ledgers are Unregistered / Consumers ( GST No. Not
required)

Enjoying this Sample?

Buy the Book Online to continue the Full


Book

TallyPrime Book (Advanced Usage) Page: 38 Visit us: www.TallyPrimeBook.com


– Rel. 3 & Higher

You might also like