首页
学习
活动
专区
圈层
工具
发布
共 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 审计调整分录异常预警(频繁调整=盈余管理信号)

{"type":"doc","content":[{"type":"paragraph","attrs":{"id":"f08f01b3-033e-41c1-9340-5ed943dbdbb1","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"问题"},{"type":"hardBreak","attrs":{"id":"6ac38eb7-a9f4-48bd-aa2e-a89561180c34"}},{"type":"text","text":"调整分录是审计的\"心电图\"。有些公司期末突击调账、用重分类掩盖错报。手工翻分录难发现模式,用 Python 自动标出三类异常信号。"}]},{"type":"paragraph","attrs":{"id":"522e96f7-4bcf-46d2-b651-6ffee3a83cb0","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"示例代码"}]},{"type":"paragraph","attrs":{"id":"45c8547b-8f29-4b4d-aaec-bc60e477182a","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":"09fcd1bc-aca3-4054-b2e5-84b4be4464d8","language":"javascript","theme":"atom-one-dark","runtimes":0,"isHoverDragHandle":false,"key":"","languageByAi":"javascript"},"content":[{"type":"text","text":"from datetime import date\nimport pandas as pd\n\ndef flag_adjustments(entries, year_end, freq_thr=10, window_days=30, ye_ratio=0.6, reclass_ratio=0.5):\n n = len(entries)\n start = year_end - pd.Timedelta(days=window_days)\n ye = [e for e in entries if start < e[\"date\"] <= year_end]\n reclass = [e for e in entries if e.get(\"type\") == \"reclass\"]\n alerts = []\n if n >= freq_thr:\n alerts.append((\"高频调整\", n))\n if n and len(ye) / n >= ye_ratio:\n alerts.append((\"期末集中调整\", len(ye)))\n if n and len(reclass) / n >= reclass_ratio:\n alerts.append((\"重分类占比高\", len(reclass)))\n return alerts\n\nentries = [\n {\"date\": date(2025,12,20), \"type\": \"accrual\"},\n {\"date\": date(2025,12,28), \"type\": \"reclass\"},\n {\"date\": date(2026,1,3), \"type\": \"reclass\"},\n]\nprint(flag_adjustments(entries, date(2025,12,31)))\n"}]},{"type":"paragraph","attrs":{"id":"ebb2d474-7a35-4937-bbf4-75dc0dca2b66","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"关键点"}]},{"type":"bulletList","attrs":{"id":"2d218080-0734-4fe7-828f-2861fe3e3234","isHoverDragHandle":false},"content":[{"type":"listItem","attrs":{"id":"938c7f63-d080-4597-b2bc-153771693821"},"content":[{"type":"paragraph","attrs":{"id":"44de762a-9bf2-4a2d-b029-9586a8114f14","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"三类信号:调整笔数异常多、调整集中在期末 30 天、重分类占比超 50%。"}]}]},{"type":"listItem","attrs":{"id":"36ed8d3d-5efa-49d6-b0b0-57c18614745f"},"content":[{"type":"paragraph","attrs":{"id":"1bcffa9c-d10f-48bc-b3bf-8c7d8b9e93fd","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"重分类本身中性,但\"用重分类掩盖错报\"是经典手法,占比高要追实质。"}]}]},{"type":"listItem","attrs":{"id":"14fb2f86-74ae-4cb9-8f27-6e98cdc16efe"},"content":[{"type":"paragraph","attrs":{"id":"e004d8c3-4884-4a87-8c5f-05e4272c0f91","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"这些是红旗不是结论,标出后看具体分录实质,别直接判舞弊。"}]}]}]},{"type":"paragraph","attrs":{"id":"eb30cc29-f43a-48a7-9de8-bedb4f12ee2e","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"小结"},{"type":"hardBreak","attrs":{"id":"b9ec283d-f42b-409b-a3cd-e672c4fe36fc"}},{"type":"text","text":"调整分录是审计的心电图,频繁、期末集中、重分类多是盈余管理的前兆信号。"}]},{"type":"horizontalRule","attrs":{"id":"0c406ea1-0f87-42b2-8aa0-2d29dc2fda13","isHoverDragHandle":false}},{"type":"paragraph","attrs":{"id":"2ae2a106-6f5b-439d-80b5-bde276cdffc0","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"你遇过\"期末突击调账\"最离谱的是哪种?评论区聊。"}]},{"type":"paragraph","attrs":{"id":"8f251ef8-b0f0-4d7d-a208-d26fe7018c00","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"如果有用,点赞收藏关注,留下审计难题。下期预告:关键审计事项自动提取与预警。"}]},{"type":"paragraph","attrs":{"id":"e372c1ed-140e-4dc8-9d75-efd41bca80b8","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"会计师事务所的一名注册会计师"}]}]}

下一篇
举报
领券