Master Article - Bank Reconciliation Settings

Bank Reconciliation Settings

• General ledger
• Bank Reconciliation Settings
• Bank Manager
• Classic Bank Reconciliation

Bank Reconciliation Settings require updating

Financials > Cash Management > Bank Reconciliation > Bank Reconciliation Settings

• Multiple Deposit Flag - (Bank Manager this setting MUST be checked) Having this checked or unchecked changes how Accounts receivable items pull into the Bank Reconciliation programs. It should not be updated after going live
• Move Bank File on Import - Bank Manager option to move the Bank file after import
• Group Sub-to-Prime Transfer Journals by Bank Account - Bank Manager option to create Sub to Prime journals
• Use Journal Posting Date to Determine Outstanding Checks - Used for Accounts Payable checks to use the Posted date instead of the Effective date
• Include Only Posted Deposits - Used for Accounts Receivable Deposits, determines if only posted transactions should pull in
• Bank Account Balance Code - Bank Manager option used for the BAI import file
• Exclude Cleared Items Date - Items before this date are excluded from Bank Reconciliation

Please use MUNIS Help for more information on each settings.

• Bank Reconciliation Settings Requiring Password
• Bank Reconciliation Settings - Exclude clear date of field reflects a date of 12 31 1899
• Duplicate Deposits - Bank Reconciliation Classic- Settings Updated Incorrectly
• Update Bank account balance code in Bank Reconciliation Settings
• Error Updating Bank Reconciliation Settings
• Munis Transactions are not pulling into Bank Reconciliation after a certain date - Bank Reconciliation Settings are NULL
• Classic Bank Reconciliation Create items is not working
• Classic Bank Reconciliation recalculate is taking a long time to process

NOTES:

• If site will reconcile GCR journal entries in Bank Reconciliation Manager the Bank Reconciliation Setting Multiple deposits per batch must be selected. 
  • If the setting is currently off and the site will be reconciling GCR entries, Create Items cannot be processed again for that bank account after the setting is changed. See: Duplicate Deposits - Bank Reconciliation Classic- Settings Updated Incorrectly
• If site does and will never post GCR journals for GL Accounts associated with Bank Codes set to Use BAI it is okay to leave the Multiple deposits per batch setting off. 
• If the site uses Adjustments/Deposits in any manner a specific date must be chosen when Classic Bank Reconciliation will stop being used and Bank Manager will begin being used. Then for a period of time both programs will be required to be used to properly reconcile a Bank code but once everything already displaying in Classic Bank Rec has been cleared going forward only Bank Manager will be needed for reconciling.
• Bank Reconciliation Manager - Set Up and Functionality.docx
• When switching between Classic Bank Reconciliation and Bank Manager please keep in mind that both programs cannot be used for the same Bank code. Please see Using cash management - Bank Reconciliation Manager versus classic Bank Reconciliation for more information.