Profile cover photo
Profile photo
Excel to Tally
222 followers -
Simple & easiest way to post data from Excel to Tally
Simple & easiest way to post data from Excel to Tally

222 followers
About
Posts

Post has attachment
Add a comment...

Post has attachment
Download Sample Data Formats for Excel to Tally Data Import Using with EazyAUTO4.

https://goo.gl/im4zo6
Add a comment...

Post has attachment
FMCG to Tally.ERP9 Data Conversion
Add a comment...

Post has attachment
Impression Systems Wishing you you all Merry Christmas.

http://www.exceltotally.in/
Photo
Add a comment...

Post has attachment
Add a comment...

Post has attachment
Tally.ERP9 GST Reports Errors & Solutions

Tally.ERP9 Accounting Software.

GST Reports
Incomplete/Mismatch In Information (to be resolved)

From Gateway of Tally.ERP9: -->>Display->> ->>Statutory Reports->>GST->>GSTR-1/GSTR-2 --------------------------------------------------------------------------------------------------------------------------
Error: 1
Tax rate/tax type note specified (A)

Error Screen Shot1 https://goo.gl/i6ZvZd

Error Screen Shot1 : https://goo.gl/i6ZvZd


Reason:
Tax rate not specified in stock item (or)
Tax Ledgers CGST & SGST Not configured correctly.
Solution: Alter Sales, CGST & SGST, Cess etc / Stock Items
Ledger Alteration [ From Gateway of Tally: ]
Accounts Info->>Ledgers->>Alter-->> Select Tax Ledger(s)
Ex. CGST->> Under->>Duties & Taxes->> Type of duty/Tax->GST->>Tax Type->> Central Tax. [ Do same changes for SGST="State Tax" ] & Accept ="Yes"
Stock Item Alteration [ From Gateway of Tally: ]
Inventory Info->>Stock Items->>Alter-Select Item and enter.
GST Applicable-->> Applicable
Set/alter GST Details-->>"Yes"
Colculation type-->> "On Value"
Taxability -->> "Taxable"
Ingratiated Tax-->> "Enter %"
Type of Supply-->>Goods
Yes

--------------------------------------------------------------------------------------------------------------------------
Error: 2
Tax rate/tax type note specified (B)

Screen Shot-1 https://goo.gl/i6ZvZd

Screen Shot-2 https://goo.gl/i6ZvZd

Screen Shot-3 https://goo.gl/i6ZvZd
[ Open Entry and check in buyer details, State and Place of Supply must be same as per Tally ]


Reason:
State name mismatched as per Tally.

Solution
Correct the state name and place of supply as per Tally. "Maharashtra"



--------------------------------------------------------------------------------------------------------------------------
Error: 3

Information required for generating table-wise details not proved.
Screen Shot1 https://goo.gl/i6ZvZd

Screen Shot2 https://goo.gl/i6ZvZd


Reason:
GSTIN/UIN is not invalid/ there is an mistake while entering GST Number.
State name Mismatched as per Tally


Solution:
Enter Correct/Actual GST Number. [You can validate number on "https://services.gst.gov.in/services/searchtp"]
Check for State Name.

--------------------------------------------------------------------------------------------------------------------------
Error: 4
Mismatch due to tax amount modified in voucher.
Screen Shot-1 : https://goo.gl/i6ZvZd

Screen Shot-2 : https://goo.gl/i6ZvZd


Reason:
Tax amount not entered correctly.
For Example of above screen shot-2, actual amount of CGST Rs.1,359/- & SGST Rs.1,359/, but entered as CGST Rs.1,340/ & SGST Rs.1,340/-
Solution:
Enter actual CGST/SGST tax value
For Example Taxable Amount of Rs.100/- & GST % 12.


Excel to Tally Import https://goo.gl/Daqtod download free trial
Add a comment...

Post has attachment

Post has attachment

Post has attachment
Shift to Tally.ERP9 for GST.
If you are using software other than Tally and want to transfer your all data into Tally.ERP9 for Accounting and GST compliances then it is possible to convert your all data into Tally.ERP9.

Download FREE TRIAL from : http://www.exceltotally.in/download.php?id=Auto4Setup #Tally #Tally.ERP #Tally.ERP9 #TallyforGST #Excel #Excelto #Exceltotally #toally #GST
Photo
Add a comment...

Post has attachment
Impression Systems Wishes You All A Very Happy Diwali!
#Diwali #HappyDiwali #HappyDeepavali
http://www.exceltotally.in
Animated Photo
Add a comment...
Wait while more posts are being loaded