Tally Prime and Erp 9
Tally Prime and Erp 9
Tally Prime and Erp 9
Tally is a complete business and management software from tally solution Pvt Ltd. It handle our
financial solution VAT,Tax and lots of transactions.
3.0 > 4.1 > 4.5 > 5.4 > 6.3 > 7.2 >8.1 > 9.0 > ERP 9.
An account is processing system in which we input our financial transaction and out-put our financial
statement.
1) Personal account
2) Real account
3) Nominal account
Those are which one related to any particular person is called personal account.
i) Natural account
ii) Artificial account
iii) Representative account
[email protected]
i) Natural account: All account which are made by god is called natural account.eg:- Ram
account, Mohan account, etc.
ii) Artificial account: All account which are made by person is called artificial account. Eg:- RBI
account, Unique computer, Nidhi enterprises, etc.
iii) Representative account : When any suffix and prefix comes with nominal account is called
representative account. Eg:- Prepaid rent account, Acquired income account, etc.
All account which are related to assets or properties is called real account.
i) Tangible account
ii) Intangible account
i) Tangibleaccount :- All account which can be touch or seen is called tangible account. Eg:-
Machinery account, Building account, Furniture account, etc.
ii) Intangibleaccount :- All account which cannot be touch or seen is called intangible account.
Eg:-Part nary account, Goodwill account, etc.
All accounts which are made by profit and loss or income and gain is called nominal account. Eg:-
Salary account, Rent account, Discount account, etc.
A business has a number of transactions everyday during accounting period. The transaction is
analyzed by any recording individual.
1) Cash transaction
2) Credit transaction
[email protected]
A transaction which involveimmediate payment in cash or cheque is called cash transaction. Eg:-
Purchase goods for Rs.10000/-
A transaction which involve not immediate payment in cash or cheque is called credit transaction. Eg:-
Purchase goods from Ravi on credit Rs.500/-
TRANSACTION
CASH CREDIT
TRANSACTION TRANSACTION
Cash Credit
Cash+Name Credit+Name
Withdraw Only Name
Diposit
Receipt
EXAMPLES
[email protected]
ii> Credit what goes out
(3) Nominal account –
i> All expense & loss Dr(Debtors)
ii> All income & gain Cr(Creditors)
Discount is reduction from a started mount in general. It is difference between a face value and a lower
amount paid or received.
1) Trade discount
2) Cash discount
Trade discount represent an allowance which is made by the manufactures to wholesalers and
wholesalers to retailers. And it is calculated as a percentage of the list price of goods.
EXAMPLES:
[email protected]
Cash discount are allowed to encourage a debtor to pay off his debit within a specified period. It is settle
to debtors has account within a given time period.
NOTE:
Purchase A/c-Dr
To Discount A/c
To Cash A/c
Purchase A/c-Dr
To Discount A/c
To Party A/c
Discount A/c
To Sales A/c
[email protected]
vxj ge m/kkj cspsaxs rks %
Party name -Dr
Discount A/c
To Sales A/c
Sales ges’kk dzsfMV i{k esa vkrk gS A
Purchase Debit ,oa Credit i{k nksuks esa vkrk ;k j[kk tkrk gSA
It includes 5 columns -
FORMAT OF ENTRY
Windows (start button) > All Program > Tally 9 > Tally 9 Release 1.0
2. Press Esc button TWO times first in “Activation form” and second in “Tally vault Password”
3. Create company :
[email protected]
Now we have to go on Create company and a form will appear as bellow .
Fill form correctly with name, mailing name, address, country in Statutory
compliance for, state, Phone no, E-mail, currency symbol, Financial year, books
beginning date, Vault password (It is very necessary to create a company).
YES in ‘Use security control’ if want to set username and password in your
company.
When we are in our company profile that time if we want to Open other company Press
Alt+F3.
If we want to Shutdown or Alter the company Press Alt+F3.
If we want to Delete our company First Alter and select the company then Press Alt+D
and then Yes.
[email protected]
Shutdown & Alter
Alt+F3
Create a Ledger:
GOT (Gateway Of Tally) -> Account info -> Ledger -> Create.
Options:
Create- Make a new ledger
ledger
[email protected]
Name Under
Salary A/c Indirect expense
Rent A/c ,,
Telephone Charge A/c ,,
Interest Paid A/c ,,
Commission Paid A/c ,,
Depreciation A/c ,,
Office Expense A/c ,,
Miscellaneous fee A/c ,,
Electricity Charge A/c ,,
Wages A/c Direct expense
Advertisement A/c ,,
Flight Charge A/c ,,
Carriage Charge A/c ,,
Discount A/c ,,
Labor charge A/c ,,
Land A/c Fixed assets
Building A/c ,,
Machinery A/c ,,
Furniture A/c ,,
Cash A/c ,,
Interest Received A/c Indirect income
Commission Received A/c ,,
Bed debs Received A/c ,,
Discount Received A/c ,,
Tax Duties & Taxes
VAT ,,
Input vat ,,
Output vat ,,
[email protected]
TDS ,,
TCS ,,
CST ,,
FBT ,,
Purchase A/c Purchase Account
Purchase Return A/c ,,
Sales A/c Sales Account
Sales Return A/c ,,
Party Name (seller) Sundry Creditors
Party Name (Buyer) Sundry Debtors
F4: Contra
F5: Payment
F6: Receipt
F7: Journal
F8: Sales
F9: Purchase
It records all transaction which are deposit, withdraw or transfer from one bank to another bank.
[email protected]
Bank A/c –Dr 10000
To Cash A/c 10000
It record all transaction which are received not only received if we sales any using goods.
[email protected]
Charity A/c –Dr 1000
To Purchase A/c 1000
[email protected]
Ex: Purchased goods for cash RS.10000/-
All financial entries are performed is called ledger. It is second book of account.
# In this entry if we make entry for cash then in particularcash a/c will not written.
For example: entry for Deposit into bank Rs.5000/- date 1/03/17 and
[email protected]
Cd (Carry down): In smaller amount and last date of same month.
Some ledgers
(1) Capital a/c , Under-Capital a/c, with opening balance – Rs.60000/-
(2) Land & Building a/c, Under-Fixed assets, with opening balance- Rs.60000/-
(3) Art store a/c, Under-Sundry debtors, with opening balance- Rs.85000/-
(4) ABC & Corporation a/c, Under-Sundry creditors, with opening balance –
Rs.85000/-
(5) Local sales, Under-Sales a/c, with opening balance –Rs.0/-
(6) Local Purchase a/c, Under-Purchase a/c, With opening balance –Rs.50000/-
(7) Bank of India a/c, Under-Bank a/c, with opening balance –Rs.30000/-
(8) Sales a/c, Under-Sales a/c, with opening balance –Rs.40000/-
Trial balance shows the status of business. It displays income, expense, profit and loss &
liabilities.
Liabilities+Income+Capital=Cr
[email protected]
Group is a collection of ledger. There are 28 group in tally.
[email protected]
= How to create Group:-
GOT(Gateway Of Tally)> Account info > Group > Create
Ex:
(jgfr;k)
Stock group are provides for the purchase of classification of stock items.
[email protected]
=How to create Stock group:-
GOT > Inventory info > Stock group > Create.
Example:
[email protected]
OnePlus ,,
Asus Zenphone ,,
Cloth Primary
Shirt Cloth
T-Shirt ,,
Pant ,,
Saree ,,
Shut ,,
Medicine Primary
Antibiotic Medicine
Anti-fungal ,,
Anti-alergic ,,
Unit of measure: Stock item mainly purchase and sales on the basis of quantities. The
quantities are measured in unit.
[email protected]
Examples:
This is the feature which allows you to perform a parallel classification of stock item.
To activate stock category Press F11 and go to Inventory features and set yes to
“maintain stock category”
Example: Under:-Leather
[email protected]
Name:-Bag, Shoe,etc.
The place where stock items are stored in huge amount is called godown.
Name Under
Godown Primary
Onside Godown
Ware side Godown
Stock items are referred to goods which you deal or you manufacture of trades
(Purchase & sales).
[email protected]
Exercises are on the last of
this note.
To activate cost center press F11 and go to Accounting features and set yes to
“Maintain Cost center”.
Name Under
Project Primary
Road Project
Building Project
Airport Project
Bag Project
project
[email protected]
Create a ledger ‘Project sales’ under Sales a/c and set yes –Cost center
applicable. Inventory value are affected- NO
Create a ledger ‘Project purchase’ under purchase a/c and set yes –Cost
center applicable and No in Inventory value are affected.
Create following supplier & buyer (Ledger):-
a) Universal cement under sundry creditors with cost center yes.
b) Tata steel under sundry creditors with cost center yes.
c) Chhabra properties under sundry debtors with cost center yes.
d) Begusarai city authority under sundry debtors with cost center yes.
Create a convenience A/c and Postage A/c under Indirect expense with cost
center yes in both ledgers.
Create another ledger ‘Consulting fee’ under direct income and cost center
yes.
Create a party ledger Lalbabu A/c under sundry debtors. Cost center –yes.
Transactions are often mode of currency other than become very powerful and
cost handle multicurrency transaction.
To activate multicurrency press F11 and go to Accounting features and set yes to
“Allow multicurrency”.
[email protected]
=How to create currency:-
I) Standard rate: This rate of exchange is obtained from the daily newspaper.
This standard on contract rate of exchange for a particular day.
[email protected]
II) Selling rate: This is the rate of your bank will be purchase dollar ($) or other
currency.
III) Buying rate: This is the rate of your bank will be sales dollar or other currency.
Create a ledger ‘Dollar a/c under ‘Bank a/c’ and currency symbol Dollar ($).
Create 2 ledger of supplier and buyer:-
i) Foreign customer under sundry debtors.
ii) Foreign supplier under sundry creditors.
Create an item ‘Leather bag’ under ‘Bag stock’ with the unit of ‘pcs’ and stock
category ‘Leather’.
Purchase leather bag from foreign supplier 100 pcs @250$.
Purchase a/c $25000
To Foreign supplier a/c $25000
[email protected]
Create a ledger ‘Foreign gain & Loss’ under ‘Indirect expense’ and Cost center
are applicable- NO.
Alter the voucher type ‘Journal’ and in the name of class- ‘Adjust gain & Loss’.
Enter and choose Yes in the option ‘Use class foreign gain &loss’, Select the
ledger- ‘Foreign gain & Loss’.
=GOT > Account info > Voucher type > Alter >Journal.
Create a journal entry with adjust gain and loss class field select foreign
customer from the list of ledger you can note foreign gain & loss amount
display automatically in amount field.
A cheque printing is written order to the bank of any started some of many cheque any
written or printed. In Tally cheque will be printed when printing a payment voucher.
To activate cheque printing press F11 and go to Accounting feature and set yes
“Enable cheque printing.”
After setting yes in set/Alter cheque printing configuration a new window will open:
[email protected]
After setting these
two value again a
new window will
open with cheque
properties (width, height, etc)
Fill the
appropriate
value and use
in filling
voucher.
([kpZ dk C;kSjk)
To activate budget press F11 and go to Accounting feature and set yes to
“Maintain budget and control.”
[email protected]
=How to create budget:-
EXERCISE
Create a new ‘Office budget’ under ‘Primary’ for the prepaid of 01/04/17 to
31/03/2018.
Select ‘Yes’ in group and make entry:-
Group Cost center Type of budget Amount
Capital A/c Not applicable On closing balance 100000
Loan ,, ,, 50000
Fixed Assets ,, ,, 50000
Current Assets ,, ,, 50000
Sundry creditors ,, ,, 50000
Sundry debtors ,, ,, 50000
[email protected]
ON NET TRANSACTION NORMALLY USED FOR INCOME AND EXPENSE ACCOUNT
LIKE INDIRECT EXPENSE, SALES A/C, PURCHASE A/C.
The budget variance report shows the figure of budget with actual percentage variance
from budget with percentage.
Press Alt+C to show the new column for budget and Alt+B for variance.
Scenario option allow to use build model like project or estimation with different
situation, parameters and conditions. This is called MIS (Management Information
System).
To activate scenario press F11 and set yes ‘Use reversing journal’ in ‘Accounting
feature’.
Create a reversing journal entry for salary of the month of August Rs 50000/-
[email protected]
Display the scenario figure in cash/Bank book using press Alt+C to show the
new column scenario.
Cash flow statement showing movement of money in, out cash in flow and out of flow
of business.
Note: (1) To view the cash flow statement with percentage set Yes on ‘Show in
percentage’ in F12.
(2) To view the cash flow statement with graph press F12 and set yes on ‘show the
graph’.
(3) To view graph wise cash flow select any group to get details of cash in flow and out
flow.
Fund flow provides the information of movement of fund (Source & Utilization).
Fund flow displays opening and closing balance working in capital and flow of fund in
difference in opening and closing working capital.
[email protected]
Interest calculation can be calculated in the business of the basis of simple interest and
compound interest on the loan and also on daily payment.
Create a ledger ‘Bank A/c’ Under ‘Bank A/c’ and set yes ‘Activate interest
calculation’.
Create a ledger ‘Mohan A/c’ under ‘Sundry debtors’ and set yes to interest
calculation.
[email protected]
Create a ledger ‘ABC Bricks’ under ‘Sundry creditors’.
Create a new stock item ‘Bricks’ under ‘Building material’ with the unit of ‘pcs’.
** Purchase Order **
**Sales Order**
[email protected]
After entering name of item same window as purchase order will be displayed.
On date 01/04/18 sales order steel to Tata steel, Order no T001 Quantity 10
ton @ 10000 per ton. Godown ware side and flight 12% on it.
Entry another sales order steel to Tata steel, Order no T002 Quantity 5 ton @
10000 per ton. Godown onside and flight charge 12% on it.
Reorder level is a quantity in hand for stock item which you sold order your supplier the
important at reorder level to have sufficient stock to customer.
GOT > Inventory info > Reorder level >Select stock item (Group).
[email protected]
NOTE: (1) The item which is taken in lower will not use in advance mode (Higher).
(2) Simple mode time: days and advance mode time: Month.
Advance:-
Simple:- 1. Item name- CPU (Computer)
1. Item name- Bricks Reorder level- 10 pcs
Reorder level- 5000pcs -1 Month
-10 Days Minimum- 5 pcs
-Higher
Minimum- 2000pcs
-Lower 2. Item name- Samsung (Mobile)
2. Item name- Steel
Reorder level- 10 pcs
Reorder level- 5 Ton
-10 Days - 1 Month
Minimum- 2 Ton Minimum- 5 pcs
-Lower
-Higher
GOT > Display > Statement of Inventory > Reorder Status > Select Stock item.
Batch wise details are used to identify the movements of inventory in batches or this is
primary requirement of the pharmacy industry and food materials.
To activate batch wise details press F11 and go to ‘Inventory Feature’ and set yes-
[email protected]
NOTE: (1) Manufacturing date and expiring date for batch is useful for business. That
date is goods that have expiry date like medicine and food materials.
TYPE OF ADJUSTMENT
EXERCISE:
Create an stock item ‘Sumo’ with the unit of ‘Strip ‘or ‘Stp’ under ‘Medicine’
category ‘Painkiller’ and set yes to ‘Batches wise details’ rate of duty ‘5’.
Create a supplier ‘Durga pharma’ under ‘Sundry creditors’.
Make a purchase entry sumo from Durga pharma 100 stp @ 40 per stp. Batch
no- DP001, manufacturing date 01/04/18 and expiry date 21/03/19. Stored in
ware side.
Make a sales entry for cash 50 stp on same batch wise. Manufacturing date
and expiry date and godown ware side.
Create another purchase invoice from Durga pharma 200 stp @ 50 per stp.
Batch no- DP002, manufacturing date 01/04/18, expiry date-31/03/20 and
stored in onside.
Create another sales invoice for cash ‘sumo’ 10 stp with Batch no-DP001 and
50 stp of DP002.
[email protected]
Display the stock details-
GOT > Accounting voucher > Alt + F10 (to display physical stock) > Enter
item name.
To activate price level press F11 and go to ‘Inventory feature’ and set yes ‘Use
multiple price level’.
VAT(Value Added Tax) is additional tax charged on sales & purchase of goods with in
store. VAT is on buyer rate dealer and any other purchase who add the value of goods.
VAT/GST CST
(Central Sales
Tax)
Input Output
VAT on MRP
Inclusive Exclusive
(All Tax included) (All Tax paid on MRP)
Create a stock item dairy milk 10 pkt @20 per pkt, Kitkat 15 pkt @ 10 per pkt,
FiveStar 10 pkt @ 20 per pkt.
Create a supplier ‘Pankaj store’ under ‘Sundry creditors’.
Create a ledger ‘GST’ under ‘Duties and Taxes’.
Create a purchase entry from Pankaj store Dairy milk 10 pkt, FiveStar 5 pkt,
KitKat 5 pkt and GST charge 12%.
Create a new stock item crocin, Disprin, D-Cold with the unit of stp.
Create a purchase entry from Durgapharmacrocin 10 stp @ 15 per stp, Disprin
5 stp @ 10 per stp, D-Cold 5 stp @ 12 per stp and GST charge 5% on it.
Create a purchase from ‘Bhi-BhaiFashon’ shirt 5 pcs @ 2000, T-Shirt 3 pcs @
1000, Saree 2 pcs @ 1500, pant 3 pcs @ 1800, Coat 1 pc @ 3500 and GST 12 %
on it.
Create another purchase from ‘Maa computer’ CPU 2 pcs @8000, Monitor 3
pcs @ 6000, Mouse 5 pcs @ 300, Keyboard 4 pcs @ 500, printer 1 pc @ 12000
and GST charge 15% on it.
[email protected]
Create a purchase entry from ‘Good books’ Notebook 5 pcs @ 20, eraser 10
pcs @ 5, pencil 10 pcs @ 7, Instrument box 2 pcs @ 80 and charged GST 9 %
on it.
Create a new stock item ‘Stapler’ under stationary with the unit of Nos
(Numbers).
Create a new group ‘Expense on purchase’ under purchase account and set
yes on –(applicable for value) for ‘method to allocated when are in purchase
invoice’.
[email protected]
(Tax Deducted at Source)
TDS is one of the modes of collection of income tax while shutting any kinds of payment
of the payer deducted income tax from the payer and deposit with income tax
authority.
To activate TDS Press F11 and go to ‘Statutory & Taxation’ and set yes at
‘Enable TDS Source’ and ‘Alter TDS’.
Create a ledger TDS A/C under Duties & Taxes and choose TDS nature
payment to sub-contractors.
Create a ledger job contract charge under indirect expense. Set yes TDS.
Create a party ledger ABC corporation under sundry creditors and set yes-
Is TDS applicable?
Individual (Huf) Non-Resident
Is lower deducted applicable?
Make a journal entry for job contract charge Rs.50000 by ABC Corporation.
ABC corporation A/c Dr 50000
To Job contract charge 50000
Make a payment entry after deducted amount 10% and deposit to the
government.
Bank A/c Dr 5000
To Cash (TDS) 5000
[email protected]
It is a tax on expenditure not income. It is a tax on employer cannot be
received from the employers.
To activate FBT press F11 and go to ‘Statutory & Taxation’ and set yes to
‘Enable FBT service’ and ‘Alter FBT Debtors’.
=Types of FBT:-
Create a payment entry by cash expense for tour and travelling expense
Rs.10000.
Purchase A/c Dr 20000
To Disha enterprises 20000
Create a FBT recovery under journal and set yes-‘Use class for FBT recovery’.
[email protected]
GOT > Account info > Voucher type > Create.
Create a FBT recovery entry for B.K Ltd for Rs.7000 against Tour & travelling.
B.K Ltd A/c Dr 7000
To Tour & Travelling 7000
Display FBT:-
GOT > Display > Statutory report > FBT report > FBT consumption.
TCS is by the seller from the buyer on sales of some specified goods as defined under
section 206 of the income tax at 1961.
To activate TCS press F11 and go to ‘Statutory & Taxation’ and set yes to ‘TCS
at source’.
Create a party ledger ‘Data & corporation’ under ‘Sundry creditors’ and set yes
‘Is TCS applicable’.
Create a stock item ‘Tend lives’ with the unit of ‘kg’ under ‘Alcoholics’.
Create a TCS ledger under ‘Duties & Taxes’ and select the type of duty TCS
nature of goods tend lives.
Create a purchase entry tend lives from data & corporation 100kg @ 1000 per
kg and charged TCS on it.
Create a sales entry for cash tend lives 50kg @ 1200 per kg and charged TCS on
it.
Deposit the TCS amount to the government.
[email protected]
Bank A/c Dr 5000
To Cash A/c (TCS) 5000
To display TCS report:-
Service tax is indirect tax on service provided. Service tax is paid by buyer of service to
seller of service who deposits tax to the government.
To activate service tax press F11 and go to ‘Statutory & Taxation’ and set yes
‘Enable service tax’ and ‘Alter the service tax details’.
Create a party ledger ‘A.Kumar & Sons’ under sundry debtors and set yes ‘Is
service tax applicable’.
Create a ‘Service tax’ ledger under ‘Duties & Taxes’, type of duty ‘service tax’
and category ‘Commercial training & coaching centre’.
Create a ‘Service sales’ ledger under sales A/c and set yes to ‘Is service tax
applicable’.
Create a service sales entry to A.Kumar and Sons for 2000 and also charged
service tax.
A.Kumar and Sons A/c Dr 22000
To Service sales 20000
To Service tax 2000
Create a receipt entry for service tax from A.Kumar and Sons 10%.
Service tax Dr 2000
To A.Kumar and Sons 2000
Create a ledger ‘Service purchase’ under purchase A/c and set yes to ‘Is
service tax applicable’.
Create a party ledger ‘Anuja & Sons’ under sundry creditors and set yes to ‘Is
service tax applicable’.
[email protected]
Create a ledger ‘Service tax purchase’ under ‘Duties & Taxes’.
Create a service tax purchase entry from Anuja & Sons Rs.25000 and also
charged service tax.
Service purchase A/c Dr 27500
To Anuja & Sons A/c 22000
To Service tax 2500
CST is a sales tax on interstate tax paid when goods sold from one state to another
state.
=Type of Forms:-
[email protected]
Exercise
Create a ledger ‘Supplier’ under ‘Sundry Creditors’ and inter ‘state sales tax
number’ in mailing details.
Create a ledger ‘Customer’ under ‘Sundry debtors’ and inter ‘state sales tax
number’ in mailing details.
Create ledger ‘Sales’ and ‘Purchase’ and set yes ‘Use in vat return’.
Create a ‘CST’ ledger under duties & taxes. Vat tax class-Not applicable and
percentage on calculation-3% on total sales.
Create a purchase entry from Supplier Laptop 10 pcs @ 30000 and charged
CST 3% issued C-form.
Create a sales entry to customer Laptop 5 pcs @ 32000 and CST charged 3%
and issued C-Form.
Create a debit note entry on supplier Laptop 2 pcs @ 30000 and CST charged
3% issued E1-form.
Create a credit note entry for customer Laptop 1pc @ 32000 and CST charged
3% issued E2-form.
To Display:-
GOT > Display > Statutory Report > CST Report > Form Receivable/Form Issuable.
Job costing is allocation of special resources used in a job like material consumption,
expense and income. The job cost included direct to material cost and expense related
to other cost. All expense and income allocated to the fob to find the total expense,
income and contribution attributed to a job.
To activate job costing press F11 and go to ‘Accounting features’ and activate
following:-
Exercise
[email protected]
Create a ‘sales’ and ‘purchase A/c’ and yes in cost centre applicable.
Create a cost centre ‘Bag project’ under ‘primary’ and set yes on use for job
costing.
Create a voucher type ‘Job issue’ in stock journal voucher and set yes on use
class for costing consumption.
Create a godown ‘Alif Ablicator’ under Godown and select cost centre ‘bag
project’.
Create a supplier ‘Rohit hardware’ under ‘sundry creditors’.
Create following items:-
[email protected]
Create a sale entry Leather bag 50 pcs for cash@ 250 from warehouse and
cost center ‘Bag project’.
Create journal entry for Labor charge Rs.2000.
Labor charge A/c Dr 2000
To Labor A/c 2000
GOT > Display > Statement of Account > Job work analysis.
It details with payment of wages and salaries to employee, a topical wages report
detailed information about basic pay, DA (Dearness Allowance) and other allowance,
bonus, deduction on account of taxes and other charges system report wages will be
overtime payment.
To activate payroll press F11 and go to ‘Accounting feature’ and set yes on
following:
Maintain payroll
Maintain cost centre
More than one payroll cost category.
Payhead: Payhead are the ledger account head which are affected by payment
voucher, payhead groups are payment account.
Employee head: We can create employee with the help of this option with the
details of employee name, date of joining, etc.
Exercise
Create a payhead ‘Basic salary’ payhead type ‘earning for employee’ under
‘Direct expense’ and calculation type ‘As user computed value’.
Create in payheads:-
[email protected]
a) ‘DA (Dearness allowance)’ under indirect expense, payhead type
‘earning for employee’ and calculation type ‘as user defined value’.
b) ‘HA (Housing allowance)’ under ‘Indirect expense’, calculation type
‘as user defined value’.
c) ‘MA’ under ‘Indirect expense’, calculation type ‘as user defined
value’.
Create in payhead ‘EPF (Earning provident fund)’ under ‘current liabilities’,
payhead type ‘deduction for employee’ calculation type as user computed
value’ @ 12% Rs.10000.
Create employees:-
Name Designation Work DOB
Ram Officer Official 01-04-1990
Mohan Manager Management 02-02-1996
Sohan Clerk Accounting 10-11-1996
NOTE: Date of birth must be above the 10 years.
To create employee: GOT > Payroll info > Employee > Create.
Create a payroll voucher entry –
[email protected]
Tally provide two types of attendance-
( i.) Attendance unit:- Payment is computed on daily, weeks, months date to specify
the pay rate first you should create the unit of attendance or record in days.
( ii.) Attendance type head:- You should create attendance type head for paid
attendance leave as requirement.
Exercise
Create an attendance unit ‘Day’.
Create an ‘attendance’ under ‘primary’, attendance type ‘attendance leave
with pay’ and period type ‘days’.
Create an attendance type ‘casual leave’ under ‘paid leave’.
Create an attendance ‘paid leave’ under ‘paid attendance’.
Alter the ‘basic salary’ and set calculation type ‘on attendance’.
Create attendance entry for details are attendance 25 days, casual leave 2
days and weekly help 4 days.(Ctrl+F5)
GOT > Display > Payroll report > Attendance sheet > Attendance register.
# Overtime: Over time work and payment is applicable have to create head for over
time and also unit of required. This is simple way to consumption to enter overtime
hour.
# Bonus: Bonus is an extra payment of a certain normally yearly and it is paid separately.
Exercise
Create an attendance head ‘Overtime’ under ‘primary’, attendance type
‘Attendance leave with pay’.
[email protected]
Create a payhead ‘Overtime’ under ‘indirect expense’ calculation type ‘on
attendance’ calculation period ‘month’, calculation type ‘as user defined’
month 26 days for 2 days.
Create a ‘bonus’ payhead under ‘indirect expense’ calculation type ‘as
computed value’, amount up to 10000/-, 8% and above 10000 10%.
P.T.O
[email protected]
Exercise 1
[email protected]
Exercise 2
[email protected]
Exercise 3
Exercise 4
[email protected]
Exercise 5 (Vat)
[email protected]
Stock items under stock group “computer”
Sl.No Item name Cost of Wareside Onside Total Retail Value
Price Price
1. CPU 7000 4 1 5 pcs 8000 40000
2. Keyboard 200 15 5 20 pcs 300 6000
3. Mouse 300 10 5 15 pcs 350 5250
4. Printer 1300 4 1 5 pcs 15000 75000
5. Speaker 1000 3 1 4 pcs 1500 6000
Stock items under stock group “cloth”
[email protected]
Sl.No Item name Cost of Wareside Onside Total Retail Value
Price Price
1. Notebook 15 15 5 20 pcs 20 400
2. Eraser 100 8 2 10 b 150 1500
3. Pencil 150 15 5 20 b 200 4000
Stock items under stock group “Medicine”
[email protected]
Exercise 1
Paid to Lalbabu for travel from Begusarai to Patna Rs.500/- for project.
Received a consulting fee Rs.1000 from building project.
Expense 1000 in postage allocated in 50% on road, 30% on building and rest
of 20% on airport.
Exercise 2
Purchase cement from universal cement Rs.250000/- and equally shared
between road and building. Credit period is 30 days.
Purchase steel from Tata steel Rs.350000/- and to be used 50000/- on road
and rest of on building. Credit period is 40 days.
After one month building project sold to chhabra properties Rs.900000/- 10%
amount received immediately and rest after 15 days.
Next month road was completed and sold to Begusarai city authority
Rs.1500000/- received 25% after 7 days and rest of 30 days.
Exercise 3
Create the items under stock group ‘Building material-
Cement –unit ‘bag’
Steel – unit ‘ton’
After the ‘project sales’ & ‘project purchase’ and set yes to ‘Inventory value
are affected’.
Purchase cement from universal cement Rs.40000/- 100 bags @ 400 and
equally shared between road & building. Credit period is 20 days.
Purchase 10 ton steel from Tata steel @ 8000 and equally shared with road &
building. Credit period is 15 days.
One month later building project sold to Chhabra properties at Rs.500000/-
and credit period is 20 days.
Next day building project sold to Begusarai city authority Rs.750000/-. Credit
period is 40 days.