{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Instructions","OCH Ledger","Acct Codes Quick Guide"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":2,"defined_names":11,"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":"Instructions","index":0,"n_rows":50,"n_cols":10,"rows_kept":50,"cut":false,"hidden":false,"merged":[[15,0,15,13],[17,0,17,8],[19,0,19,8],[20,0,20,13],[16,0,16,13],[18,0,18,5],[17,9,19,13],[24,0,24,5],[24,6,24,8],[25,0,25,13],[34,0,34,5],[34,6,34,8],[32,0,32,5],[32,6,32,8],[33,0,33,13],[30,0,30,5],[30,6,30,8],[5,0,5,13],[4,0,4,13],[1,0,1,2],[1,3,1,5],[2,0,2,13],[3,0,3,13],[7,0,7,13],[10,9,10,12],[8,0,8,5],[9,0,9,13],[8,6,8,8],[8,9,8,13],[10,0,10,5],[10,6,10,8],[28,0,28,5],[29,0,29,13],[38,0,38,13],[27,0,27,13],[37,0,37,13],[35,0,35,13],[31,0,31,13],[6,0,6,13],[48,0,48,13],[39,0,39,13],[41,0,41,13],[44,0,44,13],[46,0,46,13],[47,0,47,13],[45,0,45,13],[40,0,40,13],[42,0,42,13],[22,0,22,5],[14,0,14,5],[0,0,0,5],[0,6,1,13],[12,0,12,5],[12,6,12,8],[12,9,12,13],[13,0,13,13],[11,0,11,13],[14,9,14,13],[43,0,43,13],[49,0,49,13],[18,6,18,8],[22,6,22,8],[26,6,26,8],[28,6,28,8],[36,0,36,5],[36,6,36,8],[26,0,26,5],[23,0,23,13]]}
["LEDGER - OPERATING CASH-ON-HAND",null,null,null,null,null,"Please contact Joe Potyraj  if you have problems with this workbook.  The Excel workbooks and worksheets I design are protected, but no passwords are assigned.  This inhibits the inadvertent deletion of formulas and links, but allows users to modify worksheets as necessary.  To unprotect a worksheet, click \"Tools / Protection / Unprotect Sheet\".  I recommend that, once any given sheet is modified, the user reprotect the sheet by clicking \"Tools / Protection / Protect Sheet\".  Do not enter a password when reprotecting the worksheet."]
["Workbook created in 2006 by: ",null,null,"Dave Coddington\nEmergency Operations TA\nEmergency Response Team\nNairobi, Kenya\n"]
["Use of the Workbook"]
["This workbook may be used to electronically track transactions by DSPN made from Operating Cash-on-Hand (OCH) balances and to simultaneously monitor the overall operating cash position of the field office.  The EFR Finance Officer may also use this form as a liquidation report of OCH (A/C 1075) project advances for program activities and operations transferred from the Country Program / Regional Office to the field office.  This form does NOT represent an official report that will be used by the Country Program to document transactions to HQ/Finance - the only system that is considered \"official\" is CRS' SUN accounting software.  This form simply allows the EFR Finance Officer to track transactions and report to the Country Program / Regional Office Finance Department, which will in turn make the appropriate entries into SUN using CRS approved vouchers, and then report to HQ/Finance.  The field office should NOT submit these forms directly to HQ/Finance unless so requested by the Country Program Finance Office, Regional Office or HQ/Finance."]
["Macros"]
["This file contains Macros written in Visual Basic for Applications (VBA) code.  It automatically formats the OCH Ledger for you through various links and keyed macro commands.  In order for the macros to work properly, your computer's security settings must be set to medium or low (medium is recommended).  Click \"Tools / Macro / Security\" and select either the Medium or Low option.\nIf the High Security option is selected: the macros will not work.\nIf the Medium Security option is selected: each time you open files that contain VBA macros, you will be asked if you want to enable or disable them.  Select \"Enable.\"\nIf the Low Security option is selected: the macros will work and you will not receive any warning messages.  However, this may put your computer at risk from macros in programs imported from unknown sources and is therefore NOT recommended."]
["Set default options"]
["Set up worksheet default values as instructed below:"]
["Enter the name of the country in which you are working.",null,null,null,null,null,null,null,null,"PLEASE ENTER COUNTRY NAME IN ALL CAPS!"]
[]
["Enter the name of the field office at which you are working."]
[]
["Enter the currency you using (enter a \"currency code\").",null,null,null,null,null,null,null,null,"(E.G., USD, CFA, CFR, ETC.)"]
[]
["Check if the currency does or does not require decimal points Þ"]
[]
[]
[null,null,null,null,null,null,null,null,null,"Verify the Cash Account DSPN with the CP Finance Office or RFO."]
["Enter the DSPN for the Cash Account."]
[]
[]
[]
["Enter the DSPN funding the project.",null,null,null,null,null,"DSPN #1"]
[]
["Enter the DSPN funding the project.",null,null,null,null,null,"DSPN #2"]
[]
["Enter the DSPN funding the project.",null,null,null,null,null,"DSPN #3"]
[]
["Enter the DSPN funding the project.",null,null,null,null,null,"DSPN #4"]
[]
["Enter the DSPN funding the project.",null,null,null,null,null,"DSPN #5"]
[]
["Enter the DSPN funding the project.",null,null,null,null,null,"DSPN #6"]
[]
["Enter the DSPN funding the project.",null,null,null,null,null,"DSPN #7"]
[]
["Enter the DSPN funding the project.",null,null,null,null,null,"DSPN #8"]
[]
["After the default values are set above, save the file as an Excel Template (.xlt):  click \"File / Save As\"  and a window will appear.  \nSave as type: select \"Template\"\nEnter a file name: type \"Ledger - OCH (Field Office-Country)\""]
["To open a new Excel workbook template:\nClick \"File / New / Spreadsheet Solutions\" and select \"Ledger - OCH (Field Office-Country).\"  \n\nTo save the workbook:\nClick \"File / Save As / [Save In]\" select a destination on the C: drive or create a folder\nSave as type: select \"Microsoft Excel Workbook\"\nFile name: type \"Ledger - OCH (Field Office-Country) (Reporting Period)\""]
["Format the workbook and worksheets:"]
["To copy and insert additional rows, including formulas: on any worksheet, place the cursor in a cell on the row below which the copied row is to be inserted and press CTRL-I.  Each key entry copies and inserts one (1) row below the cursor."]
["Some Tips and other Functions:"]
["REPORTS:  Use the filters to sort data in various ways and eliminate empty rows for printing.  To eliminate empty rows, activate the filter in cell H4.  Select \"(NonBlanks)\" from the crop-down menu to eliminate all rows with no data.  Filter buttons turn BLUE when activated."]
["To create additional sheets for OCH Ledger data (e.g., \"OCH Ledger (mmX-yy)\",  \"OCH Ledger (mmY, yy\"…):  select the worksheet tab \"OCH Ledger (BLANK), press CTRL, left click on the tab and drag it to the desired location while holding the CTRL key."]
["Worksheets can be named for the period covered.  Double click on the worksheet name tab, and enter the period covered by the data."]
["Warning!"]
["Do not change the order of columns in the worksheets."]
["Do not change the name of this \"Instructions\" sheet."]
["Do not use a password to protect the sheets."]

{"sheet":"OCH Ledger","index":1,"n_rows":109,"n_cols":16,"rows_kept":109,"cut":false,"hidden":false,"merged":[[4,1,4,3],[107,0,107,3],[108,0,108,3],[108,14,108,15],[4,10,4,15],[107,5,107,9],[108,5,108,9],[101,5,101,7],[107,14,107,15],[104,5,104,7],[1,0,3,0],[1,2,3,2],[1,5,1,8],[1,4,3,4],[1,1,3,1],[1,3,3,3],[103,4,103,7],[102,5,102,7],[1,11,2,15],[0,8,0,9],[1,9,1,10],[0,11,0,14],[2,5,2,6],[2,7,2,8],[0,6,0,7],[0,0,0,5]]}
[{"$f":"\"CRS \"&Instructions!$G$9&\" GENERAL OPERATING CASH (1075) LEDGER\"","v":"CRS  GENERAL OPERATING CASH (1075) LEDGER"},null,null,null,null,null,"FIELD OFFICE:",null,{"$f":"Instructions!$G$11","v":0},null,"PERIOD:"]
["Date","Voucher /\nRef. No.","Acct . & Sub-Acct Codes","T4\n(Vendor)","Description of Transaction\n(include Vendor / Employee name)","GLOBAL CASH POSITION",null,null,null,"EMPLOYEE AND VENDOR ADVANCES",null,"DEBITS (EXPENSES) BY DSPN"]
[null,null,null,null,null,"DSPN:",null,{"$f":"IF(Instructions!G19=\"\",\"\",Instructions!G19)","v":""},null,"DSPN:",{"$f":"IF(H3=\"\",\"\",H3)","v":""}]
[null,null,null,null,null,"Opening Balance/\nReplenishments","DEBIT\n(Cash In)","CREDIT\n(Cash Out)","BALANCE","DEBIT\n(Advances)","CREDIT\n(Liqudations)",{"$f":"IF(Instructions!$G23=\"DSPN #1\",\"\",Instructions!$G23)","v":""},{"$f":"IF(Instructions!$G25=\"DSPN #2\",\"\",Instructions!$G25)","v":""},{"$f":"IF(Instructions!$G27=\"DSPN #3\",\"\",Instructions!$G27)","v":""},{"$f":"IF(Instructions!$G29=\"DSPN #4\",\"\",Instructions!$G29)","v":""},{"$f":"IF(Instructions!$G31=\"DSPN #5\",\"\",Instructions!$G31)","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(G5=0,0,G5)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null," ",null,null,"COLUMN TOTALS:",{"$f":"SUM(F$5:F99)","v":0},{"$f":"SUM(G$5:G99)","v":0},{"$f":"SUM(H$6:H99)","v":0},{"$f":"I104","v":0},{"$f":"SUM(J$5:J99)","v":0},{"$f":"SUM(K$6:K99)","v":0},{"$f":"SUM(L$6:L99)","v":0},{"$f":"SUM(M$6:M99)","v":0},{"$f":"SUM(N$6:N99)","v":0},{"$f":"SUM(O$6:O99)","v":0},{"$f":"SUM(P$6:P99)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(G99-H99=0,0,G99-H99)","v":0},{"$f":"IF(J99=0,0,J99-K99)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(G100-H100=0,0,G100-H100)","v":0},{"$f":"IF(J100=0,0,J100-K100)","v":0}]
[null,null,null,null,"CASH BALANCE ENDING AND SUM OF UNLIQUIDATED ADVANCES:",null,null,null,{"$f":"IF(G101-H101=0,0,G101-H101)","v":0},{"$f":"IF(J101=0,0,J101-K101)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(G102-H102=0,0,G102-H102)","v":0},{"$f":"IF(J102=0,0,J102-K102)","v":0}]
[]
[]
[]
["PREPARED BY (SIGNATURE AND DATE)",null,null,null,null,"REVIEWED BY (SIGNATURE AND DATE)",null,null,null,null,null,null,null,null,"APPROVED BY (SIGNATURE AND DATE)"]

{"sheet":"Acct Codes Quick Guide","index":2,"n_rows":49,"n_cols":8,"rows_kept":49,"cut":false,"hidden":false,"merged":[[0,0,0,7]]}
["SUN ACCOUNT CODES - CHEAT SHEET"]
["Description","Code",null,"Description","Code",null,"Description","Code"]
["Employee Advance - Receivable",1212,null,"PH Occupancy Expense",6155,null,"Training - Facilities",6612]
["Operating Cash Advance ",1213,null,"PH Insurance",6156,null,"Gasoline & Oil Expense",6701]
["Project Advance - Receivable",1231,null,"PH Maintenance & Repair",6157,null,"Registration/License/Tolls/Parking",6702]
["Travel Advance - Receivable",1291,null,"PH Travel & Representation",6158,null,"Vehicle Insurance",6703]
["Advance to Vendors - Receivable",1522,null,"PH Vehicle Expense",6159,null,"Vehicle Rents & Leases",6704]
["Furniture & Equipment >$5,000 (Fixed Asset)",2300,null,"PH Warehousing Expense",6160,null,"Maintenance & Repair - Labor",6705]
["Computer Equipment >$5,000 (Fixed Asset)",2400,null,"PH Internal Transport",6161,null,"Maitnenance & Repair - Spare parts",6706]
["Vehicles >$5,000 (Fixed Asset)",2500,null,"PH Material Purchases",6162,null,"Other Vehicle Expense",6708]
["Salaries - HQ & International Staff",6003,null,"PH Training",6163,null,"Claim Settlement",6801]
["Other Payroll",6005,null,"PH Monitoring and Evaluation",6164,null,"Duty Charges",6802]
["Other Fringe Benefits",6019,null,"PH Other Project Holder Expense",6165,null,"Inland Freight Charges",6803]
["Education Allowance",6021,null,"Accounting & Auditing Fees",6201,null,"Loading/Unloading",6804]
["Housing & Maintenance",6022,null,"Employment Agency Fees",6202,null,"Packaging & Reconstitution",6805]
["Installation Grant",6023,null,"Legal Fees",6203,null,"Survey Fees",6806]
["Moving Expense",6024,null,"Project & Consultant Fees",6204,null,"Warehousing Charges",6807]
["Personal Affects Shipment",6025,null,"Recruitment Service Fees / Advertising",6205,null,"Warehousing Rent",6808]
["Home Leave ",6026,null,"Courier Services",6301,null,"Warehouse Security",6809]
["War Risk Insurance",6028,null,"Email/Internet",6302,null,"Agent Fees",6810]
["Other Allowances",6029,null,"Telephone /Fax/Telex",6303,null,"Signs/Public Recognitation",6811]
["Security on residence",6030,null,"Mail & Postage",6304,null,"Internal Transport",6812]
["Salaries - National Staff",6052,null,"Membership Dues & Subscription",6305,null,"Air Freight",6813]
["Other Payroll (hourly, daily, piece work)",6059,null,"Office/Computer Supplies & Stationary",6306,null,"Shipping Insurance",6814]
["Health Insurance/Medical Expenses (National Staff)",6061,null,"Printing",6307,null,"Warehouse Freight Insurance",6815]
["Life Insurance (National Staff)",6062,null,"Furniture & Equipment Insurance",6308,null,"Ocean Freight ",6816]
["Provident/Pension Plan Expense (National Staff)",6063,null,"General Liability Insurance",6309,null,"Warehouse Salaries",6817]
["Employee Savings Plan (National Staff)",6064,null,"Maintenance & Repair - Equipment",6310,null,"Allocation to Other Agencies",6901]
["Social Security - Employer",6065,null,"Maintenance & Repair - Furniture",6311,null,"Allocation for Credit Extension",6902]
["Workers Compensation",6066,null,"Employee Activities",6312,null,"Subcontracts/Subgrantees",6903]
["Other Fringe Benefits",6069,null,"Other Office Expense",6313,null,"Subcontracts NICRA Exempt",6904]
["Severence Expense",6071,null,"Building Rent",6401,null,"Micro Finance Loan Distribution",6905]
["Staff Tuition Assistance",6072,null,"Equipment Rental",6402,null,"Deprec. Expense - Computer Equipment",6931]
["Other Allowances",6073,null,"Janitorial & Trash Removal",6403,null,"Deprec. Expense - Equipment",6932]
["Furniture & Equipment > $5,000 (Non Capital)",6101,null,"Utilities",6404,null,"Deprec. Expense - Furniture",6933]
["Vehicles Purchases > $5,000 (Non Capital)",6102,null,"Building Insurance",6405,null,"Deprec. Expense - Leasehold Improvements",6934]
["Commodities Cost (In-Kind) HQ",6103,null,"Contract Security Services",6406,null,"Deprec. Expense ",6935]
["Commodities Cost (In-Kind) Local",6104,null,"Maintenance & Repair-Building",6407,null,"Bad Debt Expense",6941]
["Ocean Freight (In-Kind)",6105,null,"Guest House Rent",6408,null,"Bank Charges",6942]
["Project Materials",6106,null,"Transportation (incl. air travel)",6501,null,"Gain/Loss - Currency Conversio",6943]
["Furn, Veh, Equipment < $5,000",6107,null,"Hotel",6502,null,"Gain/Loss - Sale of Equipment",6944]
["Services (In Kind)",6108,null,"Per Diem / Meals / Laundry",6503,null,"Gain/Loss - Sale of Vehicles",6945]
["Other (In Kind)",6109,null,"Representation (Non US Govt)",6504,null,"Taxes",6951]
["Construction Materials excl. NICRA",6111,null,"Meetings - Facilities",6505,null,"NICRA Expense",6961]
["Food Input excl. NICRA",6112,null,"Training - Transportation",6607,null,"Accrued Expenses",6971]
["PH Salaries",6151,null,"Training - Lodging",6608,null,"Other Miscellaneous",6972]
["PH Fringe Benefits",6152,null,"Training - Meals, Misc, Per Diem",6609,null,"Interest Expense",6973]
["PH Professional Fees",6153,null,"Training - Course Fees",6610,null,"Budgetary Reserve",6998]
["PH Office Expense",6154,null,"Training - Consultants",6611]