Imports PayPal CSV transaction exports, splitting fees into separate expense rows, handling refunds and currency conversions. Filters completed payments, deduplicates by ID, and maps to accounting format.
npx claudepluginhub openaccountant/skillsThis skill uses the workspace's default tool permissions.
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.
Provides UI/UX resources: 50+ styles, color palettes, font pairings, guidelines, charts for web/mobile across React, Next.js, Vue, Svelte, Tailwind, React Native, Flutter. Aids planning, building, reviewing interfaces.
Fetches up-to-date documentation from Context7 for libraries and frameworks like React, Next.js, Prisma. Use for setup questions, API references, and code examples.
Explores codebases via GitNexus: discover repos, query execution flows, trace processes, inspect symbol callers/callees, and review architecture.
Share bugs, ideas, or general feedback.
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