Skip to main content

Why Open-Source Accounting Software Isn't Xero: The 4 Dividing Lines of Commercial Financial Systems

· 6 min read
Developer & Bookkeeping Learner

If you only look at the core double-entry tables — Accounts, Journals, and Journal_Lines — a commercial system like Xero or QuickBooks and a typical open-source project on GitHub look about 90% identical. The moat is not in the schema you can see; it is in the complexity below the waterline.

Australian Fuel Tax Credits: BAS Workpapers and Software Design

· 15 min read
Developer & Bookkeeping Learner

This note is a structured knowledge outline for understanding Australian Fuel Tax Credits from a BAS, workpaper, and software-design perspective.

It focuses on the legal definition, the evidence needed to support a claim, manual record-keeping standards, software integration options, and the broader market context. It is a summary and index, not tax advice.

Australia's Recent Tax Reform Package: A Practical Summary for Individuals, Businesses and Workpaper Automation

· 14 min read
Developer & Bookkeeping Learner

Australia's 2026-27 Federal Budget introduced a broad tax reform package aimed at shifting more tax relief toward workers and small businesses, while reducing some tax advantages connected to asset income, property investment, and trust structures.

The main measures include a new Working Australians Tax Offset, a $1,000 instant tax deduction, a permanent $20,000 instant asset write-off for small businesses, the return of loss carry back, changes to negative gearing, capital gains tax, discretionary trusts, R&D tax incentives, and venture capital incentives. These measures were announced in the Budget released on 12 May 2026, but many still require legislation before they become final law. [1]

GST claims depend on records — Australia vs New Zealand (tax invoices vs evidence)

· 4 min read
Developer & Bookkeeping Learner

When you design or review a GST process, the control you implement should match the legal evidence standard.

1 One-line conclusion:

In Australia, claiming GST credits usually hinges on holding a valid tax invoice (especially above the A$82.50 threshold).
while in New Zealand, claiming GST relies on keeping sufficient taxable supply information, which can be supported by a combination of records rather than a single “tax invoice” document. ([Australian Taxation Office][1])

NZ vs AU GST returns — forms, labels, and how Xero generates them

· 9 min read
Developer & Bookkeeping Learner

New Zealand and Australia both operate a GST system, but the practical experience of preparing and filing returns differs a lot once you get into the return form structure (NZ) vs BAS / Activity Statement labels (AU), and how accounting software (like Xero) maps transactions into those structures.

This post focuses on:

  1. Common GST principles (what’s the same in both countries)
  2. Differences in return forms + links to official documents
  3. Operational details in Xero: what Xero includes, where the rules come from, and what you can configure

The comceptual basis of accounting[draft]

· One min read
Developer & Bookkeeping Learner

The accounting process :

┌────────────────────┐
│ Source Documents │
│ (invoices, bills, │
│ receipts, bank stm│
└─────────┬──────────┘
│ record + validate

┌────────────────────┐
│ Journals │
│ (transactions with │
│ debit/credit lines│
└─────────┬──────────┘
│ post

┌────────────────────┐
│ Ledgers │
│ (GL + sub-ledgers, │
│ accounts updated) │
└─────────┬──────────┘
│ summarize balances

┌────────────────────┐
│ Trial Balance │
│ (list of account │
│ balances) │
└─────────┬──────────┘
│ year-end / period-end
│ adjustments

┌─────────────────────────────┐
│ Balance-day Adjustments │
│ (accruals, prepayments, │
│ depreciation, provisions, │
│ inventory/COGS, corrections│
│ tax adjustments, etc.) │
└─────────┬───────────────────┘
│ adjusted balances

┌─────────────────────┐
│ Financial Statements│
│ P&L, Balance Sheet, │
│ Cash Flow, Notes │
└─────────┬───────────┘
│ file + retain evidence

┌─────────────────────────────┐
│ Storage of Source Documents │
│ & Accounting Records │
│ (audit trail, compliance) │
└─────────┬───────────────────┘
│ use outputs for insight

┌────────────────────┐
│ Analysis │
│ (ratios, trends, │
│ variance, KPI) │
└─────────┬──────────┘
│ explain meaning

┌─────────────────────┐
│ Interpretation │
│ (what it implies, │
│ risks/opportunities)│
└─────────┬───────────┘
│ act

┌────────────────────┐
│ Decision Making │
│ (pricing, cost, │
│ investment, cash, │
│ strategy) │
└────────────────────┘

  • operating lines vs control/settlement lines, base source type, how to genarate control/settlement lines.
  • when use tracking categories , when use account code ?
  • understand '很多控制与对账都是在 ledger 级别做的'

understand stpes :

  • 过账到总账(post to ledger)
  • 查总账明细(ledger details)
  • 再出试算表(trial balance)

2 Accounting concepts relating to the timing of events

3 Elements and components of the statement of financial position

4 Elements and components of the Income Statement and Statement of cash flows

Double-entry bookkeeping

· One min read
Developer & Bookkeeping Learner

The Underlying Accounting Model (Conceptual Outline)

  1. Double-entry bookkeeping is the fundamental law Every transaction must be recorded with equal debits and credits. This rule is invariant and non-negotiable.
  2. Account classification defines the coordinate system Accounts are categorized into Assets, Liabilities, Equity, Revenue, and Expenses. This classification provides the structural framework for interpretation and reporting.
  3. Normal balance defines axis direction Each account type has a predefined normal balance (debit or credit), which determines how increases and decreases are represented.
  4. Account codes represent points in the system Each account code is a concrete instance within the classification framework, uniquely identifying where transactions are posted.
  5. Journals describe movement through the system Journal entries record how transactions move values between accounts, while always obeying the rules of the double-entry system.

Normal Balance :

Account TypeIncreases WithDecreases WithNormal Balance
AssetsDebitCreditDebit
ExpensesDebitCreditDebit
LiabilitiesCreditDebitCredit
EquityCreditDebitCredit
RevenueCreditDebitCredit

Xero Late Claims calculation logic and how to reproduce it using journals

· 2 min read
Developer & Bookkeeping Learner

1 Introduction

Late claims are transactions that you approve, edit, void, or delete in Xero after you have finalised the GST return for that period. That means there are two scenarios:

  1. After finalising the GST return, you discover you missed a transaction.
  2. After finalising the GST return, you discover an error and correct it.

Either scenario will result in a late claim.

2 How Xero Late Claims Work

Late Claims in Xero refer to expenses or income that are recorded in a period after the one in which they actually occurred. This often happens when receipts or invoices are submitted late, after the books for the original period have been closed.

Calculation Logic :

  1. Identify the Original Period:
    • Determine the period in which the expense or income should have been recorded.
  2. Identify the Actual Posting Period:
    • Note the period in which the transaction was actually entered into Xero.
  3. Calculate the Adjustment:
    • The difference between the original and actual periods is the basis for the late claim adjustment.
    • Xero typically posts an adjusting journal to move the expense/income to the correct period for reporting purposes.

3 How to Reproduce Using Journals

  1. Create a Manual Journal:
    • Debit or credit the relevant expense/income account in the original period.
    • Offset the entry with the appropriate account (e.g., accruals, payables, or receivables).
  2. Reverse the Journal in the Actual Period:
    • In the period when the late claim is actually posted, reverse the original journal to avoid double-counting.

5 Example

  • Scenario: An expense incurred in March is submitted and entered in April.
  • Step 1: In March, create a journal:
    • Debit: Expense Account
    • Credit: Accruals
  • Step 2: In April, when the actual expense is posted:
    • Debit: Accruals
    • Credit: Expense Account

6 Conclusion

By understanding and manually reproducing Xero's Late Claims logic, you can ensure accurate period reporting and compliance with accounting standards. This approach is especially helpful for audits and for organizations not using Xero but needing similar functionality.


Reference