返回经历Back to experience

RSM / AUDIT & DATA VERIFICATION

业务数据与审计核验Business data and audit verification

参与年度 A 股上市公司审计项目,通过 Excel 数据整理、多科目底稿编制、凭证抽查和报告协作,建立对数据准确性、业务流程和风险控制的结构化理解。Supported an annual audit project for an A-share listed company through Excel data organization, multi-account working papers, voucher sampling, and report collaboration—building a structured understanding of data accuracy, business processes, and risk control.

COMPANY容诚会计师事务所(上海)Rongcheng Certified Public Accountants (Shanghai)
ROLE审计实习生Audit Intern
PERIOD2025.12—2026.03
审计AuditExcelExcel数据核验Data Verification业务流程Business Process风险意识Risk Awareness

从分散业务信息到可核验数据From fragmented business information to verifiable data

交易数据、业务凭证、科目数据、审计底稿和报告信息来自不同来源。面对大量、分散、结构不同的材料,我先进行整理、核验和结构化,形成可以继续使用的工作基础。Transaction data, business evidence, account data, working papers, and report information came from different sources. Faced with extensive, fragmented materials, I organized, checked, and structured them into a usable working base.

01复杂信息输入Complex information input
02整理与结构化Organize and structure
03核验与筛选Check and select
04形成可使用的数据基础Form a usable data base
工作维度Work dimension方法、观察或可迁移能力Method, observation, or transferable capability
交易数据与业务凭证Transaction data and business evidence

先整理来源、字段和记录,再进入后续核验。Organize sources, fields, and records before further checking.

科目数据与审计底稿Account data and working papers

按照统一逻辑分类、汇总并保留可复核的工作记录。Classify and aggregate through a shared logic while keeping reviewable records.

报告信息与检查结果Report information and check results

让数据、凭证、底稿和报告之间保持对应关系。Keep data, evidence, working papers, and reports aligned.

保持信息一致、准确和可追溯Keep information consistent, accurate, and traceable

不同来源的信息不能只看起来一致,还需要交叉核验、识别差异、确认依据并形成可追溯记录。可靠的数据工作不仅需要完成计算,也需要理解流程、保留证据、检查异常,并确保结果可以被复核和解释。Information from different sources should not only look consistent. It needs cross-checking, difference identification, confirmed evidence, and a traceable record. Reliable data work requires understanding the process, preserving evidence, checking anomalies, and keeping results reviewable and explainable.

01不同来源信息Information from different sources
02交叉核验Cross-check
03识别差异Identify differences
04确认依据Confirm the basis
05形成可追溯记录Create a traceable record
工作维度Work dimension方法、观察或可迁移能力Method, observation, or transferable capability
数据与凭证对应Data and evidence alignment

数据需要与凭证和底稿相互对应。Data needs to correspond with evidence and working papers.

样本与程序一致Samples and procedures

样本选择需要遵循既定程序。Sample selection needs to follow the established procedure.

报告数据与格式Report data and format

报告中的数据和格式需要保持一致。Report data and formatting need to remain consistent.

异常与不确定内容Anomalies and uncertainty

异常情况需要进一步核查,不确定内容不能依靠猜测补全。Anomalies need further checking; uncertain information should not be completed by guessing.

把复杂任务转化为标准化流程Turn complex tasks into a standard workflow

在年度 A 股上市公司审计项目中,我围绕底稿、数据整理、凭证抽查和报告协作完成具体支持工作。每一步都明确输入、处理、检查、复核和输出。In the annual audit project for an A-share listed company, I supported working papers, data organization, voucher sampling, and report collaboration. Each step made the input, processing, checking, review, and output clear.

01理解要求Understand the requirement
02拆解任务Break down the task
03整理数据Organize the data
04核验与记录Check and record
05复核内容Review the work
06标准化输出Deliver in a standard format
工作维度Work dimension方法、观察或可迁移能力Method, observation, or transferable capability
年度项目支持Annual project support

参与年度 A 股上市公司审计项目。Supported an annual audit project for an A-share listed company.

科目底稿Account working papers

编制应交税费、货币资金和期间费用科目底稿。Prepared working papers for taxes payable, cash, and period expenses.

Excel 数据整理Excel data organization

使用 Excel 整理交易数据,完成分类、汇总和检查。Organized transaction data in Excel for classification, aggregation, and checks.

凭证与样本Vouchers and samples

执行凭证抽查和样本筛选等实质性程序。Performed voucher sampling, sample selection, and substantive procedures.

底稿与交付Working papers and delivery

协助数据准确性初步校验、报告格式调整及英文材料协作。Supported preliminary accuracy checks, report formatting, and English-material collaboration.

把问题整理成可理解的交付Turn issues into understandable deliverables

数据本身不是最终结果。发现问题后,需要形成结构化记录、解释差异、与团队沟通,并支持后续判断。Data itself is not the final result. After noticing an issue, I organized a structured record, explained the difference, communicated with the team, and supported the next judgment.

01发现问题Notice the issue
02形成结构化记录Create a structured record
03解释差异Explain the difference
04与团队沟通Communicate with the team
05支持后续判断Support the next judgment
工作维度Work dimension方法、观察或可迁移能力Method, observation, or transferable capability
报告格式调整Report formatting

协助审计报告格式调整。Supported audit-report formatting adjustments.

数据准确性校验Data-accuracy checks

协助数据准确性初步校验。Supported preliminary data-accuracy checks.

中英文材料协作Bilingual materials

参与英文合并底稿协作,以及英文报告初稿撰写或修改。Contributed to English consolidated working papers and drafting or revising an English report draft.

规范化交付Standardized delivery

按照规范整理可交付内容,关注信息表达和细节一致性。Organized deliverables according to standards, with attention to expression and detail consistency.

这段经历形成的工作优势Strengths formed through this experience

这段审计经历让我在复杂信息环境中形成了五个稳定的工作习惯。This audit experience formed five steady working habits in complex information environments.

01结构化拆解Structured Thinking从复杂业务资料中识别关系,将任务拆成可执行步骤。Identify relationships in complex business materials and turn tasks into executable steps.
02数据敏感度Data Sensitivity关注数据之间的差异、异常和逻辑一致性。Notice differences, anomalies, and logical consistency across data.
03证据意识Evidence-based Thinking重要判断保留依据,并能够回溯信息来源。Keep the basis for important judgments and trace information back to its source.
04流程意识Process Awareness重视输入、处理、检查、复核和输出之间的完整流程。Pay attention to the full path from input and processing to checking, review, and output.
05沟通与解释Communication & Explanation把数据差异、问题和判断依据转化为结构化、可理解的信息。Turn data differences, issues, and reasoning into structured, understandable information.

NEXT EXPERIENCE

继续查看另一段工作案例Continue to another work case

查看下一段经历:新媒体运营Next experience: Content Operations 联系我Get in touch