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
Find answers from people who have previously dealt with business and work issues similar to yours - Please Register and Log In to CiteHR and post your query.