TallyPrime Book 4.0 Advanced Usage Sample Copy 1
TallyPrime Book 4.0 Advanced Usage Sample Copy 1
TallyPrime Book 4.0 Advanced Usage Sample Copy 1
0 Book
INTRODUCTION
Are you ready to take your TallyPrime skills to the next level? Look no further than the book "TallyPrime 4.0
(Advanced Usage)" written by Sanjay Satapathy. In this comprehensive guide, Mr. Satapathy dives deep into the
advanced features and functionalities of TallyPrime, helping readers unlock the full potential of this powerful
accounting software.
With TallyPrime 4.0, Tally Solutions has introduced several new features and enhancements to make accounting
even more efficient and streamlined. However, fully harnessing these capabilities requires a deeper understanding
of the software's advanced functionalities. This is where Sanjay Satapathy's book comes in.
Mr. Satapathy, a renowned expert in Tally and accounting, brings his years of experience and expertise to the
table. His book serves as a comprehensive resource for both beginners and experienced users who want to explore
the advanced features of TallyPrime 4.0.
TallyPrime is a popular accounting software used by businesses of all sizes to manage their financial transactions
and streamline their operations. While the basic usage of TallyPrime is fairly straightforward, this book delves into
the more advanced aspects of the software, equipping readers with the skills to harness its full potential.
Sanjay Satapathy, an experienced Tally expert and author, has meticulously crafted this book to cater to the needs
of professionals, accountants, and business owners who want to enhance their understanding of TallyPrime 4.0
and leverage its advanced features for better financial management.
The book covers a wide range of topics, including Advanced Inventory Management, Advanced GST
Implementation, Advanced Accounting Techniques, Advanced Reporting, Customization and Integration, and
Security Features. Each chapter is designed to provide step-by-step instructions, practical examples, and real-
world scenarios to help readers grasp the concepts and apply them effectively in their day-to-day accounting
activities.
Whether you are a TallyPrime user looking to expand your knowledge or a business owner seeking to optimize
your financial management processes, this book is a valuable resource that will empower you to make the most
of TallyPrime 4.0.
With its comprehensive coverage and user-friendly approach, TallyPrime 4.0 (Advanced Usage) by Sanjay
Satapathy is a must-read for anyone seeking to enhance their proficiency in TallyPrime and elevate their
accounting practices to the next level.
Disclaimer
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.
For
www.TallyPrimeBook.Com
Sanjay Satapathy
(Author)
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.
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 Satapathy
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: `. 800
TallyPrime 4.0
Table of Contents
CHAPTER-1
‘COMPANY’ Setup Using TallyPrime
“COMPANY” SETUP USING TallyPrime ........................................................................18
1.2. Opening (Loading) the Company in TallyPrime: .....................................................22
1.3. Modification | Update | Alter Company Details | Delete Company .......................24
CHAPTER-2
'GST' Setup Using TallyPrime
“GST” SETUP USING TallyPrime ...................................................................................25
2.1. Activate GST for Your Company ............................................................................25
2.1.1. Activate GST for Regular Dealers........................................................................................................... 25
CHAPTER-3
“ACCOUNTING” Setup Using TallyPrime
“ACCOUNTING” SETUP USING TallyPrime ...................................................................27
3.1. Account Groups in TallyPrime ..............................................................................28
3.1.1. Create Account Groups (under Single Group) one-by-one: .................................................................. 29
3.1.2. Advanced Configurations for Account Groups ...................................................................................... 30
[Practical Assignment-1]
Creation of Account Groups
3.2.6. Creating GST Ledger (CGST / SGST / IGST) under Duty and Taxes Group. ............................................ 43
[Practical Assignment-5]
Creation of GST Ledger
3.2.10. Creation of Ledger ‘Rounded off (+/-)’ for rounding the Invoice Value automatically. ...................... 50
CHAPTER-4
“INVENTORY/STOCK/ITEM” Setup Using TallyPrime
“INVENTORY” SETUP USING TallyPrime ......................................................................51
4.1. Creating a Stock Group ........................................................................................52
4.1.1. Modifying / Deleting a Single Stock Group............................................................................................ 54
[Practical Assignment-9]
Creation of Stock Group
CHAPTER-5
'PURCHASE PROCESS' Using TallyPrime
5.4. Additional Charges/ Discount etc. included or Excluded in Assessable Value for GST
Calculation .................................................................................................................71
>> Creation of Additional Charges Ledger included in Assessable Value for GST Calculation in Purchase Bill71
>> Creation of Additional Charges Ledger without Inclusion in Assessable Value for GST Calculation in
Purchase Bill .................................................................................................................................................... 72
5.5. Purchase Bill Voucher with Additional Charges / Discount both Inclusion or Exclusion in
Assessable Value for GST Calculation. .........................................................................72
[Practical Assignment-14]
Purchase of Items & Goods with Additional Charges/ Discount etc. both Local and
Outside State
5.6. Enter the Discount Percentage against each item – without using the Ledger Account 75
[Practical Assignment-15]
Purchase of Items & Goods with Discount Percentage (%) against each items
5.7. Enter Discount Percentage and/or Amount on Item Rates – using the Ledger Account 77
[Practical Assignment-16]
Purchase of Items & Goods with Discount Amount and / Or Percentage (%) against each
items using Discount Ledger
5.9. Purchase of Fixed Assets (Capital Goods) with GST in Purchase Voucher (F9).........82
[Practical Assignment-18]
Creation of Fixed Assets with GST Compliance
5.10. Purchase of ‘Nil-Rated’, ‘Exempted’, Items & Goods using TallyPrime .................86
[Practical Assignment-20]
Purchase of ‘Nil-Rated’, ‘Exempted’, Items & Goods
CHAPTER-6
'SALES PROCESS' Using TallyPrime
“SALES PROCESS” USING TallyPrime ...........................................................................94
6.1. Alter Pre-defined ‘Sale’ Voucher Types .................................................................94
6.1.1. ‘General’ Setting in Voucher Type ......................................................................................................... 95
6.1.1.1. Method of Voucher Numbering .................................................................................................... 96
6.1.1.2. Configure in Method of Voucher Numbering for GST:................................................................... 97
6.1.1.3. A further discussion on these options is necessary. ...................................................................... 98
6.1.1.4. ‘Printing’ Setting in Voucher Type ................................................................................................ 99
6.3.1.5. ‘Name of Class’ Setting in Voucher Type .................................................................................... 100
6.1.2. Voucher Classes for Sale Voucher ....................................................................................................... 100
6.2. Sale Voucher with Item Invoice for GST Compliance ........................................... 104
6.2.1. Sale of Goods and Services in a Single Invoice with multiple GST Rate. ............................................. 104
6.2.3. GST Sale of a Composite Supply (Sale of Items & Goods with Expenses Apportioning) .................... 106
6.3. Sale of ‘Nil-Rated’ , ‘Exempted’, Supplies using TallyPrime .................................. 109
[Practical Assignment-22]
Sale of ‘Nil-Rated’ , ‘Exempted’, Items & Goods
6.4. Ledger to Round-off the Invoice Value Automatically in Sale Invoice. .................. 111
6.5. Zero Valued Entries in Sale Invoice ..................................................................... 112
6.5.1. Creating Zero Valued Entries ( Sale of Free Product) ......................................................................... 112
6.5.2. Sales with Free Items (Different Actual and Billed Quantities in Sale Invoice) ................................... 113
6.6. Enable Item Rate (Inclusive of Tax) in Sale Invoice .............................................. 114
6.6.1. Enable Item Rate (Inclusive of Tax) at the time of Item Creation / Alternation mode : ..................... 114
6.6.2. Activation of Item Rate Inclusive of Tax in F12: Configuration during Sale Entry. .............................. 115
6.7. Sales of Items with Discounts ............................................................................. 116
6.7.1. Sales Discount on the Total Item Amount/Value ............................................................................... 117
6.7.2. Sales with Trade Discount................................................................................................................... 118
6.7.2.1. Display Discount Percentage against each item – without using Ledger Account..................... 118
6.7.2.2. Display Discount Percentage and Amount on Item Rates – using Trade Discount Ledger Account
119
6.8. Manage Selling Price Using Standard Price ......................................................... 121
6.8.1. Specify Standard Selling Price for Stock Item ..................................................................................... 121
6.8.2. Record Sales with Standard Selling Price............................................................................................ 122
[Practical Assignment-23]
Sale of Taxable Items & Goods
6.9. Sale Voucher with Accounting Invoice for Service Ledger .................................... 128
6.9.1. Sale Invoice with Service Charges within State (CGST / SGST) ............................................................ 130
[Practical Assignment-24]
Sale/Transaction of Services in Accounting Invoice with SGT Compliance within State
6.9.2. Sale Invoice with Service Charges Outside State (IGST) ..................................................................... 132
[Practical Assignment-25]
Sale/Transaction of Services in Accounting Invoice with SGT Compliance Outside State
6.11. Debit Note for the Increase in Sale Value ......................................................... 138
CHAPTER-7
' Sales of Goods and Services Using e-Way Bill '
Sales of Goods and Services Using e-Way Bill in TallyPrime ........................................ 139
7.1. Enable / Setup e-Way Bill in TallyPrime ............................................................. 139
7.2. Create e-Way Bill Profile on the e-Way Bill Govt. Portal. .................................... 140
7.3. Generate Online e-Way Bill with Sales in TallyPrime .......................................... 143
7.4. Print the Sales Invoice with e-Way Bill number using TallyPrime ........................ 146
CHAPTER-8
' Printing of Sales Invoice with Multiple Configurations '
9.1. Set Up Goods / Services Under Reverse Charge Mechanism (RCM) ...................... 161
9.1.1. Configure Stock Item for RCM ............................................................................................................ 161
9.1.2. Configure Service Ledger for RCM ...................................................................................................... 162
9.1.3. Record inward supply of Goods under Reverse Charge Mechanism-RCM......................................... 163
9.1.4. Record inward supply of Services under Reverse Charge Mechanism-RCM ...................................... 164
9.1.5. Manage Purchase Returns Under Reverse Charge Mechanism-RCM ................................................ 165
CHAPTER-10
' CONTRA VOUCHER' Using TallyPrime
CHAPTER-11
' PAYMENT VOUCHER' Using TallyPrime
CHAPTER-12
' RECEIPT ' Using TallyPrime
[Practical Assignment-29]
Receipt Transactions
CHAPTER-13
' CONTRA VOUCHER' Using TallyPrime
CHAPTER-14
' GST REPORT' to File GST Return Using TallyPrime
CHAPTER-15
' ORDER PROCESSING' Using TallyPrime
CHAPTER-16
' Bill Of Material (BoM)' for Manufacturing Unit
CHAPTER-20
' Optional & Non-Accounting Vouchers '
CHAPTER-23
' Filter in REPORTS ' using TallyPrime
CHAPTER-24
' Dash Board ' in TallyPrime
ASSIGNMENTS -1 TO 23
' PRACTICAL ASSIGNMENTS '
CHAPTER-1
“COMPANY” SETUP USING TallyPrime
Create a New Company doing business of FMCG with following Information …
Swayam Distribution Point (A Div. of TallyPrimeBook.Com) is one Distributor/Dealer in Balasore,
Odisha, with GSTN No - 21AGHPB2764P1ZD deals with both Whole selling & Trading of different types of Products
like … Electronics, Electrical Home Appliance, Mobiles, Personal & Essential Products 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 & Co. (www.TallyPrimeBook.Com)
Balasore, Odisha – 756001 (India)
GSTN - 21AGHPB2764P1ZD
Mob – 9437264738
Website : www.tallyprimebook.com
eMail ID : [email protected]
Financial Year begins from : 1-4-2023
Books beginning from : 1-4-2023
Note :
Your can change your Local State with your GST No. DUE TO GST TRANSACTIONS. If your put your local state, all
GST transaction with in your state will be CGST & SGST. So while creating Sundry Debtor or Sundry Creditor or
any other Credit Party, their State and GST No. depends your within State transactions or Outside State
Transaction.
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
Note :
In case you want to specify additional details for your Company, press F12 on the Company Creation
screen.
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)
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.
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.
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.
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.
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.
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.
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, 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
CHAPTER-3
“ACCOUNTING” SETUP USING TallyPrime
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.
Branch / Divisions
Bank Accounts
Cash-in-hand
Deposits (Asset)
Current Assets
Loans & Advances (Asset)
Stock-in-hand
Sundry Debtors
Duties & Taxes
Current Liabilities Provisions
Sundry Creditors
Bank OD A/c
Loans (Liability)
Secured Loans
Unsecured Loans
Investments
Fixed Assets
Suspense A/c
Direct Incomes
Direct Expenses
Indirect Expenses
Indirect Incomes
Sales Accounts
Purchase Accounts
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.
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 .
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-1]
Creation of Account Groups
Create the following Accounts Groups with Normal Letter (Italic Letters are Default (or Pre-
defined) Group) …
Current Liabilities (Pre-defined)
Deposit Received
Advances Received
Expenses and Outstanding Payable
Bank Overdraft A/c
Sundry Creditor (pre-defined):
Local Creditor
Other Creditors
Outside Creditor (IGST)
Loan & Advances (Assets)-Pre-defined
Loan to Staff
Loan to Others
Advances given
Sundry Debtor (pre-defined) :
Corporate Customer
Wholesale Customer
Local Customers
Outside Customers (IGST)
Indirect Expenses (pre-defined):
Administrative Expenses-GST
Administrative Expenses
Salaries & Staff Expenses
Selling & Distribution Expenses-GST
Selling & Distribution Expenses