Accounting

[vra]

CAN WE DEVELOP ACCOUNTING SOFTWARE IN EXCEL?
If yes, Kindly guide a little please
Thanks!!!!

 

[shyy]

Yes its possible, I created one and my vba skills is not professional. Try to plan on a piece of paper, what you want. Lay them all out and think on how you should approach it, function or vba wise.



Good Luck!

 

[John Davis]

CAN WE DEVELOP ACCOUNTING SOFTWARE IN EXCEL?
If yes, Kindly guide a little please
Thanks!!!!

Does this help?

http://dotxls.com/free-excel-templates/free-excel-templates---finance-and-accounting-templates

 

[vra]

Thanks alot . I shall follow what u said once my routine works are over.
Thanks ONce again SHYY

 

[vra]

Does this help?

http://dotxls.com/free-excel-templates/free-excel-templates---finance-and-accounting-templates

I have checked the site but it has other templates.
Thanks a lot

 

[vra]

Excel Workbook
	B	C	D	E
1	RECEIPTS REGISTER
2	CUSTOMER NAME	RECEIPTS	DATE	MODE
3	BHARAT RAIL	31500	03/04/2011	CHEQUE
4	A.D.GULHANE	13500	14/03/2011	CHEQUE
5	J.H.DAGA	6000	06/04/2011	CHEQUE
6	PRITTI	12000	09/04/2011	CHEQUE
7	SINGHAI TYRE CO.	10000	10/04/2011	CHEQUE
8	UNIVERSAL ENG	7000	11/04/2011	CHEQUE
9	CHANDRALOK	12000	13/04/2011	CASH
10	VIDARBHA HARDWARE	13000	13/04/2011	CASH
11	ASHIRWAD REST.	5000	03/05/2011	CASH
12
Sheet2

Excel 2010

Above is my receipts register. My accounting is on cash basis. So i do not need customers ledger.From this register i want my cash book & BAnk Book be automatically generate. But i do have other entries in cash book & bank book so how to go further . Coz i made cash fbook by using functions. But now other cash debits & credits how to adjust in it??

 

[vra]

Excel Workbook
	B	C	D	E	F	G
2	date	ACCOUNT CR	DEBIT	ACCOUNT DR	CREDIT	BALANCE
3	03/04/2011	FEES
4	14/03/2011	FEES	0
5	06/04/2011	FEES	0
6	09/04/2011	FEES	0
7	10/04/2011	FEES	0
8	11/04/2011	FEES	0
9	13/04/2011	FEES	12000
10	13/04/2011	FEES	13000
11	03/05/2011	FEES	5000
CASH

Excel 2010

Cell Formulas
Range	Formula
B3	=IF(RECEIPT!J8>31/3/2011,RECEIPT!J8,"")
B4	=IF(RECEIPT!J9>31/3/2011,RECEIPT!J9,)
B5	=IF(RECEIPT!J10>31/3/2011,RECEIPT!J10,)
B6	=IF(RECEIPT!J11>31/3/2011,RECEIPT!J11,)
B7	=IF(RECEIPT!J12>31/3/2011,RECEIPT!J12,)
B8	=IF(RECEIPT!J13>31/3/2011,RECEIPT!J13,)
B9	=IF(RECEIPT!J14>31/3/2011,RECEIPT!J14,)
B10	=IF(RECEIPT!J15>31/3/2011,RECEIPT!J15,)
B11	=IF(RECEIPT!J16>31/3/2011,RECEIPT!J16,)
D3	=IF(AND(RECEIPT!K8="cash",RECEIPT!J8>31/3/2011),RECEIPT!I8,"")
D4	=IF(AND(RECEIPT!K9="cash",RECEIPT!J9>31/3/2011),RECEIPT!I9,0)
D5	=IF(AND(RECEIPT!K10="cash",RECEIPT!J10>31/3/2011),RECEIPT!I10,0)
D6	=IF(AND(RECEIPT!K11="cash",RECEIPT!J11>31/3/2011),RECEIPT!I11,0)
D7	=IF(AND(RECEIPT!K12="cash",RECEIPT!J12>31/3/2011),RECEIPT!I12,0)
D8	=IF(AND(RECEIPT!K13="cash",RECEIPT!J13>31/3/2011),RECEIPT!I13,0)
D9	=IF(AND(RECEIPT!K14="cash",RECEIPT!J14>31/3/2011),RECEIPT!I14,0)
D10	=IF(AND(RECEIPT!K15="cash",RECEIPT!J15>31/3/2011),RECEIPT!I15,0)
D11	=IF(AND(RECEIPT!K16="cash",RECEIPT!J16>31/3/2011),RECEIPT!I16,0)

This above is cash book. PLs correct me if any suggestions .. & if on 10/04/2011 there is other debit in it so how to accomodate it & then same should be posted in that particular a/c.
PLs Help