web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

How Match Imported Bank Transactions with G/L Entry

(0) ShareShare
ReportReport
Posted on by 90

I've manually entered our payroll into a G/L. I have two bank transactions: one for wages, and one for taxes. In the Payment Reconciliation Journal how do I match the transactions? 

I have the same question (0)
  • Suggested answer
    Brian Wick Profile Picture
    on at

    Hi Steve,

    Without knowing the specifics...I assume that your bank statement has just 2 bank entries/deposits that imported in.  And in BC you have multiple, individual entries that represent your employee payroll.  The Apply Automatically is a 1:1 match, so you will have to match manually.  Then you can only match one application to one statement line.  At that point you can click Transfer Difference to Account which will create a new line with the remaining transaction amount that can be applied.  So if the statement amount for one of the entries was 1000.00 and you manually matched 400.00, you can Transfer the Difference to Account which will insert a new line for 600.00.  You may want to click 'Remove Applications' on the newly inserted line, and then proceed with Applying Manually.  It will be a manual process.

    The other option is to use Auto Bank Rec where you import in your bank statement.  There you have a 1:Many match where you highlight your statement entry (left side) and match to many bank ledgers.  Manual process there too. I hope this helps and I understood the issue.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,135

#2
YUN ZHU Profile Picture

YUN ZHU 733 Super User 2025 Season 2

#3
Sumit Singh Profile Picture

Sumit Singh 612

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans