Python 审计自动化工具箱 102 篇速查总目录（收官）

{"type":"doc","content":[{"type":"paragraph","attrs":{"id":"9a7659a2-432d-4c66-9ff1-cf494064f9e4","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"问题"},{"type":"hardBreak","attrs":{"id":"36f3e195-5baa-4bd1-908c-ecd81f110369"}},{"type":"text","text":"102 篇技术文章散落各处，临用找不到对应脚本。需要一个按主题归类的速查表，一眼定位“哪篇解决哪类问题、核心函数叫什么”。"}]},{"type":"paragraph","attrs":{"id":"c5b56f2b-1720-4150-8a8e-45b0ee477263","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"速查总表（按主题）"}]},{"type":"paragraph","attrs":{"id":"f09cba11-d584-4a75-86f1-3436cd3c7d7f","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"一、数据采集·清洗·底稿模板"}]},{"type":"bulletList","attrs":{"id":"000ff129-ca49-4e2f-ba05-f95fd8889fd9","isHoverDragHandle":false},"content":[{"type":"listItem","attrs":{"id":"9dd72e82-1ba9-4f17-b04e-95d5fc8dc602"},"content":[{"type":"paragraph","attrs":{"id":"ab1c06c4-a2fd-47b9-b111-bb918f98d6de","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"1 银行流水往来勾对 → reconcile_bank()"}]}]},{"type":"listItem","attrs":{"id":"a4ec8714-6851-4360-b2b8-4392154ebad3"},"content":[{"type":"paragraph","attrs":{"id":"ea716fe6-4e87-4fdb-85e9-f44c581fdf4f","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"2 科目余额表异常筛查 → flag_abnormal()"}]}]},{"type":"listItem","attrs":{"id":"31d91c4b-222a-45b7-9612-3e5d77c106a5"},"content":[{"type":"paragraph","attrs":{"id":"89577120-6695-41ef-8799-fdda9d0b246d","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"3 openpyxl 抽凭底稿生成 → build_vouch_sheet()"}]}]},{"type":"listItem","attrs":{"id":"f9d70dcd-27ad-4775-b1c4-ac95f3557d7c"},"content":[{"type":"paragraph","attrs":{"id":"7bd9c304-ac0f-4e41-a9dd-656b1d322ce5","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"5 异常分录筛查 → find_journal_redflags()"}]}]},{"type":"listItem","attrs":{"id":"1181dd69-f36d-4a7b-a15d-6a5ddf11ff4f"},"content":[{"type":"paragraph","attrs":{"id":"53f7040e-8cd9-40d5-9af1-2ad807949872","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"6 openpyxl 条件格式超链接 → add_hyperlink_fmt()"}]}]},{"type":"listItem","attrs":{"id":"9f657d5f-512d-47c0-9996-8b61d74b2723"},"content":[{"type":"paragraph","attrs":{"id":"d94a9d14-4213-43d4-a3f5-9125f28dfbb6","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"7 银行流水异常检测 → detect_flow_anomaly()"}]}]},{"type":"listItem","attrs":{"id":"7b311c0c-a539-4620-aaf9-b8c29bbf838b"},"content":[{"type":"paragraph","attrs":{"id":"373829b0-a7eb-4ffb-b482-bac96e8a895a","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"8 余额表同比环比 → yoy_mom()"}]}]},{"type":"listItem","attrs":{"id":"176699e7-72d7-4da5-a187-bf48d75dd72c"},"content":[{"type":"paragraph","attrs":{"id":"85c76ca4-ad71-440f-be6e-47698f3910e0","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"10 pandas 数据透视分析 → pivot_summary()"}]}]},{"type":"listItem","attrs":{"id":"5229d92e-abe8-4892-8666-aac2ee2eafe3"},"content":[{"type":"paragraph","attrs":{"id":"47e0d7ff-cb07-4f56-904f-c5a4909b3ff9","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"11 pdfplumber 提取表格 → extract_tables()"}]}]},{"type":"listItem","attrs":{"id":"66690d3c-1184-492d-8ef6-31b600083faa"},"content":[{"type":"paragraph","attrs":{"id":"adb5149c-d5ed-4448-8ca4-711f7298c816","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"12 银行余额调节表 → build_adjustment()"}]}]},{"type":"listItem","attrs":{"id":"0c0bd38c-cfae-4061-9e24-ae41f17542a5"},"content":[{"type":"paragraph","attrs":{"id":"5051eadc-91a2-4014-85e3-181cecf29b92","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"31 凭证系统抽样 → systematic_sample()"}]}]},{"type":"listItem","attrs":{"id":"b0948bc1-8b2f-4e7a-a2bd-f42b9ef01ee2"},"content":[{"type":"paragraph","attrs":{"id":"eb53895f-1e3b-4da1-b1c9-7fcfc689185c","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"35 openpyxl 分析程序表 → analysis_procedure()"}]}]},{"type":"listItem","attrs":{"id":"ad0f3bb4-5579-4fa9-b93a-c1159099f826"},"content":[{"type":"paragraph","attrs":{"id":"8053a033-2443-4e23-a903-c1d12450b1b3","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"57 库存现金盘点溢缺 → cash_count_diff()"}]}]},{"type":"listItem","attrs":{"id":"17e4875b-6d64-4a0f-b9f7-7811ba0db82a"},"content":[{"type":"paragraph","attrs":{"id":"e94f17c9-4d57-4460-8920-fb3c3875b5c2","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"62 银行存款未达账项 → uncleared_items()"}]}]},{"type":"listItem","attrs":{"id":"ebef70bd-1a5f-491a-ba1b-496c90d9812d"},"content":[{"type":"paragraph","attrs":{"id":"9273d784-aa3b-4536-8c94-71472661030e","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"72 函证控制表 → confirmation_log()"}]}]},{"type":"listItem","attrs":{"id":"19fb45ca-8e3e-44f1-878b-335af80ecfa2"},"content":[{"type":"paragraph","attrs":{"id":"5d7d7837-b574-4ab4-9722-7fe6262b6857","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"83 底稿索引与复核痕迹 → index_and_review()"}]}]}]},{"type":"paragraph","attrs":{"id":"392b3d7c-b256-42ad-9999-9e5eeeeca3cb","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"二、资产类测算与盘点"}]},{"type":"bulletList","attrs":{"id":"b7c1dcc9-2fc4-42a4-bcbd-dd81d583d5d6","isHoverDragHandle":false},"content":[{"type":"listItem","attrs":{"id":"59b9ea50-1fad-4684-a479-ed875c2b906a"},"content":[{"type":"paragraph","attrs":{"id":"0a97d7f2-4000-46e3-979c-8ac82e1e9d11","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"4 往来款账龄分析 → aging_analysis()"}]}]},{"type":"listItem","attrs":{"id":"52966a9a-fa06-4b11-b3a3-76a07f7b8f1b"},"content":[{"type":"paragraph","attrs":{"id":"18308e59-43d5-4870-a851-89a7a617baa3","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"9 固定资产折旧 → depreciation()"}]}]},{"type":"listItem","attrs":{"id":"c2a78549-b8db-44f5-a2aa-c082b3a00d7f"},"content":[{"type":"paragraph","attrs":{"id":"8fb5ed87-3047-417d-a592-511b4ceede21","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"13 应收账款坏账准备 → bad_debt_provision()"}]}]},{"type":"listItem","attrs":{"id":"24c71341-1059-4bce-ab41-9744241cec4f"},"content":[{"type":"paragraph","attrs":{"id":"cf1ce8ab-d625-419c-a86f-2c3aa8454224","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"16 存货收发存与盘点差异 → inventory_variance()"}]}]},{"type":"listItem","attrs":{"id":"f78f3ad3-9e52-47b4-ae67-bea9a649ece9"},"content":[{"type":"paragraph","attrs":{"id":"3acc6dc3-3e77-4e56-9c6e-5b5d6e7586ad","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"21 长期待摊费用摊销 → amortize_deferred()"}]}]},{"type":"listItem","attrs":{"id":"f853d16b-099a-45ad-b77d-8a975e256766"},"content":[{"type":"paragraph","attrs":{"id":"208d9489-0ec6-4d2c-8281-74ce4cc629d0","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"26 无形资产摊销与减值 → intangible_amort()"}]}]},{"type":"listItem","attrs":{"id":"841e96d2-080f-4748-ac5d-1f95115d11fc"},"content":[{"type":"paragraph","attrs":{"id":"ae7fbb71-f74d-4585-80d0-b5a2db012822","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"27 外币货币性汇兑损益 → fx_gain_loss()"}]}]},{"type":"listItem","attrs":{"id":"fa76e4e5-6c5e-4086-aeea-75ab51944ebe"},"content":[{"type":"paragraph","attrs":{"id":"61c2ac67-7f02-41ac-8627-cdf547512481","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"36 应收票据贴现利息 → bill_discount()"}]}]},{"type":"listItem","attrs":{"id":"147f246c-716a-4004-b698-a6c7982a1d2d"},"content":[{"type":"paragraph","attrs":{"id":"c6d245cd-7b70-47b4-a97f-4bdebb5225c5","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"38 存货跌价准备 → nrv_impairment()"}]}]},{"type":"listItem","attrs":{"id":"4c321266-6b0c-42f0-822e-2c35f9ca7bc3"},"content":[{"type":"paragraph","attrs":{"id":"6861ab64-f6c7-49b2-81b4-aae600130526","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"39 在建工程转固与利息资本化 → cap_interest()"}]}]},{"type":"listItem","attrs":{"id":"390ba8ed-b601-4f12-a8b7-02e4df03f0d8"},"content":[{"type":"paragraph","attrs":{"id":"1d3b43fd-e94e-401c-88e2-d5ae62507ef0","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"41 租赁负债与使用权资产 → lease_liability()"}]}]},{"type":"listItem","attrs":{"id":"d58c800b-0141-4216-a5d5-5d972988c995"},"content":[{"type":"paragraph","attrs":{"id":"c302e817-9f67-4beb-801a-62fe57f52db5","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"48 商誉减值测试 → goodwill_impair()"}]}]},{"type":"listItem","attrs":{"id":"10d0ba15-26fe-4a90-ab9f-07e6e3b9ff9e"},"content":[{"type":"paragraph","attrs":{"id":"185b450b-42b4-49cd-b9fb-7e081d6843e9","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"49 借款费用资本化核查 → borrow_cost_audit()"}]}]},{"type":"listItem","attrs":{"id":"579eb5df-8feb-4d67-abdc-2bebaf2b8402"},"content":[{"type":"paragraph","attrs":{"id":"df2bf2c7-9d5b-45ce-93e5-641c550c94c7","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"51 应收票据账龄与坏账 → note_aging()"}]}]},{"type":"listItem","attrs":{"id":"ae17ab37-9f7f-4719-9881-a7456e3dda4f"},"content":[{"type":"paragraph","attrs":{"id":"2180ab6f-af05-42ad-bc2a-705f142132ba","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"55 固定资产折旧复核 → depr_review()"}]}]},{"type":"listItem","attrs":{"id":"34dcf829-9b21-4893-8fec-c7a2337573e1"},"content":[{"type":"paragraph","attrs":{"id":"076c546f-2c7c-438f-8db6-5df3af6711c5","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"59 预付与长期资产采购 → prepay_check()"}]}]},{"type":"listItem","attrs":{"id":"56a2670c-10b0-44f2-85b2-9446689fae40"},"content":[{"type":"paragraph","attrs":{"id":"b914d241-427d-4cd2-8635-77a302f4d0ce","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"60 固定资产盘点差异 → fa_count_diff()"}]}]},{"type":"listItem","attrs":{"id":"59d4999c-8eb8-45ba-a9c0-d667cee580a2"},"content":[{"type":"paragraph","attrs":{"id":"a83d52e0-27c6-41a9-b85b-f481a9931bf0","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"63 应收账款 ECL 模型 → ecl_model()"}]}]},{"type":"listItem","attrs":{"id":"4cf410bd-4c14-4a7b-be8b-a2badb6ff78a"},"content":[{"type":"paragraph","attrs":{"id":"706fb0e5-c541-440a-9b8c-0fc392d3fe36","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"84 外币折算与汇兑 → currency_translate()"}]}]},{"type":"listItem","attrs":{"id":"f05957fc-7b3c-4437-8c0d-4809769a077f"},"content":[{"type":"paragraph","attrs":{"id":"c8db8f4b-0a53-4119-afd7-a2061960c096","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"85 企业合并 PPA → ppa_allocate()"}]}]},{"type":"listItem","attrs":{"id":"84ef04d1-18af-47ae-9ab1-54edd01378e2"},"content":[{"type":"paragraph","attrs":{"id":"a862eb0b-c96c-4d10-8162-830e90c542f8","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"86 公允价值层级 → fair_value_hierarchy()"}]}]},{"type":"listItem","attrs":{"id":"2a2ef97d-26d2-4746-9c62-8b0956a041df"},"content":[{"type":"paragraph","attrs":{"id":"e2c6c6d1-e0bd-4ae1-a604-c33173a16658","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"87 资产减值可收回金额 → recoverable_amount()"}]}]},{"type":"listItem","attrs":{"id":"f818ec50-fd19-42bb-8195-736ed2b7fd07"},"content":[{"type":"paragraph","attrs":{"id":"a7dbb23b-1148-48b3-83fc-c3e1c629d8fe","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"88 研发支出划分 → rnd_capitalize()"}]}]},{"type":"listItem","attrs":{"id":"bbc82db4-7808-4bd3-8054-1a503b053502"},"content":[{"type":"paragraph","attrs":{"id":"d343b415-487f-4d22-a092-2ed6b6be2e8f","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"96 可转债分拆 → cb_split()"}]}]},{"type":"listItem","attrs":{"id":"6ab2cf4e-7ec1-4608-b437-6c6477e7e2e1"},"content":[{"type":"paragraph","attrs":{"id":"ce21c9bb-c409-4c14-b689-7ab323937ca6","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"100 员工持股 ESOP 与库存股 → esop_treasury()"}]}]},{"type":"listItem","attrs":{"id":"d943831d-ee8b-4a04-a296-d5a828d99d5d"},"content":[{"type":"paragraph","attrs":{"id":"75dea77c-7d64-40a6-a380-63d232d9a0b5","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"101 其他综合收益 OCI → oci_breakdown()"}]}]}]},{"type":"paragraph","attrs":{"id":"b4b0ef6f-cf47-49a2-ae56-3b006d42fb96","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"三、负债·权益·损益·税费"}]},{"type":"bulletList","attrs":{"id":"cb481cfa-caea-432b-8a46-ed1278a005e4","isHoverDragHandle":false},"content":[{"type":"listItem","attrs":{"id":"74484f5c-bf12-4284-b8aa-65a493dcb4f8"},"content":[{"type":"paragraph","attrs":{"id":"6fad9a5e-97d4-485a-b97f-5284ef073b6f","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"14 增值税进销项勾对 → vat_reconcile()"}]}]},{"type":"listItem","attrs":{"id":"7c1fdea7-61b4-4084-abe4-eafde9e3596e"},"content":[{"type":"paragraph","attrs":{"id":"fa383fe6-9c31-4155-8355-6f24d553c89b","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"17 借款利息按日测算 → daily_interest()"}]}]},{"type":"listItem","attrs":{"id":"26a366ea-5bb3-4fcf-bb7b-3eb910841ea0"},"content":[{"type":"paragraph","attrs":{"id":"f3d15082-57f2-41d5-80b3-ce04b363c0cf","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"18 应交税费按税种 → tax_by_type()"}]}]},{"type":"listItem","attrs":{"id":"1f5c16e9-d3f0-48f6-806a-8dfb1d9acf5b"},"content":[{"type":"paragraph","attrs":{"id":"2bc486fd-f5a8-4ea0-a607-fc1750faa5b6","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"20 关联方交易识别 → related_party()"}]}]},{"type":"listItem","attrs":{"id":"17436eee-5d9c-4734-8525-3263fe63a45a"},"content":[{"type":"paragraph","attrs":{"id":"609c7309-1bc6-4a30-b6b6-7ffae10e3e11","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"23 资产负债表往来重分类 → reclassify()"}]}]},{"type":"listItem","attrs":{"id":"394f0627-9f92-4d1a-a100-ed3a3ec5df4c"},"content":[{"type":"paragraph","attrs":{"id":"bb254ad6-f727-48be-b50b-e3165d1a3c18","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"24 应付职工薪酬测算 → payroll_accrual()"}]}]},{"type":"listItem","attrs":{"id":"590dcb01-4114-4044-a239-c1431c7ddd2b"},"content":[{"type":"paragraph","attrs":{"id":"5ad128e8-001c-4623-861b-7308e2f49dd0","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"25 期间费用结构分析 → expense_structure()"}]}]},{"type":"listItem","attrs":{"id":"3c007593-984f-477a-b58b-159a023553a5"},"content":[{"type":"paragraph","attrs":{"id":"0d9b9469-f834-45b2-bf30-3ca0f1d830b4","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"28 收入成本毛利分析 → gross_margin_analysis()"}]}]},{"type":"listItem","attrs":{"id":"e376a5a1-97f3-4837-beca-7202387d1bdb"},"content":[{"type":"paragraph","attrs":{"id":"7ba225b2-8431-466e-890e-20a96ca795ae","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"30 递延所得税测算 → dta_dtl()"}]}]},{"type":"listItem","attrs":{"id":"a2156ef7-65a2-440e-8569-22ab4d3f1847"},"content":[{"type":"paragraph","attrs":{"id":"db8f5ddf-1e93-4ca2-b321-237fa6314d0a","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"32 所有者权益变动勾稽 → equity_move()"}]}]},{"type":"listItem","attrs":{"id":"1224972b-4699-4fb9-9927-1f355fefd72c"},"content":[{"type":"paragraph","attrs":{"id":"00978b75-f462-4642-8ff5-c86d955ce408","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"33 主营业务成本结转勾稽 → cogs_tieout()"}]}]},{"type":"listItem","attrs":{"id":"a6c91131-5048-4d3b-a315-fcc055f75824"},"content":[{"type":"paragraph","attrs":{"id":"76721d92-75db-455a-9ba0-a681f727b44e","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"34 预收与合同负债勾稽 → contract_liability()"}]}]},{"type":"listItem","attrs":{"id":"9b68047c-8c35-48b5-ae95-a866c3b9abf5"},"content":[{"type":"paragraph","attrs":{"id":"a70b08ef-ae39-4454-bba0-34be6ad5a788","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"37 财务费用与利息勾稽 → finance_expense_tie()"}]}]},{"type":"listItem","attrs":{"id":"04b9764a-a7ba-4f2e-93e1-22d6262a9d19"},"content":[{"type":"paragraph","attrs":{"id":"347ff60e-c72e-43ac-bb27-a82b2f0360cf","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"40 政府补助递延收益 → gov_grant_amort()"}]}]},{"type":"listItem","attrs":{"id":"34c0b2ea-5213-471a-a580-8cd9f2289319"},"content":[{"type":"paragraph","attrs":{"id":"49871f84-5a0f-4ee5-a986-327f716c2556","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"42 实收资本公积变动 → capital_change()"}]}]},{"type":"listItem","attrs":{"id":"248715b4-1f2e-4328-a210-c009ef5d12f5"},"content":[{"type":"paragraph","attrs":{"id":"5583ff80-52df-4aa6-b9cf-39a0b785ccc0","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"43 盈余公积未分配利润 → retained_earnings()"}]}]},{"type":"listItem","attrs":{"id":"fa238916-919d-4d5f-956e-86b4af543c51"},"content":[{"type":"paragraph","attrs":{"id":"106f8b84-7cea-471d-bc1e-0dc5cc074e83","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"45 企业所得税汇算 → corp_income_tax()"}]}]},{"type":"listItem","attrs":{"id":"5c7e483e-f024-4f6a-a661-7086122db28b"},"content":[{"type":"paragraph","attrs":{"id":"bb0415cc-d4a6-4ee3-8b55-ccf89fa5bfe5","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"50 现金流量表直接法 → cashflow_direct()"}]}]},{"type":"listItem","attrs":{"id":"fe1a5a5e-a0f6-44bc-a7a7-d216dd60b8ed"},"content":[{"type":"paragraph","attrs":{"id":"f6b1cd84-842c-42bc-bb98-6fa95ba37cae","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"53 销售收现交叉验证 → sales_cash_check()"}]}]},{"type":"listItem","attrs":{"id":"77b436a2-d419-4db0-894c-f59a68d8b3d4"},"content":[{"type":"paragraph","attrs":{"id":"1b62d50e-65ae-4230-b478-f9c014947f19","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"54 应付账款账龄 → ap_aging()"}]}]},{"type":"listItem","attrs":{"id":"77783b38-1631-4df8-a48d-23a9d308b0f9"},"content":[{"type":"paragraph","attrs":{"id":"f3788c55-2c63-467c-9e6f-73b84de85ce4","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"56 预计负债最佳估计 → provision_estimate()"}]}]},{"type":"listItem","attrs":{"id":"c591d6cb-af4a-4cbc-930f-0693b95e320c"},"content":[{"type":"paragraph","attrs":{"id":"ac19477b-5970-4e75-999b-32ac8ac0976c","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"58 采购付现交叉 → purchase_cash_check()"}]}]},{"type":"listItem","attrs":{"id":"595c313c-ec3c-4e43-aaee-46799df93fab"},"content":[{"type":"paragraph","attrs":{"id":"3eeda4fe-880a-46b8-a0d3-633b4a6ed2ee","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"61 或有事项披露 → contingency_disclose()"}]}]},{"type":"listItem","attrs":{"id":"491b0698-741a-4d4b-b162-4f3ec3aa6bfd"},"content":[{"type":"paragraph","attrs":{"id":"f861037e-a138-45c6-a17d-4bcf52a6c342","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"64 持续经营评估 → going_concern()"}]}]},{"type":"listItem","attrs":{"id":"aeef083b-da6b-45b0-8a5b-3b778cddccf3"},"content":[{"type":"paragraph","attrs":{"id":"7fd3fb6e-1fd0-4130-8349-836fe5655392","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"65 期后事项 → subsequent_events()"}]}]},{"type":"listItem","attrs":{"id":"79861c20-82b6-43c8-ba8c-239ead182f76"},"content":[{"type":"paragraph","attrs":{"id":"2df1eae6-0cb5-4e2a-ac01-5926cd3b592e","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"66 每股收益 → eps_calc()"}]}]},{"type":"listItem","attrs":{"id":"ff035304-3497-4608-a468-3d10aa182f50"},"content":[{"type":"paragraph","attrs":{"id":"905f28db-8b0f-4e1c-b3cb-34e491995e9c","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"67 分部报告勾稽 → segment_report()"}]}]},{"type":"listItem","attrs":{"id":"de78e95d-3b55-4edb-a4b0-ec89955101f7"},"content":[{"type":"paragraph","attrs":{"id":"203ea398-1e06-4254-bd8a-687ba6353e67","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"68 现金流量间接法自动 → cashflow_indirect()"}]}]},{"type":"listItem","attrs":{"id":"cd26c1ce-4262-40b1-b919-8e3c7a21d7a0"},"content":[{"type":"paragraph","attrs":{"id":"33bb19ca-83d4-4d4b-a46b-0409e2bcae5f","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"70 合并长投权益抵销 → consolidate_equity()"}]}]},{"type":"listItem","attrs":{"id":"f953d5ed-d31e-4dcb-8fe7-abb2bb34699f"},"content":[{"type":"paragraph","attrs":{"id":"0eff27fe-83ab-4b1a-bbe4-44c69261bd43","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"71 应交税费勾稽 → tax_tieout()"}]}]},{"type":"listItem","attrs":{"id":"b94e3aa6-e6b7-4afd-aa57-123d363af949"},"content":[{"type":"paragraph","attrs":{"id":"44ba855e-4c9c-4a1b-ac7f-c4c38119ca02","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"74 股份支付费用 → share_payment()"}]}]},{"type":"listItem","attrs":{"id":"351cec72-8771-4bb5-8907-9cf8153be4f6"},"content":[{"type":"paragraph","attrs":{"id":"cf2c3f43-f467-457b-a7f1-3151c4876b5e","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"76 债务重组损益 → debt_restructure()"}]}]},{"type":"listItem","attrs":{"id":"c9cadc65-713c-4720-a525-aaecf1cd4fdd"},"content":[{"type":"paragraph","attrs":{"id":"4fa7721f-55ab-418a-b0bd-563ce79033aa","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"77 非货币性交换 → nonmonetary_exchange()"}]}]},{"type":"listItem","attrs":{"id":"6398b42f-3c3c-44f7-9216-8face9623a05"},"content":[{"type":"paragraph","attrs":{"id":"18ba22c5-ed8a-419f-9e85-7c7da39b8fd0","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"78 会计政策变更追溯 → retroactive_adjust()"}]}]},{"type":"listItem","attrs":{"id":"323d6a1a-5364-49b7-aab8-c99803ce62da"},"content":[{"type":"paragraph","attrs":{"id":"aeb4b8ff-5403-4c05-bc14-3460ecb877eb","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"79 关联方资金占用 → rp_capital_occupy()"}]}]},{"type":"listItem","attrs":{"id":"7ea1273e-3140-40e5-ab77-be2abd6bdad3"},"content":[{"type":"paragraph","attrs":{"id":"016f5293-59e6-4eaf-a41f-a0af412f15b6","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"80 收入五步法履约进度 → revenue_progress()"}]}]},{"type":"listItem","attrs":{"id":"6ba66b58-643f-4bc1-9161-8886f6f00191"},"content":[{"type":"paragraph","attrs":{"id":"1d64fef7-9bdb-4430-9bc6-bba2015f9a9d","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"81 审计调整分录汇总 → adjustment_summary()"}]}]},{"type":"listItem","attrs":{"id":"2a77aaec-930c-4bef-b07a-dfb25537da8e"},"content":[{"type":"paragraph","attrs":{"id":"c09d9e6e-3430-4999-95f8-9a3a22070048","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"82 重要性水平与错报 → materiality_eval()"}]}]},{"type":"listItem","attrs":{"id":"35ffbd11-82e1-441b-be46-c24fa83723ef"},"content":[{"type":"paragraph","attrs":{"id":"7323ff05-0d88-4738-b42d-16f8f8d577a2","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"90 合并现金流量表抵销 → consol_cashflow()"}]}]},{"type":"listItem","attrs":{"id":"f954a059-16bd-4d30-85a4-97298339e81c"},"content":[{"type":"paragraph","attrs":{"id":"e2ec2455-f6e7-4c7c-96e9-32e1a71e9932","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"91 工资个税社保勾稽 → payroll_tax_social()"}]}]},{"type":"listItem","attrs":{"id":"1b3d4fb6-0bea-4a53-8f8d-73477a808976"},"content":[{"type":"paragraph","attrs":{"id":"363ba3a4-0d6a-462c-8955-08aab44edf8d","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"94 合并范围控制判断 → control_test()"}]}]},{"type":"listItem","attrs":{"id":"71fa5526-12f3-443d-9221-c775f47fe8fd"},"content":[{"type":"paragraph","attrs":{"id":"6764df28-51df-4e00-b7fa-b4006ac585aa","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"95 长投核算转换 → equity_method_switch()"}]}]},{"type":"listItem","attrs":{"id":"4529bbac-ed9e-4f18-a8c8-b63e368d1bbb"},"content":[{"type":"paragraph","attrs":{"id":"0f93a038-2c55-4647-88b5-458e39304672","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"97 持有待售与终止经营 → held_for_sale()"}]}]},{"type":"listItem","attrs":{"id":"f06fa519-e5ab-455f-8c0c-3fbab0c03c64"},"content":[{"type":"paragraph","attrs":{"id":"c92933eb-5f82-4811-ac3c-23221649b773","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"98 反向购买借壳 → reverse_acquisition()"}]}]},{"type":"listItem","attrs":{"id":"281af196-d046-421a-9d2e-445ca33f54d8"},"content":[{"type":"paragraph","attrs":{"id":"3aa8308a-b84a-4470-8663-96ff1fcf42a5","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"99 会计估计变更边界 → estimate_change()"}]}]}]},{"type":"paragraph","attrs":{"id":"3b0c6e00-dd65-4088-ba2f-d56d2667b9e3","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"四、审计程序·抽样·风险·意见·工程化"}]},{"type":"bulletList","attrs":{"id":"4f7eda6b-2780-4f19-a495-cbf5a3b6e238","isHoverDragHandle":false},"content":[{"type":"listItem","attrs":{"id":"a2756ca3-cd93-4f54-a665-0f3f86d13ba1"},"content":[{"type":"paragraph","attrs":{"id":"46ccb016-f30f-4a35-b9b7-aefab2db2722","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"19 openpyxl 试算平衡 → trial_balance()"}]}]},{"type":"listItem","attrs":{"id":"415b0843-4a2c-4502-b3e1-e6c80e93b46e"},"content":[{"type":"paragraph","attrs":{"id":"b50a401f-87d5-4eac-b4f5-811058e569d1","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"22 现金流量间接法 → indirect_cf()"}]}]},{"type":"listItem","attrs":{"id":"4913a99d-3e63-4c7f-bfb4-ac617857f4b8"},"content":[{"type":"paragraph","attrs":{"id":"0aca1c96-69f5-40c5-a28e-5d162c097823","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"29 openpyxl 审定表 → audited_schedule()"}]}]},{"type":"listItem","attrs":{"id":"6a83ab7b-1eff-4443-af8f-a03e6ff54dba"},"content":[{"type":"paragraph","attrs":{"id":"11c6213f-a0f3-4d6f-a4ee-6beac42ab2e7","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"44 应收账款替代程序 → alternative_procedure()"}]}]},{"type":"listItem","attrs":{"id":"b6534430-e64a-4ab7-84a6-5560f6d6f797"},"content":[{"type":"paragraph","attrs":{"id":"46a63d7f-8ea1-4f9f-b7f7-ac8008308f85","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"47 内部交易合并抵销 → intercompany_elim()"}]}]},{"type":"listItem","attrs":{"id":"04d6576f-d35f-4abc-8910-6a51b4f365d8"},"content":[{"type":"paragraph","attrs":{"id":"fd7c7ae0-75ed-4de7-978c-e34e5859db65","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"52 比率分析舞弊识别 → ratio_fraud()"}]}]},{"type":"listItem","attrs":{"id":"138ba490-439c-4d7a-bdcb-0d2fe1a65497"},"content":[{"type":"paragraph","attrs":{"id":"ac70302f-ef3a-4376-8e65-5c6e810d71fc","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"69 货币单元抽样 MUS → mus_sample()"}]}]},{"type":"listItem","attrs":{"id":"27a40f5f-9a6b-4096-8ece-e86898f6083f"},"content":[{"type":"paragraph","attrs":{"id":"325e147d-1eb2-418c-a6cc-001fa7da4489","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"73 工具箱总览与骨架 → AuditKit"}]}]},{"type":"listItem","attrs":{"id":"16ca822e-77ac-437b-840e-aa4ce9047e5a"},"content":[{"type":"paragraph","attrs":{"id":"de72b5e4-1cbe-474a-9f29-5385c25478a6","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"75 金融资产三分类 → financial_asset_class()"}]}]},{"type":"listItem","attrs":{"id":"b6a291ae-eac1-4ed8-878b-ec6d50e605db"},"content":[{"type":"paragraph","attrs":{"id":"cba6a685-ac32-47ca-ae3b-0fb43f17b2a3","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"89 套期会计 → hedge_accounting()"}]}]},{"type":"listItem","attrs":{"id":"facad4c0-991a-4a4a-a78d-530116e17c2e"},"content":[{"type":"paragraph","attrs":{"id":"e422a699-a9e5-4207-9463-6f5ae0f4b6e7","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"92 变量抽样与发现抽样 → variable_discovery()"}]}]},{"type":"listItem","attrs":{"id":"29e3e3ac-b59c-46e6-8e4a-024f994151af"},"content":[{"type":"paragraph","attrs":{"id":"77af42b4-a313-4ad3-b311-f278ce3185a1","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"102 审计意见决策树 → audit_opinion()"}]}]}]},{"type":"paragraph","attrs":{"id":"bfba863d-b4af-450b-9d9d-793f5a64ea33","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"关键点"}]},{"type":"bulletList","attrs":{"id":"50fc4fb6-d4c2-41e4-93e4-fadcd3116305","isHoverDragHandle":false},"content":[{"type":"listItem","attrs":{"id":"bb3be2e7-dfce-4455-8c89-82c11ac6f599"},"content":[{"type":"paragraph","attrs":{"id":"b4a249a7-3b66-4fb3-9878-e15b0f6f69ae","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"全系列 102 篇，统一“问题→示例代码→关键点→小结”骨架，核心函数名固定（如 ecl_model、mus_sample），复用直接 import。"}]}]},{"type":"listItem","attrs":{"id":"a3f84d42-2346-4795-a250-56c0b23ed175"},"content":[{"type":"paragraph","attrs":{"id":"70dd08c9-6d16-45f3-98fd-7083ac5ebfd1","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"按“数据采集→资产→负债权益损益→程序抽样风险”四层递进，新手从一入门、熟手跳三、复核看四。"}]}]},{"type":"listItem","attrs":{"id":"fd38c389-c10e-4d46-91d3-72eb40ae13d3"},"content":[{"type":"paragraph","attrs":{"id":"059b0a2b-9b84-4d18-8aa7-4374447d4a1c","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"所有代码纯 ASCII、零外部私有依赖，pandas/openpyxl 即可跑。"}]}]}]},{"type":"paragraph","attrs":{"id":"d0e95dc3-3ee4-4a4d-9299-9fad5d4beee5","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"小结"},{"type":"hardBreak","attrs":{"id":"55d4bbb6-73ec-42ee-a916-fbbdf84b9439"}},{"type":"text","text":"102 篇即一套可落地的审计 Python 工具箱目录。配速查表，临场找脚本不再翻聊天记录。"}]},{"type":"horizontalRule","attrs":{"id":"2d779988-fa6f-41c5-a188-07f62049d587","isHoverDragHandle":false}},{"type":"paragraph","attrs":{"id":"03a985e2-8af9-4448-94a6-88fbacc7cc49","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"你最常用的三篇是哪几篇？希望下个系列聚焦“报告自动成稿”还是“风险预警 dashboard”？评论区点菜。"}]},{"type":"paragraph","attrs":{"id":"cb2507fc-e626-4bc5-bb2c-8b92fad3fb4d","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"如果这篇帮你省了翻找时间，欢迎点赞、收藏、关注，并在评论区留下你的审计难题。下期预告：审计报告附注自动生成（从审定数一键出注释）。"}]},{"type":"paragraph","attrs":{"id":"e1cc4558-879c-4e89-affa-db1a71f3d284","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"会计师事务所的一名注册会计师"}]}]}