web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Removing Unreconciled Checks

(0) ShareShare
ReportReport
Posted on by 20

I am trying to remove some old unreconciled checks - does anyone know the correct procedure for doing this?

Thanks in advance,

Natalie

*This post is locked for comments

I have the same question (0)
  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    46,619 Super User 2025 Season 2 on at
    Re: Removing Unreconciled Checks

    Why would you not Void them instead of trying to remove them?  You can remove Bank Transactions using the Remove Bank History Utility but

    1.  You have to Void them first anyhow

    2.  You lose your audit trail on those checks

  • Kristen Kasten Profile Picture
    50 on at
    Re: Removing Unreconciled Checks

    Voiding A/P checks puts the Invoices paid on those checks to OPEN status. Is there a better way to VOID an A/P check without having to VOID the invoice?

  • L Vail Profile Picture
    65,271 on at
    Re: Removing Unreconciled Checks

    When the check was written it paid a bill. Like Kristen said, the invoices would move back to the OPEN table and you would have a like amount show up on your payables trial balance. Voiding the check would also change the balance of your check register and general ledger cash account.

    Is your goal is to just have them go away without changing any balances, or do you not want to change the gl balance but DO want to change the checkbook register balance.

    If you want only to change the checkbook register and not a/p, then void the checks using the Bank Transaction Entry Screen. You'll get a warning telling you the checks did not originate in Bank Trx Entry, but you can just ignore it.

    To keep your general ledger unaffected, post both sides of the entry to the cash account - no general journal will be created if you do that.

    If you do not want to change your checkbook balance AND you do not want to change your GL balance, void the checks in bank rec with a dr and cr to the cash account. That will initially increase the cash balance in your checkbook register, but it won't impact general ledger. To reduce the cash balance to what it was before you voided the check you'll need to do a decrease adjustment to the check register. Again debit and credit the cash account to not affect general ledger.

    You would need to 'clear' the withdrawal during a bank rec to get it off of the list.

    Does this answer your question?

    Kind regards,

    Leslie

  • Kristen Kasten Profile Picture
    50 on at
    Re: Removing Unreconciled Checks

    The goal is to clear un-reconciled (stale/not cashed) checks from bank rec that are over 1 year old that were cut to vendors and adding the amount back to the cash account and crediting the original expense account.

    After I posted my response yesterday, I thought maybe I could check off the stale checks in bank rec and create an adjustment in bank rec to accomplish my goal as stated above.

    I like the idea of voiding the checks through Bank Transactions. Then the entry can be done at that time and an adjustment wouldn't need to be made in bank rec. The drawback is when looking up the check in Payables, the check does not show up as voided. When looking at Checkbook Register Inquiry, the check is recognized as voided by showing * next to the check number. You can however create a SmartList under Bank Transactions to see which checks were voided this way, but that's only if the Void Description was used at the time of void to easily identify them. Plus using a consistant Void Description would be key. For instance, 'Check not cashed' or 'Stale Check'.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans