Dear All,

I am Viswanadh, did MBA in finance.

Recently I got job in gas pipe line lying company, and posted me as accounts head. Here I have to monitor and control all the financial transactions by satisfying vendors and the company management. Under me one accountant is working on SAP-Fico. But I donít have any idea on that ERP and in process to get trained.

Here my questions are,
1) how can I prepare MIS report (i.e on which basis can I?)
2) how can I prepare the balance sheet for the site end
3) how can I prepare the cash flow statement for every month

And let me know if there any other reports.

Please help me out by providing your experience and suggestions with data.

Thanks & Regards,

Viswanadh Raju.S

From India , Hyderabad
SAP has inbuilt formats that generate the BS and the P&L Statements from the TB. you need to be familiarize your self with the ERP and everything will fall into place
From India , Bangalore
hello Viswanath raju, am Madhukar Reddy, am giving you total practical material go throw it once.
From India , Hyderabad

Attached Files
File Type: xls Cash flow statement.xls (23.0 KB, 8063 views)
File Type: xls Funds flow.xls (53.5 KB, 3662 views)
File Type: xls MIS financials format.xls (522.5 KB, 5116 views)

funds flow statement
From India , Bangalore

Attached Files
File Type: xls Funds flow.xls (47.0 KB, 1685 views)

pls explain me whether assets in business undertaking should be purchased from owners fund or borrowers fund
From India , Gurgaon
Dear all,
we do first talling of Trial balance then we have posting the prescribed entries in balance sheet i.e liabilities and assets side in trial balance all debit goes to assets side and credit goes to liabilities side both side are tallyieng,
profit and loss a/c is the company profit and losses it will identifing total turn over + other income - ditrect expenses + indirect expenses = we got NET PROFIT

From India , Bangalore
Respected Seniors and Dear Friends,
This is Manoj Kumar from Hyderabad, doing as a US Accounts Executive in IT Solutions company,
it is It Staffing and developing company, any one please advice to me how to prepare the MIS financial reports to IT Staffing and developing company, and give some sample xls file,
I am eagarly waiting for your responce
Thanks & Regards
Manoj Kumar

From India, Hyderabad
MIS report means giving VITAL and useful information about performance of the organization to the top management.
In fact, balance sheets and other financial statements shall not be understood easily by top management.
They want precise and precious useful information only.
So as you are now in key position and not able to generate reports, do not waste time.
Simple figures also are helpful as follows:
Total sales Rs. 100 lakhs
Total purch. Rs. 90 lakhs
Total cr. sales Rs. 50 lakhs
Bad debts more than 3 months Rs. 60 lakhs
So the top management will appreciate the key figures like bad debts lying more than 3 months and the corrective steps.
Best regards

From India, Mumbai
mis report prepair in excell sheet

Hello friends, i want to the Tds and Gst process, how do file and pay every month
From India, Mumbai

If you are knowledgeable about any fact, resource or experience related to this topic - please add your views using the reply box below. For articles and copyrighted material please only cite the original source link. Each contribution will make this page a resource useful for everyone.

Please Login To Add Reply

About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2021 Cite.Coô

All Material Copyright And Trademarks Posted Held By Respective Owners.
Panel Selection For Threads Are Automated - Members Notified Via CiteMailer Server