Small and medium business | Business Central, N...

Bank Reconciliation Not showing Open Items Posted in Bank Account Subledger

(0) Share

Report

Posted on by DannyFarole

So far, I am not a fan of the bank reconciliation process in business central. The program seems clunky and unreliable.

I have an entry included on my bank statement line which is not showing on the bank account ledger entries window to be matched even though the transaction was properly booked to the bank account subledger.

Here is the entry in the GL:

Here is everything unmatched on the bank reconciliation:

Can someone please help me identify what is going on here. I have been dealing with application problems since our implementation at the beginning of the year. The bank reconciliation report is also telling me that applied entries need to be zero and are giving me errors when I try to post.

Any help would be greatly appreciated. Thanks.

I have the same question (0)

All responses (8)

Answers (0)

Sort by

Suggested answer

Dallefeld 235 User Group Leader on at

Like (0)

Report
Copy link

Link copied!

1. the GL entry screenshot does no look like standard BC. What apps are you using?

2. when you run auto match, what are you selecting for the matching fields?

3. need more information to help with the applied error, Not seeing any document numbers.

Was this reply helpful? Yes No
Suggested answer

Amit Baru 3,043 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Pls check G/L Entry again, If Bank Account no. is there, then entry is modify or delete in the Bank Account Ledger Entry.

Otherwise, Entry was posted by taking direct Bank G/l from the COA.

Regards

Amit Sharma

www.erpconsultors.com

Was this reply helpful? Yes No
DannyFarole 5 on at

Like (0)

Report
Copy link

Link copied!

Thanks for the reply. As you can see. This entry was posted to the bank subledger, not directly to the GL account. This bank reconciliation had to be reopened due to errors. It seems like when the bank rec was reopened, it did not open back this transaction. Is there a way to check?

Was this reply helpful? Yes No
DannyFarole 5 on at

Like (0)

Report
Copy link

Link copied!

Thanks for the reply Kim.

1. I am using dynamics 365 business central.

2. These are the matching fields I use:

3. there are no documents on that report. That is simply the bank account reconciliation test report.

These transactions are showing as being matched off on this report, but showing with no match from the bank reconciliation.

^^ This is from matching>match details on those transactions.

This bank account reconciliation had to be re-opened and i'm wondering if some transactions did not reopen as a result. I have checked and made sure the bank subledger balance matches the GL account balance. I just cant figure it out.

Thanks

Was this reply helpful? Yes No
Suggested answer

Dallefeld 235 User Group Leader on at

Like (0)

Report
Copy link

Link copied!

Did you execute the Suggest Lines to bring in the Bank Ledger Entries?

Was this reply helpful? Yes No
DannyFarole 5 on at

Like (0)

Report
Copy link

Link copied!

I did not at the start, however, I just tried it and nothing happened.

Thanks

Was this reply helpful? Yes No
AD-22040756-1 668 on at

Like (0)

Report
Copy link

Link copied!

based on your screenshot the bank account ledger entry is marked as reconciled. The open field does not have a check mark meaning the line is not open and it is reconciled. As its reconciled thats the reason its not appearing in your new bank reconciliation in the bank account ledger entries pane. Are you sure the bank rec. the line was reconciled on was reopened?

There are three more fields you can look at in the bank ledger entries page to verify the line is reconciled or unreconciled (these fields are not visible on the page by default so you will have to open the page inspection pane to view them) - statement status, statement no., statement line no.

Was this reply helpful? Yes No
DannyFarole 5 on at

Like (0)

Report
Copy link

Link copied!

It is showing as closed. Is there any way to reopen this transaction? - I thought undoing the bank rec would reopen it.

I am positive this line was reconciled previously. The bank rec was posted with no errors. I have a copy of the bank rec when it was posted.

Here is the transaction posted and applied from the previous bank rec.

Was this reply helpful? Yes No