Uploading an Adjustments File

To load a batch of adjustments into PropReports, a comma-separated values (CSV) file can be used. Please follow RFC 418 guidelines when creating CSV files. Notably, if you will have field values with commas, the field value must be in quotes.

Click here for an Adjustment CSV Template.

Sample Data

Date,Account,Offset Account,Category,Amount,Comment
03/31/2009,ACCOUNT1,ACCOUNT2,software,-140,03/09 Sterling software fee

Fields

Name	Mandatory?	Format	Sample	Available in Version	Description
Date	Yes	MM/DD/YYYY	`06/17/2012`	All	Date on which the adjustment should post.
Account	Yes	CHAR(20)	`ABC1234567`	All	Name of the account (PropReports Account Id). Anything after the first 20 characters will be ignored.
Offset Account	No	CHAR(20)	`1234567`	All	Optionally, a name of the opposite account for the transaction. In the sample data above, $140 is transfered from ACCOUNT1 to ACCOUNT2.
Category	No	CHAR(20)	`Dividend`	All	Can be a name of an adjustment category currently defined in PropReports or one of: `Software`, `Quotes`, `Interest`, `Dividend`, `Cash In/Out` and `Stock Locate`. Leaving blank or entering an unknown category will default to Fee: Misc.
Amount	Yes	DECIMAL(15, 4)	`140.00`	All	Amount to adjust the account balance by. Positive amount is a credit, negative amount is a debit. Adjustments with 0 for amount will not be imported.
Comment	Yes	CHAR(100)	`IBM Dividend`	All	Trader-visible comment for the adjustment.
Columns below are optional and can be in any order.
Qty	No	DECIMAL(18, 8)	5000	All	Number of shares in the adjustment-related position.
Symbol	No	CHAR(48)	IBM	All	Ticker symbol of the adjustment-related security.
Price	No	DECIMAL(18, 8)	26.3	All	Price of the adjustment-related position.
Currency	No	CHAR(3)	`USD`	All	Three-character ISO 4217 code for the currency of the specified amount. If different from the base currency of the affected account(s), the adjustment will be converted using the spot rate on file. Default currency is USD.
Entry Date	No	MM/DD/YYYY	`06/17/2012`	All	Date the adjustment was created. Blank value will set the entry date to be the same as the adjustment's post date.
Display Name	No	CHAR(30)	`John`	All	The account name you and the traders will see in reports (see Account Names). If an account already exists, the display name will only be updated if it has not been already set.
Clearing Id	No	CHAR(30)	`ABC-123`	All	The Clearing Id is the Account Id at your clearing firm (see Account Names ).
Source	No	CHAR(32)	`Sterling`	All	Source of the data being uploaded (see list of source names). If the column is not present, the source defaults to Generic.

How to Enable Uploads

Before uploading for the first time, you must to make sure the Generic data source is enabled

Step 1: Navigate to the Upload / Sources page.

Step 2: If the Generic source is in the Disabled Sources list, click Enable next to it to update the configuration.

Uploading the File

For steps to upload a file, please follow these instructions.