Back to Details

invoice-aging

Compare original and translation side by side

🇺🇸

Original

English
🇨🇳

Translation

Chinese

Invoice Aging Report

发票账龄报告

Overview

概述

Analyze accounts receivable by sorting outstanding invoices into aging buckets: Current (0-30 days), 31-60 days, 61-90 days, and 90+ days. Identifies clients with chronically late payments and calculates total exposure.
分析应收账款，将未结清发票按账龄区间分类：当期（0-30天）、31-60天、61-90天及90天以上。识别长期逾期付款的客户并计算总风险敞口。

Wilson Tools Used

使用的Wilson工具

  • transaction_search
    — find payment transactions matched to known clients or invoice references, identify gaps where expected payments are missing
  • transaction_search
    — 查找与已知客户或发票编号匹配的付款交易，识别预期付款缺失的缺口

Workflow

工作流程

  1. Ask for the list of outstanding invoices (client name, invoice amount, invoice date, due date) or ask the user to describe their invoicing pattern.
  2. Use 
    transaction_search
    to find all incoming payments from each client over the past 6 months.
  3. Cross-reference received payments against known invoice amounts and dates.
  4. For each unpaid or partially paid invoice, calculate days outstanding from the due date.
  5. Sort into aging buckets:
ACCOUNTS RECEIVABLE AGING — as of [Date]
═══════════════════════════════════════════════════════
Client          Current   31-60    61-90     90+     Total
────────────────────────────────────────────────────────
Acme Corp       $2,500      —        —        —     $2,500
Beta LLC            —    $1,800      —        —     $1,800
Gamma Inc           —       —     $3,200      —     $3,200
Delta Co            —       —        —     $5,000   $5,000
────────────────────────────────────────────────────────
TOTALS          $2,500   $1,800   $3,200   $5,000  $12,500
% of Total       20.0%    14.4%    25.6%    40.0%    100%
═══════════════════════════════════════════════════════
  1. Flag any client with invoices in the 90+ bucket.
  2. Calculate weighted average days outstanding.
  3. Recommend follow-up actions: send reminder (31-60), escalate (61-90), consider collections (90+).
  1. 请求未结清发票列表（客户名称、发票金额、发票日期、到期日），或让用户描述其开票模式。
  2. 使用
    transaction_search
    查找过去6个月内每个客户的所有入账付款。
  3. 将收到的付款与已知发票金额和日期进行交叉核对。
  4. 对每笔未付或部分付款的发票，计算自到期日起的逾期天数。
  5. 按账龄区间分类：
ACCOUNTS RECEIVABLE AGING — as of [Date]
═══════════════════════════════════════════════════════
Client          Current   31-60    61-90     90+     Total
────────────────────────────────────────────────────────
Acme Corp       $2,500      —        —        —     $2,500
Beta LLC            —    $1,800      —        —     $1,800
Gamma Inc           —       —     $3,200      —     $3,200
Delta Co            —       —        —     $5,000   $5,000
────────────────────────────────────────────────────────
TOTALS          $2,500   $1,800   $3,200   $5,000  $12,500
% of Total       20.0%    14.4%    25.6%    40.0%    100%
═══════════════════════════════════════════════════════
  1. 标记所有有90天以上账龄发票的客户。
  2. 计算加权平均逾期天数。
  3. 推荐后续行动：发送提醒（31-60天）、升级跟进（61-90天）、考虑催收（90天以上）。

Without Wilson

不使用Wilson的操作步骤

  1. Export your invoice list from your invoicing tool (QuickBooks: Reports > Customers & Receivables > A/R Aging Summary; FreshBooks: Reports > Accounts Aging; Wave: Reports > Aged Receivables).
  2. If no invoicing tool, create a spreadsheet with columns: Client, Invoice #, Amount, Invoice Date, Due Date, Paid Date, Paid Amount.
  3. Calculate days outstanding: 
    =IF(PaidDate="", TODAY()-DueDate, PaidDate-DueDate)
    .
  4. Assign buckets with: 
    =IF(DaysOutstanding<=0,"Current",IF(DaysOutstanding<=30,"Current",IF(DaysOutstanding<=60,"31-60",IF(DaysOutstanding<=90,"61-90","90+"))))
    .
  5. Pivot table: Rows = Client, Columns = Bucket, Values = Sum of Amount.
  6. For weighted average: 
    =SUMPRODUCT(Amount,DaysOutstanding)/SUM(Amount)
    .
  1. 从开票工具导出发票列表（QuickBooks：报表 > 客户与应收账款 > 应收账款账龄汇总；FreshBooks：报表 > 账户账龄；Wave：报表 > 逾期应收账款）。
  2. 如果没有开票工具，创建电子表格，列包括：客户、发票编号、金额、发票日期、到期日、付款日期、付款金额。
  3. 计算逾期天数：
    =IF(PaidDate="", TODAY()-DueDate, PaidDate-DueDate)
    。
  4. 分配账龄区间：
    =IF(DaysOutstanding<=0,"Current",IF(DaysOutstanding<=30,"Current",IF(DaysOutstanding<=60,"31-60",IF(DaysOutstanding<=90,"61-90","90+"))))
    。
  5. 数据透视表：行 = 客户，列 = 账龄区间，值 = 金额总和。
  6. 加权平均：
    =SUMPRODUCT(Amount,DaysOutstanding)/SUM(Amount)
    。

Important Notes

重要说明

  • Wilson tracks cash transactions, not invoices directly. This skill works best when you can provide a list of issued invoices to cross-reference against bank deposits.
  • Partial payments should be tracked. If an invoice is $5,000 and $3,000 was received, the remaining $2,000 is still outstanding.
  • Consider offering early payment discounts (e.g., 2/10 Net 30) for clients consistently in the 61-90+ buckets.
  • Wilson跟踪现金交易，不直接跟踪发票。当您能提供已开具发票列表以与银行存款交叉核对时，此技能效果最佳。
  • 应跟踪部分付款。如果一张发票金额为5000美元，已收到3000美元，剩余2000美元仍未结清。
  • 考虑为经常处于61-90天及以上账龄区间的客户提供提前付款折扣（例如，2/10 Net 30，即10天内付款享受2%折扣，30天内全额付款）。