SageForum for UK versions of Sage 50- Help and support.

Hi, Can any one help, I do some bookwork on Sage, I was doing a bank rec today, and I pressed clear because i was going back to it, after making corrections, This seemed to have messed things up, my balance has shot up and when i reconcile now the balance is getting worse,
any body can help it would be great


margaret

Hi Margaret,

I'm not quite sure what your query is, but here are some tips on Bank Reconcilliation.

Assuming you have a recent version of Sage, your bank reconcilliation screen will be a split screen with unmatched items at the top and matched items at the bottom.

The first balance in the bottom part of the screen is your starting point, find this balance on your relevant Bank Statement received from your bank, then start reconciling from there... do this by double clicking on the transaction in the top part of the screen, that appears on your bank statement. Do this for all the transactions on your bank statement, until they are in the bottom part of the screen.

At the top of the screen put your Bank Statement Number in the 'Reference' box, the date of your Bank Statement in the 'End Date' and the Bank Balance on the bottom of your Bank Statement in the 'End Balance Box'.

Once you have 'matched' all transactions the difference in the bottom right of your screen will be £0. If it is not you have made a mistake. Once it is £0, click 'Reconcile' in the bottom left of the screen. This will reconcile all the transactions you have matched, and create a history for you.

(You have not reconciled your bank statement until you click 'reconcile'. Up until this point you have only 'matched' transactions, and they can be unmatched by clicking 'clear' or by double clicking on them).

Next time you reconcile, the starting balance will be the end balance you reconciled this time.

Hope thats helpful,

Regards,

Andrea

Hi Andrea, Thanks for your reply, I understand the how to reconcile bit, or i thought i did! Everything was fine till one day i went to do out without matching and i pressed the clear button on the right! But i have found out since, i was reconciling the credit card, and i made apayment from the bank to the card, so its gone out the bank which is fine, but now it is not showin on the card, hence the balance on the card is incorrect, i can't pay it again from the bank else the bank will be wrong, so i don't know how to do it, I need to pay off £6500 without it going out the bank, any ideas
Thanks hun any help would be grateful

Margaret

Dear Margaret,

When I post a credit card payment, I do a bank transfer from the bank to the credit card.

I guess you have done a BP (bank payment)? So you need to delete the first transaction, and post a new transaction.

This is how I would correct it...

I would do my bank transfet from bank to credit card. You will now have two lots of £6500 on your bank.

If you have not reconciled your first transaction, simply go to >file >maintenance >corrections, find it and delete it.

If you have reconciled this first transaction, then go to >file >maintenance >corrections, find it open it up and take the tick out of the 'bank reconciled' box (make a note of the bank reconciled date). Save, then you will be able to delete it.

Now find your second transactions in >file >maintenance >corrections, open it up and put a tick in the 'bank reconciled' box, and enter the bank reconciled date as the date that you made a note of from above.

You have effectively replace the first transaction with the second one.

Good luck,
Andrea