While importing sales data via Excel template, party details (address, GST status) aren’t captured from master data, requiring manual updates in the template. Can this be resolved to pull details from master data for efficiency?

Sir, During the year 2023-24 the department raised a demand for wrong utilisation of input tax credit u/s 16(4) for the years 2017-18 and 2018-19.. The same was paid. However the challan used was ” any other payment” and not DRC 03. A letter was written 0n 27.09.23 giving all the details of the demand raised and the payments made with a request that the demand raised is nullified. For reasons best known to the officials, in spite of several visits and oral requests, nothing concrete was done except oral assurances. Now that the amensty scheme had come one more approach was made to the department. The present officer after much haggling says that there are several cases like this – using of wrong challans and the rectification cannot be done at the state level officers and it has to be done only at the central level and suggested that I raise a grievance ticket. I am not asking for the refund of the amount paid as I am aware no refund can be granted under the scheme announcd. Can any one help me under which head sub head the grievance letter is to be raised for matching the payments made and demand raised. Regards J R KOTA

FOR PETROL PUMP

I want to calculate cess @ 4 % & TCS @ 0.1 % on Total of Basic Value & Vat @ respective % , which type of Configuration required to match with Invoice Value in Tally Prime.

Right Now Cess & TCS is calculated on subtotal of Petrol & Diesel Taxable Value.

I’m seeking clarity on the applicability of GST for digital services purchased from international platforms (e.g., Envato) in USD. Should GST be charged on such cross-border transactions, and if so, under which section of the GST law is this governed? Additionally, are there any threshold exemptions or specific considerations for Indian businesses making such purchases?

Sir, when I am taking a print out of GSTR3B both the vch no and doc no are showing the same numbers, whereas for Document no it should be supplier’s invoice number. How to reslove the issue. pl kindly help

j r kota

Manually exporting GSTR1 report from tallyprime and selecting json export gives below response.

{"gstin":"XXXXXXXXXXXXXXXX","fp":"042024","b2b":[{"ctin":"XXXXXXXXXXXXXXXX","inv":[{"inum":"1","idt":"01-04-2024","val":1705,"pos":"29","rchrg":"N","inv_typ":"R","itms":[{"num":1,"itm_det":{"txval":500,"rt":5,"iamt":0,"camt":12.50,"samt":12.50,"csamt":0}},{"num":2,"itm_det":{"txval":1000,"rt":18,"iamt":0,"camt":90,"samt":90,"csamt":0}}]}]},{"ctin":"XXXXXXXXXXXXXXXX","inv":[{"inum":"4","idt":"03-04-2024","val":944,"pos":"29","rchrg":"N","inv_typ":"SEWP","itms":[{"num":1,"itm_det":{"txval":800,"rt":18,"iamt":144,"camt":0,"samt":0,"csamt":0}}]}]},{"ctin":"XXXXXXXXXXXXXXXX","inv":[{"inum":"5","idt":"03-04-2024","val":945,"pos":"27","rchrg":"N","inv_typ":"R","itms":[{"num":1,"itm_det":{"txval":900,"rt":5,"iamt":45,"camt":0,"samt":0,"csamt":0}}]}]}],"b2cl":[{"pos":"13","inv":[{"inum":"3","idt":"03-04-2024","val":413000,"itms":[{"num":1,"itm_det":{"rt":18,"txval":350000,"iamt":63000,"csamt":0}}]}]}],"b2cs":[{"typ":"OE","sply_ty":"INTER","rt":5,"pos":"27","txval":250,"iamt":12.50,"csamt":0},{"typ":"OE","sply_ty":"INTER","rt":18,"pos":"27","txval":500,"iamt":90,"csamt":0}],"cdnr":[{"ctin":"XXXXXXXXXXXXXXXX","nt":[{"val":590,"ntty":"C","nt_num":"1","nt_dt":"04-04-2024","pos":"29","rchrg":"N","inv_typ":"R","itms":[{"num":1,"itm_det":{"txval":500,"rt":18,"iamt":0,"camt":45,"samt":45,"csamt":0}}]}]},{"ctin":"XXXXXXXXXXXXXXXX","nt":[{"val":52.50,"ntty":"C","nt_num":"2","nt_dt":"04-04-2024","pos":"29","rchrg":"N","inv_typ":"SEWP","itms":[{"num":1,"itm_det":{"txval":50,"rt":5,"iamt":2.50,"camt":0,"samt":0,"csamt":0}}]}]}],"nil":{"inv":[{"sply_ty":"INTRAB2B","nil_amt":500,"expt_amt":1000,"ngsup_amt":0},{"sply_ty":"INTRAB2C","nil_amt":300,"expt_amt":200,"ngsup_amt":0},{"sply_ty":"INTRB2C","nil_amt":300,"expt_amt":450,"ngsup_amt":0}]},"hsn":{"data":[{"num":1,"hsn_sc":"0725","txval":1100,"iamt":0,"camt":0,"samt":0,"csamt":0,"desc":"","uqc":"NOS","qty":0,"rt":0},{"num":2,"hsn_sc":"0748","txval":1650,"iamt":0,"camt":0,"samt":0,"csamt":0,"desc":"","uqc":"NOS","qty":0,"rt":0},{"num":3,"hsn_sc":"0824","txval":351800,"iamt":63234,"camt":45,"samt":45,"csamt":0,"desc":"Notebook","uqc":"NOS","qty":0,"rt":18},{"num":4,"hsn_sc":"0935","txval":1600,"iamt":55,"camt":12.50,"samt":12.50,"csamt":0,"desc":"","uqc":"NOS","qty":0,"rt":5}]},"doc_issue":{"doc_det":[{"doc_num":1,"docs":[{"cancel":0,"from":"1","net_issue":8,"num":1,"to":"8","totnum":8}]},{"doc_num":5,"docs":[{"cancel":0,"from":"1","net_issue":2,"num":1,"to":"2","totnum":2}]}]}}

But when XML request is used to fetch the same i am getting below response.

XML request:
<ENVELOPE><HEADER><TALLYREQUEST>Export Data</TALLYREQUEST></HEADER><BODY><EXPORTDATA><REQUESTDESC><STATICVARIABLES><SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT><SVFROMDATE>20240401</SVFROMDATE><SVTODATE>20240430</SVTODATE></STATICVARIABLES><REPORTNAME>GSTR1 JsonExport</REPORTNAME></REQUESTDESC></EXPORTDATA></BODY></ENVELOPE>

XML response :
<GSTIN></GSTIN><FP>042024</FP><GT>0.00</GT><CUR_GT>0.00</CUR_GT><HSN><DATA><NUM>1</NUM><HSN_SC></HSN_SC><DESC></DESC><UQC></UQC><QTY>0</QTY><RT>18</RT><TXVAL>88800.00</TXVAL><IAMT>0.00</IAMT><CAMT>0.00</CAMT><SAMT>45.00</SAMT><CSAMT>0.00</CSAMT></DATA><DATA><NUM>2</NUM><HSN_SC></HSN_SC><DESC></DESC><UQC></UQC><QTY>0</QTY><RT>5</RT><TXVAL>1600.00</TXVAL><IAMT>0.00</IAMT><CAMT>0.00</CAMT><SAMT>12.50</SAMT><CSAMT>0.00</CSAMT></DATA><DATA><NUM>3</NUM><HSN_SC></HSN_SC><DESC></DESC><UQC></UQC><QTY>0</QTY><RT>0</RT><TXVAL>2050.00</TXVAL><IAMT>0.00</IAMT><CAMT>0.00</CAMT><SAMT>0.00</SAMT><CSAMT>0.00</CSAMT></DATA><DATA><NUM>4</NUM><HSN_SC></HSN_SC><DESC></DESC><UQC></UQC><QTY>0</QTY><RT>0</RT><TXVAL>1600.00</TXVAL><IAMT>0.00</IAMT><CAMT>0.00</CAMT><SAMT>0.00</SAMT><CSAMT>0.00</CSAMT></DATA><DATA><NUM>5</NUM><HSN_SC></HSN_SC><DESC></DESC><UQC></UQC><QTY>0</QTY><RT>0</RT><TXVAL>1700.00</TXVAL><IAMT>0.00</IAMT><CAMT>0.00</CAMT><SAMT>0.00</SAMT><CSAMT>0.00</CSAMT></DATA></HSN>

How to get Complete GSTR1 report response using a XML request?

How to restrict user from changing price during Recipte note (Goods receipt)

Hello, Tally CA Community…

Thanks for adding me here…

To start with I have one query. ….

When I am booking Item invoice, the GST Receivable is showing seperately in document properly. However, when I check Ledger posting after creation of document, I am finding that the GST Receivable amount is getting merged with Cost of Item and getting debited to Purchase Account.

How can I resolve this problem? Please help me.

Thanks..
Pramod Limaye