Read Sample TallyPrime 3
Read Sample TallyPrime 3
Read Sample TallyPrime 3
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.
For
www.TallyPrimeBook.Com
Sanjay Satpathy
(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 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-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
CHAPTER-2
GST SETUP USING TallyPRIME-3.*
CHAPTER-3
SET-UP OF GROUPS/LEDGERS [Charts of Accounts]
Practical Assignment - A
Practical Assignment - 1
Practical Assignment - 2
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
Practical Assignment - 7
3.2.10. Creation of Ledger ‘Rounded off (+/-)’ for rounding the Invoice Value automatically. ........ 53
CHAPTER-4
INVENTORY / ITEMS & GOODS / STOCK
Practical Assignment - 8
Practical Assignment - 9
Practical Assignment - 10
CHAPTER-5
VOUCHERS in TallyPRIME-3.*
Practical Assignment - 11
Practical Assignment - 12
5.1.2. Purchase of Capital Goods with GST in Purchase Voucher (F9) ............................................. 83
Practical Assignment - 13
Practical Assignment - 14
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
Practical Assignment - 18
Practical Assignment - 19
Practical Assignment - 20
Practical Assignment - 21
Practical Assignment - 22
CHAPTER-6
GST REPORTS TO FILE GST RETURNS IN TallyPRIME-3.*
CHAPTER-7
e-Way Bill using TallyPRIME-3.*
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.*
CHAPTER-10
Bill of Material (BOM) for Manufacturing
CHAPTER-11
Price Levels & Price List
CHAPTER-12
Cost Center & Cost Categories
CHAPTER-13
TDS (Tax Deducted at Source)
CHAPTER-14
Optional & Non-Accouning Vouchers
CHAPTER-15
REPORTS in TallyPRIME-3.*
CHAPTER-16
OTHER UTILITIES in TallyPRIME-3.*
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.
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.
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).
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’.
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.
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]
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.
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.
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).
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.
3. Press F12 and enable the required options. You will find configurations related to
Place of Supply, Reconciliation, LUT/Bond, and so on.
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.
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
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.
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
Direct Expenses
Direct Incomes
Fixed Assets
Indirect Expenses
Indirect Incomes
Investments
Bank OD A/c
Loans (Liability) Secured Loans
Unsecured Loans
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.
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)
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.
[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:
Administrative Expenses
Salaries & Staff Expenses
Selling & Distribution Expenses
Indirect Incomes:
Interest Earnings
Other Income
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)
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.
[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)