Go AD-Free with CAclubindia Pro and Daily WhatsApp Updates. Subscribe Now!

Financial Statements in Excel

479 views

Save Share

Mohanraj J

1238 Points Posted on 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

Replies (8)

Quick Summary

This discussion explores the feasibility of preparing various financial statements, including journal entries (JV), general ledgers (GL), trial balances (TB), profit and loss (P&L), and balance sheets (BS), using Microsoft Excel. While basic statements can be created with simple formulas, more advanced data entry and database functionalities might require VBA scripting. Participants shared resources and templates for creating these financial documents in Excel.

yasaswi gomes

My grammar is 💯 good I

7306 Points Posted on 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.

Mohanraj J

1238 Points Posted on 04 June 2021

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

CA. Sourav Sarkar

Chartered Accountant

24588 Points Posted on 04 June 2021

Yes you can prepare accounts in excel

yasaswi gomes

My grammar is 💯 good I

7306 Points Posted on 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.