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/202511/2025-11-10_135149_3913460.4609285832331206.png)
## Operation process 操作流程
### 1.Whether GST is charged for consumption points deductible goods 消费积分抵扣商品是否收取GST
Check whether the products deducted from consumption points are charged GST in the 'Background - > Plugin - > Menu Consumption Points Redemption'
在‘后台-->插件-->菜单消费积分兑换’查询消费积分抵扣的商品是否收取GST
![](/media/202511/2025-11-05_163917_2615180.6293733127318318.png)
### 2.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)
### 3.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 collects/includes GST and GST is charged for consumption points deducted from dishes 系统收取/包含GST且消费积分抵扣菜收取GST

**GST = actual income (F2 + G2 + M2 + O2-J2) / 1.09 * 0.09
GST=实际收入(F2+G2+M2+O2-J2)/1.09*0.09**
![](/media/202511/2025-11-06_182832_4414750.9438393997718382.jpeg)
### 2.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)
F2: Consumption points are deducted from the value of dishes (here you need to see whether the configuration of 'Background - > Plugin - > Menu Consumption Points Redemption' charges GST)
==GST is charged: actual income, which needs to be added to the value of consumption points to deduct the food
No GST: Actual income, no need to add this part of the value==
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：实际收入（不含退款金额）
F2：消费积分抵扣菜值 （这里需要看‘后台-->插件-->菜单消费积分兑换’的配置是否收取gst）
==收取gst：实际收入，需要加上消费积分抵扣菜的这部分值
不收取GST ：实际收入，不需要加上这部分值==
G2：使用现金券值（现金券支付的部分会收取gst）
J2：赠送商业积分值（使用商业积分支付时，包含的==赠送商业积分部分不收取gst==）
O2：消费积分抵扣钱（在最后支付时，抵扣部分金额，会收取gst）