文章 · 存档
试试AI做账:自动提取报表数据生成分录
你有没有这样的时刻:
- 手上有一张业务部门填的Excel表,几百行;
- 数据格式五花八门,部门名称写法不统一;
- 想生成一套记账分录,光靠公式搞半天,稍有改动就全部报错;
- 每月重复、耗时、又出错。
过去你靠经验+公式+手工,勉强凑出一套会计分录。
但现在你可以试试“AI做账”:不是代替你记账,而是帮你从“乱糟糟的业务数据表”中,自动提取关键信息,生成“可直接粘贴”的记账分录”。
不换系统,不用大平台,只要你会用GPT或飞书AI助手。
一、AI做账不是大系统,是你桌面上的“小助手”
很多人一听“AI做账”,第一反应是:是不是要上RPA?是不是要接ERP?是不是我们用不起?
错了。
现在AI可以只在你的电脑桌面上运行,不动系统,只帮你“识别→理解→生成”。
最典型的场景是:
- 你拿到一张Excel,比如销售部门的收入确认表、差旅费用表、材料采购对账单;
- 表里虽然有金额、部门、项目编号,但没有结构、没有会计语言;
- GPT就能帮你“读懂业务话”,转成“会计分录语言”。
二、实操案例:从业务表生成会计分录
来看一个真实场景:
销售部门提供的“回款确认表”:
你该怎么做分录?一般你得翻合同、确认用途、判定是否预收、然后写分录:
借:银行存款 80,000
贷:预收账款——江苏XX科技 80,000
如果是20条记录,你手工写还行;如果是200条,GPT就能直接帮你。
三步教你用GPT自动生成会计分录
第一步:整理输入格式
你只要把业务表内容“复制+粘贴”到GPT里,加上一句提示词:
请根据以下回款表内容,生成对应的标准会计分录。要求:
1. 自动判断是否属于预收或应收回款;
2. 每条分录明确借贷方向、金额、科目、客户名;
3. 用表格方式展示,方便复制到Excel。
第二步:GPT自动判断+生成分录
输出示例:
你可以一次贴入几十条记录,GPT逐条生成对应的标准格式,不用你敲一个分录模板。
第三步:复制粘贴入Excel,再导入会计系统
- 如果你在用金蝶、用友、畅捷通、SAP等软件:可以直接将分录表贴入凭证导入模板;
- 如果你用Excel台账记账,也能直接粘贴粘用。
从一堆业务字段 → 分录格式,只需3分钟。
三、不同场景下怎么写提示词?这里有模板!
通用模板结构:
你是会计岗位人员,请根据以下Excel内容,自动生成标准会计分录:
- 格式:借方科目+金额,贷方科目+金额,摘要中包含客户或项目名称;
- 要求:自动识别用途归属,不能遗漏;
- 输出表格格式,方便粘贴入Excel;
四、AI不是让你不思考,而是帮你“少做重复决定”
说白了:
- AI不帮你判断科目是否合理,但它能根据已有规则快速套用;
- AI不帮你决定政策口径,但它能按你的逻辑自动生成分录格式;
- AI不是记账员,是你记账流程的加速器。
你只要做一件事:
把你常做的分录规则,总结成逻辑模板。
比如:
- 看到“预付款”就借预付;
- 金额超过5万的打到项目科目;
- 差旅里只含住宿、交通,不含补贴…
这些逻辑交给GPT,它就能把你的脑子“变成规则引擎”。
五、怕错?你可以要求GPT“解释每一笔逻辑”
这也是AI好用的一点——它会“说明理由”。
你可以加一句提示词:
每条分录请注明生成依据,例如为何判断为预收?为何用哪个科目?
输出示例:
摘要:江苏优品科技回款,未到发货日期,按合同为预收。
分录:借银行存款80,000,贷预收账款80,000。
六、落地建议:不要全部依赖,要“半自动+人审核”
七、AI做账不是黑科技,是“减少体力活”的智能外包
记账没有技术门槛,但有逻辑门槛。
现在的GPT类AI,已经能轻松跨过技术门槛——剩下的,是你有没有把你“脑子里的那套判断逻辑”用文字写出来。
一旦你写清楚,AI就能干脏活、苦活、累活——你负责盯住方向和审核就行。
如果你想试一试,我可以为你准备:
- 各类业务场景的分录生成提示词模板
- 示例Excel表 + AI输出演示
- 与金蝶/用友凭证模板对接的格式样例
- AI辅助会计分录生成的小工具推荐表
Try AI Accounting: Automatically Extract Report Data to Generate Entries
Have you ever had moments like this:
- Holding an Excel sheet filled out by the business department, with hundreds of rows;
- Data formats are all over the place, and department names are written inconsistently;
- Trying to generate a set of accounting entries using only formulas takes forever, and any slight change causes all errors;
- Monthly repetition, time-consuming, and prone to mistakes.
In the past, you barely managed to piece together a set of accounting entries relying on experience, formulas, and manual work.
But now you can try "AI bookkeeping": it doesn't replace you in bookkeeping, but helps you automatically extract key information from the "messy business data sheets" and generate "accounting entries that can be directly pasted."
No need to change the system, no need for a big platform, as long as you know how to use GPT or the Feishu AI assistant.
* 1. AI bookkeeping is not a big system; it’s a "little assistant" on your desktop
Many people, when they hear "AI bookkeeping," their first reaction is: Do we need to implement RPA? Do we need to connect to ERP? Is it something we can’t afford?
Wrong.
Now AI can run only on your computer desktop, without affecting the system, just helping you "recognize → understand → generate."
The most typical scenario is:
- You get an Excel sheet, such as a sales department revenue confirmation form, travel expense report, or material purchase reconciliation statement;
- Although the sheet contains amounts, departments, and project numbers, it lacks structure and accounting language;
- GPT can help you "understand business language" and convert it into "accounting entry language."
* 2. Practical Case: Generating Accounting Entries from Business Tables
Let's look at a real scenario:
The "Payment Confirmation Table" provided by the sales department:
Payment Date, Customer Name, Payment Amount, Purpose of Payment, Assigned Salesperson, Project Number
5/7/10, Jiangsu XX Technology, 80,000, Product Sales Payment - Phase One , Li Ming, XM202407
What journal entries should you make? Generally, you need to review the contract, confirm the purpose, determine whether it is an advance receipt, and then write the entries:
Debit: Bank Deposits 80,000
Credit: Advance Receipts—Jiangsu XX Technology 80,000
If there are 20 records, you can write them manually; if there are 200, GPT can help you directly.
Three Steps to Automatically Generate Accounting Entries Using GPT
Step One: Organize the Input Format
All you need to do is "copy + paste" the business table content into GPT, along with a prompt:
Please generate the corresponding standard accounting entries based on the following payment receipt table. Requirements:
1. Automatically determine whether it belongs to advance receipts or accounts receivable collections;
2. Each entry clearly specifies the debit/credit direction, amount, account, and customer name;
3. Displayed in a table format for easy copying to Excel.
Step 2: GPT automatic judgment + entry generation
Output example:
Debit account, Debit amount, Credit account, Credit Amount, Summary
Bank Deposit, 80,000, Advance Receipts — XX Technology ,80,000, 2025/7/10 First installment payment received
You can paste dozens of records at once, and GPT will generate the corresponding standard format for each entry, so you don’t have to type out a journal entry template each time.
Step 3: Copy and paste into Excel, then import into the accounting system
- If you are using software like Kingdee, Yonyou, Changjietong, SAP, etc.: you can directly paste the entry table into the voucher import template;
- If you use Excel ledger for bookkeeping, you can also paste and use it directly.
From a bunch of business fields → entry format, it only takes 3 minutes.
* 3. How to write prompts in different scenarios? Here are some templates!
Scenario
Recommended prompts
Sales collection form
"Please determine whether each payment received is an advance receipt or an accounts receivable settlement, and generate the journal entries."
Travel Expense Reimbursement Form
"Please generate voucher entries for each travel expense and classify them into accounts such as travel expenses, transportation expenses, etc., according to the type of travel."
Material Purchase Payment
"Please determine whether it is an advance payment or material settlement based on the payment purpose and contract number, and generate the debit and credit entries."
Payroll distribution sheet
"Please generate the corresponding accounting entries for each payroll distribution based on the position and department, including wages payable and social security expenses."
General template structure:
You are an accounting staff member. Please automatically generate standard accounting entries based on the following Excel content:
- Format: Debit account + amount, Credit account + amount, with the summary containing the customer or project name;
- Requirement: Automatically identify the purpose and attribution, without omissions;
- Output in table format for easy pasting into Excel;
* 4. AI is not about making you stop thinking, but about helping you "make fewer repetitive decisions"
To put it simply:
- AI doesn't help you judge whether a subject is reasonable, but it can quickly apply existing rules;
- AI doesn't help you decide policy guidelines, but it can automatically generate entry formats according to your logic;
- AI is not an accountant; it is an accelerator for your bookkeeping process.
You only need to do one thing:
Summarize the entry rules you frequently use into logical templates.
For example:
- When you see "advance payment," just borrow the advance;
- Amounts exceeding 50,000 should be charged to the project account;
- Travel expenses only include accommodation and transportation, excluding allowances...
Give these rules to GPT, and it can turn your brain into a "rule engine."
* 5. Afraid of mistakes? You can ask GPT to "explain every step of the logic"
This is also one of the advantages of AI—it will "provide reasons."
You can add a prompt:
Please specify the basis for each entry, such as why it is classified as advance receipts and why a particular account is used.
Output example:
Summary: Jiangsu Youpin Technology payment received; since the delivery date has not arrived, it is recorded as advance receipt according to the contract.
Entry: Debit bank deposits 80,000, credit advance receipts 80,000.
*6. Implementation suggestion: Do not rely entirely on automation; use a "semi-automatic + manual review" approach.
Steps
Done by humans or AI
Tools
Collect business tables
Human or RPA
Excel or WeChat Work Robot
Extract fields
GPT
ChatGPT/Feishu AI Assistant
Generate Entry
GPT
ChatGPT/Tongyi Qianwen
Review Entries
Person
Manual Excel Verification
Batch Import into System
People + Template
Excel Template + Import Function
* 7. AI bookkeeping is not black technology; it is intelligent outsourcing that "reduces manual labor"
Bookkeeping has no technical threshold, but it does have a logical threshold.
Current GPT-type AI can easily overcome the technical barriers — what remains is whether you have written down the "set of judgment logic in your mind" in words.
Once you write it clearly, AI can handle the dirty, hard, and tiring work — you just need to keep an eye on the direction and review.
If you want to give it a try, I can prepare for you:
- Prompt templates for journal entry generation in various business scenarios
- Sample Excel Sheet + AI Output Demonstration
- Format Examples for Integration with Kingdee/Yonyou Voucher Templates
- Recommended Tools for AI-Assisted Accounting Entry Generation