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 Topics :
- NPO registered under sec 8 itr filing
- Form 144 (Earlier 27Q) – Reason Code (A/C/G/
- Nps taxation
- Representative assessee
- Investment Income as Business Income for Sec. 44AD
- In ITR 4 u/s 44ADA what amount we shoud show under
- Salary expenses how to treat
- Pos related issue
- Gift of unlisted shares to friend upon marriage
- Utilising Section 54(F) for capital gains reinvest
Related Topics :
CAclubindia
