Version?

Service packs?

Data integrity for bank services OK?

version is sage 300 erp 2012

I am not sure about the service pack

data integrity for bank services is ok i tihnk

Don't think, find out.

The data integrity for bank services is perfectly fine. I have finished my bank reconciliation. The one problem i have is the variance between the outstanding withdrawals.

As the summary withdrawals balance is greater than the checks listed in the reconciliation tab, it is likely that some withdrawals may have been cleared to a future period. In the current reconciliation period, those are still accounted for as outstanding withdrawals in the summary but the checks will no longer appear in the reconciliation tab once is it has been reconciled and posted. When the next reconciliation matches that future period, the summary withdrawals balance should reconcile with the checks listed in the reconciliation tab unless there are no other transactions cleared to a future period.

Thank you for your input!

After reviewed all the transactions, I found out that there are checks were reversed out due to wrong date. Can this be the reason? The difference between the withdrawals outstanding is the total amount of checks got reversed.

First we did the checks in misc payment. Then we reversed out the checks payment but not the invoices(mistake 1). Then we did the misc payment again.

I think the difference could be because we reversed out the check on date 6/2/2014 and we are doing bank reconciliation for 4/2014 and 5/2014

Yes

Are there anyway that I can fix this problem?

No, the best is to let it be, it will flush itself out of the system. Trying to fix it will only screw things up more.

Remember that when you return checks you should always use the original check date as the return date, or at least use a return date in the same period as the check date.

thank you very much for your words!

Clearing to a future period is accounted for by bank services as expected. Either wait for the future period to arrive for the balances to reconcile or restore from backup. It would take more work to restore from backup so it would be reversed to the current period but may also have to re-enter transactions in different modules already entered after the backup.

I think the best way for now is to post this reconciliation for 4/2014 and 5/2014.

Later, when I start the 6/2014 bank reconciliation, it will eventually flush out the system.

Am I right?