CHAPTER-1

‘COMPANY’ Setup Using TallyPrime

1.2. Opening (Loading) the Company in TallyPrime:

1.3. Modification | Update | Alter Company Details | Delete Company

CHAPTER-2

“GST” Setup Using TallyPrime

2.1. Activate GST for Your Company

2.1.1. Activate GST for Regular Dealers

2.1.2. Set Up Connected GST for Your Business to Manage GST Profile in TallyPrime

2.1.2.1. Enable API Requests on the GST Portal

2.1.2.2. Specify Connected GST Details

CHAPTER-3

“ACCOUNTING” Setup Using TallyPrime

3.1. Account Groups in TallyPrime

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

3.1.2. Advanced Configurations for Account Groups

[Practical Assignment-1]  :  Creation of Account Groups

3.2. Ledgers in TallyPrime

3.2.1. Creating a Single LEDGER:

3.2.2 Displaying, Altering and Deleting Ledger Accounts

3.2.3. Creating a Current Liabilities / Assets Ledger

[Practical Assignment-2]  :  Creation of Asset & Liabilities

3.2.4. Creating Bank Account Ledgers in TallyPrime

[Practical Assignment-3] : Creation of Bank Account

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

3.2.6.  Directly Create Party Ledgers Using GSTIN/UIN (Rel.5)

3.2.7. Online GSTIN Validation in TallyPrime for single Party Ledger (Rel.5)

3.2.8.    View the Filing History of a Party Ledger (Rel.5)

[Practical Assignment-4] : Creation of Debtors and Creditors

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

[Practical Assignment-5] : Creation of GST Ledger

3.2.10. Creating Sales and Purchase Ledgers for GST Compliance:

[Practical Assignment-6]  :  Creation of Sales & Purchase Ledger

3.2.11. Creating Expenses and Income Ledgers without GST Compliance

[Practical Assignment-7]  :  Creation of Income & Expenses Ledger without GST Compliance

3.2.12.  Expenses Ledger with GST Compliance

[Practical Assignment-8]  :  Creation of Expenses with GST Compliance

3.2.13. Creating Service Ledger with GST Compliance

[Practical Assignment-9] :  Creation of Service Ledger with GST Compliance

3.2.14. Incomes Ledger without GST Compliance

[Practical Assignment-10]  :  Creation of Income Ledger without GST Compliance

3.2.15. Income Ledger with GST Compliance

[Practical Assignment-11]  :  Creation of Income Ledger with GST Compliance

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

3.2.17. Ledger of Additional Charges/ Discount etc. included in Assessable Value for GST Calculation

[Practical Assignment-12] :  Creation of Ledgers included in Assessable Value for GST Calculation in Purchase Bill

3.2.18. Creation of Additional Charges Ledger without Inclusion in Assessable Value for GST Calculation in Purchase Bill

[Practical Assignment-13] :  Creation of Ledgers Excluded in Assessable Value for GST Calculation in Purchase Bill

3.2.19. Ledger for RCM (Reverse Charge Mechanism)

CHAPTER-4

“INVENTORY” Setup Using TallyPrime

4.1. Creating a Stock Group

4.1.1. Modifying / Deleting a Single Stock Group

[Practical Assignment-14]  :  Creation of Stock Group

4.2.        Creation of Stock Units of Measure

4.2.1. Simple Units of Measure

4.2.2. Compound Units of Measure

4.2.3. Alternation / Deletion of Stock Units

[Practical Assignment-15] :  Creation of Unit of Measurement

4.3.        Creation of Stock Items

4.3.1. Apply GST Rate and HSN/SAC Details in Stock Item

4.3.2.    Online HSN/SAC Validation in TallyPrime for single Stock Item or Stock Group (Rel.5)

[Practical Assignment-16]  :  Creation of Taxable Items or Goods

4.3.3. Setting MRP details in Stock Items

4.3.4. Setting ‘Nil-Rated’ , ‘Exempted’, ‘Zero Rated’ & ‘ Non-GST’ Items & Goods using TallyPrime

