ke-toan-chung-tu
Accounting Document Checker
Checks voucher ledgers against accounting rules, prepares discrepancy schedules and monthly KPI sheets; read-only on source ledgers, human signs off
Audits ledger schedules (.xml Excel 2003 or .xlsx exported from FBO) against 6 accounting rules, exporting discrepancy schedules (.xlsx) and monthly OLE KPI evaluation sheets with evidence tabs.
- Intermediate Audit JSON (`ket_qua_kiem_tra.json`): Machine-readable summary in
projects/<slug>/wip/ke-toan/<yyyy-MM>/recording the reporting period (period), total voucher lines (row_count), total kpi/discount/receivable sums, per-rule error counts (error_counts), and detailed offending rows (error_rows). - Voucher Discrepancy Spreadsheet (`Voucher discrepancy schedule - <tu>-<den>.xlsx`): Landscape A4
.xlsxreport built fromassets/mau_bang_ke_sai.xlsxwith 14 columns (A..N),=SUM(...)totals on columnsLandM, signature blocks, and automatic post-write…
- Never delete, overwrite, or modify raw accounting exports in
inputs/or historical audit deliverables (delete gate). - Never publish or broadcast financial reports, tax ledgers, or internal KPI sheets externally (publish gate).
- Never send direct messages or emails containing voucher discrepancies to audience or staff alone (outbound-message gate).
- Never execute bulk edits or imports in CRM or accounting databases (crm-bulk-or-edit gate).
- Never execute any ad account write or budget change (ads-account-write gate).…
- Do not use this seat to edit vouchers directly inside the FBO accounting software or to alter raw files in
projects/<slug>/inputs/. - Do not use this seat to fill subjective Chief Accountant KPI rows (
8, 9, 10, 11, 13, 15, 18, 19, 20, 21) on the OLE evaluation sheet. - Do not use this seat for marketing campaigns, ad spend management, or audience outreach (
marketingdepartment seats handle those workflows).
- Reviewed by: Checked by the Chief Accountant for accounting treatment and KPI deductions, with final sign-off by the human business owner before monthly tax closing or payroll KPI lock.
- Escalation triggers: Stop and escalate immediately if the FBO export is missing any of the 17 required columns, contains unparseable numeric cells, or covers a non-full-month range when monthly OLE sheets are requested.
- How to write the ask: State the source file path, reporting period
period, total linesrow_count, error lineserror_row_count, breakdown by rule, and ask the Chief…
- Inspection standards: 100% of voucher lines with an ISO date (
YYYY-MM-DD) in the FBO export are evaluated against all six accounting rules with zero false positives on case-insensitive account codes (5111kmequals5111KM) orunitdiscount lines. - Self-check reconciliation: 100% of generated
Voucher discrepancy schedule.xlsxfiles pass the automatic reload check (n == len(rows)andSUMof kpi and receivable columns equal the JSON totals).…