Sunday, April 4, 2021

Tally GST with Example


GST के लिये ERP 9 Tally में करे 

और साथ ही release 6 या 6 से उपर का होना जरुरी है 

जो आपको Gate way of Tally में नीचे की ओर दिखेगा !!

Question

A article is marked at Rs 15000.

A dealer sells it to a consumer at 10% profit. 

If the rate of GST is 12% find:

(i) the selling price (Excluding tax) of the article.

(ii) the amount of tax (under GST) paid by the consumer.

(iii) the total amount paid by the consumer.

Solution:

(i) marked price of the article =15000 Rs.

when sold at 10% profit

profit=15000*(10/100)=1500 Rs

Thus the selling price (excluding tax)=15000+1500

=16500 Rs.

(ii) The rate of GST is 12%

Thus the amount of tax (GST) paid by the consumer would be 

=16500*(12/100)

=1980 Rs

(iii) Therefore, the total amount paid by consumer= Selling price + GST

=  16500 Rs + 1980 Rs

= 18480 Rs

Tally Solution 

GST

Create a Company

Gateway of Tally> Create Company

Name > ABC & Co.

Country> India 

State > Chhattisgarh 

Gateway of Tally> press F11>F3

Enable GST Goods and services Tax> yes

Set/alter GST Details >yes

GSTIN/UIN  22AAAAA1234A1Z5 (for CG )

Press Ctrl+A

Press Ctrl+A

Create a Item for Computer

Gateway of Tally > Inventory Info > Stock Items> Create> Computer

Under > Primary

Category > Not Applicable

Units> ctrl + c 

Name Pcs

Under Primary

Ctrl + A

Ctrl+ A

Create a Ledger for Buyer Mohan

Gateway of Tally> Accounts Info> Ledgers> Create > Buyer Mohan

Under> Sundry Debtors 

Maintain bill by bill >yes

Country >India

State >Chhattisgarh 

Registration Type>Regular

GSTIN/UIN > 22AAAAA1234A1Z5

Set/Alter GST details ? yes

Yes करने पर एक screen आयेगा अगर नही आया तब F12 press करना फिर

Provides aliases along with name? Yes

Provide advanced information in master? Yes

Provide address for ledger accounts? Yes

Registration type Regular 

Access of other Territory? No

Is e-commerce operator ? No

Consider party as deemed export for purchase ? No

Party type Not Applicable

GSTIN/UIN 22AAAAA1234A1Z5

Is a transporter ? No

Ctrl+A

Ctrl + A

Create a Ledger for Consumer Sohan

Gateway of Tally> Accounts Info> Ledgers> Create > Consumer Sohan

Under> Sundry Creditors 

Maintain bill by bill >yes

Country >India

State >Chhattisgarh 

Registration Type>Regular

GSTIN/UIN > 22AAAAA1234A1Z5

Set/Alter GST details ? yes

Yes करने पर एक screen आयेगा अगर नही आया तब F12 press करना फिर

Provides aliases along with name? Yes

Provide advanced information in master? Yes

Provide address for ledger accounts? Yes

Registration type Regular 

Access of other Territory? No

Is e-commerce operator ? No

Consider party as deemed export for purchase ? No

Party type Not Applicable

GSTIN/UIN 22AAAAA123451Z5

Is a transporter ? No

Ctrl + A

Ctrl + A

Create a Ledger for CGST

Gateway of Tally > Accounting Info > Create > CGST 

Under> Duties & Taxes

Type of duty’s/Tax > GST

Tax type > Central Tax

Ctrl+A

Create a Ledger for SGST

Gateway of Tally > Accounting Info > Create > SGST 

Under> Duties & Taxes

Type of duty’s/Tax > GST

Tax type > State Tax

Ctrl + A

Create a Ledger for Profit

Gateway of Tally > Accounting Info > Create > Profit

Under> Indirect Income

Is GST Applicable? Applicable 

Set/ alter GST details? Yes

कभी कभी screen में HSN/SAC details नही मिलता तब F12 press करना

Allow HSN/SAC details? Yes

और 

Show all GST tax types? Yes 

करना

Description computer Profit 

Nature of Transaction Sales Taxable 

Tax Type

Integrated Tax 12%

Central Tax 6%

State Tax  6%

Ctrl + A

Type of supply Goods

Ctrl +A

Create a Ledger Purchase Nil

Gateway of Tally > Accounting Info > Create > Purchase nil

Under> Purchase Account

Inventory Values are affected? Yes

Is GST Applicable? Applicable 

Set/ alter GST details? Yes

कभी कभी screen में HSN/SAC details नही मिलता तब F12 press करना

Allow HSN/SAC details? Yes

और 

Show all GST tax types? Yes 

करना

Description Purchase Nil

Nature of Transaction Purchase Nil Rated

Tax Type

Integrated Tax 0%

Central Tax 0%

State Tax  0%

Ctrl + A

Type of supply Goods

Ctrl + A

Create a Ledger Sales

Gateway of Tally > Accounting Info > Create > Sales

Under> Account

Inventory Values are affected? Yes

Is GST Applicable? Applicable 

Set/ alter GST details? Yes

कभी कभी screen में HSN/SAC details नही मिलता तब F12 press करना

Allow HSN/SAC details? Yes

और 

Show all GST tax types? Yes 

करना

Description Sales 12%

Nature of Transaction Sales Taxable 

Tax Type

Integrated Tax 12%

Central Tax 6%

State Tax  6%

Ctrl + A

Type of supply Goods

Ctrl + A

Voucher Entry 

Gateway of Tally > Accounting Voucher > F9 Purchase ctrl + V 

हमेशा entry 1 July के बाद का date दे क्योंकि GST July से लागू हुआ है

Party name Consumer Sohan

Name of item 

Computer  1 pcs 15000

Profit 10%.            1500

Total                   16500 (automatic)

हमेशा entry 1 July के बाद का date दे क्योंकि GST July से लागू हुआ है

Gateway of Tally > Accounting Voucher > F8 Sales ctrl + V 

Party name Buyer Mohan 

Name of item 

Computer  1 pcs 16500

Enter

CGST                          990 (automatic)

SGST                          990 (automatic)

Total                         18480 (automatic)

अगर इसका print लेना है तब

Alt + p फिर mouse से right side menu में Alt + I को click करना तब preview दिखायेगा 

Details देखने के लिये 

Date को जरुर set कर ले Alt + F2

Gate way of Tally > Display > Day Book > Alt + F1 

Saturday, April 3, 2021

Creating Database file List Browse.....


 

Display, Locate ect Commands of Foxpro


 

Important Commands of Foxpro


 

Sort & Index Commands in Foxpro


 

Hyperlink Cross Reference and BookMark


 

Tricks & Tips for MS-Word


 

Goggle Form Questionnaire


 

Basic Commands of DOS Operating System


 

Fundamentals of Computer


 

Shortcut Keys for Power Point


 

Shortcut Keys For MS-Excel


 

Shortcut Keys for MS-Word


 

Types of Internet Services


 

Internet Connectivity


 

TCP/IP and OSI Model


 

Internet Terminology


 

Introduction of Internet


 

Computer Virus


 

Drop Down List in Excel


 

Payroll System in Tally


 

Memorandum Voucher in Tally


 

Scenario Management in Tally


 

Interest Calculation in Tally


 

Bank Reconciliation


 

Accounts and Inventory in Tally


 

Stock Entry in Tally


 

Company Creation with Voucher Entry


 

How to Create Ledger and Group


 

Tally Terminology


 

Budget in Tally


 

Export Import in Tally


 

Insert Check Marks in Excel




 

Number System


 

How to Create Macros in MS-Word


 

Logic Gates Part I


 

Logic Gate Part II


 

How to Create a Company


 

Create Form Through Developer


 

Birbal Ki Immandari


 

Theen Prashne


 

Patilae Ki Mrituu






 

Badshah Ka Adesh


 

Khush Kabari




 

Joru Ka Gulam


 

Akbar Ka Tota


 

Dudha Bhai


 

Mulla Do Payaja


 

Badshah Ka Sawal


 

Sabse Teja Chal

 


Chor ki Dadi Mai Tinka


 

Badshah Ka Adesh


 

Huzur ka Sevak


 

Char Bewakufa


 

Amir Garib


 

Kavi Ka Innam


 

Bansa Ka Tukada


 

Birbal Ka Guru


 

Theen Kahaniya


 

Badashah Ka Sapna


 

Malikana Hqua


 

Jaise Ko Taisa


 

Badashah ka Sala


 

Chamatkari Pade


 

Badshah ka Hukum


 

#Akbar #Birbal #Ki #Mulakat


 

#Pade #ki #Gawahi


 

Visual Basic .Net Programming

 Program 1 Sum of Two Numbers Form Design for Sum of Two Numbers Coding for OK Button Dim a, b, c as integer a=textbox1.text b=textbox2.text...