4.3.4.1. Setting Nil-Rated & Exempted items and Goods :

[Practical Assignment-17]  :  Creation of Nil-Rated or Exempted Items or Goods

4.3.4.2. Setting Non-GST Goods :

CHAPTER-5

“VOUCHERS” in TallyPrime

5.1. Alter Pre-defined Voucher Types

5.1.1. ‘General’ Setting in Voucher Type

5.1.1.1.  Method of Voucher Numbering

5.1.1.2. Configure Method of ‘Purchase Voucher’ Numbering to ‘Manual’

5.1.1.3. Configure in Method of ‘Sale Voucher’ Numbering for GST:

5.1.1.4. A further discussion on these options is necessary.

5.1.2.  ‘Printing’ Setting in Voucher Type

5.1.3. ‘Voucher Classes’ for Sale Voucher

CHAPTER-6

“PURCHASE PROCESS” Using TallyPrime

6.1.  Purchase Voucher (F9)

6.2.  Local Purchase (within State)

6.2.1. Fetch Party Details in Vouchers Using GSTIN/UIN (Rel.5)

6.2.1.1. Record Purchases Voucher using GSTIN/UIN to Fetch Party Details

[Practical Assignment-18]  :  Purchase of Items & Goods -Within State

6.3.  Interstate Purchase (Outside State)

[Practical Assignment-19] :  Purchase of Items & Goods -Outside State

6.4.  Additional Charges/ Discount etc. included or Excluded in Assessable Value for GST Calculation

>> Creation of Additional Charges Ledger included in Assessable Value for GST Calculation in Purchase Bill

>> Creation of Additional Charges Ledger without Inclusion in Assessable Value for GST Calculation in Purchase Bill

6.5.  Purchase Bill Voucher with Additional Charges / Discount both Inclusion or Exclusion in Assessable Value for GST Calculation.

[Practical Assignment-20]  :  Purchase of Items & Goods with Additional Charges/ Discount etc. both Local and Outside State

6.6. Purchase of Items with Trade Discount

6.6.1.  Enter the Discount Percentage against each item – without using the Ledger Account

[Practical Assignment-21]  :  Purchase of Items & Goods with Discount Percentage (%) against each items

6.6.2.  Enter Discount Percentage and/or Amount on Item Rates – using the Ledger Account

[Practical Assignment-22]  :  Purchase of Items & Goods with Discount Amount and / Or Percentage (%) against each items using Discount Ledger

6.7. Record Expenses with GST in Purchase Voucher (F9)

(A)          Create an Expenses Ledger with GST Compliance

[Practical Assignment-23]  :  Creation of Expenses with GST Compliance

(B).         Record the following Expenses with GST in Purchase Voucher (F9) under Accounting Invoice :

[Practical Assignment-24]  :  EXPENSES in PURCHASE VOUCHER [F9] – Accounting Invoice ( Ctrl+H)

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

[Practical Assignment-25]  :  Purchase of -Nil Rated & Exempted Goods

6.9. Purchase of FREE Items & Goods using TallyPrime

6.9.1.  Account for free items using Actual and Billed quantities

6.9.2.  Account for Free Items using Zero-Valued Transaction

6.10. Purchase Return / Debit Note Voucher (Alt+F5)

(A) Item Invoice Mode :

[Practical Assignment-26]  :  Debit Note / Purchase Return

(B) Accounting Invoice Mode :

6.11.     Credit Note for Increase in Purchase Value

Record a Credit Note to increase the Purchase Value:

CHAPTER-7

“SALES PROCESS” Using TallyPrime

7.1. Configure in Method of ‘Sale Voucher’ Numbering for GST:

7.2.  Record Sales Voucher using GSTIN/UIN to Fetch Party Details (Rel.5)

7.3. Sale Voucher with Item Invoice for GST Compliance

7.3.1. Sale of Goods and Services in a Single Invoice with multiple GST Rate.

7.3.2.  GST Sale of a Composite Supply (Sale of Items & Goods with Expenses Apportioning)

7.4. Sale of ‘Nil-Rated’ , ‘Exempted’, Supplies using TallyPrime

7.5. Ledger to Round-off the Invoice Value Automatically in Sale Invoice.

7.6. Zero Valued Entries in Sale Invoice

Creating Zero Valued Entries ( Sale of Free Product )

7.7. Sales with Free Items (Different Actual and Billed Quantities in Sale Invoice)

7.8. Enable Item Rate (Inclusive of Tax) in Sale Invoice

(i). Enable Item Rate (Inclusive of Tax) at the time of Item Creation / Alternation mode :

(ii). Activation of Item Rate Inclusive of Tax in F12: Configuration during Sale Entry.

7.9.        Sales of Items with Discounts

7.9.1.    Sales Discount on The Total Item Amount

7.9.2.    Sales with Trade Discount

7.9.2.1. Display Discount Percentage against each item – without using Ledger Account

7.9.2.2. Display Discount Percentage and Amount on Item Rates – using Ledger Account

7.10.     Manage Selling Price Using Standard Price

7.10.1.  Specify Standard Selling Price for Stock Item

7.10.2.  Record Sales with Standard Selling Price

7.11.  ‘e-Way Bill’ System on shipping of Material worth Rs.50,000 and more … in TallyPrime 5

7.11.1. Enable / Setup e-Way Bill in TallyPrime

7.11.2. Create e-Way Bill Profile on the e-Way Bill Govt. Portal.

7.11.3. Generate Online e-Way Bill with Sales in TallyPrime

7.11.4. Print the Sales Invoice with e-Way Bill number using TallyPrime

7.12. ‘Voucher Classes’ for Sale Voucher

[Practical Assignment-27]  :  Sales of Items & Goods -Within State

[Practical Assignment-28]  :  Sales of Items & Goods -Outside State

[Practical Assignment-29]  :  Sale of Items & Goods with Additional Charges/ Discount etc. both Local and Outside State

7.13. Sale Voucher with Accounting Invoice for Service Ledger

7.13.1. Sale Invoice with Service Charges within State (CGST / SGST)

[Practical Assignment-30]  :  Sale/Transaction of Services in Accounting Invoice with SGT Compliance within State

7.13.2.  Sale Invoice with Service Charges Outside State (IGST)

7.14.  Sales Return / Credit Note Voucher ( Alt+F6)

(A) Record Sales Return in Item Invoice Mode

[Practical Assignment-31]  :  Credit Note / Sales Return

7.15.  Debit Note for the Increase in Sale Value

CHAPTER-8

“GST on Reverse Charge Mechanism (RCM)” Using TallyPrime

8.1. Set Up Goods / Services Under Reverse Charge Mechanism (RCM)

8.1.1.    Configure Stock Item for RCM

8.1.2.    Configure Service Ledger for RCM

8.1.3.        Record inward supply of Goods under Reverse Charge Mechanism-RCM

8.1.4.    Record inward supply of Services under Reverse Charge Mechanism-RCM

8.1.5.    Manage Purchase Returns Under Reverse Charge Mechanism-RCM

CHAPTER-9

“Printing of Sales Invoice with Multiple Configurations” Using TallyPrime

9.1.        Change of Invoice Title in Sales Invoice

9.2.        Print Sales Invoice with Company LOGO

9.3.      Printing Bank Details in Sales Invoice

9.4.        Printing Previous and Current Balance in Invoice

9.5.        Change Declaration / Terms & Conditions in Sales Invoices

9.6.        ‘Setting Print Size of your Sales Invoice’ to Use Less Paper for Printing

9.7.        Add Description for Items & Ledgers to Print in Invoice

9.7.1. Additional Description for Stock Items to Print

9.7.2. Additional description for ledgers to print

9.8.        Print Proforma Invoice (Optional Voucher)

9.9.        Print Invoice on Saving a Voucher

CHAPTER-10

“RECEIPT VOUCHER” Using TallyPrime

10.1. Receipt Voucher(F6) 

10.1.1.  Cash Receipts in Single Entry mode

10.1.2.  Bank Receipts in Single Entry mode

10.1.3.  Printing a Receipt after recording a Receipt Voucher

10.1.3.1.  Print the Receipt immediately after Saving the Voucher

10.1.3.2.  Print the Receipt Voucher as a Formal Receipt

[Practical Assignment-32]  :  Receipt Transactions

CHAPTER-11

“CONTRA VOUCHER” Using TallyPrime

11.1.  Record Contra Voucher in Single-Entry Mode

11.1.1.  Cash Deposit Voucher

11.1.2. Cash Withdrawal Voucher

11.1.3.  Fund Transfer Voucher

11.1.4.  Voucher Classes for Contra Voucher

11.1.4.1. For ‘Cash Deposit’ Class under Contra Voucher

11.1.4.2. For ‘Cash Withdrawal’ Class under Contra Voucher

11.1.4.3.  For ‘Fund Transfer’ Class under Contra Voucher

[Practical Assignment-33]  :  Contra Voucher Transactions like Cash Deposit, Cash Withdrawal & Bank Transfer

11.1.5.  Contra Voucher in Day Book

11.1.6.  Contra Register Report

CHAPTER-12

“PAYMENT VOUCHER” Using TallyPrime

12.1. Payment Voucher (F5)

12.1.1. Voucher Classes for Payment & Receipt Voucher

12.1.2. Provide Narration for each Ledger in Payment Voucher

[Practical Assignment-34]  :  Payment Transactions

CHAPTER-13

“JOURNAL VOUCHER” Using TallyPrime

[Practical Assignment-35]  :  Journal Transactions

CHAPTER-14

“GST REPORTS” Using TallyPrime

14.1.  GSTR -1 Report in TallyPrime

14.1.1. Return View of GSTR-1

14.1.1.1. Total Vouchers | View Statistics & Verify Details (GSTR-1 Report)

14.1.1.2. Return View | View GST Details in the Portal Format (GSTR-1 Report)

14.1.2. Nature View of GSTR-1 Report

14.1.3. Export GSTR-1 Report from TallyPrime in the JSON Format.

14.1.4. Upload GSTR-1 directly from TallyPrime to the GST Portal (Rel-5)

14.1.5.  File GSTR-1 Directly from TallyPrime (Rel-5)

14.1.5.1.              File GSTR-1 Using EVC (Electronic Verification Code)

14.1.6. Sign GSTR-1

14.1.6.1. Undo Signing GSTR-1

14.2.  GSTR -3B Report in TallyPrime

14.2.1. View Your GST Details in GSTR-3B Report

14.2.1.1.              Header | View Company Information

14.2.1.2.              Total Vouchers | View Statistics & Verify Details

14.2.1.3.              Return View | View GSTR-3B Details in the Format of the Portal

14.2.2. Nature View of GSTR-3B Report

14.2.2.1.              Liability (Including Inward Reverse Charge Supplies):

14.2.2.2.              Input Tax Credit:

14.2.3. Export GSTR-3B in the JSON Format (Offline) to File Return in GST Portal

14.2.4. Upload GSTR-3B directly from TallyPrime to the GST Portal (Rel-5)

14.2.5. Sign GSTR-3B

14.2.5.1. Undo Signing GSTR-3B

14.3.  GST Annual Computation Report in TallyPrime

14.3.1. Vouchers Recorded for the Period

14.3.1.1. Resolution of Uncertain Transactions

14.3.2. Liability, Input Tax Credit, HSN/SAC Summary

CHAPTER-15

“e-INVOICE” Using TallyPrime

15.1. How to Generate e-Invoice Instantly in TallyPrime?

15.1.1. Mandatory Details for Generating e-Way Bill with e-Invoice

15.1.2. Generate IRN and Print QR Code on the e-invoice

CHAPTER-16

“BILL OF MATERIALS (BoM)”  for Manufacturing Using TallyPrime

16.1. Setup Bill of Materials (BOM)

16.2. Creating a Manufacturing Voucher

CHAPTER-17

“PRICE LEVELS & PRICE LIST” Using TallyPrime

17.1. Price Levels in TallyPrime

17.1.1. Create Price Levels

17.1.2. Price List in TallyPrime

17.1.3. Assign Price Levels to Ledger Accounts

17.2. Use Price Levels & Price List during Voucher Entry

CHAPTER-18

“COST CENTRE AND COST CATEGORY” Using TallyPrime

18.1. Creating Cost Category and Cost Centre

18.2. Applying Cost Centres to Ledger Accounts

18.3. Cost Centres Allocation in Voucher Entry

CHAPTER-19

“TDS (Tax Deducted At Source)” Using TallyPrime

19.1. Enabling TDS in TallyPrime

19.2. Creating TDS Nature of Payment

19.3. Creating Master Ledger with TDS Transaction i.e. Expenses, Party Ledger, TDS Ledger

Step-1: Alter/Create Expenses Ledger i.e. Rent Paid

Step-2: Alter/Create Party Ledger i.e. N. Jatania & Co ( Under Sundry Creditor) as below :

Step-3 : Create TDS Ledger i.e. TDS on Rent

Step-4: TDS Transaction (Accounting for TDS on Expenses)

19.4. TDS on Advance Payment against Expenses

19.5. Recording Payment Transaction (TDS)

CHAPTER-20

“OPTIONAL & NON-ACCOUNTING VOUCHERS” Using TallyPrime

20.1. Memo (Memorandum) Voucher

20.2. Optional Voucher

20.3. Post-dated Voucher

20.4. Physical Stock Voucher (Ctrl + F7)

20.5. Stock Journal Voucher (Alt+F7)

Additional Cost on Purchase in Stock Journal :

20.6. Rejection In  Voucher

20.7. Rejection Out Voucher

CHAPTER-21

“REPORTS” in TallyPrime

21.1. Modifying Reports

21.2. Display Financial Statements in TallyPrime

21.2.1. Balance Sheet in TallyPrime

21.2.2. Profit & Loss Account in TallyPrime

21.2.3. Receipts and Payments Report in TallyPrime

21.2.4. Trial Balance in TallyPrime

21.3. Display Books, Registers and Ledgers

21.3.1. Sales Register Report in TallyPrime

21.3.1.1. Columnar Sales Register

21.3.1.2. Extract of Sales Register

21.3.2. Purchase Register Report in TallyPrime

21.3.3. Cash /Bank Book Report in TallyPrime

21.3.4. Statement of Accounts Report in TallyPrime

21.3.5. Journal Register Report in TallyPrime

21.3.6. Day Book Report in TallyPrime

21.4. Display Inventory Reports and Statements

21.4.1. Stock Summary Report in TallyPrime

21.4.2. Stock Items Report in TallyPrime

Viewing Stock Item Vouchers

21.4.3. Godown / Location Summary Report in TallyPrime

21.4.4. Movement Analysis Report in TallyPrime

21.4.4.1. Movement Analysis (Stock Group Analysis)

21.4.4.2. Stock Item Movement Analysis 321

21.4.4.3. Accounts Group Movement Analysis

21.4.4.4. Ledger Movement Analysis

21.4.4.5. Transfer (Movement) Analysis

21.4.5. Stock Ageing Analysis Report in TallyPrime

21.4.5.1. Changing the Default Ageing Period

21.5. Display Management Information System(MIS) Reports

21.5.1. Cost Centre Reports

21.5.2. Ratio Analysis Reports

21.5.3. Cash Flow Reports

21.5.4. Funds Flow Statement Reports

21.5.5. Exception Reports

21.5.5.1. Negative Stocks Report

21.5.5.2. Negative Ledgers Report

21.5.5.3. Memorandum Voucher Register Report

