BANK REC HELP!

[MADIZZY]

HI I HAVE RECONCILED MY BANK FORM WHEN WE STARTED ON SAGE IN NOV 2010 UP UNTIL END OF AUGUST 2011,
HOWEVER WHEN I CAME TO START MY SEPTEMBER BANK REC THE FIGURES DIDNT MATCH UP. YET AFTER EACH MONTH I PRINTED MY BANK REC PRINTOUT AND IT DID!

I HAVE TRIED TO CHANGE MY OPENING BALANCE FROM 1 NOV 2010 BUT ITS NOT WORKED AM IN A RIGHT MUDDLE PLEASE HELP

[brucedenney]

Please don't SHOUT

[MADIZZY]

Sorry

[brucedenney]

The problem has almost certainly come about because you have deleted a transaction that has been bank reconciled, well that is nearly always what it is.

Obviously deleting it was a mistake, but I expect it has been put back again you just have to find it and fix it. You also want to be really aware of this issue in future if deleting transactions.

First get the copy of the last bank rec in sage by going into Bank Rec and "View History"

This method makes sure that another bank rec has been run unbeknownst to you.

Check the final balance on the last statement and compare it to the "Last Reconciled balance at the beginning of the new reconciliation.

The difference is the amount you are looking for.

I would run the report in Financials >Audit Trail Reports>Audit Trail (Deleted Transactions) do not use the nominal code filter because that is not the bank nominal code.
You can make a quick edit to this report to make it much more useful, add the AUDIT_HEADER.DATE_BANK_RECONCILED field to the line . You could also add a criteria for the AUDIT_SPLIT.BANK_CODE so you can select just the one account.

Anything deleted and with a bank rec date is a candidate for part of the balance.
Note that the Bank reconciled flag is useless because sage sets it to unreconciled when you delete the entry.

Hopefully you can work out the transactions removed and reinstate them and re-reconcile them bringing your balance back to what it should be.

LAST RESORT - If you just can't find it, then you have no choice, make an entry to correct the balance to the suspense account, write a long explanation for the auditor/accountant, reconcile off the entry to get your opening balance correct and move on.

[pc_makingithappen]

>>Hopefully you can work out the transactions removed and reinstate them and re-reconcile them bringing your balance back to what it should be.

Hi. In my case, I deleted a transaction and created a new one (to separate a related bank fee).

From my reconciled bank statement, I need to remove the deleted entry and add the newly created transaction. How can I modify a reconciled statement?

Thanks.

PS: sage instant accounts, v17 (2011)

[brucedenney]

The removed entry, has been removed from the audit trail so the bank rec should be out by the value of the removed reconciled item.

If you reconcile the replacement item in its stead, then everything should be fine.

[allisont2]

I would run the report in Financials >Audit Trail Reports>Audit Trail (Deleted Transactions) do not use the nominal code filter because that is not the bank nominal code.
You can make a quick edit to this report to make it much more useful, add the AUDIT_HEADER.DATE_BANK_RECONCILED field to the line . You could also add a criteria for the AUDIT_SPLIT.BANK_CODE so you can select just the one account.
Hi... Bruce (Denney)... hoping you may be able to help me as I too have managed to mess up my bank rec. Found your suggestion and in the reports managed to add the additional field for bank rec date.... but having problems in adding criteria. If you could give me a bit of help (word for word) it would be much appreciated.

Kind Regards
Allison

[brucedenney]

Go to

Report>Criteria

and see if you can add it in from there

[allisont2]

Hi Bruce.. thanks. Yes I have managed to.. I assume I now export it to Excel and do the sort from there?

Many thanks for your advice.
Allison

[brucedenney]

That should work.