37
M

Make Deposits show up as a lump sum entry on the bank rec auto match screen

Mary Carrero on 1/10/2019 5:52:31 PM
Currently if you make a deposit in the North American deposit screen, AND you use the bank rec with auto match functionality, each line in your deposit shows separate in the bank rec instead of the lump sum deposit your bank statement shows. This makes reconciliation a nightmare.

Please add the deposit as a lump sum to transaction in this method of bank reconciliation.
Category: Financial Management
STATUS DETAILS
Completed
Ideas Administrator

Business Central Team (administrator)

This feature will be delivered with wave 1, 2022 (April) with a new standard feature, Bank Deposits, which is similar to the US version's Deposits


Note: we will not make changes to the 'old' US Deposits feature, which will be deprecated, see more here soon: Deprecated Features in W1 - Business Central | Microsoft Docs


Brian Nielsen, Program Manger 
Business Central Team

Comments

M

M

RE: Make Deposits show up as a lump sum entry on the bank rec auto match screen

Ariles Z. on 8/3/2020 5:21:42 PM

Chris DeRusha, no negative side effects by disabling the Force Doc. No balance. Restrict this option to the deposit batch only. Your journal entries will always balance per batch, even if they don't balance by doc. no.

MS, you should uncheck that flag onValidate of the Journal type when it's deposit, document this and close this request.

Category: Financial Management

M

M

RE: Make Deposits show up as a lump sum entry on the bank rec auto match screen

Chris DeRusha on 6/26/2020 5:27:33 AM

Ariles Zebbar solution above (second comment) works. Is there a side effect that I am not thinking that would make unchecking "Force Doc Balance" (found in general journal template) a bad thing? I need these Lump Sum deposits!

Category: Financial Management

M

M

RE: Make Deposits show up as a lump sum entry on the bank rec auto match screen

Oleg Vinitskiy on 5/15/2020 1:38:52 PM

This is important function in the US. We need to be able to combine daily checks that were applied in AR into one or more deposits. These deposits should show up on the Bank Reconciliation as lump sums.
To summarize, there should be a screen where the user can click on individual checks/cash receipts. After posting, the sum of these receipts should show up in the Bank Reconciliation screen as lump sum.

Category: Financial Management

M

M

RE: Make Deposits show up as a lump sum entry on the bank rec auto match screen

Ariles Zebbar on 6/10/2019 3:56:06 PM

This is standard feature (not documented though). You must leave the "Force Doc. Balance" boolean unchecked on the the general journal batch choses used to post payment entries. BC will then post the amount as lump sum.

Category: Financial Management

M

M

RE: Make Deposits show up as a lump sum entry on the bank rec auto match screen

Janelle Riley on 4/30/2019 8:53:14 PM

This is a VERY significant issue in the US. I am a Business Central partner, and it is very awkward to explain this to a BC prospect. I believe that every US-based accounting system has this functionality. I strongly recommend this enhancement be pushed to the top of the list.

Category: Financial Management

M

M

RE: Make Deposits show up as a lump sum entry on the bank rec auto match screen

Andrew Wilcox on 1/10/2019 7:22:43 PM

This is a major problem and makes the bank account reconciliation a 2 day process when it should be a couple of hours.

Category: Financial Management

M

M

RE: Make Deposits show up as a lump sum entry on the bank rec auto match screen

Andrew Wilcox on 1/10/2019 7:22:05 PM

This is a major problem and makes the bank account reconciliation a 2 day process when it should be a couple of hours.

Category: Financial Management