Skip to main content

Notifications

Announcements

No record found.

Small and medium business | Business Central, N...
Unanswered

Transferring Outstanding Checks from GP to BC

(0) ShareShare
ReportReport
Posted on by 20

Hello,

We recently transferred over Bank monthly opening balances into business central and did not include the line details of each transaction. We now have outstanding checks from the previous month that were included in the opening balances but not posted in the bank account ledger entries within Business Central. When it comes to having these outstanding checks in the Bank reconciliation, what is the best route to get these outstanding checks into the bank account ledger entries without offsetting the opening balance?

  • Suggested answer
    Gavin Profile Picture
    Gavin 2,339 on at
    RE: Transferring Outstanding Checks from GP to BC

    Hi,

    I'd create a General Journal with one line as the bank account and the balancing entry as the bank account GL Code. This way the debit and credit will be in and out of the GL account but you'll get a Bank Account Ledger Entry to reconcile in the bank.

    For example this would produce a Bank Account Ledger Entry to reconcile of £100.00 but would post the debit and credit to the same bank GL account:

    pastedimage1684739465118v2.png

    Preview shows this

    pastedimage1684739481625v3.png

    Hope this helps.

    Thanks

    Gavin

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,391 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans