E-Reconcile

1. Bank > select the required bank account > E Reconcile.

   Tip: You may need to click the double chevron to access the E Reconcile option.

2. Enter the statement date and closing balance on your bank statement > OK.
3. File > Import Bank Transactions > browse to the required file > Open.

You cannot amend the following values:

Opening Balance	Balance brought forward from the last reconciliation. This should be the same as the closing balance on your previously reconciled statement.
Book Balance At Date	Bank account balance up to the date entered on the Amend Bank Statement Details window. It is the balance of reconciled and unreconciled items up to this date.
Difference	Difference between the Opening Balance plus the transactions you have selected to reconcile and the Statement End Balance. When you have selected all of your transactions this should be zero unless you have to make adjustments for transactions not yet entered into Sage Accounts, such as bank charges.
Uncleared Items	Total value of all of the transactions on the Reconciliation window that are not yet selected.
Reconciled Balance	This is the opening balance value, which is the sum of the current reconciled transactions. It changes automatically as you select transactions. Before you save, this should be the same balance as the closing balance on your bank statement.

The following information appears for each of the imported bank transactions and Sage Accounts transactions.

No/Trans No	Transaction number as it appears on the transaction list in the Financials window, or the number allocated to the imported bank transaction.
Ref	Reference for both your bank and Sage transactions.
Type	Sage transaction type.
Date	Depending on the transaction you are looking at, this is either the date the Sage transaction was entered, or the date of the bank transaction on your bank statement.
Details	Depending on the transaction you are looking at, this is either the description for the Sage transaction, or the description of the transaction on your bank statement.
Payments/Receipts	Value of the transaction.
Match With	When you match a transaction, this shows which transaction it is matched with.
Conf?	Initially set to N, once the transaction has been confirmed, this changes to Y.
Rec. Amount	Amount matched against the transaction.

1. From the Reconciliation window, select one of the following automatic options:
   

   Match Full	Automatically matches transactions with the same reference and amount.
   Match Amounts	Matches transactions with the same amount.
   Match Refs	Matches transactions with the same reference.

2. If more than one matching transaction is found, the Duplicate Transaction window appears and the following options are available:
   
   
   • To confirm the match, select the transaction to be matched, then click Match.
   • To proceed with the automatic matching process, without confirming the matching transactions, click Next.
   • To close the window without matching transactions, click Cancel.
3. Confirm > Reconcile > Yes.

1. From the Reconciliation window, from either the Sage transaction list or the bank transaction list, select the transactions you want to match.

   Tip: To select more than one transactions, press Shift.

2. From the opposite list, select the matching transactions.
3. Match Manual > Confirm > Reconcile > Yes.