web

You’re offline. This is a read only version of the page.

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,947

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!

I have the same question (0)

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.

Was this reply helpful? Yes No
Verified answer

Community Member 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

Was this reply helpful? Yes No
Suggested answer

Dallefeld 193 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,

Was this reply helpful? Yes No
Suggested answer

JAngle 119 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.

Was this reply helpful? Yes No
joshtechsolutions 4,947 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!

Was this reply helpful? Yes No

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

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

#1

Rishabh Kanaskar 4,132

#2

Nimsara Jayathilaka. 3,615

#3

Sumit Singh 2,912

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans