sage- bank reconcilation

meibakermeibaker Trusted RegularPosts: 481Registered
i am having so much trouble with sage!:thumbdown:
just can't understand how to work out bank reconciliation? even go through with the example, just don't understand. really confused,please please someone help me! thanks so much!

Comments

  • ema192ema192 Well-Known Posts: 107Registered
    Hello,

    Wat is it you cant understand? I have been using the bank rec on sage for years so perhaps can help.
    The basics is you put in the end date of the statement your are reconciling against. Then the amount , the statment reference.

    All the transactions within this time period will then be displayed. The best way is to start on the right of your bank statment going through it individually highlighting on the sage rec the transactions, when you are happy you have highlighted the correct ones you can then press the button to transfer them into the box at the bottom of the page. Once you have highlighted everything included in your statement you should then have a nil balance in the difference box bottom right, you can also check by the totals of DR/CR side of the account.

    Hope this helps in some way

    Emma
  • meibakermeibaker Trusted Regular Posts: 481Registered
    hi, thanks for your reply, what i did is highlight on everything which are match with the statement, then click on match transaction, but the total isn't nil, where did i go wrong ? thanks
  • A-VicA-Vic Expertise Guaranteed Posts: 6,970Registered
    meibaker wrote: »
    hi, thanks for your reply, what i did is highlight on everything which are match with the statement, then click on match transaction, but the total is nil, where did i go wrong ? thanks

    ??? isnt the total ment to be nil once you have matched the bank rec?
  • meibakermeibaker Trusted Regular Posts: 481Registered
    A-Vic wrote: »
    ??? isnt the total ment to be nil once you have matched the bank rec?

    it should be, but mine doesn't, not sure where did i go wrong
    :confused1:
  • meibakermeibaker Trusted Regular Posts: 481Registered
    sorry a vic, type wrong, my is not nil.
  • BluewednesdayBluewednesday Font Of All Knowledge Posts: 1,624Registered
    Then there is something wrong, are there any transactions missing?

    You need to check the date of the last reconciliation and the last balance that was reconciled.

    Also make sure you check that cheque amounts tally with the amount on the bank statement not just the cheque numbers.
  • A-VicA-Vic Expertise Guaranteed Posts: 6,970Registered
    Sorry was thinking the lower box to show all balances my bad
  • meibakermeibaker Trusted Regular Posts: 481Registered
    think i must miss out some detail as mine sales type A from trial balance is different to the one on the book. thanks for all ur help.
  • meibakermeibaker Trusted Regular Posts: 481Registered
    think i did it, thanks so so much for all your help. x
Sign In or Register to comment.