Ad Free CAclubindia and Daily Updates on your Mobile. Subscribe Now!

Financial Statements in Excel

04 June 2021

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

Reply
Follow
Share

8 Replies

yasaswi gomes (My grammar is 💯 good I) (7290 Points)
Replied 04 June 2021

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.

1 Like

Upgrade to CAclubindia Pro. Subscribe Now!

Mohanraj J (1178 Points)
Replied 04 June 2021

Yes, earlier I used same tricks. But , Now Management is asking JV, GL, TB in excel

CA. Sourav Sarkar (Chartered Accountant ) (24583 Points)
Replied 04 June 2021

Yes you can prepare accounts in excel

1 Like

yasaswi gomes (My grammar is 💯 good I) (7290 Points)
Replied 04 June 2021

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.

1 Like