一疊單據,影完相就掉喺電話入面,到月底先嚟後悔。呢個流程將「入賬」拆成四步:上載、提取、整理成表、出摘要 —— 每步都有 prompt,貼咗就用得。最後仲有一段進階玩法:唔再逐步指揮,而係畀個目標同規則 AI,等佢自己行完成個流程。
🧾 四步流程
① 上載單據 — 影相或者 PDF 都得,一次過掉晒入去。
② 提取欄位 — 日期、商戶、類別、金額 —— 讀單據上面真係有嘅字。
③ 整理成表 — 一行一筆,欄位次序你話事,出 CSV 直接貼入試算表。
④ 支出摘要 — 總額、類別佔比、最大五筆,一段過貼入月結。
① 上載單據
相片、PDF、截圖都得。唔使特別排版,但有幾樣嘢會直接影響之後幾步讀得準唔準:
- 影全張單,四個角都要入鏡 —— 剪走咗個總額,後面所有數都錯
- 光線平均,唔好有陰影或者反光壓住啲數字
- 摺痕同皺咗嘅位攤平,熱敏紙尤其易花
- 一次過上載同一個月嘅單據,唔好分幾次 —— 後面搵異常要成個月一齊睇先睇得出
② 提取欄位
呢一步嘅重點唔係「快」,係「唔好估」。單據影得矇、商戶名印得細、金額有個摺痕壓住 —— AI 係有能力幫你填得好順暢嘅,而嗰個先係最危險。所以 prompt 入面幾條規則,全部都係叫佢喺唔肯定嘅時候留白同標記,而唔係補一個好似啱嘅數畀你。
I've uploaded receipts (photos or PDFs). Extract these fields from each one, one block per receipt: - date (YYYY-MM-DD) - merchant - category (meals / transport / office supplies / software / marketing / professional services / travel / other) - amount and currency - payment method (only if it's on the receipt) - receipt number (only if it's on the receipt) Rules: 1. Read only what is actually visible on the receipt. If you can't read it, write "unclear" — do not guess. 2. Take the total printed on the receipt as the amount. If the line items don't add up to that total, give me both numbers and flag the mismatch. 3. List service charge, tip and tax separately. Don't fold them in as ordinary spending. 4. When you're done, list the fields you were unsure about, so I can check them myself.
③ 整理成表
格式你自己話事,下面 prompt 入面用緊嘅係一個可以直接開工嘅版本:日期|商戶|類別|金額|幣種|付款方式|單據編號|備註。想加「項目」或者「客戶」欄,改一行就得。
Turn those receipts into a table, one row per entry, with these columns in this order: date | merchant | category | amount | currency | payment method | receipt number | notes Rules: 1. Dates always YYYY-MM-DD, so they sort properly. 2. Amounts as digits only — no currency symbols, no thousands separators (e.g. 1280.50). Currency goes in its own column. 3. Use only the categories I listed. Don't invent new ones. If something genuinely fits none of them, write "other" and explain in the notes column. 4. Leave a field blank if you couldn't read it. Don't write "N/A", and don't guess. 5. Output as CSV so I can paste it straight into Google Sheets or Excel. 6. No totals row at the bottom — I'll calculate that in the spreadsheet.
兩個位好多人踩親:金額唔好連貨幣符號一齊寫(試算表會當佢文字,加唔到數),同埋唔好叫佢喺最後加一行總計(一 sort 就散晒)。
④ 支出摘要
有咗張表,摘要先有意思 —— 因為每個數都計得返出嚟。呢一步唔係叫 AI「講吓感想」,而係叫佢由張表計返總額、類別佔比、最大嗰五筆,寫成一段可以直接貼入月結嘅嘢。
Using the table above, write an expense summary I can paste straight into a spreadsheet or a monthly report: 1. Total spend for the period, by currency 2. Each category's amount and share, largest first 3. The five largest individual expenses, with dates and merchants 4. If I've given you last period's figures, compare: which categories rose, and by what percentage 5. One closing line: the single thing most worth noticing this period Rules: every number must be calculated from the table. Don't add anything that isn't in it, and don't state a conclusion stronger than the data supports.
入賬嘅底線: AI 整嘅表係副本,唔係憑證 —— 原本嗰張單據要留返底。落賬之前,至少抽查總額同日期:呢兩樣一錯,成張表都要重做。
🤖 進階:用 AI Agent 做財務規劃
頭四步係你逐步指揮,AI 逐步做。進階玩法係反過嚟:你只係講清楚目標同規則,AI 自己行完成個流程先覆你。一個月幾十張單據,逐張傾你會癲,呢個時候先真係慳到時間。
- 讀取 — 逐張單據攞日期、商戶、金額、幣種。
- 分類 — 用固定嘅類別清單,唔准自己發明。
- 找異常 — 重複扣款、高過平均、新商戶、總額對唔上、類別放錯。
- 分析 — 邊幾類佔最多?邊啲係固定開支、邊啲係一次性?
- 摘要 — 一頁以內:總額、類別分佈、Top 5、異常清單。
- 建議 — 三個具體慳錢做法,每個都要指返邊幾筆數支持。
「異常」呢兩個字,你唔定義,AI 就會自己定義。所以 prompt 入面要寫死:幾多百分比叫高、幾耐之內叫重複、邊種情況叫類別放錯。
Goal: from this month's spending, identify the major expenses, the anomalies, and anything worth my attention. I'm giving you every receipt for the month at once. Work through this whole routine yourself — don't check in at each step: 1. Read: extract date, merchant, category, amount and currency from each receipt. 2. Categorise: use only these fixed categories — meals / transport / office supplies / software / marketing / professional services / travel / other. 3. Find anomalies: flag anything matching one of these — - the same merchant charging more than once in a short window - an amount more than 50% above the average for its category - a merchant appearing for the first time this month - a receipt total that doesn't match its line items - a merchant that doesn't belong in the category it landed in 4. Analyse: which categories dominate? Which costs recur every month, and which were one-offs? 5. Summarise: one page or less — total, category breakdown, top 5 expenses, the anomaly list. 6. Recommend: three specific ways to spend less, each pointing at the actual expenses that support it. Rules: - Every conclusion must name the receipt or the line it came from. Don't tell me anything I can't trace back. - Anything you couldn't read, or that's missing data, goes in a "needs input from me" list. Don't fill it in yourself. - No investment or tax advice. Only what the numbers themselves show. - Work through all six steps, then reply once.
最要緊嗰條規則係「每個結論都要講返邊張單支持」。有咗佢,你可以抽幾條返去核;冇咗佢,你只係得到一段讀落好有道理、但你查唔到嘅嘢。
最後提醒: 呢個流程幫你慳嘅係入資料嘅時間,唔係幫你做會計判斷。稅務點報、邊啲使費可以扣,去問你嘅會計師 —— AI 做得最好嗰部分,係喺你見到佢之前,將啲數執到整整齊齊。