checkbook showing wrong opening balance

(0) Share

Report

Posted on by Refeesh Ali

5,201

hi,

i would like to inform you that i am facing a problem in one of my check book balance it is showing wrong, rest of the check book account balance is fine. please check the snapshot and advice how to fix it

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (0)

Refeesh Ali 5,201 on at

Like (0)

Report

can anybody help.

Was this reply helpful? Yes No
Suggested answer

Zohaib Asghar 250 on at

Like (0)

Report

Hi,

Please note that the last reconciled balance of the checkbook can have impact on this amount.

Financial >> Cards >> Financial >> Checkbook

For example,

if we create a new checkbook id and put a last reconciled balance of $4000. Then post a deposit of $1000 in the checkbook. Balance inquiry will be showing $5000 balance.

Was this reply helpful? Yes No
Refeesh Ali 5,201 on at

Like (0)

Report

@Zohaib Asghar : please advice me how can i fix this issue i need to correct it how to do it

Was this reply helpful? Yes No
Refeesh Ali 5,201 on at

Like (0)

Report

It's an old check book. it was alright before but suddenly the difference appeared in the opening balance.

Was this reply helpful? Yes No
Refeesh Ali 5,201 on at

Like (0)

Report

please advice

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hello,

I recommend to you to take a look in SQL Server (Dynamics and Company) for the table to see is something have been added by check links, I have that problem before,

Was this reply helpful? Yes No
Suggested answer

Zohaib Asghar 250 on at

Like (0)

Report

Hi,

My apologies for late response. I produced a similar issue in my machine. As per below screenshot, the current checkbook balance and running balance is reflecting a wrong figure.

Please note that this workaround is applicable to the case where 'last reconciled balance' for the checkbook is entered before its first reconciliation. My recommendation is to take backup, review checkbook transactions in tables, Reconcile to GL routine(match current checkbook balance and current cash account balance) and try check links before deciding to attempt the below workaround.

If you go to Checkbook Card (Financial > Cards > Financial > Checkbook) and update 'Last reconciled balance' to $0.00, the current running balance is corrected accordingly.
Please note that if the checkbook has been reconciled before, the 'last reconcile balance' cannot be changed. So, in this case, the current checkbook balance must be updated in Checkbook Master table. This will be followed by correction of running balance from down to top.

Please provide feedback if you attempt this workaround.

Was this reply helpful? Yes No
Zohaib Asghar 250 on at

Like (0)

Report

The last reconciled balance or the current checkbook balance was updated to $0.00 for the test case only. In your case, one of these fields have to be updated with the correct checkbook balance amount (based on transactions in your checkbook) rather than $0.00

Was this reply helpful? Yes No