1 / 34

Fiscal Year End Training

Fiscal Year End Training. Banner Finance Fiscal Year 2013-14. Year End Schedule & Instructions. The complete year end schedule & instructions can be found in Campus Connect within the Quick Links Channel Click Infonet Then click Departments Then click Finance

gallia
Download Presentation

Fiscal Year End Training

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Fiscal Year End Training Banner Finance Fiscal Year 2013-14

  2. Year End Schedule & Instructions • The complete year end schedule & instructions can be found in Campus Connect within the Quick Links Channel • Click Infonet • Then click Departments • Then click Finance • Then click Year End Close Review the entire schedule and instructions to become familiar with it.

  3. What is “Fiscal Year End”? Fiscal year end is essentially closing the financial ledgers at the end of a twelve-month accounting period so that Financial Statements may be prepared. Upon completion of the Financial Statements, an audit is conducted by external auditors who render an opinion on the Financial Statements.

  4. Why is Fiscal year end so important? To ensure that the College’s activities from July 1, 2013 through June 30, 2014 are accurately & completely represented by financial transactions which will ultimately become the College’s audited Financial Statements. Normally, the biggest challenge is determining whether a transaction should post to June (fiscal year being closed) or July (new fiscal year). This will be discussed later in the presentation.

  5. Financial Transactions What arethe“financial transactions” of the college? Vendor Invoices & Payments Payroll Checks  Journal Entries Recording Depreciation Capitalizing Fixed Assets Grant Billings Cash Receipts from Students

  6. Key Dates/Deadlines

  7. Key Dates to Remember! Reference the Year End Close Schedule for specific times • 06/4 Last day to enter requisitions in Ivy Market for FY 2013-14 (all employees should plan ahead!) Regional management may impose earlier deadlines if desired. • 06/6 All FY 2013-14 requisitions in Ivy Market must be approved by 5:00pm • 06/16 May begin entering requisitions in Ivy Market for FY 2014-15

  8. Key Dates to Remember! Continued Reference the Year End Close Schedule for specific times • 06/27 No Financial Aid disbursements • 06/30 Last day of activity in Banner A/R which will feed to FY 2013-14 • 07/01 Roll of General Ledger balances (assets & liabilities) to FY 2014-15 • 07/8 Last day for regions to enter & complete JVs for FY 2013-14 • 07/8 Last day to input on PHAREDS to allow feed to FY 2013-14

  9. Key Dates to Remember! Continued Reference the Year End Close Schedule for specific times • 07/8 • Last day to input vendor invoices & credit memos for FY 2013-14 • Last day to enter fixed asset adjustments and disposals for FY 2013-14

  10. Key Dates to Remember! ContinuedReference the Year End Close Schedule for specific times • 07/9 • No entry on FAAINVE • Last day to close unneeded purchase orders and general encumbrances for FY 2013-14 • All Otags & Dtags must be converted to permanent tags • Approve all June invoices, June JVs, & fixed asset adjustments out of approval queues • All incomplete finance documents must be removed

  11. Key Dates to Remember!ContinuedReference the Year End Close Schedule for specific times • 07/10 No entry on FAAINVE • 07/10 & 11 Chris Ruhl reviews open encumbrances • 07/11 Remaining open encumbrances for FY 2013-14 are rolled to FY 2014-15 • 07/11 Budgets for inception-to-date funds are rolled to FY 2014-15 • 07/14 Office of the President-Finance begins input of final year end adjustments and journal entries and preparation of Financial Statements.

  12. Transaction Dates & Fiscal Periods

  13. Transaction dates are the “driving force” that determine which month a transaction posts to. • The date of final approval does not determine which month a transaction posts to.

  14. Transaction Dates • During fiscal year end close, users will be able to enter a transaction to either fiscal year. • The system will always default the current date for the transaction date. • Users may change the transaction date to a June 2014 date or a July 2014 date to enter it against the correct fiscal year. • Transactions with a June 2014 date (or prior) will post to FY 2013-14. • Transactions with a July 2014 date (or later) will post to FY 2014-15

  15. Fiscal periods at Ivy TechA fiscal year at ITCC runs from July to June.

  16. General Ledger Roll

  17. General Ledger roll – July 1 • General ledger (G/L) ending balances for FY 2013-14 (assets and liabilities) are rolled once to FY 2014-15 beginning balances on the evening of July 1. (performed by Finance System Administrator) • The document numbers for the G/L roll start with “CGLR” and have a transaction date of July 1 (period 00). • Banner then allows concurrent year processing. This means any transaction posted to June after the G/L balance roll will update the June ending balance and the July beginning balance at the same time. This is why some transactions appear to “double-post”. They basically post to both fiscal years’ balances. • The rolled balances post to fiscal period “00” in the new year and the concurrent transactions also post to period “00” in the new year.

  18. General Ledger roll – July 1 Concurrent Year Processing Illustrated Period 12; June 2014 Period 00; July 2014 ActivityTrans.ActivityTrans. DateDateDateDate 7/1/14 End. balance 5,000.00 cr 7/1/14 7/1/14 CGRL1401 Beg Bal. 5,000.00 cr 7/2/14 6/30/14 JV000001 300.00 cr 7/2/14 6/30/14 JV000001 300.00cr 7/3/14 6/30/14 JV000002 1,000.00 dr 7/3/14 6/30/14 JV000002 1000.00dr June Final Ending Balance 4,300.00cr July Final Beginning Balance 4,300.00cr

  19. Fixed Assets & Inventory Items

  20. Fixed Assets & Inventory Items • July 8 deadline: • All FFAADJF transactions (adjustments & disposals) for FY 2013-14 should be completed to allow time for approval. Be sure to use a June 30 or prior transaction date. • July 11 deadline: • All OTags and DTags from FY 2013-14 must be converted to permanent tags. • FFADEPR must be set up for all depreciable capital tags which had an invoice transaction date of June 30 or prior. • Depreciable capital tags with an invoice transaction date of June 30 or prior must have a depreciation start date on FFADEPR of June 30 or prior (within FY 2013-14).

  21. Fixed Assets & Inventory Items-Continued • Write off adjustments for Capital items which are physically disposed of in FY 2014-15 (July or later) should not be entered on FFAADJF until after depreciation is run for FY 2013-14. The reason is because Banner does not distinguish what fiscal year the asset was disposed of for depreciation purposes. If the new year write off is posted prior to the depreciation run for the old year, Banner will not calculate depreciation for the old year on that asset. Fixed Asset Custodians will be notified when depreciation has been run. We anticipate running depreciation for the old year the last week of August.

  22. Encumbrances

  23. Purchase Orders & General Encumbrances • July 9 • Regions & CO close unneeded POs and general encumbrances from FY 2013-14. Use a June (or prior) transaction date. • July 10 & 11 Chris Ruhl review open encumbrances • July 11 5:00pm roll of encumbrances to FY 2014-15. • Process takes balances of open purchase orders and general encumbrances from FY 2013-14 and rolls them into FY 2014-15. • The document numbers for the Encumbrance roll start with “CENR” and have a transaction date of July 1. • Performed by Finance System Administrator

  24. Accounts Payable

  25. Accounts Payable – Invoices & credit MemosKey Factors • When a vendor invoice is received there are 3 key questions to ask: • 1. When was this product or service received by ITCC: June 30 and prior or July 1 and later? Create two stacks of invoices based upon your answer. • 2. Does an encumbrance exist for this product/service? • 3. If an encumbrance exists, what fiscal year is the encumbrance in? Note that info on the vendor invoice. • The transaction date of the posted invoice will be the month the expense is recorded in; not when the check is issued!

  26. Accounts Payable – Invoices & credit Memos Merchandise & services received by ITCC Through June 30 Merchandise & services received by ITCC through June 30

  27. Accounts Payable – Invoices & credit MemosMerchandise & services received by ITCC July 1 or later

  28. Budget Roll

  29. Budget Roll • July 11, 5:00pm: Budget Roll to FY 2014-15 • This process takes budget available balances for inception-to-date funds from FY 2013-14 and rolls them into FY 2014-15. • The document numbers for the Budget roll start with “CBDR” and have a transaction date of July 1. • Performed by Finance System Administrator

  30. Grants

  31. Grant Management • Words of Wisdom from the SPA Office • Grant financial reporting will be challenging the first fiscal quarter of FY 2015 (July 1 – Sept 30) so plan ahead: • Check Balances • Work with SPA to resolve concerns • Work with Project Directors to effectively manage accounts • Don’t put issues off until too late

  32. Document Management

  33. Document Wranglin’ • Don’t let your Banner Finance documents get out of control! • Ensure JVs, requisitions, vendor invoices, etc. have proper supporting documentation scanned or attached to ensure timely reviews and approvals. • Review all June documents in Banner approval queues on a regular basis so that they are all approved/denied by July 9, 2014. • Remove incomplete documents on a regular basis so that they are all removed by July 9, 2014.

  34. QUESTIONS Ivy Market questions: Contact Andy Williams Banner Finance questions: Contact Joy Abel-Kraft

More Related