21.5.5.4. Optional Vouchers Register Report

21.5.5.5. Post Dated Vouchers Register Report

CHAPTER-22

“FILTER IN REPORTS” in TallyPrime

22.1.  Apply Filter in Reports | Basic Filter, Multi-Filter, Advanced Filter

22.1.1.  Basic Filter [Ctrl+F > F5]

22.1.2.  Multi Filter [Ctrl+F > F6]

22.1.3.  Advanced Filter [Ctrl+F > F7]

CHAPTER-23

“DASH-BOARD” in TallyPrime

23.1.  View Dashboard

23.2.  Add/Remove Tile in Dashboard

23.2.1. Add Tile

23.2.2. Remove Tile

23.3.     Change View of Dashboard

23.3.1.  View Dashboard Horizontally/Vertically

23.3.2.  View Dashboard with Predefined Views

23.4.     Expand Tile in Dashboard

CHAPTER-24

“OTHER UTILITIES” in TallyPrime

24.1. Security Control

24.1.1. Set Password in TallyPrime

24.1.2. Use Security Control

24.1.2.1. Creating Users and Passwords

24.1.2.2. Creating and Setting Up Voucher Type Security for Users

24.1.3. TallyVault Password

24.2. Year-end Processing & Moving Company Data to Next Financial Year

24.2.1. Change Current Period

24.2.2. Create New Company and Import the Opening Balances

Export closing balances from old company

Import Masters of closing balances as opening balances in new company

24.3. Splitting Company Data based on Financial Year

24.4. Group Company in TallyPrime

Creating a Group Company

CHAPTER-25

“STRIPE VIEW” in TallyPrime

25.1. Enable Stripe View for all Reports / Vouchers

25.1.1.  View Reports/Vouchers with Stripes

25.1.2.  Enable Stripe View for Print, Export, E-mail, WhatsApp Reports with Stipes (Application Level)

25.2.  Enable Stripe View for specific Report/Voucher

25.2.1.  View Reports / Vouchers with Stripes

25.2.2. Print, Export, E-mail, WhatsApp with stripes

FREE e-Book (PDF) DOWNLOAD

with TallyPrime 5 Book (Advanced Usage)

TABLE OF CONTENTS

PRACTICAL ASSIGNMENTS on TallyPrime 5.1 (Advanced Usage)

Assignment-1    :              [Company Creation]

Assignment-2    :               [GST Activation]

Assignment-3    :               [Account Groups Creation]

Assignment-4    :               [Creating Liabilities / Assets Ledger]

Assignment-5    :               [Creating Party Ledgers –  Sundry Creditor / Sundry Debtor]

Assignment-6    :               [Creating GST Ledgers – ( IGST / CGST / SGST ) ]

Assignment-7    :               [Creating Sales & Purchase Ledgers ]

Assignment-8    :               [Creating Income & Expenses Ledgers ]

Assignment-9    :               [Creating Stock Group ]

Assignment-10 :               [Creating Unit of Measurement ]

Assignment-11 :               [Creating Stock Items / Products / Goods ]

Assignment-12 :               [Altering Vouchers Class – Sales i.e. GST ]

Assignment-13 :               [Entering Purchase Voucher ]

Assignment-14 :               [Entering Purchase Voucher to Record Expenses]

Assignment-15 :               [Purchase Voucher of Nil-Rated, Exempted Items]

Assignment-16 :               [Enter Purchase Return / Debit Note Voucher]

Assignment-17 :               [Enter Sale Voucher]

Assignment-18 :               [Sale Voucher of Nil-Rated, Exempted Items]

Assignment-19 :               [Enter Received Voucher]

Assignment-20 :               [Enter Payment Voucher]

Assignment-21 :               [Contra Voucher – Cash Deposit, Cash Withdrawal, Fund Transfer]

Assignment-22 :               [Enter Journal Voucher]

Assignment-23 :               [Random Voucher Entry Month-wise from  May 2024 to September 2024]