2021 1st Quarter.xlsx

	A	C	D	E
1	DEPARTMENT OF THE INTERIOR AND LOCAL GOVERNMENT
2	REGION MIMAROPA
3	PRE CLOSING TRIAL BALANCE
4	AS OF MARCH 31, 2021
5	ACCOUNT NAME	ACCOUNT CODE	DEBIT	CREDIT
6	Petty Cash Fund	1-01-01-020	#REF!
7	Cash in Bank, LCCA	1-01-02-020	#REF!
8	Cash Treasury/Agency Deposit, Regular	1-01-04-010	#REF!
9	Cash, National Treasury MDS	1-01-04-040	#REF!	qeeweq
10	Due from NGA's	1-03-03-010	#REF!
11	Due from LGU's	1-03-03-030	#REF!
12	Receivables-Disallowances/Charges	1-03-05-010	1,735,822.50
13	Office Supplies Inventory	1-04-04-010	#REF!
17	Buildings	1-06-04-010	13,724,419.92
18	Acc. Dep'n - Buildings	1-06-04-011		224,147.33
19	Office Equipment	1-06-05-020	6,180,659.61
20	Acc. Dep'n - Office Equipment	1-06-05-021		4,840,249.60
21	Furniture and Fixtures	1-06-07-010	1,117,362.97
22	Acc. Dep'n - Furniture and Fixture	1-06-07-011		277,107.83
23	Information and Comm. Tech. Equip.	1-06-05-030	11,391,563.41
24	Acc. Dep'n - ICT Equipment	1-06-05-031		7,680,441.93
25	Communication Equipment	1-06-05-070	42,500.00
26	Acc. Dep'n - Communication Equipment	1-06-05-071		4,232.30
27	Other Machinery and Equipment	1-06-05-990	633,923.20
28	Acc. Dep'n - Other Machinery and Equipment	1-06-05-991		26,500.70
29	Motor Vehicle	1-06-06-010	17,340,401.39
30	Acc. Dep'n - Motor Vehicle	1-06-06-011		9,488,065.59
33	Advances to Special Disbursing Officer	1-99-01-030	#REF!
35	Prepaid Insurance	1-99-02-050	#REF!
36	Other Prepayments	1-99-02-990	5,800.00
37	Guaranty Deposits	1-99-03-050	35,000.00
39	Due to BIR	2-02-01-010		#REF!
43	Due to NGA's	2-02-01-050		#REF!
46	Accumulated Surplus/ (Deficit)	3-01-10-010		#REF!
47	Subsidy from National Government	4-03-01-010		#REF!
48	Subsidy from Central Office NTA	4-03-01-060		#REF!
51	Salaries and Wages - Regular	5-01-01-010	#REF!
52	PERA	5-01-02-010	#REF!
53	Representation Allowance	5-01-02-020	#REF!
54	Transportation Allowance	5-01-02-030	#REF!
58	Overtime and Night Pay	5-01-02-130	#REF!
62	Retirement and Life Insurance Prem.	5-01-03-010	#REF!
63	Pag-Ibig Contribution	5-01-03-020	#REF!
64	Philhealth Contribution	5-01-03-030	#REF!
65	Employee Compensation Insurance Premiums	5-01-03-040	#REF!
66	Terminal Leave Benefits	5-01-04-030	#REF!
68	Travelling Expenses - Local	5-02-01-010	#REF!
69	Training Expenses	5-02-02-010	#REF!
70	Office Supplies Expenses	5-02-03-010	#REF!
71	ACCOUNT NAME	ACCOUNT CODE
77	Medical, Dental and Laboratory Supplies Expenses	5-02-03-080	#REF!
78	Fuel, Oil and Lubricants Expenses	5-02-03-090	#REF!
79	Other Supplies and Materials Expenses	5-02-03-990	#REF!
80	Water Expenses	5-02-04-010	#REF!
81	Electricity Expenses	5-02-04-020	#REF!
82	Postage and Courier Services	5-02-05-010	#REF!
83	Telephone Expenses	5-02-05-020	#REF!
84	Internet Subscription Expenses	5-02-05-030	#REF!
86	Extraordinary and Miscellaneoues Expenses	5-02-10-030	#REF!
87	Auditing Services	5-02-11-020	#REF!
90	Security Services	5-02-12-030	#REF!
91	Other General Services	5-02-12-990	#REF!
93	Repair & Maintenance - Machinery and Equip.	5-02-13-050	#REF!
94	Repair & Maintenance - Transpo Equip.	5-02-13-060	#REF!
96	Financial Assistance to LGUs	5-02-14-030	#REF!
97	Susidies - Others	5-02-14-990	#REF!
98	Taxes, Duties and Licenses	5-02-15-010	#REF!
99	Fidelity Bond Premiums	5-02-15-020	#REF!
100	Printing and Binding	5-02-99-020	#REF!
102	Rent/Lease Expense	5-02-99-050	#REF!
103	Other Maintenance and Operating Expenses	5-02-99-990	#REF!
110	TOTAL		#REF!	#REF!
111			#REF!
112
113	CERTIFIED CORRECT:
114
115	VAN ANGELO E. MAGUMUN
116	ACCOUNTANT III
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138