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 for upcoming training.
Month-End Reconciliation Training
- Accounts Receivable and Reimbursement Reconciliation (PDF) (3/12/2024)
- Encumbrance Reconciliation (PDF) (3/12/2024)
- PFA and SCO/Agency Reconciliation (PDF) (4/3/2024)
- PFA Reconciliation Procedure (PDF) (2/28/2024)
- PFA Reconciliation Template (XLSX) (2/28/2024)
- SCO/Agency Reconciliation Procedure (PDF) (2/28/2024)
- SCO/Agency Reconciliation Template (XLSX) (2/28/2024)
- General Ledger Account Balance Reconciliation (PDF) (4/3/2024)
- Cash in State Treasury Account Reconciliation Procedure (PDF) (4/3/2024)
- Cash in State Treasury Account Reconciliation Template (XLSX) (2/26/2024)
- Deposits in Surplus Money Investment Fund Reconciliation Procedure (PDF) (4/3/2024)
- Deposits in Surplus Money Investment Fund Reconciliation Template (XLSX) (2/26/2024)
- Office Revolving Fund and Bank Reconciliation (PDF) (3/12/2024)
- Office Revolving Fund Reconciliation Procedure (PDF) (3/12/2024)
- Office Revolving Fund Reconciliation Template (XLSX) (3/12/2024)
- Bank Reconciliation Procedure (PDF) (3/12/2024)
- Bank Reconciliation Template (XLSX) (3/12/2024)
- Property Reconciliation (PDF) (3/12/2024)
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 (2/19/2024)
- 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)
-
Year End (YE)
The information on this page includes the most common entries required for B/L reporting. Additional requirements for year-end reporting can be found in state policies and other information provided by the SCO for GAAP reporting purposes.
-
- 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 Accrual Entries (YE-A)
-
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 (11/09/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)
-
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 FSCUTraining@dof.ca.gov.
Subscribe for email notifications of FI$Cal Resources for Accounting webpage updates.