Can anyone help me with preventing the checks in the unposted transactions from being reconciled in the worksheet. or at least explain why the system is allowing to reconcile checks that are still in an unposted transactions which will lead to a difference between the GL balance and the reconciliation report.
Exclude Unposted checks from worksheet in Advance bank reconciliation
Hi Frank,
this might happen for some cases in our business. sometimes we need to generate hundreds of checks and wait until the physical checks gets signed and verified then to be posted.
anyway, even though this might be a human mistake to not post the Journal after generating the checks.
my point is if this is the initial design for the organizations with real time reconciliation as Hana Xue & Avadh Shah said, so why this is can't be turn off for the organization with a monthly reconciliation.
I am still seeing this weird from accounting perspective to reconcile a transaction that is still not written in my GL.
Exclude Unposted checks from worksheet in Advance bank reconciliation
Hi, This is an internal design of the system, which may be to adapt to more scenarios. When an enterprise needs real-time reconciliation information, it may not wait for all transactions to be posted before reconciliation.
For better use of unused check, you need to customization
Exclude Unposted checks from worksheet in Advance bank reconciliation
thanks all for your replies, but for me It still confusing , what is the point from reconciling a check that still not posted which means that the GL balances is still NOT affected, so the reconciliation cover balance is different from the GL balance. So in our case that means that the reconciliation will never be matched.
Exclude Unposted checks from worksheet in Advance bank reconciliation
Hi, This is an internal design of the system, which may be to adapt to more scenarios. When an enterprise needs real-time reconciliation information, it may not wait for all transactions to be posted before reconciliation. As rajborad says, you need to customize it to suit your needs. Best Regards, Hana
Exclude Unposted checks from worksheet in Advance bank reconciliation
Hi,
Need customization to achieve your requirement but make sure that it does not affect the standard functionality because it is a standard process, Maybe Microsoft has a logic behind that.