Q&A Tracking Sheet for a Financial Model (Excel)

Usually questions and answers on a financial model end up buried in email threads or scattered across Word files. 

In our experience it is far more efficient to track every query in a dedicated sheet embedded within the model itself and keep it live throughout the entire due diligence process. This approach supports seamless internal collaboration and provides a clear audit trail when you receive comments from auditors or other third parties. It promotes transparency and makes it easy to monitor the status of each issue, its impact level, and who is responsible for resolution.

This template includes two optional UserForms to manual data entry. The first form lets you log new questions with fields for who asked them, category, reference, date, and impact level. The second form walks you through unanswered items one by one, captures your response, records who answered and when, and can advance automatically to the next pending question. 

If you prefer manual entry you can simply type directly into the sheet.