PRACTICAL — 01

Record Journal Entries for Business Transactions

Journal Voucher Entry

Aim / Objective:
To record journal entries in Tally Prime for three business transactions — a credit sale with partial cheque payment, a rent expense, and a credit purchase of machinery.

Software Used: Tally Prime | Voucher Type: Journal / Payment / Receipt

1

Open Tally Prime → Select the Company → Go to Gateway of Tally

2

Click Vouchers → Select Journal (F7) for adjusting entries

3

Enter Date: 01/04/2025 → Enter Debit and Credit ledger names with amounts

4

For sales entry: Debit — XYZ Enterprises A/c; Credit — Sales A/c (₹50,000). Then Receipt voucher for cheque receipt of ₹25,000

5

For rent: Use Payment Voucher (F5) — Debit Rent A/c, Credit Cash A/c

6

For machinery: Use Journal Voucher (F7) — Debit Machinery A/c, Credit ABC Suppliers A/c

7

Add narration for each entry and press Ctrl+A to save

Tally Prime — Journal Voucher F2: Date | F7: Journal | Ctrl+A: Accept

Journal Voucher No. JV-001 Date: 01/04/2025

DrXYZ Enterprises A/c₹50,000.00

CrSales A/c₹50,000.00

Narration:Sold goods to XYZ Enterprises; 50% cheque

DrRent A/c₹10,000.00

CrCash A/c₹10,000.00

Narration:Rent paid in cash for April 2025

Date	Particulars	Voucher	Dr/Cr	Amount (₹)
01/04/25	XYZ Enterprises A/c Dr	JV-001	DR	50,000
	To Sales A/c		CR	50,000
01/04/25	Rent A/c Dr	PV-001	DR	10,000
	To Cash A/c		CR	10,000
01/04/25	Machinery A/c Dr	JV-002	DR	1,00,000
	To ABC Suppliers A/c		CR	1,00,000

Result/Conclusion: All three journal entries were successfully recorded in Tally Prime. The sale to XYZ Enterprises, rent payment, and machinery purchase on credit are now reflected in the respective ledger accounts.

PRACTICAL — 02

Ledger Maintenance — Create Ledger Accounts

Ledger

Aim / Objective:
To create three ledger accounts in Tally Prime: Furniture, Salary Expense, and Capital Account.

1

Gateway of Tally → Masters → Create Ledger (Alt+G → Create Master → Ledger)

2

Ledger 1: Name = Furniture | Group = Fixed Assets | Opening Balance = 0

3

Ledger 2: Name = Salary Expense | Group = Indirect Expenses | Opening Balance = 0

4

Ledger 3: Name = Capital Account | Group = Capital Account | Opening Balance = ₹1,50,000 (Cr)

5

Press Ctrl+A after each to save. Verify via Display → List of Accounts

Tally Prime — Ledger Creation Alt+G: Go To | Ctrl+A: Accept

Ledger Creation

NameCapital Account

Under (Group)Capital Account

Opening Balance₹1,50,000.00 Cr

Maintain Bill-wiseNo

✓ Ledger saved successfully

Ledger Name	Group	Nature	Opening Balance
Furniture	Fixed Assets	Asset	₹0.00
Salary Expense	Indirect Expenses	Expense	₹0.00
Capital Account	Capital Account	Liability	₹1,50,000 Cr

Result/Conclusion: Three ledger accounts were successfully created under their respective groups in Tally Prime. The Capital Account shows an opening credit balance of ₹1,50,000.

PRACTICAL — 03

Shortcut Key — Navigate to List of Ledgers

Shortcut Key

Aim / Objective:
To demonstrate the shortcut key used to navigate to the list of ledgers in Tally Prime.

SHORTCUT KEY:

Alt + G → Type "List of Ledgers" → Press Enter

Gateway of Tally → Display More Reports → List of Accounts

Shortcut	Function
Alt+G	Go To — Universal navigation in Tally Prime
D → L → A	Display → List of Accounts (classic menu path)
Ctrl+A	Accept / Save current screen

Result/Conclusion: The list of ledgers can be accessed using Alt+G shortcut or through Display → List of Accounts. All created ledgers (Furniture, Salary Expense, Capital Account) appear in the list.

PRACTICAL — 04

Trial Balance & Final Accounts

Trial Balance P&L Account Balance Sheet

Aim / Objective:
To prepare a Trial Balance, Trading & P&L Account, and Balance Sheet in Tally Prime using provided financial data.

1

Post all transactions in respective vouchers — Sales, Purchase, Rent, Salary entries

2

Gateway of Tally → Display More Reports → Trial Balance

3

Verify all ledger totals balance (Debit = Credit)

4

Gateway → Display → Profit & Loss A/c (auto-generated)

5

Gateway → Display → Balance Sheet (auto-generated)

Trial Balance

Particulars	Debit (₹)	Credit (₹)
Sales A/c	—	2,00,000
Purchases A/c	1,50,000	—
Rent Expense A/c	10,000	—
Salary Expense A/c	20,000	—
Capital Account	—	1,50,000
Cash A/c	1,70,000	—
TOTAL	3,50,000	3,50,000

Profit & Loss Account

Expenditure	₹	Income	₹
To Purchases	1,50,000	By Sales	2,00,000
To Gross Profit c/d	50,000
Total	2,00,000	Total	2,00,000
To Rent Expense	10,000	By Gross Profit b/d	50,000
To Salary Expense	20,000
To Net Profit	20,000
Total	50,000	Total	50,000

Balance Sheet (as on 31/03/2025)

Liabilities	₹	Assets	₹
Capital Account	1,50,000	Cash A/c	1,70,000
Add: Net Profit	20,000
Total Capital	1,70,000
Total	1,70,000	Total	1,70,000

Result/Conclusion: Trial Balance, P&L Account, and Balance Sheet were successfully prepared. Net Profit is ₹20,000. Balance Sheet balances at ₹1,70,000 on both sides.

PRACTICAL — 05

Recording Purchases, Sales, Receipts & Payments

Purchase Sales Receipt

Aim / Objective:
To record four business transactions in Tally Prime using appropriate voucher types.

1

Purchase Voucher (F9): LMN Traders — ₹30,000 on credit → Dr Purchase A/c, Cr LMN Traders A/c

2

Sales Voucher (F8): ABC Corporation — ₹40,000 → Dr ABC Corporation A/c, Cr Sales A/c

3

Receipt Voucher (F6): ₹15,000 from debtors via bank → Dr Bank A/c, Cr Debtor A/c

4

Payment Voucher (F5): Electricity bill ₹5,000 by cheque → Dr Electricity Expense, Cr Bank A/c

Transaction	Voucher	Debit	Credit	Amount
Purchase (Credit)	F9	Purchase A/c	LMN Traders	₹30,000
Sales (60% bank)	F8	ABC Corp / Bank	Sales A/c	₹40,000
Receipt from Debtors	F6	Bank A/c	Debtors A/c	₹15,000
Electricity Bill	F5	Electricity Exp	Bank A/c	₹5,000

Result/Conclusion: All four transactions recorded successfully using Purchase, Sales, Receipt and Payment vouchers respectively.

PRACTICAL — 06

Creating Vouchers — Sales, Purchase & Contra

Voucher Creation

Aim / Objective:
To create Sales, Purchase, and Contra vouchers in Tally Prime for specific transactions.

1

Sales Voucher (F8): Sell goods ₹60,000 to PQR Enterprises → Dr PQR Enterprises, Cr Sales A/c

2

Purchase Voucher (F9): Office supplies ₹20,000 from DEF Suppliers → Dr Purchase A/c, Cr DEF Suppliers

3

Contra Voucher (F4): Deposit ₹10,000 cash to bank → Dr Bank A/c, Cr Cash A/c

4

Enter narration for each voucher. Press Ctrl+A to save

Voucher Type	Key	Party	Amount
Sales Voucher	F8	PQR Enterprises	₹60,000
Purchase Voucher	F9	DEF Suppliers	₹20,000
Contra Voucher	F4	Cash → Bank	₹10,000

Result/Conclusion: Sales, Purchase, and Contra vouchers were created successfully. Cash of ₹10,000 is now deposited into the bank account.

PRACTICAL — 07

Shortcut Key — Open Calculator in Tally Prime

Shortcut Key

Aim / Objective:
To demonstrate how to open the built-in Calculator within Tally Prime using keyboard shortcut.

SHORTCUT KEY:

Ctrl + N → Opens the Calculator Panel in Tally Prime

Ctrl+N again → Toggles / Closes the Calculator

Shortcut	Function	Available In
Ctrl+N	Open / Toggle Calculator	All Screens
Esc	Exit from calculator mode	Voucher Entry

Result/Conclusion: The calculator in Tally Prime is opened using Ctrl+N shortcut. It provides quick arithmetic operations without leaving the current screen.

PRACTICAL — 08

Bank Reconciliation Statement

Bank Reconciliation

Aim / Objective:
To perform Bank Reconciliation in Tally Prime by matching the bank ledger balance with the bank statement balance, identifying outstanding cheques.

1

Gateway of Tally → Display More Reports → Account Books → Bank Reconciliation

2

Select the Bank Ledger (e.g., State Bank of India)

3

Enter the Bank Statement date and Bank Statement Balance: ₹1,20,000

4

Tally shows Ledger Balance = ₹1,35,000. Difference = ₹15,000 (Outstanding cheques)

5

Mark outstanding cheques of ₹15,000 as "Not yet presented to bank"

6

After reconciliation, the statement balances

Tally Prime — Bank Reconciliation Display → Account Books → Bank Reconciliation

Bank Reconciliation — State Bank of India

Bank Ledger Balance₹1,35,000.00

Bank Statement Bal.₹1,20,000.00

Difference₹15,000.00

Outstanding Cheques₹15,000.00 (not presented)

✓ Reconciled Successfully

Item	Amount (₹)
Balance as per Bank Statement	1,20,000
Add: Outstanding Cheques (not presented)	15,000
Balance as per Tally Ledger	1,35,000

Result/Conclusion: Bank reconciliation performed. The difference of ₹15,000 is due to outstanding cheques not yet presented to the bank. After adjustment, both balances match at ₹1,35,000.

PRACTICAL — 09

Shortcut Keys — Create & Save a Voucher

Shortcut Key

Aim / Objective:
To demonstrate the shortcut keys used to create a new voucher and save a voucher in Tally Prime.

CREATE & SAVE VOUCHER SHORTCUTS:

Alt + C → Create new voucher on the fly

Ctrl + A → Accept / Save the current voucher

Ctrl + S → Quick Save without accepting

Shortcut	Action
Alt+C	Create a new master (ledger/item) during voucher entry
Ctrl+A	Accept and Save the current voucher
Ctrl+S	Save without leaving the screen
Esc	Discard changes and exit voucher

Result/Conclusion: Shortcut keys Alt+C (create) and Ctrl+A (save) allow fast voucher entry and saving without using the mouse, improving data entry efficiency.

PRACTICAL — 10

Transactions Other Than Purchase & Sales

Journal Receipt

Aim / Objective:
To record miscellaneous transactions — insurance premium payment and interest income receipt — in Tally Prime.

1

Insurance Premium: Payment Voucher (F5) → Dr Insurance Expense A/c ₹7,000, Cr Bank A/c ₹7,000

2

Interest Income: Receipt Voucher (F6) → Dr Bank A/c ₹3,000, Cr Interest Income A/c ₹3,000

3

Add narration: "Insurance premium paid by cheque" / "Interest credited to bank"

4

Save with Ctrl+A

Transaction	Voucher	Debit	Credit	₹
Insurance Premium	F5 — Payment	Insurance Expense	Bank A/c	7,000
Interest Income	F6 — Receipt	Bank A/c	Interest Income	3,000

Result/Conclusion: Both non-trading transactions recorded. Insurance expense reduces bank balance while interest income increases it.

PRACTICAL — 11

Exporting Trial Balance to MS Excel

Export MS Excel

Aim / Objective:
To export the Trial Balance from Tally Prime to MS Excel format.

1

Gateway of Tally → Display More Reports → Trial Balance

2

Press Alt+E (Export) from the Trial Balance screen

3

Format: Select Excel (Spreadsheet)

4

Output File Name: TrialBalance_2025.xlsx

5

Press Enter to export. File saved in Tally export folder

Alt+E → Export current report | Select Format → Excel (Spreadsheet) | Enter → Export

Result/Conclusion: Trial Balance exported successfully to Excel format (.xlsx). The file can be opened in MS Excel for further analysis or printing.

PRACTICAL — 12

Creating GST Invoice — 18% GST on ₹80,000

GST Invoice

Aim / Objective:
To create a GST-enabled tax invoice for selling goods worth ₹80,000 to LMN Traders with 18% GST in Tally Prime.

1

Ensure GST is enabled: Gateway → F11 Features → Enable GST = Yes

2

Create GST ledgers: CGST A/c (9%) and SGST A/c (9%) under Duties & Taxes

3

Sales Voucher (F8) → Party: LMN Traders → Item: Goods → Qty & Rate

4

Apply Tax: GST @ 18% (CGST 9% + SGST 9%) on ₹80,000

5

Invoice auto-generates with GST breakup. Print with Alt+P

TAX INVOICE

Invoice No.: INV-2025-001

Date: 01/04/2025

GST No.: 23XXXXX1234Z5

Sold To:

LMN Traders

GST: 23YYYYY9876A1

#	Item Description	HSN	Qty	Rate	Amount
1	Goods (as per invoice)	8471	1	80,000	₹80,000

Taxable Value

₹80,000

CGST @ 9%

₹7,200

SGST @ 9%

₹7,200

Grand Total: ₹94,400

Component	Calculation	Amount (₹)
Taxable Value	—	80,000
CGST @ 9%	80,000 × 9/100	7,200
SGST @ 9%	80,000 × 9/100	7,200
Grand Total		94,400

Result/Conclusion: GST invoice created for ₹80,000 sale to LMN Traders. Total invoice value is ₹94,400 including CGST ₹7,200 + SGST ₹7,200.

PRACTICAL — 03

Shortcut Key — View Group Summary Report

Shortcut Key

Aim / Objective:
To navigate to and view the Group Summary report in Tally Prime using keyboard shortcuts.

GROUP SUMMARY SHORTCUT:

Alt + G → Type "Group Summary" → Enter

OR: Gateway → Display More Reports → Account Books → Group Summary

Result/Conclusion: Group Summary report viewed successfully. It displays the net balance of all account groups (Capital, Liabilities, Assets, Income, Expenses) at a glance.

PRACTICAL — 14

Stock Management — Add, Delete & Modify Inventory

Inventory Stock Management

Aim / Objective:
To manage inventory in Tally Prime: add a new item (Laptop), delete an item (Printer), and modify the selling price of an existing item (Chair to ₹500).

1

Add Item: Gateway → Masters → Create Stock Item → Name: Laptop | Unit: Nos | Opening Stock: 10 units

2

Set HSN Code, GST Rate, and Costing details for Laptop. Press Ctrl+A to save

3

Delete Item: Gateway → Masters → Alter Stock Item → Select Printer → Press Alt+D to delete

4

Modify Item: Alter Stock Item → Select Chair → Change Selling Price to ₹500 → Ctrl+A to save

5

Verify via Gateway → Display → Stock Summary

Tally Prime — Stock Item Creation Masters → Create → Stock Item

Stock Item Creation

NameLaptop

Under (Group)Primary

UnitsNos

Opening Qty10 Nos

GST Rate18%

✓ Laptop added to inventory

Action	Item	Details	Result
ADD	Laptop	10 units, opening stock	Created ✓
DELETE	Printer	Alt+D in Alter screen	Deleted ✓
MODIFY	Chair	Selling Price → ₹500	Updated ✓

Result/Conclusion: Inventory management completed. Laptop added with 10 units opening stock, Printer deleted, and Chair's selling price updated to ₹500.

PRACTICAL — 15

Find/Search Function — Narration & Amount Search

Search

Aim / Objective:
To use Tally Prime's search/find function to locate a specific transaction by narration or amount.

1

Open Day Book: Gateway → Display More Reports → Day Book

2

Press Ctrl+F or F12 to open Filter/Search options

3

Search by Narration: Type keywords like "rent" or "salary" in the search box

4

Search by Amount: Enter amount like "10,000" to filter matching transactions

5

Results display filtered entries instantly. Press Esc to clear filter

Ctrl+F → Search/Filter in Day Book | F12 → Configure search options | Esc → Clear filter

Result/Conclusion: The Find/Search function in Tally Prime (Ctrl+F) allows quick filtering of vouchers by narration text or specific amounts, making it easy to locate any transaction without manual scrolling.

PGDCA-110

Practical Based on PGDCA-108

// Index of Practicals

UNIT 01 Journal Entries

Record Journal Entries for Business Transactions

Ledger Maintenance — Create Ledger Accounts

Shortcut Key — Navigate to List of Ledgers

Trial Balance & Final Accounts

Recording Purchases, Sales, Receipts & Payments

Creating Vouchers — Sales, Purchase & Contra

Shortcut Key — Open Calculator in Tally Prime

Bank Reconciliation Statement

Shortcut Keys — Create & Save a Voucher

Transactions Other Than Purchase & Sales

Exporting Trial Balance to MS Excel

Creating GST Invoice — 18% GST on ₹80,000

TAX INVOICE

Shortcut Key — View Group Summary Report

Stock Management — Add, Delete & Modify Inventory

Find/Search Function — Narration & Amount Search