cashflows.4thqtr2022.xls

	A	B	C	D	E	F	G	H	I	J	K
1	4th qtr 2022
2
3	CASH FLOWS FROM OPERATING ACTIVITIES
4
5		Cash Inflows
6
7			Collection from Taxpayers		Amount	Collection from Taxpayers	Share from Internal Revenue Allotment	Receipts from Business/ Service Income	Interest Income	Other Receipts
8
9				Collection from Share from Taxes/ National Wealth	192,000.00	192,000.00
10
11				Collection of Property Taxes	12,582,415.00	12,582,415.00
12
13				Collection of Tax Revenue - Fines and Penalties	510,782.10	510,782.10
14
15				Collection of Tax Revenues - Tax Revenue - Individual and Corporations	55,415.50	55,415.50
16
17				Collection of Taxes on Goods and Services	7,404,020.05	7,404,020.05
18
19			Share from Internal Revenue Allotment
20
21				Receipts of Internal Revenue Allotments (IRA)	825,705,905.00		825,705,905.00
22
23			Receipts from business/service income
24
25				Collection from Business Income	26,324,219.23			26,324,219.23
26
27				Collection from Service Income	1,382,607.58			1,382,607.58
28
29				Collection of Miscellaneous Income	3,810,565.70			3,810,565.70
30
31			Collection of Receivables
32
33				Collection of Inter Agency Receivables	214,258.08					214,258.08
34
35				Collections from Accounts Receivable /and Note Receivable	18,758,825.59			18,758,825.59
36
37				Collections of Other Receivables	68,488.76					68,488.76
38
39			Receipt of Interest Income
40
41				Proceeds from Interest Income	8,055,177.41				8,055,177.41
42
43			Other Receipts
44
45				Collections of Intra Agency Fund Transfers	2,960,911.86					2,960,911.86
46
47				Receipt of funds in behalf of Other Funds or Special Accounts	42,347,531.25					42,347,531.25
48
49				Receipt of refund from Cash Advances	210,832.42					210,832.42
50
51				Receipt of refund of Cash Shortages	9.00					9.00
52
53				Receipts from Trust Liabilities	10,032,597.09					10,032,597.09
54
55				Receipts of Assistance and Subsidies	88,216,031.31					88,216,031.31
56
57				Receipts of Shares, Grants and Donations	1,126,662.71					1,126,662.71
58
59				Refund from Overpayment of Maintenance and Other Operating Expenses	842,289.45					842,289.45
60
61			Adjustments
62
63				Adjustment due to wrong SA/ Reversal due to error in recording	333,814.38					333,814.38
64
65				Adjustment to cash accounts due to overstatement in recording disbursements	55,089,601.15					55,089,601.15
66
67				Adjustment to Cash Accounts due to wrong account used	20,000.00					20,000.00
68
69				Cancelled check	37,800.00					37,800.00
70
71				Deposits of Collections (to include deposit erroneously made to other funds)	432.55					432.55
72
73				To revert Stale Check to Cash	226,274.00					226,274.00
74
75				Total	1,106,509,467.17	20,744,632.65	825,705,905.00	50,276,218.10	8,055,177.41	201,727,534.01	1,106,509,467.17
76
77		Cash Outflows
78
79			Payment of Expenses		Amount	Payment to Suppliers and Creditors	Payment to Employees	Interest Expense	Other Expenses
80
81				Payment / Reimbursement of Travelling Expenses	(4,143,238.49)		(4,143,238.49)
82
83				Payment for Communication Expenses	(1,934,226.86)	(1,934,226.86)
84
85				Payment for General Services	(70,692,746.63)	(70,692,746.63)
86
87				Payment for Maintenance and Other Operating Expenses	(15,907,300.11)	(15,907,300.11)
88
89				Payment for Professional Expenses	(29,054,376.79)	(29,054,376.79)
90
91				Payment for Repairs and Maintenance	(13,121,630.53)	(13,121,630.53)
92
93				Payment for Rewards and Prizes	(2,135,625.00)				(2,135,625.00)
94
95				Payment for Taxes, Insurance Premiums and Other Fees	(3,790,917.97)				(3,790,917.97)
96
97				Payment for the Purchase of Supplies and Materials directly issued to end-user	(22,183,751.58)	(22,183,751.58)
98
99				Payment for Utility Expenses	(15,397,223.61)	(15,397,223.61)
100