{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Form 11","Accounts"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":15,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Form 11","index":0,"n_rows":63,"n_cols":13,"rows_kept":63,"cut":false,"hidden":false,"merged":[[62,0,62,1],[0,0,2,6],[0,7,2,12],[3,9,3,12],[29,7,29,10],[3,0,3,1],[3,3,3,7],[6,6,6,12],[5,6,5,12],[5,0,5,3],[6,0,6,3],[4,0,4,12],[45,16,45,18],[7,0,7,1],[46,0,46,12],[58,12,59,12],[28,0,28,3],[28,6,28,12],[58,7,59,10],[14,15,14,23],[17,0,17,1],[18,0,18,1],[19,0,19,3],[19,6,19,12],[17,6,17,10],[47,0,47,3],[26,7,26,10]]}
[null,null,null,null,null,null,null,"Central Accounting and Reporting\nAGENCY CLEARING ACCOUNT/SPECIAL ACCOUNT RECONCILIATION"]
[]
[]
["Agency:                              ",null,null," For the month of:                           ",null,null,null,null,null,"Class Fund/Clearing Account:    "]
["SECTION A: Total receipts and disbursements in the month as recorded by agency"]
["TOTAL AGENCY RECEIPTS (Revenue)",null,null,null,null,null,"TOTAL PAYMENTS ISSUED FROM THIS ACCOUNT (Disbursement) "]
["(PER AGENCY'S INTERNAL RECORDS/LEDGERS)",null,null,null,null,null,"(PER AGENCY'S INTERNAL RECORDS/CHECK REGISTER)"]
["DESCRIPTION OR REVENUE ACCOUNT CODE",null,null,"AMOUNT",null,null,null,"EXPENSE ACCOUNT CODE",null,"JE & JE DATE","ASA ACCOUNT CODE",null,"AMOUNT"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"SUM(D9:D17)","v":0},null,null,null,null,null,null,null,null,{"$f":"SUM(M9:M17)","v":0}]
[]
["TRANSFERS IN",null,null,null,null,null,"TRANSFERS OUT"]
[]
[]
[]
[]
[null,"Total transfers in",null,{"$f":"SUM(D21:D24)","v":0},null,null,null,null,null,null,"Total transfers out",null,{"$f":"SUM(M21:M24)","v":0}]
[]
[null,"Net agency receipts",null,{"$f":"D18+D25","v":0},null,null,null,"Net disbursements as recorded by agency",null,null,null,null,{"$f":"M18+M25","v":0}]
[]
["SECTION B: BALANCE VERIFICATION",null,null,null,null,null,"SECTION C: PER OST RECORDS"]
["1.","Beginning cash balance per prior month Form 11",null,null,null,null,"1.","Ending cash balance from treasurer's activity statement (last page attached)"]
[]
["2.","Add: Net receipts as recorded by agency",null,{"$f":"D27","v":0},null,null,"2.","Reconciling items"]
[null,null,null,null,null,null,null,"Deposits in transit (add/positive)"]
[null,null,null,null,null,null,null,"Outstanding payments (reduce/negative)"]
[null,null,null,null,null,null,null,"Deposit corrections"]
["3.","Less: Net disbursements as recorded by agency",null,{"$f":"-M27","v":0},null,null,null,"Chargebacks "]
[null,null,null,null,null,null,null,"Core wires "]
[null,null,null,null,null,null,null,"Credit cards "]
[null,null,null,null,null,null,null,"Outstanding transfers "]
[null,null,null,null,null,null,null,"Other "]
[]
[]
[]
["4.","Ending cash balance per agency records",null,{"$f":"+D36+D32+D30","v":0},null,null,"3.","Reconciled cash balance per OST",null,null,null,null,{"$f":"SUM(M30:M43)","v":0}]
[null,null,null,null,null,null,null,"must equal Section B-4 Ending cash balance per agency records"]
[]
[]
["SECTION D: PER PEOPLESOFT RECORDS"]
["1.","Ending Cash Balance from SRD Report (attached)"]
[]
["2.","Reconciling Items"]
[null,"Total payments as recorded by agency\n(pending JE in PS)"]
[null,"Deposits in transit ",null,null,null,null,null,"Final balance line (must be zero) B&C",null,null,null,null,{"$f":"D44-M44","v":0}]
[null,"Deposit corrections",null,null,null,null,null,"Final balance line (must be zero) B&D",null,null,null,null,{"$f":"D44-D60","v":0}]
[null,"Chargebacks"]
[null,"Core wires/credit cards"]
[null,"Outstanding transfers"]
[null,"Other"]
[]
["3.","Reconciled cash balance per SRD",null,{"$f":"SUM(D49:D59)","v":0}]
[null,"must equal Section B-4 Ending cash balance per agency records",null,null,null,null,null,"Signature and title of chief fiscal officer",null,null,null,null,"Date"]
[]
["OMES CAR Form 11 (Rev. 9/2025)"]

{"sheet":"Accounts","index":1,"n_rows":4,"n_cols":1,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["Accounts"]
["553190 Refunds-Overpayment Charges"]
["561210 Taxes Remitted to OK Tax Comm"]
["Stat Cancel (if applicable)"]