Struggling with Excel? How Do I Create a Debtor Report for Accounts Receivable?

Hello friends,

I've joined a new organization in the Accounts Receivable department. I have been tasked with preparing a report on the current outstanding status of debtors and their payment trends. I am a basic Excel user and do not know the advanced features required to create such reports. Although I have the necessary data, I am unsure of how to present it in the form of a report. I would greatly appreciate it if any of you could help me with this.

Thank you.

Hi,

My name is Yashvant Patel. I have over 4 years of experience working in the construction industry. Recently, I have joined a trading company in the UAE. Consequently, my experience and developed MIS formats are no longer useful to me.

I kindly request all of you to provide me with MIS reports for Asset Management, Management of Payables and Receivables, and Management of PDCs.

Thank you.