To export to Excel from the ABR:
Click Financials
Click Auto Bank Reconciliation
Select the Statement being used
Select the Status (Unreconciled, reconciled)
Select All transactions you wish to export
Click Export to File
When the pop up appears, type in the name of the file followed by .CSV . This will convert the file to an Excel format.
Open this file in Excel and then click Save As to save in the form of Excel format required.