{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Template"],"read":"whole","date_system":"1900"}

{"sheet":"Template","index":0,"n_rows":68,"n_cols":5,"rows_kept":68,"merged":[[0,3,0,4],[1,3,1,4],[2,0,2,4],[3,0,3,4],[5,1,5,3],[7,1,7,3],[68,1,68,3]]}
[{"$nulls":3},"FINANCE 401"]
[{"$nulls":3},"Revised 02/01//07"]
["County Petty Cash Accounts"]
["Monthly Reconciliation Form"]
[]
["County:  "]
[]
["Month:  "]
[]
[]
["Per Bank"]
[]
[null,"Ending Balance per Depository Account Bank Statement"]
[null,null,"Date","Amount"]
[null,"1.  Plus Deposits in Transit (deposits recorded in Quicken not on bank)"]
[null,"      from Quicken Depository Account Activity Report"]
[]
[null,"*2.  Plus Other Transactions which should have been on bank statement"]
[]
[]
[]
[null,"Total Additions",null,null,{"$f":"SUM(D15:D20)","v":{"v":0,"d":"$0.00"}}]
[]
[null,"Subtotal",null,null,{"$f":"SUM(E13:E23)","v":{"v":0,"d":"$0.00"}}]
[]
[null,null,"Date","Amount"]
[null,"3.  Minus Outstanding Checks/Clearing Account Transactions"]
[null,"      from Quicken Outstanding Check List (Total Outflows)"]
[]
[]
[null,"*4.  Minus Other Transactions recorded in Quicken not on bank statement"]
[null,"      from Quicken Depository Account Activity Report"]
[]
[]
[null,"Total Reductions",null,null,{"$f":"SUM(D27:D33)","v":{"v":0,"d":"$0.00"}}]
[]
[null,"Adjusted Bank Balance",null,null,{"$f":"+E24+E35","v":{"v":0,"d":"$0.00"}}]
[]
[]
[null,"*For any transactions listed under 2 and 4 above where the bank was in error, "]
[null,"you should contact the bank to resolve."]
[]
[]
["Per Books"]
[]
[null,"Ending Balance per Quicken Report \"Account Balance as of Previous Month\""]
[null,"    (Total Assets or Total Liabilities & Equity)"]
[null,null,"Date","Amount"]
[null,"**5.  Minus Bank Charges not recorded in Quicken"]
[]
[]
[null,"**6.  Plus/Minus Other Transactions on bank statement not recorded in Quicken"]
[]
[]
[]
[null,"Subtotal",null,null,{"$f":"SUM(D49:D54)","v":{"v":0,"d":"$0.00"}}]
[]
[null,"Adjusted Book Balance",null,null,{"$f":"+E46+E56","v":{"v":0,"d":"$0.00"}}]
[]
[null,"**Transactions listed under 5 and 6 above are to be recorded in Quicken."]
[]
[]
["Reconciled by:",null,"Date:  "]
[]
["As account custodian, I recognize that I am personally responsible for the full amount of the account entrusted to me and certify that this"]
["reconciliation represents all activity of the account for the month indicated."]
[]
["Staff Chair:",null,"Date:    "]