{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Instructions","KEY INPUTS","1- Cover","1a - RMA Certification","2 - Trial Balance","3 - Budget Revenues","4 - Budget Appropriations","5 - Results of Operations","6 - Surplus"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":13,"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":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[null,"General Instructions to Complete the Annual Financial Statement Workbook"]
[null,"Solid Waste Collection Districts (SWCD)"]
["a)","This workbook is composed of several individual worksheets to complete the Annual Financial Statement."]
["b)"," It is designed to automatically calculate linked schedules from each of the data entry points. "]
["c)","The individual spreadsheets containing formulas are locked to protect the formulas. "]
["d)","Fill in only the gray sections of the worksheet. "]
["e)","Begin by navigating to the \"Key Inputs\" tab."]
["f)","Select the municipality (and county)  by clicking  on the arrow on the right side to choose. This will populate the name and county and dates  throughout the workbook.  Then continue to complete each of the fields in order to populate throughout the workbook."]
["g)","In all applicable signature lines insert appropriate officials email address."]
["h)","The completed AFS must be submitted  to the Division, via the FAST portal and it must be precisely named as: xxxx_swcd_afs_20xx.xls (provide 4 digits municode and year). "]
["i)","Only the Chief Financial Officer has access to the submit for review tab within the FAST portal."]
["j)","If copying data from a prior workbook, utilize the copy and paste-special values functionality built into Excel to preserve formatting."]

{"sheet":"KEY INPUTS","index":1,"n_rows":69,"n_cols":28,"rows_kept":69,"cut":false,"hidden":false,"merged":[[1,2,1,4],[2,2,2,4],[5,3,5,4],[59,3,59,4]]}
[]
[null,null,"SWCD Annual Financial Statement - Key Inputs"]
[null,null,"SWCD AFS Version 2022.1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DLGS"]
[]
[null,null,"Information Required for"]
[null,null,"Annual Financial Statement","Responses and Data",null,null,null,null,null,null,null,null,null,null,null,null,null,"Muncode","Town","County","Town Name","Name of Municipality","Muniname","Type of Government","Governing Body Members","Governing Body Type","2020 Census Population"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"0000","MUNICIPALITY","COUNTY","PLEASE SELECT A MUNICIPALITY","MUNICIPALITY","MUNICIPALITY"]
[null,null,"Name and County of Municipality",1,null,null,null,null,null,null,null,null,null,null,null,null,2,"1330","Aberdeen Township","Monmouth","Aberdeen Township, Monmouth County","Aberdeen Township","Aberdeen","Township","Council Members","Mayor-6 Council Members",19329]
[null,null,"Full Name of Municipality / County",{"$f":"UPPER(VLOOKUP($D$8,$Q$7:$X$19,8,FALSE)&\" Of \"&VLOOKUP($D$8,$Q$7:$X$19,7,FALSE))","v":" OF MUNICIPALITY"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q8+1","v":3},"0704","Cedar Grove Township","Essex","Cedar Grove Township, Essex County","Cedar Grove Township","Cedar Grove","Township","Council Members","5 Council Members",12980]
[null,null,"County of Municipality / County",{"$f":"UPPER(VLOOKUP($D$8,$Q$7:$X$19,4,FALSE))","v":"COUNTY"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q9+1","v":4},"1101","East Windsor Township","Mercer","East Windsor Township, Mercer County","East Windsor Township","East Windsor","Township","Council Members","7 Council Members",30045]
[null,null,"Name of Municipality / County",{"$f":"UPPER(VLOOKUP($D$8,$Q$7:$X$19,7,FALSE))","v":"MUNICIPALITY"},null,null,null,null,null,null,null,null,null,null,null,null,5,"1205","Edison Township","Middlesex","Edison Township, Middlesex County","Edison Township","Edison","Township","Council Members","Mayor-7 Council Members",107588]
[null,null,"Type ",{"$f":"UPPER(VLOOKUP($D$8,$Q$7:$X$19,8,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,6,"1414","Jefferson Township","Morris","Jefferson Township, Morris County","Jefferson Township","Jefferson","Township","Council Members","Mayor-5 Council Members",20538]
[null,null,"Federal ID #",null,null,null,null,null,null,null,null,null,null,null,null,null,7,"1331","Middletown Township","Monmouth","Middletown Township, Monmouth County","Middletown Township","Middletown","Township","Council Members","5 Council Members",67106]
[null,null,"Governing Body Type",{"$f":"UPPER(VLOOKUP($D$8,$Q$7:$Z$19,9,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,8,"1420","Mine Hill Township","Morris","Mine Hill Township, Morris County","Mine Hill Township","Mine Hill","Township","Council Members","Mayor-5 Council Members",4015]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"1427","Mount Olive Township","Morris","Mount Olive Township, Morris County","Mount Olive Township","Mount Olive","Township","Council Members","Mayor-6 Council Members",28886]
[null,null,"Address",null,null,null,null,null,null,null,null,null,null,null,null,null,10,"0427","Pennsauken Township","Camden","Pennsauken Township, Camden County","Pennsauken Township","Pennsauken","Township","Committeepersons","5 Committee Members",37074]
[null,null,"Phone ",null,null,null,null,null,null,null,null,null,null,null,null,null,11,"0911","Weehawken Township","Hudson","Weehawken Township, Hudson County","Weehawken Township","Weehawken","Township","Council Members","5 Council Members",17197]
[null,null,"Fax",null,null,null,null,null,null,null,null,null,null,null,null,null,12,"1615","West Milford Township","Passaic","West Milford Township, Passaic County","West Milford Township","West Milford","Township","Council Members","Mayor-6 Council Members",24862]
[null,null,null,null,"Certificate #",null,null,null,null,null,null,null,null,null,null,null,13,"1439","Wharton Borough","Morris","Wharton Borough, Morris County","Wharton","Wharton","Borough","Council Members","Mayor-6 Council Members",7241]
[null,null,"Chief Financial Officer"]
[null,null,"Registered Municipal Accountant",null,null,"Leave blank if CFO prepared"]
[null,null,"Year Ending"]
[]
[null,null,"DATES",{"$f":"\"Balance - January 1, \"&D33","v":"Balance - January 1, 2022"}]
[null,null,null,{"$f":"\"Balance - December 31, \"&D33","v":"Balance - December 31, 2022"}]
[null,null,null,{"$f":"\"Outstanding - January 1, \"&D33","v":"Outstanding - January 1, 2022"}]
[null,null,null,{"$f":"\"Outstanding - December 31, \"&D33","v":"Outstanding - December 31, 2022"}]
[null,null,"Year End",{"$f":"DATE(D33,12,31)","v":"2022-12-31"}]
[null,null,"Next Year End",{"$f":"DATE(D32,12,31)","v":"2023-12-31"}]
[]
[]
[null,null,"Budget Year",2023]
[null,null,"AFS Year",{"$f":"D32-1","v":2022}]
[null,null,"PY",{"$f":"D33-1","v":2021}]
[]
[null,null,"POPULATION  LAST  CENSUS",{"$f":"VLOOKUP(D8,$Q$7:$AA$19,11,FALSE)","v":0}]
[null,null,{"$f":"\"NET  VALUATION  TAXABLE  \"&D33","v":"NET  VALUATION  TAXABLE  2022"}]
[null,null,"Muni Code",{"$f":"VLOOKUP($D$8,$Q$7:$R$19,2,FALSE)","v":"0000"}]
[]
[null,null,"FISCAL YEAR TYPE:","CALENDAR YEAR MUNICIPALITIES",null,"STATE FISCAL YEAR MUNICIPALITIES",null,"TRANSITION YEAR MUNICIPALITIES"]
[null,null,"Calendar",{"$f":"\"ANNUAL FINANCIAL STATEMENT FOR THE YEAR \"&D33&\"\"","v":"ANNUAL FINANCIAL STATEMENT FOR THE YEAR 2022"},null,{"$f":"\"ANNUAL FINANCIAL STATEMENT FOR THE YEAR \"&D32&\"\"","v":"ANNUAL FINANCIAL STATEMENT FOR THE YEAR 2023"},null,{"$f":"\"ANNUAL FINANCIAL STATEMENT FOR THE TY \"&D33&\"\"","v":"ANNUAL FINANCIAL STATEMENT FOR THE TY 2022"}]
[null,null,null,{"$f":"\"COUNTIES - JANUARY  26, \"&D32&\"\"","v":"COUNTIES - JANUARY  26, 2023"}]
[null,null,null,{"$f":"\"MUNICIPALITIES - FEBRUARY 10, \"&D32","v":"MUNICIPALITIES - FEBRUARY 10, 2023"},null,{"$f":"\"MUNICIPALITIES - AUGUST 10, \"&D32&\"\"","v":"MUNICIPALITIES - AUGUST 10, 2023"},null,{"$f":"\"MUNICIPALITIES - FEBRUARY 10, \"&D32&\"\"","v":"MUNICIPALITIES - FEBRUARY 10, 2023"}]
[null,null,null,{"$f":"\"AS  AT  DECEMBER  31, \"&D33","v":"AS  AT  DECEMBER  31, 2022"},null,{"$f":"\"AS  AT  JUNE 30, \"&D32&\"\"","v":"AS  AT  JUNE 30, 2023"},null,{"$f":"\"AS  AT  DECEMBER  31, \"&D33&\"\"","v":"AS  AT  DECEMBER  31, 2022"}]
[null,null,null,{"$f":"\"Dec. 31, \"&D34","v":"Dec. 31, 2021"},null,{"$f":"\"June 30, \"&D33&\"\"","v":"June 30, 2022"},null,{"$f":"\"June 30, \"&D34&\"\"","v":"June 30, 2021"}]
[null,null,null,{"$f":"\"Dec. 31, \"&D33","v":"Dec. 31, 2022"},null,{"$f":"\"June 30, \"&D32&\"\"","v":"June 30, 2023"},null,{"$f":"\"June 30, \"&D33&\"\"","v":"June 30, 2022"}]
[null,null,null,{"$f":"\"Jan. 1, \"&D33","v":"Jan. 1, 2022"},null,{"$f":"\"July 1, \"&D33&\"\"","v":"July 1, 2022"},null,{"$f":"\"July 1, \"&D33&\"\"","v":"July 1, 2022"}]
[null,null,null,{"$f":"\"YEAR - \"&D34","v":"YEAR - 2021"},null,{"$f":"\"YEAR - \"&D34","v":"YEAR - 2021"},null,{"$f":"\"YEAR - \"&D34&\"\"","v":"YEAR - 2021"}]
[null,null,null,{"$f":"\"YEAR - \"&D33","v":"YEAR - 2022"},null,{"$f":"\"YEAR - \"&D33","v":"YEAR - 2022"},null,{"$f":"\"YEAR - \"&D33&\"\"","v":"YEAR - 2022"}]
[]
[null,null,null,"HOW MANY UTILITIES DOES THE MUNICIPALITY HAVE:",1]
[null,null,null,"UTILITY NAME(S)"]
[null,null,"UTILITY 1"]
[null,null,"UTILITY 2"]
[null,null,"UTILITY 3"]
[null,null,"UTILITY 4"]
[null,null,"UTILITY 5"]
[null,null,"UTILITY 6"]
[]
[null,null,null,"PAGE COUNT - STANDARD OR EXPANDED:"]
[null,null,null,"SHEET 6 (Trust Fund Trial Balance)","Standard"]
[null,null,null,"SHEET 6B (Schedule of Trust Fund Deposits and Reserves)","Standard"]
[null,null,null,"SHEET 9A (List of Banks Supporting 'Cash On Deposit')","Standard"]
[null,null,null,"SHEET 10 (Grants Receivable)","Standard"]
[null,null,null,"SHEET 11 (Grants Appropriated)","Standard"]
[null,null,null,"SHEET 12 (Grants Unappropriated)","Standard"]
[null,null,null,"SHEET 17A (Chapter 159)","Standard"]
[null,null,null,"SHEET 20 (Miscellaneous Revenues Not Anticipated)","Standard"]
[null,null,null,"SHEET 35 (Improvement Authorizations)","Standard"]

{"sheet":"1- Cover","index":2,"n_rows":63,"n_cols":25,"rows_kept":63,"cut":false,"hidden":false,"merged":[[1,1,1,14],[2,1,2,14],[7,1,7,14],[8,1,8,14],[4,10,4,11],[6,10,6,11],[5,10,5,11],[9,1,9,14],[21,6,21,12],[22,10,22,12],[46,1,46,5],[46,8,46,12],[45,7,45,12],[23,6,23,9],[22,6,22,9],[23,10,23,12],[44,6,44,11],[45,4,45,5],[16,12,16,14],[16,7,16,10],[16,1,16,5],[18,1,18,14],[19,1,19,14],[52,5,52,11],[53,5,53,11],[54,5,54,11],[62,1,62,14],[55,7,55,9],[56,7,56,9]]}
[]
[null,{"$f":"\"ANNUAL  FINANCIAL  STATEMENT  FOR  THE  YEAR  \"&TEXT('KEY INPUTS'!D33,\"0\")","v":"ANNUAL  FINANCIAL  STATEMENT  FOR  THE  YEAR  2022"}]
[null,"(UNAUDITED)"]
[]
[null,null,null,null,null,null,null,null,null,"POPULATION  LAST  CENSUS",{"$f":"'KEY INPUTS'!D36","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"'KEY INPUTS'!C37","v":"NET  VALUATION  TAXABLE  2022"},{"$f":"'KEY INPUTS'!D37","v":0}]
[null,null,null,null,null,null,null,null,null,"MUNICODE",{"$f":"'KEY INPUTS'!D38","v":"0000"}]
[null,"FIVE  DOLLARS  PER  DAY  PENALTY  IF  NOT  FILED  BY:"]
[]
[null,{"$f":"'KEY INPUTS'!D43","v":"MUNICIPALITIES - FEBRUARY 10, 2023"}]
[]
[null,"ANNUAL FINANCIAL STATEMENT REQUIRED TO BE FILED UNDER NEW JERSEY STATUTES"]
[null,"ANNOTATED 40A:5-12, AS AMENDED, COMBINED WITH INFORMATION REQUIRED PRIOR TO"]
[null,"CERTIFICATION OF BUDGETS BY THE DIRECTOR OF THE DIVISION OF LOCAL GOVERNMENT"]
[null,"SERVICES."]
[]
[null,{"$f":"+'KEY INPUTS'!D12","v":""},null,null,null,null,"of",{"$f":"+'KEY INPUTS'!D11","v":"MUNICIPALITY"},null,null,null,", County of",{"$f":"+'KEY INPUTS'!D10","v":"COUNTY"}]
[]
[null,"SEE  BACK  COVER  FOR  INDEX  AND  INSTRUCTIONS."]
[null,"DO  NOT  USE  THESE  SPACES"]
[]
[null,null,null,null,null,"Date","Examined By:"]
[null,null,null,null,"1",null,null,null,null,null,"Preliminary Check"]
[null,null,null,null,"2",null,null,null,null,null,"Examined"]
[]
[]
[]
[]
[]
[]
[]
[null,"(This MUST be signed by Chief Financial Officer, Comptroller, Auditor or Registered Municipal Accountant.)"]
[]
[]
[null,"REQUIRED  CERTIFICATION  BY  THE  CHIEF  FINANCIAL  OFFICER:"]
[]
[]
[null,{"$f":"\"I hereby certify that I am responsible for filing this verified Annual Financial Statement,\"","v":"I hereby certify that I am responsible for filing this verified Annual Financial Statement,"},null,null,null,null,null,null,null,null,null,{"$f":"Y43","v":"(which I have prepared)"},null,"or"]
[null,{"$f":"Y44","v":"(which I have not prepared)"},null,null,null,{"$f":"Y45","v":"[eliminate one]"},null,{"$f":"\" and information required also included herein and that this Statement is an\"","v":" and information required also included herein and that this Statement is an"},null,null,null,null,null,null,null,null,null,"Need to be able to choose if completed or not.User needs to strike out  \"Which I have prepared \" or \"Which I have not prepared\"  Default to \"NOT\""]
[null,"exact copy of the original on file with the clerk of the governing body, that all calculations, extensions and additions"]
[null,"are correct, that no transfers have been made to or from emergency appropriations and all statements contained herein",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"As the CFO, did you prepare this annual financial statement? Type Y/N in the grey box below."]
[null,"are in proof; I further certify that this statement is correct insofar as I can determine from all the books and records"]
[null,"kept and maintained in the Local Unit.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(which I have prepared)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(which I have not prepared)"]
[null,"Further,  I  do  hereby  certify that I,",null,null,null,null,{"$f":"IF('KEY INPUTS'!D20=0,\"NO ENTRY\",'KEY INPUTS'!D20)","v":"NO ENTRY"},null,null,null,null,null,",am the Chief Financial",null,null,null,null,null,null,null,null,null,null,null,"[eliminate one]"]
[null,"Officer, License #",null,null,{"$f":"IF('KEY INPUTS'!E20=0,\"NO ENTRY\",'KEY INPUTS'!E20)","v":"NO ENTRY"},null,", of the",{"$f":"+'KEY INPUTS'!D12","v":""},null,null,null,null,null,"of"]
[null,{"$f":"+'KEY INPUTS'!D11","v":"MUNICIPALITY"},null,null,null,null,",  County  of",null,{"$f":"+'KEY INPUTS'!D10","v":"COUNTY"},null,null,null,null,"and that the"]
[null,"statements annexed hereto and made a part hereof are true statements of the financial condition of the Local Unit as at"]
[null,{"$f":"\"December 31, \"&TEXT('KEY INPUTS'!D33,\"0\")&\", completely in compliance with N.J.S.A. 40A:5-12, as amended. I also give complete assurance as\"","v":"December 31, 2022, completely in compliance with N.J.S.A. 40A:5-12, as amended. I also give complete assurance as"}]
[null,"to the veracity of required information included herein, needed prior to certification by the Director of Local Government"]
[null,{"$f":"\"Services, including the verification of cash balances as of December 31, \"&TEXT('KEY INPUTS'!D33,\"0\")&\".\"","v":"Services, including the verification of cash balances as of December 31, 2022."}]
[]
[null,null,null,"Signature"]
[null,null,null,"Title"]
[null,null,null,"Address",null,{"$f":"IF('KEY INPUTS'!D16=0,\"NO ENTRY\",'KEY INPUTS'!D16)","v":"NO ENTRY"}]
[null,null,null,"Phone Number",null,null,null,{"$f":"IF('KEY INPUTS'!D17=0,\"NO ENTRY\",'KEY INPUTS'!D17)","v":"NO ENTRY"}]
[null,null,null,"Fax Number",null,null,null,{"$f":"IF('KEY INPUTS'!D18=0,\"NO ENTRY\",'KEY INPUTS'!D18)","v":"NO ENTRY"}]
[]
[null,null,null,"IT IS HEREBY INCUMBENT UPON THE CHIEF FINANCIAL OFFICER, WHEN NOT PREPARED"]
[null,null,null,"BY SAID, AT A MINIMUM MUST REVIEW THE CONTENTS OF THIS ANNUAL FINANCIAL"]
[null,null,null,"STATEMENT WITH THE PREPARER, SO AS TO BE FAMILIAR WITH THE REPRESENTATIONS"]
[null,null,null,"AND ASSERTIONS MADE HEREIN."]
[null,"Sheet  1"]

{"sheet":"1a - RMA Certification","index":3,"n_rows":70,"n_cols":25,"rows_kept":70,"cut":false,"hidden":false,"merged":[[69,0,69,13],[59,8,59,12],[61,9,61,11],[55,8,55,12],[56,8,56,12],[64,9,64,11],[62,8,62,12],[65,8,65,12],[58,8,58,12],[52,8,52,12],[53,8,53,12],[9,8,9,11],[9,5,9,6],[60,4,60,6],[21,7,21,8],[49,8,49,12],[50,8,50,12]]}
[]
[]
[null,"THE  REQUIRED  CERTIFICATION  BY  AN  RMA  IS  AS  FOLLOWS:"]
[]
[null,"Preparation by Registered Municipal Account (Statement of Statutory Auditor Only)"]
[]
[]
[null,"I have prepared the post-closing trial balances, related statement and analyses included in the"]
[null,"accompanying Annual Financial Statement from the books of account and records made"]
[null,"available to me by the ",null,null,null,{"$f":"+'KEY INPUTS'!D12","v":""},null,"of",{"$f":"+'KEY INPUTS'!D11","v":"MUNICIPALITY"}]
[null,"as  of  December  31, ",null,null,null,{"$f":"'KEY INPUTS'!D33","v":2022},"and have applied certain agreed-upon procedures thereon as"]
[null,"promulgated by the Division of Local Government Services, solely to assist the Chief Financial"]
[null,"Officer in connection with the filing of the Annual Financial Statement for the year then"]
[null,"ended as required by N.J.S.A. 40A:5-12, as amended."]
[]
[]
[null,"Because the agreed-upon procedures do not constitute an examination of accounts made in"]
[null,"accordance with generally accepted auditing standards, I do not express an opinion on any of"]
[null,"the post-closing trial balances, related statements and analyses.  In connection with the"]
[null,"agreed-upon procedures,",null,null,null,null,"(except for circumstances as set forth below, no matters) ",null,null,null,null,null,"or",null,null,null,"Need to be able to choose if completed or not.User needs to strike out  \"\"except for circumstances as set forth below, no matters\" \" or \" No matters\"  Default to \"no matters\""]
[null,"(no matters)",null,null,"[eliminate one] ",null,"came to my attention that caused me to believe that the Annual",null,null,null,null,null,null,null,null,"As the RMA, did you list any circumstances below that caused you to believe that this Annual Financial "]
[null,"Financial Statement for the year ended",null,null,null,null,null,{"$f":"'KEY INPUTS'!D46","v":"Dec. 31, 2022"},null,"is not in substantial compliance with the",null,null,null,null,null,"Statement is not in substantial compliance? Type Y/N in the grey box below.",null,null,null,null,null,null,null,null,"(except for circumstances as set forth below, no matters)"]
[null,"requirements of the State of New Jersey, Department of Community Affairs, Division of Local",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(no matters)"]
[null,"Government Services.  Had I performed additional procedures or had I made an examination",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"[eliminate one]"]
[null,"of the financial statements in accordance with generally accepted auditing standards, other"]
[null,"matters might have come to my attention that would have been reported to the governing "]
[null,"body and Division.  This Annual Financial Statement relates only to the accounts and "]
[null,"items prescribed by the Division and does not extend to the financial statements of the"]
[null,"municipality/county taken as a whole."]
[]
[null,"Listing of agreed-upon procedures not performed and/or matters coming to my attention of"]
[null,"which the Director should be informed:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"IF('KEY INPUTS'!D21=0,\"NO ENTRY\",'KEY INPUTS'!D21)","v":"NO ENTRY"}]
[null,null,null,null,null,null,null,null,"(Registered Municipal Accountant)"]
[]
[]
[null,null,null,null,null,null,null,null,"(Firm Name)"]
[]
[]
[null,null,null,null,null,null,null,null,"(Address)"]
[]
[null,"Certified by me"]
[null,null,null,null,null,null,null,null,"(Address)"]
[null,"this",null,"day of",null,null,null,{"$f":"\", \"&TEXT('KEY INPUTS'!D32,\"0\")","v":", 2023"}]
[]
[null,null,null,null,null,null,null,null,"(Phone Number)"]
[]
[]
[null,null,null,null,null,null,null,null,"(Fax Number)"]
[]
[]
[]
["Sheet  1a"]

{"sheet":"2 - Trial Balance","index":4,"n_rows":48,"n_cols":8,"rows_kept":48,"cut":false,"hidden":false,"merged":[[46,1,46,7],[47,1,47,7],[8,1,8,5],[1,1,1,7],[3,1,3,7],[4,1,4,7],[5,1,5,7],[7,1,7,7]]}
[]
[null,"NOTE  THAT  A  TRIAL  BALANCE  IS  REQUIRED  AND  NOT  A  BALANCE  SHEET"]
[]
[null,"POST  CLOSING"]
[null,"TRIAL  BALANCE - SOLID WASTE COLLECTION DISTRICT"]
[null,{"$f":"'KEY INPUTS'!D44","v":"AS  AT  DECEMBER  31, 2022"}]
[]
[null,"Cash Liabilities Must Be Subtotaled and Subtotal Must Be Marked With \"C\" -- Taxes Receivable Must Be Subtotaled"]
[null,"Title of Account",null,null,null,null,"Debit","Credit"]
[]
[null,"Cash"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"TOTAL CASH LIABILITIES",null,null,null,{"$f":"SUM(H11:H25)","v":0}]
[]
[]
[]
[null,"Fund Balance",null,null,null,null,null,{"$f":"'6 - Surplus'!K14","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"GRAND TOTAL",null,{"$f":"SUM(G10:G45)","v":0},{"$f":"SUM(H26:H45)","v":0}]
[]
[null,"Sheet  2"]

{"sheet":"3 - Budget Revenues","index":5,"n_rows":47,"n_cols":10,"rows_kept":47,"cut":false,"hidden":false,"merged":[[46,0,46,9],[27,1,27,9],[4,1,4,9],[7,1,8,6],[3,1,3,9]]}
[]
[]
[]
[null,{"$f":"\"STATEMENT OF SOLID WASTE COLLECTION DISTRICT\"","v":"STATEMENT OF SOLID WASTE COLLECTION DISTRICT"}]
[null,{"$f":"\"BUDGET REVENUES \"&TEXT('KEY INPUTS'!D33,\"0\")","v":"BUDGET REVENUES 2022"}]
[]
[]
[null,"Source",null,null,null,null,null,"Budget","Realized","Excess or Deficit*"]
[null,null,null,null,null,null,null,"-01","-02","-03"]
[null,"Surplus Anticipated",null,null,null,null,null,null,{"$f":"H10","v":0},{"$f":"+I10-H10","v":0}]
[null,"Surplus Anticipated with Prior Written Consent of"]
[null,"Director of Local Government Services",null,null,null,null,null,null,null,{"$f":"+I12-H12","v":0}]
[null,"Miscellaneous Revenue Anticipated:",null,null,null,null,null,"xxxxxxxxx","xxxxxxxxx","xxxxxxxxx"]
[null,null,null,"Adopted Budget",null,null,null,null,null,{"$f":"+I14-H14","v":0}]
[null,null,null,"Added by N.J.S.A. 40A:4-87",null,null,null,null,{"$f":"+H15","v":0},{"$f":"+I15-H15","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"+I16-H16","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"+I17-H17","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"+I18-H18","v":0}]
[null,"Total Miscellaneous Revenue Anticipated",null,null,null,null,null,{"$f":"SUM(H14:H18)","v":0},{"$f":"SUM(I14:I18)","v":0},{"$f":"SUM(J14:J18)","v":0}]
[]
[null,"Amount to be Raised by Taxation:",null,null,null,null,null,"xxxxxxxxx","xxxxxxxxx","xxxxxxxxx"]
[null,null,"(a)  Solid Waste Collection District",null,null,null,null,null,null,{"$f":"I22-H22","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"I23-H23","v":0}]
[null,null,null,null,null,null,null,"xxxxxxxxx","xxxxxxxxx","xxxxxxxxx"]
[null,null,null,"Total Amount to be Raised by Taxation",null,null,null,{"$f":"H22+H23","v":0},{"$f":"I22+I23","v":0},{"$f":"+I25-H25","v":0}]
[null,null,null,null,null,null,null,{"$f":"+H25+H20+H19+H12+H10","v":0},{"$f":"+I25+I20+I19+I12+I10","v":0},{"$f":"+J25+J20+J19+J12+J10","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Sheet 3"]

{"sheet":"4 - Budget Appropriations","index":6,"n_rows":55,"n_cols":10,"rows_kept":55,"cut":false,"hidden":false,"merged":[[54,1,54,9],[3,1,3,9],[32,1,32,9],[33,1,33,9],[35,1,35,9],[4,1,4,9]]}
[]
[]
[]
[null,"STATEMENT OF SOLID WASTE COLLECTION DISTRICT"]
[null,{"$f":"\"BUDGET APPROPRIATIONS \"&TEXT('KEY INPUTS'!D33,\"0\")","v":"BUDGET APPROPRIATIONS 2022"}]
[]
[]
[null,{"$f":"TEXT('KEY INPUTS'!D33,\"0\")&\" Budget as Adopted\"","v":"2022 Budget as Adopted"}]
[null,{"$f":"TEXT('KEY INPUTS'!D33,\"0\")&\" Budget - Added by N.J.S.A. 40A:4-87\"","v":"2022 Budget - Added by N.J.S.A. 40A:4-87"}]
[null,{"$f":"\"Appropriated for \"&TEXT('KEY INPUTS'!D33,\"0\")&\" (Budget Statement Item 9)\"","v":"Appropriated for 2022 (Budget Statement Item 9)"},null,null,null,null,null,null,null,{"$f":"+J9+J8","v":0}]
[null,{"$f":"\"Appropriated for \"&TEXT('KEY INPUTS'!D33,\"0\")&\" by Emergency Appropriation (Budget Statement Item 9)\"","v":"Appropriated for 2022 by Emergency Appropriation (Budget Statement Item 9)"}]
[null,"Total General Appropriations (Budget Statement Item 9)",null,null,null,null,null,null,null,{"$f":"+J11+J10","v":0}]
[null,"Add: Overexpenditures (see footnote)"]
[null,null,"Total Appropriations and Overexpenditures",null,null,null,null,null,null,{"$f":"+J12+J13","v":0}]
[null,"Deduct Expenditures:"]
[null,null,"Paid or Charged [Budget Statement Item (L)]"]
[null,null,"Reserved"]
[null,null,null,"Total Expenditures",null,null,null,null,null,{"$f":"SUM(I16:I17)","v":0}]
[null,"Unexpended Balances Canceled (see footnote)",null,null,null,null,null,null,null,{"$f":"+J14-J18","v":0}]
[]
[null,"FOOTNOTES - RE: OVEREXPENDITURES"]
[null,null,"Every appropriation overexpended in the budget document must be marked with an * and must agree in the aggregate with this item."]
[null,null,"RE: UNEXPENDED BALANCES CANCELED"]
[null,null,"Are not to be shown as \"Paid or Charged\" in the budget document.  In all instances \"Total Appropriations\" and \"Overexpenditures\""]
[null,null,null,"must equal the sum of \"Total Expenditures\" and \"Unexpended Balances Canceled\"."]
[]
[]
[]
[]
[]
[]
[]
[null,"SCHEDULE  OF  EMERGENCY  APPROPRIATIONS  FOR  LOCAL"]
[null,"DISTRICT  SCHOOL  PURPOSES"]
[]
[null,"(EXCEPT  FOR  TYPE I SCHOOL DEBT SERVICE)"]
[]
[null,{"$f":"TEXT(#REF!,\"0\")&\" Authorizations\"","v":{"$error":"#REF!"}}]
[null,null,"N.J.S.  40A:4-46 (After adoption of Budget)"]
[null,null,"N.J.S.  40A:4-20 (Prior to adoption of Budget)"]
[null,null,null,"Total Authorizations",null,null,null,null,null,{"$f":"SUM(I39:I40)","v":0}]
[null,"Deduct Expenditures:"]
[null,null,"Paid or Charged"]
[null,null,"Reserved"]
[null,null,null,"Total Expenditures",null,null,null,null,null,{"$f":"SUM(I43:I44)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Sheet  4"]

{"sheet":"5 - Results of Operations","index":7,"n_rows":46,"n_cols":12,"rows_kept":46,"cut":false,"hidden":false,"merged":[[45,1,45,8],[2,1,2,8],[3,1,3,8],[6,1,6,6],[14,8,15,8],[14,7,15,7]]}
[]
[]
[null,{"$f":"\" RESULTS OF \"&TEXT('KEY INPUTS'!D33,\"0\")&\" OPERATION\"","v":" RESULTS OF 2022 OPERATION"}]
[null,"SOLID  WASTE  COLLECTION  DISTRICT"]
[]
[]
[null,null,null,null,null,null,null,"Debit","Credit"]
[null,"Excess of Anticipated Revenues:",null,null,null,null,null,"xxxxxxxxx","xxxxxxxxx"]
[null,null,"Miscellaneous Revenues Anticipated",null,null,null,null,"xxxxxxxxx",{"$f":"IF(+'3 - Budget Revenues'!J19>0, +'3 - Budget Revenues'!J19,\" \")","v":" "}]
[null,null,"Required Collection of Current Taxes",null,null,null,null,"xxxxxxxxx",{"$f":"IF(+'3 - Budget Revenues'!J25>0, +'3 - Budget Revenues'!J25,0)","v":0}]
[null,null,null,null,null,null,null,"xxxxxxxxx",null,null,null,"Proof - Total Excess (Lines 9 through 12):"]
[null,null,null,null,null,null,null,"xxxxxxxxx",null,null,null,{"$f":"SUM(I9:I12)","v":0}]
[null,{"$f":"\"Unexpended Balances of \"&TEXT('KEY INPUTS'!D33,\"0\")&\" Budget Appropriations (Canceled)\"","v":"Unexpended Balances of 2022 Budget Appropriations (Canceled)"},null,null,null,null,null,"xxxxxxxxx",{"$f":"+'4 - Budget Appropriations'!J19","v":0}]
[null,"Miscellaneous Revenue Not Anticipated",null,null,null,null,null,"xxxxxxxxx"]
[null,null,null,null,null,null,null,"xxxxxxxxx"]
[]
[null,null,null,null,null,null,null,"xxxxxxxxx"]
[null,null,null,null,null,null,null,"xxxxxxxxx"]
[null,{"$f":"\"Unexpended Balances of \"&TEXT('KEY INPUTS'!D34,\"0\")&\" Appropriation Reserves\"","v":"Unexpended Balances of 2021 Appropriation Reserves"},null,null,null,null,null,"xxxxxxxxx"]
[null,"Deficit in Anticipated Revenues: Miscellaneous Revenues Anticipated"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Deficit Balance - To Trial Balance (Sheet 3)",null,null,null,null,null,"xxxxxxxxx",{"$f":"IF(+J42>0,0,J42*-1)","v":0}]
[null,"Surplus Balance - To Surplus (Sheet 21)",null,null,null,null,null,{"$f":"+IF(+J42>0,J42,0)","v":0},"xxxxxxxxx",{"$f":"SUM(I8:I40)-SUM(H8:H40)","v":0},"DO NOT REMOVE formula in K40 to calculate H40 &I39 - hide formula from user"]
[null,null,null,null,null,null,null,{"$f":"SUM(H8:H42)","v":0},{"$f":"SUM(I8:I42)","v":0}]
[]
[]
[null,"Sheet  5"]

{"sheet":"6 - Surplus","index":8,"n_rows":50,"n_cols":12,"rows_kept":50,"cut":false,"hidden":false,"merged":[[30,2,30,6],[49,1,49,11],[2,1,2,11],[3,1,3,11],[18,1,18,11],[19,1,19,11]]}
[]
[]
[null,"SURPLUS  -  SOLID  WASTE  COLLECTION  DISTRICT"]
[null,{"$f":"'KEY INPUTS'!D33","v":2022}]
[]
[null,null,null,null,null,null,null,null,null,null,"Debit","Credit"]
[null,"1.",{"$f":"'KEY INPUTS'!D24","v":"Balance - January 1, 2022"},null,null,null,null,null,null,null,"xxxxxxxxx"]
[null,"2.",null,null,null,null,null,null,null,null,"xxxxxxxxx"]
[null,"3.",{"$f":"\"Excess Resulting from \"&TEXT('KEY INPUTS'!D33,\"0\")&\" Operations\"","v":"Excess Resulting from 2022 Operations"},null,null,null,null,null,null,null,"xxxxxxxxx",{"$f":"+'5 - Results of Operations'!H42","v":0}]
[null,"4.",{"$f":"\"Amount Appropriated in the \"&TEXT('KEY INPUTS'!D33,\"0\")&\" Budget - Cash\"","v":"Amount Appropriated in the 2022 Budget - Cash"},null,null,null,null,null,null,null,{"$f":"+'3 - Budget Revenues'!H10","v":0},"xxxxxxxxx"]
[null,"5.",{"$f":"\"Amount Appropriated in \"&TEXT('KEY INPUTS'!D33,\"0\")&\" Budget - with Prior Written-\"","v":"Amount Appropriated in 2022 Budget - with Prior Written-"}]
[null,null,"Consent of Director of Local Government Services",null,null,null,null,null,null,null,{"$f":"+'3 - Budget Revenues'!H12","v":0},"xxxxxxxxx"]
[null,"6.",null,null,null,null,null,null,null,null,null,"xxxxxxxxx"]
[null,"7.",{"$f":"'KEY INPUTS'!D25","v":"Balance - December 31, 2022"},null,null,null,null,null,null,null,{"$f":"+L7+L8+L9-K10-K12-K13","v":0},"xxxxxxxxx"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K10:K14)","v":0},{"$f":"SUM(L7:L14)","v":0}]
[]
[]
[]
[null,{"$f":"\"ANALYSIS OF BALANCE DECEMBER 31, \"&TEXT('KEY INPUTS'!D33,\"0\")","v":"ANALYSIS OF BALANCE DECEMBER 31, 2022"}]
[null,"(FROM  SOLID  WASTE  COLLECTION  DISTRICT  -  TRIAL  BALANCE)"]
[]
[]
[null,"Cash",null,null,null,null,null,null,null,null,null,{"$f":"+'2 - Trial Balance'!G11","v":0}]
[null,"Investments"]
[]
[null,"Sub Total",null,null,null,null,null,null,null,null,null,{"$f":"+L23+L24+L25","v":0}]
[null,"Deduct Cash Liabilities Marked with \"C\" on Trial Balance",null,null,null,null,null,null,null,null,null,{"$f":"'2 - Trial Balance'!H26","v":0}]
[null,"Cash Surplus",null,null,null,null,null,null,null,null,null,{"$f":"+L26-L27","v":0}]
[null,"Deficit in Cash Surplus"]
[null,"Other Assets Pledged to Surplus:*"]
[]
[null,null,"Deferred Charges #"]
[null,null,"Cash Deficit #"]
[]
[]
[]
[]
[null,null,null,"Total Other Assets",null,null,null,null,null,null,null,{"$f":"SUM(K31:K37)","v":0}]
[null,"* IN THE CASE OF A \"DEFICIT IN CASH SURPLUS\", \"OTHER ASSETS\"",null,null,null,null,null,null,null,null,null,{"$f":"+L28+L38","v":0}]
[null,null,"WOULD ALSO BE PLEDGED TO CASH LIABILITIES."]
[null,{"$f":"\"# MAY NOT BE ANTICIPATED AS NON-CASH SURPLUS IN \"&TEXT('KEY INPUTS'!D32,\"0\")&\" BUDGET.\"","v":"# MAY NOT BE ANTICIPATED AS NON-CASH SURPLUS IN 2023 BUDGET."}]
[null,"(1) MAY BE ALLOWED UNDER CERTAIN CONDITIONS."]
[]
[null,"NOTE: Deferred charges for authorizations under  N.J.S.A. 40A:4-55 (Tax Map, etc.), N.J.S.A. 40A:4-55 (Flood Damage, etc.), N.J.S.A."]
[null,"40A:4-55.1 (Roads and Bridges, etc.) and N.J.S.A. 40A:4-55.13 (Public Exigencies, etc.) to the extent of emergency notes issued"]
[null,"and outstanding for such purposes, together with such emergency notes, may be omitted from this analysis."]
[]
[]
[]
[null,"Sheet  6"]