FY9900 Closing and FY0001 Opening Training

1
(No Transcript)
2
Diagnostic Reports

• Tuesday, April 14

3

• FAST
• Lynn Gabenski 303-866-2626
• Tom Gamache 303-866-3890
• Susan Meade 303-866-4161
• Trinka Mullin 303-866-4162
• Tammy Nelson 303-866-3891
• Brenda Shelinbarger 303-866-4165

4
Diagnostic Reports

• Available in INFOPAC/Document Direct and FDW
• Chapter 5, Section 1 of FPM -Purpose of the
  reports
• Assist agencies in monthly, quarterly and annual
  close
• Identifies statutory overexpenditures
• Long Bill Line Item
• Revenue underearning
• Assurance--year end processes complete.

5
Diagnostic Reports

• INFOPAC/Document Direct Reports
• Available quarterly only the day after calendar
  close.
• Available monthly on the Monday preceding month
  end close.
• Available monthly on the first business day after
  final close.

6
Diagnostic Reports

• Financial Data Warehouse (FDW) reports
• Reflect activity through previous days business
• Available when you arrive at work each day
• Be aware when two COFRS periods are open at the
  same time, FDW reports are for closing period
  ONLY.
• As of March, 2009 new reports only available on
  FDW.

7
Diagnostic Reports

• See pages 277 278 of the Fiscal Procedures
  Manual for a grid comparing INFOPAC/Document
  Direct reports to FDW reports.

8
Abnormal Balance Reports

• DOACABN1/DGABN1A,DGABN1D
• Lists possible errors based on
• Account Balance
• Type of account
• Debit balance revenue
• Account/fund combination
• Payroll codes in capital construction fund

9
Matching Object Codes between Governmental and
GFAAG

• DOACGFA1 / DGGFA1D
• Report helps to reconcile capitalized purchases
  expended in governmental funds with the amount
  capitalized in the GFAAG.
• Displays totals for each object code as well as
  for the department.
• Object codes that do not total to zero indicate a
  problem.
• Capitalize the amount or
• Transfer to different object code.

10
Budget to Actual by LBLI

• DOACEL1 / DGOEL1D
• Shows overexpenditures at the Long Bill Line
  level.
• All items on this report indicate a potential
  statutory overexpenditure that must be addressed
  by the department.

11
Budget to Actual

• DOACOEX1, DOACOEX2, and DOACOEX3 / DGOEX1D,
  DGOEX2C,DGOEX3A
• Each report provides similar information for
  different levels of the COFRS three character
  agency code.
• DOACOEX1-department level
• DOACOEX2-agency class level
• DOACOEX3-individual agency level

12
Budget to Actual

• The report allocates expenditures for each
  funding source code within a long bill group to
  the various types of revenue sources
• Federal
• Reappropriated
• Cash
• General exempt
• General
• Chapter 3 Section 1.5 (unless using positive
  coding)

13
Budget to Actual

• Calculates two types of variances
• (Over)/Under expended
• Accrued revenue over/under expenditures
• Problems indicated if
• Negative total at the FSC level or Long Bill
  group level in the (Over)/Under Expended column.
• Negative total in the FSC level or Long Bill
  group level in the Accrued Revenue Over/(Under)
  Expenditures column.

14
Budget to Actual

• Expenditures allocated to the general exempt
  revenue type with no spending authority indicates
  an overexpenditure.
• This means that the expenditures have
  inappropriately used the fund balance of the
  general fund.
• Will be noted by a newly created budget line with
  X as the GCF indicator and 0 budget.

15
Transfer Balances

• DOACXFR1
• The reports show intrafund and interfund activity
  separately.
• In addition, for higher education institutions
  the report splits certain activity into a second
  section within the intrafund and interfund
  categories.
• Non-higher education institutions will only have
  the section one intrafund and interfund reports.

16
Transfer Balances

• On the report transfers are grouped by the first,
  second and third characters of the transfer code.
• This matches both departments transaction
  information on the report.
• Problems are indicated whenever the report total
  line beginning with TRANSFER ACCOUNT MATCH
  TOTAL is not zero.

17
Diagnostic Reports

• Working session.
• Bring your Diagnostic reports
• We will review items together

18
Questions?
19
THE END