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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Business Central forum

Bank Deposits Summarized in Bank Acc. Reconciliation

(0) ShareShare
ReportReport
Posted on by 454

We receive a large number of cash receipts each day that are accumulated into a single bank deposit.  On the Bank Acc. Reconciliation, the Bank Statement shows a single deposit.  However, the Bank Account Ledger Entries shows each cash receipt as a separate line.  How do I accumulate all of the cash receipts into a single line in Bank Account Ledger Entries?

I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    on at

    Hi Janelle,

    The way I have dealt with this in BC is to use the Payment Registration Journal- you can find this by searching for Payment Registration. When you open it for the first time you'll choose the checkbook you are working in and a few other options. You can change this in the window at any time by choosing "Setup".

    You should see all of your open customer invoices in this window, and you have the ability to mark the "payment made" checkbox for all payments received that day. You can also change the amount received (it will default the entire invoice amount) if there is a partial payment.

    Lastly, once you've selected all of the payments received that would be a single deposit, choose "Post as Lump Payment" in the ribbon.

     

    I hope this helps!

    Brittney

  • Janelle Riley Profile Picture
    454 on at

    Thanks!  I tested this solution today and it works well.  I have only two concerns:

    1.  Auditors require that cash receipts transaction tie back to the customer's check. There is no field available to enter the check number.  How do you usually handle this?

    2.  What do you do when a company has thousands of open AR transactions?  It would seem that the list would become unmanageable in this scenario.

    Thanks for your assistance on this.

  • Verified answer
    Community Member Profile Picture
    on at

    Completely valid concerns! Right now the payment registration window doesn't seem to have the additional fields to add an external document number and it will always show all of the open AR transactions.

    It sounds like the straight "deposits" window would work better for you guys. Search for "Deposit" > Deposit.

    If you haven't used this before, you may need to navigate to "General Ledger Setup" and assign a number series to the "Deposit No." field.. and you may even need to add a Deposit number series. You can do this by searching No. Series and adding a new row for Deposit.

    Once this is ready to go though, in the deposits window just enter the header info, bank account, total amount of the grouped deposit, and then enter your cash receipts in the line items section. Remember to also Apply each cash receipt to the invoice by going to the ribbon under "Functions"> Apply entries.

  • Janelle Riley Profile Picture
    454 on at

    I have done quite a bit of testing on the Deposits functionality.  I think I might be missing something - I create the deposit, enter the total of the grouped deposit, and post the deposit, but each cash receipt comes into the bank rec separately.  Is there a setting somewhere that summarizes the deposits in the bank rec?

    Thanks so much for your help!

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard > Business Central

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans