Commercial Taxes Department
Government of Karnataka

VAT e-Filing System

 

 

 

 

 

 

 

    -: XML File Format :-

 

 

 

 

 

Print Page

HOME     

 

 

 

 

 

 

File Format :-

 

 

 
  • Purchase Invoice Format: The XML file should contain the following details for each purchase invoice. However, the dealer has to submit the details of the purchase invoices in respect of which the dealer has claimed the input tax credit (ITC).

o    TIN

o    Period

o    Serial No

o    Seller’s TIN

o    Seller’s Name and Address

o    Invoice No

o    Invoice Date

o    Invoice Value (net of tax)

o    Tax Charged

 
  • Sales Invoice Format: The XML file should contain the following details for each taxable sale invoice.

o    TIN   

o    Period

o    Serial No

o    Buyer’s TIN

o    Buyer’s Name and Address

o    Invoice No

o    Invoice Date

o    Invoice Value (net of tax)

o    Tax Charged

 
  • Export Invoice Format: The XML file should contain the following details for each of the Export invoice.

o   TIN          

o   Period

o   Serial No

o   Invoice No

o   Invoice Date

o   Consignee Name and Address

o   Bill of Lading No

o   Bill of Lading Date

o   Carrier/Agent Name

o   Goods

o   Invoice Value (in Foreign Currency)

o   Invoice Value (in Rs.)

 

 

XML format for purchase and sale invoices with the field validation is provided in the Annexure – A (xsd form). The sample XML file is also given in Annexures – B1 & B2 for easier understanding.

 

 

 

Annexure – A:  XML Schema Formats

 

 

 

1. PURCHASE INVOICE FORMAT

 

<?xml version="1.0" encoding="utf-8" ?>

<xs:schema  elementFormDefault="qualified" xmlns:xs="http://www.w3.org/2001/XMLSchema">

<xs:element  name="PurchaseDetails" />

<xs:element  name="PurchaseInvoiceDetails">

<xs:complexType>

<xs:sequence>

<xs:element name="TinNo" type="TinNoType" />

<xs:element name="RetPerdEnd" type="RetPerdEndType" />

<xs:element name="Sno"  type="NoZeroType" />

<xs:element name="SelName"  type="SelNameType" />

<xs:element name="SelTin"  type="TinNoType" />

<xs:element name="InvNo"  type="InvNoType"  />

<xs:element name="InvDate"  type="xs:date" />

<xs:element name="NetVal" type="DecTyp" />

<xs:element name="TaxCh" type="DecTyp" />

</xs:sequence>

</xs:complexType>

</xs:element >

<xs:simpleType name="TinNoType">

<xs:restriction base="xs:integer">

<xs:pattern value="[2][9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]"/>

<xs:totalDigits value="11" />

</xs:restriction>

 </xs:simpleType>

<xs:simpleType name="RetPerdEndType"> 

<xs:restriction base="xs:integer">

<xs:pattern value="[2][0][0][6-9][0-1][0-9]"/> 

</xs:restriction>

</xs:simpleType>

<xs:simpleType name="RetTypes">

<xs:restriction base="xs:string">

<xs:enumeration value="O" />

<xs:enumeration value="R" />

<xs:pattern value="[OR]"/>

</xs:restriction>

</xs:simpleType>

<xs:simpleType name="NoZeroType">

<xs:restriction base="xs:integer">

<xs:minInclusive value="1" />

</xs:restriction>

</xs:simpleType>

<xs:simpleType name="DecTyp">

      <xs:restriction base="xs:decimal">

<xs:totalDigits value="15"/>

<xs:fractionDigits value="2"/>

</xs:restriction>

</xs:simpleType>

<xs:simpleType name="SelNameType">

<xs:restriction base="xs:string">

<xs:pattern value="[a-zA-Z0-9,\.\s]*"/>

<xs:minLength value="1" />

<xs:maxLength value="30" />

</xs:restriction>

</xs:simpleType>

<xs:simpleType name="InvNoType">

<xs:restriction base="xs:string">

<xs:pattern value="[a-zA-Z0-9]*"/>

<xs:minLength value="1" />

<xs:maxLength value="13" />

</xs:restriction>

</xs:simpleType>

</xs:schema>

 

 

2. SALE INVOICE FORMAT

<?xml version="1.0" encoding="utf-8" ?>

<xs:schema  elementFormDefault="qualified" xmlns:xs="http://www.w3.org/2001/XMLSchema">

<xs:element  name="SaleDetails" />

<xs:element  name="SalInv">

<xs:complexType>

<xs:sequence>

<xs:element name="TinNo" type="TinNoType" />

<xs:element name="RetPerdEnd" type="RetPerdEndType" />

<xs:element name="Sno"  type="NoZeroType" />

<xs:element name="BuyName"  type="SelNameType" />

<xs:element name="BuyTin"  type="TinNoType" />

<xs:element name="InvNo"  type="InvNoType"  />

<xs:element name="InvDate"  type="xs:date" />

<xs:element name="NetVal" type="TypDec" />

<xs:element name="TaxCh" type="TypDec" />

</xs:sequence>

</xs:complexType>

</xs:element >

<xs:simpleType name="TinNoType">

<xs:restriction base="xs:integer">

<xs:pattern value="[2][9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]"/>

<xs:totalDigits value="11" />

</xs:restriction>

 </xs:simpleType>

<xs:simpleType name="RetPerdEndType"> 

<xs:restriction base="xs:integer">

<xs:pattern value="[2][0][0][6-9][0-1][0-9]"/> 

</xs:restriction>

</xs:simpleType>

<xs:simpleType name="RetTypes">

<xs:restriction base="xs:string">

<xs:enumeration value="O" />

<xs:enumeration value="R" />

<xs:pattern value="[OR]"/>

</xs:restriction>

</xs:simpleType>

<xs:simpleType name="NoZeroType">

<xs:restriction base="xs:integer">

<xs:minInclusive value="1" />

</xs:restriction>

</xs:simpleType>

<xs:simpleType name="TypDec">

      <xs:restriction base="xs:decimal">

<xs:totalDigits value="15"/>

<xs:fractionDigits value="2"/>

</xs:restriction>

</xs:simpleType>

<xs:simpleType name="SelNameType">

<xs:restriction base="xs:string">

<xs:pattern value="[a-zA-Z0-9,\.\s]*"/>

<xs:minLength value="1" />

<xs:maxLength value="30" />

</xs:restriction>

</xs:simpleType>

<xs:simpleType name="InvNoType">

<xs:restriction base="xs:string">

<xs:pattern value="[a-zA-Z0-9]*"/>

<xs:minLength value="1" />

<xs:maxLength value="13" />

</xs:restriction>

</xs:simpleType>

</xs:schema>

 

 

3. STATUTORY FORMS FORMAT

 

<?xml version="1.0" encoding="utf-8" ?>

<xs:schema elementFormDefault="qualified" xmlns:xs="http://www.w3.org/2001/XMLSchema">

<xs:element name="StatutoryFormInvoices" />

<xs:element name="CST-forms">

<xs:complexType>

<xs:sequence>

<xs:element name="TinNo" type="TinNoType" />

<xs:element name="SFType" type="sftype" />

<xs:element name="Seriesno" type="seriesnotype" />

<xs:element name="Sno" type="serialnotype" />

<xs:element name="SBTin" type="TinNoType" />

<xs:element name="SBName" type="addresstype" />

<xs:element name="SBAddr" type="addresstype" />

<xs:element name="SBState" type="statetype" />

<xs:element name="UtilCat" type="catagoryype" />

<xs:element name="UtilType" type="Utilisationtype" />

<xs:element  name="InvoiceDetails" maxOccurs="unbounded" minOccurs="0">

<xs:complexType>

<xs:sequence>

<xs:element name="InvNo" type="InvoiceNoType" />

<xs:element name="InvDate" type="xs:date" />

<xs:element name="CommName" type="CstCommodity" />

<xs:element name="InvVal" type="type="DecTyp" " />

</xs:sequence>

</xs:complexType>

</xs:element>

</xs:sequence>

</xs:complexType>

</xs:element>

<xs:simpleType name="TinNoType">

<xs:restriction base="xs:integer">

<xs:minInclusive value="100000" />

<xs:maxInclusive value="99999999999" />

</xs:restriction>

</xs:simpleType>

<xs:simpleType name="sftype">

<xs:restriction base="xs:string">

<xs:maxLength value="2" />

<xs:minLength value="1" />

<xs:enumeration value="C" />

<xs:enumeration value="D" />

<xs:enumeration value="F" />

<xs:enumeration value="H" />

<xs:enumeration value="I" />

<xs:enumeration value="E1" />

<xs:enumeration value="E2" />

<xs:enumeration value="CR" />

</xs:restriction>

</xs:simpleType>

<xs:simpleType name="serialnotype">

<xs:restriction base="xs:integer">

<xs:minInclusive value="1" />

<xs:maxInclusive value="9999999999" />

</xs:restriction>

</xs:simpleType>

<xs:simpleType name="addresstype">

<xs:restriction base="xs:string">

<xs:pattern value="[a-zA-Z0-9,\.\s]*"/>

<xs:minLength value="6" />

<xs:maxLength value="40" />

</xs:restriction>

</xs:simpleType>

<xs:simpleType name="statetype">

<xs:restriction base="xs:integer">

<xs:minInclusive value="1" />

<xs:maxInclusive value="34" />

</xs:restriction>

</xs:simpleType>

<xs:simpleType name="seriesnotype">

<xs:restriction base="xs:string">

<xs:minLength value="1" />

<xs:maxLength value="10" />

</xs:restriction>

</xs:simpleType>

<xs:simpleType name="CstCommodity">

<xs:restriction base="xs:string">

<xs:maxLength value="40" />

</xs:restriction>

</xs:simpleType>

<xs:simpleType name="DecTyp">

<xs:restriction base="xs:decimal">

<xs:totalDigits value="15"/>

<xs:fractionDigits value="2"/>

</xs:restriction>

<xs:simpleType name="InvoiceNoType">

<xs:restriction base="xs:string">

<xs:pattern value="[a-zA-Z0-9]*"/>

<xs:minLength value="1" />

<xs:maxLength value="13" />

</xs:restriction>

</xs:simpleType>

<xs:simpleType name="Utilisationtype">

<xs:restriction base="xs:string">

<xs:enumeration value="U" />

<xs:enumeration value="L" />

<xs:enumeration value="D" />

<xs:enumeration value="O" />

<xs:enumeration value="C" />

</xs:restriction>

</xs:simpleType>

<xs:simpleType name="catagoryype">

<xs:restriction base="xs:string">

<xs:enumeration value="U" />

<xs:enumeration value="R" />

<xs:pattern value="[ UR ]" />

</xs:restriction>

</xs:simpleType>

</xs:schema>

 

 

4. EXPORT INVOICE FORMAT

 

<?xml version="1.0" encoding="utf-8"?>

<xs:schema elementFormDefault="qualified" xmlns:xs="http://www.w3.org/2001/XMLSchema">

  <xs:element name="ExportDetails" />

  <xs:element name="ExpDet">

    <xs:complexType>

      <xs:sequence>

        <xs:element name="Tin" type="TinNoType" />

        <xs:element name="RetPerd" type="RetPerdEndType" />

        <xs:element name="Sno" type="NoZeroType" />

        <xs:element name="InvNo" type="InvNoType" />

        <xs:element name="InvDt" type="xs:date" />

        <xs:element name="BilCNm" type="BilNameType" />

        <xs:element name="BolNo" type="InvNoType" />

        <xs:element name="BolDt" type="xs:date" />

        <xs:element name="CarrNm" type="CarrNameType" />

        <xs:element name="Goods" type="GoodsType" />

        <xs:element name="InvCur" type="InvCurType" />

        <xs:element name="InvRup" type="InvRpType">

        </xs:element>

      </xs:sequence>

    </xs:complexType>

  </xs:element>

  <xs:simpleType name="TinNoType">

    <xs:restriction base="xs:integer">

      <xs:pattern value="[2][9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]" />

      <xs:totalDigits value="11" />

    </xs:restriction>

  </xs:simpleType>

  <xs:simpleType name="RetPerdEndType">

    <xs:restriction base="xs:integer">

      <xs:pattern value="[2][0][0][6-9][0-1][0-9]" />

    </xs:restriction>

  </xs:simpleType>

  <xs:simpleType name="NoZeroType">

    <xs:restriction base="xs:integer">

      <xs:minInclusive value="1" />

    </xs:restriction>

  </xs:simpleType>

  <xs:simpleType name="InvNoType">

    <xs:restriction base="xs:string">

      <xs:pattern value="[a-zA-Z0-9]*" />

      <xs:minLength value="1" />

      <xs:maxLength value="13" />

    </xs:restriction>

  </xs:simpleType>

  <xs:simpleType name="BilNameType">

    <xs:restriction base="xs:string">

      <xs:pattern value="[a-zA-Z0-9,(\.\s)-]*" />

      <xs:whiteSpace value="preserve" />

      <xs:minLength value="1" />

      <xs:maxLength value="60" />

    </xs:restriction>

  </xs:simpleType>

  <xs:simpleType name="CarrNameType">

    <xs:restriction base="xs:string">

      <xs:pattern value="[a-zA-Z0-9,(\.\s)-]*" />

      <xs:whiteSpace value="preserve" />

      <xs:minLength value="1" />

      <xs:maxLength value="80" />

    </xs:restriction>

  </xs:simpleType>

  <xs:simpleType name="GoodsType">

    <xs:restriction base="xs:string">

      <xs:pattern value="[a-zA-Z0-9,(\.\s)-]*" />

      <xs:whiteSpace value="preserve" />

      <xs:minLength value="1" />

      <xs:maxLength value="40" />

    </xs:restriction>

  </xs:simpleType>

  <xs:simpleType name="InvCurType">

    <xs:restriction base="xs:string">

      <xs:pattern value="[a-zA-Z0-9\s]*" />

      <xs:whiteSpace value="preserve" />

      <xs:minLength value="1" />

      <xs:maxLength value="20" />

    </xs:restriction>

  </xs:simpleType>

  <xs:simpleType name="InvRpType">

    <xs:restriction base="xs:decimal">

      <xs:totalDigits value="15" />

      <xs:fractionDigits value="2" />

    </xs:restriction>

  </xs:simpleType>

</xs:schema>

 

 

 

 

 

 

 

Annexure – B1:  Sample Purchase Invoice XML  File

 

<?xml version="1.0" encoding="utf-8" ?> 
    <PurchaseDetails>
       <PurchaseInvoiceDetails>
          <TinNo>29780319392</TinNo> 
          <RetPerdEndEnd>200608</RetPerdEnd> 
          <Sno>1</Sno> 
          <SelName>Alembic Ltd Bangalore</SelName> 
          <SelTin>29040098930</SelTin> 
          <InvNo>DB1235</InvNo> 
          <InvDate>2006-08-01</InvDate> 
          <NetVal>-100000</NetVal> 
          <TaxCh>-12500</TaxCh> 
     </PurchaseInvoiceDetails>
     <PurchaseInvoiceDetails>
       <Tin>29780319392</Tin> 
          <RetPerdEnd>200608</RetPerdEnd> 
          <Sno>2</Sno> 
          <SelName>3D Product Dev Ltd Bangalore</SelName> 
          <SelTin>29280105976</SelTin> 
          <InvNo>DB126</InvNo> 
          <InvDate>2006-08-10</InvDate> 
          <NetVal>-150000</NetVal> 
          <TaxCh>0</TaxCh> 
     </PurchaseInvoiceDetails>
     <PurchaseInvoiceDetails>
         <Tin>29780319392</Tin> 
         <RetPerdEnd>200608</RetPerdEnd> 
         <Sno>3</Sno> 
         <SelName>Alembic Ltd Bangalore</SelName> 
         <SelTin>29040098930</SelTin> 
         <InvNo>1556</InvNo> 
         <InvDate>2006-08-10</InvDate> 
         <NetVal>200000.95</NetVal> 
         <TaxCh>25000.45</TaxCh> 
     </PurchaseInvoiceDetails>
  </PurchaseDetails>

 

 

 

Annexure – B2:  Sample Sales Invoice XML  File

 

 

 

<?xml version="1.0" encoding="utf-8" ?> 
  <SaleDetails>
     <SaleInvoiceDetails>
          <Tin>29280105976</Tin> 
          <RetPerdEnd>200611</RetPerdEnd> 
          <Sno>1</Sno> 
          <BuyName>Rajalaxmi Enterprises Tumkur</BuyName> 
          <BuyTin>29750098588</BuyTin> 
          <InvNo>CR10235</InvNo> 
          <InvDate>2006-11-01</InvDate> 
          <NetVal>-10000</NetVal> 
          <TaxCh>-1250</TaxCh> 
     </SaleInvoiceDetails>
     <SaleInvoiceDetails>
          <Tin>29280105976</Tin> 
          <RetPerdEnd>200611</RetPerdEnd> 
          <Sno>2</Sno> 
          <BuyName>Ramesh Brothers and Co Bangalore</BuyName> 
          <BuyTin>29590490168</BuyTin> 
          <InvNo>CR10236</InvNo> 
          <InvDate>2006-11-02</InvDate> 
          <NetVal>-1500.01</NetVal> 
          <TaxCh>0</TaxCh> 
     </SaleInvoiceDetails>
     <SaleInvoiceDetails>
          <Tin>29280105976</Tin> 
          <RetPerdEnd>200611</RetPerdEnd> 
          <Sno>3</Sno> 
          <BuyName>Sri Pharma Ltd Bangalore</BuyName> 
          <BuyTin>29220054308</BuyTin> 
          <InvNo>10237</InvNo> 
          <InvDate>2006-11-04</InvDate> 
          <NetVal>200.45</NetVal> 
          <TaxCh>80.1</TaxCh> 
     </SaleInvoiceDetails>
  </SaleDetails>

 

 

 

Annexure – B3:  Sample SF Invoice XML  File

 

<? xml version="1.0" encoding="utf-8" ?> 

    <StatutoryFormInvoices>

        <CST-forms>

             <TinNo>29240114049</TinNo>

             <SFType>C</SFType>

             <Seriesno>10000</Seriesno>

             <Sno>12000</Sno>

             <SBTin>29480132832</SBTin>

             <SBName>SAI Traders</SBName>

             <SBAddr>Bangalore</SBAddr>

             <SBState>29</SBState>

             <UtilCat>U</UtilCat>

             <UtilType>U</UtilType>

            <InvoiceDetails>

                        <InvNo>1</InvNo>

                        <InvDate>2007-11-23</InvDate>

                        <CommName>comm</CommName>

                        <InvVal>2000</InvVal>

            </InvoiceDetails>

            <InvoiceDetails>

                        <InvNo>2</InvNo>

                        <InvDate>2007-11-21</InvDate>

                        <CommName>comm</CommName>

                        <InvVal>1000</InvVal>

            </InvoiceDetails>

        </CST-forms>

        <CST-forms>

             <TinNo>29240114050</TinNo>

            <SFType>C</SFType>

            <Seriesno>120000</Seriesno>

            <Sno>140000</Sno>

            <SBTin>29480132823</SBTin>

            <SBName>Ramanuja Traders</SBName>

            <SBAddr>Bangalore</SBAddr>

            <SBState>29</SBState>

            <UtilCat>U</UtilCat>

            <UtilType>U</UtilType>

            <InvoiceDetails>

                        <InvNo>1</InvNo>

                        <InvDate>2007-11-23</InvDate>

                        <CommName>comm</CommName>

                        <InvVal>2000.56</InvVal>

            </InvoiceDetails>

            <InvoiceDetails>

                        <InvNo>2</InvNo>

                        <InvDate>2007-11-21</InvDate>

                        <CommName>comm</CommName>

                        <InvVal>1000.23</InvVal>

            </InvoiceDetails>

            </CST-forms>              

</StatutoryFormInvoices>

                                                             

 

 

 

Annexure – B4:  Sample Export Invoice XML File

 

<?xml version="1.0"?>

<ExportDetails>

            <ExpDet>

                        <Tin>29150385359</Tin>

                        <RetPerd>200712</RetPerd>

                        <Sno>1</Sno>

                        <InvNo>682699497</InvNo>

                        <InvDt>2007-12-02</InvDt>

                        <BilCNm>MAYA HARDWARE    ELECTRICA</BilCNm>

                        <BolNo>29040351518</BolNo>

                        <BolDt>2007-12-05</BolDt>

                        <CarrNm>ConsNameType</CarrNm>

                        <Goods>Cement and Other articles </Goods>

                        <InvCur>54834</InvCur>

                        <InvRup>6854</InvRup>

            </ExpDet>

            <ExpDet>

                        <Tin>29150385359</Tin>

                        <RetPerd>200712</RetPerd>

                        <Sno>2</Sno>

                        <InvNo>682699498</InvNo>

                        <InvDt>2007-12-01</InvDt>

                        <BilCNm>BHAVANI HARDWARE    ELECTR</BilCNm>

                        <BolNo>29150720785</BolNo>

                        <BolDt>2007-12-02</BolDt>

                        <CarrNm>ConsNameType</CarrNm>

                        <Goods>Cement - Miscel</Goods>

                        <InvCur>12231</InvCur>

                        <InvRup>1529</InvRup>

            </ExpDet>

            <ExpDet>

                        <Tin>29150385359</Tin>

                        <RetPerd>200712</RetPerd>

                        <Sno>3</Sno>

                        <InvNo>682699499</InvNo>

                        <InvDt>2007-12-01</InvDt>

                        <BilCNm>MANJUSHREE GLASS    PLYWOO</BilCNm>

                        <BolNo>29910069206</BolNo>

                        <BolDt>2007-12-04</BolDt>

                        <CarrNm>ConsNameType</CarrNm>

                        <Goods>Cement - Miscel</Goods>

                        <InvCur>23176</InvCur>

                        <InvRup>2897</InvRup>

            </ExpDet>

</ExportDetails>

 

 

 

Top

 

 

 

Instructions

Tips

 

HOME