YEAR-END REPORT NO. 15, RECONCILIATION OF AGENCY ACCOUNTS WITH TRANSACTIONS PER STATE CONTROLLER - 7976

(New: 06/2014)

This report assures the accuracy and completeness of a department's revenue and expenditure accounts reported on its year-end financial reports. The Report No. 15 presents a reconciliation of a department's nominal accounts, the 8000 and 9000 series general ledger accounts with transactions per the State Controller as of June 30. The fund administrator will also record in their accounting system and include on the Report 15 certain statewide assessments charged to the fund. Submit this report with other year- end financial reports to the SCO.

A sample and instructions of how to complete Report No. 15, Reconciliation of Agency Accounts with Transactions per State Controller, is shown in the 7976 Illustration 1 and Illustration 2.

7976 Illustration 1 (Revised 03/14)

 

 

 

Agency Name and Number

Fund Name and Number

REPORT NO. 15 RECONCILIATION OF AGENCY ACCOUNTS WITH TRANSACTIONS PER STATE CONTROLLER

FISCAL YEAR ENDING JUNE 30, 20XX

 

 

 

 

 

REPORT NO. 15

 

 

Reverse Prior Year (PY)

 

 

Apply Current Year (CY)

 

 

Transactions per Agency Accounts

 

 

 

 

 

 

 

 

 

(A)

(B)

(C)

(D)

(E)

(F)

(G)

(H)

(I)

(J)

(K)

(L)

(M)

(N)

(O)

(P)

 

Transactions
per
Controller

Adjustments to Controller's Accounts

Accruals

Corrections made
by Controller's

Adjustments
to
Controller's Accounts

Accruals

Total
of
Columns
(A)-(F)

Appropriation Expenditures (9000)

Reimburse-ments
(8100)

Revenue
(8000)

Refunds to Reverted Appropriations (9891)

Prior Year Appropriation Adjustments
(9893)

Prior Year Revenue Adjustments
(9892)

Operating Transfers In
(9811)

Operating Transfers Out
(9812)

Statewide
Assessments

 

 

 

 

 

 

 

 

 

 

Item 5555-0001-001Chp20/CY

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

State Ops FY __ / __

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

10A-Registrations

24,675,103.72

 

 

 

 

12,410,445.43

37,085,549.15

37,085,549.15

 

 

 

 

 

 

 

 

20B-Evaluations

5,861,864.82

 

 

 

 

2,036,656.64

7,898,521.46

7,898,521.46

 

 

 

 

 

 

 

 

30.01C-Administration

9,435,288.94

 

 

 

 

2,992,991.88

12,428,280.82

12,428,280.82

 

 

 

 

 

 

 

 

30.02D-Distributed Admin

-9,432,648.72

 

 

 

 

-2,995,632.10

-12,428,280.82

-12,428,280.82

 

 

 

 

 

 

 

 

99Clearing Account

10,967,098.95

 

 

 

 

-10,967,098.95

0.00

0.00

 

 

 

 

 

 

 

 

90E-Reimbursements

-3,424,308.45

 

 

 

-768,931.73

-1,781,600.01

-5,974,840.19

 

-5,974,840.19

 

 

 

 

 

 

 

97Revolving Fund Advance

500,000.00

 

 

 

 

-500,000.00

0.00

 

 

 

 

 

 

 

 

 

98Advance to SRF

300,000.00

 

 

 

 

-300,000.00

0.00

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Item 5555-0001-001Chp21/PY

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

State Ops FY __ / __

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

10A-Registrations

4,084,368.09

 

-5,245,872.25

 

 

1,235,550.21

74,046.05

 

 

 

 

74,046.05

 

 

 

 

20B-Evaluations

862,301.97

 

-963,449.90

 

 

130,777.97

29,630.04

 

 

 

 

29,630.04

 

 

 

 

30.01C-Administration

1,428,793.73

 

-1,507,507.90

 

 

3,901.34

-74,812.83

 

 

 

 

-74,812.83

 

 

 

 

30.02D-Distributed Admin

-1,428,793.73

 

1,507,507.90

 

 

-3,901.34

74,812.83

 

 

 

 

74,812.83

 

 

 

 

99Clearing Account

-5,067,167.35

 

5,393,521.22

 

 

-326,353.87

0.00

 

 

 

 

0.00

 

 

 

 

90E-Reimbursements

-1,334,785.96

 

1,840,313.97

 

 

-440,488.14

65,039.87

 

 

 

 

65,039.87

 

 

 

 

97Revolving Fund Advance

-500,000.00

500,000.00

 

 

 

0.00

 

 

 

 

 

 

 

 

 

98Advance to SRF

-200,000.00

 

200,000.00

 

 

 

0.00

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Item 5555-0001-001Chp33/PPY

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

State Ops FY __ / __

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

10A-Registrations

62,999.69

 

-208,055.50

 

 

 

-145,055.81

 

 

 

 

-145,055.81

 

 

 

 

20B-Evaluations

5,831.61

 

-22,117.68

 

 

 

-16,286.07

 

 

 

 

-16,286.07

 

 

 

 

30.01C-Administration

39,004.69

 

-28,835.57

 

 

 

10,169.12

 

 

 

 

10,169.12

 

 

 

 

30.02D-Distributed Admin

-39,004.69

 

28,835.57

 

 

 

-10,169.12

 

 

 

 

-10,169.12

 

 

 

 

99Clearing Account

-172,766.73

 

172,766.73

 

 

 

0.00

 

 

 

 

0.00

 

 

 

 

90E-Rimbursements

-190.88

 

48,261.48

 

 

 

48,070.60

 

 

 

 

48,070.60

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Revenue - Current Year

-45,091.73

 

 

 

 

-222.77

-45,314.50

 

 

-45,314.50

 

 

 

 

 

 

Refunds to RevertedApprop

-4,893.35

 

 

 

 

 

-4,893.35

 

 

 

-4,893.35

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

SCO – GAAP Assessments

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

200.45

DOF – FSCU Assessments

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

600.50

FI$CalAssessments

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

10,000.00

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

TOTAL

36,573,004.62

0.00

1,715,368.07

0.00

(768,931.73)

1,495,026.29

39,014,467.25

44,984,070.61

-5,974,840.19

-45,314.50

-4,893.35

55,444.68

0.00

0.00

0.00

10,800.95

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

7976 Illustration 2

(Revised 03/14)

 

Agency Name and Number

Fund Name and Number

RECONCILIATION OF AGENCY ACCOUNTS WITH TRANSACTIONS PER STATE CONTROLLER

Fiscal Year Ending June 30, 20XX

 

Column

 

 

Description

 

 

A

 

 

 

Transactions Per Controller - Enter from the “Expend/Revenue” column of the Controller’s Agency Reconciliation Report at June 30, 20XX.

Enter the Revolving Fund Advance and Service Revolving Fund Advance from the “Advance” column of the Controller’s Agency Reconciliation Report.

Enter the amounts for the prior year advances from last year’s Report 15.

 

B

 

 

Reverse prior year Adjustments to Controller’s Accounts. Enter reversal of last year’s Report 15, Column E, Adjustments to Controller’s Accounts.

 

 

C

 

 

Reverse prior year Accruals. Enter reversal of last year’s Report 15, Column F, Accruals.

 

D

 

 

Reverse PY Corrections Made by Controller’s. Enter reversal of any prior year corrections made by SCO to Report No. 1, Report of Accruals to Controller’s Accounts and Report No. 3, Adjustments to Controller’s Accounts.

 

 

E

 

Current year Adjustments to Controller’s Accounts. Enter from Report No. 3, Adjustments to Controller’s Account.

 

 

F

 

 

Current year Accruals. Enter from Report No. 2, Accrual Worksheet. Use amounts from the last column of Report No. 2 titled “Net Total Accruals Per Agency” and use opposite sign.

 

G

 

 

The total of columns A through F must equal the total of columns H through O.

 

 

H - O

 

Columns H through O must agree with the corresponding nominal accounts, 8000 and 9000 series accounts, on the Pre-Closing Trial Balance, Report No. 7.

Use additional columns to identify other accounts as necessary.

See 7962 Illustration 1 for detail.

 

 

P

 

Statewide Assessments include assessments for (1) SCO reporting for the Comprehensive Annual Report (GAAP reporting); (2) Finance, Fiscal Systems and Consulting Unit; and (3) Financial Information System for California.

 

The Fund Administrator will record and report Statewide Assessments. Obtain amounts from Controller’s Journal Entries for these assessments which will display the organization code of the department assessing the charge (e.g., 0840 for SCO, 8860 for Finance.) Do not include statewide assessments for charges recorded against your department’s organization code, as these types of assessments are charged to your department’s appropriations (e.g., Pro Rata.)

 

CALSTARS departments which submit manual year-end reports will report statewide assessments in Column P. The statewide assessments in Column P will be independent of other figures on Report 15. The total of Column H, Appropriation Expenditures must agree to total expenditures (GL 9000) on the Pre-Closing Trial Balance (Report No. 7). CALSTARS departments should refer to the CALSTARS Procedure Manual for detailed instructions on how to record the transactions.

 

Non-CALSTARS departments will report statewide assessments as expenditures in Column H, Appropriation Expenditures. Total appropriation expenditures on Report 15 must agree to total expenditures on Report 7, the Pre-Closing Trial Balance.

 

 

Print Entire SAM Manual