Home

Welcome to the bean_counter wiki!

What is it?

This is a simple accountant app, built to ease out our traditional business gst filing process.

it cumulates transactions from 2 sheets one to track sales other for purchase and generates monthly report. of the below format

GSTIN	GSTNUMBER
Name	John doe
Month	Month Year
A )	Purchases
	Total Taxable Amount		230070
	Total C.G.S.T		1587
	Total S.G.S.T		1587
	Total I.G.S.T		8726
	Total Purchases Amount with tax		241970
B )	Input Tax amount of Purchases
	Total C.G.S.T		1587
	Total S.G.S.T		1587
	Total I.G.S.T		8726
	Total Input Tax amount		11900
C )	Sales
	Amazon Sales		0
	Flipkart Sales		0
	Offline Sales		225603
	Total Sales with Tax amount		225603
D )	Total Sales as per Following
	Total Taxable Amount		214860
	Total C.G.S.T		4414
	Total S.G.S.T		4414
	Total I.G.S.T		1915
	Total Sales with tax amount		225603
E )	Total payable tax amount of sales
	Total payable C.G.S.T		4414
	Total payable S.G.S.T		4414
	Total payable I.G.S.T		1915
	Total payable tax amount		10743
F )	Total payable tax liability
	Total input tax amount		11900
	Total payable tax amount		10743
	Total Tax Credit/ Payable		1157
G )	Total payable tax as per following states
sr no.	Name of state	I.G.S.T	C.G.S.T	S.G.S.T	Total Tax
	Gujarat	0	6001	6001	12002
	Maharashtra	8080	0	0	8080
	Rajasthan	2561	0	0	2561