Bank manager - Bank Balance is 0.00 or incorrect

Description of Issue

Bank Balance is 0.00 or incorrect in Bank Reconciliation Manager

Context
  • Bank Reconciliation Manager
  • Reconcile
  • Balance Per Bank Statement
Cause
  • Incorrect setup
  • Bank Reconciliation Settings Bank account balance code field is set to 015 instead of 045
  • Bank Reconciliation Settings Bank account balance code field is set to 045 instead of 015
  • Bank Reconciliation Settings Bank account balance code field is blank
Resolution
  • The Bank Reconciliation Settings > Bank account balance code field determines where Munis will pull the Bank Account Balance from in the BAI file. 
    • The Bank account balance field in Bank Reconciliation Setting program can be set to 015 - Closing Ledger or 045 - Closing Available
  • Bank Reconciliation Settings > Bank account balance code should be set to the BAI Code (015 or 045) that is used AND is followed by an amount other that 0.00 in the import file. 
    • General Ledger Support can update Bank Reconciliation Settings if they are incorrect
    • If the BAI file is wrong,  the sites bank should provide a new import file. Manual corrections to the import file are discouraged.
Additional Information

If the Bank account balance code field is populated incorrectly, contact General Ledger Support to assist in correcting this for future imports. 

If a reconciliation record was created in Bank Reconciliation Manager after the BAI file was imported with the wrong Bank Account Balance Code set in Bank Reconciliation Settings, deleting and recreating the reconciliation record after General Ledger Support updates the Bank Reconciliation Settings to the correct balance code will update the Balance Per Bank Statement amount to the amount from the imported BAI file.Â