en un clic
Import PayPal CSV exports with fee, refund, and currency handling.
npx skills add https://github.com/openaccountant/skills --skill paypal-importCopiez et collez cette commande dans Claude Code pour installer le skill
Import PayPal CSV exports with fee, refund, and currency handling.
npx skills add https://github.com/openaccountant/skills --skill paypal-importCopiez et collez cette commande dans Claude Code pour installer le skill
Calculate break-even revenue by separating fixed and variable costs.
Project future cash flow using historical trends and recurring patterns.
Analyze revenue and costs per client to find your most profitable accounts.
Monitor 1099 contractor payments and flag $600 threshold.
Track unpaid invoices by age bucket and flag overdue payments.
Run a monthly bookkeeping close checklist with reconciliation.
| name | paypal-import |
| description | Import PayPal CSV exports with fee, refund, and currency handling. |
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.
transaction_search — check for duplicates against existing transactionscategorize — assign categories to imported PayPal transactionsexport_transactions — export reconciled PayPal data| 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 |
Payment Received, Mobile Payment, Website Payment, Invoice ReceivedRefund, Reversal, ChargebackSubscription PaymentTransfer to Bank, Bank Deposit (appears in bank import)Currency Conversion (handled as part of the parent transaction)Authorization, Pending, Temporary HoldCompleted transactions.To work with PayPal exports manually:
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