The Department of Finance, Fiscal Systems and Consulting Unit (FSCU) provides classroom training, eLearning courses and query information to assist state departments using the Financial Information System for California (FI$Cal).
Upcoming Training
Please check back in the Fall for upcoming training.
Month-End and SCO Agency Reconciliation Training
- Presentation – Session 1 (3/30/2023)
- Presentation – Session 2 (11/21/2022)
- PFA Handouts (3/27/2023)
- PFA Template (11/29/2022)
- SCO Agency Recon Handouts (3/22/2023)
- SCO Agency Recon Template (10/19/2022)
Year-End Training
- Presentation – Session 1 (6/7/2023)
- Fiscal CMO email dated 5/5/2023: For Your Information – Year End Deadlines (6/7/2023)
- Presentation – Session 2 (6/21/2023)
- Report 1 Exercise
- Report 2 Exercise
- Report 15 Exercise
Revised Addendum 2019-20 Supplemental Pension Assessment (2/2021)
Overview Training
- Presentation (4/2022)
- Handouts (1/2021)
Chart of Accounts Crosswalk
The Chart of Accounts (COA) crosswalk of PeopleSoft, Hyperion and Legacy account codes.
- Chart of Accounts – Descriptions (11/9/2020)
- Chart of Accounts – Crosswalk of Accounts to Legacy Accounts-Department Use (06/27/2023)
- Chart of Accounts – Update Communication (10/5/2018)
eLearning Courses
Training courses to assist departments with transaction posting by module, month-end and year-end processes, and reports and queries. Material confirmed as accurate at the time of publishing. Business processes may change with current and future SCO milestone releases. We are reviewing and updating the eLearning Courses and classroom training material to reflect any changes from these functionalities. We will post the updated courses as soon as they become available.
Click here for eLearning Revision Summary.
-
General Ledger (GL)
-
Accounts Receivable (AR)
- AR1 – Create a Customer For Employee
- AR2 – Record Payroll Accounts Receivable
- AR3 – Approve Payroll
- AR4 – Record SCO Transfer State Share ARO
- AR5 – Approve SCO Transfer State Share ARO
- AR6 – Record SCO Collection of PAR
- AR7 – Approve SCO Collections of PAR
- AR8 – Create Customer for Non Employee
- AR9 – Record AR Reimbursement
- AR10 – Record AR Revenue
- AR11 – Approve AR Reimbursement Revenue
- AR12 – Record Collection Billed AR (Bank Deposit)
- AR13 – Record Collection Billed AR (Direct Transfer)
- AR14 – Approve Collection Billed AR
- AR15 – Record Collection Unbilled Receipt Uncleared Collection
- AR16 – Record Collection Unbilled Receipt Miscellaneous Receipts
- AR17 – Approve Collection Unbilled Receipt Uncleared Collection
- AR18 – Record Collection Unbilled Receipt Salary Advance
- AR19 – Approve Collection Unbilled Receipt Salary Advance
- AR20 – Record and Approve Collection of Reverting Appropriations for Abatements and Reimbursements before June 30
- AR21 – Record and Approve Collection of Reverted Appropriations for Abatements and Reimbursements after June 30
-
Accounts Payable (AP)
- AP1 – Create Regular Voucher without PO Receipt (Utilities)
- AP2 – Create ORF Voucher for Salary Advance
- AP3 – View and Correct Voucher Build Errors
- AP4 – Create Regular Voucher with PO Receipt
- AP5 – Undo Matching PO Process
- AP6 – Delete a Voucher
- AP7 – On-Demand Voucher Budget Check and Manual Voucher Post
- AP8 – Create Journal Voucher to Replenish ORF
- AP9 – Review and Correct 1099 Withholdings
-
Cross Module Process (XM)
-
Reports and Queries (RQ)
-
Month-End (ME)
- ME1 – Month-End Close Process
- ME2 – GLA 1140 Reconciliation_Non-Shared-Funds_Procedures (3/30/2023)
- ME2 – GLA 1140 Reconciliation_Non-Shared-Funds_Blank Template (03/15/2023)
- ME3 – GLA 1140 Reconciliation_Shared-Funds_Procedures (3/30/2023)
- ME3 – GLA 1140 Reconciliation_Shared-Funds_Blank Template (03/15/2023)
- ME4 – Revolving Fund Reconciliation Procedures (3/30/2023)
- ME4 – Revolving Fund Reconciliation Blank Template (03/15/2023)
- ME5 – Bank Reconciliation Procedures (3/30/2023)
- ME5 – Bank Reconciliation Blank Template (03/15/2023)
- ME8 – FI$Cal to SCO Monthly Reconciliation Report – Power BI (6/4/2021)
-
Year End (YE)
- Year End Accrual Entries (YE-A)
- YE – A-1 Record Undeposited Receipts (7/20/2023)
- YE – A-2 Adjust ORF and Cash (7/17/2023)
- YE – A-3 Accrue Reimbursements and Abatements (7/17/2023)
- YE – A-4 Manually Reclassify AR Abatements and Reimbursements for Reverted Appropriations (7/17/2023)
- YE – A-6 Record Receivables Due from SMIF and Condemnation Deposits (9/29/2023)
- YE – A-8 Accrue Accounts Payable with No Open Purchase Orders (7/17/2023)
- YE – A-8 Accrue Accounts Payable Open Purchase Orders (7/20/2023)
- YE – A-9 Accrue Revenue (7/17/2023)
- YE – A-10 – Adjustment for Dishonored Checks (7/17/2023)
- YE – A-12 Establish Reserve for Deferred (7/17/2023)
- YE – Encumbrance Liability Reclassification (7/21/2023)
- YE – PFA – Record Year-End Plan of Financial Adjustment (7/17/2023)
- Year-End Reports (YE)
Please note: YE eLearning materials will be updated on a flow basis.- YE – Material Variance Explanation Form (8/09/2023)
- YE – Report 1 (8/08/2023)
- YE – Report 2 (8/08/2023)
- YE – Report 3 (8/08/2023)
- YE – Report 4 (8/08/2023)
- YE – Report 5 (08/08/2023)
- YE – Report 6 (08/08/2023)
- YE – Report 7 (8/23/2023)
- YE – Report 7 Subsidiaries on File (08/18/2023)
- YE – Report 8 (08/18/2023)
- YE – Report 9 (08/18/2023)
- YE – Report 13 (08/08/2023)
- YE – Report 14 (08/08/2023)
- YE – Report 15 (08/08/2023)
- YE – Report 18 (08/08/2023)
- YE – Report 19 (08/08/2023)
- YE – Report 20 (08/08/2023)
- YE – Report 22 (08/08/2023)
- Year End Report Templates
- Sample Year-End Workplan 2022-23 (4/17/2023)
- Year-End Report Checklist (6/24/2022)
- Year End Accrual Entries (YE-A)
Queries and Reports
A list of public queries created by Finance to support FI$Cal users. The queries are stored in the “DOF” folder.
- Finance DFQ Support Form (7/07/2021)
- FI$Cal Queries and Reports (4/12/2023)
Please send your DFQ requests and inquiries to DFQSupport@dof.ca.gov.
Departmental Support
General accounting support for departments using FI$Cal is available by contacting FSCUhotline@dof.ca.gov.
The FI$Cal Resources for Budget page provides instructions for Hyperion users, FI$Cal budget letters, and Program and Capital Outlay Project Crosswalks.
Please send your feedback and questions regarding this webpage and training to fscuhotline@dof.ca.gov.
Subscribe for email notifications of FI$Cal Resources for Accounting webpage updates.