Tally E Book 2

F1 MACRO TECHNOLOGIES(Regd.
)
(Institute of Industrial & Corporate Training)
TALLY ERP 9
CHECK LIST FOR TALLY ERP
S. NO TOPICS
1. Manual Enters
2. Company Creation
3. Company Alter
4. Company Delete
5. Shut Company
6. Company Split Data
7. Group Company
8. Backup
9. Restore Data
10. Security Control
11. Select A Company
12. Company Name
13. Change Voucher Date
14. Creating Groups
15. Creating Ledger
16. Alter Ledger & Group
17. Delete Ledger & Group
18. Stock Groups Single & Multiple
19. Stock Item Single & Multiple
20. Unit Of Measure
General Accounting Vouchers Topic
S. NO.
21. Contra Voucher
22. Payment Voucher
23. Receipt Voucher
24. Journal Voucher
25. Purchase Voucher
26. Sale Voucher
27. Stock Journal Voucher
Advance Voucher For Inventory
28. Debit Note(Purchase Return)
29. Credit Note (Sales Return)
30. Sales Order
31. Purchase Order
32. Rejection In
33. Rejection Out
34. Manufacturing Voucher
Advance Accounting Feature
35. Bills (Payable & Receivable)
36. Multi Currency
37. Interest Calculation
38. Cost Center
39. Payroll
40. Budget
41. Bank Reconciliation Statements
Advance Inventory Feature
42. Godowns
43. Stock Categories
44. Actual & Billed Qty
45. Additional Cost OF Purchase
46. Multi Price Levels
47. Batch Wise Details
48. Separate Discount Column
Advance Taxation Feature
49. Vat (Value Added Tax)
50. CST (Central Sales Tax)
51. Service Tax
52. TDS (Tax Deducted At Source)
53. TCS (Tax Collected At Source)
54. Excise Duty
Reports In Tally
55. Display Reports
56. Print Vouchers & Reports
57. Accounts Reports
58. Inventory Reports
59. Taxation Reports
Basic Terms of Accounts
Accounts
It is a summarised record of transactions at one place relating to a particular
head.
Accounting
It is the process of collecting, recording, classifying, summarising &
communicating financial information to users.
According to the American institute of certified public

accountants:-
Accounting is an art of recording ,classifying & summarising in a significant
manner & in terms of money , transaction & events which are, in part at least, of
a financial character & interpreting the result there of.
Accountancy
It is a systematic knowledge of accounting i.e. it educates how to maintain the
books of accounts.
Book keeping
It is a part of accounting .The process of recording financial transaction in a
systematic manner & classifying into ledgers.
Capital
It is the amount invested by the owner at the time of starting business. Capital is
also known as “owner’s equity” or “net worth”. It’s shown on liability side of
balance sheet & always has a Cr .balance.
Drawing
Money withdraw by the owner from the business A/c for personal use.
Liabilities
Liabilities are the claim against the financial resources. In other words, liabilities
means amount owed (payable) by the business. Liabilities are raised due to
purchase of goods or services by the business on credit.
Liabilities can be further classified into:
Non-current liabilities (long term liabilities)
It is that liabilities which are payable after a year, Example: long term loans,
debenture.
Current liabilities (short term liabilities)
It is that liability which is payable within 6 month or 1 year.
Assets
Assets is property or legal right owned by an individual or business can be
measured in money terms.
Assets can be classified into two categories
Fixed assets-Fixed assets are those assets which are held by a business from a
long term point of view. Example: furniture, vehicle, computers, land, building,
machinery etc...
Current assets
Those assets which are held by the business with the purpose of converting them
into cash with 6 month or 1 year. Example: cash in hand, cash at bank, bills
receivable etc...........
Debtors
It is a person who owes amount to the business on account of credit sales of
goods or services. It always starts with the debit balance Example: when goods
are sold to a person on credit that person will pay the price in future.
Creditors
It is the person to whom amount is owned on account of credit purchase of goods
or services. It always starts with the credit balance. Example: when goods are
purchase from a person on credit that person will receive the price in future.
Expenditure
It is the amount spent or liability incurred for acquiring assets, goods or services.
Example: salary, rent, telephone, expenses, electricity expenses etc..........
Income
It is the profit earned during a period. In other words, difference between
revenue & expenses are called income. Income is also known as profit.
Revenue
It is the amount which as a result of operations is added to capital. In other
words, it is the monetary value of products of services sold to the customer
during the period. Example: cash sales.
Discount
When customer are allowed a reduction in the prices of goods by the business. It
is known as discount.
Stock
Stock is tangible assets held by an enterprise for the purpose of sales in the
ordinary course of business.
Classification of stock
Opening stock: It is that stock in hand in the beginning of the accounting
year.
Closing stock: It is that stock in hand at the end of the accounting year.
Vouchers
It is an evidence or proof of a business transaction.
Transactions
An agreement, communication or movement carried out between a buyer and
seller to exchange an asset for payment.
Debit
It is the left side of the account.
Credit
It is the right side of the account.
Bills receivable
Bills receivable is a document that your customer formally agrees to pay at some
future date.
Bills payable
It means a bill of exchange accepted, the amount of which will be payable on the
specified date.
Prepaid expenses
It is an expense which is paid in advance and the benefit of which will be available
in the following year or years.
Outstanding expenses
It is an expense that has been incurred but has not been paid.
Proprietor
The person who makes the investment and bear all the risk connected with the
business.
Bad debts
Bad debt is the amount owed to the business that is written off because it has
become irrecoverable.
Accounting Principles
Accounting entity
According to this concept, business & owner of the business are two separates
things. This concept is also known as business entity concept.
Money measurement concept

Accounting to this concept, transaction can be measured in money terms. If the
transactions or event that cannot be measured in terms of money are not
recorded in the books of accounts.
Classification of Accounts
There are 2 types of accounts.
Traditional classification
This is an old system of classifying accounts.
personal
Accounta Real
impersonal
Nominal
Real A/C (Golden Rule)
Dr. what comes in
Cr. What goes out
Nominal A/C (Golden Rule)
Dr. All Expenses and Losses
Cr. All Income and Gains
Personal A/C
Dr. The Receiver
Cr. The Giver
Ledgers Group
Loan HDFC A/c Loans Liability
Bank SBT A/c Bank Account
Furniture A/c Fixed asset
Furniture Mart A/c Sundry Creditors
Advertisement A/c Indirect Expense

Media Advertiser A/c Sundry Creditors
Printing charge A/c Indirect Expense
Machinery A/c Fixed asset
Purchase A/c Purchase Accounts
Aroma traders A/c Sundry Creditors
Telephone charge A/c Indirect Expense
Sales A/c Sales Account
Purchase Return A/c Purchase Accounts
Kishore A/c Sundry Debtor
Sales Return A/c Sales Account
Drawings A/c Capital Account
Salary A/c Indirect Expense
A/C. A/C. GROUP
Bills Payable Current Liabilities
Bills Receivable Current Assets
Inward Carriage Direct Expenses
Outward Carriage Indirect Expenses
Purchase Purchase A/c.
Purchase Return Purchase A/c.
Sales Sales A/c.
Sales Return Sales A/c.
Drawing Capital
Motor Car Fixed Assets
Furniture Fixed Assets
Vehicle Fixed Assets

Discount Received Income Revenue
Discount Payable Indirect Expenses
Railway Freight Direct Expenses
Wages Direct Expenses
Bad Debts Indirect Expenses
Depreciation Indirect Expenses
Rent & Taxes Direct Expenses
Opening Stock Stock In Hand
Salary Indirect Expenses
Loan Received Loan Liabilities
Loan Payable Loan Assets
Bank Overdraft Bank Overdraft
Sample
Goods Tempts Sales A/c.
Goods In Fire Sales A/c.
Goods Lost Sales A/c.
Post And Telegram Expenses Indirect Expenses
Discount Received Income Revenue
Discount Paid Indirect Expenses
Commission Received Income Revenue
Commission Paid Indirect Expenses
Printing & Stationary Expenses Indirect Expenses
Machinery Fixed Assets
Repairs Of Machinery Indirect Expenses
Light Bill Of Office Indirect Expenses

Light Bill Of House (Drawing) Capital
Telephone Expenses Indirect Expenses

Telephonebill Of House
Capital
(Drawing)
Bony Indirect Expenses
Creditors Sundry Creditors
Debtors Sundry Debtors
Insurance Premium Indirect Expenses
Office Rent Indirect Expenses
Office Expenses Indirect Expenses
Advertisement Indirect Expenses
Building Fixed Assets
Office Instrument (equipments) Current Assets
Deposited (Investment) In Share Current Assets
Interest On Bank loan Indirect Expenses
Goodwill Current Assets
Bank Loan Current Liabilities
Interest Received Income Revenue
Unpaid Salary Current Liabilities
Advanced Paid Premium Current Assets
Unreceived commission Current Assets
Advanced Received Interest Current Liabilities
Charity Indirect Expenses
Income Tax Indirect Expenses
Loan In Staff Current Assets
Interest In Loan In Staff Income Revenue

Cheque Return
Goods Loss By Rain Sales A/c.
Shop Rent Indirect Expenses
Donation Indirect Expenses
Type Writer Fixed Assets
Dharmada Indirect Expenses
Computer Fixed Assets
Loss By Flood Sales A/c.
Royalty Current Assets
Trade Work
Custom Duty Direct Expenses
Conveyance Direct Expenses
Patents Current Assets
Legal Expenses Indirect Expenses
Demurrage Indirect Expenses
Remuneration Indirect Expenses
Professional Tax Paid Indirect Expenses
Dead stock Indirect Expenses
Lease Hold Land Current Assets
Lease Hold Premises Current Assets
Honorarium Indirect Expenses
Rent Received Income Revenue
Rent Paid Indirect Expenses
Compensation Received Income Revenue
Compensation Paid Indirect Expenses

Loss Indirect Expenses
Rent Received In Advanced Current Liabilities
Financial statement
The statement which shows the financial performance & financial position of the
firms.
A complete set of financial statement is:
1. Trading a/c- It is the first stage in the process of preparing the final
accounts. With the help of trading a/c we know the gross profit or gross
loss.
2. Profit and loss a/c- A profit and loss a/c is an account into which all gains
and losses are collected in order to ascertain the excess of gains over the
losses or vice versa. With the help of profit and loss a/c we know the net
profit or net loss.
3. Balance sheet- A statement which are not directly associated with sales of
goods. Example: rent received, salaries received, discount received,
commission received.
4. Direct expenses- Those expenses which are incurred on the goods
purchased, till they are brought to the place of business for sale. In other
words, direct expenses are those expenses which are related to factory
examples are freight inward, wages, carriage inward, etc.............
5. Direct income- Those incomes which are related to factory.
6. Indirect expenses- Those expenses which are not directly associated with
the sales of goods or manufacture of goods. Example: salary, rent, printing,
postage, depreciation etc................
7. Indirect income- Those incomes which are not directly associated with
sales of goods. Example: rent received, discount received, commission
received etc.....................
Assignment No 1
Q1) what is trading account?
Q2) Give five examples of direct and indirect expenses.
Q3) state whether the following statements are True or False
i) Debit means an increase in liability and decrease in an asset.

ii) Credit means an increase in assets and decrease in liability.
iii) Salary payable is a nominal account.
iv) Debit the giver and credit the receiver is the rule of personal account.
v) Some of the transactions may have only one account.
Q4) fill in the blanks with appropriate words
i) Salary is an_________________ for the employee and

_______________for the employer.
ii) Rent receivable account is a ______________ account.
iii) Dr. Stands for _____________ and Cr. Stands for ______________.
iv) Debit the ______________ and credit the _____________ is the rule of
personal accounts.
v) Debit what comes in and credit what goes out is the rule of
____________account.
Questions of trading account
Question 1)
Particulars Amount
Opening stock 10000
Wages 5000
Sales 155000
Purchase return 8000
Freight inward 500
Purchases 100000
Carriage inward 1000
Sales return 5000
Octroi duty 2500
Question 2)
Particulars Amount
Opening stock 10000
Sales 200000
Purchases 200000
Freight inward 2500
Sales return 5000
Clearing charges 11000
Purchases returns 2500
Carriage outwards 3000
Questions of Profit and Loss Account

Question 1)
Particulars Amount
Salaries and wages 3000
Commission paid 200
Postage and telegram 150
Insurance 300
Interest paid 400

Carriage outward 500
Advertising 1000
Discount allowed 1800
Rent received 1700
Interest on investment 1500
Bad debts 900
Brokerage paid 95
Gross profit 29250
Question 2)
Particulars Amount
Gross profit 120000
Rent 5000
Salary 35000
Commission paid 19000

Interest on loan 5000
Advertisement 8000
Interest received 8000
Discount received 6000
Printing and stationery 4000
Legal charges 10000
Bad debts 2000
Loss by fire 6000
Depreciation 4000
Questions of balance sheet

Question 1)
Particulars Amount
Capital 40000
Drawings 4400
Debtors 6400
Creditors 4200
Cash in hand 360
Cash at bank 7200
Plant 10000
Furniture 3700
Net profit 1660
General reserve 1000
Closing stock 14800
Question 2)
Particulars Amount
Goodwill 20000
Capital 180000
Liabilities for expenses 1200
Cash in hand 1000

Investment 20000
Bills payable 10700
Net profit 92600
Sundry debtors 50000
Land and building 60000
Bank 20000
Sundry creditors 63000
Bills receivable 13000
Plant and machinery 40000
Provisions for bad debts 2500
Closing stock 80000
Furniture 16000
Drawings 30000
Assignment No : 2
Q1) The following information of an accounting year is given: opening capital Rs.
60,000, drawings Rs. 5,000, capital added during the year Rs. 10,000 and closing
capital Rs. 90,000. Calculate profit and loss for the year.
[Profit-Rs. 25,000]
Q2) From the following information prepare the trading account for the year
ending 31st March, 2007.
Adjusted purchases Rs. 11,00,000, Sales Rs. 12,50,000, Freight and carriage
inwards Rs. 6,000, Wages Rs. 14,000, Freight and cartage outwards Rs. 5,000.
[1,30,000]
Notes: 1) Adjusted purchases = Net purchases+ opening stock- closing stock
2) Closing stock has not been shown on the credit side of the trading
account because it has already been adjusted while calculating adjusted
purchases.
3) Freight and cartage outwards are indirect expenses and hence not
debited to the trading account.
Q3) Explain the objective of preparing a profit and loss account.

Q4) The following information was taken from an income statement:
Opening stock Rs. 5,000; Sales Rs. 16,000; Carriage inward Rs. 1,000; Sales returns
Rs. 1,000; Gross profit Rs. 6,000; Purchases Rs. 10,000; and Purchases returns Rs.
900. Calculate the closing stock.
[Closing stock Rs- 6,100]

Tally
Introduction
In the simplest terms tally can be defined as financial accounting software.
Features of tally
 Less typing work.

 All the groups and ledgers are available.
 No need to create balance sheet, profit & loss and trading A/C.
 No calculation work
 High storage capacity.
 Interest calculation.
 Record of multiple companies.
Difference between Manual & Computerized Accounting.
Manual Accounting Computerized Accounting
Need to create the Profit and loss A/c No need to create profit and loss A/c
Take user time to enter all the records Time saving.

i.e. journal-ledgers, trail balance,
trading A/c, profit and loss A/c and
balance sheet.
We can’t create budgets, cost centre We can create budgets, cost centre
etc.............. etc...........
Introduction of all version of tally:
1. Tally 4.5- It based on MS-DOS.

2. Tally 5.4- It based on window, it has facilities of inventory
information(stock maintain)
3. Tally 6.3- It has facility of internet.
4. Tally-7.2- It has facilities of VAT, TDS AND ST.
5. Tally 8.1- It has facilities of excise tax
6. Tally 9.0- It has facilities to synchronize the data and activities as many
of its functions.
7. Tally.ERP 9-It has all functions e.g. taxes, payroll, budget etc.............
COMPUTERIZED ACCOUNTING WAY
When you start the tally, the screen on the right part display the company into
option.
COMPANY
Company means any entity including all business entity like proprietorship,
partnership, non-profit organization or a company and even an individual for
which a separate book of accounts is maintained.
Steps to create a new company
Press Alt+f3 for company info-click on create company and the details of the
company.
Steps to shut a company
Press Alt+f3 for company info-click on shut company option-select the company
which you want to shut.
Steps to select a company
Press Alt+f3 for company info-click on select company option-select the company
name which you want to open.
Steps to delete the company
Press Alt+f3 for company info-click on alter option-press alt+d to the company.
LEDGERS
Ledgers are also called the principle book; ledgers are allocated to create groups
for the better control of accounts.
LEDGER AND ITS GROUPS
Ledger Group
Capital Capital account
Machinery Fixed assets
Sales Sales account
Purchase Purchase account
Sales return Sales account(DR)
Opening stock Stock in hand
Drawing Capital account(DR)

Wages Direct expenses
Carriage inward Direct expenses
Closing stock This entry done in alter option in

opening stock ledger.
Salaries Indirect expenses
General expenses Indirect expenses
Purchase return Purchase account(CR)
Debtors Sundry debtors
Cash This entry done in alter option in cash

ledger.
Carriage outward Indirect expenses
Rent Indirect expenses
Advertisement Indirect expenses
Creditors Sundry creditors
Bank Bank account
Sundry expenses Indirect expenses
Discount Indirect expenses
Printing Indirect expenses
Insurance Indirect expenses

Travelling expenses Indirect expenses
Postage and telegram Indirect expenses
Miscellaneous expenses Indirect expenses
Bad debts Indirect expenses
Loan Loan liabilities
Business premises Fixed assets
Bills payable Current liabilities
Building Fixed assets
Fixtures and fittings Fixed assets
Commission (CR) Indirect income
Bills receivable Current assets
Discount(CR) Indirect income
Depreciation Indirect expenses
Rent received Indirect income
Bank overdraft Bank od a/c
Trade expenses Indirect expenses
Electric charges Indirect expenses
Cash at bank Bank account

Plant and machinery Fixed assets
Repairs Indirect expenses
Manufacturing expenses Direct expenses
Bank charges Indirect expenses
Freight inward Direct expenses
Freight outward Indirect expenses
Interest Indirect expenses
Taxes and insurance Indirect expenses
General expenses Indirect expenses
Commission Indirect expenses
Steps to create ledgers
Gateway of tally-accounts info-ledgers-single/multiple-create.
Q1: Following balance were extracted from the books of Shri Vishwanatham on
31 march 2014
Opening balance Amount(Rs)
Capital 3600
Machinery 700
Sales 8200
Purchases 4000
Sales return 100

Opening stock 1000
Drawings 400
Wages 1000
Carriage inward 50
Salaries 600
General expenses 200
Rent 500
Purchase return 50
Debtors 3000
Cash 400
Carriage outward 200
Advertising 200
Creditors 500
Closing stock 2000
Q2: Prepare final account using following balances
Particulars Amount
Machinery 3500
Debtors 2700
Drawings 900
Purchases 9500
Wages 5000
Bank 1500
Opening stock 2000
Rent 450
Sundry expenses 200
Carriage inward 150
Capital a/c 10000
Creditors 1400
Sales 14500
Closing stock 300
Q3. Prepare the final account of Bhagwan Das on 31st March
Particulars Amount
Sales 92000
Purchases 68300
Return inward 1300
Return outward 2200
Sales 17600
Rent, rates and taxes 2200
Discount 3750
Printing 720
Insurance 500
Travelling expenses 1400
Postage and telegram 620
Miscellaneous expenses 900
Bad debts 400
Debtors 22000
Creditors 12800
Loan 5000
Capital 52500
Drawings 1910
Business premises 39000
Office furniture 1500
Closing stock 24000
Q4. Prepare trading, p&l a/c and balance sheet as on 31st march 2007.
Particulars Amount
Capital 36000
Creditors 8720
Bills payable 2527
Sales 78182
Loan 12000
Debtors 3885
Salaries 4000
Discount 1000
Postage 273
Bad debts 287
Interest 1295
Insurance 417
Machinery 10000
Opening stock 9945
Purchases 62092
Wages 4300
Buildings 23780
Fixtures and fittings 16155
Closing stock 14300
Q5. Prepare final account using following balances.
Particulars Amount
Capital 18000
Opening stock 2720
Bills payable 4827
Creditors 7581
Cash at bank 1900
Machinery 6710
Buildings 5290
Commission (cr) 390
Debtors 8100
Bills receivable 3291
Sales 12439
Purchases 10492
Return inward 1000
Return outward 1200
Cash in hand 1400
Insurance 119
Postage 132
Discount (cr) 627
Salaries 1400
Carriage 400
Wages 1510
Depreciation 600
Closing stock 7929

For display
Gateway of tally-balance sheet-Press F2 and give the closing date.
AND
Gateway of tally-profit and loss account-Press F2 and give the closing date.
Vouchers
Vouchers are used to record the day by day transactions.
Tally has following types of in-built vouchers.
 Contra voucher
o This voucher is used to record the cash and bank transactions.
 Payment voucher
o This voucher is used for cash payment.
 Receipt voucher
o This voucher sis used for cash receive.
 Journal voucher
o This voucher is an adjustment amount between two or more ledgers
accounts, without effecting cash or bank a/c.
 Sales voucher
o This voucher is used for credit sales.
 Purchase voucher
o This voucher is used for credit purchase.
To create the vouchers
Create a company-accounting voucher
Shortcut key for online creation is Alt+C
Shortcut key for single entry mode is Ctrl+V
For display of the vouchers
Gateway of tally-display-trial balance-press F12-show transactions-yes
Illustration 1
 Shyam started business with cash amounting Rs. 100000

 Opened an account in state bank of India and deposited Rs. 5000
 Purchased furniture for cash amounting Rs. 2000
 Purchased goods from M/s Raja Rao Bros on credit amounting Rs. 20000
 Sold goods to M/s Shalu & Co. For cash amounting Rs. 5000
 Sold goods to Ramesh on credit for Rs. 3000
 Received cash from Ramesh Rs. 2000
 Paid Rs. 2500 to the clerk as salary
 Commission received by cheque Rs. 2000
Illustration 2
 Received cash from Ram amounting Rs. 5000

 Purchased goods for cash amounting Rs. 1500
 Sold goods to Hari amounting Rs. 1200
 Paid Ramavtar amounting Rs. 400
 Received from Hari amounting Rs. 100
 Bought furniture from bank amounting Rs. 200
 Paid rent amounting Rs. 280
 Paid salary amounting Rs. 500
Illustration 3
 Shan commenced business with cash amounting Rs. 50000

 Purchase goods for cash amounting Rs. 10000
 Purchase goods from Mohan on credit amounting Rs. 6000
 Paid into bank amounting Rs. 5000
 Purchased furniture amounting Rs. 2000
 Sold goods for cash amounting Rs. 7000
 Sold goods to Ram on credit amounting Rs. 5000
 Cash sales amounting Rs. 3500
 Paid to Mohan on account amounting Rs. 3000
 Paid wages amounting Rs. 100
 Paid salaries amounting Rs. 2800
 Paid for postage amounting Rs. 15
Illustration 4
 Mohan commenced business with cash amounting Rs. 50000

 Purchase goods for cash amounting Rs. 10000
 Purchased goods from Mohan on credit amounting Rs. 6000
 Paid into bank amounting Rs. 5000
 Purchased furniture amounting Rs. 2000
 Sold goods to Ram on credit amounting Rs. 5000
 Cash sales amounting Rs. 3500
 Paid to Mohan on account amounting Rs. 3000
 Paid wages amounting Rs. 100
 Paid salaries amounting Rs. 2800
Illustration 5
 Kamal started business with cash amounting Rs. 100000

 Bought goods for cash amounting Rs. 30500
 Opened bank account with cash amounting Rs. 50000
 Bought goods from Surya on credit amounting Rs. 30000
 Sold goods to Rakesh on credit amounting Rs. 25000
 Purchased plant and machinery and payment is made by cheque amounting
Rs. 16000
 Paid to Surya in cash amounting Rs. 10000
 Received loan from Anil and deposited the same into bank amounting Rs.
8000
 Goods returned to Surya amounting Rs. 1000
 Withdrew from bank for personal use amounting Rs. 5000
 Paid to Surya by cheque amounting Rs. 8000
 Received cash from Rakesh amounting Rs. 10000
 Purchased stationery for cash amounting Rs. 200
 Paid wages and salaries amounting Rs. 10000
INVENTORY
Inventory means stock
Create a company on accounts with inventory
Stock Group
Stock groups in inventory info are similar to groups in accounting masters. They
are helpful in the classification of stock items.
Steps of stock groups
Gateway of tally-inventory info-stock groups-single/multiple-create.
Stock items
Stock items are the elementary inventory information, which can be issued or
received.
Steps of stock items
Gateway of tally-inventory info-stock items-single/multiple-create.

ASSIGNMENT OF INVENTORY
Illustration 1:
S.No Stock Group Stock Items Quantity Rate Value

1. Electronics CPU 10 Rs. 3,540.00 Rs. 35,400.00
2. Electronics UPS 15 Rs. 6,500.00 Rs. 97,500.00
3. Electronics LCD 5 Rs. 20,000.00 Rs. 1,00,000.00
4. Electronics LED 4 Rs. 30,000.00 Rs. 1,20,000.00
5. Stationery Notebook 3 Rs. 150.00 Rs. 450.00
6. Stationery Cashbook 5 Rs. 100.00 Rs. 500.00
7. Stationery Receipt book 6 Rs. 100.00 Rs. 600.00
For display
1) Gateway of tally-display-stock summary-press enter for more detail.

Company Features
There are three types of company features:
1) Accounting features
2) Inventory features
3) Statutory & taxation
Accounting features
The accounting feature consists of configuration/functionality, which generally

affects accounting transactions and reports. The accounting feature are further
sub-divided into six sections
 General
 Outstanding management
 Cost/profit centres management
 Invoicing
 Budgets/scenario management
 Other features
Steps of accounting features
Gateway of tally-press f11 for company features-press f1 for accounting features.
Inventory features
The inventory features comprises of configurations/functionality pertaining to

inventory transactions and reports. The inventory features are further sub-divided
into seven sections, namely
 General
 Storage & classification
 Order processing
 Invoicing
 Purchase management
 Sales management
 Other features
Steps of inventory features
Gateway of tally-press f11 for company features-press f2 for inventory features.
Statutory & taxation
The statutory & taxation features comprises of configurations/functionality

pertaining to statutory compliances. The following features is available, when
India is selected in the statutory compliances for field in the company creation
screen
 Excise
 Value added tax
 Service tax
 Tax deducted at source
 Tax collected at sourced
 Payroll statutory
Steps of statutory features
Gateway of tally-press f11 for company features.
GODOWNS
It is a place where we can store our goods. Company also wants to track the
goods sent out for job work and material received for job work by creating
different locations.
Steps to create the godowns
 Create a company-press F11-press F2

 Maintain multiple godowns-yes
 Gateway of tally-inventory info-stock items-create
 Gateway of tally-inventory info-godowns-create
 Gateway of tally-inventory voucher-press F9 for purchase-press F8 for sale.
Stock journal is used to transfer the items from one place to another.
Alt+F7-for stock journal

For display
Gateway of tally-display-statement of inventory-godowns.

Q.1) Create five Godowns of company and maintain their
stock as follows:
Godown name Product name Unit Price(per unit)
Mumbai Lux soap 12 dz. 60
Delhi Pencil 12 dz. 36
Jaipur Shirts 100 pcs. 500
Goa Accessories 10 set 120
Banglore Computer 1 set 20000

Question 2: Record the following transactions:
1. Rahul & Raj are the owner of the company named R&R Co.
2. Owners introduce some amount as Capital
a. Rahul’s Capital: Rs. 30,000.00
b. Raj’s Capital: Rs. 70,000.00
3. They decide to open some Godowns at the following locations:
a. Sarita Vihar
b. Kamla Nagar
c. Maya Puri
d. Karol Bagh
4. They decide to open a bank account in HDFC Bank & deposit Rs. 13,000.00
5. Purchase goods from PPQ Traders
Bill No: P-PPQ-001
Godown: Sarita VIhar
Item Qty Rate
CPU 10 Rs. 3,000.00
UPS 20 Rs. 4,000.00
6. Transfer goods from Sarita Vihar Godown to Mayapuri Godown
Item Qty
CPU 3
UPS 4
7. Sold goods to SSN Traders

Item Qty Rate
CPU 2 Rs. 3,500.00
UPS 3 Rs. 4,500.00
8. Paid rent for Kamla Nagar Godown amounting to Rs. 3500.00

9. Transfer goods from Sarita Vihar Godown to Karol Bagh.
Item Qty
CPU 4
UPS 3
10.Paid interest on security amounting Rs. 300.00
BUDGET
Budget is used to control the expenses.
Steps to create budget

 Maintain budget and control-yes
 Gateway of tally-accounts info-budget-create

 Give the budget name
 Accounts name(press Alt+c and create the ledger of your expenses)
 Type of budget-on closing balance
 Give the amount of the expenses(one year)
 Gateway of tally-accounting voucher-press F5
 Pay the amount of the expenses (one month)-accept it.
For display
Gateway of tally-display-trial balance-press Alt+B for budget-Press Alt+F1 for

detail.
COST CENTRE AND CATEGORIES
Cost centre and categories is used for department wise detail.
Steps to create cost centre and categories

 Maintain cost centres-yes
 More than one payroll/cost category-yes
 Gateway of tally-accounts info-cost categories-create
 Gateway of tally-accounts info-cost centres-create
 Gateway of tally-accounts info-ledger-create the ledger of salary
1) salary
Under-indirect expenses
Cost centre are applicable-yes

Gateway of tally-accounting voucher-press F5 for payment voucher-press F2 to
change the date-pay the salary according to the department.
For Display
Gateway of tally-display-statement of accounts-cost centre-category summary.

TAXATION
TDS
TDS stands for Tax Deducted at Source. This tax is provided by income tax
department. TDS is one of the modes of collection of taxes, by which a certain
percentage of amounts are deducted by a person at the time of
making/crediting certain specific nature of payment to the other person and
deducted amount is remitted to the Government account.
Steps to create TDS
Create a company-press F11-press F3
Enable Tax Deducted at Source (TDS)-yes
Set/alter TDS detail-yes

Deductor type-government
Pan/It No.-give pan card no (abcde12345)
Gateway of tally-accounts info-ledger-create
1) TDS
Under-duties and taxes
Type of duty tax-TDS
Nature of payment- fees for professional or technical services.
2) Fees
Is TDS applicable-yes
Default nature of payment- Fees for professional or technical services.
3) Future mind
Under-sundry creditors
Is TDS deductable-yes
Deductee type- body of individuals
Pan/IT no-give pan card number
Gateway of tally-accounting voucher-Press F7 for journal voucher
DR –Fees
CR-Future mind
CR-TDS
For display
Gateway of tally-display-statutory report-TDS report-computation.

TCS
TCS stand for tax collected at source.
The seller has to collect tax from the payer who has purchased the following
items:
 Alcoholic liquor for human consumption

 Tendu leaves
 Timber obtained under a forest lease
 Timber obtained by any mode other than under a forest lease
 Any other forest produce not being timber or tendu leaves
 Scrap
 Parking lot
 Toll plaza
 Mining and quarrying
The TCS on the above mentioned items vary from 1% to 5%
Deposit of TCS amount- within seven days of the following month.
Issue of TCS certificate- within in one month of collection /debit (form 27D)
The rates of TCS for representative purpose (Financial

Year 2010-11):
Steps to create TCS
Enable Tax Collected at Source (TCS)-yes
Set/alter TCS detail-yes
Collector type-others
Gateway of tally-account info-ledger-create
1) Sale
Under-sale account
2) Purchase
Under-purchase account
3) Customer
Under-sundry debtors
Is TCS applicable-yes
Buyer/lessee-body of individuals
Is lower/no collection applicable-yes
TCS lower rate (%)-give TCS %
4) Supplier
5) TCS
Type of duty/tax-TCS
Nature of goods/contract/license/lease-select TCS type
Gateway of tally-inventory info-stock items-create

Gateway of tally-accounting voucher-press F9 for purchase-press F8 for sale and
calculate TCS after double enter.
For display
Gateway of tally-display-statement of accounts-TCS outstanding-TCS payable.

To pay the TCS amount
Gateway of tally-accounting voucher-press F5 for payment voucher and pay the

TCS amount.
VAT
VAT stands for Value Added Tax. The VALUE ADDED TAX was introduced as an
indirect tax into the Indian taxation system from 1 April 2005. The existing General SALES
TAX Laws were replaced with the Value Added Tax Act (2005) and associated VAT
Rules. Haryana became the first State in the country that had adopted the taxation on 1
April 2003.
Sales tax is redefined & renamed as a VAT. But central sales tax is remain same
name and applicable as CST.
Sales tax has two types.
1) Local sales tax that is also called VAT.

2) Central sales tax that is called CST.
Rates of Vat i.e 1%, 5%, 12.5%, 20%

VAT RATES
1% Is used for selling gold silver diamonds

etc.
5% Is used for selling rice pulse medicine etc.
12.5% Is used for cosmetic item, packed tin

food, packed water & luxurious item.
20% For liquor product.
Presently VAT is followed in over 160 countries. The proposed Indian model of
VAT will be different from VAT, as it exists in most parts of the world. In India, VAT
has replaced the earlier State sales tax system.
Composition scheme under VAT Act
Registration and payment of taxes under VAT act can be two types.
1) The registration and payment of taxes under full VAT.

2) The registration and payment of taxes under composition.
When VAT is paid at the time of purchases:
Purchase A/C DR.
VAT paid (input VAT) A/C DR.
To cash A/C bank A/C/Creditors CR.
When VAT is collected at the time of sales:
Cash A/C/bank A/C/Debtors A/C DR.
To sales CR.
To VAT collected CR.
When VAT is paid to the Government

a) VAT paid
Vat paid A/C DR.
To Vat collected A/C CR.
b) VAT collected
Vat collected A/C DR.
To cash/bank A/C Cr.
To create the VAT
Create a company-Press F11-Press F3
Enable Value added tax (VAT)-yes
Set/alter VAT detail-yes
State-Delhi
Type of dealer-regular
1) Sales
Under-sales account
Used in VAT return-yes
VAT/tax class-select VAT category
2) Purchase
Used in VAT return-yes
3) Customer
4) Supplier
5) Input VAT
Type of duty/tax-VAT
6) Output vat
Type of duty/tax-VAT
Gateway of tally-accounting voucher-press F9 for purchase and calculate Input

VAT after double enter-press F8 for sale and calculate Output VAT after double
enter.
For display
Gateway of tally-display-statutory report-VAT report-VAT computation.

SERVICE TAX
This tax comes into effect in 1994. It is a tax payable on services provided by the
service provider. Just like Excise duty is payable on goods which are
manufactured, similarly Service tax is payable on services provided.
This tax is payable by the provider of services to the Govt of India. However, the
service provider can collect this tax from the consumer of services (also referred
to as recipient of service) and deposit the same with the Govt.
SERVICE TAX RATES
The current service tax rate is 12%.
Education cess @ 2% and senior and higher education cess @ 1% are also liable to
be payable on the above service tax rate.
Service tax rate =12%
(+)Education cess @ 2% =0.2%
(+)Senior and higher education cess =0.1%

@ 1%
Effective service tax rate =12.36%
Steps to create service tax
Create a company-Press F11-press F3
Enable service tax-yes
Set/alter Service tax detail-yes

1) Sales
Under-sales account
Is service tax applicable-yes
Category name-select service tax category
2) Purchase

3) Customer
Set/alter service tax details-yes
4) Supplier
Set/alter service tax details-yes
5) Input service tax
Type of duty tax-service tax
6) Output service tax
Type of duty tax-service tax
Gateway of tally-accounting voucher-press F9 for purchase and calculate input

service tax after double enter-press F8 for sale and calculate output service tax
after double enter.
For display
Gateway of tally-display-trial balance-press enter for detail.

EXCISE DUTY
An excise or excise tax (sometimes called a duty of excise special tax) is an

inland tax on the sale, or production for sale, of specific goods or a tax on a good
produced for sale, or sold, within a country or licenses for specific activities.
Excises are distinguished from customs duties, which are taxes on importation.
An excise is considered an indirect tax, meaning that the producer or seller who
pays the tax to the government is expected to try to recover or shift the tax by
raising the price paid by the buyer. Excises are typically imposed in addition to
another indirect tax such as a sales tax or value added tax (VAT).
Steps to create Excise duty
Enable excise-yes
Set/alter excise detail-yes

Gateway of tally-accounts info-voucher type-create
1) Excise on purchase
Type of voucher-purchase
Use for excise-yes
Name of class-purchase
Include these group select two options (bank account, sundry creditors)
Ledger name-press Alt+C and create the ledger of purchase
Ledger name-press Alt+C and create two ledger (input excise, ed cess)
2) Excise on sale
Type of voucher-sales
Use for excise-yes
Name of class-sale
Include these group select two options (bank account, sundry debtors)
Ledger name-press Alt+C and create the ledger of sale
Ledger name-press Alt+C and create two ledger (output excise, ed cess)
1) Supplier
Set/alter excise details-yes
Default nature of purchase-first stage dealer
2) Customer
Set/alter excise details-yes
Default nature of purchase-second stage dealer
Gateway of tally-accounting voucher-press F9 for purchase-press F8 for sale.

For Display
Gateway of tally-display-statutory report-excise report-dealer-excise stock

register.
PAYROLL
In a company, payroll is the sum of all financial records of salaries for an

employee, wages, bonuses and deductions. In accounting, payroll refers to the
amount paid to employees for services they provided during a certain period of
time.
To create the payroll
Maintain payroll-yes
More than one payroll/ cost category-yes

Gateway of tally-payroll info-pay heads-create
1) Basic salary
Pay head type-earning for employees
Calculation type-on attendance
Attendance/leave with pay- press Alt+C and create the account of present.
Calculation period-months
Per day calculation basis- as per calendar period
2) HRA (House Rent Allowance)

Calculation type-as computed value
On current earning totals-on specified formula
Slab type-percentage
3) TA (Travelling Allowance)
On current earning total-on specified formula
4) DA (Dearness Allowance)
5) PF(Provident Fund)
Pay head type-deductions from employees
Under-current liabilities
Gateway of tally-payroll info-employees group-create
Gateway of tally-payroll info-employees-create

Gateway of tally-payroll info-salary detail-create
Gateway of tally-payroll voucher-press F2 and enter date-ctrl+F5 for attendance
voucher-alt+a for auto filter-ctrl+F4 for payroll-alt+a for auto filter.
For display
Gateway of tally-display-payroll report-statement of payroll-payslip.

ASSIGNMENT OF PAYROLL
Q.2 Payroll Entries
Name Designation HRA TA DA PF Basic Salary
Sanchit Director 16% 5% 20% 4% 30000

Sharma
Pooja gupta Manager 16% 5% 20% 4% 18000
Manish Goel Team 16% 5% 20% 4% 15000

Leader
Sheetal Sinha Accountant 16% 5% 20% 4% 15000
Anushka General 16% 5% 20% 4% 20000

verma Manager
And find out Net Salary of each Employee
MANUFACTURING OR BILLS OF MATERIAL
A bill of materials or product structure (sometimes bill of material or BOM) is a

list of the raw materials, sub-assemblies, intermediate assemblies, sub-
components, parts and the quantities of each needed to manufacture an end
product. A bill of material may be used for communication between
manufacturing partners, or confined to a single manufacturing plant.
Steps to create bills of material
Create a company-press F12-Accts/inventory info

Allow components list detail (bills of material)-yes
Gateway of tally-accounts info-voucher type-create
1) Manufacturing
Type of voucher-stock journal
Use as a manufacturing journal-yes

Gateway of tally-inventory info-stock items-create the sub parts
Gateway of tally-inventory info-stock items-create main part
Set components (BOM)-yes
Unit of manufacture-1
Gateway of tally-accounting voucher-press Alt+F7 and select manufacturing

option.
For display
Gateway of tally-stock summary-press enter for detail.
Purchase and Sales Order

When the order is placed with the suppliers for the supply of goods, the
Items, quantities, date of receipt etc., details are given with the
Purchase Order Number. Later, when these goods are received,
the Purchase Order is tracked for the Order Details either in the receipt
note or in the purchase Invoice.
The Outstanding Purchase Order reports are available in Tally.ERP 9. It
is possible to know the order position of any item in the Stock
Summary. Separate Purchase Order Outstanding report and Purchase
Order Summary report are also available.
Steps to creating purchase and sales order
Allow purchase order processing-yes
Allow sales order processing-yes
Use debit/credit notes-yes
Use invoice mode for credit notes-yes
Use invoice mode for debit notes-yes
Use tracking numbers (delivery/receipt notes)-yes
Use rejection inward/outward notes-yes
Gateway of tally-accounting voucher
Alt+F4-for purchase order
Alt+F9-for receipt note
Alt+F6-for rejections out
F9-purchase
Ctrl+F9-debit notes
Alt+F5-sales order
Alt+F8-delivery note
Ctrl+F6-rejections in
F8-sales
Ctrl+F8-credit note
For display: gateway of tally-stock summary

Additional Assignments
Assignment 1
1. Company has opening cash balance amounting Rs. 5, 00,000
2. Mr. Navneet is owner the company, his opening Capital balance is Rs.
5,00,000
3. Company purchase from Komal & company
Bill. No :- P- K&C-001
Items Rate Vat
Laptop 50000 4%
TV 35000 4%
A.C 12000 4%
LCD 34500 4%
LED 78000 4%
4. Company purchase from Ramesh & Company
Bill. No :- P- R&C-001
Items Rate Vat
Laptop 10000 12.5%
TV 35000 12.5%
A.C 30000 12.5%
5. Company sold goods to Sahil & company
Bill. No :- S- S&C-001
Items Rate Vat
Laptop 60000 4%
TV 45000 4%
A.C 22000 4%
LCD 54500 4%
LED 88000 4%
6. Company return goods to Komal & company
Bill. No :- P- K&C-001
Items Rate Vat
Laptop 45000 4%
TV 25000 4%
A.C 10000 4%
LCD 24500 4%
LED 60000 4%
7. Company sold to Mukesh & co.
Bill. No :- S- M&C-001
Items Rate Vat
Laptop 60000 12.5%
TV 45000 12.5%
A.C 22000 12.5%
8. Purchase return to Ramesh & co.
Bill. No :- P- R&C-001
Items Rate Vat
Laptop 12000 12.5%
TV 35400 12.5%
A.C 23000 12.5%
9. Sales return to sahil & Co.
Bill. No :- S- S&C-001
Items Rate Vat
Laptop 40000 12.5%
TV 44000 12.5%
A.C 23000 12.5%
10. Company paid to Komal & Company Rs. 46,800 in cash
11. Company paid to Ramesh & company Rs. 5175 in cash
12. Company received from Sahil & company Rs. 107905 in cash
Answer
Balance sheet 1008905
Closing stock (189900)
Cash 1055930
Assignment 2
1. Company has to pay Mr. Ram lal Rs. 100000
2. Company purchase from Rahul & Company Rs. 50,000 and bill no is P-R&C-
001
3. Company purchase from Rajesh & Company Rs. 25,000 and bill no is P-
RA&C-001
4. Company purchase from Rani & Company amounting Rs. 50,000 and apply
Vat @ 12.5% & bill no is P- RN&C-001
5. Company purchase from Anjali kumara & sons
Bill no :- P- A&S-001
ITEMS RATE VAT
Gold 60000 1%
TV 45000 4%
A.C 55000 12.5%
6. Company purchase from Pratap Singh & Company amounting Rs. 30000
and apply vat @ 1% & bill no is P- PS&C-001
7. Company sold to Pragya & Company amounting Rs. 25,000 and apply Vat @
1% & bill no is S- PR&C-001
8. Company sold to goyal & company amounting Rs. 35000 and apply vat @
4% & bill no is S-G&C-001
9. Company sold to Kavita & company amounting Rs. 10000 and apply vat @
12.5% & bill no is S-K&C-001
10.Company sold to sharda & company
Bill no :- S- S&S-001
ITEMS RATE VAT
Gold 10000 1%
TV 25000 4%
A.C 15000 12.5%
11.Company sold to Priyanka & company
Bill no :- S- P&S-001
ITEMS RATE VAT
Gold 10000 1%
TV 15000 4%
A.C 5000 12.5%
12.Company sold to antima & company
Bill no :- S- A&C-001
ITEMS RATE VAT
Gold 10000 1%
TV 15000 4%
A.C 5000 12.5%
13.Company sold to anjali & company
Bill no :- S- P&S-001
ITEMS RATE VAT
Gold 10000 1%
TV 15000 4%
A.C 5000 12.5%
14.Company paid to Rajesh and company with the ref. no P- RA&C-001
amounting Rs. 10,100 by ICICI bank
15.Company paid to rani and company with the ref. no P- RN&C-001
amounting Rs. 56,250 by ICICI bank and Anjali Kumari & Sons with the ref.
no P- A&S-001
16.Company paid to Pratap Singh & com with the ref no P- PS&C-001
amounting RS. 30,300 by ICIC bank
17. Company received from Pragya & com with the ref. no S- PR&C-001
amounting Rs. 25,250 by ICICI bank and goyal brothers with the ref. no S-
G&C-001 amounting Rs. 36,400
ANSWER
BALANCE SHEET 57,615
CLOSING STOCK 1,05,000
ASSIGNMENT 3
1. Mr. Rajendra Kumar is owner of the company his capital opening balance is
Rs. 25,24,125
2. Company has taken loan previous year, there opening balance is
a. ICICI bank Rs. 5,67,124
b. HDFC bank Rs. 2,15,725
3. Company has to pay of previous year
Name Amount
Kelash chand & com 5,00,000
Sunjay Singh & com 2,25,000
Singh & com 2,25,000
4. Company has opening stock
Item name Quantity Rate Units
Aashirwad Aata (5kg) 50 490 Pkt.
Aashirwad Aata (10 kg) 95 513 Pkt.
Swastika Aata(5 kg) 51 123 Pkt.
Swastika Aata( 10kg) 95 50 Pkt.
Madhushree Tea(50gm) 7 500 Pkt.
Madhushree Tea( 100gm) 1000 13.50 Pkt.
Madhushree Tea(250 gm) 700 31 Pkt.
Madhushree Tea( 500gm) 425 60 Pkt.
Madhushree Tea(1 kg) 200 95 Pkt.
Tata Tea (100gm) 1000 13 Pkt.
Tata Tea (500gm.) 1000 75 Pkt.
Zotex (100 ml.) 2000 110 Nos.
Spicy Cool (100 ml) 300 85 Nos.
Zotex (200 ml) 500 195 Nos.
Java(50ml) 200 45 Nos.
Java (100 ml) 300 60 Nos.
Axe (100 ml) 500 125 Nos.
Axe (200 ml) 200 210 Nos.
Rexsona (100 ml) 1000 135 Nos.
Rexsona (200 ml) 500 225 Nos.
Lux soap (75gm) 2500 9.75 Nos.
Lux soap (100gm) 1500 14.13 Nos.
Lux soap (125 gm) 1000 15.50 Nos
Breeze (100gm) 5000 6 Nos.
Dove Soap (100 gm) 500 21 Nos.
Dove Soap (200 gm) 500 40 Nos.
Pears Soap (100 gm) 225 25 Nos.
Dabur Awala (100 ml) 250 17 Nos.
Dabur Awala (200 ml.) 250 31 Nos.
Paracute Oil (100 gm.) 500 15 Nos.
Paracute Oil (200 gm.) 600 25 Nos.
Shanti Awala (100 ml.) 500 15 Nos.
Vatika Hair Oil (100ml.) 250 61 Nos.
Sunsilk Shampoo (100ml.) 50 20 Nos.
Sunsilk Shampoo (200ml.) 50 51 Nos
Clinic plus (100 ml.) 100 30 Nos.
Clinic all clear (100 ml.) 100 35 Nos.
Clinic all clear (200 ml.) 100 60 Nos.
Chic shampoo (100 ml.) 25 25 Nos.
Chic shampoo (50 ml.) 500 13 Nos.
Ayur shampoo (500 ml.) 500 15 Nos.
Ayur shampoo (100 ml.) 500 28 Nos.
Vatika Shampoo (100ml.) 200 40 Nos.
Vatika Shampoo (200 ml.) 100 70 Nos.
Parle –G (100 gm.) 5000 3.88 Pkt.
Parle –G(250gm.) 2000 12 Pkt.
Krack Jack (100 gm.) 1000 5 Pkt.
Krack Jack(250gm.) 500 12 Pkt.
Fair & Lovely (50gm.) 250 22 Pkt.
Ayur Cold Cream (50 gm) 200 30 Pkt.
5. Company has some fixed assets, there opening Balance
Name Amount
Maruti Swift 2,13,232
Land and building 13,52,232
Furniture 5,00,000
6. Company has to be taken of previous year from
Name Amount
Jon & company 83,671
Bathala Minerals 3,50,000
Bhuvnesh & sons 1,50,000
Abhi Raj & sons 1,50,000
7. Company purchase from Contraction point
Items Quantity Rate Vat
Laxmi Bhog(5 kg) 500 50 1%
Laxmi bhog (10 kg) 500 90 1%
Veghbakri tea (250 100 30 4%
gm)
Veghbakri tea(500 50 55 4%
gm.)
8. Company has opening cash balance is Rs. 50,000
9. Company has two bank account, their opening Balance
a. ICICI bank Rs. 1,00,000
b. HDFC bank Rs. 1,00,000
10.Company sales to Sharda Ltd.
Bill no. :- S-SL-001
Items Quantity Rate Units Vat
Aashirwad Aata (10kg) 113 100 Pkt. 1%
Aashirwad Aata (5 kg.) 90 55 Pkt. 1%
Swastika Aata (10kg.) 25 100 Pkt. 1%
Swastika Aata (5 kg.) 100 60 Pkt. 1%
Madhushree tea (500 125 70 Pkt. 4%
gm)
Madhushree Tea 100 15 Pkt. 4%
(100gm.)
Zotex (100ml.) 500 140 Nos. 12.5%
11.Company sales to jeetmal & sohan Brother’s
Bill no :- S-J&S-001
Items Quantit Rat Units Vat
y e
Shanti amala (100 ml.) 100 18 Nos. 12.5
%
Sunsilk shampoo (100 25 30 Nos. 12.5
ml.) %
Vatika shampoo (200 100 85 Nos. 12.5
ml.) %
Sunsilk shampoo (200 35 65 Nos. 12.5
ml.) %
Rexsona (200 ml.) 100 250 Nos. 12.5
%
Rexsona (100 ml.) 300 160 Nos. 12.5
%
12.Company sales in cash
Laxmi Bhog Aata (10 kg.) 75 100 Pkt. 1%
Laxmi Bhog (10 kg.) 200 60 Pkt. 1%
Veghbakri tea (250 gm.) 50 40 Pkt. 4%
Veghbakri tea (500 gm.) 35 70 Pkt. 4%
Tata tea (100 gm.) 100 15 Pkt. 4%
Tata tea (500 gm.) 500 90 Pkt. 4%
Lux soap (100 gm.) 500 14.75 Nos. 4%
13.Company purchase from Sumit Corporation
BILL NO :- P-SC-001
Chana Dal (1 kg.) 200 25 Pkt. 1%
Chana Dal (5 kg.) 100 124 Pkt. 1%
Moung Dal (1 kg.) 200 32 Pkt. 1%
Moung Dal (5 kg.) 100 156 Pkt. 1%
Aashirwad Aata (50 Kg.) 50 450 Pkt. 1%
Laxmi Bhog Aata ( 50 Kg.) 50 470 Pkt. 1%
Swastika Aata (50 kg.0 50 460 Pkt. 1%
Tajmahal Tea (100 gm.) 100 18 Pkt. 4%
Tajmahal Tea (1 kg.) 100 155 Pkt. 4%
Fair & handsom (25 gm.) 75 27 Nos. 12.5%
Ponds (100 gm.) 100 40 Nos. 12.5%
Boroplus (100 gm.) 200 30 Nos. 12.5%
Assignment 4
1. Pawan and Pradeep is the owner of the company. They started a new firm
named as P&P co. They deal on regular items. They invest capital in the
ratio of 7:3 i.e. 7, 00,000 and 3, 00,000.
2. They both decide to open a current A/c in YES Bank and deposit the
security of Rs. 3000
3. They purchase some items for the business which under as fixed assets
Name of items Amount
Furniture 25000
Water cooler 15000
Heater 10000
Cooler 25000
4. They decide to appoint a employee at the different post
Name of employee Post
Shree Advertisement
manager
Pooja Sales manager
Prachi miglani Accountant
Sumit Cashier
5. P&p co. Purchase goods from Amul ltd.(Gujarat)
Bill no :- P-AM-001
Name of item Quantity Rate VAT Units
Amul favoured 20 18.5 4% Bottles
milk
Amul milk 50 35 4% Packs
Amul butter 12 30 4% Pcs
6. P&p co. Purchase goods from Pepsi co,
Bill no :- P-PP-001
Pepsi (2lt.) 20 70 4% Bottles
Pepsi (1/2 lt.) 30 15 4% Bottles
7. P&p purchase goods from Britannia co,
Bill no :- P-BC-001
White bread 10 27 4% Packs
Brown bread 10 27 4% Packs
8. P&p co. Decide to purchase advertisement service & pay TDS amounting
Rs. 10,000
9. Sold goods to S & S co. ( shopkeeper) by cheque no :- 123456
Bill no :- s-s&s-001
Amul favoured milk 5 20 4% Bottles
Amul milk 10 38 4% Packs
Pepsi (2lt.) 6 72 4% Bottles
At the end of the first Quarter. Both the owner is deciding to invite a CA for
auditing. CA is a person of company – resident and charged 45000 par visit. Apply
TDS.
Project
Mr. Anjaneya, an MBA from Fores School of management, started a whole sale
trading business of stabilizers & pumps with the name of Anja & Co, on April 1,
2014. He further planned to maintain the business accounts using Tally 9 ERP,
under the accrual system of accounting. Ledgers recorded from the books of Anja
& Co for the year 2014-15, are as below.
LEDGER GROUP
Capital Capital A/c
Drawing Capital A/c
Credit Card Bank A/c
ICICI Bank Bank A/c
Cash Cash in hand
Prepaid Insurance Current Assets
Security deposit Deposit (assets)
Salary advance Land & advance
Stock Stock
Data tech Services Sundry Debtors
Java trading co Sundry Debtors
Sea crest trading co Sundry Debtors
Soft tech trading Sundry Debtors
State trade corp. Mumbai Sundry Debtors
Sun shine traders Sundry Debtors
A2Z traders Sundry Creditors
Icon Enterprises Sundry Creditors
Pacific merchants Sundry Creditors
Wintech information system Sundry Creditors
X tech services Sundry Creditors
Input VAT 12.5% Duties & Taxes
Input VAT 4% Duties & Taxes
Output VAT 12.5% Duties & Taxes
Output VAT 4% Duties & Taxes
VAT adjustment Duties & Taxes
Electricity charges payable Provision
Rent expense payable Provision
Salary expense payable Provision
Carriage inward expenses Direct expense
Cell phone Fixed Assets
Computer Fixed Assets
Electrical fittings Fixed Assets
Furniture & Fixture Fixed Assets
Motor Vehicles Fixed Assets
Advertisement expense Indirect Expense
Bank Charges Indirect Expense
Conveyance expense Indirect Expense
Depreciation expense Indirect Expense
Donation Indirect Expense
Electricity expense Indirect Expense
Exhibition expense Indirect Expense
Insurance expense Indirect Expense
Interest due Indirect Expense
Printing and stationery expense Indirect Expense
Rent expense Indirect Expense
Salary expense Indirect Expense
Shop maintenance Indirect Expense
Telephone expense Indirect Expense
Discount received Indirect Expense
Interest Accrued Indirect Expense
Purchase CST Purchase A/c
Purchase 4% Purchase A/c
Purchase 12.5% Purchase A/c
Input CST 4% Tax on Purchase
Sales 12.5% Sales A/c
Sales 4% Sales A/c
Sales CST Sales A/c
He decided to maintain the following stock groups & stock Items.
Stock Group
Name Under Can quantity of items be

added
Pump Primary Yes
Stabilizers Primary Yes
Heater Primary Yes
Stock Items
Name Under Units VAT

Submersible Pump 4% Pumps Nos 4%
Open well pump 1% Pumps Nos 4%
High capacity stabilizers 12.5% Stabilizers Nos 12.5%
Low capacity stabilizers 12.5% Stabilizers Nos 12.5%
Electrical heater Heater Nos 12.5%
Following are the transactions for Anja & Co on monthly basis:
April
On 1st April, 2014, purchased the following items from A2Z traders on credit.
Item Name: High Capacity stabilizer

Quantity 100
Rate Rs. 600.00
Amount Rs. 60,000.00
Input VAT 12.5%
New ref p/a2z/001
On 1st April 2014, purchased the following items from M/s A2Z traders on credit
New ref: p/a2z/002

Items Quantity Rate Value VAT
Low capacity stabilizers 100 Rs. 400.00 Rs.40,000.00 12.5%
12.5%
Open well pump 4% 50 Rs.1500.00 Rs. 4%
75,000.00
Submersible pumps 100 Rs. Rs. 4%
2000.00 2,00,000.00
May
On 2nd May 2014, sold the following items for cash:

High capacity stabilizers 50 Rs. 850.00 Rs.42,500.00 12.5%
12.5%
Open well pump 4% 15 Rs.1,700.00 Rs. 4%
25,500.00
June
On 1st Jun 2014, purchased the following items from M/s pacific merchants on
credit:
New ref: p/pm/001

High capacity stabilizers 200 Rs. 650.00 Rs.1,30,000.00 12.5%
12.5%
Open well pump 4% 300 Rs.1,600.00 Rs.4,80,000.00 4%
On 2nd Jun 2014, sold the following items to java trading:

New ref: s/jtc/001
12.5%
Submersible pumps 30 Rs.2,500.00 Rs.75,000.00 4%
On 2nd Jun 2014, sold the following items to data tech A/c
Item Name: Low capacity stabliizer

Quantity 100
Rate Rs. 550.00
Output VAT 12.5%
New ref. s/dtc/001
July
1st Jul 2014, VAT adjustment Entry
On 1st Jul 2014, purchased the following items through cheque payment:

12.5%
Low capacity stabilizers 20 Rs.400.00 Rs.8,000.00 12.5%
On 2nd Jul 2014, sold the following items to data tech:
New ref: s/dtc/002

Items Actual Billed Rate Value VAT
Qty Qty
High capacity stabilizers 33 30 Rs.750.00 Rs.22,500.00 12.5%
12.5%
Low capacity stabilizers 18 15 Rs.450.00 Rs.6,750.00 12.5%
On 2nd Jul 2014, sold the following items to java trading:

New ref: s/jtc/002
Items Actual Billed Rate Value VAT
Qty Qty
High capacity stabilizers 22 20 Rs.750.00 Rs.15,000.00 12.5%
12.5%
Low capacity stabilizers 6 6 Rs.450.00 Rs.2,700.00 12.5%
On 2nd Jul 2014, goods sold as sample sales:
Item Name: Low capacity stabilizer

Quantity 5
31st Jul 2014, VAT adjustment entry.
August
On 2nd Aug 2014, sold the following items on sea crest trading corp:
Item Name: High capacity stabilizer

Quantity 90
Rate Rs. 900.00
Discount 5.00%
Amount after discount Rs. 76,950.00
VAT 12.5%
New ref s/stc/001
31st Aug 2014, VAT adjustment entry
September
On 1st Sep 2014, purchased the following items from M/s A2Z traders on credit:
New ref: p/a2z/003

Submersible pumps 50 Rs. Rs.1,05,000.00 4%
2,100.00
Low capacity stabilizer 110 Rs. 500.00 Rs. 55,000.00 12.5%
On 2nd Sep 2014, purchase return of bill no: p/a2z/003
angst ref: p/a2z/003

Low capacity stabilizer 10 Rs. 500.00 Rs. 5,000.00 12.5%
On 2nd sep 2014, sold the following items to data tech A/c
New ref: s/dtc/003

Low capacity stabilizer 100 Rs. 550.00 Rs.55,000.00 12.5%
Submersible pump 50 Rs. Rs. 4%
2,500.00 1,25,000.00
On 2nd sep 2014, sold the following to java trading
New ref: s/jtc/003

Low capacity stabilizer 12.5% 80 Rs. 700.00 Rs.56,000.00 12.5%
2,300.00 1,38,000.00
October
1st Oct 2014, VAT adjustment entry
On 1st Oct 2014, sales return from bill no: s/jtc/003
angst ref: s/jtc/003

Low capacity stabilizer 12.5% 15 Rs. 700.00 Rs. 12.5%
10,500.00
2,300.00 23,000.00
2nd Oct 2014, sold the following items to sea crest trading corp:
Item Name: Open well pumps

Quantity 200
Rate Rs. 1,900
Amount Rs. 3,80,000.00
VAT 4%
New ref s/stc/002
31st Oct 2014, VAT adjustment entry.
November
On 1st Nov 2014, purchased items from M/s Icon Enterprises on credit:
New ref: p/Ie/001

Item Name: Electric heater
Quantity 30
Rate Rs. 400
VAT 12.5%
On 2nd Nov 2014, sold the following items to sea crest trading Corp:
New ref: s/stc/003

Item Name: Open well pumps
Quantity 50
Rate Rs. 1,800
VAT 4%
December
1st Dec 2014, VAT adjustment entry
2nd Dec 2014, sold the following items on cash:

Electrical heater 60 Rs. 550.00 Rs. 12.5%
16,500.00
2,400.00 48,000.00
Open well pumps 25 Rs. Rs. 4%
1,800.00 45,000.00
31st Dec 2014, VAT adjustment entry
31st Dec 2014, Paid VAT due for the month of December by cheque.
January
1st Jan 2015, purchased items from x-tech services on credit (bill no: p/xts/001):

1,800.00 90,000.00
2nd Jan 2015, sold the following items to soft touch traders:
New ref: s/stt/001

Item Name: Submersible Pumps
Quantity 30
Rate Rs. 2,500
Discount 4%
Output VAT 4%
31st Jan 2015, VAT adjustment entry.

February
On 1st Feb 2015, purchased the following items from m/s Pacific Merchants
Bill no: p/pm/002

Open well pumps 30 Rs.1,500.00 Rs.45,000.00 4%
High capacity stabilizers 50 Rs. 500.00 Rs. 12.5%
25,000.00
On 1st Feb 2015, purchased the following items from m/s win tech
New ref: s/wis/001

Item Name: Low capacity stabilizers
Quantity 50
Rate Rs. 450.00
VAT 4%
On 1st Feb 2015, purchased the following items from /s Icon Enterprises
New ref: s/IE/002

Item Name: Submersible pumps
Quantity 30
Rate Rs. 2,200.00
Value Rs. 66,000.00
VAT 4%
1st Feb 2015, sold the following to java trading:
Bill no: s/jtc/004

Items Quantity Rate Amount Discount VAT
High capacity stabilizers 30 Rs. 850.00 Rs. 5% 12.5%
25,500.00
Open well pumps 40 Rs. Rs. 5% 4%
1,600.00 64,000.00
On 2nd Feb 2015, sold the following items to state trade corp Mumbai:
New ref: s/IE/002
Item Name: Submersible pumps
Quantity 40
Rate Rs. 2,500.00
Value Rs. 1,00,000.00
March
1st Mar 2015, VAT adjustment entry
1st Mar 2015, Sold the following items to sun shine traders:
Bill no: s/ssc/001

Items Quantity Rate Amount VAT
1,500.00 75,000.00
2,400.00 48,000.00
1,800.00 45,000.00
1st Mar 2015, sold the following items to sea crest trading corp:
Bill no: s/tc/001

Items Quantity Rate Amount VAT
Low capacity stabilizers 15 Rs. 750.00 Rs. 12.5%
11,250.00
31st Mar 2015, VAT adjustment entry.

Receipt Vouchers:
1. On 2nd April 2014, Anurag brought in capital of Rs. 15,00,000.00 by cheque

& deposited in ICICI bank by opening a new a/c.
2. On 2nd July 2014, received cheque from java trading company & data tech
services with their agst ref:
 dtc/02
 jtc/02
3. On 2nd July 2014, received cheque from Data tech services company with
the agst ref: s/dtc/001
4. On 2nd August 2014, received cheque from sea crest trading corp with the
agst ref: s/stc/001.
5. On 2nd August 2014, received cheque from java trading company with the
ref no: s/jtc/001
6. On 2nd October 2014, deposited the bill receivable drawn on Data tech with
the ref: s/dts/001.
7. On 2nd October 2014, received cheque from java trading with the ref:
s/jtc/003
8. On 2nd November 2014, received cheque from sea crest trading corp with
the ref: s/stc/002
9. On 2nd December 2014, received cheque from sea crest trading corp with
the ref: s/stc/003
10.On 2nd January 2015, received cheque from Soft touch trading with the agst
ref: s/stt/001
Payment Vouchers:
1. On 2nd April 2014, purchased furniture and fixture worth Rs. 1,50,000.00
2. On 2nd April 2014, paid for security deposit by cheque from ICICI bank
amounting to Rs. 25000.00
3. On 2nd April 2014, purchased the following fixed assets by cheque:
Name of Assets Amount
Cell Phone Rs. 5,500.00
Computer Rs. 25,000.00
Electrical Fittings Rs. 5,000.00
Motor Vehicles Rs. 40,000.00
4. On 1st April 2014, paid rent of Rs. 3,500 by cheque.
5. On 1st May 2014, paid cheque to A2Z traders for Rs. 3,96,500 & received Rs.
2000 discount with the agst ref: p/a2z/001 & p/a2z/002
6. On 1st July 2014, paid cheque to pacific traders amounting Rs. 6,45,450 with
ref: p/pm/001
7. On 1st September 2014, withdrawn Rs 6000 for personal use.
8. On 2nd September 2014, paid bank charges amounting Rs. 250.
9. On 1st October 2014, issued a cheque to A2z towards purchase amounting
Rs 1,65,450 with agst ref: p/a2z/003
10.On 1st November 2014, paid Rs. 4,500 by cheque for cell phone.
11.On 1st December 2014, settled the Icon enterprises bill by cheque
amounting Rs. 13,500 with agst ref: p/ie/001
12.On 1st December 2014, withdrawn cash for personal use amounting to Rs.
10,000.
13.On 1st January 2015, withdrawn Rs. 13,000 in cash for personal use.
14.On 2nd January 2015, withdrawn capital of Rs. 5,00,000 from the firm by
cheque.
15.On 2nd February 2015, paid VAT due for the month of January amounting
Rs. 2880.
16.On 2nd February 2015, withdrawn Rs. 5000 in cash for personal use.
17.On 2nd March 2015, withdrawn Rs 5000 for personal use.
Cash Payment:
1. On 2nd April 2014, paid carriage inward expense on cash amounting Rs. 500
2. On 2nd April 2014, withdrawn cash for personal use amounting to Rs. 5000.
3. On 2nd May 2014, paid cash for printing and stationery amounting Rs. 2500.
4. On 2nd May 2014, paid cash for the following expenses
Name of expense Amount
Printing & stationery Rs. 2500
Telephone Rs. 600
Shop Maintenance Rs. 450
Conveyance Rs. 250
nd
5. On 2 May 2014, withdrawn cash for personal use amounting Rs. 4000.
6. On 2nd May 2014, paid cash for following expenses.
Telephone Rs. 1,500
Conveyance Rs. 800
nd
7. On 2 June 2014, paid rent by cash amounting Rs. 3,500.
8. On 2nd June 2014, paid cash for carriage inward amounting Rs. 400.
9. On 2nd June 2014, withdrawn cash for personal use Rs. 5000.
10.On 2nd June 2014, paid cash for following expenses.
Prepaid Expense Rs. 2,400
Electricity Rs. 500
Conveyance Rs. 600
nd
11.On 2 July 2014, paid rent of Rs. 3500 by cash.
12.On 2nd July 2014, paid cash for the following expenses.
Advertising expenses Rs. 1,500
Donation Rs. 600
Shop Rs. 550
Conveyance Rs. 600
Electricity expenses Rs. 500
nd
13.On 2 August 2014, paid rent of Rs. 3500 by cash.
14.On 2nd August 2014, paid for the following expenses by cash.
Telephone Rs. 800
Conveyance Rs. 600
Electricity Rs. 350
nd
15.On 2 September 2014, paid cash
Electricity Rs. 350
Conveyance Rs. 600
nd
16.On 2 October 2014, paid cash
Electricity Rs. 400
Conveyance Rs. 600
Telephone Expense Rs. 1,100
nd
17.On 2 November 2014, paid cash.
Electricity Rs. 300
Conveyance Rs. 600
Telephone Rs.1,100
st
18.On 1 December 2014, paid Rs. 2500 in cash for the space provided in the
exhibition.
19.On 2nd December 2014, paid cash.
Electricity Rs. 400
Conveyance Rs. 600
Telephone Rs. 1,200
nd
20.On 2 January 2015, paid cash
Electricity Rs. 350
Conveyance Rs. 500
Telephone Rs. 800
nd
21.On 2 February 2015, paid cash
Electricity Rs. 300
Conveyance Rs. 600
Telephone Rs. 1,100
nd
22.On 2 March 2015, paid cash
Electricity Rs. 300
Conveyance Rs. 600
Telephone Rs. 1,100
Contra Vouchers:
1. On 2nd April 2014, cash withdrawn from bank amounting Rs. 50,000.
2. On 1st June 2014, cash withdrawn from bank amounting Rs. 11,000.
3. On 2nd June 2014, deposit cash into ICICI Bank amounting Rs. 40,000.
4. On 2nd October 2014, withdrawn cash from bank amounting Rs. 7,500.
5. On 2nd November 2014, issued a cheque to the cashier amounting Rs.
8,000.
6. On 2nd January 2015, deposited cash in ICICI bank amounting Rs. 1,20,000.
Journal Vouchers:
1. On 31st March 2015, transfer rent expense balance of March to rent

payable a/c amounting Rs. 3500.
2. On 31st March 2015, transfer electricity a/c balance of March to electricity
payable amounting Rs. 350.
3. On 31st March 2015, Assets are depreciated using WDV method.
Name of Asset Amount
Cell phone Rs. 825
Computer Rs. 15,000
Electrical fitting Rs. 500
Motor vehicles Rs. 6,000
Furniture & fittings Rs. 15,000
Cell phone Rs. 338
st
4. On 31 March 2015, transfer insurance a/c balance of March to electricity
payable amounting Rs. 1,800.
5. On 31st March 2015, transfer balance of drawing to Anurag capital a/c
amounting Rs. 53,000
6. On 31st March 2015, transfer of profit into capital a/c.
Solution of the Project.
Item Amount
Balance sheet Rs. 13,02,904.00
Gross Profit Rs. 2,32,342.33
Net Profit Rs. 1,42,829.33
Indirect Expense Rs. 91,513.00
Trial Balance Rs. 40,14,170.33
ASSIGNMENT 1: Do the transactions for the company and also show the cash report .
Date Particulars Amount
1/4/2012 Mr. Ram Gopal commenced business with cash 8000
2/4/2012 He bought goods for cash 5000
1/5/2012 Sold goods for cash 100
31/5/2012 Received cash from Mr. Manohar lal 360
1/6/2012 Paid into bank 3000
31/6/2012 Sold goods for cash 1500
1/7/2012 Paid for stationary 15
2/7/2012 Paid for office furniture 185
1/8/2012 Received from Mr. Kailash chand 680
2/8/2012 Paid for advertising 90
31/8/2012 Purchased Postage & Stamps 8
2/9/2012 Paid Rent 100
31/10/2012 Paid Electricity Charges 15
1) Calculate and Display the Balance Sheet and Profit & Loss statement for the Month.
2) Also display the details for following reports
a) HDFC Bank,
ASSIGNMENT 2: Do the above mention transaction with HDFC BANK; also give the cheques details for
transaction Period of 01-04-2012 to 31-10-2012. Do the Bank Reconciliation Statements (B.R.S) to match the
Balances of Pass Book & Cash Book.
ASSIGNMENT 3 Akash started business with investment of Rs. 250000.
Do the purchase transaction from Rajat & Company.
S NO ITEMS RATE QTY VAT TAX RATE LOCATION
Mouse 300 1000 12.5% Karol Bagh

1.
Keyboard 500 1000 12.5% Karol Bagh
2.
Monitor 5000 1000 12.5% Karol Bagh
3.
CPU 3000 1000 12.5% Karol Bagh
4.
Do Stock Transfer Entries In The Books Of Company:-
SOURCE ITEM Qty DESTINATION
Karol Bagh Mouse 350 Tilak Nagar
Karol Bagh Keyboard 225 Preet Vihar
Karol Bagh Monitor 360 Rajouri Garden
Do the Sales and Purchase Entries of The Company:-
PURCHSE /
DATE BILLS NO COMPANY ITEMS UNIT RATE
SALES
Keyboard 10000 600
1.6.08 P001/E901/01 PURCHASE TARUN & COMPANY
Mouse 2000 500
CPU 6500 2000
1.6.08 P001/E901/02 SALES RAMESH & COMPANY
Monitor 1500 3500
Keyboard 100
1.7.08 P001/E901/01 DEBIT NOTE TARUN & COMPANY -----
Mouse 200
CPU 100
1.7.08 P001/E901/01 CREDIT NOTE RAMESH & COMPANY ------
Monitor 200
Maintain Company Purchase Order Books and Sales Order Books
Date Order No. Order Party Items Location Units
2.6.08 101 Purchase Cred & Company Cello South Delhi 5000
2.6.08 102 Sales Deb & Sons Company Nice Main Location 1600
2.6.08 103 Sales Deb & Sons Company Cello Main Loction 1500
2.6.08 104 Purchase Cred & Company Cello North Delhi 2300
The same day, first two orders were accepted and on 2.7.08 two others were cancelled by the company
in their order books.
ASSIGNMENT 4: Mr. Ram & Bros. is the Wholesale distributors of ABC Company. The company
follows following list of sale pens to Debtor Company.
Less then Quantity Price Discount
- 1500 15/- 10%
1500 2000 13.50/- 10%
2001 3500 11.50/- 20%
3501 5000 10.50/- 30%
Otherwise Rs. 8.60/- will be charged and on each case 10% of the total quantity is mandatory to
provide.
Whatever Quantity ABC PVT ltd has been sold to Mr. Ram & bros.
ASSIGNMENT 5: Maintain Batches for the following products
S NO PRODUCT BATCH NO. MFG DATE EXP DATE QTY PRICE

1. PEPSI PEP/101/11-12 1-4-11 1-10-11 1000 35/-
2. DAIRY MILK DM/102/11-12 1-4-11 1.-9-11 1500 40/-
3. DISPRIN DS/103/11-12 1-4-11 1-11-11 1500 1.5/-
4. COMBIFLAME CBF/104/11-12 1-4-11 1-12-11 1000 2/-
5. SPRITE SPR/105/11-12 1-4-11 1-1-12 1000 45/-
 Create the voucher entries for the following and also check the Batch Transaction according to dates.
 And also show that how many products remaining after Expiring Date of Batch.
ASSIGNMENT 6:-Do the Cost Center Entries for the Company .Also check the Reports for the same.
CREATE COST CENTER

Create Cost Category
CATEGORY NAME UNDER
Revenue Non-Revenue
Cost Category Phone number 98450-65308 Primary
Items Items
Phone number 97530-46358 Primary
Phone number Yes No
Agent Yes No
Media Yes No
Agent Mr. Mohan Bose Primary
Agent Miss Monika Roy Primary
Agent Mr. Krishna Raj Primary
Media Poster Primary
Media Banner Primary
Media Radio Fm Primary
Media Radio Mirchi Radio
Media 98.3 Fm Radio
S no Date Expense Cost Center Amount
98450-65308 2250
1-5-2011 Telephone bill
1.
97530-46358 750
2-5-2011 Telephone bill 2289-0045 2070

2.
2289-4466 700
98450-65308 1000
3.
97530-46358 2000
Mr. Mohan Bose 800
2-5-2011 Commission for agent Miss Monika Roy 950

4.
Mr. Krishna Raj 1450
98450-65308 1200
5.
97530-46358 950
Radio Mirchi 11000

2-6-2011 Advertisement
6.
98.3 fm 12000
2289-0045 1070
7.
2289-4466 830
Mr. Mohan Bose 900
2-5-2011 Commission for agent Miss Monika Roy 1600

8.
Mr. Krishna Raj 2300
Total 43820
ASSIGNMENT 7: Abc Ltd. wants to collect Interest from One of his Debtor Company “DEB & COMPANY” who
has entered into a Contract to pay 5% Interest on the due Amount made by him if he is unable to pay it till his
due date.
 Credit Sales made by ABC to Deb & Company-Rs. 20,000 on 1.4.11

 Due after 1 month
 Actual Receipt Recovered by ABC on 1.5.11.
Calculate and display the appropriate “Interest Received” by ABC Ltd. on 1.5.11.
ASSIGNMENT 8: ABC Pvt. Ltd. Undertakes a project named as “Project A”. He also prepared a Budget control his
expenses for the period of 1-4-2011 to 31-12-2011.
Budgets for the Ledger:-
Ledger Cost Center Type Of Budgets Amount
Salaries N.A On Nett transaction 25000
Wages N.A On Nett transaction 100000
Conveyance N.A On Nett transaction 12000
Office Costs N.A On Nett transaction 12000
P& L A/C N.A On Nett transaction 50000
Total 199000
Do the following entries:-
Date Expense Amount
1-5-2011 Salary paid 25000
2-5-2011 Wages 59000
1-6-2011 Conyenace expense 25900
2-6-2011 Capital 500000
1-7-2011 Rent paid 15000
2-8-2011 Office expense 5000
1-9-2011 Machinery expense 45000
2-9-2011 Furniture 50000
1-10-2011 Sales 38000
2-10-2011 Purchase raw material 25800
1-11-2011 Conyenace 5600

2-11-2011 Flat 36000
1-11-2011 Type writer 12500
2-12-2011 Rent paid 15000
1-12-2011 Purchase raw material 25000
882800
ASSIGNMENT: 9 ABC PVT ltd working as the assembler company of the computer. They purchase only part of
the computer and assembling them.
Following parts are required to maintain one PCS of computer.
S NO ITEMS NAME PARTS PRICE
1. Mother Board 1 PCS 2400
2. Hard Disk 1 PCS 1700
3. Monitor 1 PCS 5500
4. Key Board 1 PCS 250
5. Ram 1 DISK 900
6. DVD Writer 1 PCS 900
7. Cabinet 1 PCS 1400
8. Processor 1 PCS 8500
9. Mouse 1 PCS 150
10. Speaker 2 PCS 1000
11. Ups 1 PCS 1700
Total cost of one computer 24400
Also calculate the additional cost for the computer like wages, transport freight etc on the basis of
percentage.
Assignment 10:- X has been in service of ABC PVT Ltd. Since 1-5-10 in Delhi. During this Financial year X receives
Basic Salary @ Rs. 9000 p.m.Company is also giving following allowances benefits to Mr. X:
S.No. Allowance Name Rates
1. Dearness allowance 10% of basic salary
2. House Rent Allowance 20% of Basic Salary
3. Conveyance Allowance 50/- per day
4. Food Coupons Rs. 500/- pm (Flat Rate)
5. Medical Treatment Allowance 1000/- per month
 Employee Contribution to Provident Fund is 8% of his basic
From Amount Amount Upto Value

- 3000 0
3000 6000 30
6000 9000 60
9000 13000 100
13000 - 150
Assignment 12:- Open Your Company and Pass the Following Entries
a) Outstanding Amc charges clear through cash as on 01/0402006.

b) Paid Rs.25, 000/-to M/s Genlite through cheque of SBI (Chq No: 500126) as on 02/04/2006,
Adjust the full amount of 1st bill (Pur/G/101) and rest of the amount from 2nd bill (Pur/G/155).
c) Paid Rs. 24, 5000/- to Shakti India through cheque of SBI (chq No: 500126) as on 02/04/2006.
d) Received cash Rs.10000/- from modern traders as on 02/04/2006 against bill no. Sal/MT/101
e) Received a cheque of ICICI bank worth24, 500 (Ch. no. 721091) from bearings & Spares against
their two bills, deposited into UTI bank as on 02/04/2006 and rest of the amount treated as
discount allowed.
f) Modern Traders clear 90% of their total outstanding through cash dated 02/04/2006 and rest of
the amount treated as bad debt.
g) Rs. 550/- paid in cash for General Expenses dated as on 02/04/2006.
h) Purchase Furniture worth Rs. 15000/- from style Spa. Ref No Asst/1 dated as on 01/07/2006
i) Received interest on debentures Rs.65000/- through cheque of abn-amro {Ch. No.854721)
dated 02/04/2006 & deposited into SBI.
j) Received commission in cash Rs.45000/- from various sources dated as on 02/04/2006.
Assignment 13:- Pass the following entries with Cost Category / Cost Center.
Cost Category: - Branch, Telephone and Employee
Cost Center: - Kolkata, Delhi, Mumbai & Chennai (under Branch), 2231-8541 & 2251-
7423(under Telephone), Mr. Chopra & Mr. Dey (under Employee).
a) Salary paid Rs.5000/- in cash for Mr. Chopra of Kolkata branch dated as on 01/07/2006
b) Paid Telephone bill Rs. 65000/- (Rs.4500 for 2231-8541 & Rs.2000 for 2251-7423) through a cheque
of SBI (chq No-500127) as on 02/07/2006.
c) Paid Rs.550/-is cash to Mr. Dey as Incentive dated as on 02/04/200.
d) Advertising expenses expenses worth Rs.20000/- paid through a cheque of SBI (chq No: 500128) as
on 02/07/2006. 28% for Kolkata,32% for Delhi 25% for Mumbai & 15% for Chennai branch.
(VAT/CST)
Assignment 14:- Company started their business with two new items:
1. Ponds cream 2. Lotus Cream

a) Company Purchase the following items with 4% vat from Mathur Enterprise & stored at behala
dated as on 07/08/2006. 50pcs Ponds cream @35/-, 50pcs Lotus cream @75/- {Bill no:-
Pur/ME/06-07/901}
b) Company Purchase the following items with 4% vat from Sital Stored & stored at behals dated as
on 01/08/2006.25pcs Ponds cream @35/-, 25pcs Lotus cream @75/-{Bill no: Pur/SS/06-07/051}
c) Company sold the following items with 4% vat to Mr. Bhargav from behala godown dated as on
02/08/2006. 55pcs Ponds cream @45/-, 55pcs Lotus cream @90/-{Bill no: Sale/B/06-07/1}
d) Company sold 20pcs Ponds cream @45/-,20pcs Lotus cream @90/- with CST 4% to Mumbai stores
of Bandra from behala godown as on 02/08/2006 and courier Rs.150/- paid in cash.{Bill no:
Sale/MS/06-07/455}
e) Company purchased a picking Machine for stock department having total cost of Rs.54,000/- with
vat on Capital Goods @4% from Western Logica on 02/08/2006.{Purchase bill no:
Pur/Asst/WL/06-07/100},-Pass the first set off entry for Input Credit on Capital Goods on
01/09/2006 for the month September.
f) Purchase 20pcs of Ponds cream @35/- & 20pcs of Lotus cream @75/- from X ltd (unregistered
dealer) with vat rate 12.5% {Purchase bill no: Pur/x/06-07/891 dated as on 01/06/2006 & stored in
behala godown.
g) Vat return was filed on 02/09/2006. After adjusting input/output vat.
(TCS)
Assignment 15:- Open Your Company and Pass the Following Entries.
a) Company purchases 1000Cft. Of timber @22/- from Jai Ambe Trading Co. through cheque of SBI
{Ch. No.541249} dated as on 02-02-2007. (Ref PB/JAT 1041).
b) Company sold 1000Cft of timber @ 30/- to Bhutan Plywood Ltd with TCS & freight Rs.1800/- {Bill
no.BPL/1/06-07} dated as on 02-02-2007.
c) Bhutan Plywood paid the full amount through a cheque of UTL & deposits the same in SBI against
bill no. BPL/1/06-07 dated as on 02-02-2007.(ch.no.65400)
(Service Tax)
a) Company is starting to provide training in assembling of PC.

b) Mr. Samir takes admission with Rs.7000/- for his course & service tax
@ 12.3%% in the amount. (ref MR/S/100)
c) Company receives the amount in cash.

d) Company receives their telephone bill from BSNL of Rs.2500/- for the month of Feb’07 & service
tax @ 12.3%
e) Calculate the difference amount & paid the amount to the government as service tax dated as on
01-03-2007 through SBI (chq.no.245175).
(TDS)
1. TDS amount shall be paid to the government account through any designated branches of the
authorised banks, along with Income Tax Challan No.
2. On 1st April, 2009 Universal Infotech received a Bill (vide No. 001) from Pheonix Agencies for Rs.
5,00,000 towards the Advertisement services rendered.

Tally E Book 2

Uploaded by

Copyright:

Available Formats

Tally E Book 2

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Tally E Book 2

Uploaded by

Copyright:

Available Formats

F1 MACRO TECHNOLOGIES(Regd.

According to the American institute of certified public

Liabilities can be further classified into:

Non-current liabilities (long term liabilities)

Current liabilities (short term liabilities)

It is that liability which is payable within 6 month or 1 year.

Assets can be classified into two categories

Money measurement concept

Real A/C (Golden Rule)

Dr. what comes in

Cr. What goes out

Nominal A/C (Golden Rule)

Dr. All Expenses and Losses

Cr. All Income and Gains

Dr. The Receiver

Cr. The Giver

Bank SBT A/c Bank Account

Furniture A/c Fixed asset

Furniture Mart A/c Sundry Creditors

Advertisement A/c Indirect Expense

Printing charge A/c Indirect Expense

Machinery A/c Fixed asset

Purchase A/c Purchase Accounts

Aroma traders A/c Sundry Creditors

Telephone charge A/c Indirect Expense

Sales A/c Sales Account

Purchase Return A/c Purchase Accounts

Kishore A/c Sundry Debtor

Sales Return A/c Sales Account

Drawings A/c Capital Account

Salary A/c Indirect Expense

A/C. A/C. GROUP

Bills Payable Current Liabilities

Bills Receivable Current Assets

Inward Carriage Direct Expenses

Outward Carriage Indirect Expenses

Purchase Purchase A/c.

Purchase Return Purchase A/c.

Sales Sales A/c.

Sales Return Sales A/c.

Motor Car Fixed Assets

Furniture Fixed Assets

Vehicle Fixed Assets

Discount Payable Indirect Expenses

Railway Freight Direct Expenses

Wages Direct Expenses

Bad Debts Indirect Expenses

Depreciation Indirect Expenses

Rent & Taxes Direct Expenses

Opening Stock Stock In Hand

Salary Indirect Expenses

Loan Received Loan Liabilities

Loan Payable Loan Assets

Bank Overdraft Bank Overdraft

Goods Tempts Sales A/c.

Goods In Fire Sales A/c.

Goods Lost Sales A/c.

Post And Telegram Expenses Indirect Expenses

Discount Received Income Revenue