The GST calculation formula is Tally GST 计算公式Tally

**Calculate GST by reverse-engineering the documents exported by the system, used for financial reconciliation.
根据系统导出的文档进行倒算GST，使用于财务对账**
## sketch map 示意图
![](/media/202601/2026-01-13_102210_1909380.2974926058000116.png)
## Operation process 操作流程
### 1.Filter the query conditions 筛选查询条件
Filter under 'Back - > Financial> Financial Reconciliation' to filter the 'Payment Time' 'Order Status' > Complete' criteria
在‘后台-->财务-->财务对账’进行筛选‘支付时间’‘订单状态-->完成’条件
![](/media/202511/2025-11-05_164820_9322630.6326085419720726.png)
### 2.Export order details 导出订单详情
Click Export to filter the order details of the data
点击导出，筛选数据的订单详情
![](/media/202511/2025-11-05_162214_4015190.5049637737002319.png)
## Countdown formula 倒算公式
### 1.The system charges/includes GST, but GST is not charged for consumption points deducted dishes 系统收取/包含GST但消费积分抵扣菜不收取GST
**GST = Actual income (G2+M2+O2-J2)/1.09 * 0.09
GST=实际收入(G2+M2+O2-J2)/1.09*0.09**
![](/media/202511/2025-11-06_182932_2618950.023016078018727626.jpeg)
### Note 注意
M2: Actual income (excluding refund amount)
G2: Use the value of the cash coupon (GST will be charged for the portion paid by the cash coupon)
J2: Gift Business Points (GST is not charged for the included Gift Business Points when paying with Business Points)
O2: Consumption points deduction (GST will be charged for part of the deduction at the final payment)

M2：实际收入（不含退款金额）
G2：使用现金券值（现金券支付的部分会收取gst）
J2：赠送商业积分值（使用商业积分支付时，包含的==赠送商业积分部分不收取gst==）
O2：消费积分抵扣钱（在最后支付时，抵扣部分金额，会收取gst）