How can I retrieve the correct number for Balance Last Statement and the Statement Ending Balance

(5) Share

Report

Posted on by joshtechsolutions

4,971

Hi Community,

I'm starting a new Bank reconciliation in a new company.

In Bank Reconciliation, the Balance Last Statement and the Statement Ending Balance is 0.00, may I know how can I retrieve the correct number here if this is the first time i'm doing Bank Reconciliation?

Please show me the step by step to get the number if possible.

Thank you.

Categories:

Dynamics 365 Business Central

Microsoft Dynamics NAV

I have the same question (0)

All responses (9)

Answers (1)

Suggested answer

Jainam M. Kothari 15,631 Super User 2025 Season 2 on at

Like (2)

Report

Hello,

Balance Last Statement = This represents the balance from the last posted bank reconciliation in the BC. The system will automatically retrieve this balance. But if you are doing first time Bank Reconciliation Process then you can Manually Enter the same.

Statement Ending Balance = This is the ending balance of the current bank reconciliation, reflecting the bank statement's ending balance.

Lets take an Example.

Currently i am doing the Bank Reconciliation for the Month of January 2026.

Balance Last Statement = Balance based on Last Posted Bank Reconciliation i.e. Statement Ending Balance as on 31-12-2025. But if you are doing first time Bank Reconciliation Process then you can Manually Enter the Balance of Bank Statement as on 31-12-2025.

And Statement Ending Balance = Bank Statement Ending Balance as on 31-01-2026.

I Hope your query will be resolved.

Was this reply helpful? Yes No
joshtechsolutions 4,971 on at

Like (3)

Report

Hi Jainam M. Kothari ,

I don't have a last posted bank reconciliation because this is the first time i am doing bank recon in a new company.

So if I never did a bank recon before, I don't think I will have a last posted Bank Reconciliation. if you can advise.

Thank you !

Was this reply helpful? Yes No
Suggested answer

Jainam M. Kothari 15,631 Super User 2025 Season 2 on at

Like (2)

Report

Hello,

Sure, i forgot to mention that if you are doing first time Bank Reconciliation Process then you can Manually Enter the Balance of Bank Statement as on 31-12-2025.

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 20,275 Super User 2025 Season 2 on at

Like (3)

Report

Yes if you are doing it first time then you have to enter data manually.

Hope this helps: https://learn.microsoft.com/en-us/training/modules/bank-reconciliation-dynamics-365-business-central/

Check this video as well: it will help you to clear concept: https://www.youtube.com/watch?v=ygzx0mN5800&pp=ygUnYmFuayByZWNvbmNpbGlhdGlvbiBpbiBidXNpbmVzcyBjbmV0cmFs

https://www.youtube.com/watch?v=ygzx0mN5800

Was this reply helpful? Yes No
Gerardo Rentería Ga... 25,157 Most Valuable Professional on at

Like (3)

Report

Hi, good day
I hope this can help you, and give you some hints.Solved: Bank Reconciliation

Best Regards
Gerardo

Was this reply helpful? Yes No
Suggested answer

Ramesh Kumar 7,527 Super User 2025 Season 2 on at

Like (2)

Report

Hi,

If this is your first time, you'll need to manually enter the amount and ensure that your balance matches the GL balance associated with the bank account. For example, if the last statement balance from the old system is $10,000, the GL balance linked to the bank account should also be $10,000

Thanks

Ramesh

If this was helpful, please check the "Does this answer your question?" box and mark it as verified.

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 31,340 Super User 2025 Season 2 on at

Like (4)

Report

As mentioned, the first time you do a bank rec. you can manually populate that field.

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No
Verified answer

YUN ZHU 95,331 Super User 2025 Season 2 on at

Like (3)

Report

Hi, From the code, it is taken from the Balance Last Statement field on the bank card.

Hope this helps as well.

Thanks.

ZHU

Was this reply helpful? Yes No
Vahid Ghafarpour 12,090 Super User 2025 Season 2 on at

Like (3)

Report

If any of the responses helped resolve your issue, please take a moment to mark the best answer. This helps others in the community quickly find solutions to similar problems.

To do this, simply click the "Does this answer your question?" button on the most helpful response and like the helpful posts. If your issue is still unresolved, feel free to provide more details so the community can assist further!

Thanks for being an active part of the Dynamics 365 Community!

Was this reply helpful? Yes No