-
2009 Interactive Year End Calendar (requires Flash Player)
-
2009 Year End Calendar (PDF 1.5MB)
-
Brio Database Password Change Guide (PDF 143kB)
-
Brio FAQs [Permalink]
FAQs
General Questions
Do I need to download the Brio Plug-in everytime I use Brio?
No. You only need to download the plug-in once. Please note that there is a bug in Internet Explorer v7 that asks users to download the plug-in every tome they run a report. If this happens, just cancel the download and you will be able to run your report.Do I automatically have access to Brio?
On September 1, 2008 all current eReports users will automatically have access to Brio. Current Brio users will retain access. Anyone who does not currently have eReports or Brio will need to fill out a Security Authorization form which is available on the CDV web site at http://www.nyu.edu/cdv.Can I use Brio on my home computer?
Yes, you must use a VPN client to access the NYUHome or NYU Reporting website. Then you can download the Brio plug-in and use Brio on your home computer. The VPN client can be obtained on the ITS website at http://www.nyu.edu/its/software/vpn/.Can you save the navigation to the financial reports folder in Brio to your desktop?
You will need to navigate from the root folder to the financial reports folder in order view the available standard reports.Why is Brio not directly compatible with a Macintosh?
Currently there are limited high-end financial reporting systems that are compatible with Macintosh that would meet NYU’s financial reporting needs. The systems available on the market for Macintosh users are not up to NYU’s standards.Do MAC users need to download the Brio plug-in?
Yes, everyone must download the Brio plug-in.Can I download the Brio Plug-in from the Reporting Website?
No, you must download the Brio Plug-in from NYUHome.Will the Data Dictionary be available from NYUHome?
The Data Dictionary will be available through the NYU Reporting page (https://www.nyu.edu/financial.services/reporting) which will launch in September 2008. There will also be a direct link to the Data Dictionary from Administrative Services which is accessible from NYU Home.Can I run more than one report at a time?
If you access Brio through the NYU Reporting page (https://www.nyu.edu/financial.services/reporting) you will be able to run more than one report at a time using different browser windows.How will I load and obtain queries that I currently use?
The views have changed in the new reporting environment; therefore, you will not be able to access your current Brio queries after September 1stCan I use Brio on a SAFARI browser?
No. Please use Internet Explorer 6 (IE6) or higher, or Netscape 7.0.1.Will I be notified when historical data is migrated into Brio?
Yes, the FSUP team will communicate exact dates with the financial reporting community.Can I see more examples of the standard reports?
Yes, as the standard reports are finalized, we will post to the FSUP website a demonstration of the report with an audio voiceover explaining the report details.What definitions will be in the Data Dictionary on September 1, 2008?
All of the new Views/Objects will be defined, and all of the new reports will be defined. We will also define business terms and hope to have them complete by the go live date as well.
Report-specific QuestionsCan we get a report for check clearing date/ notification when checks are issued to vendors?
Yes, this field will be available on at least one of the standard reports. This functionality is currently being developed.If a check is paid on multiple projects will you be able to see the prices of the check per project?
Yes, as long as the Projects are added to your chartfield selections.Can I combine and associate PO Activity with General Ledger Activity?
You cannot combine standard reports, but can create ad hoc queries in Brio to meet this need.Will you be able to type in report variables and limits?
You will not be able to type in these fields or select from available variables and limits on the first release of Brio in September. However, we will be adding this feature as an enhancement to Brio at a later date.Will indirect cost be encumbered in this new system?
Indirect costs does not get encumbered.Where will the T & E Reports be?
T&E reports are available through fiscal year end in eReports and will then be available through a reporting mechanism with the new system, Maximus.
Can you pull a Salary Expense Report by Employee ID (especially useful when T & E is spread across multiple projects)?
The current structure of the Salary Expense Report has not changed.Can you have the detailed report viewable from the summary report?
No. You will have to run the detailed report separately.Can you run a report on individual on salaries?
Not in Brio financials. Instead, use the Salary Expense report for this information.Is there a drill-down capability to determine the details of the OBR Summary Expense (SER, PO, etc)?
BISRAD is working on a solution to allow users to view the details of the OBR Summary Expense Report. Information on this feature will be communicated at a later date.Will account descriptions be available in Brio?
Yes, you can view an account description in the Account Summary report.Is it possible to have an option on the Checks Issued Report to search by vendor name instead of vendor ID?
Both Vendor Name and Vendor ID are available fields in the Checks Issued Report. An available parameter for this report is Vendor ID. You can also pen the bqy file to do a search based on Vendor Name.Will there be an “account” field in the Summary Report (with the ability to limit)?
Account is a parameter field that you can limit on for all reports including the Budget Report. -
Brio Financial Reporting Support as of March 16, 2009 [Permalink]
Beginning Monday, March 16, 2009, support for the Standard Financial Reporting Library will be enhanced to provide more immediate and targeted answers to customer's requests. We have organized our new support solutions model into a multi-tiered structure with ITS Client Services (x8-3333) as the first point of contact for answers to issues in the BRIO reporting environment. As a result of this new support model, user inquiries can be directed to either askITS@nyu.edu or x83333, Option 3. ITS Client Services will log each inquiry into their tracking software to ensure all customer service requests are resolved in a timely manner.
When the answer is not within the purview of ITS Client Services, they will immediately route your issue or question to the appropriate department in Financial Operations and Treasury (CDV), or the Budget Office. These groups have committed to responding within designated timeframes (determined by the type of incident or question), and will either resolve your issue immediately, or provide you with an estimate of the amount of time a resolution will require.
Please go to http://www.nyu.edu/financial.services/cdv/resources-pg76 to find a description of standard services for the Financial Operations and Treasury and Budget Office teams.
Getting Help
Please contact ITS Client Services by calling x8-3333. Then select option "3" to reach their Administrative Systems Support team. If you wish to request help regarding the Financial Reporting environment via email, please send your inquiry to askITS@nyu.edu.
-
Brio Reports Matrix (PDF 29kB)
-
Brio Reports Self-Help Troubleshooting Guide (PDF 996kB)
-
Budget Control Error Description [Permalink]
Description Cause Resolution ChartField Translation Error The Budget Control Module could not translate one or more chartfields on the distribution line to a valid budget distribution. Contact Rayard Hosein (x82725) CDV Financial Information systems. Org Budget Data Not Found The fund on the transaction line is designated as requiring organization (expense) budget control; however, the system could not find an organization (expense) budget for this chartfield combination. (Fund 10,12 : Fund /Org, Funds 14,16: Fund/Org/Program Either change the chartfield values to point to a different budget or prepare a BIA adjustment to budget for this chartfield combination. Project/Grant Data Not Found The project chartfield on the transaction line designates that this project requires project/grant budget control; however, they system could not find a matching project/grant budget in the project/grant budget table. Contact John Hernandez
Research/Restricted Acc Svcs
Tel: (212) 998-2889
john.l.hernandez@nyu.edu
Insufficient Organization Bud The remaining spending authority for the organization (expense) budget for this chartfield combination was not sufficient to cover this transaction. (Fund 10,12 : Fund /Org, Funds 14,16: Fund/Org/Program Either change the chartfield values to point to a different budget or prepare a BIA adjustment to increase spending authority. Organization Budget is Frozen The chartfield combination on the transaction line indicates that the organization (expense) budget has been/is frozen. Either change the chartfield values to point to a different budget, or contact the Budget Office to determine if the freeze can be removed. Insufficient Proj/Grant Bud The remaining spending authority for the Project budget is not sufficient to cover this transaction. Either change the chartfield values to point to a different budget, or contact John Hernandez,
Research/Restricted Acc Svcs
Tel: (212) 998-2889
john.l.hernandez@nyu.eduProject/Grant Budget is Frozen The chartfield combination on the transaction line indicates this project budget is frozen. Either change the chartfield values to point to a different budget, or Contact John Hernandez
Research/Restricted Acc Svcs
Tel: (212) 998-2889
john.l.hernandez@nyu.eduPurchase Order Over Liquidated This Voucher distribution line is over the Purchase Order distribution line encumbrance amount.The Voucher amount exceeded the encumbrance amount plus the tolerance. Contact Purchasing to increase the PO amount. Project/Grant Data Not Found No budget data was found in the for this project. Contact John Hernandez
Research/Restricted Acc Svcs
Tel: (212) 998-2889
john.l.hernandez@nyu.edu
Insufficient Funding Source The Project/Grant chartfield value on the transaction line is designated as requiring funding source control; however, the sum of the funding sources is not enough to cover the transaction amount. Contact John Hernandez
Research/Restricted Acc Svcs
Tel: (212) 998-2889
john.l.hernandez@nyu.eduOutside Proj/Grant Budget Date One of the following is true: Contact Rayard Hosein (x82725) CDV Financial Information systems. a) transaction date on the distribution line is earlier than the project budgets begin date b) begin date of the budget period of the distribution line is later than the project budgets' end date c) end date of the budget period of the distribution line is earlier than the projects budgets' begin date. Invalid Project/Grant Date The transaction date (usually the document's accounting date) does not fall within the Project/Grant budget begin and end dates. Contact John Hernandez
Research/Restricted Acc Svcs
Tel: (212) 998-2889
john.l.hernandez@nyu.edu
-
Budget Control Error Processes & Report (PDF 72kB)
-
Cost Transfer Interim Guidelines (PDF 44kB)
-
eReports Name Mapping to Brio Standard Reports [Permalink]
Old Ereport Name Current Standard Report Library Name Report Description Budget Exception Report Budget Exception Report Reflects budget fails for transactions from General Ledger, Accounts Payable and the Purchasing modules when the transactions are fed to the Commitment Control module (where budgets reside). Project Activity Summary Project Summary Report Provides Budget to Actual status of individual grant-related projects. ACH Banking Audit Report Electronic Payment Audit Report Fund Balance Report Fund Balance Report Month end summary report which includes fund balance (inception to date), revenue and all expense activity. Checks Issued Payment Status Report Reflects all payments and the status of that payment made via check, wire transfer, Account Clearing House to a vendor or through a manual payment process. PO Activity Purchase Order Detail Report Summarizes Purchasing and Accounts Payable transactions in one report Unpaid Voucher Report Unpaid Approved Voucher Report Shows all direct pay documents (non purchase order) pending payment or audit review. Negative Confirmation Processing Unpaid PO Voucher Report Shows purchase order invoices that have been entered for payment. All purchase orders are placed on a 10 day hold to allow for review and cancellation of any payments that should not be processed Budget Summary Report Budget Summary Report Summarizes budget, actuals and encumbrances to yield available balance. Salary Expense Report Salary Expense Report This report provides Payroll History by employee or all chartfields (fund, org, program, project and account). This is a combination of FAME and HRIS data. Budget Detail Report - General Ledger/KK Detail Report Budget Detail Report Summarizes budget, actuals and encumbrances to yield available balance and also provides budget and actual transactions at a journal line level. UPS Weekly Charges UPS Weekly Charges Shows UPS invoices by Deptid and Date Range and shows whether or not they have been paid. -
fame Account Numbers with Descriptions (updated 5/29/09) [Permalink]
An "Account" is a 5-digit number in fame that is used in recording online such financial transactions as revenue and expenses. The Account Description identifies that type or purpose of an account, which helps users to assign the most appropriate account code for a financial transaction.
Click here for a listing of all accounts in PDF form. (PDF 192kB)
-
Financial Reporting Support Matrix [Permalink]
Support Group Scope of Service Hours of Operation Estimated time of Initial Response Estimated time of Resolution CDV
Sponsored Programs AccountingAnswer questions and resolve issues regarding reports on projects within Funds 24 and 25 excluding those report issues outlined below. M–F, 9am–5pm Two business days. Three to five business days. CDV
General & Restricted AccountingResolve issues regarding posted transactions, missing revenue and expenses, post chartfield setup questions, and general financial questions for Funds other than Funds 24 and 25. M–F, 9am–5pm Email response within one business day. Most issues within three business days; if unable to resolve, progress notification within three business days. CDV
PayrollAnswer questions and resolve issues regarding the Salary Expense Report. M–F, 9am–5pm One business day. Two to three business days. CDV
Accounts Payable Customer Service CenterAnswer questions and resolve issues regarding payments and purchase order reports. M–F, 9am–5pm One business day. One to two business days. Exceptions: two to three business days. CDV
fame Help DeskReceive new and change access request documents for the financial reporting environment, salary expense reports (SER), and chartfield values viewable in the standard reports library. M–F, 8:30am–5:30pm Two business days. New access: three to five business days; chartfield changes: two to three business days. Budget Office Answer questions and resolve issues concerning missing budgets and budget exceptions in standard financial reports except Funds 24 and 25 budgets. M–F, 9am–6pm One business day. Two to three business days. -
Fund Codes with Descriptions (PDF 89kB)
-
Instructions for Adding a Signature to Email [Permalink]
Click on the following links for instructions on how to add a signature to your outgoing email.
Creating a Signature in Eudora (PDF 188kB)
Creating a Signature in Lotus Notes (PDF 51kB)
Creating a Signature in NYUHome (PDF 61kB)
Creating a Signature in Outlook 2003 (PDF 528kB) -
Journal Entry Management System (JEMS) Support [Permalink]
Journal Entry Management System (JEMS) Support
The Journal Entry Management System (JEMS) was developed through a collaboration between the Controller's Division and ITS to improve the internal controls relating to the creation, approval, and validation of "Actuals" journal entries posted in the University's general ledger (FAME). JEMS is being implemented through a phased approach. Units currently utilizing JEMS are listed in the User Guide.
JEMS User Guide (PDF 148kB)
JEMS Access Form (PDF 848kB)
-
Journal Source Contact List [Permalink]
Area Source Contact Name Contact Phone Contact Email Accounting Operations G- prefix Terry Ten Eyck 8-2915 terry.teneyck@nyu.edu Accounting Operations X- prefix Terry Ten Eyck 8-2915 terry.teneyck@nyu.edu Accounts Payable: - Bookstore
AP Bill Bechtel 5-3987 wjb3@nyu.edu - Central Supply and Staples
AP Scott Lewis 8-1201 scott.lewis@nyu.edu - Payment Tech ( JPMorgan Chase)
AP Susan Snyder 8-1033 susan.snyder@ nyu.edu - Payroll
AP Charlene Hamblin 8-2966 charlene.hamblin@
nyu.eduAdvertising ADV Denise Truitt 8-6835 denise.truitt@nyu.edu Bookstore BOK Bill Bechtel 5-3987 wjb3@nyu.edu BSR/Gifts BSR Tony Wong 8-2798 tony.wong@nyu.edu Department of Media Production/ NYU Photo Bureau DMP Elisa Guarino 8-6871 elisa.guarino@nyu.edu Financial Reporting Jennifer Mitchell 8-2746 jennifer.mitchell@nyu.edu Financial Reporting Upload JV FUL Jennifer Mitchell 8-2746 jennifer.mitchell@nyu.edu General Acctg Upload JV GUL Terry Ten Eyck 8-2915 terry.teneyck@nyu.edu Web Communications EMS Cheryl Barkin 2-9925 cheryl.barkin@nyu.edu "Heating, Ventilating, Air Conditioning" HVC Cedric Jackson 5-3267 cedric.jackson@nyu.edu Stephen Brennan (212) 443-0186 stephen.brennan@
nyu.eduNetwork Connection ITS Erin O'Malley 2-9260 erin.omalley@nyu.edu Loeb Student Center (Catering) LOB Nicolle Bruechert 8-4961 nb6@nyu.edu Mail Services ZMS Edgar Castro 8-1014 edgar.castro@nyu.edu Petty Cash: PCH Peter Chian 8-2711 prc2@nyu.edu Alberta Showalter 8-2820 ams4@nyu.edu Photo Bureau PHO Genevieve St. Louis 8-6827 genevieve.stlouis@
nyu.eduPayroll PR1234 David Houlihan 8-2946 david.houlihan@nyu.edu Publications PUB Mindy Anderson 8-6824 mindy.anderson@nyu.edu Reprographics REP Jim Gibby 8-1057 jim.gibby@nyu.edu SPA - Sponsored Programs Accounting S- prefix Richelle Ash or
Baboucarr N’Dow8-2953
8-2714SCPS SCP Carlo Pellicciari 8-7021 cqp1324@nyu.edu SIS-Student Information System SIS Larry Hitchcock 8-4477 larry.hitchcock@nyu.edu Bursar TCR Alberta Showalter 8-2820 ams4@nyu.edu Telecommunications TEL Katherine Miranda 8-1239 kathy.miranda@nyu.edu Lucas Molina 8-1227 lucas.molina@nyu.edu Ticket Central TKT Lori Kraus 8-4421 lori.kraus@nyu.edu Utility Services - Plant USD Stevenson Holder 5-3320 sh3@nyu.edu Backup for these EDI's are stored by Individual Departments. UPS AP Fisher Scientific AP Headway AP -
May 8, 2009: Financial Forum Presentations [Permalink]
Please note, all presentation files are available only to forum attendees and require a password to open. The password was emailed to attendees on May 11—if you would like to have this information emailed to you again, please contact Tom Brazda at tom.brazda@nyu.edu.
1. Welcome – Martin Dorph
2. Endowment Status – Martin Dorph
3. Budget (PDF 72kB) – Anthony Jiga
- Fiscal 2009 Budget
- Fiscal 2010 Budget
- New Budget Model
- Fiscal 2010 Budget Calendar (PDF 32kB)
4. Student Loans (PDF 36kB) – Richard Bing
5. Program Services Office (PDF 32kB) – Renaud Fournier
- Overview of the Office
- Status of key administrative systems projects
6. Student Information System (PDF 216kB) – Roger Printup
- Fiscal 2009 Budget
-
Payroll Deadline Schedule for November 2009 (PDF 83kB)
-
Payroll Distribution Report (PDF 18kB)
-
Payroll Journal Translation [Permalink]
The 10 position payroll journal ID can be translated as follows:
Journal ID for Payroll Cycles:
1st three positions denote type of action
PED Payroll Actuals PER Encumbrance Relief for payroll cycle PEA Encumbrance Adjustment PEC Encumbrance Correction PES Encumbrance Set-up (Initial annual encumbrance load)
4th and 5th positions denote the month
01-Jan 02-Feb 03-March 04-April 05-May 06-June 07-July 08-August 09-Sept 10-Oct 11-Nov 12-Dec
6th position denotes the type of payroll
1, 2, 3, 4, 5 Weekly 6, 7, 8 Bi-weekly 9 Monthly
7th to 10th positions denote the calendar year of the transaction
Example: PED0192004 would translate to: Monthly payroll Actuals for January 2004
Journal ID for Daily Encumbrance Transactions:
1st two positions denote type of action
DB Daily encumbrance debit CR Daily encumbrance credit
3rd and 4th positions denote the month (same as above) 5th and 6th positions denote the day of month 7th and 8th positions denote the calendar year of the transaction 9th and 10th positions are used for payroll transaction identification
Example: DB09240321 would translate to: Daily debit encumbrance adjustment for 09/24/03
-
Time & Effort Reporting Resources [Permalink]
Resources are now available online for Time and Effort Reporting using NYU's Effort Reporting System (ERS). A valid NYU NetID and password are required to view the following:
Resources
T&E Faculty Announcement (PDF 73kB)
Policy on Effort Reporting for Sponsored Programs at Washington Square (PDF 969kB)
Faculty Effort Guidelines (PDF 143kB)
Effort Reporting System Process Flowchart (PDF 227Kb)
Training on the Use of the Maximus ERS Presentation (PDF 500kB)
This overview of the ERS was presented at the training sessions held June 16–18, 2009.Department Coordinator Quick Guide (PDF 271kB)
Certifier & PI Quick Guide (PDF 50kB)
Dental School Faculty Training Presentation (PDF 380kB)
This overview of the ERS was presented at the training session for Dental School faculty on July 9, 2009.VPN Client Download and Setup Instructions
Online Tutorials
To take the following courses, users need a computer with Internet access, a web browser with Flash Player 7 or higher, and headphones or speakers.
ERS 101: An Introduction to the Effort Reporting System (Flash Player required; duration: 15 min.)
This course is an introduction to NYU's Effort Reporting System (ERS). It will answer questions about the system's features including: online certification, home departments, Certifiers, user roles, line certification, 9 over 12 conversion, salary caps, K-awards, and cost transfers.ERS 201: All About the NYU Effort Reporting System (Flash Player required; duration: 30 min.)
This tutorial is a step–by–step review of the effort certification process using NYU's Effort Reporting System. It will cover the following scenarios: changing certifier assignments, pre-review of the effort form, certification by Principal Investigator, certification by faculty, post-review, reporting, and view/read-only pre-review. -
Transfer Accounts Matrix (XLS 52kB)
