Skip to main content

Notifications

Announcements

No record found.

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

Tracing individual entries in a bank reconciliation

(0) ShareShare
ReportReport
Posted on by 35

We are a high volume low value business and when reconciling the bank there are batches of customer entries within a single bank receipt. I am trying to find an individual entry but don't want to open up every single line on the Bank Account Statement for the month I know it was reconciled in. Is there something like a transaction list/audit trail showing all entries and where each was bank reconciled against?

  • RE: Tracing individual entries in a bank reconciliation

    Thank you Cynthia, you superstar! That is exactly what I was looking for. Tested and it works perfectly.

    It's a shame that BC takes such a long winded process but that is a different gripe...

  • Suggested answer
    RE: Tracing individual entries in a bank reconciliation

    You can use Inspect Pages and Data (Also called Page Inspection) to find information from the Bank Account Ledger Entry.

    From the Bank Account Ledger Entry, CTRL+ALT+F1. Filter Table Fields using 'state' to get a list with values for Statement Status, Statement No, and Statement Line No.

  • RE: Tracing individual entries in a bank reconciliation

    Sorry, just to clarify - I have found the BC entry, just not what transaction it was reconciled against on the bank statement.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,391 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans