Visit and subscribe our YouTube Channel: YouTube

Wednesday, 27 December 2017

Verification of Opening Balances in Tally

Verification of Opening Balances in Tally

Effective Date for Bank Reconciliation in Tally

Effective Date for Reconciliation (Bank Accounts only)

This is to be given for accounts falling under the Bank Accounts Group (or Bank OCC a/c). The books beginning date is taken by default. It appears in the Ledger Creation screen as shown below:

Friday, 22 December 2017

GST E Way Bill



The government is all set to put in place the E-way bills. As decided in 24th meeting of GST council,

Information to be furnished and by whom:
E-way bill system will be in place on trial basis from January 16, 2018 and will be made mandatory from February 01, 2018 for Inter-state movement of goods. The states have an option to choose their timings for the implementation of E-way bill system for intra state movement of goods. However there will be uniform E way bill system from June 01, 2018.

Remove Lines in Tally - Restore Lines in Tally

Remove and Restore Line in Tally Shortcut



Wednesday, 20 December 2017

24th GST Council on E Way Bill

The 24th GST Council Meeting held on 16th December 2017 through video conferencing decides that Inter-State e-way Bill to be made compulsory from 1st of February, 2018; The System to be ready by 16th of January, 2018; The Uniform System of e-way Bill for Inter-State as well as Intra-State movement will be implemented across the country by 1st June, 2018.


Tuesday, 19 December 2017

Monday, 18 December 2017

Reverse Billing in Tally - Rate Inclusive of GST in Tally

Tally Reverse Billing (Inclusive of GST Billing)





1. Go to Inventory Information >Stock Item > Alteration> Select Inventory


2. Click F12 Configuration  > Set as Inclusive of Tax for Stock Items : Yes

Release Notes for Tally.ERP 9 Release 6.3 – India (GSTR 3B Direct Upload From Tally)

Release Notes for Tally.ERP 9 Release 6.3 – India

Direct Export 3B from Tally

Direct Exporting Data to GSTR 3B Utility from Tally





Sunday, 17 December 2017

Importing Opening Balance in Tally

Export Opening Balance from Previous Year


1. Go to Gateway of Tally > Display > List of Accounts.


Tally Exporting Masters and Importing Masters

Exporting Masters and Importing Masters in Tally





Export Masters

1. Go to Gateway of Tally > Display > List of Accounts.

2. Click E Export to open the Export Report.

Saturday, 16 December 2017

GST Monthly Tax Computation V.1



Download the file and fill the appropriate GSTIN, Legal Name, Select the Month and Year From Drop down List Box
Fill if any Opening Balance in ITC or Cash Balance.
Fill the Current Month Details in Yellow Boxes only.






GST Monthly Tax Computation V.1




Any Further Queries please feel Free to Contact us:

goodwilllearningworld@gmail.com

goodwilllearningworld@outlook.com



GST Rate updated as on 15.11.2017 (With 23rd GST Council Amendment)

HSN Code wise GST Rate (updated as on 15.11.2017)

Please Click here to download the GST Rate








Friday, 15 December 2017

How to hide the Folder or Making the Folder invisible.

Are you wanted to hide the folder?

Is there any folder you want to keep hidden from every one's view?

Like, making the folder invisible?






Tally Cutomization -Tally TDL for Employee Photo In Tally

Copy  the Below TDL Code in text File

and save in any Folder.



Thursday, 14 December 2017

FAQs on GSTR 3B Return under GST

1. What is GSTR-3B?

GSTR-3B is a simplified summary return and the purpose of the return is for taxpayers to declare their summary GST liabilities for the tax period and the discharge of these liabilities in a timely manner.
A normal taxpayer is required to file GSTR-1, 2, & 3 returns for every tax period. In case of extension of due dates for filing of GSTR-1 and GSTR-2, GSTR-3B needs to be filed and subsequently if there is any discrepancy between the system generated 3B and earlier filed 3B the taxpayer will have to pay additional tax, liability and other dues.


Tally Customization -Tally TDL for View GSTIN in Purchase & Sales Vouchers


Copy  the Below TDL Code in text File

and save in any Folder.


Memorandum Vouchers in Tally

Memorandum Vouchers in Tally
In this article you are going to learn how to create and what is the use of:
Ø Memorandum Vouchers
Ø Post Dated Vouchers
Ø A blend of Memorandum and Post Dated Vouchers





UNPROTECT ANY EXCEL WORKBOOK





Step 1: Open the Excel File, Press Alt+F11 to Open MS Visual Basic.


Step 2: Press F7, and Paste The Following Code


Income Tax Slab Rate for Assessment Year 2017-18 (FY 2016-17)


Income Tax Slabs in India

The Income Tax slab rates are different for different categories of taxpayers. We can divide Income Tax slab rates for the following categories:


·         Individual or HUF or Association of Person or Body of Individual or Artificial Juridical Person
·         resident senior citizen
·         resident super senior citizen
·         partnership firm
·         local authority
·         domestic company
·         foreign company
·         For a co-operative society

Income Tax Slab Rates for Assessment Year 2017-18


Income Tax Slab Rates for Assessment Year 2018-19 (FY 2017-18)


For Individual or HUF or Association of Person or Body of Individual or Artificial Juridical Person
Income Tax Slab Rates for Assessment Year 2018-19


Income Range (in Rupees)
Tax Rate (in %age)
Zero – 2,50,000
Nil
2,50,000-5,00,000
5%
5,00,000-10,00,000
20%
Above 10,00,000
30%
Less: Rebate u/s 87A – It is only applicable to resident individuals with income up to Rs. 3,50,000. The maximum amount of rebate allowed is Rs. 2,500.
Add: Surcharge – A surcharge @ 10% of tax is applicable if income lies between Rs. 50 lakhs to Rs. 1 crore, but if it exceeds Rs. 1 crore then the surcharge will be payable @ 15%. However, surcharge is subject to marginal relief as stated:
·         If income exceeds Rs. 50 Lakh or Rs. 1 crore as the case may be, the applicable tax plus surcharge should not exceed the part of income which is in excess to Rs. 1 crore.
Add: “Education Cess” and “Secondary and Higher Education Cess” shall be levied at the rate of 2% and 1% respectively, on the amount of tax computed, inclusive of surcharge.


For resident senior citizen (between 60 and 80 years of age)
Slab Rates for A.Y. 2018-19 (F.Y. 2017-18)
Income Range (in Rupees)
Tax Rate (in %age)
Zero – 3,00,000
Nil
3,00,000-5,00,000
5%
5,00,000-10,00,000
20%
Above 10,00,000
30%
Less: Rebate u/s 87A – It is only applicable to resident individuals with income up to Rs. 3,50,000. The maximum amount of rebate allowed is Rs. 2,500.
Add:Surcharge – A surcharge @ 10% of tax is applicable if income lies between Rs. 50 lakhs to Rs. 1 crore, but if it exceeds Rs. 1 crore then the surcharge will be payable @ 15%. However, surcharge is subject to marginal relief as stated:
·         If income exceeds Rs. 50 Lakh or Rs. 1 crore as the case may be, the applicable tax plus surcharge should not exceed the part of income which is in excess to Rs. 1 crore.
Add: “Education Cess” and “Secondary and Higher Education Cess” shall be levied at the rate of 2% and 1% respectively, on the amount of tax computed, inclusive of surcharge.


For resident super senior citizen (80 years and above)
Slab Rates for A.Y. 2018-19 (F.Y. 2017-18)
Income Range (in Rupees)
Tax Rate (in %age)
Zero – 5,00,000
Nil
5,00,000-10,00,000
20%
Above 10,00,000
30%
Add: Surcharge – A surcharge @ 10% of tax is applicable if income lies between Rs. 50 lakhs to Rs. 1 crore, but if it exceeds Rs. 1 crore then the surcharge will be payable @ 15%. However, surcharge is subject to marginal relief as stated:
·         If income exceeds Rs. 50 Lakh or Rs. 1 crore as the case may be, the applicable tax plus surcharge should not exceed the part of income which is in excess to Rs. 1 crore.
Add: “Education Cess” and “Secondary and Higher Education Cess” shall be levied at the rate of 2% and 1% respectively, on the amount of tax computed, inclusive of surcharge.


For a partnership firm (including LLP)
Slab Rates for A.Y. 2018-19 (F.Y. 2017-18)
Tax Rate
Surcharge
Education Cess
Secondary & Higher
Education Cess
30%
12%
2%
1%
Add: Surcharge – A surcharge @ 12% of tax is applicable if income exceeds Rs. 1 crore. However, surcharge is subject to marginal relief.
·         If income exceeds Rs. 1 crore, the applicable tax plus surcharge should not exceed the part of income which is in excess to Rs. 1 crore.
Add: “Education Cess” and “Secondary and Higher Education Cess” shall be levied at the rate of 2% and 1% respectively, on the amount of tax computed, inclusive of surcharge.


For a local authority
Slab Rates for A.Y. 2018-19 (F.Y. 2017-18)
Tax Rate
Surcharge
Education Cess
Secondary & Higher
Education Cess
30%
12%
2%
1%
Add: Surcharge – A surcharge @ 12% of tax is applicable if income exceeds Rs. 1 crore. However, surcharge is subject to marginal relief.
·         If income exceeds Rs. 1 crore, the applicable tax plus surcharge should not exceed the part of income which is in excess to Rs. 1 crore.
Add: “Education Cess” and “Secondary and Higher Education Cess” shall be levied at the rate of 2% and 1% respectively, on the amount of tax computed, inclusive of surcharge.


For a domestic company
Slab Rates for A.Y. 2018-19 (F.Y. 2017-18)
Tax Rate
Surcharge
Education Cess
Secondary & Higher
Education Cess
25% for income up to Rs. 50 crore
7% for income between Rs. 1 crore & Rs. 10 crore
2% of income tax plus surcharge
1% of income tax plus surcharge
30% for income exceeding Rs. 50 crore
7% for income between Rs. 1 crore & Rs. 10 crore and 12% if income exceeds Rs. 10 crore
Add: Surcharge – A surcharge @ 12% of tax is applicable if income exceeds Rs. 1 crore. However, surcharge is subject to marginal relief.
·         If income lies between Rs. 1 crore & Rs. 10 crore, the applicable tax plus surcharge should not exceed the part of income which is in excess to Rs. 1 crore.
·         If income exceeds Rs. 10 crore, the applicable tax plus surcharge should not exceed the part of income which is in excess to Rs. 10 crore.
Add: “Education Cess” and “Secondary and Higher Education Cess” shall be levied at the rate of 2% and 1% respectively, on the amount of tax computed, inclusive of surcharge.


For a foreign company
Slab Rates for A.Y. 2018-19 (F.Y. 2017-18)
Tax Rate
Surcharge
Education Cess
Secondary & Higher
Education Cess
Income b/w Rs. 1 crore & Rs. 10 crore
Income exceeds Rs. 10 crore
50% on royalty received from government or Indian concern*
2%
5%
2%
1%
40% on any other income
2%
5%
*Note: Royalty here means –
·         Royalty received from government or an Indian concern in pursuance of an agreement (approved by Central government) between April 1, 1961 and 31 March, 1976
·         Fees for providing technical services in pursuance of an agreement (approved by Central government) made between February 29, 1964 and April 1, 1976
Add: Surcharge – A surcharge is applicable in the following 2 conditions subject to marginal relief:
·         If income lies between Rs. 1 crore & Rs. 10 crore, the applicable surcharge should be 2%.
·         If income exceeds Rs. 10 crore, the applicable surcharge should be 5%.

Marginal Relief on Surcharge –
·         If income lies between Rs. 1 crore & Rs. 10 crore, the applicable tax plus surcharge should not exceed the part of income which is in excess to Rs. 1 crore.
·         If income exceeds Rs. 10 crore, the applicable tax plus surcharge should not exceed the part of income which is in excess to Rs. 10 crore.
Add: “Education Cess” and “Secondary and Higher Education Cess” shall be levied at the rate of 2% and 1% respectively, on the amount of tax computed, inclusive of surcharge.


For a Co-operative Society
Slab Rates for A.Y. 2018-19 (F.Y. 2017-18)
Income Range (in Rupees)
Tax Rate (in %age)
Zero – 10,000
Nil
10,000 – 20,000
20%
Above 20,000
30%
Add: Surcharge – A surcharge @ 12% of tax is applicable if income exceeds Rs. 1 crore. However, surcharge is subject to marginal relief as stated:
·         If income exceeds Rs. 1 crore, the applicable tax plus surcharge should not exceed the part of income which is in excess to Rs. 1 crore.
Add: “Education Cess” and “Secondary and Higher Education Cess” shall be levied at the rate of 2% and 1% respectively, on the amount of tax computed, inclusive of surcharge.


How to Calculate Income Tax from Income Tax Slab Rates?
Suppose Mr. Nikhil has an annual income of Rs. 10 lakh in the Financial Year 2016-17. How will we calculate his tax liability for Assessment Year 2017-18?
Income (in rupees)
Tax Rate (in %age)
Calculation
Zero – 2,50,000
Nil
2,50,000 x 0 = 0
2,50,000 – 5,00,000
10%
2,50,000 x 10% = 25,000
5,00,000 – 10,00,000
20%
5,00,000 x 20% = 1,00,000
Above 10,00,000
30%
0 x 30% = 0
Total tax = (0 + 25,000 + 1,00,000 + 0) x 1.03 = Rs. 1,28,750
So, his tax liability for Financial Year 2016-17 comes out to be Rs. 1,28,750.
Now suppose that he earns the same amount of income in the Financial Year 2017-18. How will we calculate his tax liability for Assessment Year 2018-19?
Income (in rupees)
Tax Rate (in %age)
Calculation
Zero – 2,50,000
Nil
2,50,000 x 0 = 0
2,50,000 – 5,00,000
5% (new rate)
2,50,000 x 5% = 12,500
5,00,000 – 10,00,000
20%
5,00,000 x 20% = 1,00,000
Above 10,00,000
30%
0 x 30% = 0
Total tax = (0 + 12,500 + 1,00,000 + 0) x 1.03 = Rs. 1,15,875
So, his tax liability for Financial Year 2017-18 comes out to be Rs. 1,15,875. His tax liability has effectively reduced in F.Y. 2017-18 for the same amount of income earned during F.Y. 2016-17 due to reduction in tax slab rate for income falling between Rs. 2,50,000 to Rs. 5,00,000.
Note: This tax calculation is a basic example for your understanding which is applicable only for individuals (up to 60 years of age) without accounting for tax deductions and exemptions.
Income Tax Slab Rates for Assessment Year 2018-19


For Individual or HUF or Association of Person or Body of Individual or Artificial Juridical Person
Slab Rates for A.Y. 2018-19 (F.Y. 2017-18)
Income Range (in Rupees)
Tax Rate (in %age)
Zero – 2,50,000
Nil
2,50,000-5,00,000
5%
5,00,000-10,00,000
20%
Above 10,00,000
30%
Less: Rebate u/s 87A – It is only applicable to resident individuals with income up to Rs. 3,50,000. The maximum amount of rebate allowed is Rs. 2,500.
Add: Surcharge – A surcharge @ 10% of tax is applicable if income lies between Rs. 50 lakhs to Rs. 1 crore, but if it exceeds Rs. 1 crore then the surcharge will be payable @ 15%. However, surcharge is subject to marginal relief as stated:
·         If income exceeds Rs. 50 Lakh or Rs. 1 crore as the case may be, the applicable tax plus surcharge should not exceed the part of income which is in excess to Rs. 1 crore.
Add: “Education Cess” and “Secondary and Higher Education Cess” shall be levied at the rate of 2% and 1% respectively, on the amount of tax computed, inclusive of surcharge.


For resident senior citizen (between 60 and 80 years of age)
Slab Rates for A.Y. 2018-19 (F.Y. 2017-18)
Income Range (in Rupees)
Tax Rate (in %age)
Zero – 3,00,000
Nil
3,00,000-5,00,000
5%
5,00,000-10,00,000
20%
Above 10,00,000
30%
Less: Rebate u/s 87A – It is only applicable to resident individuals with income up to Rs. 3,50,000. The maximum amount of rebate allowed is Rs. 2,500.
Add:Surcharge – A surcharge @ 10% of tax is applicable if income lies between Rs. 50 lakhs to Rs. 1 crore, but if it exceeds Rs. 1 crore then the surcharge will be payable @ 15%. However, surcharge is subject to marginal relief as stated:
·         If income exceeds Rs. 50 Lakh or Rs. 1 crore as the case may be, the applicable tax plus surcharge should not exceed the part of income which is in excess to Rs. 1 crore.
Add: “Education Cess” and “Secondary and Higher Education Cess” shall be levied at the rate of 2% and 1% respectively, on the amount of tax computed, inclusive of surcharge.


For resident super senior citizen (80 years and above)
Slab Rates for A.Y. 2018-19 (F.Y. 2017-18)
Income Range (in Rupees)
Tax Rate (in %age)
Zero – 5,00,000
Nil
5,00,000-10,00,000
20%
Above 10,00,000
30%
Add: Surcharge – A surcharge @ 10% of tax is applicable if income lies between Rs. 50 lakhs to Rs. 1 crore, but if it exceeds Rs. 1 crore then the surcharge will be payable @ 15%. However, surcharge is subject to marginal relief as stated:
·         If income exceeds Rs. 50 Lakh or Rs. 1 crore as the case may be, the applicable tax plus surcharge should not exceed the part of income which is in excess to Rs. 1 crore.
Add: “Education Cess” and “Secondary and Higher Education Cess” shall be levied at the rate of 2% and 1% respectively, on the amount of tax computed, inclusive of surcharge.


For a partnership firm (including LLP)
Slab Rates for A.Y. 2018-19 (F.Y. 2017-18)
Tax Rate
Surcharge
Education Cess
Secondary & Higher
Education Cess
30%
12%
2%
1%
Add: Surcharge – A surcharge @ 12% of tax is applicable if income exceeds Rs. 1 crore. However, surcharge is subject to marginal relief.
·         If income exceeds Rs. 1 crore, the applicable tax plus surcharge should not exceed the part of income which is in excess to Rs. 1 crore.
Add: “Education Cess” and “Secondary and Higher Education Cess” shall be levied at the rate of 2% and 1% respectively, on the amount of tax computed, inclusive of surcharge.


For a local authority
Slab Rates for A.Y. 2018-19 (F.Y. 2017-18)
Tax Rate
Surcharge
Education Cess
Secondary & Higher
Education Cess
30%
12%
2%
1%
Add: Surcharge – A surcharge @ 12% of tax is applicable if income exceeds Rs. 1 crore. However, surcharge is subject to marginal relief.
·         If income exceeds Rs. 1 crore, the applicable tax plus surcharge should not exceed the part of income which is in excess to Rs. 1 crore.
Add: “Education Cess” and “Secondary and Higher Education Cess” shall be levied at the rate of 2% and 1% respectively, on the amount of tax computed, inclusive of surcharge.


For a domestic company
Slab Rates for A.Y. 2018-19 (F.Y. 2017-18)
Tax Rate
Surcharge
Education Cess
Secondary & Higher
Education Cess
25% for income up to Rs. 50 crore
7% for income between Rs. 1 crore & Rs. 10 crore
2% of income tax plus surcharge
1% of income tax plus surcharge
30% for income exceeding Rs. 50 crore
7% for income between Rs. 1 crore & Rs. 10 crore and 12% if income exceeds Rs. 10 crore
Add: Surcharge – A surcharge @ 12% of tax is applicable if income exceeds Rs. 1 crore. However, surcharge is subject to marginal relief.
·         If income lies between Rs. 1 crore & Rs. 10 crore, the applicable tax plus surcharge should not exceed the part of income which is in excess to Rs. 1 crore.
·         If income exceeds Rs. 10 crore, the applicable tax plus surcharge should not exceed the part of income which is in excess to Rs. 10 crore.
Add: “Education Cess” and “Secondary and Higher Education Cess” shall be levied at the rate of 2% and 1% respectively, on the amount of tax computed, inclusive of surcharge.


For a foreign company
Slab Rates for A.Y. 2018-19 (F.Y. 2017-18)
Tax Rate
Surcharge
Education Cess
Secondary & Higher
Education Cess
Income b/w Rs. 1 crore & Rs. 10 crore
Income exceeds Rs. 10 crore
50% on royalty received from government or Indian concern*
2%
5%
2%
1%
40% on any other income
2%
5%
*Note: Royalty here means –
·         Royalty received from government or an Indian concern in pursuance of an agreement (approved by Central government) between April 1, 1961 and 31 March, 1976
·         Fees for providing technical services in pursuance of an agreement (approved by Central government) made between February 29, 1964 and April 1, 1976
Add: Surcharge – A surcharge is applicable in the following 2 conditions subject to marginal relief:
·         If income lies between Rs. 1 crore & Rs. 10 crore, the applicable surcharge should be 2%.
·         If income exceeds Rs. 10 crore, the applicable surcharge should be 5%.

Marginal Relief on Surcharge –
·         If income lies between Rs. 1 crore & Rs. 10 crore, the applicable tax plus surcharge should not exceed the part of income which is in excess to Rs. 1 crore.
·         If income exceeds Rs. 10 crore, the applicable tax plus surcharge should not exceed the part of income which is in excess to Rs. 10 crore.
Add: “Education Cess” and “Secondary and Higher Education Cess” shall be levied at the rate of 2% and 1% respectively, on the amount of tax computed, inclusive of surcharge.


For a Co-operative Society
Slab Rates for A.Y. 2018-19 (F.Y. 2017-18)
Income Range (in Rupees)
Tax Rate (in %age)
Zero – 10,000
Nil
10,000 – 20,000
20%
Above 20,000
30%
Add: Surcharge – A surcharge @ 12% of tax is applicable if income exceeds Rs. 1 crore. However, surcharge is subject to marginal relief as stated:
·         If income exceeds Rs. 1 crore, the applicable tax plus surcharge should not exceed the part of income which is in excess to Rs. 1 crore.
Add: “Education Cess” and “Secondary and Higher Education Cess” shall be levied at the rate of 2% and 1% respectively, on the amount of tax computed, inclusive of surcharge.


How to Calculate Income Tax from Income Tax Slab Rates?
Suppose Mr. Nikhil has an annual income of Rs. 10 lakh in the Financial Year 2016-17. How will we calculate his tax liability for Assessment Year 2017-18?
Income (in rupees)
Tax Rate (in %age)
Calculation
Zero – 2,50,000
Nil
2,50,000 x 0 = 0
2,50,000 – 5,00,000
10%
2,50,000 x 10% = 25,000
5,00,000 – 10,00,000
20%
5,00,000 x 20% = 1,00,000
Above 10,00,000
30%
0 x 30% = 0
Total tax = (0 + 25,000 + 1,00,000 + 0) x 1.03 = Rs. 1,28,750
So, his tax liability for Financial Year 2016-17 comes out to be Rs. 1,28,750.
Now suppose that he earns the same amount of income in the Financial Year 2017-18. How will we calculate his tax liability for Assessment Year 2018-19?
Income (in rupees)
Tax Rate (in %age)
Calculation
Zero – 2,50,000
Nil
2,50,000 x 0 = 0
2,50,000 – 5,00,000
5% (new rate)
2,50,000 x 5% = 12,500
5,00,000 – 10,00,000
20%
5,00,000 x 20% = 1,00,000
Above 10,00,000
30%
0 x 30% = 0
Total tax = (0 + 12,500 + 1,00,000 + 0) x 1.03 = Rs. 1,15,875
So, his tax liability for Financial Year 2017-18 comes out to be Rs. 1,15,875. His tax liability has effectively reduced in F.Y. 2017-18 for the same amount of income earned during F.Y. 2016-17 due to reduction in tax slab rate for income falling between Rs. 2,50,000 to Rs. 5,00,000.

Note: This tax calculation is a basic example for your understanding which is applicable only for individuals (up to 60 years of age) without accounting for tax deductions and exemptions.