Hi, I am Priti, Please help & guide to prepare MIS report for expense mangement. priti
From India, Mumbai
From India, Mumbai
Our compliance dashboard gives a 360? view of filings, deadlines, missed reports, and pending challans?so nothing falls through the cracks. See It In Action - Book Your Demo
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
Nishant
From India, Chandrapur
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
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
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