Spreadsheet: 24728d1215506795-designing-a-spreadsheet-for-projects-projects
Sheet: Reporting Requests

Project | Date Added | I.D | TT no | Client | Fund Code | User | Priority | Reason for Priority | Report Affected | Issue | Assigned to | Updates | Status | E.T.A |  | [NAME] on Project
Adding PRICE SOURCE to Pricing Report_RDM |  | 249565 |  |  |  |  | 1 |  | Pricing report | GLS are now bringing thru the Caliber source and we will want this in pricing report | .
Amend report_Customised (TT 291333) |  | 249125 |  |  |  |  |  |  | Customised Client Reports | reports not pulling in correct info, column J is where problem occurs. | Vivekvikash Agarwal | QA | Currenlty being worked on
NAV trigger report for Paulson, data from GLS needed (TT 263389) |  | 226131 | 263389 |  |  |  |  |  | Stored Procedures | [NAME] | [NAME] | UAT | Currenlty being worked on
TB V's Holdings & TB V's PL to be updated for Long Dated futures (TT273417) |  | 218988 | 273417 |  |  |  |  |  | TB V's Holdings and TB V's PL
TPA [NAME] all reports & datafiles sent via FTP (TT283964) |  | 242918 | 283964 |  |  |  |  |  | Holdings report | client has asked that we set up ftp versions of the reports we send over to them on a daily basis. These are holdings reports run with specific searches. Is this possible & what info do I need from the client in order to go ahead | [NAME] | DEV | Currenlty being worked on
YTD Dividend [NAME] (tt172270 & 193635) |  | 191439 | 172270 & 193635 |  |  |  |  |  | Dividend report | think the problem is in the format of this report. It combines wt for the entire year and shows it against the latest dividend income/expense entry. | [NAME] | DEV | Currenlty being worked on
01_Treatment of receipt delay on Pricing Report |  | 146300 | 204746 & 204651 |  |  |  |  |  | Pricing report | Trade date cash report and TB treated as accrued after pay date until receipt delay was up, P&L treated as paid from pay date (receipt delay being irrelevant on the P&L), not sure what holdings did but they should all be consistent, i.e. cash on TB, TD Cash, P&L and holdings should be consistent | . |  | Completed
02_Corporate Actions By Period (TT260591) |  | 224140 | 260591 |  |  |  |  |  | Corporate actions | Is it possible to add CFD securities to this Report
02_RGL Tax Lot by TaxDate (TT 286081) |  | 242516 | 286081 |  |  |  |  |  | Tax report | Realized P&L of the layering report is different from 04 realized P&L
ADdition of OTHER ASSETS onto Trueview export (TT 293550) |  | 249127 | 293550 |  |  |  |  |  | Truview | "Other Assets" is reported at the end of the holdings reports and we would like to pull this value into truView as such we need the location of this field in the database. want it added to; SP called truview_positions to collect position level position level data
Amort Report_BOSTON initialisation (TT285719) |  | 242688 | 285719 |  |  |  |  |  | Amortization report | Please develop a version of the 08 amortization report that will begin amortizing on SRI+1. This will be used for the Boston converted funds for Goldman.
Counterparty to be added for FX FORWARDS_Trueview exports (TT282693) |  | 240800 | 282693 |  |  |  |  |  | Truview | We currently do not extract any counterparty field into truview for FX forward positions. We would like to put an enhancement into our extraction stored proc so that counterparty can be pulled in for fx forwards. | Vivekvikash Agarwal | DEV | Currenlty being worked on
New Export for GSAM (tt296069) |  | 249924 | 296069 |  |  |  |  |  | Mosiki Data Export | want to be able to show cross-currency forwards on a base currency basis for each leg of the forward. | Vivekvikash Agarwal | DEV | Currenlty being worked on
rdm pricing_Brevan 4PM prices (tt 261815) |  | 224770 | 261815 |  | CSFBF | [NAME] | 1 | Need report to pull accurate prices | Pricing report |  | .
RDM Report_Pull in Forwards TT 194665 |  | 207124 | 194665 |  |  |  |  |  | Pricing report | On a daily basis the above macro is run at a Bloomberg terminal where all the various fwd rates are pulled in. The file is then circulated to all within NAV to allow them to drop in their forward contracts from the pricing report, run the macros and then populate the secondary pricing column in the pricing report with the output. As API may be in danger of shutting down due to usage we should have a backup plan whereby an actuate report would be populated with the rate data in the same format as the above letting NAV teams work from that instead. | .
Scheduling GSAMBOSII Data Exports_TT298982 |  | 251337 | 298982 |  |  |  |  |  | Mosiki Data Export | need recon reports to be schduled to run each day, PL, FX Trade, trade Cash, trial Bal, [NAME] trades.
Traxis - Cilent request to supress one trader ID on customized reports (tt 193459) |  | 186578 | 193459 |  |  |  |  |  | Customised Client Reports | IFS to supress the trader id Sergei Parmenov on these reports
VICIS Capital PRICING ISSUE adding expiration date (TT263080) |  | 233159 | 263080 |  |  |  |  |  | Pricing report | incorrect prices and prices not pulling in to report | .
01_Actuate Reports-Traxis - net exposure not consistent on reports TT 195715 - |  | 187603 | 195715
Attribution by Manager- Formula details (TT 154580) |  | 211924 | 154580 |  |  |  |  |  | Customised Client Reports | client formulas need to be cross checked with IFS
Cost & Mkt Vla roll report Amendment |  | 205036
Reconciliation Reports - 06 not showing cross currencies |  | 134356 |  |  |  |  |  |  | IGLS vs Caliber Quantity Recon | incorrect qty in GLS side for fx and repos are incoorect on Caliber side of report
(TT 254514) Actuate Reports-Cost and Market Value Roll report 06-07 does not tie |  | 229448 | 254514 |  |  |  |  |  | Cost and MktValue roll report | closing cost on the 2006 Cost and Mkt Roll report does not tie to the opening balance on 2007 report
(TT 254990) CSFBFI - IImplement SPLIT logic to excel download for 03_Tax Lot Unrealized Holdings & 02_Profit and Loss by Product |  | 220579 | 254990 |  |  |  |  |  | Tax Lot Unrealized Holdings & Profit and Loss by Product | Please implement the SPLIT logic to the excel downloads of 03_Tax Lot Unrealized Holdings & 02_Profit and Loss by Product
(TT 265249) **Actuate Reports-BH 4pm Pricing Report - need logic amended for FI Aus/Asai securities, |  | 227870 | 265249 |  |  |  |  |  | Pricing report | reporting logic issue, FI it is actually pulling the prior day close.
(TT 271206)  Mosiki Data Export - GSAMBOSII |  | 233889 | 271206 |  |  |  |  |  | Mosiki Data Export | Please mirror the GSAMBOS entity on the Data Export Function for GSAMBOS, please include the following 5 files: GoldmanSachsPL? GS_FX_Trade GS_Trade_Cash? GS_Trail_Balance? Unsettled_Trades
(TT 273396) Collapse Fixed income Swaps on Beauchamp Export |  | 234030 | 273396 |  |  |  |  |  | Beauchamp Export | Is it possible to add the "collapse Fixed Income swaps" rule to the Beauchamp Export files? As it stands we are sending the client teh Offset Line as well as the TRS line.
(TT 274669) Attachment - SEC 13F Filing |  | 235396 | 274669 |  |  |  |  |  | Holdings report | need holdings report to cross reference a funds holding to the list published by the SEC for the 13F filing
(TT 277011) Mosiki Data Export - File Breaks |  | 249685 | 277011 |  |  |  |  |  | Mosiki Data Export | Settled cash does not tie out to the TB. JPM futures cash is off by exact same amount as the citi equities cash.
(TT 278201) For DB Torus Japan Master Fund Ltd, the P+L Summary Report does not tie back to the P+L dynamic report |  | 246933 | 278201 |  |  |  |  |  | Profit and [NAME] report | DB Torus Japan Master Fund Ltd, the P+L Summary Report does not tie back to the P+L dynamic report
(TT 282302)  Touradji Trade file - data export - please add FX trades to file |  | 240187 | 282302 |  |  |  |  |  | Touradji Data export | Please can you add the FX trades to the Touradji Data export trade file
(TT 282750) DiMaio  EXPORTS - PNL FILE |  | 240440 | 282750 |  |  |  |  |  | DiMaio EXPORTS | Please update PNL mapping to not rollup positions
(TT 288529) Actuate Reports-YTD Divs report - format |  | 245171 | 288529 |  |  |  |  |  | Dividend report | report breaks down dividends earned by broker and is sorted by country. need report to run so its sorted by clearer (with income/expense details and not accruals)
(TT 290317) Julius Settle Trade Cash File |  | 245639 | 290317 |  |  |  |  |  | settle trade cash reports | files being generated are incompatible with clients system as the date in row A and B is in a different format than the one they receive.one they receives shows the date in format mm/dd/yy whereas the ones we've generated today shows it as [NAME]/dd/yyyy.
(TT 290340) **Actuate Reports-Traxis - attribution report not picking up cross ccy fx |  | 248034 | 290340 |  |  |  |  |  | Attribution report | New cross currency fx seq FX2544497 , secid 37221 p&l not being picked up on the attribution report.
(TT 293603) Actuate Reports-PnL TSS |  | 248111 | 293603 |  |  |  |  |  | Profit and [NAME] report | issue on p&l report: strategy name is to long for report and one digit is being cut off. | Vivekvikash Agarwal | QA | Currenlty being worked on
(TT208890)  [NAME] on the unsettled trades report.  The report details the correct trade date in column C7 |  | 193965 | 208890 |  |  |  |  |  | unsettled trades report | Please look at paydowns. The report details the correct trade date in column C7, but the trade date detailed for the individual securities (B9 to B16)is 01/01/00, can someone please let me know where this date is been generated from.
(TT254520) CUSIP not picking up preceding zero on the data export |  | 220128 | 254520 |  |  |  |  |  | Mosiki Data Export | When the output is downloaded to .csv the leading zeros are deleted on the file under the [NAME] field. Can the [NAME] field be changed to text in the sp.
(TT296169) TruView_Position Stored Procedure |  | 250408 | 296169 |  |  |  |  |  | Truview | add a field which stores the gls_secid for the underlying bond to which this repo is linked? | Vivekvikash Agarwal | DEV | Currenlty being worked on
04_TT114441 & TT76176 :Caliber v's GLS and P&L Only showing one side of each fx deal. Can we have the other side added? |  | 98545 | 114441 & 76176 |  |  |  |  |  | Caliber v's GLS and P&L | Can you also take a look at the Market Value columns? currently they do not rec at all
08_TB showing Holdings and PnL |  | 226658 |  |  |  |  |  |  | Trial Balance | We need to add new GL accounts to the A/P and A/R sold sections is there a mapping table or an rpt_catalog table for this which we can manually gl accounts if necessary
AAR report excel version |  | 178329 |  |  |  |  |  |  | AAR report excel version | Auto covert to excel prior to ftp or email
Accrued Interest Check - MBS traded interest double-counted (TT182162) |  | 176791 | 182162 |  |  |  |  |  | Accrued Interest Check | appears the delay pay is not backing out the 'settled' interest on this secid 1154968
Active Portal -- Fund list |  | 127170 |  |  |  |  |  |  | Active Portal | Move stored proc imssp_fund from web_fe database to GPS database. 1. Remove hardcoded reference to database GPS.. and CUSTOM.. 2. Change Active Portal to point to GPS instead of web_fe database for connection that uses imssp_fund stored proc. (Active Portal change will be done by [NAME]).
Active Portal --Report Publish info |  | 127197 |  |  |  |  |  |  | Active Portal | Move Report publish from web_fe to GPS database
Actual Search Defintions |  | 237575 |  |  |  |  |  |  | Search Defintions | Is there anywhere I can see peoples search definitions. Need to build an app that lists all ros files under GPS report folder.
Adding extra paramaters onto a customised holdings_investcorp (tt223066) |  | 202307 | 223066 |  |  |  |  |  | Holdings report | identifier fields which we don't currently use such as Isin, [NAME], [NAME], Price Ric and Ticker. If I populate these fields can the dynamic holdings pick them up?
amendment to formulae on Pricing Report TT189837 & 228168 |  | 182801 | 189837 & 228168 |  |  |  |  |  | Pricing report | 2 separate formulae to be amended on pricing report
Archive Policy on ACtuate folders (TT 263153) |  | 235709 | 263153 |  |  |  |  |  | Actuate | TA NY is having an issue with active folders being archived
[NAME] all their reports onto a disc |  | 250099 |  |  |  |  |  |  |  | [NAME]? all their reports onto a disc from inception to date. Liquidate 06.30.08
Caliber AAR Audit report |  | 212342 |  |  |  |  |  |  | Caliber
Crystal Report - Black Box project |  | 232326 |  |  |  |  |  |  | Crystal Report | Black Box project for Justin Barter (Corporate Accounting).
Downloading reports into separate tabs in excel |  | 202156 |  |  |  |  |  |  | Actuate | Can we figure out a way to download a report from actuate to excel and it will go into different tabs
Enhancement to Client Customised Report (TT 298084) |  | 250983 | 298084 |  |  |  |  |  | Actuate | Please add a column to WebReporting? > - GPS Reports > - Customized Client Reports > - Victus Reports > 01_Victus Currency Exposure which details local MTM for Swaps only.
Enhancements to YTD Dividend Report, (TT134755,190917) |  | 125894 | 134755 & 190917 |  |  |  |  |  | Dividend report | MTMNA numbers incorrect, they are being duped and do not tie to the GL activity. Other issue is MTMNA not being reflected correctly on all GL accounts it is being lumped into one GL account
Extra Data PnL export for GSIP required. (TT287622) |  | 244529 | 287622 |  |  |  |  |  | Profit and [NAME] report | Client has asked about possibility of including MTD P&L on P&L file sent daily
Forward Pricing report_RDM |  | 166084 |  |  |  |  |  |  | Pricing report | Forward pricing report
Fund server configuration for GPS3 and GPS4 |  | 165922
Holdings and GL Extracts (TT298179) |  | 251040 | 298179 |  |  |  |  |  | Holdings &and GL extracts | client is looking to receive holdings and GL extracts on a daily basis
Optimized stored proc imssp_purchase_sale when run for a few selected secids. |  | 221191 |  |  |  |  |  |  |  |  | [NAME] | QA | Currenlty being worked on
PnL Report_Exceptions |  | 211968 |  |  |  |  |  |  | Profit and [NAME] report | Oustanding requests have been combined for the [NAME] report
RDM Accrued interest amended to tie to TB (XP194717) |  | 226983 | 194717 |  |  |  |  |  | Accrued Interest Check | this report does not tie to Trial balance and has not done since 4/30/07
RDM Investment report _4 amendments (TT224211,231235 & 238610,258228) |  | 207126 | 224211, 231235, 238610, 258228 |  |  |  |  |  | RDM Investment report
RDM reports - change logic to pick up the correct BB yellow key for Fut and OPT |  | 223825 |  |  |  |  |  |  | RDM reports | change logic to pick up the correct BB yellow key for Fut and OPT
Separate the Currency Options from United States to a new line called FX Derivatives_TT 205622 - |  | 192215 | 205622 |  |  |  |  |  | Customised Client Reports | Please [NAME] a new line called FX DERIVATIVES, and move all these Currency Options from United States to there: EO-USDHKD(USD)01/28/09 7.8C (secid 1235562); EO-USDHKD(USD)01/29/09 7.8C(SECID 1238122); EO-AUDJPY(AUD)03/25/10 88C(secid 1291385); EO-GBPJPY(GBP)02/05/10 220C(secid 1244581); EOUSDAUD(USD)04/15/08 .8211P(secid 1313031); EOUSDARS(usd)11/08/07 3.05P(secid 1335800); EO-USDILS(USD)5/20/08 4.325C(secid 1357368) | .
TAX - TB vs PL rec |  | 185430 |  |  |  |  |  |  | TB vs PL | Tax wants to enhance the current TB vs PL reconciliation
Touradji Data exports, require YTD (tt272486) |  | 234519 | 272486 |  |  |  |  |  | Touradji Data export | Touradji still need year to date trade files for each fund. If you could set up a export for each of the following funds and send a export daily
Trans on Cost & Market roll rpt (TT169804, 184169, 183920) |  | 167909 | 169804, 184169, 183920 |  |  |  |  |  | Cost and MktValue roll report | report is required by the auditors and since it does not tie to the TB teams have to manually find the differences. Is there a way it could be fixed or a way to find the differences.
Treatment of Paydowns on Reports (TT159689) |  | 158057 | 159689 |  |  |  |  |  | Pricing report | Hi, can someone please take a look at the treatment of paydowns for the pricing report. We had a break on position and Market Value between the pricing report and the Holdings report and TB etc for 09/30 on secid 1051041. It looks like it was caused by a 9/30 paydown (which was a Saturday) hitting up on 9/29 for all reporting except the pricing report which reflected it on the first business day AFTER paydown date.Can someone please take a look and ensure that the pricing report is updated to reflect paydowns in the same manner as all other GLS reports. | .
TT 190917 - Add account number 25990 to the bottom of the YTD Div Report |  | 184138 |  |  |  |  |  |  | Dividend report | Can we get the account number 25990, Dividend Reclaim Receivable, added to the bottom of the YTD Div Report. Currently it gives us the account numbers 22003,32110 and 32307. If 25990 could be added here, so we are able to tie back the accrual
[NAME] for CMS |  | 228322 |  |  |  |  |  |  | unsettled cash | [NAME] for CMS to add Column for CounterParty
Remove autosys Jobs for Client CMG (tt 300869) |  | 252671 | 300869 |  | CDAFMLTD |  |  |  | data export | Hi, can you please cancel the automatic daily data exports for CMG as fund is now liquidated
Amend C_GSAMBOS Tax Lot Autosys job (TT 300976) |  | 252742 | 300976 | GSAMBOS | GEOLLC | [NAME] |  |  | Scheduled Jobs | Currently there is a job scheduled to run the file GSAM_Tax_Lot? for group C_GSAMBOS at 5:00 am EST. Can we have this time moved up to 12:00 am EST? Let me know if you need more information or have any questions. Thanks
enhancement on customized client report - Estimated performance Return (TT299657) |  | 252715 | 299657 |  |  |  |  |  | Estimated Performance Return | The MTD performance calculation does not include P&L On Class Hedges on the above report.
rename table SUDOsyslogTB to LOGIN_SUDOsyslogTB in SUDO log section of GLS and Caliber Audit version2 reports (TT296779) |  | 252897 | 296779 |  |  |  |  |  | Audit Reports | The Audit reports are failing on SUDO log server syslogprod1.Please rename table SUDOsyslogTB to LOGIN_SUDOsyslogTB in SUDO log section of GLS and Caliber Audit version2 reports. Table SUDOsyslogTB is corrupt, so we need to use new table LOGIN_SUDOsyslogTB, because we do not want to stop the audit log mySQL server. | .
Cash RecX Inaccuracies | 2008-07-03 00:00:00 | 252982 |  |  |  |  | 1 |  | Actuate | There appears to be inaccuracies with this stored proc and that of Actuate cash SP.SP id is: imssp_rxp_trans_sdate Transaxctions appear to be opposite on SP id is: imssp_rxp_trans_sdate compared to ACtuate. IR - wrong direction MAT - wrong direction FXB - wrong direction IMS_WT+ - wrong direction. New: IMS_SBOM appearing - per Orla Denning below Shouldnt hit cash, only transactions that hit Cash should be on this query.I think we need a full review/comparison of posting rules on the imssp_rxp_trans_sdate & imssp_rxp_trans vs Other Actuate Cash Reports.But if imssp_rxp_trans_sdate one could be looked at 1st as high priority as IBT are using this live to try to do transaction recon's and its causing a lot of issues | [NAME] | DEV | Currenlty being worked on
Additional options to Pricing Report (TT 268675, TT285405) ) |  | 236325 | 268675 & 285405 |  |  |  |  |  | Pricing report | Please allow users to access the following three fields in their reports as BB have changed the way they price T-Bills and Discount bonds. PX_DISC_MID PX_DISC_BID PX_DISC_ASK These fields are currently in QA in 1.7.0. Thanks, [NAME] | [NAME] | DEV | Currenlty being worked on
Pricing report issue - Not taking in full ticker and not strike price and put or call | 2008-07-04 00:00:00 | 253245 | 299144 | VICIS |  | [NAME] |  |  | Pricing report | In the execution of the report, the report is just taking the start of the ticker and not the strike price and put or call when going to RDM
Pricing_Equity Options |  | 253249 | 300959 |  |  |  |  |  | Pricing report | Pricing Equity Options
AAR Audit Report |  |  |  |  |  |  |  |  | Audit Report |  | [NAME] | DEV | Currenlty being worked on
TB extract for Investai |  | Not in XPLANNER |  |  |  |  |  |  | TB extract |  | [NAME] |  | Currenlty being worked on
Working With Datawarehouse Team |  | Not in XPLANNER |  |  |  |  |  |  |  |  | [NAME] |  | Currenlty being worked on
New tax reporting requirements are coming up so will be busy with those to |  | Not in XPLANNER |  |  |  |  |  |  | Tax report |  | [NAME] |  | Currenlty being worked on
Re Testing Chnages to imssub_unrealized_pl to avoid table scan
TB-PL Reconciliations - stored procedure and actuate report |  |  |  |  |  |  |  |  | TB - PL Reconciliation |  | [NAME] | DEV | Currenlty being worked on