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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

Bank Rec Matching Many Statement lines to One Ledger Entry

(0) ShareShare
ReportReport
Posted on by 5

My company has an online payment portal similar to Bill.com that deposits to our bank account daily. At the end of the month I make a single journal entry to book the lump sum of all of those payments rather than making an entry for each individual day. 

So for example if I receive 30 deposits of $100 I would book a single journal entry for $3000 instead of 30 different entries. This is an issue on the bank recs because I can not seem to match all of the individual Bank Statement lines to a single Ledger Entry. Is this possible to do and if not what would the best solution be?

I have the same question (0)
  • Suggested answer
    Nitin Verma Profile Picture
    21,812 Moderator on at

    Hi,

    As I know we dont have Many-to-One matching available in Bank account reconciliation, In that case I think you have to post 30 different entries, so that you can match your Bank account ledger entry individually with your bank statement entry.

    Thanks.

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 690 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 545 Super User 2026 Season 1

#3
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 304 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans