VAT Report in Excel

gopaliba

HI,

												
												
												
												
Government of Karnataka												
(Department of Commercial Taxes)												
												
FORM VAT 100												
												
(See Rule 38)												
												
1		General Information			:							
1.1		LVO CODE			:							
1.2		Tax Period (Month)			:							
1.3		Type of Return			:							
1.4		Date of Filing Return			:							
1.5		TIN No			:							
1.6		Full Name of the Daler			:							
												
1.7		Address of the Dealer			:							
												
1.8		Tax Invoices issued in the Month*			:							
												
PARTICULARS OF TURNOVERS												
												
Local							Interstate					
2	Total Turnover						3	Total Turnover (Interstate  / Exports Import / Consignment				
												
2.1	Sales Return, discounts, Labour Charges Etc. as per Rule 3(2)						3.1	Sales return, disounts, Labour charges, etc as per Rule 3(2)				
												
2.2	Consignment Sales / C. A. Sales						3.2	Stock Tranfers / Consignment Sales				
2.3	Tax Collected (VAT)						3.3	Exempted Sales				
2.4	Exempted Sales						3.4	Direct Exports				
2.5	Others						3.5	Deemed Exports (Against H Form)				
												
2.6	Taxable Turnover (Local) (Box 2 Less Box 2.1 to Box 2.6)						3.6	Sale in Transit (E - I and E - II)				
												
							3.7	Sales in the course of Import (High Sea Sales)				
												
							3.8	CST Collected				
							3.9	Taxable (Interstate) [Box No.3 Less (Total of Box No.3.1 to 3.8)]				
												
												
4	Net Tax Payable											
4.1	Out Put Tax Payable					(Refer Box No.8.3)						
4.2	B/F of Previous Month											
4.3	Input Tax Credit					(Refer Box No.11)						
4.4	Tax Payable					[(Box No.4.1 - (Box No.4.2+Box No.4.3)]						
4.5	Tax Deducted at source					(Certificate Enclosed)						
4.6	Balance Tax Payable					(Box No. 4.4 - Box No. 4.5)						
4.7	Refund					Yes / No						
4.8	Credit Carried forward					Yes / No						
4.9	Net Tax refund as per Incentive Notification											
												
5		Tax Payment Details										
		Details				Amount	Cash / DD / Cheque / Challan No.		Bank		Date	
												
5.1		Tax Payable as per Box No.4.6										
5.2		Interest										
5.3		Others										
5.4		Total of Box No.5.1, Box No.5.2 and Box No.5.3										
												
												
For CTD / Bank Use Only												
Date of Receipt of Return												
Received Rs.												
In words Rs.												
Challan No.						Date						
												
									Signature and Seal of LVO / VSO			
* Note: If the Serial Numbers of Tax Invoices are of different series then it should be mentioned separately												
												
6	Details of Local Sales / URD Purchases and Output Tax / Purchase Tax Payable											
												
6.1	Taxable Turnover of Sales at rate of 1% Tax						6.7	Output Tax Payable (relating to Box No.6.1)				
												
6.2	Taxable Turnover of Sales at rate of 4% Tax						6.8	Output Tax Payable (relating to Box No.6.2)				
												
6.3	Taxable Turnover of Sales at Standard rate of Tax of 12.5%						6.9	Output Tax Payable (relating to Box No.6.3)				
												
6.4	Taxable Turnover of URD Purchases (Specify Rate of Tax)						6.10	Purchase Tax Payable (relating to Box No.6.4)				
												
6.5	Others, if any (Please Specify)						6.11	Output Tax Payable (relating to Box No.6.5)				
												
6.6	Total (Box No.6.1 to 6.5)						6.12	Total Output Tax Payable (Box No 6.7 to 6.11)				
												
												
7	Details of Interstate Sales and CST Payable											
7.1	Taxable Turnover of inter-state sales at rate of 1% Tax						7.7	Output Tax Payable (relating to Box No.6.1)				
												
7.2	Taxable Turnover of inter-state sales at rate of 3% Tax						7.8	Output Tax Payable (relating to Box No.6.2)				
												
7.3	Taxable Turnover of inter-state sales at Standard rate of Tax of 4%						7.9	Output Tax Payable (relating to Box No.6.3)				
												
7.4	Taxable Turnover of Inter-State Sales without C Forms at 12.5% Tax						7.10	Purchase Tax Payable (relating to Box No.6.4)				
												
7.5	Others, if any (Please Specify)						7.11	Output Tax Payable (relating to Box No.6.5)				
												
7.6	Total (Box No.6.1 to 6.5)						7.12	Total Output Tax Payable (Box No 6.7 to 6.11)				
												
												
8	Less:											
	8.1	Total Output Tax				(Total of Box No.6.12 and Box No.7.12						
	8.2	Output Tax deferred to Industries as per Incentive Notifications										
	8.3	Net Output Tax Payable				(Box No. 8.1 Less Box No. 8.2)						
												
9	Details of Purchases and Input Tax											
												
9.1	Net value of  purchases at 1% tax						9.11	Input Tax (Relating to Box No.9.1)				
9.2	Net value of purchases at 4 % tax						9.12	Input Tax (Relating to Box No.9.2)				
9.3	Net value of purchases at standard rate of tax at 12.5 % tax						9.13	Input Tax (Relating to Box No.9.3)				
9.4	Value of URD purchases to the extent used or sold (specify rate of tax)						9.14	Input Tax (Relating to Box No.9.4)				
												
9.5	Others, if any (please specify)						9.15	Input Tax (Relating to Box No.9.5)				
9.6	Value of VAT exempted goods.											
9.7	Purchases from Composition dealer											
9.8	Value of goods imported  and / or  purchased in the course of inter-State trade including E1 and EII  purchase.											
												
												
9.9	Value of goods received  by stock transfer /  consignment transfer											
												
9.10	Total value of purchases (Total of Box Nos. 9.1 to 9.9)						9.16	Input Tax (Relating to Box No.9.11 to 9.15)				
												
												
10	Ineligible Input Tax Credit											
10.1	Non-deductible input tax being restricted u/s 11 of VAT Act											
10.2	Non-deductible input tax – Pre-registration Purchases u/s 13 of VAT Act 											
10.3	Non-deductible input tax-under special rebating scheme u/s 14 read with Section 11 of VAT Act											
10.4	Non-deductible input tax – under partial rebating scheme u/s 17 of VAT Act											
10.5	Others, Please Specify											
10.6	Total Ineligible Input Tax Credit					(Total of Box No. 10.1 to Box No. 10.5)						
11	Eligible Input Tax Credit 					(Box No. 9.16 – Box No. 10.6)						
												
DECLARATION												
          I / We Declare that the particulars furnished above are true and complete in all respects.  I / We hereby declare that I am / We are aware that there are penalties for making false declarations or incomplete returns.												
												
												
Place:		Bangalore						Signature:				
Date:								Name and Designtion Seal:				
												
12	ENTRY TAX											
(Applicable to dealers' who are liable to tax under the KTEG ACT, 1979)												
												
12.1	TOTAL PURCHASES : Value of goods liable for entry tax both Local, Interstate and Imports including freight and inward expenses											
												
	LESS:											
12.2	Purchases within the local Area,  Purchases against Form-40Purchase Returns, Re-exports											
12.3	Others  -Items otherthan P&M debited in P/M Schedule											
12.4	TAXABLE TURNOVER  											
												
CALCULATION OF ENTRY TAX PAYABLE												
												
	Description of Goods								Taxable Value		Tax Payable	
12.5	Goods Taxable @ 1%											
12.6	Goods Taxable @ 2%											
12.7	Goods Taxable @ 5%											
12.8	Goods Taxable (others)											
12.9	TOTAL											
												
12.10	Tax Paid Particulars			Rs.			Cash / DD / Challan No.:					
												
	Date:											
												
	I / We declare that the particulars furnished above are true and complete in all respects.											
												
	Place:		Bangalore					Signature:				
	Date:							Name and Designtion Seal:				
												
	Incomplete forms will be deemed to be invalid and penalties relating to non-filing will apply.											
	Note: If the Return is not applicable then it can be written as ``N.A”											
												
13	SPECIAL ENTRY TAX											
(Applicable to dealers who are liable to tax under the Karnataka Special Tax on Entry of certain Goods Act, 2004)												
	 TOTAL PURCHASES : 											
13.1	Value of goods liable for KSTECG both Local, Interstateand Imports including freight and inward expenses											
												
	LESS:											
13.2	a)	Exemption (Please specify)  (I-S & Import of Raw Materials & Components)										
	b)	Purchase Returns										
	c)	Re-exports										
	d)	Others										
13.3	TAXABLE TURNOVER											
												
	Description of the Notified Goods								Taxable Value		Tax Payable	
13.4	Goods Taxable @ 4%											
13.5	Goods Taxable @ 12.5%											
13.6	Goods Taxable (others)											
13.7	TOTAL											
13.8	Less: CST Paid as per Section 4(2) of KSTECG Act											
13.9	Balance Tax Payable											
												
13.10	Tax Paid Particulars			Rs.			Cash / DD / Challan No.:					
												
	Date:											
												
	NOTE: The High Court of Karnataka has struck down the entire provisions of The Karnataka Special Tax on Entry of Certain Goods Act (2004).  Accordingly the details sought for under clause 13 above is not applicable											
												
	I / We declare that the particulars furnished above are true and complete in all respects.	I / We declare that the particulars furnished above are true and complete in all respects.										
												
	Place:		Bangalore					Signature:				
	Date:							Name and Designtion Seal:				
												
	Incomplete forms will be deemed to be invalid and penalties relating to non-filing will apply.											
	Note: If the Return is not applicable then it can be written as ``N.A”											

Please suggest how to populate the values in the excel template attached here,(sheet 1).
Here Inventory is not maintained, In payables, values are entered in Invoices, and posted. I kept a button which generates a excel. I have attached the excel template here, Please suggest how to populate the values from navision to excel.

Thanks & regards,
Gopalakrishnan N

ssingla

You need to learn how export to excel functionality works. Report No. 6 Trial Balance will be good for you to start with.

kriki

[Topic moved from 'NAV 2009' forum to 'NAV/Navision' forum]