Currently, the Attendance Reconciliation report is only showing one column named "Motive" which refers to the "Adjusted Out Reason". There's no column related with the "Adjusted in Reason".
Prevent Future Issues
- Ensure that on the tab "roles" within this report, the profile of the user you are using to test is setup. This will ensure he has access to this report.
- Run the Attendance Reconciliation report
- Verify that the fields Adjusted In Reason and Adjusted Out Reason fields appear
- Open the report in Excel and verify that the values show up on the pivot