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 |
| All | Date on which the adjustment should post. |
Account | Yes | CHAR(20) |
| All | Name of the account (PropReports Account Id). Anything after the first 20 characters will be ignored. |
Offset Account | No | CHAR(20) |
| 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) |
| All | Can be a name of an adjustment category currently defined in PropReports or one of: |
Amount | Yes | DECIMAL(15, 4) |
| 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) |
| 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.