banner_ad

Financial Statements in Excel

Others 433 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
22 May 2026
U.S. Financial Reporting & Consolidation Manager

Karia Overseas

Ahmedabad

CA

View Details
Company
29 May 2026
Finance Head

Bhawar Sales Corporation

Chennai

Graduate (Any)

View Details
Company
18 May 2026
MIS Executive

Primarc Pecan Retail Limited

Mumbai

B.Com

View Details
Company
10 June 2026
Senior Account Executive

JDS Advisory LLP

Ahmedabad

CA Inter

View Details
Company
19 May 2026
Article, CA & Paid Assistant Positions

Aggarwal Sarawagi and Co

New Delhi

CA

View Details
Company
ARTICLESHIP 04 June 2026
Article

Rakhecha & Co.

New Delhi

CA Inter

View Details
Company
01 June 2026
Audit, Taxation & Compliance Executive

R P S K & Associates

Nashik

CA Inter

View Details
Company
ARTICLESHIP 15 May 2026
Audit Assistant / Article Trainee / Intern

SSGS and Associates

Chennai

CA Inter

View Details