The finance system a CEO opens every morning.
Payouts, pacing, P&L — raw payment exports in, decisions out. This is a working replica of what I built: same layout, same logic, illustrative figures. Let the tour run, or click any tab.

Mark Anthony Ayala
Finance Operations Officer · AudaCity Capital
15+ yrs FP&A · reporting · banking · audit
Three numbers, two versions each.
Reported shows the cash that moved. Adjusted counts payouts earned but not yet released — so the margin is never flattered by timing.
Overview
Ask me about these numbers
Answers come from the figures on this tab. Claude explains them — it does not recalculate them, so an answer here cannot disagree with the charts below.
Weekday/weekend split | ▲ +9.6% vs last 3M
Flat daily-average run rate $1,262,000
Daily avg: $42,600 | MTD: $298,000 | 7 of 31 days
Reported (cash released): 34.5% · prior month 41.0%
Adjusted trend: 42.1% → 40.3% → 38.2%
Reported $236,800 · payout queue +$24,400 (MTD)
Gross profit: $298,600 | Opex: $86,200
Net margin: 24.6% | Prior month: $186,900
Month pacing — October 2026
Where revenue is, where the plan says it should be, and where the month lands if the days still to come look like the days already reported.
Gap at month end
+$220,000
20.0% ahead of plan
Target
$1,100,000
plan total for the month
Waiting on data
1
day already traded, not yet reported
Illustrative figures — layout of the system I built, not company data.
What it does
Six things the system answers before anyone asks.
A fully remote proprietary trading firm, money moving daily across card, bank-wire, PayPal, and crypto rails — and no regular monitoring when I arrived. I built the pipeline from the raw payment exports up: Google Sheets and Apps Script underneath, a custom web app on top.
Money flow, daily
What came in, what went out, and what is still owed — every morning, from the raw payment data up. Before this, nothing was monitored on a regular cadence.
Month pacing against target
Where revenue is, where the plan says it should be, and where the month lands if the days to come look like the days already reported — with the gap in one number.
Obligation-adjusted P&L
Payouts earned but not yet released are counted before the cash leaves, so payout ratio and net income are never overstated by timing.
Weekly digest, automated
A short email leadership actually reads: each section is one line and one bar against a target tick. Generated and sent from the sheets, untouched by hand.
Pricing, discounts & giveaways
List price vs. collected, cost per new customer by code, and 'free' tracked like a payout — so the real price and the real cost are both visible.
Ask the dashboard
A question box on every tab. Leadership asks in plain English; answers come from the live figures on that tab and never recalculate them.
Company figures stay inside the company — this page describes the system, not the numbers.
What I bring
Six ways I move the numbers — and the business.
Finance systems & automation
Raw payment exports in, decision-ready dashboards out. Google Sheets, Apps Script, and a custom web app — built so the numbers refresh themselves.
Payment operations
Payouts, payables, and settlements across card, bank-wire, PayPal, and crypto rails — reconciled to the cent, every month.
Decision-ready reporting
KPI dashboards and management reports leadership can actually act on — not just look at.
Forecasting & pacing
Run rates, month pacing against target, and variance analysis that connect what happened to where the month lands.
Audit-grade discipline
15 years of audit experience baked into every process — internal controls, compliance, and risk awareness by default.
Cross-functional partner
Marketing, ops, leadership — I deliver the numbers people need before they have to chase them down.
Experience
15 years, six companies, one through-line.
From branch-level bank audits to running finance operations for a fully remote proprietary trading firm.
Finance Operations Officer
CurrentAudaCity Capital
Jun 2026 — Present · Fully remote · Proprietary trading firm
- Run daily finance operations — trader payouts, vendor payables, and settlements across card, bank-wire, PayPal, and crypto platforms.
- Built the firm's finance dashboard from scratch: Google Sheets + Apps Script pipelines feeding a custom web app the CEO and Finance Lead open every day.
- Automated the reporting cadence — daily cash-flow update, weekly digest, and month-end close — from one source of truth.
- Reconcile revenue across payment platforms monthly, with every transaction converted and audited in USD.
Head of Finance
4 yrs 8 mosThe Thirty Minute Trader
Oct 2021 — May 2026 · Quezon City · Hybrid
- Led finance reporting and monitoring — sales, collections, expenses, and overall performance.
- Managed reporting for multi-million peso monthly sales, affiliate sales, and operating expenses.
- Built and enhanced KPI dashboards, trackers, and finance monitoring tools used by leadership.
- Drove budget monitoring, forecast reviews, and variance analysis of actuals vs. targets.
Lead Auditor
15+ yrs · SeasonalSJSS Bookkeeping and Accounting Services
Apr 2011 — Present · Quezon · Hybrid
- Audit reviews of financial records, transactions, and supporting schedules across business and cooperative clients.
- Prepared audit working papers, financial reports, and schedules for client review and compliance.
- Led exit conferences with operations teams and Boards of Directors to translate findings into corrective actions.
Accounting & Finance Senior Officer
2 yrs 8 mosGing and Dot Fashion Inc. (FILA Apparel)
Feb 2018 — Sep 2020 · BGC · On-site
- Owned monthly reporting, reconciliations, and financial monitoring across branches.
- Tracked sales-to-stock ratios and analyzed item performance to support merchandising decisions.
- Oversaw inventory allocation and replenishment planning across branch network.
Accounting Supervisor
2 yrsVantaggio Inc (FILA)
Mar 2016 — Feb 2018 · Makati · On-site
- Supervised daily accounting operations and timely monthly financial reporting.
- Managed post-dated checks (PDCs) and supplier payment schedules with strong control discipline.
- Reviewed reconciliations and supporting schedules to maintain report accuracy and consistency.
Audit Associate
4 yrs 6 mosCooperative Bank of Quezon Province
Oct 2011 — Mar 2016 · Lucena · On-site
- Conducted independent branch audits across financial records and operations.
- Evaluated branch processes against internal policies and BSP regulations.
- Submitted structured audit reports to the Audit Head for Board-level reporting.
Toolbox
The stack behind the insight.
The everyday finance stack, plus the tools to automate it — and constantly adding to both.

How I work
I map the system. Then I fix what matters.
My first instinct when facing any problem isn't to open a spreadsheet — it's to understand how the system works. Where the data comes from, where it breaks down, and exactly what needs to change. Audit taught me discipline. FP&A taught me clarity. Finance operations taught me to build the system itself. And 15 years across all three taught me how to connect dots that other departments can't see — quietly, precisely, and always before someone has to ask.
Read what colleagues sayNeed the system, not just the report?
Finance operations, FP&A, and audit — happy to talk about finance systems, cooperative audits, and advisory work. Remote.