Sunday, December 22, 2019

Classroom Assignment






Sesson 40

 Intrastate goods purchases:-
On 1st July 2017, purchased 100 no Rel Comm Series All Mobile phones
@ Rs. 7400 each from Rel Comm Mobiles, Maharashtra.
Invoice No. RCM/0107. CGST @ 6% & SGST @ 6%

 Intrastate goods sales:-   
On 2nd July, we sold 50 Rel Comm Series All Mobile phones at
The rate of Rs. 10,000 each to Mobile Gallery, Maharashtra. The
Invoice number is MG/02017. Extra packaging cost is Rs. 1,000.
CGST & SGST are 6% each.

 Interstate Goods purchases:-
On 3rd July 2017, purchased 200 India Air Bol Series
G12 at Rs. 9,500/- each from India AirBol Mobiles, Karnataka.
Invoice No. IAM/0307. IGST 12%

 Interstate Goods sales:-
On 4th July 2017, we sold 200 numbers of India
AirBol Series G12 at Rs. 15, 000/- each to Mobiles
Home, Tamil Nadu. The invoice number is
MH/0407. The IGST is 12%.

Sales Return :-
On 10th July, a mobile gallery returned 20
Damaged mobiles.

Purchases Return:-
On 12th july, returned 20 damaged mobiles to
Rel Comm Mobiles

 Sale with inclusive of taxes:-

On 14th July sold 50 Rel Comm Series A11 @ Rs. 11,000/- inclusive

Tax to New India Mobile Shoppe, Maharashtra.

Payroll in Tally


 Payroll
Payroll means salary calculation of an employee in the business.
Payroll is simply an aggregation of total amount wages paid by the business to its employees.
The total amount of money that a company pay to its employees.

Pay Head:-

Basic Salary
H.R.A.
T.A.
D.A.
Bonus
Leave
P.F.
Overtime

Payroll Processing in Tally

Payroll:-

Employee Databases
Leave & Attendance
Overtime / Production
Income- Tax
Loans & Advances
Salary & Increments
Pay-slip
Provident Fund
Professional Tax
Employee State Insurance
National Pension Scheme

Five Easy Steps to Payrol:-

(1)
(2)
(3)
(4)
(5)
Create
Employee
Master
Create
Payroll
Master
Create
Pay
Heads
Create
Salary
Details
Process
Payroll
1 Employee
   Groups

2 Employee
    Master
1 Payroll Unit


2 Attendance /                                      
Production Type
1 Earning

2 Deductions

3 Employees’       
   Statutory  
   Deductions

4 Employees’
   Statutory
  Contributions
1 Group Pay
   Structure

2 Individual
   Pay Structure
1 Attendance    
   Process

2 Payroll    
   Process

3 Payroll   
   Reports

 Example:-

Mr. Chandan Kumar is an employee of a company as an assistance manager, (Branch office Mahua) in the department of marketing. He absents 3 days and Overtime 20 hrs  in the month. Absenting charge ₹ 200/- per day and Overtime rate ₹ 200/- per hour. His Salary details are following:-

Basic Salary                          :-          50,000/-
Bonus                                    :-            1,000/-
D.A.                                        :-            5,000/-
H.R.A.                                    :-            5,000/-
Overtime                                :-            4,000/-
T.A.                                         :-            5,000/-
Leave                                     :-           (   600/-)
P.F.                                         :-           ( 5,000/-)


Request to you prepare Pay-slip of Mr. Chandan Kumar in tally.


 Enabling Payroll :-
           
Gateway of Tally > F:11 Company Features > Accounting Features > Cost / Profit centre managements > Maintain Payroll – “Yes”





Payroll Info

           
The Payroll Info. Allows to set up the employee defaults and standard payroll information with common payroll fields used for calculating earning and deductions.

 Payroll Info:-

           


Gateway of Tally > Payroll Info.



Payroll Info.
                                                                         
       Employee Categories
       Employee Groups
       Employee
                     
       Units (Work)
       Attendance/ProductionTypes

      Pay Heads
      Salary Details
      Voucher Types
      Quit





            Employee Categories:-

            Each categories is unique with regard to type of work performed, job security, benefits package, and ability to organize unions. Assignment to an employee category is based upon job title and the role of the position.

Following are the employee categories in the business/company:
·         Account Department
·         Sales Department
·         Managing Department
·         Branch office Mahua
·         Branch office Hajipur
·         Branch office Sonpur
·         Branch office Patepur etc.


 Employee Categories Creation:-

Gateway of Tally > Payroll Info.> Employee Categories > Create






 Employee Group:-
           
            Employee Group allows to group employees in a logical manner.
The salary structure can be defined at the employee group level.

Following are the employee group by designation:
·         Managers
·         Field Managers
·         Supervisors
·         Senior Accountants
·         Junior Accountants
·         Computer Operators
·         Clerks
·         Peons
·         Workers
·         Sales Department
·         Marketing Department etc.

Employee group creation:-

Gateway of Tally > Payroll Info. > Employee Group > Create
1.    Sales Department
2.    Marketing Department








 Unit creation :-
           
            Gateway of Tally > Payroll Info. > Unit > Create
1.  Hrs (Hours)
2.  Min (Minutes)
3.    Hrs of 60 min







 Attendance / Production Types creation:-

            Gateway of Tally > Payroll Info > Attendance / Production > Create


Name
Under
Type
Unit
1.    Leave
Primary
Leave without Pay
Day
2.    Overtime
Primary
Production
Hrs of 60 min







 Pay Head :-

A Pay Head is categorized as allowances, Deductions or Reimbursements in tally, Payhead types are provided in natural language for ease of use, as follow in this we have to define Basic, H.R.A, D.A, P.F, Bonus, etc.







 Pay Head Creation:-
            Gateway of tally > Payroll Info. > Pay Head > Create

Name
Basic
Salary
H.R.A.
Leave
P.F.
Overtime
Bonus
Pay Head Types
Earning for Employees
Earning for Employees
Deduction from Employees
Deduction from Employee
Earning for Employee
Earning for Employee
Incomes Types
Fixed
Fixed


Variable
Variable
Under
Indirect Expenses
Indirect Expenses
Current Liabilities
Current Liabilities
Indirect Expenses
Indirect Expenses
Efect net Salary
Yes
Yes
Yes
Yes
Yes
Yea
Name to be display in payroll
Basic Salary
H.R.A.
Leave
P.F.
Overtime
Bonus
Currency of Ledger
   ₹
Use for calculation of Gratuity
No
No
No
No
No
No
Set /Alter Income Tax Details
No
No
No
No
No
No
Calculation Types
As User Defined Value
As Computed Value
On Attendance
(Leave Without Pay-Leave)
As Computed Value
On Prduction
Flate Rate
Calculation Period

Months
Days
Months

Months
Rounding Methord

Normal Rounding
Normal Rounding
Normal Rounding
Normal Rounding
Normal Rounding
Limit

Nil
Nil
Nil
Nil
Nil
Compute

On Speciefied Formula

On Speciefied Formula


Specified Formula

Basic Salary

Basic Salary












 Basic Salary Creation:-
            Gateway of tally > Payroll Info. > Pay Head > Create




 H.R.A. Creation:-
            Gateway of tally > Payroll Info. > Pay Head > Create



 T.A. Creation:-
            Gateway of tally > Payroll Info. > Pay Head > Create




 D.A. Creation:-
            Gateway of tally > Payroll Info. > Pay Head > Create




 Leave Creation:-
            Gateway of tally > Payroll Info. > Pay Head > Create



 P.F. Creation:-
            Gateway of tally > Payroll Info. > Pay Head > Create



 Overtime Creation:-
            Gateway of tally > Payroll Info. > Pay Head > Create



 Bonus creation:-
            Gateway of tally > Payroll Info. > Pay Head > Create



Reimbursement  Creation:-
            Gateway of tally > Payroll Info. > Pay Head > Create




 Salary Details:-

            In Tally, throgh this option we set salary detail of an employee. Salary detail means earning for employee and deduction from employee. Example:- Basic Salary, H.R.A, T.A, D.A, Bonus, P.F, etc.

Salary Details Creation :-

            Gateway of Tally > Payroll Info > Salary Detail > Define




To set salary detail of Marketing Departmental employees

Gate way of tally > Payroll Info. > Salary Details > Define > Marketing Department >


 Employee:-
           
            The person which workes in the company/business on the basic of monthly salary is called employee. Example:- Manager, Assitance Manager, Sales Manager, Peon, Clerk, Cashier, Accountant, Field Officer etc.

 Employee Creation :-
           
            Gateway of Tally > Payroll Info.> Employee > Create



















Salary Payable Creation :-
           

 Gateway of tally > Payroll Info. > Pay Head > Create  

 Payroll Voucher Alteration :-
           

 Gateway of tally > Payroll Info. > Payroll Voucher Type > Alter > Payroll





 Payroll Voucher Entry :-


Gateway of tally > Payroll Voucher


 Attendance & Leave Recording :-


            Ctrl + F5 attendance


Ctrl + F4 Payroll

Alt + A   Payroll Autofill





Again Payroll Autofill (Alt+A)






 To view Payroll-slip :-
           

            Gateway of Tally > Display > Payroll Reports > Statement of Payroll > Pay Slip > Single Pay Slip > Chandan Kumar > Alt + P (Print with Preview)