You will support daily reconciliations, client deposits/withdrawals accounting, AP/AR, and operational finance reporting. This role is Excel-heavy and requires strong command of lookup/matching logic (XLOOKUP/ VLOOKUP/ HLOOKUP/ INDEX-MATCH), PivotTables, and data accuracy across multiple sources (CRM, PSPs, bank statements, trading platform reports).
Operations Accounting
- Support accounting operations for client deposits and withdrawals: posting, tracking, exception handling, and daily reporting.
- Maintain and reconcile operational ledgers related to client money flows, payment channels, and internal transfers (as applicable to your structure).
- Monitor transaction statuses and ensure deposit/withdrawal data is consistent across Bank/PSP/CRM/Backoffice/Trading platform reports.
Daily Reconciliations
- Perform daily/weekly/monthly reconciliations across:
- Bank statements vs PSP/acquirer reports
- PSP settlements vs internal transaction logs
- CRM/backoffice balances vs finance trackers
- Fees, chargebacks, reversals, refunds (where applicable)
- Identify breaks, investigate root causes (timing, currency, fees, duplicate entries, FX, chargebacks), and escalate with clear evidence packs.
Advanced Excel Reporting & Controls
- Build robust reconciliation templates using advanced Excel including:
- Lookups & matching: XLOOKUP, VLOOKUP/HLOOKUP, INDEX-MATCH
- Logic & aggregation: IF/IFS, SUMIFS, COUNTIFS, error-handling and flags
- PivotTables for daily summaries (volumes, variances, settlement status, aging)
- Prepare daily dashboards and exception lists for Ops/Finance leadership (deposit/withdrawal KPIs, pending items, mismatch categories).
- Ensure reports are audit-ready: clear supporting files, consistent formatting, and traceable calculations.
AP/AR
- Support Accounts Payable: vendor invoices (technology providers, PSPs, liquidity/bridge vendors, marketing invoices if routed through finance), approvals, payment schedules.
- Support Accounts Receivable (where relevant): partner/IB invoices, rebates/commissions payable/receivable tracking, intercompany recharges.
- Track and reconcile provider fees (PSP MDR, chargeback fees, bank charges, FX spreads where visible) against agreements and settlements.
Must-Have
2+ years experience in accounting operations, ideally in brokerage, fintech, payments, or financial services.
Strong experience in reconciliations, specifically multi-source matching and variance resolution.
- Advanced Excel Skills:
- Lookup Functions: XLOOKUP, VLOOKUP/HLOOKUP, INDEX-MATCH
- Aggregation: SUMIFS/COUNTIFS
- Data controls: validation, conditional formatting, text functions, de-duplication
- PivotTables (create, refresh, grouping, calculated fields preferred)
High attention to detail, structured thinking, and ability to work under daily deadlines.
Power Query (importing and merging large reports from banks/PSPs/platforms)
Exposure to CRM/backoffice systems, payment gateways/PSPs, and trading platform reporting (MT4/MT5 or similar).
Understanding of chargebacks/refunds, settlement cycles, and multi-currency reconciliation.
