Reversing or deleting a bank entry on Sage

Reversing or deleting a bank entry on Sage

Didn't find your answer?

Please can someone help - when entering the Bank Statements onto Sage and reconciling them I have allocated a payment to the wrong invoice (correct Customer but wrong invoice!). How can I correct this before the accountant comes in to do the month end? (tremble!) I presume I go into File - Maintenance but then what? Any help gratefully accepted. Thanks.

Replies (12)

Please login or register to join the discussion.

By Tonykelly
01st Oct 2011 15:22

simplest way

delete the transaction and post it correctly

Thanks (1)
avatar
By poppydew
01st Oct 2011 18:33

Thanks Tony but I am worried about just deleting and reposting it as it was featured in a Bank Reconciliation I did a few pages back - how will the new transaction slot into this?

Thanks (0)
avatar
By Figurate
01st Oct 2011 19:35

Reconcile the replacement transaction

If you delete a "reconciled" transaction, then when you do you next bank rec, the opening reconciled bank balance will just be different by the amount of the deleted transaction. Just add/match the new (replacement) transaction (assuming its for the same amount as the erroneous one that was deleted), in the same way that you would reconcile any other transaction, to get back to the correct opening balance.  Then continue as normal.

Louise
www.figurate.co.uk
www.happyaccountant.com

Thanks (1)
avatar
By poppydew
01st Oct 2011 20:22

Thanks for that Louise, so it won't matter that I am on a different bank statement 'page number'?

(I normally enter the paper Bank Statements page number as the 'Statement Reference' box in the Sage 'Statement Summary' in Bank Reconciliation)

Thanks (0)
avatar
By Figurate
02nd Oct 2011 19:27

No, it won't matter, if...

No, it won't matter, if overall, you reconcile to the correct total, by the end of the "new" bank statement page number. (still use the statement reference as you normally would).

Louise
www.figurate.co.uk
www.happyaccountant.com

Thanks (2)
Me!
By nigelburge
02nd Oct 2011 11:52

Sorry to go OT but...........

............this is one of the reasons I loathe and detest Sage.

And it is one of the reasons I love VT: everything in VT is editable - just lovely!

Thanks (0)
Replying to ShirleyM:
avatar
By poppydew
02nd Oct 2011 19:46

I agree!

I hate Sage too with a vengeance!!! I wish we had VT at work but I have never seen it advertised in any job ads for bookkeepers they all want blasted Sage :(

Thanks (0)
By Tonykelly
02nd Oct 2011 20:31

you have another option

I have spoken to my contact at Sage today, and explained that you were very worried about changing the bank transactions.

He advised me of another solution and asked that I should pass it onto you.

Enter another invoice on the system - dummy invoice for the same amount as the bank receipt.

Enter a credit note (same amount) on the system and allocate it against the invoice you should have matched the bank receipt against.

Both these invoices should be coded T9. You can post them to suspense or any account as they will cancel each other out.

You can leave the bank as it is and carry on with your bank recs as normal.

 

 

 

Thanks (0)
Replying to ShirleyM:
avatar
By johndon68
03rd Oct 2011 10:05

Tax Codes...

Tonykelly wrote:

I have spoken to my contact at Sage today,

Both these invoices should be coded T9.

Not necessarily, if the VAT Cash Accounting Scheme is in use, you don't use T9, you use the code appropriate to the original invoice...

John

Thanks (0)
Replying to ShirleyM:
avatar
By Figurate
18th Oct 2011 09:24

outstanding invoice...

Tonykelly wrote:

I have spoken to my contact at Sage today, and explained that you were very worried about changing the bank transactions.

He advised me of another solution and asked that I should pass it onto you.

Enter another invoice on the system - dummy invoice for the same amount as the bank receipt.

Enter a credit note (same amount) on the system and allocate it against the invoice you should have matched the bank receipt against.

Both these invoices should be coded T9. You can post them to suspense or any account as they will cancel each other out.

You can leave the bank as it is and carry on with your bank recs as normal.

 

 

 

 

Although that wouldn't touch the bank, I would be cautious about doing that in general, because it would mean that the outstanding invoice left on the customer account wouldn't be the actual o/s invoice (it would be the "dummy" invoice that would show as o/s).  Consequently, it might cause confusion if sending out customer statements or doing credit control.

(Should also mention - it's possible to do a bank rec just for the one correcting customer receipt transaction. (using, say, the original bank statement number & date with "A" or "adjust" or "correct" etc.. as a suffix) and then the opening reconciled bank balance on the next proper bank rec will be correct.)

Louise
www.figurate.co.uk
www.happyaccountant.com

 

Thanks (0)
By Tonykelly
03rd Oct 2011 11:53

agree with John and Louise

Posting dummy invoices may correct the problem, but may cause other problems, so is certainly not the ideal solution.

As initially pointed out the simplest way is to delete the transaction, as mentioned in my first post.

 

 

Thanks (0)
avatar
By AiCc
26th Jan 2013 21:50

BP
A bp has been made to diesel account instead of drawings. When I am making the change through a journal do I journal it out at the gross amount at t1 or net amount at t1. I am really confused please help

Thanks (0)