WorkBook

Import Bank Reconciliation Files

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

To use Bank Reconciliation in the Month-End submodule, you must have access to Finance & Administration as defined in User Access Rights 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 WorkBook system, use the drop-down list above the left pane of the Finance & Administration page to select the Company for which you want to import bank reconciliation files.
  3. In the left pane of the Finance & Administration page, click Month-End > Bank Reconciliation.
  4. Click the Bank Account tab and highlight the bank account for which you want to import a reconciliation file.
  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 appropriate 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 appropriate options from the drop-down list.
  9. To create or delete import specifications and script parameters, click the Setting tab .
  10. Click OK - Import Data.