TallyPrime Book (ExPERT)

Content

Tally Prime Book-Expert Tutorial

CHAPTER-1 [COMPANY CREATION ]

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

CHAPTER-2 [GST SETUP USING TallyPrime]

2. Activate GST for Regular Dealers

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

3.1. Account Groups in TallyPrime

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

3.2. Ledgers in TallyPrime

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

Assignment-1

3.2.3. Creating Bank Account Ledgers in TallyPrime

Assignment-2

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

Assignment-3

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

Assignment-4

3.2.6. Creating Sales and Purchase Ledgers for GST Compliance:

I. Creating a Sales Ledger: Sales-GST/IGST (both for Local & Outside State)
II. Creating a Purchase Ledger: Purchase-GST/IGST (both for Local & Outside State).

Assignment-5

3.2.7. Creating Expenses and Income Ledgers without GST Compliance

Assignment-6

3.2.8. Creating Service Ledger with GST Compliance

Assignment-7

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

CHAPTER-4 [INVENTORY / ITEMS & GOODS / STOCK]

4.1. Creating a Stock Group

4.1.1. Modifying / Deleting a Single Stock Group

Assignment-8

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

4.3. Creation of Stock Items

4.3.1. Setting GST Details in Stock Item ( Tax On Value)

Assignment-9

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

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

Assignment-10

CHAPTER- 5 [VOUCHERS in TallyPrime]

5.1. Purchase Voucher (F9)

(A) Local Purchase (within State)
(B) Interstate Purchase (outside State)
(C) Purchase Voucher with some Additional Charges/ Discount etc.

> Creation of Additional Charges Ledger included before GST in Purchase Bill
> Creation of Additional Charges Ledger included after GST in Purchase Bill
> Purchase Bill Voucher with Additional Charges / Discount both before and after GST

Assignment-11

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

Assignment-12

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

Assignment-13

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

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

(A) Item Invoice Mode :
(B) Accounting Invoice Mode :

Assignment-14

5.3. Sales Invoice (F8) –

Voucher Classes for Sale Voucher

5.3.1. Sale Voucher with Item Invoice for GST Compliance

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

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

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

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

5.3.6. Zero Valued Entries in Sales Invoice

> Creating Zero Valued Entries ( Sale of Free Product )

5.3.7. Different Actual and Billed Quantities in Sale Invoice

5.3.8. Enable Item Rate (Inclusive of Tax) during Sale

5.3.8.1. Enable Item Rate (Inclusive of Tax) at the time of Item Creation / Alternation mode :
5.3.8.2. Activation of Item Rate Inclusive of Tax in F12: Configuration during Sale Entry.

Assignment-15

5.3.9. Sale Voucher with Accounting Invoice for Service Ledger

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

Assignment-16

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

Assignment-17

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

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

Assignment-18

5.5. Contra Voucher (F4)

(A) Cash Deposit Voucher
(B) Cash Withdrawal Voucher
(C) Fund Transfer Voucher

Assignment-19

5.6. Payment Voucher (F5)

Assignment-20

5.7. Receipt Voucher(F6)

Assignment-21

5.8. Journal Vouchers (F7):

Assignment-22

5.9. Physical Stock Vouchers (Ctrl+F7):

5.10. Journal Vouchers (F7):

CHAPTER-6 [GST Reports to File GST Returns]

6.1. GSTR -1 Report in TallyPrime

6.1.1. Return View of GSTR-1

6.1.2. Nature View of GSTR-1 Report
6.1.3. Export GSTR-1 Report from TallyPrime in the JSON Format.

6.2. GSTR -2 Report in TallyPrime

6.3. GSTR -3B Report in TallyPrime

6.3.1. Return View of GSTR-3B Report

6.3.2. Nature View of GSTR-3B Report

6.3.3. Generate GSTR-3B Returns in the JSON Format to File from TallyPrime

> Print GSTR-3B Return in Word Format or File directly on the GST Portal.

CHAPTER – 7 [REPORTS IN TallyPrime]

7.1. Modifying Reports
7.2. Display Financial Statements in TallyPrime

7.2.1. Balance Sheet in TallyPrime

7.2.2. Profit & Loss Account in TallyPrime
7.2.4. Trial Balance in TallyPrime

7.3. Display Books, Registers and Ledgers

7.3.1. Sales Register Report in TallyPrime

7.3.1.1. Columnar Sales Register
7.3.1.2. Extract of Sales Register

7.3.2. Purchase Register Report in TallyPrime
7.3.3. Cash /Bank Book Report in TallyPrime
7.3.4. Statement of Accounts Report in TallyPrime

7.4. Display Inventory Reports and Statements

7.4.1. Stock Summary Report in TallyPrime
7.4.2. Stock Items Report in TallyPrime

7.4.3. Viewing Stock Item Vouchers

7.4.4. Movement Analysis Report in TallyPrime

7.4.4.1. Movement Analysis (Stock Group Analysis)
7.4.4.2. Stock Item Movement Analysis
7.4.4.3. Accounts Group Movement Analysis
7.4.4.4. Ledger Movement Analysis

7.4.5. Ratio Analysis Reports
7.4.6. Cash Flow Reports
7.4.7. Funds Flow Statement Reports
7.4.8. Exception Reports

7.4.8.1. Negative Stocks Report
7.4.8.2. Negative Ledgers Report

CHAPTER – 8 [OTHER UTILITIES]

8.1. Set Password in TallyPrime
8.2. Year-end Processing & Moving Company Data to Next Financial Year

8.2.1. Change Current Period

8.3. Splitting Company Data based on Financial Year
8.4. Group Company in TallyPrime

> Creating a Group Company

PRACTICAL ASSIGNMENT with GST using TallyPrime [F.Y. 2023-24]

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 [Enter Contra Voucher – Cash Deposit, Cash Withdrawal, Fund Transfer]
Assignment-22 [Enter Journal Voucher]
Assignment-23 [Random Voucher Entry Month-wise from May 2020 to September 2023]

MAY – 2022
JUNE – 2022
JULY – 2022
AUGUST – 2022
SEPTEMBER – 2022

SWAYAM EDUCATION
Mandal Bagicha, Hemkapada,
Sunhat, Balasore-756002 ( Odisha )-India
eMail ID : tallyerp9bookorder@gmail.com
Web : www.tallyPrimebook.com
Mob : 09437264738

error: Content is protected !!
Scroll to Top
Call Now ButtonCall me...