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 :
- FAI & FAST-DS 2026 query
- Is GST registration mandatory in this case
- Buying a residential flat in Goa: should my wife b
- Income tax filling
- Applicability of RCM in the case of import of serv
- Confusion in gst registration for service category
- Itc claimed from return defaulters
- Gst input credit
- CAN PARTNERSHIP FIRM SIGN SERVICE AGGREMENT WITH A
- E-waybill
Related Topics :
CAclubindia
