Skip to main content

Notifications

Dynamics 365 Community / Forums / Finance forum / Exclude Unposted check...
Finance forum
Suggested answer

Exclude Unposted checks from worksheet in Advance bank reconciliation

editSubscribe (1) ShareShare
ReportReport
Posted on by Ehab Elshamy 2
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.
Categories:
Other
Financial Management
  • Ehab Elshamy Profile Picture
    Ehab Elshamy 2 on at
    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.
  • Suggested answer
    Avadh Shah Profile Picture
    Avadh Shah 39 on at
    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

    Thank you,
    Avadh Shah
  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 3,505 Super User on at
    Exclude Unposted checks from worksheet in Advance bank reconciliation
    Why are you not posting your payment journals as soon as the payments are generated?
  • Ehab Elshamy Profile Picture
    Ehab Elshamy 2 on at
    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.
  • Hana Xue Profile Picture
    Hana Xue Microsoft Employee on at
    Exclude Unposted checks from worksheet in Advance bank reconciliation
    Hi,
    If the answer is helpful, please mark it as verified.
    Best Regards,
    Hana
  • Suggested answer
    Hana Xue Profile Picture
    Hana Xue Microsoft Employee on at
    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
  • rajborad Profile Picture
    rajborad 170 on at
    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.
  • Suggested answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 3,505 Super User on at
    Exclude Unposted checks from worksheet in Advance bank reconciliation
    Have the checks been generated and mailed?  If so, they are legitimate open checks to be reconciled. 

Helpful resources

Quick Links

Take the Community feedback survey!

Answer this brief 15-question survey about your Community experience…

Demystifying Copilot: Service Edition with Sundar Raghavan

Sundar answers more questions about Copilot for Service...

Dynamics 365 Business Central vs Finance and SCM

Take a look at the key differences between Business Central and…

more Community News

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,375 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 223,308 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,140

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans