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

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

Like (4) Share

Report

Posted on 2 Apr 2025 05:53:43 by joshtechsolutions

4,742

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

All responses (8)

Answers (0)

Suggested answer

YUN ZHU 80,252 Super User 2025 Season 1 on 02 Apr 2025 at 23:40:46

Like (1)

Report

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

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

Hope this helps as well.

Thanks.

ZHU
Suggested answer

Valentin Castravet 27,136 Super User 2025 Season 1 on 02 Apr 2025 at 17:50:58

Like (2)

Report

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

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/
Suggested answer

Ramesh Kumar 2,333 on 02 Apr 2025 at 13:16:26

Like (0)

Report

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

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.
gdrenteria 16,846 Most Valuable Professional on 02 Apr 2025 at 11:05:21

Like (2)

Report

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

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

Best Regards
Gerardo
Suggested answer

Khushbu Rajvi. 12,826 Super User 2025 Season 1 on 02 Apr 2025 at 08:45:41

Like (2)

Report

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

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
Suggested answer

Jainam M. Kothari 4,129 on 02 Apr 2025 at 06:44:41

Like (1)

Report

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

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.
joshtechsolutions 4,742 on 02 Apr 2025 at 06:42:42

Like (2)

Report

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

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 !
Suggested answer

Jainam M. Kothari 4,129 on 02 Apr 2025 at 06:28:03

Like (1)

Report

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

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.