Docs/Guides
Stripe Import
Bring your Stripe activity into your books, tied to Stripe to the cent. Free.
Your Stripe balance should match your books. This import makes sure it does. It books your charges, Stripe's fees, refunds and payouts. Then it checks that the Stripe account in your books moved by exactly what Stripe says. If it doesn't, nothing is written.
It's free on every plan.
Step 1: Export your activity from Stripe
- In the Stripe Dashboard, open Reports, then Balance (dashboard.stripe.com/reports/balance).
- Pick the date range. Start the day after your last import. Stripe's reports only include whole days.
- In the Balance change from activity section, click Export, choose CSV, then Itemized.
- In the Payouts section, click Export, choose CSV, then Itemized. Payouts are their own section, so this is a second file.
Optional: when you export, add the source_id column. It lets the import match each charge to the same charge anywhere else in your books.
Stripe's guide to this report: Balance summary report.
Step 2: Ask your AI
With Solarium connected to your AI (see Use With AI), attach both files and ask:
> Import these Stripe exports into Solarium. Show me the preview first.
It asks which accounts to use: your Stripe account, the bank Stripe pays out to, your sales account and your fees account. Then it shows the preview.
Step 3: Check the preview, then book it
The preview lists every transaction it would book and ends with one line:
> Stripe Oct 1 To Oct 15: Books 562.68, Stripe's Net 562.68, Difference 0.00
If the difference is 0.00, tell it to go ahead. The new transactions land in Review. Confirm them there to post them.
What it books
| Stripe activity | In your books |
|---|---|
| A charge | Sales, into your Stripe account |
| Stripe's processing fees | One fee per day, the exact sum of that day's charge fees |
| Stripe's own fees (billing, Connect) | Fees, with the sales tax Stripe charges as an input tax credit |
| A refund | Taken off sales |
| A payout | Stripe to your bank. If your bank feed already has it, it's linked, not booked twice. |
| A Connect transfer | The account you name for payouts to connected accounts |
What it checks
- Nothing twice. Anything already in your books is skipped, from any source. That includes a charge entered by hand and a payout already on your bank feed.
- Fees tie to charges. Each day, your charges minus their fees must equal what Stripe kept.
- Every charge arrives. Each day's charges in your books must match Stripe's count and total.
- Stripe ties. The Stripe account in your books must move by exactly Stripe's net for those days.
If any check fails, it tells you why and writes nothing.
Charges without a customer go to your sales account. If you've confirmed a charge of the same amount before, it uses that one's category and tax.
The older balance history export works too.