WorkBook

Import Bank Reconciliation Files

Use the Import file tab under the Bank reconciliation submodule to import bank reconciliation files.

To use the Bank Reconciliation submodule, you must have access to Finance & Administration as defined in the User Access Rights submodule under Settings.

To import a bank reconciliation file:

  1. On the main toolbar, click Finance & Administration .
  2. If you have more than one company in your system, use the drop-down list above the left pane of the Finance & Administration screen to select the company for which you want to import bank reconciliation files.
  3. In the left pane of the Finance & Administration screen, click Month-end > Bank reconciliation.
  4. Click the Bank account tab and highlight the bank account that you want to import a reconciliation file for.
  5. Click the Import file tab and click Import .
  6. In the Bank reconciliation data import dialog box, click the Execute tab and select the applicable option from the Specification drop-down list.
  7. Choose the Source file that you want to import.
    WorkBook displays the source file data on the table.
  8. You can edit the fields in the first three rows of the table by double-clicking on the corresponding field and entering or selecting the applicable options from the drop-down list.
  9. If you want to create or delete import specifications and script parameters, click the Setting tab .
  10. Click OK - Import Data.