Troubleshooting Reconciliation Issues

  1. Verify all your checks.
    • Ensure all the checks from the statement have been cleared in EJ
    • Ensure there are no checks cleared in EJ that are not on the statement
    • Ensure the amount of each check matches the amount in EJ
  2. Verify all your deposits.
    • Ensure all of the deposits from the statement have been cleared in EJ
    • Ensure there are no deposits cleared in EJ that are not on the statement
    • Ensure all of the amounts from the bank statement match your spreadsheet and EJ
    • Review to see if there are any bank charges on your statement          
    • If any of your Ingencio, Defendant Access or eFile amounts do not match the bank, log into Paymentech and see if you have any chargebacks or returns.  Make sure to process these.  It is recommended to check these weekly and at end of month so they can get processed in the current month.
  3. Review your bank statement for any other debits to your account.
    • Verify all NSF’s have been processed
    • Verify any other debits have been processed
    • Review to see if there are any bank charges on your statement          
  4. Ensure your Bank Reconciliation worksheet is filled out.
    • Enter all of your deposits from EJ (recommended to do this daily)
    • Highlight each item once you have verified the amount matches the bank statement (if it is a combination of 2 deposits – make note of that on your worksheet)
    • In the bottom section of the worksheet:
      • Enter the amount from the bank statement
      • In the 2 lines below that, enter any deposits (use a negative) that are in the bank but are either not in EJ or you are unable to clear them in EJ (possibly they are part of a larger deposit that not all of the transactions have hit the bank account)
      • In the 2 lines below that, enter any items that are deducted from your bank account but not processed in EJ yet (possibly an NSF that wasn’t processed)
    • Use the amount on the next line “Amount to use in EJ” to enter when you go to the reconciliation screen in EJ
  5. If you are still unable to reconcile, please submit an eService ticket.  
    • From the Reconcile button, make sure you have cleared all deposits and checks that you have verified with the bank account and hit save at the bottom
    • Include a copy of your bank statement
    • Include a copy of your reconciliation worksheet
    • Include the amount you are off
    • Include any potential issues you are aware of