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.

All responses (5)

Answers (0)

Suggested answer

Valentin Castravet 24,822 Super User 2024 Season 2 on at

Like (0)

Report

Lump Deposit Amount

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

Valentin Castravet

Zander ERP Services
Suggested answer

YUN ZHU 73,696 Super User 2024 Season 2 on at

Like (1)

Report

RE: Lump Deposit Amount

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

Gavin 2,339 on at

Like (0)

Report

RE: Lump Deposit Amount

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

NAV_with_Narang 2,236 Super User 2024 Season 1 on at

Like (0)

Report

RE: Lump Deposit Amount

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

Nitin Verma 21,091 Super User 2024 Season 1 on at

Like (0)

Report

RE: Lump Deposit Amount

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.