fusion reconciliation for the system transaction on period and bank statment transacion next period

Summary:

oracle Fusion

There is business case for the bank statement reconciliation cash management

Ex .. system date for VISA OR master cared revenue transaction the following have been recorded on Fusion as JV

29-03-2024 1100 KD

30-03-2024 1200 KD

31-03-2024 1250 KD

The above transactions take 3 days to transferred to our bank account so bank statement will be as following

01-04-2024 1100 KD

02-04-2024 1200 KD

03-04-2024 1250 KD

What is the best practice to do the bank reconciliation for the above transaction since system transactions in March and bank statement in April on same bank statement since we are doing statement monthly full month or in case we can achieve with another way please provide