V.12 System error??

[StephanieB]

I reallocated some payments to a supplier. Deleted them after bank rec, and re-posted correctly. Usually the bank b/fwd balance reflects this at the next reconciliation and can be put right.
This time, the b/fwd bal didn't change, but the trial balance figure did.
Can't see anywhere on trial balance where there's a compensating entry.

Tried deleting the corrected payments, but supplier accounts now incorrect.

Help appreciated.

[brucedenney]

you say "I reallocated some payments to a supplier."

There is no function to do this but I can think of 2 ways

1/ Edit transaction in error corrections, and change the supplier account.

2/ Delete the transaction, re-enter the transaction.

I assume you did the second method

The original transaction was marked as Bank Reconciled, so when you deleted it the Bank Reconciliation should have changed to reflect this, you would normally rectify this by reconciling the replacement transaction.

You are saying that the B/F balance following the deletion of the transaction has not changed.

Please confirm the version number is 12.01.0070 (Help>About>General)

Please confirm the operating System is XP with SP3 (Right Click on My Computer>Properties)

I would use the view history option in the bank rec and verify that the B/F balance has not changed from the last pdf.

I would run error checking, do a re-index and compress just to be sure.

I would check for the date of the entries, did you date the wrong year?

[StephanieB]

Thank you for your response.
Yes,I did delete & repost.
Confirm v 12.01.0070 and XP SP 3
Checked data - all OK
Dates - all 2011
History bank recs correct.
Have re-indexed bank and supplier records -no change

Any other ideas?

[brucedenney]

Does the opening balance on the current bank rec screen match the closing bank rec amount on the last pdf report?

[StephanieB]

Yes it does, even after I've done the delete and re-post.

Unfortunately, the re-posts are sitting as unmatched.
Seems I can either have the bank account correct or the Supplier account, not both.
As it's a substantial sum, I can't just wite it off.

StephanieB

[StephanieB]

As this would appear to be unresolvable, I have created a 'System error' bank account and posted the supplier payments from it.
I have set it up not to be included on the Balance Sheet and will include a file note to the accountant explaining the discrepancy with the Trial Balance.
Hope this helps others who may encounter the same difficulty.

[brucedenney]

something sounds wrong... there has to be an explanation.

Go into the Bank rec, enter the End Balance as the actual bank balance in the TB
Match All transactions and check the difference should be zero.
This proves the bank rec matches to the TB. If it doesn't match by the amount you deleted doing an adjustment might be warranted

DO NOT reconcile, just close and discard.


============

The system error bank account is not needed, you can just make a bank receipt or payment to resolve any bank rec discrepancy and then post that to a suspense account for the auditor to dig into at year. This way you don't have another unneeded nominal account hanging around for years to come.