You’re offline. This is a read only version of the page.
47
Hello everyone,
Hope someone can help. My predecessor in our company has somehow managed to reconcile our bank accounts without the bank actually being balanced - probably using "suggest lines.." rather than the actual bank statement.
The problem for me now is that I have a bunch of lines on the bank ledger entries which cancel out themselves (meaning it sums to 0) and I have no way of marking them as "closed"!
To try and solve it, I tried going a few days ahead on the bank recon, adding some lines to the bank statement side and matching them on the ledger entries, but then it claims the total balance does not match the bank statement ending balance!
In the above screenshot, I have added the statement ending balance as of the end of 1st October - on the right hand side, aaaall the lines up until 30th September sums to 0 because they are corrections etc, meaning that only the lines on the left are the correct ones that need to match the right hand side on 1st of October. But when I try to post it like this, I get the error message "Statement ending balance is not equal to total balance" BUT when I take all the lines on the left and sum the amount, it totals to the exact same as when I take every single line on the right (up to and including 1st October 2021) and sum the amount there!
Mind you, when I open a completely new bank recon, all the lines that sum to 0 (up until 30th September) are already marked as green and it stays green even after I try to remove match!
Very confusing case, I know but basically I just need all entries up to and including 30th September (or 1st October for that matter, doesn't matter - on both dates, the statement and bank entries are 100% correct) to be marked as closed 'somehow'!
Hope this all makes sense and someone can help :) Additional information: I do not have any admin rights etc in NAV! I'm "just" a user
Michelle,
You noted in your original statement that '..., all the lines that sum to 0 (up until 30th September) are already marked as green and it stays green even after I try to remove match! ... basically I just need all entries up to and including 30th September (or 1st October for that matter, doesn't matter - on both dates, the statement and bank entries are 100% correct) to be marked as closed 'somehow'!'
I would list each Check Ledger Entry or Bank Ledger Entry, depending on where its located, and list out each Document No., Entry No., Date, and Amount. This list, based on what you wrote, should be what you want closed and reconciled, from the Bank Reconciliation standpoint. Now give this list to the Partner and explain you want these entry:
Bank Ledger Entries
1. Bank Ledger Entry Open = FALSE
2. Statement Status = Closed
Check Ledger Entries
1. Statement Status = Closed
2. Open = No
Your Partner will know the fields and values to fill in to close the entries out so they are not picked up during a Bank Rec.
Hope this helps.
Steve
How would I go about doing #2 please? The guy who messed up the recons is no longer with the company so I can, thankfully, do whatever I want to fix it :)
Michelle,
UGH! I feel for you. Based on what you have written, I might recommend that you work with your Partner to either:
1) Undo the Posted Bank Reconciliation and then move forward
or
2) List all the entries that zero out and ask the Partner to clear them for you.
I would ask your Partner what they would like to do but, for me, if the Bank entries are 100% correct and I am trying to close out entries that zero out I would do #2.
Thanks,
Steve
#1
Sohail Ahmed
1,234
#2
YUN ZHU
1,006
Super User 2025 Season 1
#3
Mansi Soni
872
Share
Report
All responses (
Answers (
