Friday 15 January 2016

AR Receipt and Bank Statement Reconciliation

When the AR Receipt is Created and Applied to the Invoice based on the receipt class setup for the receipt method used in the AR transaction the Receipt status will change to Remitted or cleared.
If the Receipt class Matching setup is labelled as By Matching : In that case the Cash receipt status will change to Remitted,
The cash receipt needs to be reconciled against a bank statement to clear it off.

In order for this to happen we need to

  • make an entry for the bank statement
  • Select the receipt from the list of available receipts available for reconciliation
  • Once the bank statement is reconciled with the receipt the receipt status changes to Cleared and the bank statement line is reconciled.
Below SQL can be used to find out details of a AR cash receipt being reconciled with a bank statement


select cba.BANK_ACCOUNT_NAME,cba.bank_account_num,csh.statement_number,csl.STATUS,csl.amount,csl.trx_type,acr.receipt_number,arm.name
from CE_STATEMENT_HEADERS csh,
     ce_statement_lines csl,
     ce_bank_accounts  cba,
     ce_statement_reconcils_all csr,
     apps.ar_cash_receipts_all acr,
     ar_receivable_applications_all ara,
     ar_receipt_methods arm,
     hr_operating_units hou,
     AR_CASH_RECEIPT_HISTORY_ALL ach
where csh.STATEMENT_HEADER_ID = csl.STATEMENT_HEADER_ID
and     csh.BANK_ACCOUNT_ID = cba.BANK_ACCOUNT_ID
and csl.STATEMENT_LINE_ID = csr.STATEMENT_LINE_ID
and csr.reference_id = ach.CASH_RECEIPT_HISTORY_ID
and csh.statement_number = :statement_number
and bank_account_num = :bank_account_num
and csr.REFERENCE_TYPE = 'RECEIPT'
and acr.cash_receipt_id = ara.cash_receipt_id
      and acr.receipt_method_id = arm.receipt_method_id
      and ara.org_id = hou.organization_id
      and hou.name  = :operating_unit
      and receipt_number = :receipt_number
      and acr.cash_receipt_id = ach.cash_receipt_id  

1 comment:

  1. Nice post! Cheque is an important means of payment. Cheque is used for paying a large sum of money. It is the most widely used tool for drawing money from the bank.
    Read More

    ReplyDelete