Hi, I am Priti, Please help & guide to prepare MIS report for expense mangement. priti
From India, Mumbai
From India, Mumbai
one way is to list down all the expense heads under which expenses are booked in the TRIAL BALANCE of a company. against those heads enter the net amount(Dr.- Cr.) given in the trial bal.
Also you have to consider the increase/decrease in finished stocks, if required.
Nishant
From India, Chandrapur
Also you have to consider the increase/decrease in finished stocks, if required.
Nishant
From India, Chandrapur
Hi Priti,
Collate complete data in one excel file and prepare a pivot table by employees, there expenses & Aging analysis.
It will give you employee wise details grouping in ages(<30 Days, 30-60,60-90,>90 Days )
Please let me know if you have further doubts else provide me the sample expense sheet I will send you with a prepared report.
Warm Regards,
Vinodkumar Gandhe.
From India, Bangalore
Collate complete data in one excel file and prepare a pivot table by employees, there expenses & Aging analysis.
It will give you employee wise details grouping in ages(<30 Days, 30-60,60-90,>90 Days )
Please let me know if you have further doubts else provide me the sample expense sheet I will send you with a prepared report.
Warm Regards,
Vinodkumar Gandhe.
From India, Bangalore
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.
Career - How to Prepare Your Curriculum Vitae (Revised Ed McGraw Hill).pdf
Expense sheet new 20090108 Sample Sheet -2.xls