Position discrepancies will occur when reconciling trades for a number of different reasons. The majority of conflicts are typically the result of:

Corporate actions (e.g. symbol change, split, merger/acquisition)
Missing data from your clearing firm or execution provider (e.g. away trades, option exercises).
Differences in ticker symbols

Below you will find explanations and steps to fix both common and edge case discrepancy issues.

After taking steps to resolve the discrepancy you will need to rerun the reconciliation process for the discrepancy to disappear.

Symbology Discrepancies

Symbols inconsistent with PropReports symbology

PropReports compares its internal positions against positions reported by your clearing firm or the DMA provider. Because various systems use different symbol naming standards PropReports attempts to "normalize" ticker symbols when matching positions. Discrepancies may occur during reconciliation when this normalization process fails. Below are two examples where the symbol used by PropReports does not match the symbol used by the clearing firm:

ABCXYZ (123)
	BRK/A 300  --
	BRK.A  --  300
	LXP-PC 100  --
	LXPPRC  --  100

In the example above, you can see that PropReports is reporting 300 shares long of "BRK/A" for account ABCXYZ whereas the other system is showing 300 shares for "BRK.A". The correct symbol should be BRK/A and the erroneous symbology of BRK.A causes a discrepancy. The same issue exists for the "LXP-PC" / "LXPPRC" discrepancy (the correct symbol being LXP-PC).

To reconcile this type of discrepancy, you will have to correct the ticker symbol via the Audit / Symbols page.

Alphanumeric code in place of ticker

When a vendor's symbol database is incomplete they may send an ISIN or some internally-generated code in place of a ticker. Below are two examples where a symbol is missing in the data received from the clearing firm:

ABCXYZ (123)
	ASG 58,888  -- 
	US5299904186  --  58,888
	AMD     5,000 --
	A005767  --  5,000

Reconcile this type of discrepancy by navigating to the Audit / Symbols page, searching for the code causing the discrepancy (e.g. A005767 or US5299904186 from the examples above) and correct the ticker symbol.

Corporate Actions

Symbol Change

Ticker symbols can change when companies merge, change names, get delisted or go bankrupt. For example, when AOL Time Warner dropped the AOL and became simply Time Warner, it changed its symbol from AOL to TWX. Here's what the discrepancy looks like:

ABCXYZ (123)
	TWX --  123
	AOL  123  --

To reconcile this type of discrepancy, navigate to the Audit / Corporate Actions page and select the Symbol Change action. Please visit our Symbol Change support page for complete instructions.

Stock Split

If a trader is holding a position for a stock that did a split or reverse split, a discrepancy will appear on the reconciliation report. The example below shows a discrepancy for symbol "ABTL". PropReports is reporting 19,000 shares, while the clearing firm is reporting only 3,800. This is because the stock has undergone a 1:5 stock split.

ABC123 (123)
        ABTL 19,000 3,800

To reconcile this type of position discrepancy, navigate to the Audit / Corporate Actions page and select the Stock Split action. Please visit our Stock Split support page for complete instructions.

Option Expiration

Below is an example of a position discrepancy caused by an option that needs to be expired. The option for security "JOSB" was set to expire on 07/21/2012 and came up as a discrepancy simply because the option matured without being closed out in PropReports.

ABC123 (123)
	+JOSB120721C00050000 1  --

To reconcile this type of discrepancy, visit the Audit / Corporate Actions page and select the Option Expiration action to close the position. Please visit our Option Expiration support page for complete instructions.

Configuration Errors

Another common issue is incorrect or missing account names. Below are various examples of discrepancies caused by account name configuration errors.

Mismatched Clearing Id or Account Id

DEFXYZ (321)
	MSFT 1,500 --
ABC123 (123)
	MSFT -- 1,500

Clearing Id not set

	MSFT 1,500 --
ABC123 (123)
	MSFT -- 1,500

Clearing Firm or Source not set or incorrect

ABC123 (123)
	MSFT -- 1,500

To fix these types of discrepancies, navigate to the Accounts / Overview page for the account holding the position and verify the account names are correctly set. If reconciling against the clearing firm, then the Clearing Id and Clearing Firm must be set and accurate. If reconciling against the DMA vendor, ensure the Account Id and Source match. For more information on account names, please click here.

Browser not supported