Stripe Import

Overview

Import transaction data from Stripe CSV exports into Open Accountant. Handles charges (revenue), Stripe processing fees, and refunds as separate line items. Payouts are skipped since they appear in your bank import and would cause double-counting.

Wilson Tools Used

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

Column Mapping

Stripe CSV Column	Open Accountant Field	Notes
`id`	`reference_id`	Stripe charge ID (ch_xxx)
`Created (UTC)`	`date`	Transaction date
`Description`	`description`	Customer-facing description
`Amount`	`amount`	Gross charge amount (positive = income)
`Fee`	`amount` (separate row)	Stripe processing fee (negative = expense)
`Net`	—	Calculated field, not stored directly
`Currency`	`currency`	3-letter ISO code
`Status`	—	Only import `succeeded` charges
`Customer Email`	`notes`	Optional, stored in notes

Workflow

Ask the user for the Stripe CSV file path.
Parse the CSV and validate expected Stripe column headers.
Filter rows:
- Import: rows where
```
Type
```
  is
```
charge
```
  and
```
Status
```
  is
```
succeeded
```
- Import: rows where
```
Type
```
  is
```
refund
```
- Skip: rows where
```
Type
```
  is
```
payout
```
  or
```
transfer
```
  (these appear in bank imports)
- Skip: rows where
```
Status
```
  is
```
failed
```
  or
```
pending
```
For each charge, create two transactions:
- Revenue: positive amount from the
```
Amount
```
  column, category "Revenue:Stripe"
- Fee: negative amount from the
```
Fee
```
  column, category "Fees:Payment Processing"
For refunds, create a negative revenue transaction with category "Revenue:Refunds"
Deduplicate using the Stripe charge ID (
```
id
```
column) as the reference.
Preview the import summary: total charges, total fees, total refunds, net revenue.
Insert transactions and confirm.

Without Wilson

To work with Stripe exports manually:

Downloading from Stripe

Log in to dashboard.stripe.com
Go to Payments (left sidebar)
Click Export (top right of the payments list)

Select date range and columns:

Recommended:

id

Created (UTC)

Description

Amount

Fee

Net

Currency

Status

Type

Customer Email

Choose CSV format and download

Manual Processing in a Spreadsheet

Open the CSV in Google Sheets or Excel.
Filter out non-succeeded: Data > Filter > Status column > select only "succeeded"
Remove payouts: Filter Type column > deselect "payout" and "transfer"
Create revenue rows:
- Column for category: set to "Revenue:Stripe" for all charge rows
- Amount column already has the gross charge amount
Create fee rows: Add rows for each charge with:
- Same date
- Description: "Stripe fee — [original description]"
- Amount: negative value from the Fee column (e.g., if Fee = 2.90, enter -2.90)
- Category: "Fees:Payment Processing"
Handle refunds: Refund rows should have negative amounts in the Amount column. Set category to "Revenue:Refunds"

Summary formulas:

Gross Revenue:    =SUMIFS(Amount, Type, "charge", Status, "succeeded")
Total Fees:       =SUMIFS(Fee, Type, "charge", Status, "succeeded")
Total Refunds:    =ABS(SUMIFS(Amount, Type, "refund"))
Net Revenue:      =GrossRevenue - TotalFees - TotalRefunds
Effective Rate:   =TotalFees / GrossRevenue * 100

Reconcile with bank: Your bank payout amounts should equal the sum of
```
Net
```
column values between payout dates.

Important Notes

Stripe amounts are in the smallest currency unit in the API but in standard units in CSV exports (e.g., $10.00, not 1000).
Multi-currency: if you accept payments in multiple currencies, each currency is imported with its original amount. Wilson does not perform currency conversion.
Stripe fee percentage is typically 2.9% + $0.30 per transaction but varies by plan. The actual fee is in the CSV.
Do not import payouts. Payouts are the transfer from Stripe to your bank account. These appear in your bank statement import and importing them from Stripe would double-count the money.
Connect/platform charges: if you use Stripe Connect, application fees appear as separate line items. Import these under "Fees:Platform" if applicable.

stripe-import

NPX Install

Tags

SKILL.md Content