Reconciling your Bank Account using an Import with Excel
Create your Excel file by running the Bank Transaction Export Spreadsheet in AGRIS:
Bank > Report Manager > Bank Account Reports > Standard > 8. Bank Transaction Export Spreadsheet
Put in your bank code, transaction dates (for the range you are wanting to reconcile), and your Status Code A to A to show only Active transactions
...