<?php 
session_start();
ob_start(); 
include "header.php";
//$objIms->Semifinisheditem_alter();

?>






		 <style>
			select.error { background-color:#ffa8a8; border: 1px dotted red;  }
			input.error{ background-color:#ffa8a8;   }
			textarea.error{ background-color:#ffa8a8; border: 1px dotted red;  }
         </style>
		 
        


<style type="text/css">
<!--
.table_bg{ border:#CCCCCC solid 1px; border-radius:5px; height:auto; width:auto; padding:20px; margin-bottom:10px;}


-->
</style>

<script type="text/javascript">

 
 
function printDiv(divName) {
     var printContents = document.getElementById(divName).innerHTML;
     var originalContents = document.body.innerHTML;

     document.body.innerHTML = printContents;

     window.print();

     document.body.innerHTML = originalContents;
}


</script>
	
<!-- Page wrapper  -->
        <div class="page-wrapper">
         
            <!-- Container fluid  -->
            <div class="container-fluid">
                <!-- Start Page Content -->
                <div class="row">
                    <div class="col-12">
                        <div class="card">
                            <div class="card-body">
							
							<h3>GST BB Report</h3>
							<hr />
<form name="form1" id="form1" method="post">
  <table id="example23" class="display nowrap table table-hover table-striped table-bordered" cellspacing="0" width="100%">
  <tr>
  <td width="24%"><div align="">Month</div></td>
      <td width="12%">
	    <div align="center">
	      <select name="month" id="month"  class="required form-control">
	        <option value="" style="display:none">-Select-</option>
	        <option value="01" <?php if($_POST["month"]=='01'){ ?> selected="selected" <?php }?>>Jan</option>
			<option value="02" <?php if($_POST["month"]=='02'){ ?> selected="selected" <?php }?>>Feb</option>
			<option value="03" <?php if($_POST["month"]=='03'){ ?> selected="selected" <?php }?>>Mar</option>
			<option value="04" <?php if($_POST["month"]=='04'){ ?> selected="selected" <?php }?>>Apr</option>
			<option value="05" <?php if($_POST["month"]=='05'){ ?> selected="selected" <?php }?>>May</option>
			<option value="06" <?php if($_POST["month"]=='06'){ ?> selected="selected" <?php }?>>Jun</option>
			<option value="07" <?php if($_POST["month"]=='07'){ ?> selected="selected" <?php }?>>Jul</option>
			<option value="08" <?php if($_POST["month"]=='08'){ ?> selected="selected" <?php }?>>Aug</option>
			<option value="09" <?php if($_POST["month"]=='09'){ ?> selected="selected" <?php }?>>Sept</option>
			<option value="10" <?php if($_POST["month"]=='10'){ ?> selected="selected" <?php }?>>Oct</option>
			<option value="11" <?php if($_POST["month"]=='11'){ ?> selected="selected" <?php }?>>Nov</option>
	      	<option value="12" <?php if($_POST["month"]=='12'){ ?> selected="selected" <?php }?>>Dec</option>
            </select>
        </div></td>
		<td width="7%"><div align="">Year</div></td>
      <td width="8%">
	    <div align="center">
	      <select name="yyear" id="yyear" class="required form-control">
	        <option value="" style="display:none">-Select-</option>
			<?php for($yy=2017;$yy<=date('Y');$yy++)
			{?>
	        <option value="<?=$yy?>" <?php if($_POST["yyear"]==$yy){ ?> selected="selected" <?php }?>><?=$yy?></option>	
			<?php }?>		
            </select>
        </div></td>
	<td width="49%"><input type="submit" name="Search" value="Search" class="btn btn-info" /></td>
	</tr>
  </table>
  
</form>
<br />

<?php 
if(isset($_POST["Search"]))
{
//$s_date=$objIms->DateToInt($_POST["s_date"]);
$mm=$_POST["month"];
$yy=$_POST["yyear"];

$s_date=$objIms->DateToInt('01-'.$mm.'-'.$yy);
$end_date=$objIms->DateToInt(date("t-m-Y",$objIms->DateToInt('01-'.$mm.'-'.$yy)));
 $month=date("F",$s_date);	
 ?>
 <input type="hidden" name="rahul" id="rahul" value="<?='3-B for '.$month.' '.$yy?>" /> 
<?php 				
							$sql_viewtmp="select salesmas_id,sum((qty*unit_price)-(qty*unit_price*(discount/100))) as taxvalue,cgst,sgst from view_sales_mstrdet where stampdate>='$s_date' and stampdate<='$end_date' and cancel_status=0 and cgst>0 and session_login_id = '".$_SESSION['login_id']."' group by salesmas_id,cgst,sgst";
							$res_viewtmp=mysql_query($sql_viewtmp);
							$saletaxval=0;
							$salecgst=0;
							$salesgst=0;
							while($rws=mysql_fetch_array($res_viewtmp))
							{
							$salesmas_id=$rws["salesmas_id"];
							$sql_viewret="select sum((ret_qty*sell_price)-(ret_qty*sell_price*(discount/100))) as taxvalue from view_saleret_masdet where return_date>='$s_date' and return_date<='$end_date' and salesmas_id='$salesmas_id' and session_login_id = '".$_SESSION['login_id']."'";
							$res_viewret=mysql_query($sql_viewret);
							$rwsret=mysql_fetch_array($res_viewret);
							if($rwsret["taxvalue"]<>''){$sretval=$rwsret["taxvalue"];}else{$sretval=0;}
							if($rws["taxvalue"]<>''){$sval=$rws["taxvalue"];}else{$sval=0;}
							$saletaxval+=$sval-$sretval;
							$scgst=($rws["cgst"]/100)*($sval-$sretval);$salecgst+=$scgst;
							$ssgst=($rws["sgst"]/100)*($sval-$sretval); $salesgst+=$ssgst;
							
							}
							
							
							
							
							$sql_intertmp="select sum((qty*unit_price)-(qty*unit_price*(discount/100))) as taxvalue,igst from view_sales_mstrdet where stampdate>='$s_date' and stampdate<='$end_date' and cancel_status=0 and igst>0 and session_login_id = '".$_SESSION['login_id']."' group by igst";
							$res_intertmp=mysql_query($sql_intertmp);
							$saletaxvalinter=0;
							$saleigstinter=0;
							while($rwsinter=mysql_fetch_array($res_intertmp))
							{
							if($rwsinter["taxvalue"]<>''){$svalinter=$rwsinter["taxvalue"];}else{$svalinter=0;}$saletaxvalinter+=$svalinter;
							$sigstinter=($rwsinter["igst"]/100)*$svalinter;$saleigstinter+=$sigstinter;
							}
							
							 $sql_viewpur="select sum((pur_qty*pur_price)-(pur_qty*pur_price*(discount/100))) as taxvalue,cgst,sgst from view_pur_masdet where purchase_date>='$s_date' and purchase_date<='$end_date' and cgst>0 and session_login_id = '".$_SESSION['login_id']."' group by cgst,sgst";
							$res_viewpur=mysql_query($sql_viewpur);
							$rwspur=mysql_fetch_array($res_viewpur);
							if($rwspur["taxvalue"]<>''){$purtaxval=$rwspur["taxvalue"];}else{$purtaxval=0;}
							$purcgst=($rwspur["cgst"]/100)*$purtaxval;
							$pursgst=($rwspur["sgst"]/100)*$purtaxval;
							
							
							$sql_viewpur_z="select sum((pur_qty*pur_price)-(pur_qty*pur_price*(discount/100))) as taxvalue_z from view_pur_masdet where session_login_id = '".$_SESSION['login_id']."' and purchase_date>='$s_date' and purchase_date<='$end_date'  and purmas_id in (select id from tbl_purchase_master where tax_type = 'Tax Exempted' and session_login_id = '".$_SESSION['login_id']."')";
							$res_viewpur_z=mysql_query($sql_viewpur_z);
							$rwspur_z=mysql_fetch_array($res_viewpur_z);
							if($rwspur_z["taxvalue_z"]<>''){$purtaxval_z=$rwspur_z["taxvalue_z"];}else{$purtaxval_z=0;}
							$purcgst_z=0;
							$pursgst_z=0;
							$purigst_z=0;
							
							$sql_viewpur_null="select sum((pur_qty*pur_price)-(pur_qty*pur_price*(discount/100))) as taxvalue_null from view_pur_masdet where session_login_id = '".$_SESSION['login_id']."' and purchase_date>='$s_date' and purchase_date<='$end_date'  and purmas_id in (select id from tbl_purchase_master where tax_type = 'Tax' and session_login_id = '".$_SESSION['login_id']."') and cgst ='0'  and sgst ='0'  and igst ='0' ";
							$res_viewpur_null=mysql_query($sql_viewpur_null);
							$rwspur_null=mysql_fetch_array($res_viewpur_null);
							if($rwspur_null["taxvalue_null"]<>''){$purtaxval_null=$rwspur_null["taxvalue_null"];}else{$purtaxval_null=0;}
							
							
							
							$sql_interpur="select sum((pur_qty*pur_price)-(pur_qty*pur_price*(discount/100))) as taxvalue,igst from view_pur_masdet where purchase_date>='$s_date' and purchase_date<='$end_date' and igst>0 and session_login_id = '".$_SESSION['login_id']."' group by igst";
							$res_interpur=mysql_query($sql_interpur);
							$rwsinterpur=mysql_fetch_array($res_interpur);
							if($rwsinterpur["taxvalue"]<>''){$purtaxvalinter=$rwsinterpur["taxvalue"];}else{$purtaxvalinter=0;}
							$purigstinter=($rwsinterpur["igst"]/100)*$purtaxvalinter;
							

?>
     
            
		
					<div id="table_wrapper">
					<div id="printableArea">
					<div class="panel">
					<div class="panel-heading">GSTR1 3-B Report For <?php echo $month;?> <?php echo $_POST["yyear"];?></div>
					<p>&nbsp;</p>
                   <!--  <table width="100%" border="0">
  <tr>
    <td width="23%"><strong>Sale Summary(Intra State) :- </strong></td>
    <td width="11%">&nbsp;</td>
    <td width="22%"><strong>Sale Summary(Inter State) :- </strong></td>
    <td width="13%">&nbsp;</td>
    <td width="20%"><strong>Total Sale Summary :- </strong></td>
    <td width="11%">&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>Taxable Value : </td>
    <td><?=round($saletaxval,2)?></td>
    <td>Taxable Value : </td>
    <td><?=round($saletaxvalinter,2)?></td>
    <td>Total Taxable Value : </td>
    <td><?=round(($saletaxval+$saletaxvalinter),2)?></td>
  </tr>
  <tr>
    <td>Central Tax : </td>
    <td><?=round($salecgst,2)?></td>
    <td>Integrated Tax : </td>
    <td><?=round($saleigstinter,2)?></td>
    <td>Central Tax :</td>
    <td><?=round($salecgst,2)?></td>
  </tr>
  <tr>
    <td>State Tax : </td>
    <td><?=round($salesgst,2)?></td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>State Tax :</td>
    <td><?=round($salesgst,2)?></td>
  </tr>
  <tr>
    <td>Cess : </td>
    <td><?=0?></td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>Integrated Tax :</td>
    <td><?=round($saleigstinter,2)?></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>Cess :</td>
    <td><?=0?></td>
  </tr>
  <tr>
    <td><strong>Sales Return Summary(Intra State) :- </strong></td>
    <td>&nbsp;</td>
    <td><strong>Sales Return Summary(Inter State) :- </strong></td>
    <td>&nbsp;</td>
    <td><strong>Total Sales Return Summary :- </strong></td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>Taxable Value : </td>
    <td><?=0?></td>
    <td>Taxable Value : </td>
    <td><?=0?></td>
    <td>Total Taxable Value : </td>
    <td><?=0?></td>
  </tr>
  <tr>
    <td>Central Tax : </td>
    <td><?=0?></td>
    <td>Integrated Tax : </td>
    <td><?=0?></td>
    <td>Central Tax :</td>
    <td><?=0?></td>
  </tr>
  <tr>
    <td>State Tax : </td>
    <td><?=0?></td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>State Tax :</td>
    <td><?=0?></td>
  </tr>
  <tr>
    <td>Cess : </td>
    <td><?=0?></td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>Integrated Tax :</td>
    <td><?=0?></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>Cess :</td>
    <td><?=0?></td>
  </tr>
  <tr>
    <td><strong>Purchase Summary(Intra State) :- </strong></td>
    <td>&nbsp;</td>
    <td><strong>Purchase Summary(Inter State) :-</strong></td>
    <td>&nbsp;</td>
    <td><strong>Total Purchase Summary :-</strong></td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>Taxable Value : </td>
    <td><?=round($purtaxval,2)?></td>
    <td>Taxable Value : </td>
    <td><?=round($purtaxvalinter,2)?></td>
    <td>Total Taxable Value : </td>
    <td><?=round(($purtaxval+$purtaxvalinter),2)?></td>
  </tr>
  <tr>
    <td>Central Tax : </td>
    <td><?=round($purcgst,2)?></td>
    <td>Integrated Tax : </td>
    <td><?=round($purigstinter,2)?></td>
    <td>Central Tax :</td>
    <td><?=round($purcgst,2)?></td>
  </tr>
  <tr>
    <td>State Tax : </td>
    <td><?=round($pursgst,2)?></td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>State Tax :</td>
    <td><?=round($pursgst,2)?></td>
  </tr>
  <tr>
    <td>Cess : </td>
    <td><?=0?></td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>Integrated Tax :</td>
    <td><?=round($purigstinter,2)?></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>Cess :</td>
    <td><?=0?></td>
  </tr>
  
  <tr>
    <td><strong>Purchase Return Summary(Intra State) :- </strong></td>
    <td>&nbsp;</td>
    <td><strong>Purchase Return Summary(Inter State) :- </strong></td>
    <td>&nbsp;</td>
    <td><strong>Total Purchase Return Summary :- </strong></td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>Taxable Value : </td>
    <td><?=0?></td>
    <td>Taxable Value : </td>
    <td><?=0?></td>
    <td>Total Taxable Value : </td>
    <td><?=0?></td>
  </tr>
  <tr>
    <td>Central Tax : </td>
    <td><?=0?></td>
    <td>Integrated Tax : </td>
    <td><?=0?></td>
    <td>Central Tax :</td>
    <td><?=0?></td>
  </tr>
  <tr>
    <td>State Tax : </td>
    <td><?=0?></td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>State Tax :</td>
    <td><?=0?></td>
  </tr>
  <tr>
    <td>Cess : </td>
    <td><?=0?></td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>Integrated Tax :</td>
    <td><?=0?></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>Cess :</td>
    <td><?=0?></td>
  </tr>
</table>-->


<div class="pr" id="" style="" >
  <h3 style="color:#000000" align="center"><b>FORMGSTR-3B</b></h3>
  <div class="row">
  <div class="col-md-4"></div>
   <div class="col-md-4"></div>
    <div class="col-md-4">
	<table width="100%" id="exldiv">
	<table width="100%" class="table" border="1px">
	<tr>
	<td>YEAR</td>
	<td><?php echo $_POST["yyear"];?></td>
	</tr>
	<tr>
	<td>MONTH</td>
	<td><?php echo $month;?></td>
	</tr>
	</table>
	</div>
  </div>
  
  <table width="100%" class="table" border="1px">
	<tr>
	<td>1</td>
	<td>GSTIN</td>
	<td><?php echo strtoupper($_SESSION['gstin']);?></td>
	</tr>
	<tr>
	<td>2</td>
	<td>Legal name of the registered person</td>
	<td><?php echo strtoupper($_SESSION['name']);?></td>
	</tr>
	</table>
 <p><b>3.1	Details of OutwardSupplies and inwardsupplies liable to reversecharge</b></p>
 <table width="100%" class="table" border="1px">
	<tr>
	<th>Nature of Supplies</th>
	<th>Total TaxableValue</th>
	<th>Integrated Tax</th>
	<th>Central Tax</th>
	<th>State/UT Tax</th>
	<th>Cess</th>
	
	</tr>
	<tr>
	<th>1</th>
	<th>2</th>
	<th>3</th>
	<th>4</th>
	<th>5</th>
	<th>6</th>
	
	</tr>
	
	<tr>
	<td>(a) Outward taxable supplies (other than zero rated, nil rated and exempted)</td>
	<td><?php echo round(($saletaxval+$saletaxvalinter),2);?></td>
	<td><?php echo $saleigstinter;?></td>
	<td><?php echo $salecgst;?></td>
	<td><?php echo $salesgst;?></td>
	<td></td>
	</tr>
	
	<tr>
	<td>(b) Outward taxable supplies (zero rated)</td>
	<td><?php echo round($purtaxval_null,2);?></td>
	<td>0</td>
	<td>0</td>
	<td>0</td>
	<td>0</td>
	</tr>
	
	<tr>
	<td>(c) Other Outward supplies (Nil rated, exempted)</td>
	
	
	<td><?php echo round($purtaxval_z,2); ?></td>
	<td>0</td>
	<td>0</td>
	<td>0</td>
	<td>0</td>
	</tr>
	<tr>
	<td>(d) Inward supplies (liable to reverse charge)</td>
	<td></td>
	<td></td>
	<td></td>
	<td></td>
	<td></td>
	</tr>
	<tr>
	<td>(e) Non-GST outward supplies</td>
	<td></td>
	<td></td>
	<td></td>
	<td></td>
	<td></td>
	</tr>
	</table>
 <p><b>3.2	Of thesupplies shown in3.1(a)above, details ofinter-State suppliesmade to unregistered persons, composition taxablepersonsand UINholders</b></p>
 
  <table width="100%" class="table" border="1px">
	<tr>
	<th></th>
	<th>Place ofSupply (State/UT)</th>
	<th>Total Taxable Value</th>
	<th>Amount of Integrated Tax</th>
	
	</tr>
	<tr>
	<th>1</th>
	<th>2</th>
	<th>3</th>
	<th>4</th>
	
	
	</tr>
	
	</table>
	<p><b>4. Eligible ITC</b></p>
	<table width="100%" class="table" border="1px">
	<tr>
	<th>Details</th>
	<th>Integrated Tax</th>
	<th>Central Tax</th>
	<th>State/UT Tax</th>
	<th>Cess</th>
	
	</tr>
	<tr>
	<th>1</th>
	<th>2</th>
	<th>3</th>
	<th>4</th>
	<th>5</th>
	
	
	</tr>
	<tr>
	<td>(A) ITC Available (whether in full or part)</td>
	<td></td>
	<td></td>
	<td></td>
	<td></td>
	</tr>
	
	<tr>
	<td align="center">(1)	Import of goods</td>
	<td></td>
	<td></td>
	<td></td>
	<td></td>
	</tr>
	<tr>
	<td align="center">(2)	Import of services</td>
	<td></td>
	<td></td>
	<td></td>
	<td></td>
	</tr>
	<tr>
	<td align="center">(3)	Inward supplies liable to reverse charge (other than 1 & 2 above)</td>
	<td></td>
	<td></td>
	<td></td>
	<td></td>
	</tr>
	<tr>
	<td align="center">(4)	Inward supplies from ISD</td>
	<td></td>
	<td></td>
	<td></td>
	<td></td>
	</tr>
	<tr>
	<td align="center">(5)	All other ITC</td>
	<td><?=round($purigstinter,2)?></td>
	<td><?=round($purcgst,2)?></td>
	<td><?=round($pursgst,2)?></td>
	<td></td>
	</tr>
	
	
	<tr>
	<td>(B) ITC Reversed</td>
	<td></td>
	<td></td>
	<td></td>
	<td></td>
	</tr>
	
	<tr>
	<td align="center">(1)	As per rules 42 & 43 of CGST Rules</td>
	<td></td>
	<td></td>
	<td></td>
	<td></td>
	</tr>
	<tr>
	<td align="center">(2)	Others</td>
	<td></td>
	<td></td>
	<td></td>
	<td></td>
	</tr>
	
	
	<tr>
	<td>(C) Net ITC Available (A) – (B)</td>
	<td><?=round($purigstinter,2)?></td>
	<td><?=round($purcgst,2)?></td>
	<td><?=round($pursgst,2)?></td>
	<td></td>
	</tr>
	
	
	
	<tr>
	<td>(D) Ineligible ITC</td>
	<td></td>
	<td></td>
	<td></td>
	<td></td>
	</tr>
	
	
	<tr>
	<td align="center">(1)	As per section 17(5)</td>
	<td></td>
	<td></td>
	<td></td>
	<td></td>
	</tr>
	<tr>
	<td align="center">(2)	Others</td>
	<td></td>
	<td></td>
	<td></td>
	<td></td>
	</tr>
	</table>
	  <p><b>5.	Values of exempt, nil-rated and non-GST  inwardsupplies</b></p>
	  	<table width="100%" class="table" border="1px">
	  <tr>
	<th>Nature of supplies</th>
	<th>Inter-State Supplies</th>
	<th>Intra-State Supplies</th>
	
	</tr>
	<tr>
	<th>1</th>
	<th>2</th>
	<th>3</th>
	
	
	
	</tr>
	
	<tr>
	<td>From a supplier under composition scheme, Exempt and Nil rated supply</td>
	<td>0.00</td>
	<td>0.00</td>
	</tr>
	
	<tr>
	<td>Non GST Supply</td>
	<td></td>
	<td></td>
	</tr>
	
	</table>
	
	<p><b>5.1 Payment of tax</b></p>
		<table width="100%" class="table" border="1px">
	  <tr>
	<th>Description</th>
	<th>Integrated Tax</th>
	<th>Central Tax</th>
	<th>State/UT Tax</th>
	<th>Cess</th>
	
	</tr>
	<tr>
	<th>1</th>
	<th>2</th>
	<th>3</th>
	<th>4</th>
	<th>5</th>
	
	
	
	</tr>
	
	<tr>
	<td>Interest</td>
	<td></td>
	<td></td>
	<td></td>
	<td></td>
	</tr>
	
	<tr>
	<td>Late Fees</td>
	<td></td>
	<td></td>
	<td></td>
	<td></td>
	</tr>
	
	</table>
	<p><b>6.	Payment of tax</b></p>
	
	<table width="100%" class="table" border="1px">
	 <tr>
	 <th>Description</th>
	 <th>Tax Payable</th>
	 
	 
	 <th colspan="4"><table width="100%">
	 <tr><th colspan="8">Paid through ITC</th>
	 </tr>
	 <tr><th>Integrated Tax</th>
	     <th>Central Tax</th>
		  <th>State/UT Tax</th>
		  <th>Cess</th>
	 </tr></table>
	 </th>
	 
	 <th>Tax paid TDS/TCS</th>
	  <th>Tax/Cess paid in cash</th>
	   <th>Interest</th>
	   <th>Late Fee</th>
	   
	 </tr>
	 
	<tr>
	<th>1</th>
	<th>2</th>
	<th>3</th>
	<th>4</th>
	<th>5</th>
	<th>6</th>
	<th>7</th>
	<th>8</th>
	<th>9</th>
	<th>10</th>
	
	
	
	</tr>
	
	<tr>
	<td>Integrated Tax</td>
	<td></td>
	<td></td>
	<td></td>
	<td></td>
	<td></td>
	<td></td>
	<td></td>
	<td></td>
	<td></td>
	</tr>
	
	<tr>
	<td>Central Tax</td>
	<td></td>
	<td></td>
	<td></td>
	<td></td>
	<td></td>
	<td></td>
	<td></td>
	<td></td>
	<td></td>
	</tr>
	
	<tr>
	<td>State/UT Tax</td>
	<td></td>
	<td></td>
	<td></td>
	<td></td>
	<td></td>
	<td></td>
	<td></td>
	<td></td>
	<td></td>
	</tr>
	
	<tr>
	<td>Cess</td>
	<td></td>
	<td></td>
	<td></td>
	<td></td>
	<td></td>
	<td></td>
	<td></td>
	<td></td>
	<td></td>
	</tr>
	
	
	</table>
	<p><b>7.	TDS/TCS Credit</b></p>
	<table width="100%" class="table" border="1px">
	  <tr>
	<th>Details</th>
	<th>Integrated Tax</th>
	<th>Central Tax</th>
	<th>State/UT Tax</th>
	
	
	</tr>
	<tr>
	<th>1</th>
	<th>2</th>
	<th>3</th>
	<th>4</th>
		
	
	
	</tr>
	
	<tr>
	<td>TDS</td>
	<td></td>
	<td></td>
	<td></td>
	</tr>
	
	<tr>
	<td>TCS</td>
	<td></td>
	<td></td>
	<td></td>
	</tr>
	</table>
	
	<p>&nbsp;</p>
	<p><b>Verification (byAuthorisedsignatory)<br />
Iherebysolemnlyaffirmanddeclarethattheinformationgivenhereinaboveistrueand correct to the best<br /> ofmyknowledge and belief and nothing has been concealed there from.
</b></p>
<p>&nbsp;</p>
<p><b>Instructions:</b></p>

<p>1)	ValueofTaxableSupplies=Valueofinvoices+valueofDebitNotes–valueofcredit notes+valueofadvancesreceivedforwhichinvoiceshavenotbeenissuedinthesame month  – value ofadvances adjusted against invoices</p>

<p>2)	Detailsofadvancesaswellasadjustmentofsameagainstinvoicestobeadjustedandnot shown separately</p>

<p>3)	Amendment in anydetailsto be adjustedand notshown separately.</p>

  </table></div>
  
  
  
  
</div>
<!--<div align="center"><span class="btn btn-info" onClick="printDiv('printableArea')">Print</span> &nbsp;&nbsp;<button class="btn btn-success">Export to Excel</button></div>-->

		   </div>
		   </div>
		   </div>
    <?php 
	}?>
	
		

   
<p></p>
		<br />
        


</div>
<br />

<div align="center"><span class="btn btn-info" onClick="printDiv('printableArea')">Print</span> &nbsp;&nbsp;<button id="btnExport" class="btn btn-success">Export to Excel</button></div>
 </div>
                    </div>
                </div>
                <!-- End PAge Content -->
            </div>
            <!-- End Container fluid  -->
<?php include 'footer.php' ?>
<script type="text/javascript">
   
 $(document).ready(function() { 
  $("#btnExport").click(function(e) {
    e.preventDefault();

    //getting data from our table
    var data_type = 'data:application/vnd.ms-excel';
    var table_div = document.getElementById('table_wrapper');
    var table_html = table_div.outerHTML.replace(/ /g, '%20');

    var a = document.createElement('a');
    a.href = data_type + ', ' + table_html;
    a.download = document.getElementById('rahul').value + '.xls';
  
    a.click();
  });
});

    window.open('data:application/vnd.ms-excel,' + $('#dvData').html());
    e.preventDefault();

</script>
 <!--<script src="../js/lib/datatables/datatables.min.js"></script>
    <script src="../js/lib/datatables/cdn.datatables.net/buttons/1.2.2/js/dataTables.buttons.min.js"></script>
    <script src="../js/lib/datatables/cdn.datatables.net/buttons/1.2.2/js/buttons.flash.min.js"></script>
    <script src="../js/lib/datatables/cdnjs.cloudflare.com/ajax/libs/jszip/2.5.0/jszip.min.js"></script>
    <script src="../js/lib/datatables/cdn.rawgit.com/bpampuch/pdfmake/0.1.18/build/pdfmake.min.js"></script>
    <script src="../js/lib/datatables/cdn.rawgit.com/bpampuch/pdfmake/0.1.18/build/vfs_fonts.js"></script>
    <script src="../js/lib/datatables/cdn.datatables.net/buttons/1.2.2/js/buttons.html5.min.js"></script>
    <script src="../js/lib/datatables/cdn.datatables.net/buttons/1.2.2/js/buttons.print.min.js"></script>
    <script src="../js/lib/datatables/datatables-init.js"></script>-->
