Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Business Central forum / Lump deposit amounts
Business Central forum

Lump deposit amounts

(0) ShareShare
ReportReport
Posted on by JustAK6 145

Question: What is the proper method to have a deposit made up of multiple line items show up as a single lump deposit, not the individual line items on the bank account and for reconciliation?

This feels like a very basic question, but I have tried all the options I can find (Deposits, Register Customer Payments and Cash Receipts Journal), and I cannot figure it out.

My objective is to have the deposit amount that shows on the bank account match an actual deposit so the bank reconciliation process is simpler.

For example, I receive three checks from customers:

Customer A: $250.00

Customer B: $500.00

Customer C: $1,250.00

When I make the actual bank deposit, I deposit $2,000.00. On the bank statement downloaded for reconciliation, it shows $2000.00. 

However, every method I try to use results in three deposits showing on the bank account, one for each line item.

What is the method to have the bank account show a single $2,000 deposit made up of the three line items? 

Categories:
Financial Management
  • Paul_BC_Newbie Profile Picture
    Paul_BC_Newbie 35 on at
    RE: Lump deposit amounts

    Hello Carl,

    Quick question. I tried the above and I still have 3 bank ledger entries. This is what I am trying to do:

    Customer A Pays: $2000

    With payment is a processing Fee of $50

    The bank statement pulls in $1950

    I setup the receipt as follows:

    Line 1: | Doc Type: Payment| -  |External Doc number ##| - |Act. Type: Bank Act| - |Act No.: Bank # | - |Amount: $1950| - |Bal Act.: GL account| - |Bal. Act No.: Bank GL #|

    Line 2: | Doc Type: Payment| -  |External Doc number ##| - |Act. Type: Customer| - |Act No.: Cust # | - |Amount: -$2000| - |Bal Act.: Bank Act.| - |Bal. Act No.: Same bank as line 1| (I am applying this to a open invoice as well)

    Line 2: | Doc Type: Payment| -  |External Doc number ##| - |Act. Type: GL| - |Act No.: Fee GL | - |Amount: $50| - |Bal Act.: Bank Act.| - |Bal. Act No.: Same bank as line 1|

    My assumption is I'm not putting the above info in the correct order. Recently switched from QB which handled this very differently.

    I am having the same issue when im just trying to bring in 4 checks from different customers. Creates 4 bank ledger items.

    Thank you!

  • JustAK6 Profile Picture
    JustAK6 145 on at
    RE: Lump deposit amounts

    Thank  you so much! You nailed it, and I am guessing answer my same question about to do it using the Purchasing Journal:)

  • Verified answer
    Community Member Profile Picture
    Community Member on at
    RE: Lump deposit amounts

    In your cash receipt journal create 1 line with the type: Bank Account and choose the respective bank account no. and put in a debit balance of $2000

    Then create 3 lines below it with type:Customer and select each customer with each respective credit balance. You will end up with 1 entry in the bank sub-ledger and 1 in each customer sub ledger.

    Your journal batch only needs to balance overall, you don't need to use the balancing account on each line.

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 forum

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans