APL |
RECONSCREEN |
RECONSCREEN
Our interactive reconciliation screen RECONSCREEN can help you to balance accounts one-by-one against bank statements. It compensates for the usual trade-date versus settlement-date discrepancies, and allows you to identify and correct errors in trades and in cash transactions.
- Type RECONSCREEN and press
Enter ↵
The system will ask for beginning and ending dates.
- Enter the dates covered by the statement you are working with
You will then be asked to select the accounts to balance.
- Enter the short name(s) or account number(s) and press F10
The following screen will appear:
Custodian Settlement Date Cash Screen ------------------------------------- As of September 30, 1996 Snam BWNUM DTCNO1/DTCNO SD Balance ------ ---------- ------------ ------------- DEMO02 42 00DA28092 10,975.23 DEMO01 278689 00DA43296 1,500.00 DEMO02 42 00DA28092 1,750.00 DEMO03 43 00DA23120 3,250.10 DEMO04 44 00DA09237 5,100.45 DEMO05 45 00DA23013 3,123.87 DEMO06 46 00DA44439 2,254.30 DEMO07 47 00DA23112 12,987.55 Please Enter the Custodian´s Settlement Date Cash Balance ŠŠŠŠŠŠŠŠŠŠŠŠŠŠŠŠŠŠŠŠŠŠŠŠŠŠŠŠŠŠŠŠŠŠŠŠŠŠŠŠŠŠŠŠŠŠŠŠŠŠŠŠŠŠŠŠŠŠŠŠŠŠŠŠŠŠŠŠŠŠŠŠŠŠŠŠŠŠ F-3 to Exit F-10 to Continue
- In the right column, enter the settlement date cash balance from the custodian statement and press F10
The Cash Adjustment Screen is the first to appear:
Dividends interest, contributions, withdrawals and any other general ledger data are displayed. Compare them to the statement.
- Make corrections by typing over the bad amounts, adding new transactions or deleting transactions
At any time you may press F5 to recalculate and see the effects of your changes at the bottom of the screen.
- If there are no additional changes to make on trades you can press F10 to save your changes
Note: Alterations will be saved to the general ledger file.
An audit report will be generated upon hitting F10. This will display the changes you have made in the general ledger or trade information. A summary of pending transactions will appear as well.
- To reconcile trade information press F2
The Trade Adjustment Screen:
- Adjust information by typing over it
To correct a commission or broker, you must press F9 to access a second screen with this information. At any time you may press F5 to recalculate and see the effects of your changes at the bottom of the screen.
- To save your changes press F10
Note: Any altered trade is fixed using the DELBATCH method: first we post a trades batch deleting the bad trade, and then we post a second batch with the corrections, leaving an audit trail.
An audit report will be generated upon hitting F10. This will display the changes you have made in the general ledger or trade information. A summary of pending transactions will appear as well.
Function Keys
Esc - Exit
F3 - Exit
F2 - Toggle Between Trade, Cash Adjustment Screen and Market Value Screens
Shift/F2 - Toggle Between Trade, Cash Adjustment Screen and Market Value Screens
F5 - Recalculate
F6 - Diary Notes-Goes to the Infodex Diary Notes Screen
Shift/F6 - Delete Line
F7 - Prior Account
F8 - Next Account
F9 - Move to additional Trade Screen Data
Shift/F9 - Returns you to the Custodian Balance screen to make additional changes
F10 - Save and post all changes