Total Legal Accounting 3
SECTION 3.4.2 - REGISTER BALANCES
USAGE: To print a list of all or a selection of Securities & Investment Registers with their balances. This report can either be used to list the current balances of each Register or a breakdown of balances and charges. This report can be used as a source document for Government reporting and Statements to your Clients.
DISCUSSION: The report always prints in file code order.
When you enter this program, the following questions will appear:
USE LONG FORMAT REPORT If you are using wide stationery, reply Y, otherwise reply N. This question will only be displayed if the relevant option is set to A, see SECTION 7.1.2.
INCLUDE ALL FILES If you answer Y here, all files (that pass the questions above) will be included in the report. Otherwise, you will be asked to enter values for the following ranges. If you enter Y here, go directly to the OK TO PRINT question.
SEC & INV. RANGE This allows you to limit the report to a range of Investment codes. Enter the lower and upper ranges of the codes you require. The default limits will include all files.
LIST ALL BALANCES If you answer N here, only the current balance will be printed. However, more details are printed across the line, eg. Description. If you answer Y, T.L.A. will compute the value in several categories and print them across the line.
DATE RANGE This allows you to specify a range of dates for T.L.A. to compute the balances. If you leave the dates as the default, the total balance will be computed. Normally, you would enter a period range eg three months or a year.
NON-RES DATE RANGE This is the transaction date range specifically for non-resident withholding tax. This is normally a year range but it may be a different range to the one above. The reason for the separate range is that, generally, you will not tell the bank what to withhold until after the period is complete and then they will take the monies out. The transaction (if you choose to match the bank statement) will thus be out of the first range but it refers to tax with in the first range (above). The separate range offered here allows for this. So, for example, you might enter a range of 1/7/2005 to 30/6/2006 for the DATE RANGE and 8/8/2005 to 9/7/2006 for the NON-RES DATE RANGE. If this does not apply, enter the same date range for both DATE RANGE’S.
To start the report, press <Enter> through each field or simply press <F10>.
The report itself will detail the File Code (the Register code), the Link Code (the Trust account this Register links to) and the account balance (within the range of dates you have chosen). If you have chosen not to LIST ALL BALANCES, the account description will be printed next. If you have chosen to LIST ALL BALANCES, the totals in other categories will be listed instead. These are: Withdrawals (Trust Receipts), Deposits (Trust Cheques), Interest (Income), Management Fees, Government Charges, Withholding Taxes and any Opening Balances (created via compressions etc.). These correspond to the transaction entry types available in SECURITIES & INVESTMENTS DATA ENTRY (see SECTION 3.3). At the end of the report, all monetary fields are totalled.