Skip to content
Ryan Duguid
Tools Questions Rates Evidence About
Shows the agent-readable text of this page.

Open source tools for Australian accountants

Check workpaper packs, explore cash shortfalls and inspect the calculations.

Explore the cash flow example

Built by Ryan Duguid, an accountant in Newcastle, NSW.

Last reviewed 4 November 2026.

Compare profit with cash flow

Lumbridge Services is a fictional Newcastle maintenance business. Delay one customer receipt by 45 days and inspect the cash gap in its Excel forecast. The quarter’s profit stays the same.

Excel chart of weekly closing cash after a 45-day receipt delay, showing the cash gap against the assumed bufferView full-size chart
13-week forecast with one receipt paid 45 days late. Weekly closing cash falls to ($25,160) against a $15,000 buffer, then recovers to $67,320 by December, the same as without the delay. Exported from the supplied workbook in Excel 16.0 on 4 November 2026. Capture record.

Choose a route

Check a pack or calculate

Each tool runs on a fictional example first and keeps its working visible.

  • Use accounting functions in Excel
  • Review a month-end close
  • Calculate a Coal LSL levy
  • Check a BAS pack before manager review
  • All tools by accounting task

Answer a tax or payroll question

Find the records, calculations and steps for a question, then check the current rate against its primary source.

  • 100 accounting questions
  • Maintained rate tables

Review my work

Read my background and credentials, then check the releases, source reviews and tests behind each tool.

  • About Ryan Duguid
  • Evidence behind the tools

Try each tool with fictional data first

Use the sample files to check what each tool accepts, refuses and explains before using it in a firm. Check its version and limits in the setup guide before you install it.

Browse reproducible evaluations Set up AI tools

Latest tool releases

  • Aus Accounting MCP v0.7.1 31 October 2026
  • Payday Super receipt evidence v0.2.3 30 October 2026
  • Subcontractor ledger skills for construction and mining v0.5.0 28 October 2026
Tools Rates Evaluations Evidence About Contact Privacy and site use

Ryan Duguid is not a registered tax or BAS agent. Nothing here is accounting, tax, legal or financial advice. Outputs are review aids for a qualified professional. This site is not affiliated with or endorsed by the ATO, Xero or Anthropic. Advice and review boundary

Changelog GitHub Related resources Machine-readable index Human-readable credits

Ex fide fiducia Ex fide fiducia, Latin for from faith comes confidence

Ryan Duguid, ABN 59 834 031 764

duguid.com.au/


      

Page text could not be loaded. Open full text or select Human to return.