Hi, I am Priti, Please help & guide to prepare MIS report for expense mangement. priti
From India, Mumbai
Acknowledge(0)
Amend(0)
From India, Mumbai
Acknowledge(0)Amend(0)
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 balance. Also, you have to consider the increase/decrease in finished stocks, if required.
Nishant
From India, Chandrapur
Acknowledge(0)Amend(0)
Nishant
From India, Chandrapur
Acknowledge(0)Amend(0)
Hi Priti,
Collate complete data in one Excel file and prepare a pivot table by employees, their expenses, and Aging analysis. It will give you employee-wise details grouped in ages (<30 Days, 30-60, 60-90, >90 Days). Please let me know if you have further doubts, or else provide me the sample expense sheet, and I will send you a prepared report.
Warm Regards,
Vinodkumar Gandhe.
From India, Bangalore
Acknowledge(0)Amend(0)
Collate complete data in one Excel file and prepare a pivot table by employees, their expenses, and Aging analysis. It will give you employee-wise details grouped in ages (<30 Days, 30-60, 60-90, >90 Days). Please let me know if you have further doubts, or else provide me the sample expense sheet, and I will send you a prepared report.
Warm Regards,
Vinodkumar Gandhe.
From India, Bangalore
Acknowledge(0)Amend(0)Looking for something specific? - Join & Be Part Of Our Community and get connected with the right people who can help. Our AI-powered platform provides real-time fact-checking, peer-reviewed insights, and a vast historical knowledge base to support your search.
New MIS reports Master Data.xls
23_excel funaction and data analysis tool.pdf