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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

Undeposited funds to bank deposits workaround?

(2) ShareShare
ReportReport
Posted on by 83
Hello, 
We receive batch preauthorized payments to our bank.
 
The journal entries come from a different loan management system, and deposit expected payments to Undeposited Funds.
 
In QB, we used to pick up the Undeposited Funds entries, which would automatically show up in the Deposit window. This feature was amazing as highlighted the un-cleared transactions, which some sometimes meant that one was an error and had to reversed in the other system and then you could apply both the original erroneous entry and the reversal against one another to clear them. Doing deposits this way, instead of posting directly has many benefits, and then posting as lump sum can make the automation of the bank reconciliation much smoother.
 
There does not appear to be a similar feature in Business Central and one would have to do a journal entry taking it out of undeposited funds, but against what and when doing the bank deposit, you have to select the customer and have an open invoice. The open invoice would be the interest charged and a credit reducing loan balance. This method seem to not allow a quick way to see what the outstanding/ un-cleared undeposited funds, which could be an error and need to reversed.
 
How do other people deal with this and has anyone found a workaround?
Any help would be appreciated.
Thanks, 
Cedric
 
 
  • Suggested answer
    KasparsSemjonovs Profile Picture
    4,851 Super User 2026 Season 1 on at
    If You want additional postings, You can create a seperate Bank Account (Undeposited funds) with its own Bank Account Posting group, and Seperate Customer (Undeposited Funds) withs its own Gen. Bus. Posting Group and register all such payments on this Customer in this Bank account. 
    Then You can reverse each one, and post it to correct Customer/Bank account. 

    But for me it seems like double the work, but if needed, can be done like that.

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 774 Super User 2026 Season 2

#2
YUN ZHU Profile Picture

YUN ZHU 569 Super User 2026 Season 2

#3
AndrewThomas81 Profile Picture

AndrewThomas81 296 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans