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

Credit card bank reconciliation query in Business Central

(4) Share

Report

Posted on by CU17071028-0

Hi Expects

Currently, a credit card holder bank reconciliation screen has one amount of $300 in Bank Account Ledger Entries, however, I do not want this amount to appear on the bank Account Ledger side of the bank reconciliation. In saying that I would like to increase the same amount of Credit card GL account but not in bank reconciliation screen. Can anyone have any suggestion how to address this issue. I don't know how to solve this matter.

Many thanks.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

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

Like (1)

Report

Hello,

You can post a General Journal entry that reclassifies the amount from the bank account to the Credit Card G/L account without involving the bank ledger.

This ensures the amount is correctly reflected in the credit card account while keeping it out of the bank reconciliation screen.

Be sure to exclude the bank account from the journal lines and document the adjustment clearly for audit purposes.

Was this reply helpful? Yes No
Suggested answer

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

Like (4)

Report

Hello,

In Business Central, if you want to remove the $300 from appearing in the bank reconciliation screen but still reflect it as an increase in the credit card GL account, the correct approach is to reverse the Bank Account Ledger Entry (e.g., using a general journal to debit the bank and credit a suspense or clearing account), then post a separate journal entry directly to the credit card GL account bypassing the bank. This way, the amount no longer shows in the bank reconciliation, but your credit card liability is still increased properly.

Hope this answer will help you!

Regards,
Mansi Soni

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

Like (2)

Report

Hi Mansi and Jainam

Thank you for your information and help.

Just clarify the step 2 part - how to do the separate journal side.

Step 1. I understand how to reverse bank ledger. Step 2, I don't know how to post a separate journal entry directly to the credit card GL account bypassing the bank.

Step 1 Reverse bank ledger - this way will remove the bank account reconciliation.

Dr Bank account - Card holder account
Cr Credit card suspense account.

Step 2 - How to increase credit card GL account - what is the Dr side. Is it increasing the Expense account?
Cr credit card suspense account

Dr Expense???

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

Like (0)

Report

Hi

You could analyze the use of a bridge account to help maintain traceability of the adjustment.

I think that entry, if I understand the problem correctly, would be between the credit card account and the corresponding expense account.

Best

GR

Was this reply helpful? Yes No
Suggested answer

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

Like (1)

Report

Hi! What you're describing sounds like you want to record the $300 transaction on the credit card G/L account without affecting the bank reconciliation view.

Here’s a simple suggestion to handle this:

Post a General Journal entry that credits the credit card G/L account (e.g., 300) and debits an expense or clearing account (depending on your setup).

Make sure the Bank Account is not selected in the journal line — this way, it won’t appear in the Bank Account Ledger Entries and won’t show up in the bank reconciliation screen.

This ensures the value is reflected in the G/L without interfering with the bank rec process.

✅ Mark this answer as verified if it helps you.

Was this reply helpful? Yes No
Suggested answer

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

Like (1)

Report

For Step 2, yes — you're correct. Since you want to increase the credit card G/L account without affecting the bank reconciliation, you can create a G/L journal entry like this:

Debit the appropriate expense account (e.g., Travel, Office Supplies — whatever the $300 was for).

Credit the Credit Card G/L account to show that it was used for payment.

This way, the amount is properly recorded as an expense, and it increases the credit card balance — without showing up in the bank ledger again.

Hope that clears it up!

✅ Mark this answer as verified if it helps you.

Was this reply helpful? Yes No