Journal Line Bank Statement Reconciliation

Many times business wants to reconcile a Journal with a bank statement line but it might happen that the Journal Line is not available in the list of Reconcilable lines  , Below are some of the simple checks you can perform to find the reason why the Journal is not available

• Is the Journal Line Posted
• Is the Journal line account same as the Cash Account on the bank account setup
• If you have entered any search criteria in the Find screen which might not be matching the Journal you are expecting to reconcile
• The Journal has not been already reconciled with a bank statement . In Order to check if a Journal line is reconciled against a bank statement  , use the below SQL

          SELECT Count(1)

              FROM ce_statement_lines sl, 

                          ce_statement_reconcils_all sr, 

                          gl_je_headers jh, 

                          gl_je_lines jl ,

                          ce_statement_lines sh

            WHERE 1=1

                 AND sr.statement_line_id=sl.statement_line_id

                 AND sr.je_header_id=jh.je_header_id

                 AND jh.je_header_id=jl.je_header_id

                 AND sr.reference_id=jl.je_line_num

                AND sr.reference_type='JE_LINE'

                AND sl.statement_header_id = sh.statement_header_id

                AND gjh.name = :journal_name

Hope this Helps

Thanks