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

Bank accounts list balance query in Business Central

(7) Share

Report

Posted on by CU17071028-0

Hello

In the bank accounts list of BC, after the bank direct debt to the credit card account, there should not have any amount appeared on to the bank account list but there is still having balance of $25 which should become zero into the card holder bank account. Can you please tell me how to prepare the journal to remove them.

Many thanks.

2025-07-18 10_21_09-Bank Accounts (CPS).png

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (9)

Answers (0)

Suggested answer

JUBEL THOMAS JOY 279 on at

Like (3)

Report
Hi,

Please find my suggestions to overcome this scenario

Current Situation:

To clear the remaining $25 balance in the bank account, please post the following journal entry:

Debit: Credit Card Payable – to reduce the outstanding liability

Credit: Bank Account – to remove the leftover balance and reflect the correct bank position

Recommended Action for Permanent Resolution:

Please review the existing Direct Debit setup under the Payment Method configuration in Business Central. Ensuring this is correctly configured will help prevent similar discrepancies in future transactions.

Was this reply helpful? Yes No
CC-30110434-0 12 on at

Like (3)

Report

Hi Jubel
Thank you for your information. I have just a query about your response.

If I prepare the journal what your suggestion is, the transaction will be appeared in the Bank Account Ledger Entries in Credit Card Bank reconciliation screen.

The query is how to enter the journal entry but does not appear on the credit card reconciliation screen because the bank reconciliation screen did not have this amount at all. Please advise.

Thanks.

Was this reply helpful? Yes No
Gerardo Rentería Ga... 25,225 Most Valuable Professional on at

Like (3)

Report

Hi, good day

You can record an adjustment line item in a journal. Although the ideal is to identify the reason for the difference? Could it be a bank reconciliation transaction?

Working with general journals to post directly to G/L - Business Central | Microsoft Learn

Best Regards
Gerardo

Was this reply helpful? Yes No
Suggested answer

Jainam M. Kothari 15,639 Super User 2025 Season 2 on at

Like (2)

Report

Hello,

You can create a General Journal entry that credits the bank account and offsets it against the appropriate account (such as a credit card or expense account).

This involves entering a journal line with a negative $25 amount under the bank account, and selecting a balancing account to reflect where the charge was actually made.

Once posted, this will clear the bank account balance and ensure accurate financial records.

Was this reply helpful? Yes No
CU17071028-0 34 on at

Like (2)

Report

Hi Jainam

Thank you for your information. Just clarify about your answer so I know how to fix this issue.

I think I need to have two-step journal to clear this out so it won't show up in bank account list and at this same time it won't appear in the credit card bank reconciliation .

Step 1. - to clear the bank account but it will appear in the bank reconciliation screen which I don't want to show up.
Dr Credit Card Payable $25

Cr Bank account $25

Step 2. to remove this amount that does not show up in the bank reconciliation screen, I need to clear this out.

Dr Bank account $25
Cr expenses $25

Please advise. Thanks.

Was this reply helpful? Yes No
Ahmad Subhani 585 on at

Like (2)

Report

Hi,

Maybe this will Help you.

https://www.linkedin.com/pulse/d365-bc-direct-debit-collection-recurring-sales-ahmad-subhani-kopse/?trackingId=Nvx%2FntyPQ3KoA3I5PAXsOw%3D%3D

Mark the Answer as Verified if this is Helpful.

Was this reply helpful? Yes No
Suggested answer

Mansi Soni 8,909 Super User 2025 Season 2 on at

Like (4)

Report

Hello,

To remove the remaining $25 balance from the bank account in Business Central, you can post a general journal entry to clear it. Go to General Journals, create a new line with the Bank Account as the account type and enter $25 in the credit column (if it's a debit balance), then offset it to the appropriate credit card account (G/L Account or Vendor) in the debit column. Ensure the Bal. Account Type is set correctly and post the journal. This will clear the bank balance to zero.

Hope this answer will help you!

Regards,
Mansi Soni

Was this reply helpful? Yes No
Suggested answer

Sohail Ahmed 11,148 Super User 2025 Season 2 on at

Like (2)

Report

To clear the $25 balance from the card holder's bank account, you can post a General Journal entry as follows:

1. Open the General Journals page.

2. Enter a new line:

Account Type: Bank Account

Account No.: (select the cardholder's bank account)

Amount: -25 (to reduce the balance)

3. Add a balancing line (e.g., to a suspense or clearing G/L account).

4. Post the journal.

This will remove the $25 from the bank account list. Make sure the offsetting G/L account is appropriate for tracking.

✅ Mark this answer as verified if it helps you.

Was this reply helpful? Yes No
Suggested answer

Jeffrey Bulanadi 8,760 on at

Like (1)

Report
Hi,

When a direct debit clears a credit card account, the bank account balance should reflect zero. If a residual amount like $25 remains, it usually means the transaction wasn’t fully posted or matched during reconciliation.

Here’s how to resolve it:

Create a General Journal entry to clear the $25 from the bank account.

Line 1:

Account Type: G/L Account

Account No.: Credit Card Clearing or Expense Account

Amount: Debit $25.00

Line 2:

Account Type: Bank Account

Account No.: [Your Bank Account]

Amount: Credit $25.00

This will remove the leftover balance from the bank account and offset it against the appropriate account.

If you don’t want this entry to appear in the Bank Account Reconciliation screen, make sure it’s posted directly to the G/L and not matched to a bank statement line. You can also use a separate journal batch for adjustments to keep things clean.

Before posting, run a Test Report to confirm the journal balances and doesn’t interfere with open reconciliations.

Helpful Reference
How to Work with General Journals in Dynamics 365 BC
Reconcile Bank Accounts – Microsoft Learn
Processing Bank Account Reconciliations in Microsoft Dynamics 365 BC | Kristen Hosman

If you find this helpful, feel free to mark this as the suggested or verified answer.

Cheers
Jeffrey

Was this reply helpful? Yes No