发票台账怎么做:Excel/CSV 台账与查重防重复报销How to keep an invoice ledger — Excel/CSV and de-duplication

发票一多就乱?一份好的台账能让你随时知道"这个月报了多少、哪张票报过没"。这篇讲清台账要记什么、怎么导出、如何查重,避免重复报销。Lost track of invoices? A good ledger tells you at a glance what was claimed this month and which invoice was already used. This covers what to log, how to export and how to dedup to stop double claims.

2026-10-29 · 约 6 分钟阅读~6 min read · 分类:管理Category: Manage

台账的本质:把每张发票的关键信息集中记在一张表里,方便统计、核对与审计。它既是报销的"底稿",也是防止重复报销的"防火墙"。Essence: a ledger centralizes each invoice's key fields for stats, checking and audit. It's both the working paper and the firewall against double claims.

一、台账至少记这些字段1. Fields your ledger should have

字段Field说明Why
发票号码Invoice number查重主键,数电票为 20 位号码Dedup key; 20 digits for digital
开票日期Date按月统计、逾期提醒Monthly stats, aging
销方名称/税号Seller供应商核对Supplier check
金额 / 税额 / 价税合计Amount / tax / total合计与校验Totals & checks
报销状态Status待报/已报/已付Pending/done/paid

二、手工台账 vs 自动台账2. Manual vs automated ledger

维度Aspect手工 ExcelManual Excel自动台账工具Automated tool
录入Entry手动抄写,易错Typing, error-prone批量识别自动填Batch auto-fill
查重Dedup靠眼睛或公式Eyes or formulas入库即自动比对Auto on import
统计Stats透视表Pivot按月一键汇总One-click monthly
隐私Privacy本地文件Local file浏览器本地In-browser

三、三步建立自动台账3. Build an automated ledger in three steps

  1. 批量提取:在 信息提取 上传发票,自动识别号码、日期、金额、税额、购销方,导出 Excel/CSV。Extract: upload invoices to Extract; it reads number, date, amounts, buyer/seller and exports Excel/CSV.
  2. 入库查重:把记录导入 本地发票台账,系统按发票号码做历史比对,重复票立即标记。Import & dedup: load records into the local ledger; it compares by number and flags duplicates instantly.
  3. 统计归档:按月查看合计与分类,导出备份,换电脑前保存 JSON/Excel 即可迁移。Stats & archive: view monthly totals by category, export a backup, and save JSON/Excel before switching devices.

四、查重是防重复报销的关键4. Dedup is the key to stopping double claims

重复报销大多因为"忘了这张报过"。以发票号码为唯一键,新票入库时自动和历史记录比对,命中即标红提示,从源头堵住漏洞。注意:同一笔业务可能有多张不同发票(如分项开票),查重只看"号码是否重复",不会误伤正常多张票。Most double claims come from "forgot this one was claimed". Use the invoice number as the unique key; on import the tool compares against history and flags matches in red, closing the loophole at the source. Note: one transaction can legitimately have several different invoices — dedup only checks number repetition, never mis-flagging normal multi-invoice cases.

五、常见坑5. Common pitfalls

  • 只存打印件:打印件丢了电子原件,无法再查验或重新入账,台账应保留号码与电子文件。Keep only prints: losing the electronic original means no re-verification; keep numbers and the e-file.
  • 跨设备不同步:台账在本机浏览器,换电脑前务必导出备份再导入。No cross-device sync: the ledger lives in your browser — export a backup before switching devices.
  • 忘记价税校验:台账里加一列校验"价税合计 = 金额 + 税额",录入即发现错误。Skip total check: add a column verifying "total = net + tax" to catch errors on entry.