Finance — Accounts Receivable
Government collection tracking · Aging analysis · Invoice monitoring
Total Receivables
₱55.35M
8 active accounts
Overdue (90+ Days)
₱19.3M
3 accounts · 35% of AR
Collected YTD
₱38.7M
↑ 12% vs last year
Avg Collection Days
74 days
Target: 60 days
Aging Breakdown
Current (0–30)
₱12.25M
3 accounts
30–60 Days
₱12.4M
1 account
60–90 Days
₱8.7M
1 account
90+ Days
₱19.3M
3 accounts
Collected
₱7.3M
1 account
9 records · ₱59.85M
| Invoice No | Client | Project Ref | Delivery | Invoice Date | Claim Date | Amount | Aging | Status | Officer | Remarks |
|---|---|---|---|---|---|---|---|---|---|---|
| INV-2026-0041 | City of DavaoLGU | PRJ-2026-001 | Apr 10 | Apr 12 | Apr 15 | ₱12,400,000 | 58d | Maria Santos | Awaiting COA clearance | |
| INV-2026-0038 | Quezon City GovLGU | PRJ-2026-002 | Mar 20 | Mar 22 | Mar 25 | ₱8,700,000 | 79d | Jose Reyes | Budget release pending | |
| INV-2026-0035 | Cebu ProvinceLGU | PRJ-2026-003 | Feb 14 | Feb 16 | Feb 20 | ₱4,200,000 | 112d | Maria Santos | Escalated to COO | |
| INV-2026-0044 | DPWH Region VIIGov Agency | PRJ-2026-004 | May 02 | May 03 | May 05 | ₱3,100,000 | 28d | Ana Cruz | Documents submitted | |
| INV-2026-0029 | Makati Medical CenterHospital | PRJ-2026-005 | Jan 15 | Jan 17 | Jan 20 | ₱5,200,000 | 145d | Jose Reyes | Legal review ongoing | |
| INV-2026-0047 | Batangas ProvinceLGU | PRJ-2026-006 | May 20 | May 21 | May 23 | ₱6,400,000 | 10d | Ana Cruz | Newly filed | |
| INV-2026-0021 | DOH Region IIIGov Agency | PRJ-2025-088 | Dec 10 | Dec 12 | Dec 15 | ₱9,800,000 | 172d | Maria Santos | Partial payment received ₱2M | |
| INV-2026-0050 | Iloilo City GovLGU | PRJ-2026-009 | Jun 01 | Jun 02 | Jun 03 | ₱2,750,000 | 5d | Ana Cruz | Inspection pending | |
| INV-2026-0015 | Pampanga ProvinceLGU | PRJ-2025-071 | Nov 05 | Nov 07 | Nov 10 | ₱7,300,000 | — | Jose Reyes | Fully collected May 28 |