# data-gb-supply-settlement

- Repo URL: http://192.168.1.4:3000/qianliyun/data-gb-supply-settlement
- Git SSH URL: ssh://git@192.168.1.4:2222/qianliyun/data-gb-supply-settlement.git
- Local path: /Users/bot1/AI Work/02_projects/active/data-gb-supply-settlement
- Machine/Profile: bot1/finance
- Owner/Requester: 朱潇潇
- Task type: finance-data/reconciliation
- Status: active
- Last updated: 2026-05-25T22:33:37+0800
- Latest commit: de3ac9807b921aec985cb72967c2bec11ed372a0
- Related bots/profiles: finance

## Purpose

持续整理“万物有灵”通过“元浪”向国博供货相关的线上/线下结算数据，按产品、渠道、结算月份/周期累计数量、单价、金额，便于后续每月追加和年底盘点。

## Current authoritative description

The repo root `REPO_DESCRIPTION.md` is the source of truth for detailed evolving state.

## Current deliverables

- 推荐简化报表：`deliverables/国博供货备货与销售简表_20260525.xlsx`
- 完整首版报表：`deliverables/国博供货结算总表_20260525.xlsx`
- 当前规范化主表：`work/settlement_master.csv`
- 简化表 CSV：`work/simple_product_summary.csv`
- 简化表汇总：备货合计 3950；销售数量合计 1134；销售金额合计 14891.72 元；线下销售 981 / 9825.60 元，线上销售 153 / 5066.12 元。

## Search keywords

国博 供货 结算 元浪 万物有灵 桃花洞釉 国宝器韵 国宝气韵 发卡 发圈 线上 线下 天猫 京东 馆内 发货单 调拨单 备货 销售结算 对账 总表 finance reconciliation