Engrana manual

Contents › Sales

Marketplace settlements

In short

Marketplace payouts (for example, Allegro) for sold orders: how much reached the bank, what was withheld (commission, shipping, refunds) and which orders the payout settles. At the top — how much the marketplace owes us or we owe it.

Why it matters

  • Settle order payments received through the marketplace and reconcile them with the bank.
  • Record the marketplace commission: deductions go to expenses by category or against its monthly invoice.
  • Revalue the marketplace's balance in another currency at year end.

Who can

Finance, the branch manager and the administrator.

How to do it

  1. Record payout. Marketplace payout number, received on, period, amount received in bank and the bank account.
  2. Deductions. "Add deduction": category, amount and, if needed, the order. If the commission is billed by a marketplace invoice, choose that invoice.
  3. Orders. Tick the orders the payout settles. Total at the bottom: received in bank + withheld.
  4. Exchange difference — if the orders are in another currency: plus means you received more than recorded, minus means less.
  5. Post the payout. If the amount was calculated at the ECB rate, enter the amount from the bank statement: the difference goes to exchange differences.
  6. Revaluation at date (usually 31 December): unsettled orders in a foreign currency are recalculated at the ECB rate; the next day the revaluation reverses itself.

Common messages

  • "Selected orders were paid …, the payout is …" — the amounts do not match: check the marketplace report.
  • "We owe the marketplace…" — it will deduct buyer refunds from the next payout.
  • "No bank account…" — create one in "Organisations".
  • "No open marketplace invoices…" — enter its invoice for the period under supplier invoices.

Questions and answers

Why does the branch manager have no access to payouts? The marketplace account is shared by the whole organisation, so payouts can only be viewed and recorded with a role for the whole organisation (finance, the branch manager, the administrator). Someone whose role covers only one branch gets "No … permission …".

Do I have to record Allegro payouts by hand? If "Import Allegro fees and payouts" is on in the "Allegro connection", the program creates and posts the payout itself for every withdrawal to the bank: the amount to bank, Allegro fees and the paid orders. It is not created automatically, for example, without a "Bank account for Allegro payouts" or if the channel fee comes from the marketplace invoice — then record the payout here. The amount is calculated at the ECB rate: enter the statement amount.

Can one order be settled by two payouts? No: an order is settled by only one posted payout. If you try again, the program replies "Order … is already settled by payout …".

How do I fix a mistake in a posted payout? "Finance" → "Documents" → open the payout → "Cancel document" and give the reason, then record the payout again: its orders can be ticked again.

How do I cancel a revaluation at date? First cancel its reversal — the same document on the next day — and then the revaluation itself. Otherwise the program replies "First cancel the revaluation reversal …".

Where next

  • "Documents" — payments and the marketplace's supplier invoices.
  • "Orders" — the channel's orders and their payment.