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

Lump Deposit Amount

(1) Share

Report

Posted on by lynnid

We receive around 100+ checks per day from 100+ different customers. What is the best way to create a lump sum amount for the deposit where it shows the total amount to deposit and matches my bank statement, and not a deposit of 100+ different checks? I have tried so many different ways and nothing is working, other than creating a "clearing account" where I deposit all of the checks to and then make a deposit to our checking for the lump amount pulling from that account.

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Nitin Verma 21,708 Moderator on at

Like (0)

Report

Hi,

If you are receiving 100+ checks for all different customer, then you have to make those entries manually before posting Cash receipt journal etc.

There is no automatic ways to put 100 checks all together.

Thanks.

Was this reply helpful? Yes No
Suggested answer

NAV_with_Narang 2,294 Moderator on at

Like (0)

Report

Hi lynnid - Are you using the US/CA/MX version of BC SaaS? If yes, you can use this feature:

https://learn.microsoft.com/en-us/dynamics365/business-central/bank-create-bank-deposits

Was this reply helpful? Yes No
Suggested answer

Gavin 2,508 on at

Like (0)

Report

Hi,

To add to the comments already added, you can enter all your cash receipts and balance to a bank account. Below I've entered two cash receipts for different customers balancing to a bank account:

This produces one bank ledger entry for the bank rec.

I also wrote about this in the blog post on the purchasing side.

https://thedynamicsexplorer.com/2020/10/30/dynamics-365-business-central-how-to-post-one-bank-account-ledger-entry-for-multiple-payment-entries-in-the-payment-journal/

Hope this helps.

Thanks

Gavin

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,597 Super User 2025 Season 2 on at

Like (1)

Report

Hi, just adding to others' reply.

The Bank Deposits feature has been added to all versions since BC20.

https://yzhums.com/23796/

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 31,428 Super User 2025 Season 2 on at

Like (0)

Report

You can use bank deposits, and then check Post as Lump Sum to yes.

Valentin Castravet

Zander ERP Services

Was this reply helpful? Yes No