Bank Reconcillation

[anne1823]

Could anybody help I have taken over a position from somebody who retired after 15 years I had just under 3 weeks to learn all of his job they use Sage Accounts version 11 where I was using Sage MMS before.
Since April I have done the bank reconcillation each month and all was well until the Finance Director says the totals in the bank rec to the totals in Sage are different. I have only done the bank reconcillation as shown to me before they retired.
We tried to sort it out at the end of August and we thought we had done until I looked at the Opening Balance brought forward and it is different to what we reconcilled to at the end of August. I do not wont to continue as I think it would make the matter worse.

August Bank Reconcillation is as follows:
Balance per bank £150555.53
Uncleared Items £1768.90
Uncleared Items £3922.89
Balance per cashbook £144863.74
This cashbook balance was correct with the Trial balance for August.
I have gone into the bank reconcillation today and it says that the opening balance is £146641.23 if you take this away from the £144863.74 it gives you a difference of £1777.49 just found a recurring entry of £8.59.so this make this difference of £1768.90 and if you take the £146641.23 away from the £150555.53 it makes the difference of £3914.30 which again has the recurring entry of £8.59.

We then decided to split the bank accounts into the current account only;
September Reconcillation is as follows:
Balance per Bank £4556.09
Uncleared items £3006.20
Balance per cashbook £1549.89
The only way I can get September to balance is if I reconcile all the items including the uncleared ones.

If anybody could help me sort this problem out I would be most grateful.
Anne

[Site4]

When you say "Cashbook" do you actually mean one of those antique books three feet wide with hundreds of columns and a quill pen?

And do I understand your reconcil for August correctly? (plus or minus the odd 8 quid), i.e.

Bank statement 150555.53
less items in sage not cleared bank 3922.89
Balance per sage reconcil 146632.64
less items in the cash book not in sage 1768.9
Balance per cashbook 144863.74

[brucedenney]

Sage has a really good bank rec feature.

I suggest that rather than doing an old fashioned cash book reconciliation you learn the sage way.

Not least because until you mark transactions reconcilled the sage way, the transactions remain outstanding for ever and will never be possiblt to clear them from the audit trail.