banner_ad

Financial Statements in Excel

416 views 8 replies
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
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


CCI Pro

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
Featured 02 May 2026
Senior Executive

hitesh chandwani & co

Pune

B.Com

View Details
Company
Featured 28 March 2026
Accountant

Ashok Amol & Associates

New Delhi

B.Com

View Details
Company
Featured 14 April 2026
GST CONSULTANT

Abhishek G Agrawal & Co.

Korba

CA Final

View Details
Company
Featured 29 April 2026
Manager- Finance and Compliance

Naveen Fintech Pvt Ltd

Kolkata

CA Inter

View Details
Company
Featured 13 April 2026
GST CONSULTANCY

Abhishek G Agrawal & Co.

Korba

CA Final

View Details
Company
Featured 28 March 2026
CA Final

Ashok Amol & Associates

New Delhi

CA Final

View Details