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

Mark Anthony Ayala

Finance Operations Officer · AudaCity Capital

15+ yrs FP&A · reporting · banking · audit

1

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

Refresh

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.

Ask a question
Revenue run rate · Adjusted
$1,320,000

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

Payout ratio · Obligation-adjusted
38.2%

Reported (cash released): 34.5% · prior month 41.0%

Adjusted trend: 42.1% → 40.3% → 38.2%

On track
Net income · Obligation-adjusted
$212,400

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.

actuals through Oct 7

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

Revenue target Run rate (projected) Running revenue
$300K$600K$900K$1200Kdata ends+$220,000 ahead$1,100,000target$1,320,000projectedOct 1Oct 8Oct 15Oct 22Oct 31

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.

Full experience
  1. Finance Operations Officer

    Current

    AudaCity 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.
  2. Head of Finance

    4 yrs 8 mos

    The 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.
  3. Lead Auditor

    15+ yrs · Seasonal

    SJSS 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.
  4. Accounting & Finance Senior Officer

    2 yrs 8 mos

    Ging 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.
  5. Accounting Supervisor

    2 yrs

    Vantaggio 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.
  6. Audit Associate

    4 yrs 6 mos

    Cooperative 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.

Google SheetsGoogle Apps ScriptBolt.new web appsAdvanced ExcelLooker StudioPower BIQuickBooksPayment rails: card · wire · PayPal · cryptoClaudeChatGPTGemini
Finance workspace

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 say

Need the system, not just the report?

Finance operations, FP&A, and audit — happy to talk about finance systems, cooperative audits, and advisory work. Remote.

Start a conversation