Partial Receipt Reconciliation in cash management

Hi All,

My client is in retail sector and we have big volume of scenario where we need partial receipt reconciliation functionality with update GL account balance v.

  

In current architecture, we can split the bank statement line and reconcile the bank statement but accounting does not flow in this case to GL for split line created. In this case my Bank Statement balance and GL balance is not tallying.

For e.g

We have created receipt of 1000 in Receivables against the POS sales.

Receiving money from banks in 400, 400, 200. across week, monthly.

While reconciling splitting the bank statement line and reconcling the bank statement. Now bank statement balance and GL balance does not tally as we have not reconcile/clear the receipt of 1000.