Journal entry missing from bank reconciliation classic - create items processed for a different Bank Account

Description of Issue

Journal Entry (GCR, CRP or GEN) was posted to the cash account but is not displaying in Bank Reconciliation

GL Account is assigned to more than one Bank Account record and Create items processed for a different Bank Account

Context
  • Bank Reconciliation

  • Adjustments/Deposits Reconciliation

  • Create Items

  • Bank Codes

Cause
  • Create Items process was completed on the wrong bank code. - Create items looks at Adjustments (GEN, GNI) and Deposits (CRP, GCR).

  • Create items can only pull in a journal line that has not been processed and assigned to an Bank Code/Bank Account. If a GL account is tied to multiple bank accounts, the journal line amount will only pull in for the first bank account create items is processed for. 

Resolution

Review GL accounts assigned on Bank Codes > Bank Account records to confirm that a GL account is on more than one Bank Account record.  

After the journal is posted, the create items is run in order for the item(s) to pull into a Bank Reconciliation record. If the journal doesn't show under the correct Bank code complete these steps:

  1. MUNIS > Financials > Cash Management > Bank Reconciliation > Bank Reconciliation > Adj / Dep Recon > Mass Delete, use Mass Delete to remove the items from the original bank code and Create items on the correct Bank code/Bank account. 

       2. Complete the create items process again using the correct Bank code/bank account.

From the Bank Reconciliation screen:

    1. Select the Adj/Dep Recon option in the ribbon

    2. Select Create Items and Accept

    3. A Munis popup for reviewing transactions will appear, select Yes to create items

    4. Once Items are created, hit Continue and Return back to the Reconciliation record

    5. Select the Recalculate option in the ribbon and the reconciliation amounts should update

Additional Information

Ideally a General Ledger account should only be tied to one Bank Code/Bank Account combination in Munis.

Â