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

(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 52 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,521 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 176 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,521 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

Contextual content recommendations & SharePoint Q&A

Instantly access relevant sales materials…

Beyond the DRA Cloud Label Printing

Explore cloud-based label printing within Dynamics 365…

HR Infrastructure Customer merge

Important considerations for HR Customer migrations…

more Community News

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 223,784 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,142

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans