Prepare the journal entry to record pooled endowment investment activity for the month.
Verify that the Banner balance after the journal entry posts reconciles to the ending investment account statement.
Copy and paste data into reconciliation worksheet tab "FGRFAAC before entry."
Verify that ending balances in spreadsheets from broker tie to investment statement.
Make a copy of the prior month's reconciliation workbook for the current month.
Copy ending values by fund to the beginning value for the new month.
Look up the fees, investment income, and ending market values of each fund from the investment worksheets.
Calculate the unrealized gain/loss for each fund (ending – beginning – investment income – fees).
Create the journal entry date from these calculations.
Format the data for upload.
Upload the JV, leaving the entry "in process."
Print out cover sheet.
Attach supporting documents.
Sign coversheet and submit to a reviewer.
Run FGRFAAC Fund/Account Activity Report again with same parameters as above after entry has been approved and posted.
Copy and paste data into reconciliation worksheet tab "FGRFAAC after entry."
Calculate differences between Banner ending balances and investment ending balances.
Investigate and correct any differences that are more than a few cents due to rounding.
Prepare the reconciliation worksheet with Banner and investment balances pulling from worksheets.
Print and sign the reconciliation worksheet.
Attach the copies of the investment statement and FGRFAAC output after entry to the reconciliation worksheet.
Submit reconciliation package to the Controller for review and approval.
File approved reconciliation documents in BDM.
Fixed asset acquisitions are recorded manually in the audit roll forward schedule which provides calculations for recording depreciation expense.
Fixed Assets Accountant
Banner general ledger, fixed assets module