You’re offline. This is a read only version of the page.
We are trying to void a check no. 506321 that was issued in Dec 19, 2013 but it was not cleared yet as of 01/20/14 - when we tried to void the check - we got an error message "Statement Status must be open in Check LedgerEntry Entry No. = 9658" - when we looked at the check ledger entries for this bank to find the check - there is a statement no. of 01022014 and the Open Field is checked. When we looked at the Bank Recon for this bank - we see this check is part of the Check List but it has not been clear yet - so under this assumption - we should be able to void the check# 506321 but we cannot do it - somehow it seems to think it is tied to the bank recon statement that was done on 01/02/2014 and will not let us void this check. How do I open the Bank Recon Statement but if I do that, will this cause an issue with the bank recon we did for the cleared checks as of 01/02/2014?
What is the best way for us to handle this issue?
*This post is locked for comments
[quote]Regulation CC states when deposits of various types must be made available to your customers, measured in business days following the banking day on which the deposit is made. Business days are defined as Mondays through Fridays except federal holidays. A banking day is any business day (up to the bank's cut-off hour) when your institution is open for substantially all of its banking activities. All references to the number of days to funds availability in this guide indicate maximum time limits for making funds available; your institution may provide earlier availability of funds if it chooses and may extend the time when funds are available up to periods set by Regulation CC on a case-by-case basis. [/quote]
US law requires the check value to be credited within days, regardless of whether the account has been confirmed to be active and to have sufficient funds available.
That is why a check can be deposited and then days later the deposit is reversed when the account is found to be closed or to have insufficient funds.
This bank reconciliation process as designed is pie-in-the-sky full of overweening optimism.
If the entry is reconciled that means you have accepted that your bank statement entry and system entries are tallied. Once the entry is reconciled you will not be able to void or reverse any entry. Best option you have is to post a separate entry to reverse the cheque.
As Alex said if the account was closed how did the cheque got cleared?
I also have a similiar problem. The check cleared the account in December so I was able to post my bank rec. A few days later, the check was returned because the account was closed. I'm trying to void the check but I can't. Thanks
Thank you this also helped me solve a similar problem to what the original posted had.
We have the user post the open Bank Reconciliation and it is now fine. Thanks for the help.
Dear Rob:
I have discussed this with our accounting dept. They will post the unposted bank rec first. This would solve the issue of the cheque entries being "locked" for those unclear checks.
We assume that the bank rec will be completed and posted right away. I agree that there should be some changes made to avoid this issue.
Thanks for your help on this.
Hi Berlinda,
With a large number of cheque entries it's probably easier to delete the unposted bank rec., void the cheque(s), and the recreate the rec. This is one of the downsides with NAV's bank rec. process in that the cheque entries are essentially "locked" when they are brought into a bank rec. worksheet.
I guess Microsoft assumed most users would be completing and posting the reconciliation right away, but in practice I've seen a lot of clients who prefer to start the rec. at the beginning of the month and then continually work on it for a period of time. In fact, there is a suggestion submitted on Microsoft Connect from another user to change this behaviour so that cheques in unposted bank rec.'s may be voided without having to go through this workaround.
Regards,
Rob
Dear Rob:
Yes, It seems we have an active/open bank reconciliations that have not been posted yet.
I have seen this check on it but I also seen a lot of other checks that are not cleared yet on the Open bank reconciliation - close to around 600 entries.
Would be it be better to post the open bank reconcilation rather than deleting each one of those uncleared checks ?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (