Loading...
HomeMy WebLinkAbout2023.06.20 PPFD Handout - Finance Report G�� �'2� � rv��-- - [��ryF;�� ��5� � P�� �"��e Balance Sheet ���� Through 06/20/23 � Detaii Listing ��tiF:��hi���;�.��: Include Rollup Account/Rollup to Base � Current YTD Prior Year Account Account Description Balance Total Actual Net Chanue Change% Furd Category E�ernal `urd Type Fun� 931-Pasco Public Facility District ASSETS 10 50.1010 Cash 799,597.42 1.29 799,596.13 61,984,196.12 10-Totals $799,597.42 $1.29 $799,596.13 61,984,196.12% 12 12.1210 Taxes Receivable-Sales .00 139,009.27 (139,009.27) (100.00) 12-Totals $0.00 $139,009.27 ($139,009.27) (100.00%) ASSETS TOTALS $799,597.42 $139,010.56 $660,586.86 475.21% LIABILITIES AND FUND EQUITY LIABILITIES 21 21.2105 Aaounts Payable 9,000.00 8,387.10 612.90 7.31 21.2128 Dueto Other Govt .00 150,120.00 (150,120.00) (100.00) 21.2225 A/P Year End Accrual .00 210,216.43 (210,216.43) (100.00) 21-Totals $9,000.00 $368,723.53 ($359,723.53) (97.56%) LIABILITIES TOTALS $9,000.00 $368,723.53 ($359,723.53) (97.56%) FUND EQUITY 29 � 29.2900 Fund Balance (229,712.47) (229,712.97) .00 .00 29-Totals ($229,712.97) ($229,712.97) $0.00 0.00% FUND EQUITY TOTALS Prior to Current Year Changes ($229,712.97) ($229,712.97) $0.00 0.00% Prior Year Fund Equity Adjustment .00 Fund Revenues (1,286,535.57) Fund Expenses 266,225.18 FUND EQUIIY TOTALS $790,597.42 ($229,712.97) $1,020,310.39 444.17% LIABILITIES AND FUND EQUIII'TOTALS $799,597.42 $139,010.56 $660,586.86 475.21% �und 931-Pasco Public Facility District Totals $0.00 $0.00 $0.00 +++ Fund Tyt�e Totals $0.00 $0.00 $0.00 +++ Fund Category External Totals $0.00 $0.00 $0.00 +++ Grand Totals $0.00 $0.00 $0.00 +++ Run by Monica Hofstetter on 06/20/2023 13:05:57 PM Page 1 of 1 �� � � Budget Performance Report ����� Fiscal Year to Date 06/20/23 � Inciude Rollup Accaunt and Rollup to Base ,".t.1�+,:E� Adopted YTD Budget-YTD Acmunt Account Descnption Budget T2nsactions Trdnsadions Fund 431-Pasco Public Facility District REVENUE Dept 1?-City Mgr Prog 590-PPFD Admin 31 31.1310 LocalSalesTax .00 1,077,054.01 (1,077,054.Q1) 31.1311 PFD Sales Tax 500,000.00 199,481.54 300,518.46 31-ToWls $500,000.00 y1,276,535.55 ($776,535.55) 34 34.4527 PFD Paxo Support 20,000.00 10,000.02 9,999.98 34-TOWIs $20,000.00 $10,000.02 $9,999.98 Prog 590-PPFD Admin Totals $520,000.00 y1,286,535.57 ($766,535.57) Dept 13-City Mgr Tota'.s $520,000.00 $1,286,535.57 ($766,535.57) REVENUE TOTALS $520,000.00 $1,286,535.57 ($766,535.57) EXPENSE DeDt 13-City Mgr Prog 590-PPFD Admin 54.4524 Advertising 500.00 566.29 (68.29j � 54.4530 Legal Combined Sen�ces 1,200.00 5,483.50 (4,283.50) 54.4540 Organizational5ervices 500,000.00 199,481.54 300,518.46 54.4541 Professiondl Services 5,000.00 57,150.00 (52,150.00j 54.4574 Pos�ge Couner Shipping .00 .00 .00 54.4635 Insurance Premiums 3,150.00 3,541.85 (391.65) 54.4900 I/F Admin Services 12,000.00 .00 12,000.00 54-Totals $521,850.00 $266,2Z5.18 $255,624.82 Proa 590-PPFD Admin TotalS $521,850.00 $266,225.18 $255,624.82 Dept 13-City Mgr Tota�s $SZS,S50.00 $266,225.18 $255,624.82 EXPENSE TOTALS $521,850.00 $266,225.18 $255,624.82 Fund 931-Pasco Pu61ic Facility District Totals REVENUE TOTALS 520,OOQ.40 1,286,535.57 (766,535.57) IXPENSE TOTALS 521,850.00 266,225.18 255,624.82 Fund 931-vasco vublic Facility oistrid rotals ($1,850.�0) $1,020,31039 ($1,022,160.39j Run 6y Monica Hofstetter on 06/20/2023 01:07:40 PM Page 1 of 1 CITY OF PASCO Expense Ledger Detail Listing From Date: 1/1l2023-To Date: 6/30l2023 G1L Date Journal lournal TypSub Ledger Description/Project Source Reference Budget Encumbrance Actual GIL Account Number:931.13.590-54.4524 Advertising 4/7/2023 2023-00001417 JE AP A/P Invoice Entry Accounts Payable $�g.Zg Invoice Number Vendor Description Invoice Date Payment Type Payment Number Amount Distribution Amount 185018 TRI CITY HERALD LEGAL ADVERTISEMENTS 2/24-3/10/202 3/31/2023 Check 255354 $568.29 $568.29 Total: $568.29 Month Total: April 2023 $568.29 Account Total: Advertising $500.00 $O.Oo $568.29 G/L Account Number:931.13.590-54.4530 Legal Combined Services 1l18l2023 2023-00000319 JE AP A/P Invoice Entry Accounts Payable $918.00 Invoice Number Vendor Description Invoice Date Payment Type Payment Number Amount Distribution Amount 17842 KERR FERGUSON LAW PLLC PPFD LEGAL SERVICES DECEMBER 20�1/13l2023 Check 253774 $918.00 $918.00 Total: $918.00 Month Total: January 2023 $918.00 2!6/2023 2023-00000500 JE AP A/P Invoice Entry Accounts Payable $1,440.00 Invoice Number Vendor Description Invoice Date Payment Type Payment Number Amount Distribution Amount 17859 KERR FERGUSON LAW PLLC PPFD LEGAL SERVICES JANUARY 2023 2/212023 Check 253922 $1,440.00 $1,440.00 Total: $1,440.00 Month Total: February 2023 $1,440.00 3/13/2023 2023-00001035 JE AP A/P Invoice Entry Accounts Payable $936.00 Invoice Number Vendor Description Invoice Date Payment Type Payment Number Amount Distribution Amount 17877 KERR FERGUSON LAW PLLC PPFD LEGAL SERVICES/FEBRUARY 202 3l7/2023 Check 254721 $936.00 $936.00 Total: $936.00 Month Total: March 2023 $936.00 5115/2023 2023-Q0001965 JE AP A/P Invoice Entry Accounts Payable $330.50 Invoice Number Vendor Description Invoice Date Payment Type Payment Number Amount Distribution Amount 17924 KERR FERGUSON LAW PLLC PPFD LEGAL SERVICES/MARCH 2O23 5/1l2023 Check 256068 $330.50 $330.50 Total: $330.50 Month Total: May 2023 $330.50 6/6/2023 2023-OQ002441 JE AP A/P Invoice Entry Accounts Payable $1,859.00 Invoice Number Vendor Description Invoice Date Payment Type Payment Number Amount Distribution Amount 17943 KERR FERGUSON LAW PLLC PPFD LEGAL SERVICES/MAY 2023 6/2/2023 Check 256663 $1,859.00 $1,859.00 Total: $1,859.00 Month Total: June 2023 $1,859.00 Account Total: legal Combined Services $1,200.00 $O.DO �5,483.50 user:Monica Hofstetter Pages 1 of 3 Tuesday,June 20,2023 CITY OF PASCO Expense Ledger Detail Listing From Date: 1l1I2023-To Date:6/30/2023 G/L Account Number:931.13.590-54.4540 Organizational Services 4/4/2023 2023-00001417 JE AP A/P Invoice Entry Accounts Payable $61,693.28 Invoice Number Vendor Description Invoice Date Payment Type Payment Number Amount Distribution Amount APRIL 2023 KENNEWICK PUBLIC FACILITIES PFD SALES TAX REC'D BY PA5C0 AND 4/4l2023 Check 255285 $61,693.28 $61,693.28 Total: $61,693.28 Month Total: April 2023 $61,693.28 5(11/2023 2023-00001959 JE AP A/P Invoice Entry Accounts Payable $59,693.82 Invoice Number Vendor Description Invoice Date Payment Type Payment Number Amount Distribution Amount MAY 2023 KENNEWICK PUBLIC FACILITIES PFD SALES TAX REC'D BY PASCO AND:5/9/2023 Check 256067 $59,693.82 $59,693.82 Total: $59,693.82 Month Total: May 2023 $59,693.82 616/2023 2023-00002441 JE AP A/P Invoice Entry Accounts Payable $78,094.44 Invoice Number Vendor Description Invoice Date Payment Type Payment Number Amount Distribution Amount JUNE 2023 KENNEWICK PUBLIC FACILITIES PFD SALES TAX REC'D BY PASCO AND:6/2/2023 Check 256662 $78,094.44 $78,094.44 Total: $78,094.44 Month Total: June 2023 $78,094.44 Account Total: Organizational Services $500.000.00 $0.00 �199.481.Sa GlL Account Number:931.13.590-54.4541 Professional Services 1/1l2023 2023-00000019 AB AB Post Adopted Budget BudgetProcessing Month Total: January 2023 $0.00 213/2023 2023-00000495 JE AP A/P Invoice Entry Accounts Payable $10,000.00 Invoice Number Vendor Description Invoice Date Payment Type Payment Number Amount Distribution Amount 007 WATKINS ENDEAVOR LLC SERVICES FOR PPFD 1/1/23-1/31/23 2/1/2023 Check 254011 $10,000.00 $10,000.00 Total: $10,000.00 Month Total: February 2023 $10,000.00 3/6/2023 2023-00000966 JE AP A/P Invoice Entry Accounts Payable $10,000.00 Invoice Number Vendor Description Invoice Date Payment Type Payment Number Amount Distribution Amount 008 WATKINS ENDEAVOR LLC SERVICES FOR PPFD 211123-2/28l23 3!1l2023 Check 254638 $10,000.00 $10,000.00 Total: $10,000.00 3/27/2023 2023-00001170 JE AP A/P Invoice Entry Accounts Payable $10,000.00 Invoice Number Vendor Description Invoice Date Payment Type Payment Number Amount Distribution Amount 009 WATKINS ENDEAVOR lLC SERVICES FOR PPFD 3!1/2023-3/31l202�4/1/2023 Check 255065 $10,000.00 $10,000.00 Total: $10,000.00 Month Total: March 2023 $20,000.00 4l17/2023 2023-00001658 JE AP A/P Invoice Entry Accounts Payable $150.00 user:Monica Hofstetter Pages 2 of 3 Tuesday,June 20,2023 CITY OF PASCO Expense Ledger Detail Listing From Date: 1I112023-To Date:6130l2023 Invoice Number Vendor Description Invoice Date Payment Type Payment Number Amount Distribution Amount 105 SIGDEL RICHA FIRE IMPACT,GENERAL FUND STUDY b3121/2023 Check 255683 $10,000.00 $150.00 Total: $150.00 Month Total: April 2023 $150.00 5l1/2023 2023-00001907 JE AP A/P Invoice Entry Accounts Payable $9,000.00 Invoice Number Vendor Description Invoice Date Payment Type Payment Number Amount Distribution Amount 010 WATKINS ENDEAVOR LLC SERVICES FOR PPFD 411 01/2 0 2 3-4/30/2C5l1/2023 Check 255958 $10,000.00 $9,000.00 Total: $9,000.00 5l19/2023 2023-00002021 JE AP A/P Invoice Entry Accounts Payable $5,000.00 Invoice Number Vendor Description Invoice Date Payment Type Payment Number Amount Distribution Amount 106 SICaDEL RICWA PDF PINANCIAI MODELIW6 4/29/2023 Check 256276 $4,OOO.dO $4,000.00 107 SIGDEL RICHA PDF FINANCIAL MODELING 5/1/2023 Check 256276 $4,000.00 $4,000.00 Total: $8,000.00 Month Total: May 2023 $17,000.00 6l512023 2023-00002441 JE AP A!P Invoice Entry Accounts Payable $10,000.00 Invoice Number Vendor Description Invoice Date Payment Type Paymeni Number Amount Distribution Amount 011 WATKINS ENDEAVOR LLC SERVICES FOR PPFD 5/01/23-5/31/23 6J1/2023 Check 256746 $10,000.00 $10,000.00 Total: $10,000.00 Month Total: June 2023 $10,000.00 Account Toial: Professional Services $5,000.00 $O.OD $57,150.00 G/L Account Number:931.13.590-54.4635 Insurance Premiums 1/1l2023 2023-00000019 AB AB Post Adopted Budget BudgetProcessing 1I27/2023 2023-00000306 JE AP A/P Invoice Entry Accounts Payable $3,541.85 Invoice Number Vendor Description Invoice Date Payment Type Payment Number Amount Distribution Amount 3041138 HUB INTERNATIONAL NORTHWEPPFD INSURANCE 1l28/2023-1/28/2024 1/27/2023 Check 253702 $3,541.85 $3,541.85 Total: $3,541.85 Month Total: January 2023 $3,541.85 Account Total: Insurance Premiums $3,150.00 $0.00 $3,541.85 Fund Total: Pasco Public Facility District $521,850.00 $0.00 �266,225.18 user:Monica Hofstetter Pages 3 of 3 Tuesday,June 20,2023 Cash Flow Budget Analysis Pasco Public Facilities District Reference Actual Budget Beginning A Balance (229,713) (232,506) (237,413) 122,452 434,953 850,386 1,107,835 1,383,738 1,660,141 1,9 Ori�inal BudRet New Bud�et 1an-23 Feb-23 Mar-23 Apr-23 May-23 Jun-23 Jul-23 Aug-23 Sep-23 Revenues PPFD Retail Sales Tax(2/10th) 3,250,000 - 4,866 326,941 323,051 422,197 325,000 325,000 325,000 325,000 3 Regional Retail Sales Tax 500,000 500,000 - - 61,693 59,694 78,094 60,000 60,000 60,000 60,000 Pasco Subsidy PFD 20,000 20,000 1,667 1,667 1,667 1,667 1,667 1,667 1,667 1,667 1,667 Total Revenues 520,000 3,770,000 B 1,667 6,533 390,301 384,412 501,958 386,667 386,667 386,667 386,667 3 Exqenses Advertising 500 1,500 - - - 568 - - 500 - - Legal 1,200 12,000 918 1,440 936 - 331 1,859 1,000 1,000 1,000 Organization Service 500,000 500,000 - - - 61,693 59,694 78,094 60,000 60,000 60,000 Insurance Premium 3,150 3,542 3,542 - - - - - - - - Professional Services 5,000 120.000 - 10,000 20,000 150 17,000 10,000 10,000 10,000 10,000 Owner's Representative 208,350 - - - - - 29,764 29,764 29,764 29,764 Design Costs Cost Allocation 12,000 108,000 - - 9,500 9,500 9,500 9,500 9,500 9,500 9,500 Total Expenses 521,850 953,392 C 4,460 11,440 30,436 71,911 86,525 129,218 110,764 110,264 110,264 1 Net Revenue/(Expense) D (2,793� (4,907) 359,865 312,501 415,433 257,449 275.903 276,403 276,403 2 Ending E Balance (232,506} (237,413) 122,452 434,953 850.386 1,107,835 1,383,738 1,660,141 1,936,543 2,2 Reference: A=Beginning Cash Available B=Monthly Revenues C=Monthly Expenses D=Monthly Net Revenue/(Expense) E=Ending Cash Available,based on actual or anticipated monthly activity