Financial Statements in Excel

498 views
User Avatar

781 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
0 Reply Share Follow
On 04 June 2021 at 18:11 Report
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.

User Avatar

My grammar is 💯 good I
5110 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.

1 Reply
On 04 June 2021 at 18:40
User Avatar

781 Points Posted on 04 June 2021
Yes, earlier I used same tricks. But , Now Management is asking JV, GL, TB in excel
Reply
On 04 June 2021 at 18:48
User Avatar

Chartered Accountant
16188 Points Posted on 04 June 2021
Yes you can prepare accounts in excel
1 Reply
On 04 June 2021 at 19:08
User Avatar

My grammar is 💯 good I
5110 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.

1 Reply
On 04 June 2021 at 19:54
User Avatar

781 Points Posted on 04 June 2021
Thank u so much Sourav and Yasaswi
Reply
On 04 June 2021 at 21:17
User Avatar

Chartered Accountant
16188 Points Posted on 06 June 2021
Your welcome
Reply
On 06 June 2021 at 05:54
User Avatar

My grammar is 💯 good I
5110 Points Posted on 06 June 2021

Your welcome and glad you got your excel templates

1 Reply
On 06 June 2021 at 11:23
User Avatar

Chartered Accountant
16188 Points Posted on 25 July 2021
Thank you
1 Reply
On 25 July 2021 at 09:01

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Recent Topics :

  1. Comparative BS PL with Audit report
  2. Source of funds in IT returns
  3. Work from home job
  4. TDS ON ANY PURCHASE OF ANY GOODS - 393(1)
  5. TDS on payment to a non resident
  6. NSFA(National Food Security Act) commission
  7. RCM applicability on petty GTA freight (₹450
  8. Short payment reccieved in export & GST implic
  9. Parag Gupta vs Purushottam Aggarwal- who is best f
  10. GST applicability on own-vehicle goods transportat

More recent discussions | Post

Related Topics :

Loading

Latest Job Openings

View all
Company
Featured 21 September 2026
Consultant - Reporting

Finrep Advisors LLP

Mumbai

CA

View Details
Company
ARTICLESHIP 16 September 2026
Article Assistant

MANUJ SHARMA AND COMPANY

Noida

CA Inter

View Details
Company
08 September 2026
Semi-Qualified Assitant

Subrahmanyam & Sivudu CA Firm

Hyderabad

CA Inter

View Details
Company
08 September 2026
Audit Executive

Thammana & Associates

Srikakulam

B.Com

View Details
Company
Featured 12 September 2026
Assistant Manager - Finance & Compliance

Naveen Fintech Pvt Ltd

Kolkata

CA Inter

View Details
Company
ARTICLESHIP 04 September 2026
Accounts Executive

Hema Yashwanth & Associates

Chennai

B.Com

View Details
Company
19 September 2026
Finance Manager

Mugdha Art Studio

Hyderabad

CA

View Details
Company
ARTICLESHIP 18 September 2026
Industrial Trainee

Twenty Point Nine Five Ventures Private Limited

Noida

CA Inter

View Details