To identify and resolve discrepancies between automated and manual reports, I would first verify the data sources to ensure they are consistent and up-to-date. I would check the formulas and scripts used in the automation process to ensure they are correctly implemented. Next, I would compare a sample set of data from both reports to pinpoint where the discrepancies occur. If needed, I would collaborate with team members from different departments to gather insights and verify the data accuracy. Once the root cause is identified, I would make the necessary adjustments to the automation process and re-run the reports to confirm the discrepancies are resolved. Regular monitoring and validation would be implemented to prevent future issues.