Follow these steps to create a custom import template for the Auto Bank Reconciliation screen.
Click the Financials tab.
Click Auto Bank Reconciliation.
Enter a Statement Ref number in the Auto Bank Reconciliation screen. If you are only creating a template, any value will do. Once a reference is entered, some options that were previously greyed out become available. On the right side, near the Unreconciled and Reconciled tabs, click the small white page icon (3rd from the right) to open the options window.
Click Import Formats.
Click the blank page icon to create a new template.
Enter a name in the Import name field.
Set the Import type to match your file format. For Excel files, keep it as Comma Separated Values.
Map each ABR field to the column number in your import file. For example, if transaction balances appear in column D of your spreadsheet, enter 4 (columns are numbered by their position: A=1, B=2, C=3, D=4, and so on). Click an ABR field to see the Separated Values options on the right, then enter the relevant column number. Once all column numbers are entered:
Click Save.
Import your CSV file as you normally would when importing a bank statement.
Select the template you just created.
Confirm the information is in the correct columns.
If the information is not in the correct columns, return to the mapping steps above and check the column numbers you have assigned.