News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... In Bank Reconciliation...

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

Answered

In Bank Reconciliation, what to do if the Statement Ending Balance doesn’t match with the Total Balance in Navision 2018?

(1) Share

Report

Report

Posted on by joshtechsolutions

4,549

Hi community,

I have a rather silly question.

In Bank Reconciliation, what to do if the Statement Ending Balance doesn’t match with the Total Balance in Navision 2018?

how do I go about matching it till they are balance?

Thank you!

All responses Img

All responses (5)

Answers Img

Answers (1)

CU17021654-0 2 on at

Like (0)

Report

In Bank Reconciliation, what to do if the Statement Ending Balance doesn’t match with the Total Balance in Navision 2018?

While this may appear to be understood, the way to check if the reconciliation matches the statement is to go line by line with the amounts on the left side of the reconciliation and match those to each line amount on the bank statement. Many times an import of the amounts is done and not all transactions get imported. Those transactions you have to enter into the left side manually.

Other times, no matter what I do, something is caught up in a memory cache and it just won't balance and post. When this happens I need to delete the current reconciliation and start fresh.
Verified answer

Community Member Microsoft Employee on at

Like (1)

Report

RE: In Bank Reconciliation, what to do if the Statement Ending Balance doesn’t match with the Total Balance in Navision 2018?

Josh,

Adding to the other replies...

If you G/L Bank Balance does not match the Statement Ending Balance you have to ask yourself:

1. Did the Statement and Bank G/L Balance match and post correctly last month (rule out issues from prior month)?

2. Are all the checks listed in the NAV matched and cleared from what the Statement shows?

3. Are all the deposits listed in NAV matched and cleared from what the Statement shows?

4. Have you recorded any fees and missing entries on the Statement and not in NAV?

If all the above are good, then are you sure the Ending Bank Balance entered equals the Ending Bank Balance on Statement? Is the Statement thru a month end and when you pulled (Suggest) the Checks and Deposits that date range was correct and did not include activity post the Bank Statement Ending Date?

Hope all this helps.

Thanks,

Steve
Suggested answer

Dallefeld 171 User Group Leader on at

Like (0)

Report

RE: In Bank Reconciliation, what to do if the Statement Ending Balance doesn’t match with the Total Balance in Navision 2018?

Josh is right about transactions missing but to take this a step further. But there are many questions....

Can you balance to your deposits cleared on your bank rec and the deposits cleared on your bank statement? Can you do the same for your checks?

Are you talking about the difference value in the bank rec?

Or are you saying that the balance on the bank account card doesn't match the statement ending balance? If you think about it, these rarely will match because you have transactions that have been deducted from the bank card but not yet reconciliation to the bank statements,
Suggested answer

JAngle 63 on at

Like (0)

Report

RE: In Bank Reconciliation, what to do if the Statement Ending Balance doesn’t match with the Total Balance in Navision 2018?

Are you missing some transactions? This would suggest that.
joshtechsolutions 4,549 on at

Like (0)

Report

RE: In Bank Reconciliation, what to do if the Statement Ending Balance doesn’t match with the Total Balance in Navision 2018?

Anyone can advise? Thank you!

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 292,494 Super User 2025 Season 1

#2

Martin Dráb 231,305 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans