The issue has been resolved
After the reinstall you need to deactivate the Layout generator Add-in (under the excel options) and restart excel. It will auto-execute and the task pane should show up
Sage Intelligence is an additional reporting module for most sage products. It extracts data from the core program (the one you're having the account reconciliation issue with) and pushes all that data into excel where you can design…"