Reconciliation
The Reconciliation module of TheBooks provides the tools you need to reconcile your accounts with your clearing brokers. It can quickly and automatically reconcile trade confirmations, open positions, and balances. It handles all of the paper work and communication associated with reconciling your trading activity, leaving you with more time to research and trade your strategies.
Obtaining statements and equity runs
Whether the runs come are sent via email or come from FTP sites, the Reconciliation module automates the process of downloading the statements. Statements are automatically parsed, and their information is extracted as soon as they are received. The download and parsing status of all statements is available from any computer in your network and is updated as changes occur.
Data extraction
Because no statements are created equal, the Reconciliation module provides complete flexibility in symbol translation and market re-valuation. It allows accounts from multiple statements to be mapped to a single account and translates and converts all markets, exchange rates, and quantities to your standards. Contract prices and quantities can be scaled and inverted, FX trades can be re-stated, and exchange rates can be scaled and inverted.
The result... all data is presented in a single, consistent format the way you want it, using the symbols, account numbers, and conventions you use.
Reconciling accounts
To reconcile trade confirmations, simply select Discrepancies and then Confirms. Trades with differences, trades missing from the statement, and trades missing from your system are displayed. To see differences at the FCM level, select the FCM and then click on Confirms. Reconciling positions and balances work the same way.
If required, multiple people can reconcile at the same time, each working with one or more FCMs.
There is even an issue tracking facility to keep track of problems so they don’t get overlooked on subsequent statements.
Online access to statement data
The Reconciliation module also includes an online statement archive allowing you to recall any statement and its data from anywhere in your network. There is no need to look for statements in your files. Just select the date, and you can review all statements and their data for that day.
Because all extracted data is stored in an ODBC server database, it is available for you to analyze using any of the popular reporting tools.