Back to Details

accounts-payable-management

Compare original and translation side by side

🇺🇸

Original

English
🇨🇳

Translation

Chinese

Accounts Payable Management

应付账款管理

Overview

概述

Accounts payable (AP) management covers ingesting supplier invoices, matching them against purchase orders and goods receipts, scheduling payments, capturing early-payment discounts, and reconciling against the vendor ledger. For most e-commerce merchants, a dedicated AP tool or accounting software integration handles this far better than custom code.
应付账款（AP）管理涵盖接收供应商发票、将其与采购订单和收货单匹配、安排付款、获取提前付款折扣以及与供应商分类账对账。对于大多数电商商家而言，专用的AP工具或会计软件集成处理这些事务的效果远优于自定义代码。

When to Use This Skill

何时使用此技能

  • When your AP team is manually keying invoices from PDFs into spreadsheets and payment delays are causing vendor friction
  • When you need automated three-way matching between purchase orders, goods receipts, and invoices
  • When early-payment discounts (e.g., 2/10 net 30) are being missed because payment scheduling is reactive
  • When preparing for an ERP integration (NetSuite, SAP, QuickBooks) and need a clean AP data model
  • When audit requirements demand an immutable record of every invoice approval, payment authorization, and GL posting
  • 当你的AP团队手动将PDF发票录入电子表格，且付款延迟导致与供应商产生矛盾时
  • 当你需要在采购订单、收货单和发票之间实现自动化三方匹配时
  • 当由于付款调度被动而错过提前付款折扣（如2/10 net 30，即10天内付款享2%折扣，30天内全额付款）时
  • 当准备集成ERP系统（NetSuite、SAP、QuickBooks）并需要清晰的AP数据模型时
  • 当审计要求保留每笔发票审批、付款授权和总账过账的不可变记录时

Core Instructions

核心操作指南

Step 1: Determine your current setup and choose the right AP tool

步骤1：确定当前设置并选择合适的AP工具

Store StageRecommended ToolWhy
Small (< $1M revenue)QuickBooks Online or XeroBoth handle AP with supplier invoices, payment scheduling, and bank reconciliation; integrate with Shopify/WooCommerce via native connectors
Mid-market ($1M–$20M)BILL (formerly Bill.com) or TipaltiBILL handles invoice capture via email, approval workflows, ACH/check payments, and vendor portals; Tipalti adds mass global payments
Enterprise ($20M+)NetSuite ERP or SAP Business OneFull ERP with three-way matching, GL coding, and multi-entity consolidation
Custom / HeadlessBuild an AP data model + integrate with Stripe Treasury or Plaid for paymentsFor platforms with non-standard procurement workflows
店铺阶段推荐工具推荐理由
小型（年收入<100万美元）QuickBooks Online 或 Xero两者均可处理供应商发票、付款调度和银行对账；通过原生连接器与Shopify/WooCommerce集成
中型市场（年收入100万–2000万美元）BILL（原Bill.com）或 TipaltiBILL支持通过电子邮件捕获发票、审批工作流、ACH/支票付款和供应商门户；Tipalti额外支持批量全球付款
企业级（年收入>2000万美元）NetSuite ERP 或 SAP Business One完整的ERP系统，支持三方匹配、总账编码和多实体合并
自定义/无头架构构建AP数据模型 + 集成Stripe Treasury或Plaid处理付款适用于具有非标准采购工作流的平台

Step 2: Connect your e-commerce platform to your AP system

步骤2：将电商平台连接到AP系统

Shopify

Shopify

Connect Shopify to QuickBooks Online:
  1. Install QuickBooks Online connector from the Shopify App Store (free, by Intuit) or use A2X (paid, more reliable for high-volume)
  2. The connector syncs Shopify sales, refunds, and payouts to QuickBooks automatically
  3. In QuickBooks → Expenses → Vendors, manage your supplier invoices and payment schedules
  4. Enter vendor invoices manually in QuickBooks or forward supplier invoices to your QuickBooks inbox email (QuickBooks extracts invoice data via OCR)
Connect Shopify to BILL:
  1. Install BILL from the Shopify App Store or connect via Zapier
  2. BILL receives supplier invoices via email (forward to your BILL inbox address)
  3. BILL extracts invoice data, routes for approval based on your rules, and schedules ACH or check payments
  4. For Shopify inventory vendors: create purchase orders in BILL and match incoming invoices against them
将Shopify连接到QuickBooks Online：
  1. 从Shopify应用商店安装QuickBooks Online连接器（Intuit提供，免费）或使用A2X（付费，高交易量场景下更可靠）
  2. 连接器会自动将Shopify的销售、退款和付款数据同步到QuickBooks
  3. 在QuickBooks中，进入「费用 → 供应商」管理供应商发票和付款计划
  4. 手动在QuickBooks中录入供应商发票，或将供应商发票转发至你的QuickBooks收件箱邮箱（QuickBooks通过OCR提取发票数据）
将Shopify连接到BILL：
  1. 从Shopify应用商店安装BILL，或通过Zapier连接
  2. 将供应商发票转发至你的BILL收件箱邮箱，BILL将接收这些发票
  3. BILL提取发票数据，根据你的规则路由审批，并安排ACH或支票付款
  4. 对于Shopify库存供应商：在BILL中创建采购订单，并将收到的发票与之匹配

WooCommerce

WooCommerce

Connect WooCommerce to QuickBooks:
  1. Install the QuickBooks Online plugin from WooCommerce.com (official extension)
  2. Configure sync settings: sales orders, refunds, and fees sync automatically
  3. Manage supplier invoices in QuickBooks → Expenses
Connect WooCommerce to Xero:
  1. Install Xero from WooCommerce.com or use a third-party connector like WooSync or Xero for WooCommerce by Codisto
  2. Xero handles AP with a built-in bills module, payment approvals, and bank reconciliation
将WooCommerce连接到QuickBooks：
  1. 从WooCommerce.com安装QuickBooks Online插件（官方扩展）
  2. 配置同步设置：销售订单、退款和费用将自动同步
  3. 在QuickBooks的「费用」模块中管理供应商发票
将WooCommerce连接到Xero：
  1. 从WooCommerce.com安装Xero，或使用第三方连接器如WooSync或Codisto提供的Xero for WooCommerce
  2. Xero通过内置的账单模块处理AP事务，支持付款审批和银行对账

BigCommerce

BigCommerce

Connect BigCommerce to QuickBooks:
  1. Use QuickBooks Online connector from the BigCommerce App Marketplace or A2X Accounting
  2. A2X is specifically designed for e-commerce accounting and handles Shopify/WooCommerce/BigCommerce → QuickBooks sync accurately
Connect BigCommerce to NetSuite:
  1. Use the NetSuite Connector from the BigCommerce App Marketplace or a middleware like Celigo or Boomi
  2. NetSuite provides enterprise AP with full three-way matching, multi-entity support, and audit trails
将BigCommerce连接到QuickBooks：
  1. 使用BigCommerce应用市场的QuickBooks Online连接器或A2X Accounting
  2. A2X专为电商会计设计，可准确处理Shopify/WooCommerce/BigCommerce到QuickBooks的同步
将BigCommerce连接到NetSuite：
  1. 使用BigCommerce应用市场的NetSuite Connector，或使用中间件如Celigo或Boomi
  2. NetSuite提供企业级AP功能，支持完整的三方匹配、多实体管理和审计追踪

Step 3: Set up invoice capture and approval workflows

步骤3：设置发票捕获和审批工作流

Using BILL (best-in-class dedicated AP tool)

使用BILL（顶级专用AP工具）

  1. Invoice capture: Forward supplier invoices to your BILL inbox email or have suppliers submit directly via a BILL supplier portal link
  2. AP inbox in BILL: Review captured invoices at BILL → Payables → Inbox; BILL's OCR extracts vendor name, invoice number, date, amount, and due date
  3. Approval routing: Go to BILL → Settings → Approval Policies to configure amount-based routing:
    • Under $500: auto-approve
    • $500–$5,000: AP Manager approval
    • $5,000–$50,000: Controller approval
    • Over $50,000: CFO approval
  4. Approvers receive an email with a one-click approve/reject link
  5. Payment scheduling: BILL schedules payments based on vendor due dates; you can also set to pay X days before due date to capture 2/10 early discounts
  1. 发票捕获： 将供应商发票转发至你的BILL收件箱邮箱，或让供应商通过BILL供应商门户链接直接提交
  2. BILL中的AP收件箱： 在BILL的「应付账款 → 收件箱」中查看捕获的发票；BILL的OCR会提取供应商名称、发票编号、日期、金额和到期日
  3. 审批路由： 进入BILL的「设置 → 审批政策」，配置基于金额的路由规则：
    • 500美元以下：自动审批
    • 500–5000美元：AP经理审批
    • 5000–50000美元：财务总监审批
    • 50000美元以上：首席财务官审批
  4. 审批人会收到包含一键批准/拒绝链接的电子邮件
  5. 付款调度： BILL根据供应商到期日安排付款；你也可以设置在到期日前X天付款，以获取2/10的提前付款折扣

Using QuickBooks Online for smaller operations

使用QuickBooks Online（适用于小型业务）

  1. Go to Expenses → Vendors → [Vendor] → New Transaction → Bill
  2. Enter invoice details manually or forward the invoice PDF to your QuickBooks inbox email
  3. Set the due date based on vendor terms (e.g., net 30)
  4. To pay: go to Expenses → Pay Bills, select invoices due, choose payment method (bank transfer, check)
  5. QuickBooks tracks outstanding AP and generates an aging report (Reports → Accounts Payable Aging)
  1. 进入「费用 → 供应商 → [对应供应商] → 新交易 → 账单」
  2. 手动录入发票详情，或将发票PDF转发至你的QuickBooks收件箱邮箱
  3. 根据供应商条款设置到期日（如net 30，即30天内付款）
  4. 付款操作：进入「费用 → 付款账单」，选择到期发票，选择付款方式（银行转账、支票）
  5. QuickBooks会跟踪未结清的AP，并生成账龄报告（报表 → 应付账款账龄）

Step 4: Implement three-way matching

步骤4：实现三方匹配

Three-way matching compares: the purchase order (what you ordered), the goods receipt (what you received), and the vendor invoice (what the vendor is charging).
In NetSuite:
  • NetSuite handles three-way matching natively — create a PO, receive the goods (Inventory → Receive Inventory), then match the vendor bill against both; discrepancies auto-flag as exceptions
In QuickBooks:
  • QuickBooks does not do three-way matching automatically
  • Workflow: create a PO in QuickBooks (Expenses → Purchase Orders), receive the items in inventory, then match the bill to the PO manually
  • Third-party add-on: Zahara or Lightyear add PO matching and approval automation on top of QuickBooks
In BILL:
  • BILL supports PO matching — create POs in BILL, then when an invoice arrives, BILL prompts you to match it against an open PO
三方匹配指对比：采购订单（你订购的内容）、收货单（你收到的内容）和供应商发票（供应商收取的费用）。
在NetSuite中：
  • NetSuite原生支持三方匹配——创建采购订单，收货（库存 → 接收库存），然后将供应商账单与两者匹配；差异会自动标记为异常
在QuickBooks中：
  • QuickBooks不自动支持三方匹配
  • 工作流：在QuickBooks中创建采购订单（费用 → 采购订单），接收库存商品，然后手动将账单与采购订单匹配
  • 第三方插件：Zahara或Lightyear可在QuickBooks基础上添加采购订单匹配和审批自动化功能
在BILL中：
  • BILL支持采购订单匹配——在BILL中创建采购订单，当发票到达时，BILL会提示你将其与未结采购订单匹配

Step 5: Capture early-payment discounts

步骤5：获取提前付款折扣

Common vendor terms are "2/10 net 30" — 2% discount if paid within 10 days, full amount due in 30.
In BILL:
  1. In your vendor record, set payment terms to "2/10 Net 30"
  2. BILL automatically flags invoices where early payment would save money
  3. Go to BILL → Payables → Early Pay to see all discount opportunities sorted by savings amount
In QuickBooks:
  1. When entering a vendor bill, set the payment terms to "2/10 Net 30"
  2. QuickBooks calculates the discount amount automatically
  3. When paying: select the bill and QuickBooks shows the discount available if paid today
Key rule: Set a weekly payment run on a fixed day (e.g., every Tuesday). Pay all invoices due in the next 10 days. This captures early discounts systematically without manual review.
常见的供应商条款是“2/10 net 30”——10天内付款享2%折扣，30天内全额付款。
在BILL中：
  1. 在供应商记录中，将付款条款设置为“2/10 Net 30”
  2. BILL会自动标记提前付款可节省成本的发票
  3. 进入BILL的「应付账款 → 提前付款」，查看按节省金额排序的所有折扣机会
在QuickBooks中：
  1. 录入供应商账单时，将付款条款设置为“2/10 Net 30”
  2. QuickBooks会自动计算折扣金额
  3. 付款时：选择账单，QuickBooks会显示如果今日付款可享受的折扣
关键规则： 固定每周某一天（如每周二）进行付款操作。支付所有未来10天内到期的发票。这样无需手动审核即可系统地获取提前付款折扣。

Step 6: Reconcile and report

步骤6：对账和报告

AP aging report

AP账龄报告

Run monthly to see all outstanding payables by age:
  • QuickBooks: Reports → Accounts Payable Aging Summary
  • BILL: Reports → AP Aging
  • Xero: Reports → Aged Payables Summary
This shows you what's current, 30–60 days, 60–90 days, and 90+ days overdue.
每月生成一次，查看所有未结应付款的账龄：
  • QuickBooks： 报表 → 应付账款账龄汇总
  • BILL： 报表 → AP账龄
  • Xero： 报表 → 逾期应付账款汇总
该报告会显示当前到期、30–60天、60–90天以及90天以上逾期的款项。

Cash flow forecast

现金流预测

  • QuickBooks: Reports → Cash Flow Forecast (shows projected outflows based on bill due dates)
  • Float (add-on for QuickBooks/Xero): provides a more accurate 90-day cash flow forecast including AP obligations
  • QuickBooks： 报表 → 现金流预测（根据账单到期日显示预计流出）
  • Float（QuickBooks/Xero的插件）：提供更准确的90天现金流预测，包括AP债务

Custom / Headless — core AP data model

自定义/无头架构——核心AP数据模型

typescript
// Minimal AP invoice schema for custom implementations
interface ApInvoice {
  id: string;
  vendorId: string;
  invoiceNumber: string;      // unique per vendor
  invoiceDate: Date;
  dueDate: Date;
  currency: string;           // 'USD'
  totalCents: number;
  paidCents: number;          // increments as payments are applied
  status: 'received' | 'pending_approval' | 'approved' | 'scheduled' | 'paid' | 'disputed';
  poId?: string;              // linked purchase order for matching
  earlyDiscountRate?: number; // e.g., 0.02 for 2%
  earlyDiscountDeadline?: Date;
}

// Identify invoices where early payment saves money
function findEarlyPaymentOpportunities(
  invoices: ApInvoice[],
  todayDate: Date
): { invoiceId: string; discountCents: number; deadline: Date }[] {
  return invoices
    .filter(inv => inv.status === 'approved')
    .filter(inv => inv.earlyDiscountRate && inv.earlyDiscountDeadline! > todayDate)
    .map(inv => ({
      invoiceId: inv.id,
      discountCents: Math.round(inv.totalCents * inv.earlyDiscountRate!),
      deadline: inv.earlyDiscountDeadline!,
    }))
    .sort((a, b) => b.discountCents - a.discountCents);
}
typescript
// Minimal AP invoice schema for custom implementations
interface ApInvoice {
  id: string;
  vendorId: string;
  invoiceNumber: string;      // unique per vendor
  invoiceDate: Date;
  dueDate: Date;
  currency: string;           // 'USD'
  totalCents: number;
  paidCents: number;          // increments as payments are applied
  status: 'received' | 'pending_approval' | 'approved' | 'scheduled' | 'paid' | 'disputed';
  poId?: string;              // linked purchase order for matching
  earlyDiscountRate?: number; // e.g., 0.02 for 2%
  earlyDiscountDeadline?: Date;
}

