Accounting export: guide for tax advisors and accountants
This guide explains to tax advisors and accountants how the monthly ioumi accounting export is structured, how to book it and how to reconcile the ioumi balance. It is meant for accounting firms in Austria and Germany that look after a business selling with ioumi. Sellers can pass the link to this page directly to their accounting firm.
What is ioumi?
Section titled “What is ioumi?”ioumi is a platform that service businesses such as coaches, consultants and agencies use to handle the entire process from contract to payment digitally: proposal, contract, electronic signature, invoice and payment collection. Installment payments, recurring services and custom payment plans are billed automatically, with a VAT-compliant invoice for every payment date.
For accounting, this means: every payment collected through ioumi has an invoice with a sequential number, and all documents and movements are available every month as a structured export package.
The ioumi balance
Section titled “The ioumi balance”In the seller’s books, the ioumi balance should be treated as a separate cash account, comparable to an additional bank account or a PayPal account.
- When a customer pays an invoice, the amount is credited to the seller’s ioumi balance.
- At the same moment, the transaction fee for payment processing is deducted from the balance.
- The balance is transferred to the seller’s bank account in regular payouts.
- Once a month, ioumi GmbH issues a VAT-compliant invoice for the fees withheld, the ioumi fee invoice.
So there are three kinds of money movements: payments in, fees and refunds out, and payouts to the bank account. In rare cases, manual balance adjustments are added. All movements are listed in full in the monthly transactions list, so the balance can be reconciled from it without gaps.
What the export contains
Section titled “What the export contains”For every completed month, the export package contains:
- Sales journal (CSV): all outgoing invoices and credit notes created in the month, one row per invoice line item
- Transactions list (CSV): all money movements of the month on the ioumi balance, one row per event
- Document PDFs: the original invoices and credit notes from the sales journal, file name equals document number
- ioumi fee invoice (PDF): the invoice from ioumi GmbH for the transaction fees of the month
Documents and the ioumi fee invoice cannot be changed once they are created. The contents of the CSV files also stay the same when downloaded again, with one exception: the invoice_status column in the sales journal shows the status at the time of the download (see below).
The sales journal
Section titled “The sales journal”The basis for booking revenue. Each row is an invoice line item. Invoices with several line items or several tax rates appear on multiple rows under the same invoice number and should be recorded as a split booking. Credit notes (document_type = credit_note) refer to the original invoice via original_invoice_ref and have negative amounts.
The customer data (name, company, address, country, VAT ID, customer type) is included in every row, so it can also be used to set up customer master data. The customer_id column is a stable ioumi ID that can be mapped to your own customer account number.
The tax_treatment column states the VAT treatment for each line item:
| Value | Meaning |
|---|---|
standard | VAT shown, vat_rate and vat_amount filled in |
eu_reverse_charge | B2B service to another EU member state for a customer with a valid VAT ID (customer_vat_id), tax liability with the recipient of the service, 0% |
third_country | Customer outside the EU (third country), usually not taxable, 0% |
small_business | Seller uses the small business scheme, no VAT |
Right next to it is tax_country: the country whose rules were used to calculate the VAT on the invoice, recorded at the time of invoicing. If the seller charges consumers in other EU countries at their VAT rate (OSS), revenue can be analyzed by country using this column.
invoice_status shows the status of the invoice at the time of the download: paid, open or canceled. If an invoice that was open in April is paid in May, it appears as paid when April is exported again. The sales journal does not contain a payment date. The payment itself is in the transactions list of the month in which it came in. Canceled invoices stay in the journal, and the related credit note documents the cancellation.
The transactions list
Section titled “The transactions list”The ledger of the ioumi balance and the basis for reconciliation. One row per money movement. Even for invoices with several line items, one payment equals exactly one row.
| Type | Direction | Meaning |
|---|---|---|
payment | in | Incoming payment from a customer. payment_method shows the payment method (for example visa, mastercard, sepa_debit). |
fee | out | Transaction fee, deducted directly from the balance. Always appears as a pair with the related payment. |
refund | out | Refund to the customer by credit note, reference to the original invoice via original_invoice_ref |
dispute_debit, dispute_fee | out | Chargeback of a disputed payment including the fee |
payout | out | Payout from the balance to the seller’s bank account |
credit_balance, debit_balance | in / out | Balance adjustments by the platform, with a stated reason |
Payments appear in the month in which they were successfully collected. They are matched to the invoice via invoice_number.
The only difference between the sales journal and the transactions list is invoices for which no payment has come in yet. These are the open items. An open item is settled in one of two ways:
- The payment comes in. It appears in the transactions list of the month in which it came in. This can also be a later month, for example when a SEPA Direct Debit for an invoice from the end of the month only comes in a few banking days later.
- The invoice is canceled. ioumi then creates a credit note that reverses the invoice. It appears in the sales journal of the month in which the cancellation happened, with a reference to the original invoice via
original_invoice_ref. Because no money changed hands, such a cancellation does not create a row in the transactions list.
The fee_invoice_ref column links every fee row to the ioumi fee invoice on which it was billed. Every fee is billed exactly once.
The ioumi fee invoice
Section titled “The ioumi fee invoice”The monthly incoming invoice from ioumi GmbH (Austria, VAT ID ATU82959014) to the seller for the transaction fees of the month. ioumi creates it on the first day of the following month and provides it in the seller’s account and in the accounting export. It is not sent by email. The invoice date and due date are the last day of the service period. The invoice amount equals the sum of all fee and adjustment rows in the transactions list that refer to this invoice number. The amount has already been withheld from the balance, so there is no outstanding payment obligation.
VAT treatment depending on where the seller is established and on their VAT ID, four cases:
- Austria: 20% Austrian VAT shown, input tax deduction under the general rules
- Another EU country with a VAT ID confirmed via VIES: reverse charge without VAT, tax liability of the recipient of the service (§ 13b UStG or Art. 196 of the VAT Directive)
- Another EU country without a valid VAT ID: 20% Austrian VAT shown
- Outside the EU (third country): without VAT
The seller’s own tax status, for example the small business scheme, does not change this treatment.
Booking in brief
Section titled “Booking in brief”- Keep the ioumi balance as a separate cash account, like an additional bank account.
- Book revenue from the sales journal. Under accrual-basis VAT, by invoice date. Under cash-basis VAT, by the payment date from the transactions list.
- Book credit notes as a reduction in revenue against the original invoice.
- Book transaction fees as an expense from the ioumi fee invoice, not from the individual fee rows. The transactions list is for reconciliation, the ioumi fee invoice is the supporting document.
- Book balance adjustments via the ioumi fee invoice, where they are documented as a separate line item.
- Payouts are purely a cash transfer between the ioumi balance and the bank account, neither income nor expense.
- Refunds and chargebacks reduce the balance. The supporting document is the respective credit note or the proof of the chargeback.
- File the document PDFs as document images for the bookings, for example via DATEV Belegtransfer. They are matched by the invoice number in the file name.
Reconciling the ioumi balance
Section titled “Reconciling the ioumi balance”The seller’s ioumi balance can be fully reconciled from the transactions list:
Closing balance = opening balance + incoming payments ± balance adjustments − fees − refunds and chargebacks − payouts
Invoices without an incoming payment do not affect the balance. They remain as open items on the accounts receivable account until the payment comes in or a credit note cancels the invoice.
Technical notes
Section titled “Technical notes”- Encoding UTF-8 with BOM, semicolon separator, CRLF line endings
- Comma as decimal separator, period as thousands separator, two decimal places (for example 2.000,00)
- Date format DD.MM.YYYY
- Currency stated per row
- Negative amounts mark outflows (
direction=out) - Header always in row 1