Page 1 of 1

Bank Reconciliation

Posted: 18 Oct 2012, 13:38
by staceeb77
Hi Guys, Or Bruce :)

I'm doing a bank rec and have come across an amateur problem! On the statement a certain payment has represented itself 4 times as being paid in, then it's gone out 3 times to make it just one payment, so when recording this as a receipt I only did it once. Now I'm faced with the problem of the statement not matching up to sage. How do I reflect this?

Thanks in advance :D

stacey

Re: Bank Reconciliation

Posted: 18 Oct 2012, 16:58
by brucedenney
There are 2 ways,

either post the receipt and claw backs as per the bank, so things are the same (a pain to have to enter multiple entries that do nothing overall, but the upside are things are exactly the same in Sage to the Bank)

Or

just match the final entry (not so good if the transactions straddle the bank statement end as the figures will not match)

Re: Bank Reconciliation

Posted: 19 Oct 2012, 08:17
by staceeb77
Right I'm quite basic with sage at the mo,

so you mean to do them as receipts and payments in and out of the Bank (1200) to match the statement?

What N/C would I have to use?

Thanks again :) x

Re: Bank Reconciliation

Posted: 19 Oct 2012, 15:24
by brucedenney
Yes bank payments and receipts would do it.

the nominal doesn't really matter because they cancel each other out, however, miss-postings is typically set up for this sort of transaction where the net overall effect is nothing.

Re: Bank Reconciliation

Posted: 22 Oct 2012, 08:44
by staceeb77
You're a star, thank you :) I can now catch up on a months worth of reconciling :) fun day for me today :-/ haha

Thanks again :)