Ut dallas tex rev 1

How can we help?


How do I download Account Reconciliation Application (ARA) data into Excel?


There are three ways to download ARA data.
1) To download data related to one cost center, one period and one account code, you can use the 'Download to Excel' icon. This is located near the 'view all' option in each account grid in ARA and is depicted by a box with a grid and a red arrow. 2) To download data related to one cost center and one period, you can use the 'Download Actuals' tab (to the right of the Encumbrance Information tab in ARA). On that page, scroll to the far right, and use the 'Download to Excel' icon to download the data. This is located near the 'view all' option and is depicted by a box with a grid and a red arrow. This will usually yield many rows and columns of data. This downloaded data file is then often used in conjunction with the FlickBooks tool. 3) To download data related to a range of cost centers or for a range of periods, use the UTD ARA Query page. This can be found at: Main Menu > General Ledger Custom > Account Reconciliation > UTD ARA Query. For questions about how to use this page, please email Financial Compliance at fincompliance@utdallas.edu. The ARA Query will usually yield many rows and columns of data. This downloaded data file is then often used in conjunction with the FlickBooks tool. See 'What is FlickBooks' for more information.

Did this solve your problem?

HR Human Resources Payroll [] Payment Services Bursar Immigration Purchasing Information Security Employment Travel Tax Compliance Parking OCA Benefits Auxiliary Compensation FMS Safety Interviews & Hiring Budget Applying for a Job FLSA Meetings room reservation Food H1-B Visa J-1 Visa AFR Dining & Vending Emergency Police Facilities HUB Residency Surplus Inventory Employee Tuition Assistance Events Liability non-exempt Emergency Management Security Engineering Box CometSpace One Card auxillary sick leave meal plan parking ticket pay-by-space Continuity Planning Institutional Equity new position Tobacco Tobacco-Free account reconciliation Encryption Job Changes & Audits Treasury Awareness complaint ISO Policy user account Duo e-plan Infosecurity NetID Plus Administration Email Incident Response Mail Overtime work order Copies E-3 Visa parking permit Prints Public Information salary Transportation Vendor Management Camps equipment insurance identity finder insurance B-1/B-2 Visa Bookstore & Tech Store controlled asset exempt meal money student union TN Visa enforcement file sharing IDT Mobile Devices notifications PRR form Relocation UBIT DART pass EOI Letters of Representation Office Information recycle student services building student union mall alcohol booth reservation campus construction comet cab customer service fire office key Patching phishing risk assessment form Scanning academic year annual enrollment campus emergency response team cert certificate of liability crime disability permit envelopes ferpa glb act identity theft lost and found online timesheet posters property theft report training ut dallas email visitor Visitor Passes acceptable use Adverse Security Event annual security report available jobs bereavement bicycle registry brochures catering census day comet cash compliance cprit door access educational discount fmla funeral leave General goals hazardous waste hipaa Incident Reponse internal candidates key terms letterhead lone star conference room LOR mcdermott library medical appeal merit increase net id password pci-dss people involved phases photography Plan plinth area police report Procurement secure socket layer Security Incident short-term visitor stamps strategy student employee text message University Data utd-id vacation vehicle assistance Vendor waste what to report who should get familiar will preparation worker's compensation zipcar