Margin per channel, returns and PSP costs in view with AI

5 min read

Your own shop, Bol and an extra marketplace: revenue grows, your overview does not. Here is how to extract margin per channel, returns and PSP costs from your bookkeeping with AI.

Drie kanalen voeden een staafdiagram: marge per verkoopkanaal

Your own webshop, selling through Bol and since this year an international marketplace as well. Orders keep coming in and the connectors record everything neatly in Exact Online. Still, one question stays open every month: which channel actually makes money, and where does profit leak away to returns and transaction costs?

These days you can answer that question without any export work. Connect your AI assistant to your administration and ask, in plain English, for your margin per channel, your returns trend or your payment costs per month. Why is that possible now while your dashboards leave it out? Here is how it works.

Why you never see your margin per channel on one screen

The data has been there all along. Through the Shopify connector and the Bol connector every order lands automatically in Exact Online, together with the customer, items and stock. So your bookkeeping is in fact omnichannel, even if your reports are not.

And that is where it pinches. The standard reports show totals: revenue per month, a profit and loss statement, a balance sheet. Fine for the accountant, but your questions are different. What do I keep on a marketplace order? Which items come back most often? And how much do I actually pay my payment provider on a yearly basis?

Anyone who wants to know this exports to Excel, filters by journal and pastes cost prices next to it. You do that thoroughly once. After that, the issues of the day take over.

Ask the margin question in plain English

With Exact AI Connect you connect your own AI assistant, Claude, ChatGPT, Copilot, Gemini or Perplexity, directly to Exact Online. For the big questions the connector uses an analysis function that can handle your entire administration:

  • revenue and margin per item, including top-10s
  • costs per supplier and per cost account
  • trends per month or quarter, even across several years

And so channel questions too. If each connector records its orders recognisably, for example in its own journal or on its own sales relation, the AI groups your revenue per channel and sets the costs next to it. That way you see in a single answer that your own shop runs a different margin than the marketplace, and whether that gap is growing or shrinking.

The limit is honest: the AI analyses what is recorded in Exact Online. It does not look directly into your webshop or your marketplace account, and whatever is not in your administration does not exist for the analysis. In practice that tends to work as an advantage, because you force yourself to record all channels neatly, and then one question calculates everything.

Track down the silent profit leaks: PSP costs and returns

PSP costs are the transaction costs that your payment provider withholds per order, think of the fee per iDEAL payment or credit card transaction. Per order it amounts to little. Added up it is a serious cost item that rarely appears on a dashboard. If you record those costs on a separate general ledger account, the AI adds them up per month and sets them next to your revenue in that same month. If your payment costs rise faster than your revenue, now you do see it.

Returns work the same way. They land in your administration as credit notes, and you can analyse those: the number and amount per month, the trend over the year, and which items get credited most often. An item that sells well but keeps coming back cuts into your margin harder than you think.

That leaves the reconciliation: matching received payments to the right outstanding items. This can be done through the AI connector too. You ask which invoices match a payment and reconcile them after you confirm. If you process large volumes of webshop sales, you automate this fully with the Reconciliation module, which supports all major payment providers.

Stay in control: confirmation, permissions and security

An AI with access to your bookkeeping calls for clear agreements, and those are built into the connector. Analyses are read actions. If the AI wants to create or change something, such as during reconciliation, there is always a confirmation step first: you see what is about to happen and approve it. You can also restrict write permissions per role or set the connector to read-only entirely, with a daily limit as an extra safeguard.

Exact AI Connect is ISO 27001 certified and independently pentested, and we are an official Exact Online partner. You try it free for 30 days with all features and up to 3 administrations; after that the subscription can be cancelled monthly.

Example prompts for your webshop administration

Copy these questions into your connected AI assistant and adjust them to your own setup:

Give me the turnover per journal for this quarter, so I can compare my sales channels side by side.

What are the 10 items with the highest turnover this year, and what is the margin per item?

Add up the costs on the general ledger account for payment provider fees per month and place them next to the turnover for the same month.

How many credit notes did we book this year per month, and what is the total amount? Show the trend.

Which suppliers cost me more this year than last year? Sort by the difference.

Ready to get started? Start your free trial →

Frequently asked questions

Yes, as long as each channel is booked recognisably in your records, for example in its own journal or on its own sales relationship. The AI then groups revenue and costs per channel and shows the trend over longer periods. For these analyses you use the free trial period or the analytics version of Exact AI Connect.

No. The AI reads your bookkeeping, not your sales platforms. The webshop and marketplace connectors make sure orders end up in Exact Online automatically, after which the AI analyses what is booked there. Whatever is not booked is therefore not included in the calculation.

Essentials costs €29 and Analytics €79 per user per month, with 1 administration included and cancellable monthly. For channel, margin and trend analyses you need Analytics or the trial period. In terms of usage you have plenty of room: 5,000 requests per month with Essentials and 15,000 with Analytics.

Yes, the connector is built for that: ISO 27001 certified and independently pentested. With Essentials we do not store any financial data, every query goes straight to Exact Online. With Analytics the large analyses run on a secured copy of your administration within the EU, which we delete as soon as you stop.