Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

This setting is configured on the Bank Files tab of Banking Configuration Maintenance. See Banking Configuration Maintenance - Bank Files tab in the Finance manual.

To reconcile bank accounts using imported bank files:

  1. Select Module > General Ledger > Bank Reconciliation from the main menu.
    The Select Current Bank Statement Control window is displayed.
    Image RemovedImage Added
    Tip: You can also access General Ledger functions by clicking Image Removed Image Added.
  2. Click Image Removed Image Added.
    The Create New Bank Statement Control window is displayed.
    Image RemovedImage Added
    Note: Most of the details are usually populated from the previous bank reconciliation.
  3. Select the bank account to reconcile using the Bank Code drop-down list, if you have more than one bank account.
    Image RemovedImage Added
  4. Download the bank account transaction file from the bank.
  5. Return to the Create New Bank Statement Control window.
  6. Click
    Anchor
    O_9239
    O_9239
    Image RemovedImage Added.
    The Load Bank Transactions window is displayed.
    Image RemovedImage Added
  7. Click Image RemovedImage Added.
    A window similar to the following one is displayed.
    Image RemovedImage Added
  8. Browse for the bank account transaction file.
  9. Select the required file.
  10. Click Image Removed Image Added.
    The Load Bank Transactions window is redisplayed.
    Image RemovedImage Added
  11. Click Image Removed Image Added.
    The following dialog window is displayed.
    Image RemovedImage Added
  12. Click Image Removed Image Added.
    The Change Bank Statement Control window is displayed.
    Image RemovedImage Added
    Note: The Closing Balance is updated automatically from the bank transaction file.
  13. Click Image Removed Image Added.
    The Bank Reconciliation window is displayed.
    Image RemovedImage Added
    Note: In the example above a single transaction (Ord 2) in the right pane has not been matched. An EFT deposit has been added to the NYBA total.
    If the bank statement is reconciled, the difference (Diff field) is zero and the following message is highlighted in green: B/S Reconciled.
    Image RemovedImage Added
    If the general ledger bank transactions are reconciled, the Variance is zero and the following message is highlighted in green: G/L Reconciled.
    Image RemovedImage Added
  14. Click Image Removed Image Added.
    The following dialog window is displayed.
    Image RemovedImage Added
  15. Click Image Removed Image Added.
    The following dialog window is displayed.
    Image RemovedImage Added
  16. Click Image Removed Image Added.
    The Bank Reconciliation report is spooled to your default Synergetic printer and the Select Current Bank Statement Control window is redisplayed.
    Image RemovedImage Added
  17. Repeat from step 2 for each bank account to reconcile.