// Identify invoices where early payment saves money
function findEarlyPaymentOpportunities(
  invoices: ApInvoice[],
  todayDate: Date
): { invoiceId: string; discountCents: number; deadline: Date }[] {
  return invoices
    .filter(inv => inv.status === 'approved')
    .filter(inv => inv.earlyDiscountRate && inv.earlyDiscountDeadline! > todayDate)
    .map(inv => ({
      invoiceId: inv.id,
      discountCents: Math.round(inv.totalCents * inv.earlyDiscountRate!),
      deadline: inv.earlyDiscountDeadline!,
    }))
    .sort((a, b) => b.discountCents - a.discountCents);
}

Best Practices

最佳实践

  • Separate invoice approval from payment authorization — the person who approves an invoice should not be the person who initiates the payment; this is a basic internal control
  • Run payment runs on a fixed weekly cadence — predictable payment dates reduce bank fees, simplify cash forecasting, and vendors learn to expect payment on those days
  • Store original invoice PDFs for 7 years — attach the PDF to every bill in QuickBooks/BILL; required for tax audits and vendor disputes
  • Send remittance advice — when paying multiple invoices in one ACH batch, email the vendor a list of which invoices were paid and for what amounts so they can reconcile their AR
  • Lock invoice amounts after approval — never edit a bill's total after it's been approved; create a credit memo or debit memo for adjustments instead
  • 分离发票审批与付款授权——批准发票的人员不应是发起付款的人员；这是基本的内部控制措施
  • 固定每周进行付款操作——可预测的付款日期减少银行手续费，简化现金流预测，供应商也会习惯在这些日期收款
  • 将原始发票PDF保存7年——在QuickBooks/BILL中为每笔账单附加PDF；这是税务审计和供应商纠纷所需的凭证
  • 发送汇款通知——当在一个ACH批次中支付多笔发票时，向供应商发送电子邮件，列出已支付的发票及金额，以便他们对账应收账款
  • 批准后锁定发票金额——账单获批后切勿修改总金额；如需调整，请创建贷项通知单或借项通知单

Common Pitfalls

常见问题与解决方案

ProblemSolution
Duplicate invoice paymentsQuickBooks and BILL both alert on duplicate invoice numbers per vendor — enable these warnings and require staff to acknowledge them before saving
Early discount window missed because invoice sat in approval queueAdd a "discount deadline" badge in your approval tool; BILL shows this prominently; set escalation reminders 2 days before the discount expires
AP aging report shows negative balancesVendor credits and credit memos can create negative balances; ensure credits are applied against open invoices as part of your payment run
Vendor disputes payment amountAlways store the PO, goods receipt, and invoice together with your matching result; this is your paper trail for disputes
问题解决方案
重复支付发票QuickBooks和BILL都会针对同一供应商的重复发票编号发出提醒——启用这些提醒，并要求员工在保存前确认
因发票在审批队列中延误而错过提前折扣窗口期在审批工具中添加“折扣截止日期”标识；BILL会突出显示该信息；在折扣到期前2天设置升级提醒
AP账龄报告显示负余额供应商贷项和贷项通知单可能导致负余额；确保在付款操作中将贷项应用于未结发票
供应商对付款金额有异议始终将采购订单、收货单和发票与匹配结果一起存储；这是你处理纠纷的纸质凭证

Related Skills

相关技能

  • @vendor-management
  • @order-management-system
  • @returns-refund-policy
  • @vendor-management
  • @order-management-system
  • @returns-refund-policy