sage- bank reconcilation
meibaker
Registered Posts: 481 Dedicated contributor ๐ฆ
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!
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!
0
Comments
-
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
Emma0 -
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 ? thanks0
-
-
sorry a vic, type wrong, my is not nil.0
-
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.0 -
Sorry was thinking the lower box to show all balances my bad0
-
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.0
-
think i did it, thanks so so much for all your help. x0
Categories
- All Categories
- 1.2K Books to buy and sell
- 2.3K General discussion
- 12.5K For AAT students
- 323 NEW! Qualifications 2022
- 165 General Qualifications 2022 discussion
- 11 AAT Level 2 Certificate in Accounting
- 56 AAT Level 3 Diploma in Accounting
- 88 AAT Level 4 Diploma in Professional Accounting
- 8.8K For accounting professionals
- 23 coronavirus (Covid-19)
- 272 VAT
- 92 Software
- 273 Tax
- 135 Bookkeeping
- 7.2K General accounting discussion
- 200 AAT member discussion
- 3.8K For everyone
- 38 AAT news and announcements
- 345 Feedback for AAT
- 2.8K Chat and off-topic discussion
- 582 Job postings
- 16 Who can benefit from AAT?
- 36 Where can AAT take me?
- 42 Getting started with AAT
- 26 Finding an AAT training provider
- 48 Distance learning and other ways to study AAT
- 25 Apprenticeships
- 66 AAT membership