historical-trend-analysis

Compare original and translation side by side

🇺🇸

Original

English

🇨🇳

Translation

Chinese

Historical Trend Analysis Skill

历史趋势分析Skill

Analyses multi-year financial data to identify trends, detect anomalies, and flag year-over-year changes that may indicate audit risk, missed deductions, or tax planning opportunities. Uses Xero historical transaction data and analysis results across multiple financial years.

通过分析多年度财务数据，识别趋势、检测异常，并标记可能预示审计风险、遗漏抵扣项或税务规划机会的年度变化。使用Xero历史交易数据及多个财年的分析结果。

When to Use

适用场景

Comparing income/expense patterns across 3-5 financial years for trend detection
Identifying anomalous expense categories that deviate from historical norms
Detecting revenue growth/decline trends for loss carry-forward planning
Flagging sudden changes in expense ratios that may trigger ATO benchmarking
Supporting the Similar Business Test (SBT) with historical consistency evidence
Assessing amendment worthiness by comparing identified opportunities across FYs
Providing context for Division 7A compliance (loan balance trends)
Cash flow forecasting based on historical seasonal patterns

对比3-5个财年的收入/支出模式以检测趋势
识别偏离历史常规的异常支出类别
检测收入增长/下降趋势，用于亏损结转规划
标记可能触发ATO基准对比的支出比率突变
以历史一致性证据支持相似业务测试（SBT）
通过跨财年对比已识别机会，评估修订的可行性
为Division 7A合规性提供背景信息（贷款余额趋势）
基于历史季节性模式进行现金流预测

Analysis Methods

分析方法

1. Year-over-Year (YoY) Comparison

1. 年度同比（YoY）对比

Compare each financial year against the prior year:

Metric	Calculation	Significance
Revenue Growth	(Current - Prior) / Prior × 100	Loss utilisation, GST threshold
Expense Ratio	Total Expenses / Total Revenue	ATO benchmark comparison
Category Shift	Category % of Total (current vs prior)	Misclassification detection
Net Profit Margin	Net Profit / Revenue × 100	Loss carry-forward trigger

对比每个财年与上一财年的数据：

指标	计算方式	重要性
收入增长率	(当期-上期)/上期 × 100	亏损利用、GST阈值
支出比率	总支出/总收入	ATO基准对比
类别占比变动	当期与上期的类别占总金额比例	错误分类检测
净利润率	净利润/收入 × 100	亏损结转触发条件

2. Moving Average

2. 移动平均值

3-year rolling average smooths one-off anomalies:

Use Case	Window	Alert If
Revenue trend	3 years	Current deviates > 20% from average
Expense category	3 years	Category deviates > 30% from average
Deduction claims	3 years	Claims drop > 50% (may indicate missed deductions)
Contractor payments	3 years	Sudden increase > 40% (contractor deeming risk)

3年滚动平均值可消除一次性异常：

适用场景	时间窗口	预警条件
收入趋势	3年	当期值与平均值偏差超过20%
支出类别	3年	类别值与平均值偏差超过30%
抵扣申报	3年	申报额下降超过50%（可能表明存在遗漏抵扣项）
承包商付款	3年	金额突然增长超过40%（承包商认定风险）

3. Anomaly Detection

3. 异常检测

Flag values that fall outside expected bounds:

Method	Description	Application
Z-score	Standard deviations from mean	Expense category outliers
IQR (Interquartile Range)	Values beyond Q1-1.5×IQR or Q3+1.5×IQR	Revenue spikes/dips
Percentage change threshold	YoY change exceeding configurable threshold	ATO audit risk triggers

标记超出预期范围的数值：

方法	说明	应用场景
Z-score	与平均值的标准差	支出类别异常值
IQR（四分位距）	超出Q1-1.5×IQR或Q3+1.5×IQR的值	收入峰值/谷值
百分比变动阈值	年度同比变动超过可配置阈值	ATO审计风险触发项

4. Seasonal Pattern Analysis

4. 季节性模式分析

Identify recurring seasonal patterns in cash flow:

Pattern	Detection	Use
Quarterly spikes	BAS periods showing consistent revenue peaks	Cash flow forecasting
Year-end clustering	Expenses concentrated in June	Prepayment detection (s 82KZM)
Holiday dips	Consistent revenue drops (Dec/Jan)	Working capital planning

识别现金流中重复出现的季节性模式：

模式	检测方式	用途
季度峰值	BAS申报期出现持续收入高峰	现金流预测
年末集中支出	支出集中在6月份	预付款项检测（第82KZM条）
假期低谷	收入在12月/1月持续下降	营运资金规划

Data Sources

数据源

Source	API Endpoint	Fields
Historical Transactions	`/api/audit/cached-transactions`	Amount, date, category, account
P&L Reports	`/api/xero/reports?reportType=ProfitAndLoss`	Income, expenses by category
Year Comparison	`/api/audit/year-comparison`	Pre-computed YoY metrics
Analysis Results	`/api/audit/analysis-results`	AI-classified findings per FY
Trends	`/api/audit/trends`	Pre-computed trend data

来源	API端点	字段
历史交易数据	`/api/audit/cached-transactions`	金额、日期、类别、账户
损益表报告	`/api/xero/reports?reportType=ProfitAndLoss`	收入、分类别支出
年度对比数据	`/api/audit/year-comparison`	预计算的同比指标
分析结果	`/api/audit/analysis-results`	按财年分类的AI识别发现
趋势数据	`/api/audit/trends`	预计算的趋势数据

