Connectors

/

Stripe

/

Book Stripe fees to Rillet
Write
Cross-Connector

Book Stripe processing fees to Rillet every period

For finance teams who want Stripe fees recorded in Rillet as balanced journal entries by asking their AI assistant, with no period booked twice.

Try PopdockAI free
Get a live demo
Book Stripe fees to Rillet
Book Stripe fees from 1 to 30 September to Rillet, debit 6150 and credit 1210.
Stripe fees for 1 to 30 September come to 2,418.06 USD and 312.40 EUR, and the period is not booked yet. - USD entry: debit 6150, credit 1210, 2,418.06 - EUR entry: debit 6150, credit 1210, 312.40 - Fee refunds: 41.20 USD deducted Shall I book these two entries?
Stripe
Sample figures. Your results come from your own account.
rillet-get-accounts
rillet-get-journal-entries
stripe-get-balance-transaction
rillet-add-journal-entry

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Stripe

Stripe
Run it on your own Stripe data.

Connect Stripe, pick your AI tool and paste the prompt.

Try PopdockAI free

The problem

Stripe fees never arrive as bills in Rillet

Stripe takes its fees before paying out, so they never arrive as bills in Rillet. Booking them means totalling fees across balance transactions per currency, allowing for fee refunds and making sure the same period is not booked twice.

Without PopdockAI

  • Export balance transactions for the period
  • Total fees per currency, minus fee refunds
  • Check the period has not been booked already
  • Write a journal entry for each currency

With PopdockAI

  • Both accounts are checked and past entries looked for
  • Fees are summed per currency, with fee refunds as reductions
  • Sources are shown by transaction type
  • One balanced entry per currency is booked after you confirm

The prompt

Use this prompt

Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.

Prompt
**Objective:** Total the Stripe fees on balance transactions from {from-date} to {to-date} and, after the user confirms, book them in Rillet as one journal entry per currency: debit {fee-account-code}, credit {clearing-account-code}.

**Step 1: Check the accounts**

Call `rillet-get-accounts` with `account-code` = {fee-account-code}, then again with `account-code` = {clearing-account-code}. If either is missing, say which and stop.

**Step 2: Check it has not been booked**

Call `rillet-get-journal-entries` (no filters) and look for an entry named Stripe fees {from-date} to {to-date}. If one exists, report its journal-id and date and stop.

**Step 3: Total the fees**

Call `stripe-get-balance-transaction` with `created.from` = {from-date} and `created.to` = {to-date}. Sum the fee field per currency, counting negative fees (fee refunds) as reductions. Also count the transactions per type so the user can see where the fees came from.

**Step 4: Preview and confirm**

For each currency with a non-zero total, show the proposed entry: name, date {to-date}, line 1 debit {fee-account-code} for the total, line 2 credit {clearing-account-code} for the same total, plus the per-type counts. Ask the user to confirm. Write nothing until they say yes.

**Step 5: Book**

For each confirmed currency call `rillet-add-journal-entry` with name = Stripe fees {from-date} to {to-date} (add the currency code when there is more than one), date = {to-date}, currency in upper case, line 1 = debit {fee-account-code}, line 2 = credit {clearing-account-code}, both lines for the total in that currency, and a description of Stripe processing fees. Use the side values the tool's schema lists. Debits must equal credits. If the total is negative, swap the sides and say so.

**Step 6: Confirm**

Call `rillet-get-journal-entries` again and check each entry is present by name. Report its journal-id.

**Rules & Guidelines:**

* `stripe-get-balance-transaction` is on the stripe server and is read-only. The other tools named here are on the rillet server.
* The only tool that may write is `rillet-add-journal-entry`, and only after the Step 4 confirmation.
* Do not call `rillet-update-journal-entry` or `rillet-add-account`.

**Validation:**

* If Stripe returns no balance transactions or every fee is zero, say there is nothing to book and stop.
* Stripe may return amounts in the smallest currency unit. If fees look 100 times too large for the transaction amounts, divide by 100 and say so in the preview.
* If a tool cannot be found, name the server it belongs to (rillet or stripe) and stop.

Who it's for

One answer, three teams that use it

General ledger accountants

Book fees without the spreadsheet

Balanced entries per currency come ready to confirm, with fee refunds already netted.

Book Stripe fees for October to Rillet, debit 6150 and credit 1210.

Controllers

Close the month with fees included

A check for an existing entry stops the same period from being booked twice.

Is there already a Stripe fee entry in Rillet for September? If not, book it.

Finance managers

Understand processing costs

Fees shown by transaction type tell you where processing costs come from.

Show last quarter's Stripe fees per currency and type, then book them to Rillet.

How it works

What PopdockAI does when you ask

You give a period and the accounts, and your AI assistant totals Stripe fees and prepares the journal entries for Rillet. Nothing is booked until you confirm, and no period is booked twice.

01

Ask

You give a period and the fee and clearing accounts.

Your AI tool

02

Check

It confirms both accounts exist and the period is not already booked.

rillet-get-accounts
rillet-get-journal-entries

03

Total

It sums Stripe fees per currency, counting fee refunds as reductions.

stripe-get-balance-transaction

04

Confirm

You preview each journal entry, then it is booked and read back.

Your AI tool

What PopdockAI provides

The tools behind the answer

Ready made tools for Stripe and one secure connection to your AI tool. No code, no exports.

get-data

rillet-get-accounts

Returns chart of accounts entries (code, name, type, status) from Rillet.
get-data

rillet-get-journal-entries

Returns journal entry headers (name, date, currency, related record) from Rillet.
get-data

stripe-get-balance-transaction

Returns balance transactions (type, amount, fee, net, availability date) from Stripe.
run-action

rillet-add-journal-entry

Creates a manual journal entry in Rillet with up to four lines. Debits must equal credits; fill at least lines 1 and 2.
Read only.Nothing in Stripe Changes

This report is built from Get data tools only. PopdockAI applies the row, field and parameter rules your admin sets, and every query is written to the audit trail.

How Popdock AI secures your data

The outcome

Fees on the books every period, never twice

Try PopdockAI free
Get a live demo

Related use cases

More ways to put this data to work

All Ramp use cases

One prompt template with infinite possibilities.

‍

Your AI assistant adapts its approach, tone, and capabilities to match each unique context while you maintain a single, manageable workflow.

Join forward-thinking companies that are transforming their operations with intelligent, secure AI automation.

Try PopdockAI Free
See Documentation