发票台账怎么做: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
- 批量提取:在 信息提取 上传发票,自动识别号码、日期、金额、税额、购销方,导出 Excel/CSV。Extract: upload invoices to Extract; it reads number, date, amounts, buyer/seller and exports Excel/CSV.
- 入库查重:把记录导入 本地发票台账,系统按发票号码做历史比对,重复票立即标记。Import & dedup: load records into the local ledger; it compares by number and flags duplicates instantly.
- 统计归档:按月查看合计与分类,导出备份,换电脑前保存 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.