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

Transferring Outstanding Checks from GP to BC

(6) Share

Report

Posted on by BC101

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?

All responses (7)

Answers (0)

Sort by

Suggested answer

Gavin 2,510 on at

Like (4)

Report
Copy link

Link copied!

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:

Preview shows this

Hope this helps.

Thanks

Gavin
DLDlutavia 14 on at

Like (4)

Report
Copy link

Link copied!

I agree with Gavin except you want the debit to the G/L account and the credit to the Bank Account.
Suggested answer

YUN ZHU 103,227 Super User 2026 Season 2 on at

Like (3)

Report
Copy link

Link copied!

As far as I know, this can only be adjusted manually via General Journal.

When you post Bank Accounts, be sure to check the GL Account associated with it first.

Hope this helps as well.

Thanks.

ZHU
Suggested answer

Jeffrey Bulanadi 9,128 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hi,

When migrating from GP to BC, it’s common to transfer opening balances without the underlying transaction detail, but that can complicate bank reconciliation if outstanding checks aren’t reflected in the ledger.

The cleanest way to bring those outstanding checks into BC without offsetting your opening balance is to use a General Journal that posts both the debit and credit to the same bank GL account. This creates Bank Account Ledger Entries for reconciliation, while keeping the GL impact neutral.

Here’s how to approach it:

Create a General Journal batch

For each outstanding check, enter a line with:

Account Type = Bank Account

Account No. = your bank account

Amount = negative value (e.g., -100.00)

Bal. Account Type = G/L Account

Bal. Account No. = same GL account linked to the bank account

This setup creates a bank ledger entry for each check, which will appear during reconciliation, but the debit and credit cancel each other out in the GL. You can also use Configuration Packages if you need to import multiple lines efficiently.

Helpful Reference
How to Enter Opening Bank Balances in BC – ERP Software Blog
Reconcile bank accounts – Microsoft Learn
Bank Account Ledger Entries and Setup – Microsoft Learn

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

Cheers
Jeffrey
Suggested answer

Rishabh Kanaskar 6,231 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi,

In Business Central, the recommended approach is:
1. Do not post directly against the opening balance, as that will offset it.
> Use a “Journal” approach:
> Open a Payment Journal or General Journal.
> Enter the outstanding checks as payments against the original vendors/customers.
> Set the Bank Account correctly and post.

2. Reconcile afterward:
> These journal entries will appear in the Bank Reconciliation as outstanding items.
> When the checks clear, mark them as reconciled.

This method ensures that the opening balance remains intact and outstanding checks are represented properly in BC and can be tracked in future reconciliations.
No offsetting of opening balances is required.

Thanks

Rishabh
Suggested answer

Sumit Singh 11,805 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Hi,

You need to create the bank ledger entries to handle the outstanding checks without affecting Chart of accounts. Hence, Bank account posting group GL code and balancing account GL code should be same while creating the General journal entries. You also need to enable the direct posting for the time-being and then after posting disable it. This process will created Bank account ledger entries without having any impact on Chart of accounts.

Please try first over Sandbox environment and once satisfied, replicate over Production environment.

Please mark "Verified" if it helps.
Suggested answer

Nimsara Jayathilaka. 5,137 Super User 2026 Season 1 on at

Like (5)

Report
Copy link

Link copied!
Hi

The proper way is Use the Payment Journal with a clearing account it gives proper ledger entries for checks while keeping your opening balance intact.

You can try given steps also

Enter manual payment journals – Post each outstanding check using the Payment Journal with the same bank account, but use a clearing or suspense account (not the bank account offset). This records the checks in the Bank Account Ledger without changing the opening balance.

Use General Journal with balancing account – Create entries for each outstanding check in the Bank Account and offset them to a temporary G/L account so total impact on the bank balance remains zero.

Import via bank reconciliation adjustments – If there are many transactions, consider importing them as bank reconciliation lines marked as “Outstanding,” but this method won’t create ledger entries—only helps in reconciling.

Thanks

Nimsara