calculation of professional tax

Normally professional tax in not applicable all over the country but there are some state where the government take professional tax 

Karnataka,
Bihar, 
West Bengal,
AndhraPradesh,
Telangana, 
Maharashtra,
Tamil Nadu, 
Gujarat,
Assam, 
Kerala,
Meghalaya,
Odisha, 
Tripura, 
Madhya Pradesh
Sikkim.

 Professional tax caluclted on two basis  1. Professional Tax on Total Salary.

2. Professional Tax on Basis Salary.

So Here is the Exanple

Formula:                                                                                                                                 =IF((E7>=$A$2)*(E7<=$B$2),$C$2,IF((E7>=$A$3)*(E7<=$B$3),$C$3,IF((E7>=$A$4)*(E7<=$B$4),$C$4,IF((E7>=$A$5)*(E7<=$B$5),$C$5,IF((E7>=$A$6)*(E7<=$B$6),$C$6))))) 


($ it is the sign that fix the cell, select the cell and press F4 or Fn+F4)

2. Calculation of professional Tax according to the basis salary

Golden rule of account

TALLY

Accounting is the systematic and comprehensive way recording of financial transactions related to a business, and it also refers to the process of summarizing, analyzing and reporting these transactions to oversight agencies and tax collection entities. Accounting is one of the key functions for almost any business; it may be handled by a bookkeeper and accountant at small firms or by sizable finance departments with dozens of employees at large companies

Personal Account:- As the name show "personal account" it means account for an individual person or the firm. it can be a person Eg. Ram, Shyam, joy Etc or the firm or a company it will count in personal account.


Real Account:- A real account is a general ledger account that does not close at the end of the accounting year. The balance of real account carry forward to next yeat.
real accountsa are balance sheet item like- asset accounts (cash, account receivable, buildings, etc.), liability accounts (notes payable, account payable, wages payable, etc.), and stockholder equity account etc.


Nominal Acccount:- Nominal accounts are directly related to Excpens and income of the firm Expense can be direct and indirect both.


Monetary traction of Business is to be recorded in the book of account of account by the method of Double accounting system.

                                                Accounting ledger

                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              

Personal account	Real account	Nominal account
1.Person 2. Firm 3. Company Etc	1. Cash 2. Building 3. Furniture 4. Machinery etc	1. Expenses & losses 2. Income and gain

                              

                                                                  GOLDEN RULE    

Personal	Real	Nominal
1.       Debit the receiver 2.       Credit the Giver	1.       Debit what comes in 2.       Credit what goes out	3.       Debit All expense 4.       Credit all income & gain

   

                                                

shortcut keys

                                               SHORTCUT  KEYS OF TALLY                                 


Shortcut Keys are helpfull to work fast. These keys are always helpfull. it save the time and boost the speed  of work.

1.         F1                           To select a Company

2.         Alt+ F1                  To select the inventory
                                       ( To view the detailed of entries)

3.         Ctrl+F1                  To see payroll Voucher

4.         F2                           To change the current date

5.         F3                           To select company

6.         F4                           To select the contra Voucher
                                    (For Cash to Bank or Bank to cash entry)

7.         F5                           To select the payment voucher

8.         F6                           To Select the receipt voucher

9.         F7                           To select the journal voucher     

10.      F8                           To select the sales voucher

11.      Ctrl+F8                  To Select the credit note

12.      F9                           To select the purchase voucher

13.      Ctrl+F9                  To select the debit note

14.      F10                         To select the reversing Journal Voucher

15.      Ctrl + F10             To select the memorandum  voucher

16.      F11                         To select the function and features screen

17.      F12                         To select the Configure Screen

Convert negative value in postive

                                  Convert Negative Value in Positive


Replace all Negative value in positive. Here is the table

1. Select the whole negative row

2. Press Ctrl+F

3. Click on Replace All.

Click on Ok 

Now all the negative values are changed into Positive.

Excel introduction

Excel was Developed by Microsoft and first released on September 30, 1985, Excel is capable of creating and editing spreadsheets that are saved with a .xls or .xlsx file extension. General uses of Excel include cell-based calculation, pivot tables, and various graphing tools. For instance, with an Excel spreadsheet, you could create a monthly budget, track business expenses, or sort and organize large amounts of data.
                Microsoft Excel is a spreadsheet program that is used to record and analyse numerical data.We all deal with numbers in one way or the other. We all have daily expenses which we pay for from the monthly income that we earn. For one to spend wisely, they will need to know their income vs. expenditure. Microsoft Excel comes in handy when we want to record, analyze and store such numeric data.
   How to start excel                       

• Click on start menu
• Point to all programs
• Point to Microsoft Excel
• Click on Microsoft Excel

Alternatively, you can also open it from the start menu if it has been added there. You can also open it from the desktop shortcut if you have created one.

Randbetween

                                       Randbetween Function


To Get a random value in a table we use this Formula(Randbetween).

Syntex: 
=Randbetween(Bottom,Top)

  Bottom= Here Put The Botton Value
  Top      = Here put the Top Value

Example- we want a random table between 500 & 1000. Here is bottom value is 500 and                         top value 1000.