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)
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 Threads
- Commission are brokerage
- Understanding 80G5 Registration: A Complete Guide
- Discuss and Download CA Inter Question Paper Septe
- Discuss and Download CA Final Question Paper Septe
- Last to claim itc for FY 2024-25
- Vicky Kumar
- Taxation of Awarded share and issued Share
- Timing of actual filing return after paying self-a
- Property given for development ..amounts sale
- ITR-3 Submit level validation error
Related Threads
CAclubindia
