Skip to content
View ryanduguid's full-sized avatar
8 followers · 26 following

Block or report ryanduguid

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. Markdown is supported. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
ryanduguid/README.md

Ryan Duguid

I'm an accountant in Newcastle, Australia. I build open-source tools for Australian tax, payroll and financial reporting.

DrDebits APES 110 aligned guardrails Open-source Australian accounting tools Ozzit: 134 native Excel LAMBDAs Python 3.10 or later Model Context Protocol

Selected work

  • xero-trial-balance-export exports reconciled Xero trial balances to CSV for Power BI, Excel and pandas.
  • Ozzit provides 134 native Excel LAMBDA functions for financial modelling and GST arithmetic.
  • accounting-excel-toolkit contains Power Query and VBA utilities for Australian ledger exports.
  • payday-super-checker checks super contribution timing and prepares exceptions for review.

See the full project catalogue and worked examples.

The projects use synthetic public examples and support professional review. They do not lodge or write to ledgers.

Background

  • Provisional member of Chartered Accountants ANZ
  • SAP S/4HANA certified in FI and CO
  • Xero specialist certification (Level 3)

The Aus Accounting MCP is published on PyPI. I have also contributed to the Meltano SDK and OpenAccountants.

Portfolio · Evidence and assurance · Email

Pinned Loading

  1. xero-trial-balance-export xero-trial-balance-export Public

    Export reconciled Xero trial balances to validated CSV for Power BI, Excel and pandas.

    Python

  2. payday-super-checker payday-super-checker Public

    Experimental tool for checking Payday Super timing and preparing exceptions for review.

    Python

  3. au-tax-mcp-server au-tax-mcp-server Public

    Local MCP server for ATO small-business benchmarks, Payday Super 2026 review, refused Division 7A, and synthetic SBR fixtures. Not advice.

    Python

  4. review-ready-gate review-ready-gate Public

    Stop incomplete workpapers reaching manager review. Deterministic readiness gate for Australian public-practice packs. Not advice.

    Python