首页
学习
活动
专区
圈层
工具
发布
共 23 篇文章
1
用 pdfplumber 从 PDF 提取表格数据(附完整代码)
2
用 pandas 自动生成银行余额调节表(附完整代码)
3
用 pandas 做多维度数据透视分析(pivot_table 实战,附完整代码)
4
用 pandas 自动检测银行流水中的异常交易(附完整代码)
5
用 pandas 自动算科目余额的同比与环比变动(附完整代码)
6
用 Python 自动测算固定资产折旧(直线法实战,附完整代码)
7
用 pandas 快速筛查异常会计分录(附完整代码)
8
Python 偿债能力综合预警:负债率 + 流动比率 + 利息保障
9
Python 审计自动化工具箱 102 篇速查总目录(收官)
10
Python 审计报告附注自动生成(从审定数一键出注释)
11
Python 现金流断裂预警:自由现金流与短债覆盖
12
Python 审计底稿自动排版(页眉页脚页码冻结一键设)
13
Python 多 Excel 工作簿批量合并与汇总
14
Python 财务异常检测:统计离群点自动筛查
15
Python 毛利率同业对标分析(行业基准导入与偏离预警)
16
Python 截止性测试自动化(收入费用跨期抽凭)
17
Python 内控缺陷识别矩阵(控制活动评价指标化)
18
Python 银行流水聚类识别潜在关联方
19
Python 实体经营风险预警:营收与经营现金流背离
20
Python 审计项目工时与排期优化(负荷与甘特)
21
Python 审计风险预警 Dashboard:从底稿数据自动出风险热力表
22
Python 审计调整分录异常预警(频繁调整=盈余管理信号)
23
Python 关键审计事项(KAM)自动提取与预警

Python 关键审计事项(KAM)自动提取与预警

{"type":"doc","content":[{"type":"paragraph","attrs":{"id":"1f6344df-0e92-49e5-b048-41820e36e595","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"问题"},{"type":"hardBreak","attrs":{"id":"9a1aa599-b445-4a3c-96fa-26b0fae6fbb6"}},{"type":"text","text":"审计报告里的\"关键审计事项\"不是拍脑袋写的,它来自底稿里风险最高的几个领域。手工从几十张底稿里挑高风险科目效率低,用 Python 把风险分 >= 70 的科目自动抽出来排好序,就是 KAM 的初稿。"}]},{"type":"paragraph","attrs":{"id":"dd18b58f-e689-4b1c-be5e-77ae1b1d87a7","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"示例代码"}]},{"type":"paragraph","attrs":{"id":"43cb2ede-5565-4ffb-a974-c55af94c0d61","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","marks":[{"type":"textStyle","attrs":{"color":"","background":""}}],"text":"plaintext"}]},{"type":"codeBlock","attrs":{"id":"40fb6b2f-a9e3-4977-a4ff-3d6d0bb06889","language":"javascript","theme":"atom-one-dark","runtimes":0,"isHoverDragHandle":false,"key":"","languageByAi":"javascript"},"content":[{"type":"text","text":"def extract_kam(scores, thr=70):\n kam = [s for s in scores if s[\"score\"] >= thr]\n kam.sort(key=lambda x: x[\"score\"], reverse=True)\n return [(s[\"sheet\"], s[\"score\"]) for s in kam]\n\nscores = [\n {\"sheet\": \"收入\", \"score\": 82},\n {\"sheet\": \"存货\", \"score\": 65},\n {\"sheet\": \"应收\", \"score\": 74},\n {\"sheet\": \"货币资金\", \"score\": 20},\n]\nprint(extract_kam(scores))\n"}]},{"type":"paragraph","attrs":{"id":"b3371d4c-cbb1-4f8a-8e61-9076d66c3002","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"关键点"}]},{"type":"bulletList","attrs":{"id":"39db89f7-28ba-4451-9b9a-80031ec1b659","isHoverDragHandle":false},"content":[{"type":"listItem","attrs":{"id":"94eb801f-2a0b-41b4-ae16-1ac835cdc736"},"content":[{"type":"paragraph","attrs":{"id":"33a96659-fc2e-4a54-af34-a6c2305b532d","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"KAM 本质是\"高风险领域清单\",先由前面各篇的测算函数产出 0–100 风险分,再用阈值抽取。"}]}]},{"type":"listItem","attrs":{"id":"c07a0e51-8584-42b1-9080-373a394ecfa9"},"content":[{"type":"paragraph","attrs":{"id":"b6eb6ccb-1084-4d24-b3ae-ea8f30331386","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"阈值 70 是经验值:取前几名即可,太多就失去\"关键\"意义,一般 2–4 项。"}]}]},{"type":"listItem","attrs":{"id":"a374d5dd-7a19-4a27-9a4f-6b9676c23e59"},"content":[{"type":"paragraph","attrs":{"id":"37ae7624-79b1-491e-91aa-c88b8d2b3cc0","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"这是初稿不是终稿,抽出来后还要结合审计师的职业判断补\"为什么关键、怎么应对\"。"}]}]}]},{"type":"paragraph","attrs":{"id":"5e1b7aa5-ad0a-4ff6-97f4-0721c89e7052","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"小结"},{"type":"hardBreak","attrs":{"id":"c512ea0e-70b7-442c-9874-9d03c8069419"}},{"type":"text","text":"关键审计事项可以先用 Python 从风险分里自动抽取排序,把审计师从体力活里解放出来,把精力放在判断上。"}]},{"type":"horizontalRule","attrs":{"id":"0071c3ea-1814-459f-8396-5154d132f9c9","isHoverDragHandle":false}},{"type":"paragraph","attrs":{"id":"085677e8-840c-45bb-b5fe-0194e15e88fd","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"你做 KAM 时最头疼的是\"挑事项\"还是\"写描述\"?评论区聊。"}]},{"type":"paragraph","attrs":{"id":"07db3a51-77a1-41d1-ae4b-8b2da7b86e62","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"如果有用,点赞收藏关注,留下审计难题。下期预告:实体经营风险预警(营收与现金流背离)。"}]},{"type":"paragraph","attrs":{"id":"81737e18-498d-4cac-8d92-474f326e7474","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"会计师事务所的一名注册会计师"}]}]}

举报
领券