Python 截止性测试自动化（收入费用跨期抽凭）

{"type":"doc","content":[{"type":"paragraph","attrs":{"id":"0e3aa064-b7e7-4a15-9d21-215ab6c08e83","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"问题"},{"type":"hardBreak","attrs":{"id":"88773f52-bc36-410c-b4bd-00b04479c225"}},{"type":"text","text":"资产负债表日前后各抽若干笔凭证，确认收入/费用计入正确期间。手工翻凭证判断入账期易漏。用 Python 按“凭证日期 vs 资产负债表日”自动分类，标出可能跨期错报。"}]},{"type":"paragraph","attrs":{"id":"3eca1e62-bd04-4e32-9648-16fab20bf2d7","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"示例代码"}]},{"type":"paragraph","attrs":{"id":"e84661da-baa9-4cd3-990d-437615b1423c","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":"ba99ccb4-c7f5-46e7-b4b3-1398389e8250","language":"javascript","theme":"atom-one-dark","runtimes":0,"isHoverDragHandle":false,"key":"","languageByAi":"javascript"},"content":[{"type":"text","text":"from datetime import date\n\ndef cutoff_test(vouchers, year_end):\n results = []\n for v in vouchers:\n in_period = v[\"date\"] <= year_end\n early = v[\"date\"] <= year_end and v.get(\"ship_date\", v[\"date\"]) > year_end\n late = v[\"date\"] > year_end and v.get(\"biz_date\", v[\"date\"]) <= year_end\n results.append({**v, \"in_period\": in_period,\n \"early_risk\": early, \"late_risk\": late})\n return results\n\nvouchers = [\n {\"id\": \"V1\", \"date\": date(2025,12,28), \"ship_date\": date(2026,1,5), \"amt\": 100},\n {\"id\": \"V2\", \"date\": date(2026,1,4), \"biz_date\": date(2025,12,20), \"amt\": 80},\n]\nprint(cutoff_test(vouchers, date(2025,12,31)))\n"}]},{"type":"paragraph","attrs":{"id":"3e1417c9-6054-402b-81cc-d9239320b540","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"关键点"}]},{"type":"bulletList","attrs":{"id":"2d471d1c-91d4-473d-8485-232b86a7fbe9","isHoverDragHandle":false},"content":[{"type":"listItem","attrs":{"id":"cd4b85ad-49b2-472d-85f7-a21270eba86f"},"content":[{"type":"paragraph","attrs":{"id":"f08a615b-d438-4916-a34b-96499741875d","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"截止测试核心：比“入账日”和“权属转移日/义务发生日”，两者跨资产负债表日即风险点。"}]}]},{"type":"listItem","attrs":{"id":"be5cc7d7-f01c-4513-90a3-c5781396fb63"},"content":[{"type":"paragraph","attrs":{"id":"751ed715-f74c-45cd-baa1-6c80b7c77d79","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"early_risk 抓提前确认收入，late_risk 抓推迟确认；两者都需追凭证与物流/合同佐证。"}]}]},{"type":"listItem","attrs":{"id":"65f7ef20-8710-41a3-89dc-e2426b6f3861"},"content":[{"type":"paragraph","attrs":{"id":"868969e0-c52d-42ce-ab16-6bf6af03f07b","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"自动化只做分类标记，最终靠抽样看原始单据，样本量按重要性水平定。"}]}]}]},{"type":"paragraph","attrs":{"id":"d3152d9a-a1e9-4d65-9ee2-02c58d2b8009","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"小结"},{"type":"hardBreak","attrs":{"id":"4d26afbc-39b5-4ccf-a9d0-2b4781ef7eca"}},{"type":"text","text":"截止错报的本质是“时间错配”。Python 把凭证按日期分层，跨期嫌疑一笔不漏地标出来。"}]},{"type":"horizontalRule","attrs":{"id":"090bf8a4-fab9-4dd7-ab9e-331cca0dd52b","isHoverDragHandle":false}},{"type":"paragraph","attrs":{"id":"23c25981-af77-4ad4-80de-998f5062af90","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"你做截止测试通常抽期末前后几天？遇到过哪种跨期最隐蔽？评论区聊。"}]},{"type":"paragraph","attrs":{"id":"883f371b-7d48-4d5d-9614-56eeff667128","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"如果有用，点赞收藏关注，留下审计难题。下期预告：内控缺陷识别矩阵（控制活动评价指标化）。"}]},{"type":"paragraph","attrs":{"id":"d91bc12d-000c-42e5-be95-f2bacf03af0a","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"会计师事务所的一名注册会计师"}]}]}