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

Issue posting bank reconciliation

(0) Share

Report

Posted on by kjjson

We are trying to post a bank reconciliation. The amount difference is 0, but we get a message "Remaining amount must be equal to -184831.05 in Bank Account Ledger Entry: Entry No. 10771. Current value is -38580.37" I am unsure what this error means, or how to go about correcting it so we can post the bank reconciliation. Any assistance?

Thanks,

I have the same question (0)

All responses (10)

Answers (0)

Alfredo_Iorio 1,264 on at

Like (0)

Report

Hi.

The error is about the remaining amount on a single Bank ledger entry. Therefore, you need to check the application of the bank account statement line to the ledger entry.

This could be because an existing application to a payment journal was done manually and resulted in the remaining amount being higher than the bank account statement line.

Can you share a screenshot of your Bank Rec? That might help

Was this reply helpful? Yes No
kjjson on at

Like (0)

Report

Here is a screen shot. Thank you for your assistance

Was this reply helpful? Yes No
kjjson on at

Like (0)

Report

A little more information, I looked at the entry in the bank ledger table, and the amount is the -38580.37, so I have no idea where the -184831.05 is coming from or how to update it.

Was this reply helpful? Yes No
Alfredo_Iorio 1,264 on at

Like (0)

Report

Thanks.

That was going to be my next question.

What is the applied amount to that entry in your Bank rec?

Do you have any customisation on your Bank module?

Was this reply helpful? Yes No
kjjson on at

Like (0)

Report

There are no customizations. Here is the applied information (or is there something else that is needed?

Was this reply helpful? Yes No
Dallefeld 211 User Group Leader on at

Like (0)

Report

Do you have an entry in the bank rec for -184831.05?

Was this reply helpful? Yes No
DJAGASSAR 46 on at

Like (0)

Report

Hi,

What version? I believe this error occurs when matching many bank lines to 1 bank ledger entry.

Was this reply helpful? Yes No
Suggested answer

Amit 2,559 on at

Like (0)

Report

Hi,

Adding info

https://learn.microsoft.com/en-us/dynamics365/business-central/bank-how-reconcile-bank-accounts-separately

Regards
Amit Sharma
www.erpconsultors.com
Press Yes if Info is useful

Was this reply helpful? Yes No
Suggested answer

DAnny3211 11,397 on at

Like (0)

Report

hi

look this

www.youtube.com/watch

DAniele

Was this reply helpful? Yes No
Community member 2 on at

Like (0)

Report

I'm having this exact same issue. What fixed it?

Was this reply helpful? Yes No