Tally Prime
Ex 1
• On 01 Apr 22 the directors of the company brought Rs. 25 L as Capital.
The company maintains its bank account with ICICI Bank.
Ex 2
• On 02 Apr 22, the company rented a godown and paid a security deposit
of Rs. 1 Lakh by cheque.
Ex 3
• On 2 Apr 22, the following assets were purchased by the company.
From Ram Electricals
Particulars Amount
Electrical Fittings 30,000
Computer (Office Use) 60,000
From Woodland Furntures
Particulars Amount
Work Tables 15,000
Furniture & Fixtures 70,000
The Fixed Asset Ledgers were directly debited without booking the
transactions in the Supplier Account. Separate cheques were issued favoring
the respective parties.
Ex 4
• On 2 Apr 22, the company withdraw Rs. 60 K from the bank for office use
of which Rs. 50,000 was given as advance for petty case.
Ex 5
• On 1 May 22, company purchased spare parts and accessories from
Spark Computers on a credit period of 15 days. The goods were stored in
Computer Accessories godown and Rs. 1,000 was paid towards carriage
inwards of the item.
Item Qty Rate Value
Processor (Atom) 100 5,500 5,50,000
Hard disk (320 GB) 100 2,900 2,90,000
LCD Monitor 100 5,800 5,80,000
Processor (i7) 100 9,500 9,50,000
Total 23,70,000
The above items are taxable at 5% GST.
Ex 6
On 2-5-2021, the following items were purchased from ABC Computers on
30 days credit. The good were stored in computer accessories godown.
Carriage inward expenses of Rs.900 was paid. GST@5% is applicable on all
the items.
Items Quantity Rate (Rs.) Value (Rs.)
Keyboard 100 (no's) 350 35,000
Optical mouse 10(box) 450 45,000
Motherboard 100 (nos) 4,500 4,50,000
(intel)
Ex :7
On 1-06-2022, the following items were transferred from the Computer
Accessories Godown to the Assembly Godown.
Item Quantity
Processor (core i7) 95
LCD Monitor 95
Processor(Atom) 95
Hard Disk(320 GB) 95
Keyboard 95
Optical Mouse 95
Motherboard(intel) 95
Ex: 8
On 02-06-2022, issued a bearer cheque for Rs. 50,000 toward petty
cash.
Ex: 09
• On 02. 06.2022 the company assembled 90 computers with Pentium
core i7 configuration using the given table an stored the same in the
finished goods godown. Wages of Rs. 15,000 and overhead (including
power) of Rs. 1,000 were incurred. To assemble a Pentium core i7 the
following accessories are required.
Name Quality
Processor (corei7) 1 no
LCDmonitor 1 no
Mother board 1 no
Optical mouse 1 no
Keyboard 1 no
Hard disk 1 no
The wages were paid by cheque.
Ex: 10
On 01.07.2022 following items were purchased from Kiran Technologies
Delhi.
Items quantity rate Amount
Optical mouse 50 400 20,000
The above items are taxable @ 5% GST, the invoice amounted to Rs 21,000
Ex 11
ON 01-07-2022 The company sold the following items to Mahesh
Computer on credit of 15 days
item Quantity rate Value Amount
Pentium 50 60,000 30,00,000 31,50,000
core i7
Ex 12
On 02-07-2022 the company paid to Spark Computer Rs. 15,00,000 as part
payment of bill dated 1-05-2022
Ex: 13
On 01-08-2012 the following item were transferred from the computer
accessories godown to assembling godown.
item Quantity
LCDmonitor 5
Processor core i7 5
Processor atom 5
Hard disk 5
Keyboard 5
Optical mouse 5
Mother board 5
Ex: 14
On 02-08-2022 the company assembled 10 nos of computer atom and stored
them in finished godown the wages amounted to Rs. 6,000 and overhead to
Rs. 1000 (including power)
Item Quantity
Processor atom 1
LCDmonitor 1
Motherboard 1
Harddisk 1
Opticalmouse 1
Keyboard 1
The wages paid by cheque.
Ex: 15
• On 02-08-2022 received cheque from Mahesh Computers in full
settlement for bill dated 1-07-2022
Ex: 16
• On 01-09-2022 following items were sold to Xion Stores, Singapore on
credit of 30 days
Item Quantity Rate Value
Pentium core i7 7 $1,500 $10,500
The invoice was raised in $(us dollar) and the rupee was traded at
Rs. 73/$
Ex: 17
• On 2-09-2022 the company received a Sales Order (VC 01/22) for 6 nos
of computer (atom) from Vinayaka Computers to be delivered on 1-10-
2022 at Rs 33,000 each. GST is chargeable @ 5% on such goods.
Ex 18
• On 2-09-2022 the company sold the following items to DJ Designers,
Pune
Item Quantity Rate
Computer atom 1 35,000
Ex 19
• On 1-10-2022 the company delivered (vide no DN- 01 ) the following
items to Vinayaka Computers against their sales order VC01/22.
item Quantity Rate
Computer atom 6 33,000
Ex 20
• On 2-10-2022 the company placed purchase order (vide no PO/001) to
Byte Computers for the following items.
Item Quantity Rate
LCD monitor 100 5,500
Harddisk 100 3,200
Keyboard 100 350
Optical mouse 100 450
Motherboard 100 5,500
The order is due on 1-11-2022
Ex 21
• On 2-10-2022 the company received a cheque from Xion Stores,
Singapore amounting to $10,500 and bank charges of $100 (which is
debited to the company’s account) the exchange rate of $ as on the date
is Rs. 75/$.
Ex 22
• On 1-11-2022 the company received the following items from Byte
Computers against order no PO/001 (as receipt note no RN-01)
Item Quantity
LCD monitor 100
Hard disk 100
keyboard 100
Optical mouse 100
Mother board 100
Ex 23
• On 2-11-2022 Vinayaka Computers returned 1 no of computer atom
which were delivered on 1-10-2022 as per delivery note no DN-01 due to
defective quality.
Ex 24
• On 2-11-2022 a sales invoice was raised on Vinayaka Computers for the
following items
Item Quantity Rate
Computer 5 33,000
atom
The amount was received in full by cheque
Ex 25
• On 2-11-2022 the company returned 10 nos of optical mouse to Byte
Computers due to defective quality.
Ex 26
• On 01-12-2022 the following items were sold to Newtech Technologies
on credit of 5 days. interest is applicable at 10% p.a. after the due date
and 12% interest is further chargeable from 01-01-2023. Tax = 5% GST.
Item Quantity Rate
Pentium core i7 5 55,000
Computer atom 2 35,000
Ex 27
• On 2-12-2022 Byte Computers sent an invoice for the goods retained by
the company towards PO/001 the details are as follows (items are
taxable)
Item Quantity
LCD monitor 100
Harddisk 100
Keyboard 100
Optical mouse 90
Mother board 100
Ex 28
• On 02-01-2023, the company received a cheque from New Tech
Technologies with interest, in full settlement of bill dated 01-12-2022.
Ex 29
• On 30-01-2023 the cashier handling petty cash submitted the statement
of expenses for Jan 2023.
1. Salaries to staff for the month = 30,000
2. Electricity expenses = 2,000
3. Conveyance expenses = 1,200
4. Printing and stationary expenses = 2,700
5. Rent expenses = 25,000
Name Salary
Ramesh 10,000
Praveena 8,000
Shasikumar 6,000
Sanjeev 6,000
Ex 30
• On 30-04-2023 pass the necessary journal entry to adjust forex gain/loss.
Ex 31
• On 30-04-2023 the store keeper found that the stock of optical mouse
was only 45 nos after a physical stock verification in the computer
accessories godown. The difference in stock of optical mouse was
accounted by passing a physical stock voucher.
Ex 32
• Generate trial balance of as on 30-04-2023.
TDS
Ex 33
• On 02-04-2022 the company received an invoice for Rs. 35,000 from
Mr. Ramanadhan - a chartered Accountant - towards internal audit of
accounts.
Ex 34
• On 01-05-2022 the company paid Rs. 31,500 to Mr. Ramanadhan towards
his invoice after deducting TDS.
Ex 35
• On 02-01-2023 the company paid a cheque for Rs. 7,00,000 to Spark
Computers against purchases made.
Ex 36
• On 02-05-2022 the company paid Rs.3,500 to government towards TDS
on internal audit.
REPORTS
• Reports help in decision making process. It can be used to study the
present situation of a business.
• Reports are an essential part of every business be it a startup or an MNC.
Reports provide you an overview of the current situation of the business
or a project. An overview provides you with the support required to take
a decision in the most accurate way possible.
• Tally provides a number of different reports which can be utilized by
most businesses to evaluate the efficiency of their various processes.
Reports such as the Balance sheet, Profit and loss etc are some common
business financial reports available in Tally.
Outstanding report
• Outstanding report in Tally.ERP 9, shows user the receivables which are
pending with customers. The user can check the report ledger-wise as
well as bill-wise. The user can see the ageing analysis on the basis of the
due date on the bills. The ageing analysis helps the user to take timely
follow-ups for the payment and can clear his outstanding receivables as
soon as possible.
• To check outstanding report in Tally, go to Gateway of Tally -> Display ->
Statement of Accounts -> Outstanding -> Ledger
Profit and Loss report
• The Profit and loss report shows all the incomes as well as the expenses
for a particular time period. It displays whether the expenses are
exceeding the incomes causing a loss or the income is exceeding the
expense causing a profit. Profit and loss report is also available in Tally.
• To check Profit & Loss report go to Gateway of Tally -> Profit and Loss.
Cash flow/ Fund flow report
• Cash flow statement is a report that shows the inward and outward flow
of cash in the organization. It shows how the cash is spent and from
where it is earned. Tally has this made for you. You do not have to spend
time creating this report.
• To check the Cash flow report: Go to Gateway of Tally -> Display ->
Cash/Funds Flow -> Cash Flow
Ratio Analysis report
• Ratio Analysis report is another performance based report that provides
insights regarding the financial health of the business. Tally provides a
ratio analysis report that can be viewed from
• Gateway of Tally -> Ratio Analysis.
Balance Sheet
• A balance sheet shows the assets and liabilities of the company. It helps
to understand the performance of the business. Tally.ERP 9 shows the
balance sheet of the company.
• To check Balance Sheet Gateway of Tally -> Display -> Final Accounts ->
Balance Sheet
Stock summary report
• The stock summary report in Tally.ERP 9 provides a summary of the
stock/inventory available on a specified date. It shows the current
availability of stock. This helps you to check the available stock before
hand and then plan accordingly. The quantity of stock can be kept in
level with the demand so as to avoid overstocking of inventory. This
report also helps to avoid wastage of inventory.
• To check stock summary, Go to Gateway of Tally -> Stock Summary
Stock Ageing analysis report
• The stock ageing analysis report in Tally helps the user to understand
which of his/her goods are fast moving and which of them are slow-
moving. This helps the user to develop strategies regarding procurement
of raw materials or to decide whether to liquidate the stock on the basis
of its age or not.
• To check Stock ageing Analysis report in Tally, Go to Gateway of Tally ->
Display -> Inventory Books -> Ageing Analysis -> Select the group.
GST reports
• Tally provides various reports such as GSTR-1, GSTR-2, GSTR-3B related reports. GSTR-
1 report in Tally is same as the GSTR-1 form. This makes things easier for the user at
the time of return filing. Reports show details of:
– All transactions in the GSTR-1
– Which transactions are not eligible for returns
– Non-participating transactions
– Tally serial number-wise details of values as mentioned in GSTR-1
• If there are any mismatches or incomplete information, the user can correct it and
then include it in the return filing. Thus in this way, Tally ensures, that its users file
accurate returns.
• To check the various reports under GST in Tally, Go to Gateway of Tally -> Display ->
Statutory Reports -> GST -> Select the report you would like to check.
E-way Bill reports
• Tally can be used to generate e-way bills. Not just that tally also provides
reports of these e-way bills which is consolidated to provide valuable
insights to the user.
• Following are the various benefits this report provides:
– It shows all the transactions which have been considered for e-way bills
– It also shows all the transactions that need to be considered for e-way
bills.
– Details of all the transactions for which e-way bills were generated
• To check E-way Bill report: Gateway of Tally -> Display -> Statutory Reports -
> GST -> e-Way Bill -> e-Way Bill Report
