Discrepancy between balance on Bank Register and Bank Reconciliation

[LyndafromTat]

Using Accountright Live, today when my file opened there was a message saying a recurring transaction had not posted correctly.

It was a journal to transfer funds from one bank account to another. 

The journal actually appeared in both bank accounts twice with the same journal number.

That journal number also came up when i later entered another journal.

I deleted one of the journals because the bank register list was showing two and the balance was wrong.  The balance looked correct then.

When I tried to reconcile the account in Bank Reconciliation, the calculated statement didn't agree by the amount of the journal i had deleted (the transaction was after the closing date on the bank reconciliation so shouldn't have effected it anyway).

So I deleted the second journal entry and the situation is the same.

My bank register is correct, but i have to enter an incorrect statement amount to get the bank reconciliation to reconcile.  This is the same for both the accounts involved in the journal.

Does anyone know if this will rectify itself, or how I can fix it?

Thanks!

[Steven_M]

Hi @LyndafromTat

You mentioned that you have reconciled the account already with an incorrect statement amount is that correct? If not can you go to Banking>>Reconcile Accounts>>Enter in the Last Statement Date to be the Bank Statement Date and enter in the Closing Statement Balance to be the balance on the statement for that date. Does it show an Out of Balance/ the correct Calculated Statement Balance?

Also if you go to the Banking>>Bank Register>> Does it show the two transactions within that window or just the one?

[LyndafromTat]

Hi Steven,

No I haven't reconciled yet.

if i enter the closing statement balance and have all the items ticked i have a difference of $1292.

The other bank account that was the other side of the journal is the same, a difference of $1292.

I deleted both the incorrect journals and they don't appear on the bank register and the running total on the bank register is correct.  Also, when i open spend money the amount showing as the balance is correct.

It is only the Calculated Statement Balance that is incorrect.

I reposted the journal correctly and it appears in the bank register.

Also, in the bank feeds window the Calculated balance shows a variance of $1292 to the bank balance.

I have been using MYOB for around 20 years and haven't struck this before!!

Thanks for your help

Lynda

[LyndafromTat]

Still not solved unfortunately

[Steven_M]

Hi @LyndafromTat

It sounds like we do need to get the company file in for an investigate just before we do that are you able to confirm 2 points for me.

1) If you go back to the previous reconciliation i.e. enter in the Last Reconciled Date in the Bank Statement Date and enter in the Closing Statement Balance on that statement in the Closing Statement Balance. Do you have an Out of balance appearing? This is going to check to make sure that previous reconciliations are untouched and still balancing.

2) What is the version number of the program? This can be checked via Help>>About AccountRight. Both the version and file version numbers would be appreciated.

[LyndafromTat]

Hi Steven

If  I go back to the previous reconciliation there is now a discrepancy of $1292.

My version is 2015.2.17.2166

File 2015.2.17.2751

Could you tell me how long you will need the file and how much this will cost?

Thanks, Lynda

[Steven_M]

Hi @LyndafromTat

Thank you for confirming that information

If we do need to get the company file in for an investigation and possible repair we may have the company file for an extended period of time. However you can continue to work the company file while we have it, we will arrange for the 'current' file to be sent in when we have fix for that file. As to cost there would be no cost at this stage for that investigate and repair.

However in saying that if a previous bank reconciliation is out of balance it does sound at this stage like a simple bank reconciliation out of balance. For example as its a recurring transaction you may have deleted a previously recorded/reconciled transaction which would cause the out of balance in the current file. I would recommend going through Support Note: Out of balance bank reconciliation to find and correct that bank reconciliation out of balance.