Finance | Project Operations, Human Resources, ...

Exclude Unposted checks from worksheet in Advance bank reconciliation

(1) Share

Report

Posted on by Ehab Elshamy

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.

I have the same question (0)

All responses (8)

Answers (0)

Sort by

Suggested answer

Frank Hamelly | MVP... 46,633 Moderator on at

Like (0)

Report
Copy link

Link copied!

Have the checks been generated and mailed? If so, they are legitimate open checks to be reconciled.

Was this reply helpful? Yes No
Raj Borad 1,578 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Suggested answer

Hana Xue Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Hana Xue Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi,

If the answer is helpful, please mark it as verified.

Best Regards,

Hana

Was this reply helpful? Yes No
Ehab Elshamy 2 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Frank Hamelly | MVP... 46,633 Moderator on at

Like (0)

Report
Copy link

Link copied!

Why are you not posting your payment journals as soon as the payments are generated?

Was this reply helpful? Yes No
Suggested answer

Avadh Shah 52 on at

Like (0)

Report
Copy link

Link copied!

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

Thank you,
Avadh Shah

Was this reply helpful? Yes No
Ehab Elshamy 2 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No