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

(5) Share

Report

Posted on by joshtechsolutions

5,007

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,803 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

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 5,007 on at

Like (3)

Report
Copy link

Link copied!

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,803 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

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. 22,130 Super User 2026 Season 1 on at

Like (3)

Report
Copy link

Link copied!

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,555 Most Valuable Professional on at

Like (3)

Report
Copy link

Link copied!

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,547 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

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 32,208 Super User 2026 Season 1 on at

Like (4)

Report
Copy link

Link copied!

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 99,086 Super User 2026 Season 1 on at

Like (3)

Report
Copy link

Link copied!

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,228 Super User 2026 Season 1 on at

Like (3)

Report
Copy link

Link copied!

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