PRIME SPONSOR - FACTOHR - Payroll Software with GPS Enabled Attendance, Travel, Performance Management, HRMS. Explore Features
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
Cite.Co is a repository of information created by your industry peers and experienced seniors sharing their experience and insights.
Join Us and help by adding your inputs. Contributions From Other Members Follow Below...
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
hello Viswanath raju, am Madhukar Reddy, am giving you total practical material go throw it once.

Attached Files
Membership is required for download. Create An Account First
File Type: xls Cash flow statement.xls (23.0 KB, 7950 views)
File Type: xls Funds flow.xls (53.5 KB, 3570 views)
File Type: xls MIS financials format.xls (522.5 KB, 4936 views)

funds flow statement

Attached Files
Membership is required for download. Create An Account First
File Type: xls Funds flow.xls (47.0 KB, 1652 views)

pls explain me whether assets in business undertaking should be purchased from owners fund or borrowers fund
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
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
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
mis report prepair in excell sheet
Hello friends,
i want to the Tds and Gst process, how do file and pay every month
PRIME SPONSOR - TALENTEDGE "Interactive Anywhere Learning". Executive courses from top reputed institutes like IIM, XLRI, MICA. View Courses
Add Reply Start A New Discussion

About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2019 Cite.Coô