To change the ‘balance at’ date to which the bank reconciliations in Troika Wealth Management work to, from the Utilities modules, select the Database tab and then menu option Bank Reconciliation Options. Enter the require 'Report Date'.
In Troika releases prior to 2.09.022 Bank Reconciliation Options was located in the Wealth Management module, Global tab.
If the 'Enable Bank Reconciliation Statement Balance Entry' box is checked, the 'Report Date' and 'Date Gap Exception Threshold' boxes become active. This information is used in conjunction with an exception report and also adds extra fields to the reconciliation screen.
The statement balance is entered manually from the closing balance of the bank statement. The Unreconciled Difference is the difference between the statement balance and the reconciled balance. Date Reconciled To is the date of the statement from which the balance is taken. An exception report can be produced listing all accounts where the difference between the report date and the Date Reconciled To is greater than the Date Gap Exception Threshold or where there is an unreconciled difference.