Skip to main content

Notifications

Announcements

No record found.

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

Bank Rec Matching Many Statement lines to One Ledger Entry

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?

  • Suggested answer
    Nitin Verma Profile Picture
    Nitin Verma 21,091 Super User 2024 Season 1 on at
    RE: Bank Rec Matching Many Statement lines to One Ledger Entry

    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

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 Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans