Accounting & Bookkeeping Portfolio / 2025 - 2026

NEO
GERONA

CA ANZ Provisional Member. Aspiring Chartered Accountant. Building clean, reliable books from the ground up.

Specialisation Bookkeeping & Finance
Location Perth, Western Australia
Tools Xero | MYOB | Excel | Tableau
Availability Monday to Friday
Hi, I'm Neo.
Neo Gerona

I help small businesses and accounting firms achieve accurate, full-cycle books and financially informed reporting, delivered by someone who understands the numbers behind the numbers. As a CA ANZ Provisional Member currently enrolled in Australian Tax and Business Law, I am on a mission to bring a finance-trained perspective into bookkeeping support, so that the teams I work with get more than data entry and closer to a junior finance partner who catches the details before they become problems.

I am a Bachelor of Business graduate from the University of Waikato Management School. My finance and supply chain specialisations are where I pull ahead. I come in with cross-functional awareness which better positions how I analyse and interpret a set of books and how I report back to a supervisor, with the confidence, confidentiality, honesty, and attention to detail a finance team needs to do the job effectively.

Beyond the technical accounting work, I have self-taught myself McKinsey consulting frameworks (the Pyramid Principle, Situation-Complication-Resolution, and MECE structuring) so I can break down complex financial topics and deliver them in plain language to non-finance stakeholders. Whether it is presenting variance analysis to a committee or translating BAS positions for a small business owner, the goal is the same: lead with the answer, support it cleanly, and respect the reader's time.

Outside of work I'm into personal investing and keeping up with capital markets. When I'm not staring at charts I'm usually camping or fishing on the weekends.

Degree
Bachelor of Business (Finance)
University
Waikato Management School
Location
Perth, WA
Work Rights
Full unrestricted (NZ citizen, SCV 444)
Membership
CA ANZ Provisional Member
Currently Studying
Tax and Business Law (AU)
Capabilities I Bring from Day 1

Accounting & Bookkeeping

  • Accounts Payable / Receivable
  • Bank Reconciliation
  • Payroll Processing
  • BAS / GST Preparation
  • Month-End Close

Financial Analysis

  • Financial Statement Analysis
  • Budgeting & Forecasting
  • Variance Analysis
  • Ratio Analysis
  • Cash Flow Analysis

Administration

  • Data Entry & Validation
  • Invoice Processing
  • Filing & Record Keeping
  • Client Communication

Technical Tools

  • Advanced Excel
  • Financial Modelling
  • Power BI & Tableau
  • Microsoft Office Suite
Tools of the Trade
Xero
Accounting Software
Certified Professional L2 + Payroll + Migration
MYOB
Accounting Software
Business Certified
Microsoft Excel
Spreadsheet / Modelling
Advanced
Microsoft Office
Productivity Suite
Advanced
Tableau
Data Visualisation
Developing
Power BI
Data Visualisation
Developing
Canva
Graphics Design
Advanced
QuickBooks
Accounting Software
Awareness
Salesforce
Enterprise Resource Planner
Awareness
Professional Credentials
CA ANZ Provisional Membership
Chartered Accountants Australia and New Zealand | Apr 2026
Member ID: 3238716. Approved subjects: Ethics and Sustainability, Risk Technology and AI. Currently enrolled in Tax and Business Law (AU).
Xero Certified Professional (Level 2)
Xero Central | Apr 2026
Manual entry, cash coding, bank feed reconciliation, AR/AP workflows.
Xero Payroll Specialist
Xero Central | Apr 2026
Pay runs, leave, superannuation, payroll reconciliation.
Xero Migration Specialist
Xero Central | Apr 2026
Conversion Toolbox, COA mapping, post-conversion validation.
MYOB Business Certification
MYOB | Apr 2026
Full six-module pathway: AR, AP, bank reconciliation, reporting.
Advanced BAS and GST Course
Udemy / Xero Australia | Apr 2026
BAS preparation, GST classification, period reconciliation.
Accounting Foundations Professional Certificate
LinkedIn Learning / Xero | Apr 2026
Corporate finance, managerial finance, management accounting.
Xero Certified Specialist (Level 3)
Xero Central | May 2026
Fixed assets, tracked inventory, multi-currency, projects, expenses, advanced reporting, budgets and variance analysis.
Intuit Academy Professional Bookkeeper Certificate
Coursera / Intuit | May 2026
Full bookkeeping pathway: double-entry, accounting cycle, asset lifecycle, COGS under FIFO/LIFO/average cost, inventory, depreciation, reconciliation, and financial statement preparation.
Excel Demo Company Pty Ltd
Full-cycle accounting demonstration built from scratch in Microsoft Excel. FY2026 H1 reporting period, AASB and ATO compliant. Each stage uses Excel formulas and features to make data entry dynamic, validated, and traceable.
Chart of Accounts - General Ledger
1 / 15
Chart of Accounts (General Ledger)
Master COA mapping each account to its classification, normal balance, and financial statement destination. Serves as the single source of truth for all downstream journals and reporting.
Best practice: Accounts grouped by type (Assets, Liabilities, Equity, Revenue, Expenses) with consistent numbering convention. Excel: Data Validation dropdowns sourced from this table prevent freeform account entry across all journals.
Chart of Accounts - Subsidiary Ledger
2 / 15
Chart of Accounts (Subsidiary Ledger)
Subsidiary COA for individual debtor and creditor accounts that feed into the control accounts on the general ledger. Maintains granular visibility without cluttering the main COA.
Best practice: Subsidiary accounts reconcile to AR/AP control totals at period end. Excel: SUMIF validates subsidiary balances against control account totals for reconciliation checks.
General Journal
3 / 15
General Journal
Primary book of original entry recording all non-specialised transactions in chronological order with full double-entry structure. Every entry includes a narration for audit trail purposes.
Best practice: Each journal entry balances (debits equal credits) and references a source document. Excel: Data Validation dropdowns restrict account selection to COA entries, IF formulas flag imbalanced entries, and structured Tables enable auto-expansion as entries grow.
Cash Payments Journal
4 / 15
Cash Payments Journal
Specialised journal recording all cash outflows including supplier payments, expense reimbursements, and GST-inclusive disbursements. Separates high-volume cash transactions from the general journal to reduce posting congestion.
Best practice: GST component automatically split from gross amount for accurate input credit tracking. Excel: Formulas calculate GST at 1/11th of gross, SUMIF aggregates totals by account for period-end posting to the general ledger.
Sales and Purchases Journal
5 / 15
Sales and Purchases Journals
Specialised journals capturing all credit sales and credit purchases separately from cash transactions. Each entry records customer or supplier, invoice reference, GST treatment, and payment terms for aged receivable and payable tracking.
Best practice: Credit transactions separated from cash to support accurate AR/AP aging. Excel: VLOOKUP pulls customer and supplier details from the subsidiary ledger, GST auto-calculated, and conditional formatting highlights overdue invoices based on terms.
General Ledger
6 / 15
General Ledger
Account-level transaction history assembled from all journals using PivotTables. Each account displays debits, credits, and running balance with slicer-based filtering for instant drill-down by account.
Best practice: Ledger balances reconcile to journal totals before trial balance extraction. Excel: PivotTable with Slicer filter for dynamic account selection, calculated field for running balance, automatic refresh when journal source data updates.
10-Column Worksheet
7 / 15
10-Column Worksheet
Combined worksheet displaying the unadjusted trial balance, adjustments, adjusted trial balance, income statement, and balance sheet columns side by side. Provides a complete audit trail from raw balances through to financial statement allocation in a single view.
Best practice: All five paired columns must independently balance (debits equal credits) before financial statements are prepared. Excel: SUMIF pulls ledger balances, adjustment columns reference journal entries, and IF formulas route each account to the correct financial statement column based on account classification.
10-Column Worksheet Hidden Rows
8 / 15
10-Column Worksheet (Formula View)
Behind-the-scenes view of the 10-column worksheet with hidden rows expanded, showing the formula logic that drives dynamic account classification and balance routing.
Best practice: Transparent formula structure allows any reviewer to trace calculations without relying on the preparer's explanation. Excel: Nested IF and SUMIF formulas automate account routing, IFERROR handles blank accounts gracefully, and balance check rows validate each column pair.
Income Statement
9 / 15
Income Statement
Revenue through net profit for H1 FY2026 with gross margin and operating margin analysis. Sourced directly from the income statement columns of the 10-column worksheet.
Best practice: Revenue recognition aligned with AASB 15, expenses matched to the period they relate to under the accrual basis. Excel: SUMIF against the adjusted trial balance by account classification, percentage formulas calculate margins at each profit level.
Balance Sheet
10 / 15
Balance Sheet
Assets equal Liabilities plus Equity as at 30 June 2026. Current and non-current classifications applied, fixed assets shown net of accumulated depreciation, with a built-in balance check.
Best practice: Classified presentation per AASB 101, current/non-current distinction based on 12-month operating cycle. Excel: SUMIF lookups by classification, balance check formula returns BALANCED or ERROR, conditional formatting highlights discrepancies in green or red.
Cash Flow Statement
11 / 15
Cash Flow Statement
Indirect method reconciling operating profit to actual cash movement for H1 FY2026. Includes a reference guide explaining the logic behind working capital adjustments and how asset, liability, and equity movements translate to cash inflows and outflows.
Best practice: Depreciation added back as non-cash expense, working capital changes reflect balance sheet movements per AASB 107. Excel: Cell references link to balance sheet and income statement, working capital change formulas compare opening to closing balances.
Simple BAS
12 / 15
Simple BAS Lodgement Worksheet
GST worksheet calculating Label 1A (GST on sales) and Label 1B (GST on purchases) directly from the adjusted trial balance. Net GST position determines whether the business owes the ATO or receives a refund.
Best practice: BAS figures reconcile to the GST accounts on the adjusted trial balance, not raw journals. Excel: Basic arithmetic (total sales divided by 11 for GST collected, total purchases divided by 11 for GST paid), subtraction for net position. No complex formulas needed.
Quarterly Comparison
13 / 15
Quarterly P&L Comparison
Q1 versus Q2 income statement with H1 YTD totals and explanatory notes for material variances. Enables management to identify revenue decline, margin compression, or cost blowouts at a glance.
Best practice: Variance notes explain the business reason behind each material movement, not just the number. Excel: Period filtering via SUMIFS with quarter criteria, variance formulas calculate both dollar and percentage change, notes column maintained manually for context.
Dashboard Financial Statements
14 / 15
Quarterly Dashboard (Financial Statements)
Interactive dashboard with a dropdown quarter selector that dynamically refreshes the income statement and balance sheet summary. Colour-coded variance indicators let a business owner assess period performance in under 60 seconds without opening the ledger.
Best practice: Dashboard consolidates key financial metrics into a single view for non-accounting stakeholders. Excel: Data Validation dropdown drives SUMPRODUCT and SUMIFS lookups across the source data, IFERROR handles missing periods, conditional formatting applies green (favourable) and red (unfavourable) to variances automatically.
Dashboard KPIs
15 / 15
Quarterly Dashboard (KPIs)
Working capital tracking with AR, AP, and inventory movement analysis alongside cash flow summary and current ratio calculation. Surfaces liquidity risks before they become cash flow problems.
Best practice: Current ratio monitored per period to flag deteriorating liquidity early. Excel: SUMPRODUCT and SUMIFS pull opening and closing balances dynamically, percentage change formulas quantify period-over-period movement, conditional formatting highlights ratios below acceptable thresholds.
Goals Roadmap

The goal has always been straightforward: build the technical foundation first, then earn the credential that makes it official. Right now that means getting into a bookkeeping or graduate accounting role, completing a Cert IV traineeship on the job, and working through CA Foundations alongside real-world practice. Chartered Accountant is the destination. Everything between here and there is the proof.

In Progress

Industry Breakthrough

Now
  • Secure bookkeeping or graduate accounting position in Perth
  • Apply Xero, MYOB, and Finance degree immediately
  • Build practical AP/AR, reconciliation, and payroll experience
  • Establish professional references and track record
01
Enrolling

On-Job Learning

Year 1 - 2
  • Complete Cert IV in Accounting and Bookkeeping
  • Structured as a traineeship alongside daytime employment
  • Formalise practical skills with nationally recognised qualification
  • South Metropolitan TAFE
02
Planned

Mentored Professional Experience

Year 3 - 4
  • Study CA Foundations alongside full-time work
  • Financial accounting, management accounting, and taxes
  • Target completion within three years
  • Build associate relationship with a trusted mentor
03
Goal

Chartered Accountant

Year 4+
  • Enter CA ANZ Program with three years supervised experience
  • Complete CA Program modules and mentored practical experience
  • Qualify as a Chartered Accountant (CA)
  • Long-term: advisory, financial analysis, or public practice
04
Get in Touch
Open to entry-level accounting, bookkeeping, and clerical roles across Greater Perth, as well as volunteer finance roles such as not-for-profit Treasurer or committee positions.
Phone
+61 0410 017 687
Website
Location
Gosnells, Perth WA
Salary Expectations
$30k - $50k