Finance | Project Operations, Human Resources, ...

Bank transaction not appearing on the check register that was not posted in bank transactions

(5) Share

Report

Posted on by MD-25021902-0

JE's posted through the general journal module related to a bank account, as opposed to the bank transaction module, are NOT appearing on the check register that is generated from the bank reconciliation module. Any one know why. If not, how do we record to ONLY on the check book register, and not on the GL?

Categories:

Microsoft Dynamics GP

I have the same question (0)

All responses (3)

Answers (0)

Joseph Markovich 3,972 on at

Like (1)

Report

Bank transaction not appearing on the check register that was not posted in bank transactions

Hello:

Journal entries only post to the GL, they don't post to the Checkbook transaction history. Honestly, you really need to change your GP setup to NOT allow direct posting to your cash accounts from the GL.

All of the cash transactions should be handled through the appropriate modules: Sales for cash receipts that will then flow through to bank deposits, Purchasing for payments and refunds and Financial for bank transactions (deposits, withdrawals, transfers).

Otherwise, all of the checkbook balances never get updated and then you have a mess for bank rec.

Joe

Was this reply helpful? Yes No
Suggested answer

Pierre D. 42 on at

Like (0)

Report

Bank transaction not appearing on the check register that was not posted in bank transactions

Hi

If you want to avoid that situation in the future, you need to change the setup of the GL Account, you need to uncheck the Allow Account Entry box.

This will remove the possibility for any user the use that GL in JE Entries, only transactions using the Checkbook ID (Bank Transactions in the Financial module, Cash Receipts in the Sales modules or Payments Transactions in the Purchasing module) will be able to affect this GL.

In Dynamics GP the bank reconciliation is done through the banking module transactions, not the GL transactions (there are 3rd parties solutions that would allows you to do that). The easiest way to enter in the banking module the "missing" transaction would be to do a bank transaction and use the same GL Account for the debit and the credit (don't forget to temporarily check the box in your GL Accounts setup) and then post the transaction, the banking module will now have the transaction and the impact on the GL balance will be null.

Hope it helps

Was this reply helpful? Yes No
Suggested answer

Holly Huffman 6,522 Super User 2025 Season 2 on at

Like (1)

Report
Bank transaction not appearing on the check register that was not posted in bank transactions

Good morning, afternoon, or evening depending on your location!

This issue occurs because journal entries (JEs) posted through the General Journal module don’t automatically appear in the check register generated from the bank reconciliation module. The reason is that General Journal entries don’t create bank transactions in the same way as entries posted through the Bank Transaction module.

Why This Happens:

General Journal entries affect the GL (General Ledger) but don’t create a corresponding bank transaction.

The Bank Transaction module is designed to track transactions specifically for bank reconciliation, ensuring they appear in the check register.

The check register pulls data from bank transactions, not directly from the GL.

How to Record Transactions in the Check Register Without Affecting the GL:

Use the Bank Transaction Module Instead of General Journal

Navigate to Cash and Bank Management > Bank Transactions.

Post the transaction directly in the Bank Transaction module instead of using a General Journal entry.

Manually Create a Bank Transaction for the JE

If the JE was already posted, you can manually create a bank transaction to ensure it appears in the check register.

Go to Bank Transactions > Create New Transaction and enter the details.

Use a Separate Posting Layer for Bank Transactions

If you need to record transactions only in the check register and not in the GL, consider using a special posting layer.

Navigate to General Ledger > Setup > Posting Layers and configure a layer that doesn’t affect financial reporting.

Check Bank Account Setup

Ensure that the bank account is properly linked to the transaction type in Cash and Bank Management.

Go to Bank Accounts > Setup > Posting Profiles and verify the settings.

Please note: I teamed up with CoPilot AI to research and craft the best response to your question!
Hope this helps some!

Was this reply helpful? Yes No