Skip to Article Skip to Youtube

Submitting Purchases, Sales, and Returns Details to Commercial Tax in A.P.


This is the first step in the process of submitting the Monthly VAT Returns in Andhra Pradesh state Commercial Tax Department website. And this procedure is called as Invoice Tracking System and started in April 2015 and made it mandatory on June 2015 onwards in Andhra Pradesh state.

Submitting Purchases, Sales, and Returns Details to Commercial Tax in A.P.

In the Invoice Tracking System every VAT Dealer has to submit the Purchases, Sales, Purchase Returns and Sales Returns details electronically by logging into their VAT Dealer Account before they submit their monthly VAT Returns. Here Purchase details are called as Annexure I and Sales details are called as Annexure II. The VAT Dealer must keep the following points while preparing the Annexure I and Annexure II Excel Template files.

  1. The VAT Dealer has to submit the Purchases from VAT Dealers and the Sales made to the VAT Dealers within Andhra Pradesh state only.
  2. The VAT Dealer should not submit the Purchases from outside the Andhra Pradesh state and the Sales made to the outside the state.
  3. The VAT Dealer should not submit the Cash Sales and Cash Purchases
  4. The VAT Dealer should not submit the Purchase from TOT Dealers and Sales to TOT Dealers.

How to Download the Purchases, Sales, Purchase Returns and Sales Returns Excel Template files

The Commercial Tax Department has designed the Excel Template files for preparing the Purchases, Sales, Purchase Returns and Sales Returns details and every VAT Dealer has to fill the template files with the purchase, sales, and returns details. In the VAT Dealer account four different sets of Template Files will be available for Purchases, Sales, Purchase Return and Sales Returns.

In order to download the Excel Template Files login to your VAT Dealer account from AP Commercial tax e-Return portal.

  1. In the Home screen of the VAT Dealer Account click on Returns menu.
  2. In order to download the Annexure I Excel Template file click on Upload Purchase Details sub menu.
  3. And click on Download template for Purchases hyperlink and save the Purchases Excel Template file in your Computer System.
  4. In order to download the Annexure II Excel Template file click on Upload Sales Details sub menu and click on Download template for Sales hyperlink and save the Sales Excel Template file in your Computer System.
  5. For Purchase Returns and Sales Returns you will be having the sub menu available for the template files.

How to fill up the Purchases, Sales, Purchase Returns and Sales Returns Excel Template files

In order to fill up the Purchases details just open the Purchases Excel Template file downloaded from the e-Returns portal.

  1. Enter your TIN Number and Choose the month of VAT Return from the list of Months and enter the Year of the VAT Return.
  2. After that you have to record the Purchase details like TIN number of the seller, Invoice Number, Date of Invoice, amount of Invoice (Including VAT), Commodity, and VAT Tax percent.
  3. Provide the serial numbers starting from 1 and increase every record by 1.

So you have to provide the invoice details followed by a serial number. And for Sales, Purchase Returns and Sales Returns also you have to follow the same procedure but you have to open corresponding Excel Template files downloaded from the e-Returns portal.

How to upload the Purchases, Sales, Purchase Returns and Sales Returns details in VAT e-Returns Portal

After we have prepared the Purchases, Sales, Purchase Returns and Sales Returns Template files the VAT Dealer have to upload them from the VAT Dealer Account. In order to upload the Purchase details login to your VAT Dealer account from AP Commercial tax e-Return portal.

  1. In the Home screen of the VAT Dealer Account click on Returns menu.
  2. In order to upload Annexure I Excel Template file click on Upload Purchase Details sub menu.
  3. Click on Choose File button and select the prepared Purchases Excel Template file from your Computer.
  4. And click on Upload button and click on Yes button to submit the Purchase details.

Now you have uploaded the Purchases details in order to upload the Sales Template file

  1. In the Home screen of the VAT Dealer Account click on Returns menu.
  2. In order to upload Annexure II Excel Template file click on Upload Sales Details sub menu.
  3. Click on Choose File button and select the prepared Sales Excel Template file from your Computer.
  4. And click on Upload button and click on Yes button to submit the Sales details.

You can follow the same procedure for uploading the Purchase Returns and Sales Returns Template files but you have to choose the Upload Purchase Returns Details sub menu to upload the Purchase Returns Template File and Upload Sale Returns Details sub menu to upload the Sales Returns Template File under Returns menu. And the rest of the procedure is as same as in the case Purchase Uploading.

How to confirm the Purchases and Sales details in VAT e-Returns Portal

Now all the Purchases, Sales, Purchase Returns and Sales Returns details are uploaded and the next step is to confirm the uploaded details. In order to confirm the Purchases details login to your VAT Dealer account from AP Commercial tax e-Return portal.

  1. To confirm the uploaded Annexure I and Annexure II files click on Returns menu and choose the Confirm Invoice Details sub menu.
  2. In the Confirm Invoice Details screen select the month for which you are confirming the Annexure details and Choose Purchases for Invoice Type and click on Get Details button.
  3. If you find the List of Invoice details under Mismatch section rectify them before you confirm otherwise click on Confirm Invoice details button.

For the confirming the Sales also do the same procedure but choose the Sales under Invoice Type. Now both the Purchases and Sales details are confirmed. And this is the procedure of preparing and submitting the Invoice Details to the Commercial Tax Department in Andhra Pradesh State.

Labels:
is the founder of AccountsGuy.Net with the view of providing Accounting and Technical support using Accounting package Tally ERP 9, and Office Tools to the people. I write articles on Accounts, Blogging, Computer Operating, and technical issues and some of my experiences on them for students, beginners. Follow our Networks or sing-up for the email newsletter below for your daily dose of Tips and Tricks.
Subscribe To Newsletters

{ 30 Comments... read them below or add one }

stein said...

hello sir this venky from kakinada i am selling commidity to poultry
in sale details entering they ask tin number of purchaser but there is no tin number for poultry so how to upload sale details.

Venkkatesh K said...

If you are selling from other state you have tell the other state seller to enclosed a Letter Head along with their Waybill and Invoice that the customer does not have the TIN Number and he is the direct customer.

Unknown said...

Dear sir,
nice and very useful article,

I have a query ..we are not taking any ITC on purchase , then whether i need to enter and upload the all purchase details?
What is the procedure for filing VAT 200A and VAT return?

Venkkatesh K said...

If you do not have any VAT Purchases you do not need to upload the Purchase details. And you have to submit the VAT Form 200A based on your Transaction related to in the report.

Unknown said...

Dear Sir,
We are executing mechanical Contract works in Steel Plant. We are purchasing the Items with VAT and not selling the Items. However we are using those Items for Fabrication / Erection Works.
I have few queries on filing Return.

1. We have Purchased Items, so we will upload the Purchase details sheet
2. We are not selling the Items, but we are using the Items, so let us know whether we have to upload the sale details, if yes how can we prepare the sale details?
3. For our work, we are getting the service tax from our head contractor and we are paying that Service Tax Amount to Govt.
4. As we are already paying the service tax whether we can apply for the VAT refund of our Purchases?

So far as I can understand I should not pay both VAT & ST at a time. Please suggest otherwise.

Venkkatesh K said...

As you are the consumer of the Goods you do not need to upload the consignment in the Sales Details of the VAT Returns. As per now Service Tax is different and VAT is different untill the GST is come into effect. And you can not avail the input of the Goods untill you sale them. But for some Capital Goods you can avail off the Input Credit in the VAT.

srinivas said...

I am a VAT dealer running a retail pharmacy,no problem with purchase component,but I sell in retail manner medicines to patients who will not have TIN number ,then how to submit sales details in excel ?

Venkkatesh K said...

In Sales Annexure the VAT Dealer has to include only Sales to VAT Dealers and not Sales to Other than VAT Dealers.

satish goel said...

process of vat return of andhra predesh and Telangana is either same or different.

Venkkatesh K said...

The procedure of VAT Returns submission is different.

satish goel said...

Please make a video on telangana vat & cst return. If u do so It will help me very much Because I live in hyderabad so I need it.

Venkkatesh K said...

Mr. Satish Goel,

We are eager to share the knowledger as much as i can i have only AP VAT Dealer Login Details with me to demo. Right now i do not have any Telanga VAT Dealer Login Details to give a demo on it. If you need to have information it is really my pleasure.

So, mail me your VAT Dealer Login details to my mail id kshyam24@gmail.com and i assure you that it will not be used until unless your prier permission.

Divi Srinivas said...

SIR,
When uploading purchase details,I come across this problem..invoice has two items ,one item with 5% another item with 14.5%.in this scenario how to enter the amount and invoice number in the excel template,with out any problem for uploading

Venkkatesh K said...

Single Invoice having different set of Tax Rates is a common thing in practice.

For instance, Purchase Invoice No. 145 having the Total Amount of Rs. 1,45,820/-
in which 14.5% Tax Rate cost is 1,15,020/-
And 5% Tax Rate cost is 30,800/-

You can record this information in the Purchase Annexure Excel File to upload in the Commercial Tax e-Returns Portal.

You have to enter tow records one record for 14.5% Rs. 1,15,020/- and another record for 5% Rs. 30,800/-

And you will now record for Total Invoice Amount of Rs. 1,45,820/- in the Purchase Annexure.

It will not give any problem while uploading the Annexure file in the e-Returns Portal.

sridevisandhya nukala said...

Sir,
During the year 2015-16,we have uploaded sales details for september month but with wrong TIN NO:Hoew can we rectify the error?

Venkkatesh K said...

You can rectify the error by submitting the Revised VAT Returns with the 6 months of the return month. In your case the Last date for Revised Return for September month is March 31st 2016. So, you are note able revise your September month. So, My advise is to prepare a Request letter to the Concerned CTO by explaining the reason what mistake in September month VAT Returns and Uploads happened. Submit the Letter along with the September month Returns Copy and get the acknowledgement.

ANIL KUMAR said...

Hello sir, I'm Anil from vizag. I'm selling goods to both registered and unregistered dealers of AP but when I'm trying to file the returns it was not accepting the unregistered dealers because of lack of TIN no..so kindly suggest me how can I file the returns?

Venkkatesh K said...

You do not need to upload the Sales to Unregistered VAT Dealers in AP VAT Dealer e-Returns Portal.
For more information read this article: Submitting Purchases, Sales, and Returns Details to Commercial Tax in A.P.

Gayatri budha said...

hello sir i want to know how to modify/update the purchase details for the mismatch report

Ashok Kollagi. Kollagi. said...

Dear Sir
The invoice uploading and modifications upto March-2016 will be closed by 15-07-2016 from RETURNS menu. my problem is in the month of SEP-2015 and i have uploaded purchase details and sales details wrongly...so it is showing invoices are mismatch. now can i upload the same month details within the dead line..

Venkkatesh K said...

If there is any mistake found in the Invoices that you uploaded either of Purchase or Sales you can modify, delete, upload new Invoices for the period Jun-2015 to March-16.

Venkkatesh K said...

With the help of "Modify Invoice Details" sub menu under "Returns" menu you can modify/update or delete the invoices.

Venkata Suresh said...

Dear Sir,I'm a TOT dealer.In how many days i have to file e return after paying quarterly turnover tax in online?

Venkkatesh K said...

TOT Dealer must file a quarterly return and pay the tax due for each quarter ending June, September, December and March by the end of the following month.

For instance, June Quarter Returns to be submitted by the end of July month.

ajay parasa said...

hi venkatesh sir,
1.what is basic limit for tot and vat dealers for registration?
2.sir if mismatches in uploaded invoices.. is there any procedure if not rectified before 15th july??

Venkkatesh K said...

1. You can read about TOT & VAT Basics in this article What is TOT and how to apply for TOT Dealership?.
2. If mismatch is not rectified within the due date there is no other solution. All you have to explain the things and based on the explanation penalty and tax will be levied.

kotesh said...

Dear sir,
I have a construction site in Vijayawada. But due to Andhra Telangana division there is problem regarding TIN Number while selling flats. Can I change My TIN number??? If so What is the procedure for that purpose

Venkkatesh K said...

You can not change the TIN Number but you can cancel and re apply for fresh TIN in both the State. For more assistance contact me @ kshyam24@gmail.com.

Jitendar Kumar said...

Dear Mr. Venkatesh Said,
I request your expert advice on my issue.
1) I have purchased goods under AP Vat on VAT basis (VAT applicable is 5%) for which i have uploaded Purchase annexure.
2) I have those sold goods under CST Act to unregistered dealers without Form 'C' @5% for which i am not allowed to upload Sales Annexure since it is a Non-Annexure transaction.

My query is can i set off CST liability against Input VAT accrued in VAT purchase and also i want to know how to fill VAT200A in my case.

I observed that u have been replying to all queries sincerely hope that u will reply to my query too.

Venkkatesh K said...

Mr. Jitender Kumar,
Thanks for your appreciation regarding my reply to the readers and come to the point that the VAT Dealer can set off the CST Liability against the VAT Input Credit in Form VAT 200.

Post a Comment

How do you feel about this Blog Post.