Financial Accounting and Reporting provides services that include interim and year-end financial closings (e.g. journal entries, Cognos financial reports, University financial statements), general ledger maintenance (e.g. new funds, departments, accounts, activity codes and location codes), capital projects, fixed assets and equipment inventories, sponsored grants, endowment and gift accounting, and banking and treasury.
The information contained on this page will assist with the following:
- Year-End and Interim Closings
- Journal Entries
- Financial Reporting via Cognos
- Reporting Deadlines
Please feel free to forward any reporting questions you have to Valarie Waddell and Jennifer Killingsworth. Thank you for visiting – we look forward to serving you.
Banner Financial Training through Cognos
The documents below are critical to proper financial reporting. The macros are used to format reports once they are produced through Cognos. Be sure to save this file in the D:\Userdata\Excel directory.
- Campus Financial Reporting Instruction Manual - updated 8/21/14
- Campus Financial Reporting Quick Guide - updated 6/26/14
- Demonstration Video: Using Excel Macros for Cognos 8.4 Reports
- Downloading and Installing Macros for Excel 2007 Instructions
- Downloading and Installing Macros for Excel 2010 Instructions
- Financial Reporting Macros
This presentation will assist managers of petty cash and change funds in understanding their responsibilities for disbursement, documentation and safeguarding of University resources.
This presentation will provide guidance to the campus community on the steps necessary to prepare, support, approve, and submit journal entries.
Frequently Asked Questions
|What are the monthly deadlines/cut-off days?||All journal entries are due to Financial & Accounting Services (FAS) by the 2nd business day after month end.Cash receipts received by FAS by 11am of the last business day of the month will appear on your monthly reports.||Financial Reporting|
|When are monthly reports available?||Monthly reports will be available by the morning of the 6th business day of the following month. The Cognos user listserv will be notified via email when reports are ready.||Financial Reporting|
|How do I read my monthly reports?||Please sign up for a Cognos Financial Reporting Training through the PDC website or email firstname.lastname@example.org.||Financial Reporting|
|How do I get questions researched?||Invoice & Payment questions: Accounts Payable: email@example.com. |
Deposit questions: Accounts Receivable: firstname.lastname@example.org
Payroll entry questions: Payroll: email@example.com.
All other questions should be directed to Ruth Smith at firstname.lastname@example.org or email@example.com.
|Can I receive goods during this fiscal year and expense them in the next fiscal year?||If an item is received by June 30, it must be expensed in June. There are no exceptions to the rule.||Financial Reporting|
|How do I receive a copy of a department's monthly report?||Please request approval for access to Cognos by placing a ticket through the Remedy system.||Financial Reporting|
Monthly Reporting Deadlines
- All Journal entries are due to Financial & Accounting Services (FAS) by the 2nd business day after month end.
- Cash receipts received by FAS on or before 11:00 a.m. by the close of the last business day of the month will appear on your monthly reports.
- Monthly reports will be available by the morning of the 6th business day of the following month.
- 2014-15 Mid Year Close Calendar provides important dates for our December 2014 close period
- 2014-15 Closing Calendar provides important dates for FY15
- 2013-14 Closing Calendar provides important dates for FY14.
Chart of Accounts Dictionary
Below is a listing of commonly used expense accounts, including definitions, examples, related accounts, and commonly mistaken accounts. Questions regarding this dictionary should be directed to firstname.lastname@example.org.
Fiscal Year End
For information, procedures, and all important information regarding year end, please go to the FYE Administrative Procedure.
Click the Forms tab to view the following critical year-end related forms:
- Travel & Entertainment Voucher
- Expenditure Voucher
- Deposit Accruals
- Deposit Revenue
Links to other important information:
Journal Entry Template
Example Journal Entry
Account Reconciliation form
Travel & Entertainment Voucher through December 31, 2013
Travel and Entertainment Expense From travel as of January 1, 2014