division of antipolo city ca not tally

8/14/2019 Division of Antipolo City CA NOT TALLY

1/22

Division Account

Office Code Particulars Cash Advance (Balance)

as of Dec 31, 2012

(1) (2) (3) (4)

Division Proper (TOTAL ONLY) 106 Payroll Fund

BAGONG NAYON II NHS 106 Payroll Fund -

NOTE: Total Unliq

Consolidated INCL

CONSOLIDATED AGING OF CASH ADVANCES

As of March 31, 2013

1 2 3 4 = 5+6+7+8+9+10+11

Division Office (TOTAL ONLY) 106 Payroll Fund -

TOTAL

Division Office Account Code Particulars TOTAL

148Advances to Officers and

Employees

123Due from Officers and

Employees (IF ANY)

148Advances to Officers and

Employees

P


Employees (IF ANY)

C


2/22

Ius 106 Payroll Fund -

(TOTAL ONLY of the Ius) 123 Due from OE (IFANY) -

148 Advances to OE -

Attention:

ACCOUNTANTSPlease SUBMIT ASAP and UPDATE MONTHLY for early submission

Email to: [email protected]


Fax No. 682-6941

TOTAL


3/22

Balance as of % of Cash Advance Balance as of

Dec. 31, 2012 Liquidation for CY 2013 Mar. 31, 2013

(5) (6=4-5) (7=5/4) (8) (9) (10=8-9)

- -

- - - - -

uidated CA must tally with the Consolidated Trial Balance as of Decembe

UDING Ius

5 6 7 8 9 10

Amount Due

Current Past Due

31 - 60 days 61 - 90 days 91 - 365 days Over 1 Year Over 2 Years

Less than 30 days

- 7,200.00 7,200.00 -

- - -

- -

RIOR YEAR CASH ADVANCE CURRENT YEAR 2013

Liquidation

(this year)

Liquidation

(this year)

- -

(In Pesos)

DEPARTMENT OF EDUCATION

NSOLIDATED STATUS OF CASH ADVANCE

REGION IV-A (CALABARZON)

Gate 2, Karangalan Village, Cainta, RizalAs of March 31, 2013


4/22

-

-

-

- - - - -

Prepared by: Certified Correc


5/22

Total Unliquidated

% of Cash Advance

Liquidation as of March 31, 2013

(11=9/8) (12=6+10)

-

-

r 31, 2012

11 12

Remarks

Over 3 Years

-100%

-

-

-


6/22

-

by:


7/22

Division Account

Office Code Particulars Cash Advance (Balance) as Balance as of % of Cash Advance Balance as of

of March 2012 March 2012 Liquidation for CY 2012 March 2012

(1) (2) (3) (4) (5) (6=4-5) (7=5/4) (8) (9) (10=8-9)

Division Proper 106 Payroll Fund

Ius (TOTAL of the Ius) 106 Payroll Fund

Cupang National High School 106 Payroll Fund - 48,818.18 48,818.18 -

Attention:



Email to: [email protected] Prepared by: Certified Correct by:

Fax No. 682-6941


As of December 31, 2011

123

Due from Officers and

Employees (IF ANY)


CONSOLIDATED STATUS OF CASH ADVANCE


Gate 2, Karangalan Village, Cainta, Rizal


(In Pesos)

PRIOR YEAR CURRENT YEAR 2011

Liquidation

(this year)

Liquidation (this

year)

148Advances to Officers

and Employees


Employees (IF ANY)


and Employees


Employees (IF ANY) -


and Employees-

TOTAL

Division Office Account Code P Amount Balance Less than 30 days

Amount Due

Current Past Due



8/22

1 2 3 4 5 6 7 8 9

Division Office 106 Payroll Fund

123 Due from OE (IFANY)

148 Advances to OE

Ius 106 Payroll Fund

(TOTAL of the Ius) 123 Due from OE (IFANY)

148 Advances to OE

- - - - -

Attention:




Fax No. 682-6941

TOTAL


9/22

Total Unliquidated

% of Cash Advance

Liquidation as of Mar. 31, 2012

(11=9/8) (12=6+10)

100%

Total Remarks

Over 3 Years


10/22

11 12

- -


11/22

Division Account



(1) (2) (3) (4) (5) (6=4-5) (7=5/4) (8) (9) (10=8-9)



SAN JOSE NATIONAL HIGH SCHOOL 106 Payroll Fund - 145,530.00 145,530.00 -

145,530.00 145,530.00

Attention:




Fax No. 682-6941



123

Due from Officers and

Employees (IF ANY)






(In Pesos)


Liquidation

(this year)

Liquidation (this

year)


and Employees


Employees (IF ANY)


and Employees




and Employees-

TOTAL

Division Office Account Code P Amount Balance Less than 30 days

Amount Due

Current Past Due



12/22

1 2 3 4 5 6 7 8 9

Division Office 106 Payroll Fund123 Due from OE (IFANY)

148 Advances to OE

Ius 106 Payroll Fund

(TOTAL of the Ius) 123 Due from OE (IFANY)

148 Advances to OE

- - - - -

Attention:




Fax No. 682-6941

TOTAL


13/22

Total Unliquidated

% of Cash Advance


(11=9/8) (12=6+10)

100% -

Total Remarks

Over 3 Years


14/22

11 12

- -


15/22

Division Account



(1) (2) (3) (4) (5) (6=4-5) (7=5/4) (8) (9) (10=8-9)



Mambugan National High School 106 Payroll Fund - 92,000.00 92,000.00 -

92,000.00 92,000.00

Prepared by: Certified Correct by:

AIDA T. TAYAMORA

Senior Bookkeeper

TOTAL

- -


and Employees-




and Employees


Employees (IF ANY)


and Employees


Employees (IF ANY)


STATUS OF CASH ADVANCE


MAMBUGAN NATIONAL HIGH SCHOOL


(In Pesos)


Liquidation

(this year)

Liquidation (this

year)

Ruhat HillS, Siruna Village, Mambugan, Antipolo City


16/22

Total Unliquidated

% of Cash Advance


(11=9/8) (12=6+10)

100% -

-


17/22

Division AccountOffice Code Particulars Cash Advance (Balance) Balance as of % of Cash Advance Balance as of % of

as of Dec 31, 2012 Mar 31, 2013 Liquidation for CY 2013 Mar. 31, 2013 Liquidation

(1) (2) (3) (4) (5) (6=4-5) (7=5/4) (8) (9) (10=8-9) (11=9/8)

Division Proper (TOTAL ONLY) 106 Payroll Fund - -

IUs (TOTAL ONLY of the IUs) 106 Payroll Fund - 67,845.00 67,845.00 - 100%

NOTE: Total Unliquidated CA must tally with the Consolidated Trial Balance as of March 31, 2013

Consolidated INCLUDING Ius



1 2 3 4 = 5+6+7+8+9+10+11 5 6 7 8 9 10 11

Division Office (TOTAL ONLY) 106 Payroll Fund -

123 Due from OE (IFANY) -


IUs 106 Payroll Fund -(TOTAL ONLY of the IUs) 123 Due from OE (IFANY) -


- - - - - -

Attention: Prepared by: Certified Correct by:

ACCOUNTANTSPlease SUBMIT ASAP and UPDATE MONTHLY for early submission DANIEL M. YURABA

Email to: [email protected] SENIOR BOOKKEEPER

TOTAL

Amount Due

Current Past Due

31 - 60 days 61 - 90 days 91 - 365 days Over 1 Year Over 2 Years Over 3 Years

Less than 30 days

TOTAL

Division Office Account Code Particulars TOTAL


and Employees- 67,845.00 67,845.00 - 100%


Employees (IF ANY)- -


and Employees- -

PRIOR YEAR CASH ADVANCE CURRENT YEAR 2012Liquidation

(this year)

Liquidation

(this year)

- -123Due from Officers and

Employees (IF ANY)

(In Pesos)







18/22


Fax No. 682-6941


19/22

Total UnliquidatedCash Advance

as of December 31, 2012

(12=6+10)

-

-

12

Remarks

-

-

-

-


20/22

Division Account

Office Code Particulars Cash Advance (Balance) Balance as of % of Cash Advance Balance as of % of

as of Dec 31, 2012 March 31, 2013 Liquidation for CY 2013 March 31, 2013 Liquidation

(1) (2) (3) (4) (5) (6=4-5) (7=5/4) (8) (9) (10=8-9) (11=9/8)

Division Proper (TOTAL ONLY) 106 Payroll Fund

Cupang Nat'l High School 48,818.18 48,818.18 - 100%

Mambugan Nat'l High School 92,000.00 92,000.00 - 100%

Mayamot Nat'l High school 67,845.00 67,845.00 - 100%

San Jose Nat'l High School 145,530.00 145,530.00 - 100%

IUs (4) 354,193.18 354,193.18 - 100%

123 Due from Officers and

Bagong Nayon II Nat'l High School 7,200.00 7,200.00 - 100%

IUs (1) 7,200.00 7,200.00 - 100%

NOTE: Total Unliquidated CA must tally with the Consolidated Trial Balance as of March 31, 2013

Consolidated INCLUDING Ius



1 2 3 4 = 5+6+7+8+9+10+11 5 6 7 8 9 10 11

Division Office (TOTAL ONLY) 106 Payroll Fund 3,599,900.33 1,513,141.34 2,086,758.99

123 Due from OE (IFANY) -


IUs 106 Payroll Fund 361,393.18 361,393.18

5 123 Due from OE (IFANY) -


- 361,393.18 1,513,141.34 2,086,758.99 - - -TOTAL

TOTAL Less than 30 days

Amount Due

Division Office Account Code Particulars

Current Past Due

31 - 60 days 61 - 90 days 91 - 365 days Over 1 Year Over 2 Years Over 3 Years

106 Payroll Fund

148 Advances to Officers

and Employees


and Employees467,151.31 317,229.37 149,921.940 68% 172,300.00 148,800.00 23,500.00 86%

PRIOR YEAR CASH ADVANCE CURRENT YEAR 2012

Liquidation

(this year)

Liquidation

(this year)

421,208.23 81% 2,676,727.00 1,187,085.66 1,489,641.34 44%143

Due from Implementing

Units 2,190,737.85 1,769,529.62

(In Pesos)







21/22

Attention: Prepared by: Certified Correct by:




Fax No. 682-6941


22/22

Total Unliquidated

Cash Advance

as of March 31, 2013

(12=6+10)

-

-

12

Remarks

173,421.94

1,910,849.57

division of antipolo city ca not tally

Documents