ABCDEFGHIJKLMNOPQRSTUVWXY
1
2
AGING REPORT OF ACCOUNTS RECEIVABLES
3
Client NameProject NameInvoice #Invoice Amount (vat-ex)Invoice Percentage Payment TermsInvoice DateInvoice Due Date# of Days from Invoice Date# of Days Overdue
5
Qymera Inc.Huawei Cloud Project - Oct0002559,440.1461%30 Days1/30/242/29/249969
6
Qymera Inc.Huawei Cloud Project - Nov0003701,992.66100%30 Days1/30/242/29/249969
7
Qymera Inc.Huawei Cloud Project - Dec0004731,781.04100%30 Days1/30/242/29/249969Burn Rate per month3,500,000.00
8
Qymera Inc.Huawei Cloud Project - Jan0005684,944.28100%30 Days1/30/242/29/249969Daily burn rate 116,666.67
9
City Savings BankHuawei Cloud Project - Dec 20230006468,116.89100%30 Days2/15/243/16/248353
10
City Savings BankHuawei Cloud Project - Jan 20240007921,210.02100%30 Days2/15/243/16/248353
11
Unionbank of the Philippines930 ULAP additional SBC sessions 10489,416,250.00100%30 Days4/15/245/15/24230
12
City Savings BankHuawei Cloud Project - Feb 20240008580,400.77100%30 Days4/18/245/18/24200
13
City Savings BankHuawei Cloud Project - March 202400092,736,888.81100%30 Days4/18/245/18/24200
14
Unionbank of the PhilippinesNew offsite ATMs10561,560,774.43100%30 Days5/2/246/1/2460
15
UnionDigital Bank Inc.
2024 Splunk Subscription Renewal105710,036,035.67100%30 Days5/2/246/1/2460
16
Alexis A. Molaer Law Offices Blancco Project105892,648.1650%30 Days5/6/246/5/2410
17
18
19
LEGEND
20
21
Current (Invoices NOT Over Due)
564,900.00paid amountClient NameProject
Invoice Amount
% Invoice
Cost of SalesMargin
Gross Margin
22
1-30 Days (Over Due)Before1,829,078.61
Dec to Jan
206806.36Sept Bill
23
>31Days (Over Due)New1,389,326.91
Dec to Jan
358,093.64diff
24
Difference439,751.70Oct Bill - Prev917533.78559,440.14Oct Bill NewQymera Inc.
Qymera - UD - Cloud Bill
2,884,964.47#REF!2,756,599.40128,365.0751,346.03
25
60.97%City Savings BankPAM - Delinea#REF!#REF!1,675,940.53#REF!#REF!
26
27
City Savings Bank
CSB Huawei Cloud Bill
#REF!#REF!1,555,550.15#REF!#REF!
28
Unionbank of the Philippines
VSAN Phase 2 - 1st Year
#REF!#REF!30,910,476.67#REF!#REF!
29
 Unionbank of the Philippines
240 ULAP additional sessions
#REF!#REF!2,034,766.00#REF!#REF!
30
#REF!#REF!38,933,332.75#REF!#REF!
31
32
33
Qymera - UD - Cloud Bill / PAM - Delinea / CSB Huawei Cloud Bill
34
Total Receivables
#REF!
35
Receivables Impacting Operations
#REF!
36
% of Impactful Receivables
#REF!
37
Business Burn Rate (per month)
3,500,000.00
38
Business Burn Rate (per day)
116,666.67
39
Gross Margin#REF!
40
% of Gross Margin less Business Burn Rate (per month) #REF!
41
Gross Margin less Business Burn Rate (per month) #REF!
42
43
VSAN Phase 2 - 1st Year / 240 ULAP additional sessions
44
Total Receivables
#REF!
45
Receivables Impacting Operations
#REF!
46
% of Impactful Receivables
#REF!
47
Business Burn Rate (per month)
3,500,000.00
48
Business Burn Rate (per day)
116,666.67
49
Gross Margin#REF!
50
% of Gross Margin less Business Burn Rate (per month) #REF!
51
Gross Margin less Business Burn Rate (per month) #REF!
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101