Back to Details

venmo-reconciler

Compare original and translation side by side

🇺🇸

Original

English
🇨🇳

Translation

Chinese

Venmo Reconciler

Venmo交易核对器

Overview

概述

Import and reconcile Venmo transaction exports, separating personal transfers from business income/expenses. Venmo mixes social payments with business transactions in a single feed — this skill classifies each transaction, flags ambiguous entries for review, and imports business-relevant transactions into Open Accountant.
导入并核对Venmo导出的交易记录，区分个人转账与商业收支。Venmo会将社交支付与商业交易混在同一个信息流中——本工具会对每笔交易进行分类，标记模糊条目以供审核，并将相关商业交易导入Open Accountant。

Wilson Tools Used

使用的Wilson工具

  • transaction_search
    — check for duplicates and cross-reference with bank imports
  • categorize
    — assign business categories to Venmo transactions
  • anomaly_detect
    — flag transactions that look personal in a business context (or vice versa)
  • export_transactions
    — export reconciled business transactions
  • transaction_search
    — 检查重复项并与银行导入记录交叉核对
  • categorize
    — 为Venmo交易分配商业类别
  • anomaly_detect
    — 标记在商业场景中看起来像个人交易的记录（反之亦然）
  • export_transactions
    — 导出已核对的商业交易

Column Mapping

列映射

Venmo CSV ColumnOpen Accountant FieldNotes
ID
reference_id
Venmo transaction ID for dedup
Datetime
date
Transaction timestamp
Note
description
User-entered payment note
From
description
(prefix)		Sender name
To
description
(prefix)		Recipient name
Amount (total)
amount
Signed amount (+ received, - sent)
Status
—Only import 
Complete
transactions
Type
—Payment, Charge, Transfer, etc.
Funding Source
notes
Venmo balance, bank, card
Venmo CSV列Open Accountant字段说明
ID
reference_id
Venmo交易ID，用于去重
Datetime
date
交易时间戳
Note
description
用户输入的付款备注
From
description
（前缀）		付款方名称
To
description
（前缀）		收款方名称
Amount (total)
amount
带符号金额（+ 收入，- 支出）
Status
—仅导入
Complete
（已完成）的交易
Type
—付款、收费、转账等
Funding Source
notes
Venmo余额、银行账户、银行卡

Workflow

工作流程

  1. Ask the user for the Venmo CSV file path.
  2. Parse the CSV and validate Venmo column headers.
  3. Filter by status: only 
    Complete
    transactions.
  4. Filter by type:
    • Import: 
      Payment
      (sent/received money for goods or services)
    • Import: 
      Charge
      (invoiced someone and they paid)
    • Skip: 
      Standard Transfer
      and 
      Instant Transfer
      (bank transfers, appear in bank import)
  5. Classify each transaction as personal or business:
    • Business signals: notes containing keywords like "invoice," "payment for," business name, service description, dollar amounts > $100
    • Personal signals: notes with emoji, first-name-only, social language ("thanks for dinner," "splitting rent")
    • Ambiguous: flag for manual review
  6. Present the classification for user confirmation:
    • Business transactions: import with appropriate categories
    • Personal transactions: skip (or import to a "Personal" category if user wants full tracking)
    • Ambiguous: ask user to classify each one
  7. Deduplicate against existing transactions using Venmo ID.
  8. Import confirmed business transactions.
  1. 向用户索要Venmo CSV文件路径。
  2. 解析CSV并验证Venmo列标题。
  3. 按状态筛选：仅保留
    Complete
    （已完成）的交易。
  4. 按类型筛选：
    • 导入：
      Payment
      （因商品或服务收付资金）
    • 导入：
      Charge
      （向他人开具发票并收到付款）
    • 跳过：
      Standard Transfer
      （标准转账）和
      Instant Transfer
      （即时转账）（银行转账记录会出现在银行导入记录中）
  5. 将每笔交易分类为个人或商业：
    • 商业信号：备注包含“invoice（发票）”、“payment for（付款用于）”、企业名称、服务描述、金额超过100美元等关键词
    • 个人信号：备注包含表情符号、仅名字、社交用语（如“thanks for dinner（感谢晚餐）”、“splitting rent（分摊房租）”）
    • 模糊条目：标记以供人工审核
  6. 向用户展示分类结果以确认：
    • 商业交易：按适当类别导入
    • 个人交易：跳过（若用户需要完整追踪，可导入至“个人”类别）
    • 模糊条目：请用户逐一分类
  7. 使用Venmo ID与现有交易去重。
  8. 导入已确认的商业交易。

Without Wilson

不使用Wilson的情况

To reconcile Venmo transactions manually:
手动核对Venmo交易：

Downloading from Venmo

从Venmo下载记录

  1. Log in at venmo.com (must use web, not the app)
  2. Go to Statements (under Settings, or navigate to venmo.com/account/statement)
  3. Select the date range (available in monthly chunks)
  4. Click Download CSV
  5. Alternative: In the Venmo app > Settings > Tax Documents for 1099-K if applicable (only if you exceed IRS thresholds: $5,000 in 2024+)
  1. 登录venmo.com（必须使用网页版，而非应用）
  2. 进入Statements（账单）（在设置下，或直接访问venmo.com/account/statement）
  3. 选择日期范围（仅支持按月下载）
  4. 点击Download CSV（下载CSV）
  5. 替代方式：若适用（仅当你超过IRS阈值：2024年及以后超过5000美元），在Venmo应用 > 设置 > **Tax Documents（税务文件）**中获取1099-K表单

Manual Reconciliation in a Spreadsheet

在电子表格中手动核对

  1. Open the CSV. Venmo CSVs have some quirks:
    • The first few rows may be metadata — delete them so your header row is the first row.
    • Amounts may be formatted as 
      + $50.00
      or 
      - $25.00
      with spaces. Clean with Find & Replace: remove 
      $
      , 
      +
      , and spaces, then convert the column to Number format.
  2. Filter out transfers: Remove rows where Type is "Standard Transfer" or "Instant Transfer."
  3. Add a "Classification" column with values: 
    Business
    , 
    Personal
    , 
    Review
    .
  4. Classify by keyword search: 
    =IF(OR(
  REGEXMATCH(Note,"(?i)invoice|payment for|consulting|freelance|order|service"),
  ABS(Amount)>100
), "Business",
IF(OR(
  REGEXMATCH(Note,"(?i)dinner|lunch|drinks|rent|split|birthday|thanks"),
  LEN(Note)<10
), "Personal",
"Review"))
  5. Manual review: Go through "Review" rows and classify each one.
  6. Business summary: 
    Business Income:   =SUMIFS(Amount, Classification, "Business", Amount, ">0")
Business Expenses: =ABS(SUMIFS(Amount, Classification, "Business", Amount, "<0"))
  7. Tax note: If your Venmo business income exceeds $5,000/year (2024 threshold), Venmo issues a 1099-K. Your records should reconcile with this form.
  1. 打开CSV。Venmo的CSV有一些特殊之处：
    • 前几行可能是元数据——删除这些行，使标题行成为第一行。
    • 金额格式可能为
      + $50.00
      或
      - $25.00
      并包含空格。使用查找和替换清理：移除
      $
      、
      +
      和空格，然后将该列转换为数字格式。
  2. 过滤转账记录：删除Type（类型）为“Standard Transfer（标准转账）”或“Instant Transfer（即时转账）”的行。
  3. 添加“分类”列，取值为：
    Business（商业）
    、
    Personal（个人）
    、
    Review（审核）
    。
  4. 通过关键词搜索分类： 
    =IF(OR(
  REGEXMATCH(Note,"(?i)invoice|payment for|consulting|freelance|order|service"),
  ABS(Amount)>100
), "Business",
IF(OR(
  REGEXMATCH(Note,"(?i)dinner|lunch|drinks|rent|split|birthday|thanks"),
  LEN(Note)<10
), "Personal",
"Review"))
  5. 人工审核：查看“Review（审核）”行并逐一分类。
  6. 商业交易汇总： 
    Business Income:   =SUMIFS(Amount, Classification, "Business", Amount, ">0")
Business Expenses: =ABS(SUMIFS(Amount, Classification, "Business", Amount, "<0"))
  7. 税务提示：若你的Venmo商业年收入超过5000美元（2024年阈值），Venmo会出具1099-K表单。你的记录应与该表单一致。

Reconciliation Tips

核对技巧

  • Cross-reference Venmo transfers to your bank account with your bank statement. The "Standard Transfer" amounts in Venmo should match deposits in your bank.
  • If you use Venmo for Business (separate business profile), those transactions are pre-classified — export them separately.
  • 将Venmo至银行账户的转账记录与银行对账单交叉核对。Venmo中的“Standard Transfer（标准转账）”金额应与银行存款金额匹配。
  • 若你使用Venmo for Business（独立商业账户），这些交易已预先分类——请单独导出。

Important Notes

重要提示

  • Venmo personal vs. business classification is a best-effort heuristic. Always review the results.
  • Venmo notes are user-entered free text and often contain emoji, jokes, or vague descriptions. Categorization accuracy depends on note quality.
  • The IRS reporting threshold for payment apps is $5,000 for 2024 and later tax years. If you receive business payments via Venmo above this threshold, you'll receive a 1099-K.
  • Venmo "Standard Transfer" to your bank takes 1-3 business days. "Instant Transfer" is immediate but has a fee. Neither should be imported as revenue — they're just moving money to your bank.
  • If you use both Venmo personal and Venmo for Business profiles, export and import them separately to avoid mixing.
  • Venmo CSV downloads are only available through the website, not the mobile app.
  • Venmo个人与商业交易的分类是基于启发式规则的最佳尝试。请务必审核结果。
  • Venmo备注是用户输入的自由文本，通常包含表情符号、玩笑或模糊描述。分类准确性取决于备注质量。
  • 2024年及以后纳税年度，支付应用的IRS申报阈值为5000美元。若你通过Venmo收到的商业付款超过此阈值，将收到1099-K表单。
  • Venmo“Standard Transfer（标准转账）”至银行账户需1-3个工作日。“Instant Transfer（即时转账）”即时到账但需收取手续费。两者均不应作为收入导入——它们只是将资金转移至你的银行账户。
  • 若你同时使用Venmo个人账户和Venmo for Business账户，请分别导出和导入，避免混合。
  • Venmo CSV仅可通过网站下载，无法通过移动应用下载。",