Bank Reconciliation Statement
I have had multiple customer bring this issue up to me in the past few weeks where the bank reconciliations show a “difference”. The GL balance and bank statement balance are in agreement and there is no error when posting the reconciliation.
However, the ‘test report’ shows a difference.
The Total Balance equals the statement ending balance and the Total Difference is zero.
The g/l account balance equals the Balance.
Transaction detail which totals to the difference.
This is Microsoft’s answer at this time.
The reason there is a difference, but it still lets you post the bank rec., is because when this field is calculated on the report it starts with the total balance on the bank account and it ignores statement date. Essentially the difference of 924.00 are the transactions on the bank subledger that occurred after the statement date.
There is no way of getting rid of it other than customizing the report to change the calculation. In version 20 Microsoft updated the bank statement report and it looks very similar, you could use that one as it will not have this difference field. However, this report does not contain the outstanding transactions.
Here is a link to vote for this fix.
https://experience.dynamics.com/ideas/idea/?ideaid=8107250a-ecea-ec11-b5cf-0003ff45a05b