Before you start Before reconciling your bank account, ensure you've entered all of your transactions up to the end date of your bank statement.
Enter your statement summary VIDEO
Go to Bank accounts , then click the relevant bank account. Select Reconcile . If the 'The bank account selected has been marked as not requiring bank reconciliation' message appears, follow the steps on the article.
Enter the Ending Balance from your statement. Enter the Statement Date from your statement. Enter any Interest Earned and the Date . Enter any Account Charges and the Date . Click OK . If necessary, you can change statement summary information in the Reconcile window by clicking Edit or the pencil icon .
VIDEO
In the Matched transactions pane, check the Last reconciled balance . Does the Last reconciled balance match the opening balance on the bank statement you're reconciling? Match your transactions VIDEO
In the Un-matched transactions pane:
Select the first transaction that appears on your bank statement. Click Match >> Repeat Steps 1 and 2 until all transactions match your bank statement.
If you haven't entered a transaction into Sage 50 Accounts, post an adjustment. You can save the reconciliation at any point and complete it later, click Save progress Use Saved .
At any point before you reconcile, to see a list of currently unmatched items, click Report .
Reconcile your bank statement VIDEO
Once you match all the relevant transactions:
Check the Matched Balance and the Statement Balance are the same Difference will be zero. If the difference: Is zero Click Reconcile . Isn't zero You must find out why it isn't zero .If required, click Save progress .
Next time you open the Reconcile window, to open the saved reconciliation, click Use Saved .
View reconciled report - optional Go to Bank accounts then click the relevant bank account. Select Reconcile then click OK . Select View history . Double-click the required pdf file.