paypal-import

Compare original and translation side by side

🇺🇸

Original

English

🇨🇳

Translation

Chinese

PayPal Import

PayPal 导入

Overview

概述

Import transaction data from PayPal CSV exports. Handles payments received, fees, refunds, and currency conversions. PayPal CSVs include many transaction types — this skill filters to financially meaningful entries and maps them to Open Accountant's format.

从PayPal CSV导出文件导入交易数据。支持处理收到的付款、手续费、退款以及货币转换。PayPal CSV包含多种交易类型——本Skill会筛选出具有财务意义的条目，并将其映射为Open Accountant的格式。

Wilson Tools Used

使用的Wilson工具

```
transaction_search
```
— check for duplicates against existing transactions
```
categorize
```
— assign categories to imported PayPal transactions
```
export_transactions
```
— export reconciled PayPal data

```
transaction_search
```
—— 对照现有交易检查重复项
```
categorize
```
—— 为导入的PayPal交易分配分类
```
export_transactions
```
—— 导出已对账的PayPal数据

Column Mapping

列映射

PayPal CSV Column	Open Accountant Field	Notes
`Date`	`date`	Transaction date (MM/DD/YYYY format)
`Time`	—	Not stored, date is sufficient
`Name`	`description`	Counterparty name
`Type`	—	Used for filtering (see workflow)
`Status`	—	Only import `Completed` transactions
`Gross`	`amount`	Transaction amount before fees
`Fee`	`amount` (separate row)	PayPal fee (negative = expense)
`Net`	—	Calculated, not stored directly
`Transaction ID`	`reference_id`	PayPal transaction ID for dedup
`Currency`	`currency`	3-letter ISO code
`Subject` or `Item Title`	`notes`	Optional detail

PayPal CSV列	Open Accountant字段	说明
`Date`	`date`	交易日期（MM/DD/YYYY格式）
`Time`	—	不存储，日期信息已足够
`Name`	`description`	交易对方名称
`Type`	—	用于筛选（见工作流）
`Status`	—	仅导入 `Completed` （已完成）交易
`Gross`	`amount`	扣除手续费前的交易金额
`Fee`	`amount` （单独行）	PayPal手续费（负值表示支出）
`Net`	—	计算得出，不直接存储
`Transaction ID`	`reference_id`	PayPal交易ID，用于去重
`Currency`	`currency`	3位ISO代码
`Subject` 或 `Item Title`	`notes`	可选详情

Workflow

工作流

Ask the user for the PayPal CSV file path.
Parse the CSV (PayPal uses comma-separated with quoted fields).

Filter by transaction type:

Import:

Payment Received

Mobile Payment

Website Payment

Invoice Received

Import:
```
Refund
```
,
```
Reversal
```
,
```
Chargeback
```
Import:
```
Subscription Payment
```
Skip:
```
Transfer to Bank
```
,
```
Bank Deposit
```
(appears in bank import)
Skip:
```
Currency Conversion
```
(handled as part of the parent transaction)
Skip:
```
Authorization
```
,
```
Pending
```
,
```
Temporary Hold
```

Filter by status: only
```
Completed
```
transactions.
For each payment received, create two transactions:
- Revenue: gross amount (positive), category "Revenue:PayPal"
- Fee: fee amount (negative), category "Fees:Payment Processing"
For refunds/reversals, create a negative revenue transaction.
For currency conversions: attach the conversion rate to the parent transaction notes.
Deduplicate using PayPal Transaction ID.
Preview and confirm import.

向用户索要PayPal CSV文件路径。
解析CSV（PayPal使用带引号字段的逗号分隔格式）。
按交易类型筛选：
- 导入：
```
Payment Received
```
  （收到付款）、
```
Mobile Payment
```
  （移动支付）、
```
Website Payment
```
  （网站支付）、
```
Invoice Received
```
  （收到发票付款）
- 导入：
```
Refund
```
  （退款）、
```
Reversal
```
  （撤销）、
```
Chargeback
```
  （拒付）
- 导入：
```
Subscription Payment
```
  （订阅付款）
- 跳过：
```
Transfer to Bank
```
  （转账至银行）、
```
Bank Deposit
```
  （银行存款）（会在银行导入中出现）
- 跳过：
```
Currency Conversion
```
  （货币转换）（作为父交易的一部分处理）
- 跳过：
```
Authorization
```
  （授权）、
```
Pending
```
  （待处理）、
```
Temporary Hold
```
  （临时冻结）
按状态筛选：仅保留
```
Completed
```
（已完成）交易。
对于每笔收到的付款，创建两笔交易：
- 收入：总金额（正值），分类为"Revenue:PayPal"
- 手续费：手续费金额（负值），分类为"Fees:Payment Processing"
对于退款/撤销交易，创建一笔负收入交易。
货币转换：将转换率附加到父交易的备注中。
使用PayPal交易ID去重。
预览并确认导入。

Without Wilson

不使用Wilson的手动操作

To work with PayPal exports manually:

手动处理PayPal导出文件的步骤：

Downloading from PayPal

从PayPal下载文件

Log in at paypal.com
Go to Activity (top navigation)
Click Statements > Activity download (or Reports > Activity download in business accounts)
Select date range (max 1 year at a time)
File type: CSV
Click Download
For business accounts: Reports > All reports > Transactions > select date range > Download CSV

登录paypal.com
进入Activity（活动）（顶部导航栏）
点击Statements（报表）> Activity download（活动记录下载）（企业账户为Reports（报告）> Activity download（活动记录下载））
选择日期范围（每次最多1年）
文件类型：CSV
点击Download（下载）
企业账户操作：Reports（报告）> All reports（所有报告）> Transactions（交易记录）> 选择日期范围 > Download CSV（下载CSV）

Manual Processing in a Spreadsheet

在电子表格中手动处理

Open the CSV. PayPal CSVs use the encoding Windows-1252 — if you see garbled characters, re-open with UTF-8 encoding.
Filter Status: Keep only "Completed" rows.
Filter Type: Remove "Transfer to Bank," "Bank Deposit," "Currency Conversion," and "Authorization" rows.
Split revenue and fees:
- For each payment, the Gross column is revenue and the Fee column is the PayPal fee.
- Create a new row for each fee with the negative fee amount.
Handle refunds: Refund rows already have negative Gross amounts. Keep as-is.
Currency conversion: If you received a payment in EUR but your account is in USD, PayPal creates two rows — one in EUR and one with the USD conversion. Use the USD row and note the original currency.

Summary formulas:

Gross Revenue:  =SUMIFS(Gross, Type, "Payment Received", Status, "Completed")
Total Fees:     =ABS(SUMIFS(Fee, Type, "Payment Received", Status, "Completed"))
Total Refunds:  =ABS(SUMIFS(Gross, Type, "Refund", Status, "Completed"))
Net Revenue:    =GrossRevenue - TotalFees - TotalRefunds
Fee Rate:       =TotalFees / GrossRevenue * 100

打开CSV文件。PayPal CSV使用Windows-1252编码——如果出现乱码，重新用UTF-8编码打开。
筛选状态：仅保留"Completed"（已完成）行。
筛选类型：移除"Transfer to Bank"（转账至银行）、"Bank Deposit"（银行存款）、"Currency Conversion"（货币转换）和"Authorization"（授权）行。
拆分收入和手续费：
- 对于每笔付款，Gross（总额）列是收入，Fee（手续费）列是PayPal手续费。
- 为每笔手续费创建新行，金额为手续费的负值。
处理退款：退款行的Gross（总额）列已为负值，直接保留即可。
货币转换：如果您收到欧元付款但账户币种为美元，PayPal会生成两行记录——一行欧元记录，一行美元转换记录。使用美元记录，并备注原始币种。

汇总公式：

Gross Revenue:  =SUMIFS(Gross, Type, "Payment Received", Status, "Completed")
Total Fees:     =ABS(SUMIFS(Fee, Type, "Payment Received", Status, "Completed"))
Total Refunds:  =ABS(SUMIFS(Gross, Type, "Refund", Status, "Completed"))
Net Revenue:    =GrossRevenue - TotalFees - TotalRefunds
Fee Rate:       =TotalFees / GrossRevenue * 100

Reconciliation

对账

PayPal transfers to your bank should match the sum of Net amounts between transfer dates.
If they don't match, check for held funds, disputes, or currency conversion differences.

PayPal转账至银行的金额应与转账日期之间的Net（净额）总和一致。
如果不一致，请检查冻结资金、纠纷或货币转换差异。

Important Notes

重要说明

PayPal CSV encoding can cause issues. If the file won't parse, try saving as UTF-8 first.
PayPal date format is MM/DD/YYYY (US accounts) or DD/MM/YYYY (international). Wilson auto-detects based on account locale.
"General Payment" type in PayPal can be either sent or received — check the sign of the Gross amount.
PayPal business accounts have more detailed CSVs than personal accounts. The column mapping above covers both.
Do not import "Transfer to Bank" rows — these are the PayPal-to-bank transfers that appear in your bank statement.

PayPal CSV编码可能导致问题。如果文件无法解析，先尝试另存为UTF-8格式。
PayPal日期格式为MM/DD/YYYY（美国账户）或DD/MM/YYYY（国际账户）。Wilson会根据账户区域设置自动检测。
PayPal中的"General Payment"（普通付款）类型可能是付款或收款——请检查Gross（总额）的正负号。
PayPal企业账户的CSV比个人账户更详细。上述列映射适用于两种账户类型。
请勿导入"Transfer to Bank"（转账至银行）行——这些是PayPal转至银行的记录，会出现在您的银行对账单中。