How To Prepare Expense Management-mis Report

Priti Bhanushali
Hi, I am Priti,
Please help & guide to prepare MIS report for expense mangement.
priti
NISHANT THAKKAR
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
Vinodkumar Gandhe
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.
If you are knowledgeable about any fact, resource or experience related to this topic - please add your views. For articles and copyrighted material please only cite the original source link. Each contribution will make this page a resource useful for everyone. Join To Contribute