FM Year End Closing Useful Information

1
FM Year End Closing Useful Information

• Knowledge Sharing Workshop
• April 27, 2005
• Rachel Carson Auditorium

2
FM Year End Closing

• Objective to open FY 2005-06 with correct
  beginning balances for prior year funds
• Pre-closing
• Preliminary projection 6/30 status
• Closing
• Lapse/expire unneeded funding
• Fund balance carryforward
• Commitment carryforward
• Budget carryforward (usually FC level 3 lowest
  level CI)
• Objective to align Actual Year data at
  detailed level for SEM-BPS FY 2006-07 budget
  preparation

3
FM Reports in BW

• Budget Execution Folder
• Budget Version Comparison Version 0 to 999
• Review Budget Subtypes - Estimated to Actual
• Review Subtypes - Estimated Augs to Actual
  Revenue (isolates Budget Subtype 2000)
• Budget Carryforward Comparisons FY 2003 to 2004
  and Beyond
• Budget Execution Projections Folder
• FY to date Payroll Posting with Projected Expense

Dont Forget FM Balances Report
4
Main BW Menu (with Budget Execution Folder open)
5
(No Transcript)
6
(No Transcript)
7
Fiscal Yr To Date Payroll Posting with Projected
Expense
8
(No Transcript)
9
FM Reports in R/3

• Payroll Default Cost Center
• Display Transaction Y_DC1_32000594
• Role FI/CO/FM Viewer
• Input overwrite PYRLDFLT
• with (your 2-digit BA) PYRLDFLT
• ie 21PYRLDFLT

10
(No Transcript)
11
(No Transcript)
12
FM Year End Closing Budget Transaction Tips
13
Budget Transaction Tips

• Transaction FMW1 Funds Block Pending Lapse
• Additions/reductions are processed using separate
  documents value adjustments cannot be processed
  against funds block pending lapse documents
• Use document type PL (pending lapse) for
  positive amounts document type NB (negative
  block) for negative amounts
• A PL can only post where a budget posting
  currently exists in subtype 1000 (current year)
  or 9000 (prior year)
• An NB can only post where a PL currently
  exists and cannot exceed the amount of the PL
  posting

14
Budget Transaction Tips

• Transaction FMW1 Funds Block Pending Lapse
• How do I determine what fund, funds center and
  commitment item combination to use to liquidate a
  funds block pending lapse?
• Use the Earmarked Funds Journal to determine
  account coding for NB reduction documents
• S_P99_41000147 - Earmarked Funds Journal

15
Budget Transaction Tips

• Earmarked Funds Journal S_P99_41000147

16
Budget Transaction Tips

• Earmarked Funds Journal S_P99_41000147

17
Budget Transaction Tips

• Transaction FMW1 Funds Block Pending Lapse
• How do I determine which fund, funds center and
  commitment item combination to use to post a
  funds block pending lapse?
• Use the BW Funds Management Balances report
  substituting Funds Center Level 3 for Funds
  Center remove commitment item hierarchy

18
Budget Transaction Tips

• Funds Management Balances report

19
Budget Transaction Tips

• Transaction FMW1 Funds Block Pending Lapse
• Always check before parking documents!
• Funds block transactions workflow from agency to
  comptroller
• Transaction processing ends when the fiscal year
  ends cannot increase or decrease a funds block
  on July 1
• IES and BFM will determine a process to centrally
  change funds blocks before posting lapses

20
Budget Transaction Tips

• Transaction FR64 Budget Return
• Use to reduce estimated augmentations and federal
  and non-federal transfer amounts in subtypes
  2000, 3000 and 4000
• Amounts must balance
• 4xxxxxx and 92xxxxx commitment items must have
  expenditure (6xxxxxx commitment item) offset
  amount

21
Budget Transaction Tips

• Transaction FR64 Budget Return
• What sign do I use on my amounts to process a
  budget return?
• ALWAYS enter amounts as positives, except for
  92xxxxx series commitment items
• 92xxxxx balance is negative (subtypes 3000 and
  4000), enter a negative

22
Budget Transaction Tips

• Transaction FR63 Budget Supplement
• Use to increase estimated augmentations and
  federal and non-federal transfer amounts in
  subtypes 2000, 3000 and 4000
• Amounts must balance
• 4xxxxxx and 92xxxxx commitment items must have
  expenditure (6xxxxxx commitment item) offset
  amount

23
Budget Transaction Tips

• Transaction FR69 Budget Transfer
• Use to re-allot budget amounts between funds
  centers and/or commitment items at the budget
  posting level (FC3/lowest level CI)
• Cannot transfer across subtypes
• Sender side must have an existing budget posting

24
Budget Transaction Tips

• Lapsing Prior Year Expenditure Credits
• Available balance resulting from credit rather
  than unused budget
• Use transaction FR69 Budget Transfer

25
Budget Transaction Tips

• Lapsing Prior Year Expenditure Credits
• Sender fund is SAP fund where credit resides
• Receiver fund is the lapse fund XX99999ZZZ
  where XX Ledger of sender fund
• ZZZ Fund type of sender fund
• Subtype is 6000 for lapse, 7000 for expiration
• Sender and receiver year is ALWAYS current fiscal
  year
• Sender and receiver commitment item is 6000020

26
Budget Transaction Tips

• Info Pak Training Documents