dear experts, in tally we face problem related to output taxes like cgst and sgst will not be equal in inclusive tax type. please suggest some solutions/ideas/suggestions for solving this problem. i am attaching data and screenshot of it.
Find the Field Name Where you want to Put Formula And Set a logical condition Example: Set as: If $LedgerName Contains "CGST" Then $$PrevObj:$Amount Else 0
First of all.. Please do let me know which country and what taxation method are you following ???? Is there 10% GST slab in India ??? IF 100/- is rate inclusive then without rate it would be 95.2381% and CGST and SGST would both be -- 2.380952% So --- 95.2381 + 2.380952 + 2.380952 will give you 100%. From where and how did you dreamed up your %age share ??? So in your case above....if 1500/- is inclusive then NETT -- 1428.571 CGST -- 35.71429 (2.5% of 1428.571) (reverse - 2.380952% of 1500/-) SGST -- 35.71429 (2.5% of 1428.571) (reverse - 2.380952% of 1500/-) TOTAL -- 1500/- ............ Please get your basic computing mechanics right first, before applying to real Tally data, else it becomes a problem to the data.
dear sir, in a hurry burry i just created a demo company for demonstration of problem but i could not sent original data as it is more than 600mb. instead of 12% ledger i put 5% leder and formula of 12%, i accept it but still problem is not solved. bcoz tally takes 4 decimal numbers in percantge field, so the difference in cgst and sgst arises. check my second post, i have put screenshot of original data. it is showing difference in each invoice.
First ... your demo data is internally corrupt.... so for R&D purpose make a new Company and check out your parameters there. Second... in Backward calculations, there always will be difference......... nearest right way is to have rounded off all the back calculations uniformly.... in duties ledgers as well as ledger allocations. Even then there will be difference, but few.
dear sir, can we modify 4 decimals to 7 decimals point. example 12% formula is 89.2857(as per tally field) if we modify 89.2857142 in percantage field. i think if we can modify this, we can achive desired results without tax difference
Yes, You can do this by the attribute "Format" at field Level But I think It will be always unequal So, The solution will be to copy the previous value Example [Field: NewField] Set as :$$Number:$BilledQty Or Set as: $$PrevObj:$Amount
You can have as many decimal as you want (works for display only) ............ the computations will be on 4 only..........
All in all.....Default ledger allocations is not useful for taxation purposes ....GST or TDS or whatever.....never works. If at all, such things were possible, then BOSSES would do on their own, there is no need for an Accountant. It seems, people are thinking --- that with TDL and other utilities they can do their work with a few clicks.............. this is erroneous thinking.
dear sir, This above issue was reported to tally solutions, They advice to go for customization. till now no body gave solutions.
very difficult for retail sales whose stock item is more than 2000 items. so only tally is not very much successful in retail shops category.
I already gave the Hint Sir... No one will give you complete solution Because This is a learning website..
dear sir, This is off the topic. but i have to share it here. third software like Pearl xp uses 10 decimals in their calculations which is not visible in voucher screen( but it shows 2 decimals at voucher screen). therefore the calculations is 100% correct. i Am attaching the screen shot of the exported data. please check it.
Thank u again for the reply. i will surely try, try, try till i get desired result. As i am a beginner i don't have any idea regarding the codes. but i will surely learn it with all the support in this forum.
Tally offers both ERP and POS software........... if your idea is to use POS/retail business, you should have gone for POS version. It is called Shoper 9. Please check the website. Download the same for free trial. There is simply no issue from Tally. ..... You are feeling so, since it is not suitable to your needs and requirements. Also as per business model, the data also has to be structured properly, to get proper results. Judging from the sample data you have sent, you have not even structured the Ledger A/cs and their settings properly. A complete guide or training on Tally is required for you to enable you to use all features properly.
pl read - 1- retail case/ wholesale case s not issue , issue is that owner wants to become data entry opretor. so he always have less time to post entry as counter is always running. 2-method u are using is not allowed as per GST rules. even if u do sales as per above , then is it showing GST sepreatly ? as per rules ? 3- if u use inclusive tax field, it must be ok. I have many clients of KIRANA , having 12500 + items, and even if they make sale of a choklate / egg / biscute then also doing entry. 4-Please put your enquiry in detail we can do TDL but, as AMIT KUMAR says , it will be as per rules or fundamentals of Tally. 5- even in regulor case ( inclusiv tax field enabled) take one item Sugar of 5% gst and put Qty as large = 5000 Kg , and see invoice will not match see image attached. so first understand fundas of any software , then choose correct one for your business , every software have + or - things. so insted of finguring software, let us discuss in detail 9764999865 or rbmithari@gmail.com
