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

Community site session details

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

How to get cash receipt batches to hit bank as a total batch amount instead of separate entries

(0) ShareShare
ReportReport
Posted on by 42

Hi all,

I'm sure this is very basic but I have been looking for over an hour and can't find an answer. Every day I enter all of the incoming customer payments into a cash receipts journal batch (called CHECKS). How can I have all of those transactions hit the bank account as one entry when I do the bank rec? Right now if I deposit 10 checks in my cash receipt journal batch it's showing as 10 separate entries so it's a pain to reconcile. in SL those payments showed as one amount & it was much easier but I'm unsure how to do this in BC. I have looked at my template & I don't see a way to make it hit the bank rec as a batch there. Thank you!

I have the same question (0)
  • Suggested answer
    JAngle Profile Picture
    123 on at
    RE: How to get cash receipt batches to hit bank as a total batch amount instead of separate entries

    Alter the way you balance the journal. Have the bank account balancing line as a sum of the customer payment amounts. This would mean ignoring the balancing account fields.

    This is a more traditional use of a journal as you have rows for credit and debit entries rather than settling it on one row.

  • Suggested answer
    Moosiah22 Profile Picture
    42 on at
    RE: How to get cash receipt batches to hit bank as a total batch amount instead of separate entries

    Thanks Josh! this method works great.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

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

#1
Sumit Singh Profile Picture

Sumit Singh 2,674

#2
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 2,580

#3
YUN ZHU Profile Picture

YUN ZHU 2,115 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans