Dear Friends,
Is it possible to prepare Financial Statement in Excel (JV, GL, TB, PL, BS).
Transaction Volume:
Sales Invoice - 100
Purchase Invoice - 200
Prepaid, Tax, Salaries, Depreciation etc.
Anyone can share me the Templates if you're having or assist me accordingly.
mohanraj_vkj @ yahoo.co.in
Menu
Financial Statements in Excel
Replies (8)
Quick Summary
One can prepare normal templates easily using add and minus functions. But if you want to enter data into a single cell and database it, you need to know vba scriptts.
Yes, earlier I used same tricks. But , Now Management is asking JV, GL, TB in excel
Yes you can prepare accounts in excel
https://web.iit.edu/sites/web/files/departments/general-accounting/pdfs/ga_journal_entry_form.xls
This link will help you if you can interpret it’s working, or lose type on google- gl excel template, Tb excel templates, pl excel templates. Lots of useful templates are available online.
Thank u so much Sourav and Yasaswi
Your welcome
Your welcome and glad you got your excel templates
Thank you
Recent Topics :
- TDS payment code query
- Query on FLAIR return
- Itr 4 problem
- Capital Gains Mismatch Due to Sale Agreement in FY
- REGARDING NRO INVESTMENT IN SHARES OF DOMESTIC COM
- DTAA benefits
- SUPPLEMENTARY AGREEMENT FOR ADDING A PARTER IN TN
- Part availmement of ITC in case of rejection of su
- Due date for itr 5 no audit with loss for fy 25 26
- Capital Gains Mismatch AIS
Related Topics :
CAclubindia
