Introduction

Tally is powerful accounting software, which is driven by a technology called concurrent multi-lingual
accelerated technology engine. It is easy to use software and is designed to simply complex day to day
activities associated in an enterprise. Tally provides comprehensive solution around accounting principles,
inventory and data integrity. Tally software comes with easy to use interface thus making it operationally
simple.

Benefits of Tally Accounting Software

 The technology employed by tally makes data reliable and secure. This helps in connecting files across
multiple office locations.
 Tally accounting software is capable of undertaking financial analysis and financial management. It
provides information around receivables turnover, cash flow statement, activity consolidation and even
branch accounting.
 Tally accounting software is east to set up and simple to use. A single connection can support multiple
users. It can be easily used in conjunction with the Internet making possible to publish global financial
reports.
 Tally accounting software can seamlessly connect with various Microsoft applications.

Versions of Tally:

Tally 4.5: This version MS-DOS support financial accounting system. It takes care of accounting activities
only such as Ledgers Classification Vouchers Entry. It provides simple financial reports and bill wise analysis
of debtors and creditors in the business.

Tally 5.0: This version is an upgraded version to tally 4.5 and it works in windows operating
system Inventory modules is introduced in this version, which involves detailed inventory, structure invoicing
and integrating accounting and Inventory records.

Tally 5.4: This version is an improved module over the version 5.0 where it is capable of converting earlier
data formats in to the current data format. This is possible though Import of Data Facility.

Tally 6.3: Tally 6.3 is extended enterprise systems whereby it interacts with other system through ODBC you
and e-mail upload your financial records form tally.

Tally 7.2: This version is an integrated enterprise system provides different kind of taxes like VAT, TDS &
TCS and Service Tax modules is introduced in this version.

Tally 8.1: Tally 8.1 is multi language support software. It supports 10 Languages includes is introduced in
this version.

Tally 9.0: This version is an improved model over the version 8.1. it supports 13 Languages . Payroll, POS
(Point of Sales) modules is introduced in this version.

Tally.ERP9: This is the latest version which provides different features like remote access, much powerful
data security, tally.net and many more.
Detailed about the predefined group in Tally.erp!

1. Capital: It includes Capital A/drawing A/partners’ Capital A/c., Share Capital etc.

2. Reserve and surplus: (retained Earning) It is another name for reserve and surplus accounts. Such as
Capital reserve, general Reserve, Profit and loss account ,reserve for depreciation ,Reserve for income tax.

3. Current Assets: It contain following sub group

Cash All cash related Accounts

Bank All bank Related Accounts
Deposits (assets): All rental deposits, fixed deposits, security deposits etc. which are made by the company.
Loan and Advancement (assets) loan and advancement provides to outsider by the Company which are non-
trading. Example salary advance, advance for purchased of fixed assets etc.
Stock in hand: It includes opening and closing stock the balancing depends upon type of inventory
management.

4. Fixed Assets: It includes all fixed assets of the company.

5. Investment: like bonds, securities, shares.

6. Loans (Liability): It keeps an account of the Loans taken by the Company.

a) Bank OD Accounts [Bank OCC Accounts]: Bank OCC is the alias name for Bank OD Accounts. It holds
Over Draft Account like, Bill Discounting Account, etc. of the Bank.

b) Secured Loan: It holds the accounts of the loans taken by the company from Banks and other Financial
Bodies by mortgaging its Fixed Assets. It is a secured loan so it has to be returned from the fixed asset of the
company even if the company fails.

c) Unsecured Loans: This is an unconditional loan obtained from Partners / Directors or outside parties.

7) Suspense Account: This accounts is opened when trail balance does not match and some
discrepancy Balance Sheet. It is a Balance Sheet item and shown either in asset or balance sheet side.

8) Miscellaneous Expenses (Asset): This is mainly for legal disclosure requirements, like Schedule VI of
Indian Companies Act. It is rarely used. This is a primary group. Create all expense accounts that are not
written off to P&L A/c the same year in which they are incurred under this group. Such expenditure is written
–off proportionally over a number of years Ex. Preliminary expenses lump sum amount paid for obtaining
copy right or technical knowhow.

9) Branch / Divisions: It holds the accounts of all the Sister Concerns, Branches, Divisions, Affiliation, etc.
of the existing company. This is primary group. When we are maintaining accounts of Head Office which has
various Branches of Divisions under it, create such branch or division accounts under this group Ex.
Vijayawada branch A/c, Hyderabad H.O A/c etc.,

10) Sales Account: such as sales a/c and sales return account .It holds the different Sales Accounts.

11) Purchase Account: It holds the accounts related to purchase.

12) Direct Income: account of the direct income is opened like income due to sales of service generally used
in professional service. A Professional Service provider generally use to open an account as Professional
Fees instead of Sales Account, under this Group.

13) Indirect Income: It is an accounts of non-sale indirect income, like income from Rent Received,
Commissions Received, Interest Received, etc.

14) Direct Expenses: It has factory related expense or generally direct expenses the direct trading expenses of
the factory, like Wages paid to Labours, Transportation, Electricity Bill.

15) Indirect Expenses: Expenses incurred in the administrative building, like Salary A/cf, Maintenance of
Vehicle, etc.
Create the Ledger a/c and Pass the voucher entries of the following Entries:-

 Cash brought in by proprietor as capital Rs.. 30000

 Goods purchased on credit from Madan Lal Rs.. 5,000.
 Furniture purchased for cash Rs.. 10000.
 Goods sold on credit to Dev. Raj Rs.. 1600
 Goods purchased for cash Rs.. 4500
 Goods sold for cash Rs. 2100
 Rent paid for shop to landlord 3000
 Commission received in cash 2000.
 Cash deposited into bank 5000
 Cash withdrawn from bank for office use Rs.. 2000
 Cash drawn by proprietor from business for personal use Rs.. 3000
 Goods given as charity Rs.. 1000.
 Bad Debts written off Rs.. 500.
 Bad debts recovered in cash Rs.. 300.
 Carriage paid on machinery (expenses on purchase of asset) Rs.. 1000
 Depreciation on fixed assets Rs.. 500
Capital A/c- 2700 Fixed Assets- 9500 Current Assets- 14000
Gross Loss- 5800 Net Loss- 8500 P&L- 10500

Journal Entries:-
 Capital Introduce of Rs.. 225000 (House hold furniture Rs.. 75000, Rs.. 150000
deposited into the Chase Bank).
 Paid life insurance policy for Rs.. 1500 by Chase cheque No. 112233.
 Bank charges Rs.. 450 Debited.
 Paid Rs.. 5000 to challenger system by cheque against his bill.
 Bought office expenses for Rs.. 150 with Petty cash.
 Wages of Rs.. 600 paid to employees by cheque No. 112234
 Cheque for Rs.. 5000 received from Data Link Technologies against his first bill
Ch.No.001122
 Withdraw Rs.. 200 from bank account for petty cash.
 Paid salary Rs.. 4000 to employees by cheque No. 112235
 Bought Furniture Rs.. 20000 from Furniture House
 Receive Rs.. 5000 from Compu Care System Full & Final settlement by cheque No.
112236
 Paid Rs.. 19500 to Furniture House by cheque and get discount of Rs.. 500 Cheque No.
112236
 Rs..200 Bank charges Reverse
 Paid Rs.. 1500 for advertisement expenses by cheque No. 112236
 Withdraw Rs.. 2000 from bank for Personal use.
  Paid Rs.. 10000 to Horizon Enterprises by cheque No. 112237 (chq dt. 20-04-2017)
against his first bill.
Balance Sheet-223000 Fixed Assets- 95000 Current Assets- 105500
Gross Loss- 600 Net Loss- 7500 P&L- 8000

Accounting Management
Humrahi traders purchased tally Erp 9 to maintain its Accounts. Create company in Tally Erp
9 & record transactions given below:
 On 1.4.2014 started business with cash Rs.. 25000/-, furniture Rs.. 20000/- & building
155000.
 On 2.4.2014,purchased goods from Infocom ltd. For cash Rs.. 10000.
 On 2.4.2014, sold goods to radha electricals for cash Rs.. 12000.
 On 4.4.2014,purchased Goods from Firstcomp on Credit Rs.. 5000
 On 4.4.2014, sold goods to Prakash on credit Rs.. 7000
 On 7.4.2014, opened a bank a/c in Sbi with depositing Rs. 5000.
 On 10.4.2014, taken a loan from hdfc Rs.. 25000.
 On 12.4.2014, purchased goods from Infocom Ltd. On credit Rs.. 10000
 On 13.4.2014, sold goods to Radha electricals on credit Rs.. 15000
 On 20.4.2014, returned goods to Firstcomp Rs.. 15000.
 On 21.4.2014, received goods from Prakash Rs.. 2000.
 On 23.4.2014, withdrew from bank Rs.. 2000.
 On 25.4.2014, paid salary Rs. 4000, & wages Rs.. 2000 in cash.
 On 26.4.2014, received commission Rs.. 3000.
 On 30.4.2014, paid electricity charges by cheque Rs.. 1000.
 Tracking of Balance Bill-by-Bill
 Vridhi Traders received an invoice no. PLC from power line Computer for Rs. 8500/-.
 Vridhi Trade made a sale worth Rs. 5750 to First Com Solutions with reference no: FC-
1.
 Make sales to First Com Solutions for Rs.5000 with reference no: FC-1 and check
whether the sales transaction is allowed or not would you get the warning screen?
 Purchase goods worth Rs. 5000 from Power Line Computers. Enter the invoice no. -
PLC1. Allow a credit period of 30 days.
 Received cheque Payment from First Com Solutions against reference no. FC-1
 Sold goods worth Rs.6000 to Fit Com Solutions. Create a new reference with FC-2 as
the reference number.
 Open a ledger by name Cash under Cash in Hand Account Group and enter the
opening balance as Rs.200000/-
 Record a sale for Rs.580 to AP Electronics. The Bill reference is New Ref – bill/005
 Similarly, Record 3 Sales Invoices to AP Electronics.
a. Made a sale of Rs.600 (Bill Reference – Bill/006)
b. Made a sale of Rs.620 (Bill Reference – Bill/007)
c. Made a sale of Rs.650 (Bill Reference – Bill/008)
 Received a cheque of Rs.2000, from AP Electronics against all references.
 Find the Outstanding Report.
 Cost Centre and Cost Categories
 Data secure Pvt. Ltd. Paid Rs.60000 towards Rent, out of which Rs.. 20000 was paid
towards Noida Office and Rs.40000 towards Mumbai Office (Use Cost Centre), vide
cheque no 000002.
 The sales team of Data secure Pvt. Ltd. Began customer visits for giving a demo of its
Secure Data Antivirus. The company provided Rs.20000 towards their Transportation
and food expenses, of which Rs.15000 was allocated for Salesman X and Rs. 5000 to
salesman Y, vide cheque no: 00003 (Use Cost Centre & Cost Categories)
 Data secure Pvt. Ltd. Paid Rs. 80000 towards Rent, out of which Rs.20000 was paid
towards Noida Office and Rs. 60000 towards Mumbai Office (Use Cost Centre).
 Made a payment toward cost of expanses for Rs. 20000, vide cheque no. 00004,
cheque. Allocate the total amount as follows:

Cost Category : Department

Cost Centre Amount

Marketing 5000
Accounts 15000

 The company has pre-allocated the Event Expenses of Rs. 24000 to it’s employee-wise
as, 70% to Salesman X and 30% to Salesman Y.
 Create the following Cost Category & Cost Centres in your company:
I. Cost Category – Agent
II. Pass commission of Rs.35000 (Mohan Rs.5000, Vinay Rs. 25000, Sohan Rs.
5000) through Cash.
 Discuss various reports based on Cost Centre & Cost Categories.
 Cost Centre and Cost Categories
Q- Satya InfoTech is a software firm based in Hyderabad. The company has
installed tally. Erp 9 to track specific expenses for the departments & the office
locations of the firm. Perform corresponding entries in Tally Erp 9 on the basis of
following instances & find out details as asked:
 Company started using tally from 1.4.2014
 It has offices at two locations, namely Antra Tech Park & Gulmarg Complex.
 The company has three departments, namely Sales Engineering, Accounts.
 Major expenses borne by company are the following:
 Stationary expense.
 Electricity charges
 Rent for the premises
 Travel expenses
 Company spent 10000 on stationary Expenses for Accounts department of
both the offices on 20.4.2014.
 Company spent 15000 on travel expenses for the Sales department of
Gulmarg complex 21.4.2014.
 A total sum of Rs.6000 was paid against stationary expenses for sales &
engineering department of both the offices on 22.4.2014.
 Company paid Rs.54000 as rent for Gulmarg Complex office & Rs.66000 for
Antra tech Park office 30.4.2014.
 Company paid Rs.30000 against Electricity charges for Gulmarg complex
office & Rs.36000 for Antra tech Park office on 30.4.2014(Hint: Distribute
expenses equally if specific breakup is not mentioned).
 Find out department wise total expenses for the month of April, 2014.
 Find out total expenses borne by company for the month of April for Each
Location.
 Find out the total expenditure made on the stationary by Antra Tech Park
office.
 Inventory Management
Q1- Lakshmi Pustak Bhandari has opened its book shop at 72, college street,
Kolkata. They are using tally to maintain their inventory and record transactions.
Q2- Inventory Information:
 Unit of Measurement- Pcs
 Godowns:
o MG Road
o Main Store
 Stock Groups
o Science Books
o Arts Books
o Commerce Books
 Stock Items

Stock Item Stock Group

Concepts of Physics
Organic Chemistry Science Books

Advanced Maths
History part-1
Economics QB Arts Books

Political Sc QB
Accounts QB
Basic Maths Commerce Books

Advanced Accountancy

Q3- Opening Balances-

 Cash: Rs. 150000 (Dr)
 Capital: Rs. 100000 (Cr)
 SBI: Rs. 75000 (Dr)
 Verma Books: Rs. 25000 (Cr)
 Rashmi Book House: Rs. 14000 (Dr)
Q4- Opening Stock of goods- Rs. 11000 as follows:

Books Main Store MG Road Store Rate Amount

Accounts QB 10 20 25 750
Concepts of Physics 25 20 150 6750

Basic Maths 30 40 40 2800

Political Sc QB 05 09 50 700
Q5-Following are some transactions of the current financial year:
 Paid Rs. 10000 to Verma books in cash.
 Purchased from Anupam Agency Rs. 7000 on credit. (Inv No. 33).
Book Name Quantity Rate Amount
Advance Maths 15 100 1500
Advanced accountancy 20 250 5000
Economics QB 25 20 500
 Purchase furniture Rs. 5000 by cheque.
 Purchase rs. 500(political Sc QB-10cps)in cash from Verma Books.
 Received rs. 2000 from Rashmi Book House by cheque.
 Paid telephone Bill rs. 1,000 in cash.
 Withdrawn from bank Rs. 10000 for personal use.
 Sold goods to Ajad Book Depot on credit Rs. 15000(Bill No. abd001).
Book Name Quantity Rate Amount
Concepts of Physics 30 175 5250
Advanced maths 5 150 750
Organic chemistry 10 150 1500
Basic Maths 50 60 3000
Advanced Accountancy 12 350 4200
Economics QB 10 30 300

 Purchased the following for Rs. 1350 in cash:

Book name Quantity Rate Amount
Advanced Accountancy 5 250 1250
Accounts QB 5 20 100

 Sold goods to Pathfinder for Rs. 5, 550 in cash:

Book Name Quantity Rate Amount
Concepts of Physics 5 175 875
Political QB 15 75 1125
Advanced Accountancy 5 350 1750
Accounts QB 20 25 500
Economics QB 10 30 300
 Received from Ajad Book Depot Rs. 9000 by cheque. (Bill no. ABD001).
 Paid Rs. 7500 in cash to Anupam Agency[Inv no-33]
 Purchased books from Amar Books Rs. 3325[Ref.76]
Book Name Quantity Rate Amount
Concepts of Physics 5 150 750
Organic chemistry 7 150 1050
Basic maths 10 50 500
History Part-1 5 25 125
Advanced Maths 9 100 900
 Inventory Management
Create the following Godowns:-
Name Address
ABC H-2/3, Nirmana Road, Delhi-110084
JM K-5/2, Pusa Road, Karol Bagh, Delhi-110023
Stock Group- Laptop & Accessories
Stock Categories- HP, Lenovo & Dell
Unit of Measurement- Nos.
Create the following Stock item
Name Under Category Godowns rate
ABC JM
Earphone Accessories Lenovo 25 20 150
E-book Laptop HP 10 10 10000
Dell-Inspire Laptop Dell 5 20 22000
Battery Accessories Dell 5 5 2000

 Sold the 2 E-book@12000 to Mr.Rakesh from JM Godown.

 Purchase the 5 battery@2000 from M/s Techno Solution by cash and store
in ABC Godown.
 Sold the 1 Dell-Inspire @25000 by cash.
 Find out the Stock Summary and check the inward and outward quantity.
 2 E-book Transfer from ABC to JM Godown.
 Change the physical quantity of Earphone in JM Godown 20 to 25.
 Sold the 2 Dell-Inspire @25000 by cash and give 1 Earphone free to
customer.
 Purchase the 25 earphone @150 but billed only 22 nos of earphone from
M/S Rohan Accessories.
 Purchase the Laptop Charger 20nos@700 and get 2% trade discount from
Mohan Ltd.
 Company send the debit Note for return 2 nos of Laptop to Mohan Ltd.
 Company sold the Laptop charger 2nos@1000 to Raghav.
 Company receive 1 Laptop charger returned from Raghav.
 Order Processing
 Create required masters, record the relevant entries in the books of
Pratham Enterprises.
 Placed an order (order no: -ord/152) of 500 school Bags @150 to Mohan
Ltd. (Hint: - Enable the purchase order processing).
 Company received invoice from Mohan Ltd. (Bill No. – pur /152).
 Company returned 50 school bags to Mohan ltd. (Hint: - Enable the
Rejection Out).
 Find out the outstanding order.
 Received an order (order no: - ord/152/sl) of 400 school Bags @250 from
NK Ltd. (Hint: - Enable the sale order processing).
 Send the Invoice & Delivered the above order to NK Ltd (Bill No. – Sale
/152).
 Company receive returned back 50 school bags from NK ltd.
 Pratham Enterprises placed an order with Bell India Pvt. Ltd. For 100
computers on 1.4.2017 which is due to be received on 5.4.2017.
 On 2.4.2017, Due to unavailability of stock, only 80 computers was received
on 5.4.2017.Bill for 80 computers was received.
 Pre-close the pending Quantities which are against the order.
 Point of Sale
 Company sold the following Item.
Name of Item Qty Rate
Battery 5 2500
Ear-Phone 5 200
Laptop Charger 5 1000
Company Receive the Sodexo coupon of Rs. 1000 and rest 7500 amount receive by debit card
and 10000 amount receive by cash.
 Shobha Super Market sold 12 bottles of Olive Oil at ₹450, to a customer who made
payment using different modes - ₹1,400 by Sodexo coupons, ₹2500 by Debit card,
₹2000 by cash, and the balance payable to the customer is ₹500.
 Shobha Super Market sold 10 bottles of Olive Oil at ₹450 to a customer who paid with
sodexo Gift Coupons worth ₹1000, ₹1500 by credit card and ₹2000 by cash.
 Shobha Super Market Sold 2 Nos of Palm oil @ ₹350 each, 3 Nos of mustard oil @
₹250 each and 1 Nos of Tropicana Juice @ ₹300 each. Total bill amount is ₹1750,
Customer paid ₹750 through card and made a cash payment of ₹2000. The balance
payable is ₹1000.
 Find the POS Register.

Batch-Wise Details
 National Trader Purchased Saridon – 250 nos from Get-well Pharmacy at Rs.. 5050
each with batch number ST/101, with manufacturing date as 15-08-2017 and expiry
date is 14-08-2018
 Raise a cash sale Invoice for 200 Nos of Saridon at Rs.. 7050 from above Batch No.
ST/101
 Raise another purchase invoice on Get-Well Pharmacy for Saridon with the following
details :-
I. Batch No.: ST/102
II. Quantity : 300 nos
III. Manufactured Date : 15-05-2017
IV. Expiry Date : 31-02-2031
V. Purchase Ledger : Purchase
 Make a cash sales invoice for Saridon – 50 nos from batch ST/101 and 200 nos from
batch ST/102 at Rs.. 7050 each.
 National Trader Purchased 2000 boxes of Stamlo-2mg from Suraksha Pharmacy at Rs..
200/box. The manufacturing and expiry dated of Batch No. phar/001 are 01-04-2017
and 02-05-2017 respectively.
 Raise a cash sales Invoice for200 boxes of Stamlo-52mg at Rs.. 250/box from the above
Batch No. phar/001.
 Purchase 50 strips Disprin Tablet from KJ Distribute Rs. @ Rs.. 10 (Bill no. PUR/DT-12)
(Batch no. DT-001, MFG. 20-05-2017, Exp. 19-06-2017)
 Pass sales 20 strips Disprin Tablet against the above batch no. to Satyam & Co. @ Rs..
15 on 01-09-2017 (Bill no. SL/DT-001)
 See batch-wise details.
 Bill of Material
Q- Company decide made the students Geometry Kit.

 1 Geometry Kit required following items.

Name of Item Qty
Pen 2
Pencil 1
Eraser 2
Scale 1
Sharpener 1

 Company Purchase the following item on cash.

Name of Item Qty Rate per Qty

Pen 200 4
Pencil 100 2
Eraser 250 1
Scale 100 2
Sharpener 100 2

 Company made 50 geometry kit and sold 20 kit to Rohan Stationary with 20% profit on 1 kit by cash.

Q- Create the necessary masters and record a Manufacturing Journal for manufacturing one Computer from
the following components.
Name of the Item Quantity (in Nos)
Hard Disk Drive 1
CPU 1
Monitor 1
Keyboard 1
Mouse 1

The Standard Cost for Hard Disk Drive, CPU, Monitor, Keyboard and Mouse are ₹7000, ₹1000, ₹3000, ₹2500
and ₹1900 respectively.
 Interest Calculation
Q- Company sold the following items to Mohan communication on 30 days credit
if payment not received within 30 days company charge the interest@10% per
month. On 01/05/2017.
Name of Item Qty Rate per item

Laptop 5 25000

Q- Company received the full amount with interest from Mohan on 2/07/2017 by
cheque.
Q- Company purchase the following items from Sohan Communication on 15
days credit and interest rate@12% per month. On 02/6/2017
Name of Item Qty Rate per item

Laptop 15 22000

Q- Company paid full amount to Sohan with interest on 1/08/2017 by cash.

 Price Level & Price List
Q- Create a price level with the following specifications:
Price level name- Export Sales
Product- Samsung Galaxy Mobile
UOM- Pcs
Applicable from- 1/9/2017
Price list details:-
Up to 5 Pcs Rate-4,800 (Discount 1%)
Up to 10 Pcs Rate-4,700 (Discount 2%)
Up to 15 Pcs Rate-4,700 (Discount 4%)
Above 15 Pcs Rate-4,600 (Discount 5%)
On the above criteria, pass sales entry to SOB Distributors for 4 Pcs Mobile. Bill No. SL/MS-
005, on 2/9/2017.

Q- Create a price level with the following specifications:

Price level name- Retail Sales
Product- USB Pen Drive
UOM- Pcs
Applicable from- 1/9/2017
Price list details:-
Up to 10 Pcs Rate-1250 (No Discount)
Up to 25 Pcs Rate-1250 (Discount 5%)
Above 25 Pcs Rate-1250 (Discount 7.5%)
On the above criteria, pass sales entry to SOB Distributors for 12Pcs USB Drive. Bill No.
SL/MS-006, on 2/9/2017.
 TDS
Q-Company received bill from advertising agency of Rs.112360/- towards advertising
services. Company paid the amount to advertising agency after deduction of TDS & TDS
amount paid to authorised agency.
Q- Company receive a bill from MS Associates for commission charged Rs 20000/-
& advertisement expenses 150000/-.
Q- Company made on advance of Rs 10000/- to Rohit Agency towards advertising expenses
on which TDS will be adjusted against the 110000/- TDS is deducted which he made the
payment.
Q- Company receive a bill from computer Solution of RS 80000/- towards commission
charged computer solution has a certificate for deduction of @ 1%. Charged.
Q- Company receive a bill from Gokul Co. building for Rs. 1000000/- towards Rent on Building
& furniture Gokul Co. had a certificate for 0% deduction.
 Banking
Pratham Enterprises is based out of Bangalore & trades in Stationary items.
 For handling their regular payments, Pratham Enterprises has an account with State
bank of INDIA (SBI) with an Opening Balance of Rs. 100000/- & issues cheques for
paying to his Vendors.
 They maintain one cheque book with numbers 100501 to 100550.
 On 5.5.2017, they made a cheque payment to Ace Décor, for interior decoration
services rendered by them @6000/-. While printing, the cheque got stuck in the
printer & hence, they had to mark that cheque as cancelled & issue the next cheque in
the sequence.
 On 15.5.2017, they issued a blank cheque to their vendor Matsya store.
 What is the cheque Number issued as a blank cheque?

Q2-One stop store is a retail dealing in grocery & other household items.
 For handling their regular payments, One Stop store has an account with Axis bank
with an Opening Balance of Rs. 50000/- & issues cheques for paying to his Vendors.
 There are 4 people in their accounts department & two of them (RAM, JOHN) are
given individual cheque books while the others share a cheque book.
 They want to print a cheques instead of writing it manually so that there are no
mistakes & the cheques issued to vendors are neat
 Cheque book range for Ram is-602211-602230
 Cheque book range for John is-702231-702255
 The third Cheque book range starts from 234501 & has 50 cheques.
 Create the required masters & configure it based on the scenario described above.
 Now they upgraded to the latest release of Tally Erp 9.now they want to monitor
the same for available cheques & other cheques statuses.
 Also, they are engaging with a new vendor Mahalakshmi Traders & they have asked
them to issue a blank cheque as Security. Due to some reason, ram had to cancel
the cheque No.-602221. He issued another cheque, instead. Now he wanted to
verify how many cheques have been cancelled by him.
 Use the Cheque Register Report to view status of all cheques, create a blank
cheque from sharing cheque book & cancel the Ram’s Cheque.
 GST
Mukta traders is a company registered in Delhi (GSTIN: - 07AAACI3160Q1ZC).
Opening Balance of Following Ledger: -
Cash: ₹ 500000.
HDFC Bank: ₹1000000.
 On 1.07.2017, purchased the following goods from Kaya traders (GSTIN: -
07AAACB0876A1Z7) with supplier invoice No: pur/1.

Name of GST Quantity/Nos. Rate/Nos Amount

Item Rate
Computer 18% 100 10000 1000000

 On 1.07.2017, sold the following goods to Tara Traders, Delhi (GSTIN: -

07AABCW5412C1ZR). With Reference No. 1/MT.
Name of GST Quantity/Nos. Rate/Nos Amount
Item Rate
Computer 18% 50 11000 550000

 On 2.07.2017, purchased the following goods from Pillai Traders, Uttar Pradesh
(GSTIN: - 09AAACG0611J1ZY) with Reference No. Pur/2.
Name of GST Quantity/Nos. Rate/Nos Amount
Item Rate
Computer 18% 20 10000 200000
UPS 12% 50 2000 100000

 On 2.07.2017, sold the following goods to Maruthi Traders, Haryana (GSTIN: -

06AAJCA7647M1Z5) with Reference No. 3/MT.
Name of GST Quantity/Nos. Rate/Nos Amount
Item Rate
Computer 18% 20 11000 220000
Packing Charge = ₹4000
Discount Allowed@2%
 On 31.07.2017, Maruthi Traders returned the following goods against the sales
reference no. 3/MT.
Name of GST Quantity/Nos. Rate/Nos Amount
Item Rate
Computer 18% 2 11000 22000

 On 31.07.2017, sold the following goods on Cash (Delhi, Consumer) reference no.
4/MT.
Name of GST Quantity/Nos. Rate/Nos Amount
Item Rate
Computer 18% 2 11000 22000
  On 31.07.2017, sold the following goods to Rajesh Traders (Gujarat, Consumer)
reference no. 5/MT.
Name of GST Quantity/Nos. Rate/Nos Amount
Item Rate
Computer 18% 20 11000 220000
UPS 12% 10 2500 25000
Packing Charge = ₹14000
Check the GSTR-1 Report of July Month

 On 1.8.2017, Received the audit services from CA Sonali, Haryana (GSTIN: -

06AFOPP3600C1ZS) of Rs. 35000 + GST@18% with Invoice No. pur/3
 On 2.8.2017, sold the following goods to Maruthi Traders and also provide
software Installation Service with Reference No. 6/MT
Name of GST Quantity/Nos. Rate/Nos Amount
Item Rate
Computer 18% 20 11000 220000
UPS 12% 2 2500 5000
Particular GST Amount
Rate
Software 18% 15000
Installation

 On 2.8.2017 Mukta Traders provide support services to Tara Traders of Rs.

20000 + GST@18%. With Reference No. 7/MT
 On 2.8.2017 received Advance amount of Rs 15000 for 5 computer from
Prashant (Delhi, Consumer). With Reference No. Adv/1
 On 31.8.2017 Increase Tax liability against advance received (Ref- Adv/1).
  On 31.8.2017, Provide support services to Tara Traders of Rs. 30000 (Inclusive of
GST@18%). With Reference No. 8/MT
 On 31.8.2017, Purchase the following exempted goods from Pillai Traders with
Invoice No. pur/4.
Name of GST Quantity/Nos. Rate/Nos Amount
Item Rate
Stamps Exempted 100 250 25000

 On 31.8.2017, sold the following exempted goods to Maruthi Traders with

Reference No. 9/MT
Name of GST Quantity/Nos. Rate/Nos Amount
Item Rate
Stamps Exempted 50 350 17500

Check the GSTR-1 Report of August Month

  On 01.09.2017, Goods sold to Prashant and adjust the advance amount of Rs.
15000 with Ref No. Adv. /1.

Name of GST Quantity/Nos. Rate/Nos Amount

Item Rate
Computer 18% 5 11000 55000

 On 01.09.2017, Goods sold to Michal (Country- United States of America). Port

Code.- 855100
Name of GST Quantity/Nos. Rate/Nos Amount
Item Rate
Computer 18% 4 11000 44000
 On 02.09.2017, Goods sold to Jacky Chan (Country- China) against LUT/Bond
Details & Port Code. – 856963.
Name of GST Quantity/Nos. Rate/Nos Amount
Item Rate
Computer 18% 2 11000 22000
 On 02.09.2017, Company purchase the goods from Mr. Shah (Country- United
States of America) with Supplier Invoice No. USA/1
Name of GST Quantity/Nos. Rate/Nos Amount
Item Rate
Computer 18% 2 10000 20000
 On 30.09.2017, Decrease Tax Liability and adjust the previous period advance
amount against sale to Prashant.
 On 30.09.2017, Increase Tax Liability due to import of goods from Mr. Shah
(invoice no. USA/1).
 On 30.09.2017, Increase Input Tax Credit against the Tax Liability of Import of
goods from Mr. Shah (invoice no. USA/1).

Check the GSTR-1 Report of September Month

 Payroll
 Record the transactions for salary calculation of below table:
Employee Employee Basic DA HRA PF conveyance Pf contribution 12%
Name Group Pay Deducti
on
EPS EPF
Abhinav Accounts 20000 25% 40% of 12% 800 8.33% 3.67%
Kumar of basic pay
basic
Bhaskar Accounts 22000 25% 40% of 12% 800 8.33% 3.67%
Pandey of basic pay
basic
Chetan Finance 23000 25% 40% of 12% 800 8.33% 3.67%
singh manager of basic pay
basic
Dhiru rokaya Marketing 25000 25% 40% of 12% 800 8.33% 3.67%
of basic pay
basic
Elena Souza Marketing 15000 25% 40% of 12% 800 8.33% 3.67%
of basic pay
basic

 Create the following units of payroll:

i. Hours
ii. Minutes
iii. Compound unit: 1hr=60mints.
 Create attendance/Production type:

ABSENT
AGAINST THE FIELD Actions to be performed
Under Primary
Attendance type Leave without Pay
Period type Days

Sick Leave(SL)
AGAINST THE FIELD Actions to be performed
Under Primary
Attendance type Attendance/Leave with Pay
Period type Days
 Overtime
AGAINST THE FIELD Actions to be performed
Under Primary
Attendance type On production
Period type hr. of 60 min
 Record the attendance details:
Employee name SL(days) Absent(days)
Abhinav Kumar 0 1
Bhaskar Pandey 0 2
Chetan singh 2 0
Dhiru rokaya 1 0
Elena Souza 1 1
 Pass the transaction of Salary Payable for December month.
 On 2-01-2018, pass the transaction of Salary Payment by cash.
 Find out the Pay Slip & Pay Sheet Report.
 JOB ORDER
 Pride industries ltd. Is engaged in manufacturing & trading pressure
Cookers. It undertakes manufacturing as well as outsources manufacturing
of pressure cookers to job workers with the required specifications.
 Pride Industries ltd. has placed a job work out order for manufacturing
pressure cookers to Madan Manufacturing Co., Andhra Pradesh. The raw
materials for manufacturing a pressure cooker are purchased by Pride
industries Ltd. & are transferred to Madan Manufacturing Co.
 Handling Job work Out order processing in Tally.erp9:
Date Particulars
05-07-2017 Pride industries ltd. Purchased the following items from Global
corporation & the goods were stored in component Godown:
Name of stock item Quantity Rate(₹) Amount(₹)
Aluminium supplies 5000 20/Kg 100000
Bakelite Handle Knob 2000 10/No. 20000
Rubber Gaskets 1000 5/No. 5000
Upper Lid 2000 8/No. 16000
Lower Lid with Base 1000 10/No. 10000
05.07.2017 Voucher: Job Work Out
Pride industries ltd., placed a job work order with Madan Manufacturing Co., for manufacturing of
the following stock items
Name of stock item Quantity Rate(₹) Amount(₹)
Pressure cooker 100 1000 100000
To manufacture 1 Nos. of pressure cooker, the following components are consumed:
Name of stock item Quantity consumed
Aluminium supplies 5kgs
Bakelite Handle Knob 2Nos
Rubber Gaskets 2Nos
Upper Lid 1Nos
Lower Lid with Base 1Nos
The stock is maintained in separate Godown for job work purpose. The raw materials are stored in
COMPONENT Godown & the finished goods are stored in FINISHED GOODS Godown.
05.07.2017 Voucher: Material out
Pride industries ltd. Transferred the following component to Madan Manufacturing Co., for
manufacturing pressure cookers. A separate job worker Godown was maintained to track the job
work activities.
Name of stock item Quantity Rate(₹) Amount(₹)
Aluminium supplies 500 20/Kg 10,000
Bakelite Handle Knob 200 10/No. 2,000
Rubber Gaskets 200 5/No. 1,000
Upper Lid 100 8/No. 800
Lower Lid with Base 100 10/No. 1,000
15.7.2017 Voucher: Material In
Pride industries ltd. Received the following finished goods from Madan manufacturing Co. the
goods are stored in FINISHED GOODS Godown.
Name of stock Item Quantity Rate/Nos. Amount
Pressure cooker 100 1,000 ₹ 1,00,000
 Voucher: Purchase Voucher
17.07.2017 Pride industries Ltd. Booked the job work charges payable to Madan Manufacturing Co. & on
the same day they made a payment of ₹ 1,10,000 towards job work charges.
17.07.2017 Voucher: Payment Voucher
Pride Industries ltd. Booked made a payment of ₹1,10,000 to Madan Manufacturing Co.
towards job work charges.

 Handling Job work In order processing in Tally.erp9:

Date Particulars
05-08-2017 Pride industries ltd. Received a job work order from Sunshine industries for
manufacturing the following goods:
Name of stock item Quantity Rate(₹) Amount(₹)
Pressure cooker 50 1,000/Nos. 50,000
To manufacture 1 Nos. of pressure cooker, the following components are consumed:
Name of stock item Quantity consumed
Aluminium supplies 5kgs
Bakelite Handle Knob 2Nos
Rubber Gaskets 2Nos
Upper Lid 1Nos
Lower Lid with Base 1Nos
The stock is maintained in separate Godown for job work purpose. The raw materials & finished
goods are stored in Sunshine Godown i.e. Third party Godown.
12.08.2017 Voucher: Material IN
Pride industries ltd. Received the following components from Sunshine industries for manufacturing
pressure cookers. A separate job worker Godown is maintained to track the job work activities.
Name of stock item Quantity Rate(₹) Amount(₹)
Aluminium supplies 250 20/Kg 5,000
Bakelite Handle Knob 100 10/No. 1,000
Rubber Gaskets 100 5/No. 500
Upper Lid 50 8/No. 400
Lower Lid with Base 50 10/No. 500
15.8.2017 Voucher: Manufacturing journal
Pride industries ltd. Manufactured 50 pressure cookers using the raw materials received from
Sunshine Industries that are stored in Sunshine Godown.
16.8.2017 Voucher: Material Out
Pride industries ltd. delivered the following finished goods to Sunshine industries. The goods are
stored in FINISHED GOODS Godown.
Name of stock Item Quantity Rate/Nos. Amount
Pressure cooker 50 1,000 50,000

18.08.2017 Voucher: Sales

Booked the income of ₹ 50,000 in the sales invoice from Sunshine Industries for the job work
rendered.
18.08.2017 Voucher: Receipt Voucher
Received ₹ 50,000 from Sunshine Industries for the job work rendered.