Home For AAT student members AQ 2013 AAT Level 3 (Level 6 in Scotland)
Current updates regarding coronavirus (Covid-19) and the precautions AAT are taking will be continually updated on the below page.

Please check this link for the latest updates:
We hope you are all safe and well and if you need us we will be here. 💚


sage- bank reconcilation

meibakermeibaker Trusted RegularRegistered Posts: 481
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 Registered Posts: 107
    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 Registered Posts: 481
    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 Registered Posts: 6,970
    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 Registered Posts: 481
    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 Registered Posts: 481
    sorry a vic, type wrong, my is not nil.
  • BluewednesdayBluewednesday Font Of All Knowledge Registered Posts: 1,624
    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 Registered Posts: 6,970
    Sorry was thinking the lower box to show all balances my bad
  • meibakermeibaker Trusted Regular Registered Posts: 481
    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 Registered Posts: 481
    think i did it, thanks so so much for all your help. x
Sign In or Register to comment.