This feature can be used with the following license packs: (Starter), Basic, Professional, Enterprise

This article contains the following sections:
Payout reports for Stripe Credit Cards and iDeal

Payout reports for Finnish online payments (Paytrail)

Payout reports for Stripe Credit Cards and iDeal

When using Stripe as a payment method in Lyyti, you'll always find a report of the money transferred to you. By default, the report is created once a month (last day of each month). Each reports includes all events and payments in the given payout period.

Reports are generated provided that there have been transactions during the previous period. In Lyyti, these receipts can be found in the top navigation bar under Finance > Reports > Stripe: Payout reports.

The report list view includes essential information for each report. Contents:

• Date of creation
• Estimated arrival of the money to your bank
• Total sum of the money transfer
• Total sum of commission
• Transfer ID
• Possibility to download report as CSV
  
  

Reports show all transactions made during the previous period. Each Report is downloadable in Excel-compatible CSV-format.

N.B. Due to regional differencies, some Excel versions might use comma as decimal separator. If you have problems with CVS reports in Excel, you'll find help from "CVS reports and Excel-problems" -article. 

Each purchased product or item has it's own row and following details:

1. Time and Date of creation
2. Payment method (E.g Stripe card)
3. Event name
4. Internal project information for accounting
5. Total (no data, title column/row)
6. Product Name
7. Product amount
8. Total charge
9. VAT amount
10. VAT rate
11. Currency
12. Stripe's fee
13. Lyyti's fee
14. VAT for Lyyti's fee
15. Total fees
16. Total payout sum
17. Payout currency
18. Lyyti payment ID 
19. Participant's ID
20. Participant's first name
21. Participant's last name
22. Participant's email

You may send these reports to your company's financial department if they need more information about payments.

A complete example CSV file of the payout report can be found attached to the bottom of this article.

Payout reports for Finnish online payments (Paytrail)

When you are using online payment methods provided by Paytrail, you'll find a receipt or a report of the money transferred to you by Paytrail. Payout reports are found in Finance > Reports > Paytrail: Payout reports. Each report includes all company events and payments in the given payout period. Reports are generated based on Paytrail's payout cycle. You can also find payout reports in your Paytrail Merchant's panel.

Paytrail will account payments. 
Settlement delays according to payment methods are:

• (Finnish) Online bank payments: 1 business day
• Card payments and MobilePay payments: 5 business days

Payout reports of Paytrail-payments include the following information: 

1. Creation date and time
2. Payment method (for examle paytrail_osuuspankki or paytrail_mobilepay)
3. Name of the event
4. Project *(project info for example for account ledger personnel)  
5. Inner order *
6. Bookkeeping account *
7. VAT-code*
8. Total
9. Name of product
10. Amount of product
11. Payment status
12. Reference number
13. Order number
14. Charged
15. VAT share
16. VAT rate
17. Currency
18. Transaction fee
19. Commission fee
20. VAT fee
21. Total paid out
22. Paid out currency
23. Tilityksen valuutta
24. Lyytin payment ID
25. Parcipant ID
26. Participant's first name
27. Participant's surname
28. Participant's email address

*) This info is defined event specifically in event's Payment > Overview page

Payout report in Excel looks like this, for example: