Reconciling Using an Import with Excel

Reconciling your Bank Account using an Import with Excel

Create your Excel file by running the Bank Transaction Export Spreadsheet in AGRIS:
1. Bank > Report Manager > Bank Account Reports > Standard > 8. Bank Transaction Export Spreadsheet
2. 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

2. Once you have your spreadsheet open that we just exported:

a. For transactions you are wanting to reconcile:

i. Make the status an X in Column B. You must use a capital X. The Status Codes in this column are A (Active), V (Void), and X (Reconciled). If you ran the report using A to A for your Status Code, all of your codes should be an A when you begin reconciling.

ii. Fill in your reconciled date in column N in the format YYMMDD

b. Save your spreadsheet and close out of Excel

3. Import as you would in normal import procedures. You can use any of your existing import setups in Reports > Import Procedures and just select the file you saved, or you can create a new import in Maintenance > Import Maintenance.

a. Make sure your Report Option is set to always print, and that the output device is your Spool. This way you can go back and review any rejects from the import or see what successfully imported.