Trend Classification

趋势分类

Trend	Criteria	Tax Implication
Stable Growth	Revenue growing 5-15% YoY consistently	Healthy; normal deduction patterns
Rapid Growth	Revenue growing > 30% YoY	May breach SG maximum contribution base; payroll tax threshold risk
Decline	Revenue falling > 10% YoY	Loss carry-forward planning; consider COT/SBT
Volatile	Revenue swinging > 25% YoY alternating	Cash flow risk; consider PAYG instalment variation
Flat	Revenue within ±5% YoY	Stable; check for inflation erosion of real deductions
Seasonal	Consistent intra-year pattern	Align BAS reporting with cash flow

趋势类型	判定标准	税务影响
稳定增长	收入持续每年增长5-15%	健康状态；常规抵扣模式
快速增长	收入年增长率超过30%	可能超出SG最高缴费基数；存在工资税阈值风险
下降	收入年降幅超过10%	需进行亏损结转规划；考虑COT/SBT
波动	收入年波动幅度超过25%且交替变化	现金流风险；考虑PAYG分期付款调整
平稳	收入年变动在±5%以内	稳定；需检查实际抵扣额是否受通胀侵蚀
季节性	年内存在持续一致的模式	使BAS申报与现金流匹配

Output Format

输出格式

xml

<trend_analysis>
  <entity_id>org_456</entity_id>
  <analysis_period>FY2020-21 to FY2024-25</analysis_period>

  <revenue_trend>
    <classification>stable_growth</classification>
    <average_yoy_growth>8.3</average_yoy_growth>
    <years>
      <year fy="FY2020-21" revenue="850000" />
      <year fy="FY2021-22" revenue="920000" yoy_change="8.2" />
      <year fy="FY2022-23" revenue="1010000" yoy_change="9.8" />
      <year fy="FY2023-24" revenue="1080000" yoy_change="6.9" />
      <year fy="FY2024-25" revenue="1170000" yoy_change="8.3" />
    </years>
  </revenue_trend>

  <anomalies>
    <anomaly>
      <category>Motor Vehicle Expenses</category>
      <financial_year>FY2023-24</financial_year>
      <value>45000</value>
      <three_year_average>28000</three_year_average>
      <deviation_percentage>60.7</deviation_percentage>
      <z_score>2.4</z_score>
      <risk>ATO benchmark deviation — motor vehicle expenses unusually high</risk>
      <recommendation>Verify classification; may include personal use component</recommendation>
    </anomaly>
  </anomalies>

  <sbt_evidence>
    <expense_consistency_score>78</expense_consistency_score>
    <top_categories_stable>true</top_categories_stable>
    <business_type_consistent>true</business_type_consistent>
    <sbt_assessment>likely_satisfied</sbt_assessment>
  </sbt_evidence>
</trend_analysis>

xml

<trend_analysis>
  <entity_id>org_456</entity_id>
  <analysis_period>FY2020-21 to FY2024-25</analysis_period>

  <revenue_trend>
    <classification>stable_growth</classification>
    <average_yoy_growth>8.3</average_yoy_growth>
    <years>
      <year fy="FY2020-21" revenue="850000" />
      <year fy="FY2021-22" revenue="920000" yoy_change="8.2" />
      <year fy="FY2022-23" revenue="1010000" yoy_change="9.8" />
      <year fy="FY2023-24" revenue="1080000" yoy_change="6.9" />
      <year fy="FY2024-25" revenue="1170000" yoy_change="8.3" />
    </years>
  </revenue_trend>

  <anomalies>
    <anomaly>
      <category>Motor Vehicle Expenses</category>
      <financial_year>FY2023-24</financial_year>
      <value>45000</value>
      <three_year_average>28000</three_year_average>
      <deviation_percentage>60.7</deviation_percentage>
      <z_score>2.4</z_score>
      <risk>ATO benchmark deviation — motor vehicle expenses unusually high</risk>
      <recommendation>Verify classification; may include personal use component</recommendation>
    </anomaly>
  </anomalies>

  <sbt_evidence>
    <expense_consistency_score>78</expense_consistency_score>
    <top_categories_stable>true</top_categories_stable>
    <business_type_consistent>true</business_type_consistent>
    <sbt_assessment>likely_satisfied</sbt_assessment>
  </sbt_evidence>
</trend_analysis>

Best Practices

最佳实践

Minimum 3 years of data required for meaningful trend analysis
Adjust for inflation when comparing dollar amounts across years (use CPI)
Exclude one-off items from trend calculations (e.g., asset sales, insurance payouts)
Normalise for business changes — merger/acquisition/restructure events invalidate YoY comparison
ATO benchmarks are descriptive — deviations are informational, not normative (AD-6)
Use Xero account codes for consistent category mapping across years
Financial year convention: Always use FY format (e.g., FY2024-25), never calendar year

至少3年的数据才能进行有意义的趋势分析
跨年度比较金额时需调整通胀因素（使用CPI）
趋势计算中排除一次性项目（如资产出售、保险赔付）
针对业务变化进行标准化——合并/收购/重组事件会使年度同比对比失效
ATO基准仅作参考——偏离仅为信息提示，非强制性要求（AD-6）
使用Xero账户代码以确保跨年度类别映射的一致性
财年约定：始终使用FY格式（如FY2024-25），切勿使用日历年