{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["YTD Thru MAR 31   Trial Bal","Cash Detail Schedule"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":65,"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":"YTD Thru MAR 31   Trial Bal","index":0,"n_rows":280,"n_cols":11,"rows_kept":280,"cut":false,"hidden":false,"merged":[[6,5,6,7],[0,0,0,3],[12,0,12,3],[1,0,1,3],[8,0,8,3],[9,1,9,3],[10,1,10,3],[6,1,6,2],[7,0,7,3],[4,0,4,3],[13,1,13,3],[14,1,14,3],[30,0,30,4],[31,7,31,9],[32,8,32,9],[39,7,39,10],[36,7,37,10],[38,7,38,10],[15,1,15,3],[25,0,25,2],[31,3,32,3],[38,4,38,5],[34,7,35,9],[34,10,35,10]]}
["INTRODUCTION"]
["The purpose of this Toolkit is to streamline the preparation of the interim financial report to the Diocese of Cleveland."]
[]
["The Toolkit consists of the following tabs:"]
["Toolkit Trial Balance (GREEN TAB)--this is the current tab and provides space to insert the basic financial information using the Diocese's chart of accounts.  You need to insert the requested financial information described below in the columns below for the following periods (Enter data only in the cells highlighted in yellow or green--do not add any lines to this tab - DO NOT USE CUT AND PASTE):"]
["Column"]
["E","Current YTD\n    ended",null,"2020-03-31","Colum F ","Last Year YTD period ended:\nMarch 31, 2019"]
["Schedules (BLUE TAB)--this is the tab for the spreadsheet in which you must enter selected supplemental information required by the Diocese.  Enter data only in the cells highlighted in yellow.  Insert rows as necessary on this tab."]
["To view and/or print the respective information, please press the appropriate button below:"]
[]
[]
[]
["INSTRUCTIONS FOR USE OF TOOLKIT"]
[1,"Entering Parish Identity Information--enter in the cells highlighted in yellow in rows 22 through 29 the parish identity information"]
[2,"Entering Financial Data--in column E  & F  enter the balance sheet and income statement trial balance information for the period indicated in the respective cell.  "]
[3,"Determining if Financial Data is in Balance and Completion of Schedules--once it is determined that column E & F are in balance (see row 35 that indicates whether the respective column is in balance.) , Go to the Cash Detail Schedule tab and complete the detail banking information."]
[]
[]
[]
[]
[]
["PARISH NAME"]
["ADDRESS"]
["CITY, STATE, ZIP CODE"]
["PARISH NUMBER"]
["PERSON TO CONTACT\n  WITH QUESTIONS:"]
[null,"Name"]
[null,"Telephone"]
[null,"Email"]
[]
["USE ONLY THE ACCOUTS PROVIDED BELOW.  DO NOT ADD OTHER ACCOUNTS.  IF YOUR SYSTEM USES ACCOUNTS NOT SHOWN HERE, INCLUDE THE AMOUNTS IN THE CAPTIONS THAT BEST FIT THE CLASSIFICATION YOUR SYSTEM USES.\nEMAIL THIS FILE TO: parishaccounting@dioceseofcleveland.org  \nDATE DUE: April 30, 2020"]
[null,null,null,null,"Year-to-Date\nMarch 31,","Year-to-Date\nMarch 31,","Year-to-Date\nMarch 31,","June 30, 2019 ENDING Fund Balance\n         (6/30/19 toolkit cell G67) "]
[null,null,null,null,{"$f":"$D$7","v":"2020-03-31"},"2019","2020 Budget"]
[null,null,null,null,"Enter data from system"," Enter data from last year toolkit","OPTIONAL"]
["Spreadsheet audit control tests:",null,null,null,{"$f":"IF(ROUND(E49,2)=(ROUND(E63,2)),\"YES\",\"NO\")","v":"YES"},{"$f":"IF(ROUND(F49,2)=(ROUND(F63,2)),\"YES\",\"NO\")","v":"YES"},null,"Does beginning fund balance equal ending fund balance from June 30?",null,null,{"$f":"IF(ROUND(I33,2)=ROUND(E57,2),\"YES\",CONCATENATE(\"ERROR   OFF BY\",\" \",ROUND((I33-E57),2)))","v":"YES"}]
["Total asset accounts equal total of liability and net worth accounts for period end.  If \"NO\" indicated, determine why and correct."]
[null,null,null,null,null,null,null,"If not YES and there is an ERROR above-\nPlease explain the cause of the Fund Balance change\nNOTE: Any fund balance error will repeat each quarter until the next fiscal year."]
[]
[null,"Acct","Old\nRpt\nLine","Chart of Accounts Caption",{"$f":"IF(AND((E35=\"yes\"),(F35=\"YES\")), \"\", \"THIS PARISH REPORT IS NOT IN BALANCE   - PLEASE RECHECK BEFORE SENDING\")","v":""},null,null,"type here…"]
[]
[null,null,null,null,null,null,null,"This area may be used for parish notes:"]
["BALANCE SHEET DETAIL "]
[null,"0101.00",null,"Cash in bank - checking (Schedule A page 1)"]
[null,"0102.00",null,"Savings and investments (Schedule A page 2)"]
[null,"0103.00",null,"Accounts receivable"]
[null,"0104.00",null,"Prepaid expenses"]
[null,"0105.00",null,"Other assets"]
[null,"0200.00",null,"Fixed assets (Should be -0-)"]
[null,null,null,"Total Assets",{"$f":"SUM(E43:E48)","v":0},{"$f":"SUM(F43:F48)","v":0}]
[null,"0301.00",null,"Accounts payable  "]
[null,"0302.00",null,"Income received in advance"]
[null,"0303.00",null,"Employee withholdings"]
[null,"0304.00",null,"Accrued liabilities "]
[null,"0305.00",null,"Deferred restricted support"]
[null,"0400.00",null,"Loans, notes and Mortgages Payable "]
[null,null,null,"Total Liabilities",{"$f":"SUM(E50:E55)","v":0},{"$f":"SUM(F50:F55)","v":0}]
[null,"0500.00",null,"Fund balance beginning of fiscal period (July 1)"]
[null,null,null,"Net surplus (deficit) for period as per below"]
[null,null,null,"Church",{"$f":"E168","v":0},{"$f":"F168","v":0},{"$f":"G168","v":0}]
[null,null,null,"School",{"$f":"E275","v":0},{"$f":"F275","v":0},{"$f":"G275","v":0}]
[null,null,null,"Cemetery",{"$f":"E280","v":0},{"$f":"F280","v":0},{"$f":"G280","v":0}]
[null,"0500.00",null,"Ending Fund Balance",{"$f":"SUM(E57:E61)","v":0},{"$f":"SUM(F57:F61)","v":0}]
[null,null,null,"Total Liabilities and Ending Fund Balance",{"$f":"E56+E62","v":0},{"$f":"F56+F62","v":0}]
[]
[]
["CHURCH INCOME STATEMENT DETAIL"]
[null,1000,"OPERATING RECEIPTS"]
[null,1001,1,"Offertory Collections"]
[null,1002,2,"Other Collections"]
[null,1004,3,"Bequests, Donations and Restricted Funds"]
[null,1005,4,"Contributions from Parish Organizations"]
[null,1006,5,"Income from Parish Programs"]
[null,1007,6,"Income from Teaching Activities"]
[null,1008,7,"Net Bingo Proceeds"]
[null,1009,8,"Fund-Raising Income"]
[null,1010,9,"Investment Income"]
[null,1011,10,"Rental Receipts"]
[null,1012,11,"Endowment Income"]
[null,1013,12,"Miscellaneous Receipts"]
[null,1100,"EXTRAORDINARY RECEIPTS"]
[null,1101,14,"Diocesan Subsidies"]
[null,1102,15,"Receipts from Sale of Property"]
[null,1103,16,"Receipts from Insurance Claims"]
[null,1104,null,"Transfer to (from) school"]
[null,1106,17,"Diocese Designated Collections Received"]
[null,1109,18,"Other Extraordinary Receipts"]
[null,null,null,"Church Revenues",{"$f":"SUM(E68:E86)","v":0},{"$f":"SUM(F68:F86)","v":0},{"$f":"SUM(G68:G86)","v":0}]
[null,2000,"ADMINISTRATION"]
[null,2001,"21 & 22","Salaries and Other Compensation:"]
[null,2002,23,"Payroll Taxes and Fringe Benefits"]
[null,2003,24,"General Administrative Expenses"]
[null,2004,25,"Rectory Food and Household Supplies"]
[null,2005,26,"Staff Development and Training"]
[null,2006,27,"Publications and Periodicals"]
[null,2007,28,"Interest Expense"]
[null,2015,29,"Miscellaneous Expenses"]
[null,2100,"CELEBRATING"]
[null,2101,"31 & 32","Salaries and Other Compensation:"]
[null,2102,33,"Payroll Taxes and Fringe Benefits"]
[null,2103,34,"Altar, Sanctuary and Liturgy"]
[null,2104,35,"Spiritual Growth Activities"]
[null,2105,36,"Staff and Parishioner Training"]
[null,2115,37,"Miscellaneous Expenses"]
[null,2200,"CARING"]
[null,2201,39,"Salaries and Other Compensation"]
[null,2202,40,"Payroll Taxes and Fringe Benefits"]
[null,2203,41,"Christian Service Programs"]
[null,2205,42,"Staff Development and Training"]
[null,2206,43,"Administrative Expenses"]
[null,2215,44,"Miscellaneous Expenses"]
[null,2300,"TEACHING (EXCLUDING ELEMENTARY SCHOOL)"]
[null,2301,46,"Salaries and Other Compensation"]
[null,2302,47,"Payroll Taxes and Fringe Benefits"]
[null,2303,48,"PSR Instructional Expenses (K-12)"]
[null,2304,49,"Other Teaching Programs"]
[null,2305,50,"Staff Development and Training"]
[null,2306,51,"Administrative Expenses"]
[null,2307,52,"Volunteer Recognition Expense"]
[null,2308,53,"Teacher Certification Training"]
[null,2309,54,"REO Assessment Fees"]
[null,2310,55,"Memberships and Subscriptions"]
[null,2315,56,"Miscellaneous Expenses"]
[null,2400,"STEWARDSHIP AND EVANGELIZING"]
[null,2401,58,"Salaries and Other Compensation"]
[null,2402,59,"Payroll Taxes and Fringe Benefits"]
[null,2403,60,"Evangelization Programs"]
[null,2405,61,"Staff Development and Training"]
[null,2406,62,"Administrative Expenses"]
[null,2415,63,"Miscellaneous Expenses"]
[null,2500,"PARTICIPATING"]
[null,2501,65,"Salaries and Other Compensation"]
[null,2502,66,"Payroll Taxes and Fringe Benefits"]
[null,2503,67,"Participating Activities"]
[null,2505,68,"Staff Development and Training"]
[null,2506,69,"Administrative Expenses"]
[null,2515,70,"Miscellaneous Expenses"]
[null,2600,"PLANT OPERATION"]
[null,2601,72,"Salaries and Other Compensation"]
[null,2602,73,"Payroll Taxes and Fringe Benefits"]
[null,2607,74,"Contracted Services"]
[null,2608,75,"Utilities"]
[null,2609,76,"Plant Operation Supplies"]
[null,2610,77,"Rental of Facilities and Equipment"]
[null,2611,78,"Replacement of Equipment"]
[null,2612,79,"Property and Casualty Insurance"]
[null,2613,80,"Vehicle Expenses"]
[null,2614,81,"Property Taxes"]
[null,2615,82,"Miscellaneous Expenses"]
[null,2700,"OTHER OPERATING DISBURSEMENTS"]
[null,2704,84,"Diocese Assessments"]
[null,2705,85,"Payments Made to Other Schools"]
[null,2706,8,"Fund-Raising Expense"]
[null,2708,null,"Rental Expense"]
[null,3000,"CAPITAL DISBURSEMENTS"]
[null,3001,88,"Land"]
[null,3002,89,"Land Improvements"]
[null,3003,90,"Buildings and Additions"]
[null,3004,91,"Building Remodeling, Improvements and Major Repairs"]
[null,3005,92,"Vehicles, Equipment and Furniture"]
[null,3100,"OTHER EXTRAORDINARY DISBURSEMENTS"]
[null,3105,94,"Insurance Settlements Expenses"]
[null,3107,95,"Designated Collections Remitted to the Diocese"]
[null,3108,96,"Intra-Parish Transfers"]
[null,3109,97,"Removal of Underground Tanks"]
[null,3110,98,"Removal of Asbestos"]
[null,3111,99,"Miscellaneous Extraordinary Disbursements"]
[null,null,null,"Church Expenses",{"$f":"SUM(E89:E166)","v":0},{"$f":"SUM(F89:F166)","v":0},{"$f":"SUM(G89:G166)","v":0}]
[null,null,null,"Net Church Surplus (Deficit)",{"$f":"E87-E167","v":0},{"$f":"F87-F167","v":0},{"$f":"G87-G167","v":0}]
["SCHOOL INCOME STATEMENT DETAIL"]
[null,4000,"OPERATING RECEIPTS"]
[null,4001,1,"Tuition"]
[null,4002,2,"Registration and Other Fees"]
[null,4003,3,"Bequests, Donations and Restricted Funds"]
[null,4004,4,"Government Assistance"]
[null,4005,5,"School-sponsored Food Program"]
[null,4006,6,"Latch-Key Program Receipts"]
[null,4007,7,"Pre-School Program Receipts"]
[null,4008,8,"Student Services Receipts"]
[null,4009,9,"Fund-raising - Income"]
[null,4010,10,"Investment Income"]
[null,4011,11,"Rental Receipts"]
[null,4012,12,"Endowment Income"]
[null,4013,13,"Other Operating Income"]
[null,4100,"EXTRAORDINARY RECEIPTS",null," "," "," "]
[null,4101,15,"Payments from/(to) Parish"]
[null,4102,16,"Diocesan Subsidies"]
[null,4103,17,"Receipts from Sale of Property"]
[null,4104,18,"Receipts from Insurance Claims"]
[null,4109,19,"Other Extraordinary Receipts"]
[null,null,null,"School Revenues",{"$f":"SUM(E171:E189)","v":0},{"$f":"SUM(F171:F189)","v":0},{"$f":"SUM(G171:G189)","v":0}]
[null,5000,"ADMINISTRATION"]
[null,5001,22,"Salaries and Other Compensation"]
[null,5002,23,"Payroll Taxes and Fringe Benefits"]
[null,5003,24,"General Administrative Expenses"]
[null,5004,25,"OCE Administrative Fees"]
[null,5005,26,"Bad Debts"]
[null,5006,27,"Memberships and Subscriptions"]
[null,5007,28,"Workshops, In-service and Meetings"]
[null,5008,29,"Faculty Expenses"]
[null,5009,30,"Public Relations"]
[null,5010,31,"Gifts and Donations"]
[null,5015,32,"Miscellaneous Expenses"]
[null,5100,"INSTRUCTIONAL"]
[null,5101,34,"Salaries and Other Compensation"]
[null,5102,35,"Payroll Taxes and Fringe Benefits"]
[null,5103,36,"Instructional Expenses"]
[null,5104,37,"Replacement of Instructional Equipment"]
[null,5105,38,"Instructional Contracted Services"]
[null,5200,"LIBRARY"]
[null,5201,40,"Salaries and Other Compensation"]
[null,5202,41,"Payroll Taxes and Fringe Benefits"]
[null,5203,42,"Library Expenses"]
[null,5204,43,"Audio/Visual Expenses"]
[null,5300,"STUDENT SERVICES"]
[null,5301,45,"Salaries and Other Compensation"]
[null,5302,46,"Payroll Taxes and Fringe Benefits"]
[null,5303,47,"Extracurricular Expenses"]
[null,5304,48,"Health Services"]
[null,5315,49,"Miscellaneous Expenses"]
[null,5400,"SCHOOL-SPONSORED FOOD PROGRAM"]
[null,5401,51,"Salaries and Other Compensation"]
[null,5402,52,"Payroll Taxes and Fringe Benefits"]
[null,5403,53,"Food Costs"]
[null,5404,54,"Other Food Program Expenses"]
[null,5500,"STUDENT TRANSPORTATION"]
[null,5501,56,"Salaries and Other Compensation"]
[null,5502,57,"Payroll Taxes and Fringe Benefits"]
[null,5504,58,"Other Student Transportation Expenses"]
[null,5600,"LATCH-KEY EXPENSES"]
[null,5601,6,"Salaries and Other Compensation"]
[null,5602,6,"Payroll Taxes and Fringe Benefits"]
[null,5603,6,"Other Program Expenses"]
[null,5700,"PRESCHOOL EXPENSES"]
[null,5701,7,"Salaries and Other Compensation"]
[null,5702,7,"Payroll Taxes and Fringe Benefits"]
[null,5703,7,"Other Pre-School Expenses"]
[null,5800,"PLANT OPERATION"]
[null,5801,60,"Salaries and Other Compensation"]
[null,5802,61,"Payroll Taxes and Fringe Benefits"]
[null,5807,62,"Contracted Services"]
[null,5808,63,"Utilities"]
[null,5809,64,"Plant Operation Supplies"]
[null,5810,65,"Rental of Facilities and Equipment"]
[null,5811,66,"Replacement of Equipment"]
[null,5812,67,"Property and Casualty Insurance"]
[null,5813,68,"School Vehicle Expenses"]
[null,5814,69,"Property Taxes"]
[null,5815,70,"Miscellaneous Expenses"]
[null,5900,"FACULTY RESIDENCE"]
[null,5901,72,"Salaries and Other Compensation"]
[null,5902,73,"Payroll Taxes and Fringe Benefits"]
[null,5906,74,"Telephone"]
[null,5907,75,"Contracted Services"]
[null,5908,76,"Utilities"]
[null,5909,77,"Faculty Residence Supplies"]
[null,5910,78,"Rent Expense"]
[null,5911,79,"Furniture and Equipment Replacement"]
[null,5912,80,"Property and Casualty Insurance"]
[null,5913,81,"Faculty Vehicle Expenses"]
[null,5914,82,"Property Taxes"]
[null,5915,83,"Miscellaneous Expenses"]
[null,6000,"CAPITAL DISBURSEMENTS"]
[null,6001,86,"Land"]
[null,6002,87,"Land Improvements"]
[null,6003,88,"Buildings and Additions"]
[null,6004,89,"Building Remodeling, Improvements and Major Repairs"]
[null,6005,90,"Vehicles, Equipment and Furniture"]
[null,6006,91,"Faculty Residence"]
[null,6100,"OTHER EXTRAORDINARY DISBURSEMENTS"]
[null,6105,93,"Insurance Settlements Expenses"]
[null,6109,94,"Removal of Underground Tanks"]
[null,6110,95,"Removal of Asbestos"]
[null,6111,96,"Miscellaneous Extraordinary Disbursements"]
[null,null,null,"School Expenses",{"$f":"SUM(E192:E273)","v":0},{"$f":"SUM(F192:F273)","v":0},{"$f":"SUM(G192:G273)","v":0}]
[null,null,null,"Net School Surplus (Deficit)",{"$f":"E190-E274","v":0},{"$f":"F190-F274","v":0},{"$f":"G190-G274","v":0}]
[]
["CEMETERY INCOME STATEMENT DETAIL"]
[null,null,null,"Cemetery Revenue"]
[null,null,null,"Cemetery Expense"]
[null,null,null,"Net Cemetery Surplus (Deficit)",{"$f":"E278-E279","v":0},{"$f":"F278-F279","v":0},{"$f":"G278-G279","v":0}]

{"sheet":"Cash Detail Schedule","index":1,"n_rows":103,"n_cols":7,"rows_kept":103,"cut":false,"hidden":false,"merged":[[0,0,0,5],[2,1,2,5],[3,1,3,5],[102,0,102,4],[4,1,4,5],[5,1,5,5],[6,1,6,5],[55,0,55,5],[56,0,56,5],[104,0,104,5],[11,0,11,5],[101,0,101,1],[8,0,8,5],[9,0,9,5],[10,0,10,5],[101,4,101,5],[14,2,14,4]]}
[]
[]
["NAME OF PARISH",{"$f":"UPPER('YTD Thru MAR 31   Trial Bal'!$D$22)","v":""}]
["ADDRESS",{"$f":"UPPER('YTD Thru MAR 31   Trial Bal'!$D$23)","v":""}]
["CITY, STATE, ZIP CODE",{"$f":"UPPER('YTD Thru MAR 31   Trial Bal'!$D$24)","v":""}]
["PARISH NUMBER",{"$f":"'YTD Thru MAR 31   Trial Bal'!D25","v":0}]
["FISCAL PERIOD ENDED ",{"$f":"'YTD Thru MAR 31   Trial Bal'!$D$7","v":"2020-03-31"}]
[]
["SCHEDULE A - CHECKING, SAVINGS AND INVESTMENT ACCOUNT INFORMATION AS OF"]
[{"$f":"'YTD Thru MAR 31   Trial Bal'!$D$7","v":"2020-03-31"}]
["Include all accounts active during the year - including $0 balance and closed accounts."]
["(Add rows as necessary using menu)"]
["CASH IN BANK - CHECKING ACCOUNTS (ACCOUNT 0101):"]
["Bank Account Name  ","Bank Name","Bank Acct #\n(last 4 digits)","Restricted?","Amount"]
["CHURCH",null,"U- unrestricted\nT - Temporarily Restricted\nP- Permanently Restricted\nUse Multiple lines if needed for one account"]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
["Total Church Checking Accounts",null,null,null,null,null,{"$f":"SUM(E16:E32)","v":0}]
[]
["ELEMENTARY SCHOOL"]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
["    Total Elementary School Checking Accounts",null,null,null,null,null,{"$f":"SUM(E36:E47)","v":0}]
[]
["CEMETERY CHECKING ACCOUNTS"]
[null,null,null,null,0]
[null,null,null,null,0]
["Total Cemetery Checking Accounts",null,null,null,null,null,{"$f":"SUM(E51:E52)","v":0}]
["TOTAL CHECKING ACCOUNT BALANCES",null,null,null,{"$f":"\"--total carried to following page\"","v":"--total carried to following page"},null,{"$f":"SUM(G33:G53)","v":0}]
[]
[]
["SCHEDULE A - CHECKING, SAVINGS AND INVESTMENT ACCOUNT INFORMATION - Continued"]
[]
["TOTAL CHECKING ACCOUNT BALANCES",null,null,null,{"$f":"\"--from preceding page\"","v":"--from preceding page"},null,{"$f":"G54","v":0}]
[]
["SAVINGS AND INVESTMENTS (ACCOUNT 0102):"]
["CHURCH"]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
["Total Church Savings and Investment Accounts",null,null,null,null,null,{"$f":"SUM(E63:E76)","v":0}]
[]
["ELEMENTARY SCHOOL"]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
["    Total Elementary School Savings & Investment Accounts",null,null,null,null,null,{"$f":"SUM(E80:E87)","v":0}]
["CEMETERY"]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
["Total Cemetery Savings & Investment Accounts",null,null,null,null,null,{"$f":"SUM(E90:E96)","v":0}]
[]
[]
["TOTAL SAVINGS AND INVESTMENTS",null,null,null,null,null,{"$f":"SUM(G77:G99)","v":0}]
[]
["TOTAL PARISH CHECKING, SAVINGS AND\n     INVESTMENT ACCOUNTS ",null,null,null,{"$f":"'YTD Thru MAR 31   Trial Bal'!$D$7","v":"2020-03-31"},null,{"$f":"G59+G100","v":0}]
[{"$f":"IF(G102=SUM('YTD Thru MAR 31   Trial Bal'!E43+'YTD Thru MAR 31   Trial Bal'!E44),\" \",\"ERROR - TOTAL SHOULD EQUAL\")","v":" "},null,null,null,null,null,{"$f":"IF(G102=SUM('YTD Thru MAR 31   Trial Bal'!E43+'YTD Thru MAR 31   Trial Bal'!E44),\"OK\",SUM('YTD Thru MAR 31   Trial Bal'!E43+'YTD Thru MAR 31   Trial Bal'!E44))","v":"OK"}]