Stripe

List this business's connected payment provider accounts (Stripe, Revolut, etc. — owner-manual integrations, not Stripe Connect hosted checkout). Returns id, provider, display name, mode (test/live), and status - never secret/API-key values. Call this first to get paymentProviderAccountId, required by every other Stripe tool.

Pull fresh fee data from Stripe's LIVE API for one account and month - scans every balance transaction in the period, upserts stripe_fee_items (idempotent, safe to re-run), and derives/updates the period's settlement (gross sales, refunds, fees, expected payout). May take a few seconds. Requires draft_write or full_post permission tier.

Pull fresh payout data from Stripe's LIVE API for one account and month - upserts stripe_payouts and stripe_payout_items (idempotent, safe to re-run). May take a few seconds. Requires draft_write or full_post permission tier.

List monthly Stripe fee summaries (one per account per month) - total fees, reverse-charge VAT, and posting status (draft/posted/needs_review/confirmed).

List the individual fee line items behind one monthly fee summary (from list_stripe_fee_summaries).

Full reconciliation detail for one account+month: gross sales, refunds, disputes, Stripe fees, reverse-charge VAT, expected payout, and which journal entries (if any) have posted the sale/fee legs. get_posting_queue already surfaces settlements needing posting with a ready debit/credit template - use this tool for direct lookup of a specific period instead.

List Stripe payouts (transfers to the business's bank account) - amount, arrival date, and whether it's been matched to a bank transaction yet.

List the individual payments/fees/refunds/adjustments that make up one Stripe payout (from list_stripe_payouts).

List recent Stripe Connect invoice payments (hosted checkout, not the fee/payout reconciliation tables above) for this business, each already resolved to its ksiegai invoice number and customer name where applicable - use this to answer 'which invoice did this Stripe payment pay' or 'has invoice X been paid via Stripe'. Most recent 20.

Bank-transfer matching: for Stripe payouts still awaiting a match (or one specific payoutDbId), looks for a bank_transactions row within ±4 days of the payout's arrival date with a matching amount and links them (bank_match_status -> 'matched'). Requires draft_write or full_post permission tier.

Auto-classify unclassified expense bank transactions that look like Stripe transfers (counterparty/description containing 'stripe') - only acts for VAT-exempt business profiles (returns classified:0 otherwise, by design). Requires draft_write or full_post permission tier.

Manually confirm a Stripe payout (bank_match_status -> 'matched' if bankTransactionId given, else 'manual_confirmed') and record its financial_event. This is a bookkeeping record, not a journal entry - still use draft_journal_entry/post_journal_entry separately for the actual GL posting. Requires draft_write or full_post permission tier.

After posting a journal entry for a Stripe settlement's sale or fee leg (via draft_journal_entry + post_journal_entry, using get_posting_queue's template), call this to record the link and update the settlement's status - otherwise it keeps reappearing in get_posting_queue forever. A settlement can need both a sale and a fee entry; status only becomes 'posted' once both applicable legs are linked.

After posting a journal entry for a Stripe monthly fee summary (via draft_journal_entry + post_journal_entry), call this to mark the summary as posted and record the link.