Monthly Finance Report

Depending on when you close your fiscal period, you need the Monthly finance report or Daily finance report.

Your Adyen account holds several balances recorded in different registers in the report. Figure out which amounts are relevant to your fiscal period closing process and find them in the report.

Find the details of your balances

If the last day of your fiscal period is the last day of the month, you can use the Monthly finance report to close your fiscal period.

If not, you can use the Daily finance report to close your fiscal period.

Look in the Payment balances sheet.

Under the heading line that includes the Account, TestMerchant, included date range, and currency, there are tables for different account registers.

Balances overview dashboard

If you have a manual bookkeeping process or don't want to look at a spreadsheet, you can check your balances in a dashboard instead.

Account register balances

Column B shows the name of the account register. Each account register has its own Opening Balance and End Balance entry.

Balance movements

Column C shows all the journal types recorded in the account register, below the Opening Balance and above the End Balance entry.
Column E shows the count (the number of records) of each journal type, and Column F shows the monetary amount.

You can use these balance movement entries to track the balances throughout the date range of the report.

Monthly or daily opening and closing balances

You can use the opening and closing balances when you close a fiscal period. For example, if you are closing a fiscal year, you can match the end balance of the last month of your fiscal year to the end balance of your whole fiscal year.

Look in the Balances sheet.

In the Monthly finance report, it shows the opening balance and the end balance for the month.
In the Daily finance report, it shows the opening balance of the report date and the opening balance of the first day of the month.

Monthly and Daily finance reports

Use these reports to review payment activity for a given period.

The Monthly and Daily finance reports show an overview of your account balances and transactions. These reports show monetary amounts in your primary settlement currency. They're available in .XLS, XLSX and .PDF file types.

Generating and downloading: Get this report manually or automatically.

Time zone: CET time zone.

Date range: Select the date range of data included when you generate the report in your Customer Area.

Availability: Available for company accounts and merchant accounts.

Sample

Download a sample Monthly finance report or a sample Daily finance report for examples of the included data.

Structure

There are a several sheets in this report, including:

Monthly or Daily overview sheet

This worksheet displays an overview of the finance report in two sections:

Summary section

The first several lines in the report show a summary with the following information:

Line name	Description
Account Type	Indicates the reporting level: either at merchant account, or company account level.Typical values are: MerchantAccount, Merchant for merchant account level reports. CompanyAccount, Company for company account level reports.
Account Code	Indicates the specific company or merchant account the report has been requested for.

Overview section

Under the Overview header line, there's an overview of different amounts from the report's date range:

Column name	Description
Adyen Settlement	Indicates the settled amount, in the primary settlement currency,.
External Settlement	Indicates the amount settled by a third party, in the primary settlement currency. This applies to transactions where Adyen is not in the money flow.
Total in [primary settlement currency]	Indicates the total amount for the line item, in the primary settlement currency.

Line name	Description
Payments received on/in [ period ]	Total value of the payment requests received by the Adyen payments platform.
Payments authorised on/in [ period ]	Total value of the authorised payments for the reporting period.
Amount sent for settle on/in [ period ]	Total value of the transactions with a SentForSettle status during the reporting period. By the end of the period some of these transactions may change their status to Settled or CaptureFailed , or remain in SentForSettle .
Amount sent for refund on/in [ period ]	Value of the transactions with a SentForRefund status during the reporting period. By the end of the period some of these transactions may change their status to Refunded or RefundFailed , or remain in SentForRefund .
Total amount paid out on/in [period]	Total amount of the transactions that were settled to your bank account during the reporting period. For a breakdown of how this figure was calculated, click the [+] icon on the left side of the Excel sheet. The Total amount paid out on/in [period] is not the sum of the previous four rows in the report.
Total receivables from Adyen at end of [ period ]	Total amount of Open captured balance , Open payable balance , and Deposit .
Open captured balance (gross)	Total value of the transactions with a SentForSettle status at the end of the reporting period. This is the amount that Adyen has requested from the shopper's bank but has not yet been received by Adyen. This is the gross amount, before fees have been deducted.
Open payable balance	Total value of the transactions where Adyen has received the funds from the bank, and where Adyen is holding the funds until the next settlement batch. This is the net amount, after fees have been deducted.
Deposit	The amount withheld by Adyen to cover risk exposure. This is calculated based upon your merchant potential liability (MPL) and can fluctuate from month to month based on your payment behavior.
Refund Reserve	The amount held to process refunds. The configured value of the Reserve can be determined and funded both manually and automatically.

Payment balance sheet

The payment balance sheet shows a summary of the end of the report's date range. You can find the values of transactions ordered by status.

The table groups the entries by status, and the Year To Date (YTD) or Month To Date (MTD) up to and including the report's date range. All amounts are displayed in your primary settlement currency.

Due to exchange rate fluctuations, the Opening Balance may not match the End Balance from the previous date range.

Columns

Column name	Description
Count	The number of transactions that make up the line item.
[Primary settlement currency]	The three-character ISO code representing the primary settlement currency. All amounts in this column are converted to this currency.
Check	Exchange rates in the report are end of month, mid rates. You can review them on the ExchangeRates worksheet in the report file. Multi-currency transactions are converted to the primary settlement currency using end of month rates. Due to exchange rate fluctuations over time, there may be some valuation differences; in this case, they are reported in this column. Amounts in this column do not represent gains or losses due to currency conversion.

Entries

Under the header line, each line in the report is a separate entry.

Line name	Description
Received – Opening Balance	Shows the End Balance carried over from the previous period.
Received – Received	Payments received by the Adyen payments platform.
Received – Refused	Payments that resulted in a refusal, either by the Adyen fraud tool or by the acquirer.
Received – Error	Payments that resulted in an error.
Received – Authorised	Payments that resulted in a successful authorisation.
Received – HandledExternally	Payments that were handled outside of the Adyen payments platform.
Received – ReceivedPayout	Payout received by the Adyen payments platform.
Received – RefusedPayout	Payout that resulted in a refusal, either by the Adyen fraud tool or by the acquirer.
Received – PayoutError	Payout that resulted in an error.
Received – PayoutAuthorised	Payout that resulted in a successful authorization.
Received – End Balance	Payments whose latest status for the reporting period is Received.
Authorised – Opening Balance	Shows the End Balance carried over from the previous period.
Authorised – Authorised	Payments that resulted in a successful authorisation.
Authorised –Cancelled	Payments that were cancelled following up on a merchant's request.
Authorised – Expired	Payments whose capture request was never received. The system flags these transactions as Expired.
Authorised – SentForSettle	Payments whose capture request was successfully received. Transactions where Adyen is in the money flow are included here.
Authorised – SentForSettleExternally	Payments for which the Capture request was received. Transactions where Adyen is not in the money flow are included here.
Authorised – PayoutAuthorised	Payouts that resulted in a successful authorization.
Authorised – SentForPayout	Payouts whose payout request is successfully sent to the acquirer by the Adyen payments platform. Payouts where Adyen is in the money flow are included here.
Authorised – SentForPayoutExternally	Payouts whose payout request is successfully sent to the acquirer the Adyen payments platform. Payouts where Adyen is not in the money flow are included here.
Authorised – End Balance	Payments whose latest status for the reporting period is Authorised.
Captured – Opening Balance	Shows the End Balance carried over from the previous period.
Captured – SentForSettle	Payments whose capture request was sent to the acquirer.
Captured – Settled	Payments whose capture request was sent to the acquirer, and whose funds have been received by Adyen. This is the gross amount, before fees have been deducted.
Captured – CaptureFailed	Payments whose capture request was declined by the acquirer.
Captured – SentForRefund	Payments whose refund request was sent to the acquirer.
Captured – Refunded	Payments whose refund request was confirmed and successfully executed by the acquirer.
Captured – RefundFailed	Payments whose refund request was declined by the acquirer.
Captured – SentForPayout	Payouts whose payout request was sent to the acquirer.
Captured – PaidOut	Payouts whose payout request was confirmed and successfully processed by the acquirer.
Captured – PayoutFailed	Payouts whose payout request was returned by the acquirer.
Captured – End Balance	Payments whose latest status for the reporting period is SentForSettle.
Captured Externally – Opening Balance	Shows the End Balance carried over from the previous period.
Captured Externally – SentForSettle	Payments whose capture request was sent to the acquirer.
Captured Externally – SettledExternally	Payments whose capture request was sent to the acquirer, and where Adyen is not in the money flow.
Captured Externally – CaptureFailed	Payments whose capture request was declined by the acquirer.
Captured Externally – SentForRefund	Payments whose refund request was sent to the acquirer.
Captured Externally – RefundedExternally	Payments whose refund request was confirmed and successfully executed by the acquirer.
Captured Externally – RefundFailed	Payments whose refund request was declined by the acquirer.
Captured Externally – SentForPayout	Payout whose payout request was sent to the acquirer.
Captured Externally – PaidOutExternally	Payouts whose payout request was confirmed and successfully processed by the acquirer.
Captured Externally – PayoutFailed	Payouts whose payout request was returned by the acquirer.
Captured Externally – End Balance	Payments whose latest status for the reporting period is SentForSettle.
Payable – Opening Balance	Shows the End Balance carried over from the previous period.
Payable – Settled	Payments whose capture request was sent to the acquirer, and whose funds have been received by Adyen. This is the net amount, after fees have been deducted.
Payable – Refunded	Payments whose refund request was confirmed and successfully executed by the acquirer.
Payable – Fee already charged	Transaction fee that Adyen deducted from the settlements for the relevant period.
Payable – Chargeback	Payments whose final transaction status is Chargeback.
Payable – ChargebackReversed	Payments whose final transaction status is ChargebackReversed.
Payable – RefundedReversed	Payments where the issuer was unable to provide the refunded funds to the account holder, and the funds were returned to Adyen.
Payable – DepositCorrection	Required amount to adjust the deposit.
Payable – InvoiceDeduction	Total amount of invoiced fees deducted from your settlement for the reporting period.
Payable – MerchantPayout	Total amount of funds settled to your bank account.
Payable – MerchantPayoutFailed	Total amount of failed settlements to your bank for the month.
Payable – ManualCorrected	Total amount of manually corrected funds, for example discounts, if any.
Payable – PaidOut	Payouts whose payout request was confirmed and successfully executed by the acquirer.
Payable – PaidOutReversed	Payouts where the issuer was unable to pay out the funds to the account holder, and the funds were returned to Adyen.
Payable – MerchantPayin	Total amount of funds sent via a credit transfer or direct debit in order to increase the Reserve.
Payable – ReserveAdjustment	Total amount of funds moved to or from the Reserve register.
Payable – Other	Any miscellaneous bookings that were placed in your Next payout (Payable) batch.
Payable – End Balance	Payments whose latest status for the reporting period is Settled, and whose funds are being held until the next settlement batch.
Deposit – Opening Balance	Shows the End Balance carried over from the previous period.
Deposit – End Balance	Shows the updated deposit amount.
Reserve – Opening Balance	Shows the End Balance carried over from the previous period.
Reserve – End Balance	Shows the updated Reserve amount.
PayinPending – MerchantPayinPending	Payments to fund the Reserve that have been initiated to Adyen, but have not yet reached our bank account.
PayinPending - MerchantPayin	Payments to fund the Reserve that have been initiated to Adyen, have reached our bank account and allocated to the MerchantAccount.
Commission – Settled	Total payment method commission charged on Settled for the month.
Commission – Refunded	Total payment method commission charged on Refunded for the month.
Commission – Chargeback	Total payment method commission charged on Chargebacked for the month.
Commission – ChargebackReversed	Total payment method commission charged on ChargebackReversed for the month.
Commission – ManualCorrected	Total payment method commission charged on ManualCorrecteds for the month.
Commission – PaidOut	Total payment method commission charged on PaidOut for the month.
Commission – PaidOutReversed	Total payment method commission charged on PaidOutReversed for the month.
Commission – Total commission	Total amount of all commissions.
Fee – Total Calculated	Total Adyen transaction fee for the month. You can calculate this amount yourself in the following way: (Received + SentForRefund ) * your Adyen transaction fee
Check sum / multicurrency difference	Exchange rates in the report are end of month, mid rates. You can review them on the ExchangeRates worksheet in the report file. Multi-currency transactions are converted to the primary settlement currency using end of month rates. Due to exchange rate fluctuations over time, there may be some valuation differences; in this case, they are reported in this column. Amounts in this column do not represent gains or losses due to currency conversion.

Merchant payout details sheet

The Merchant payout details sheet shows details of payout batches from the report's date range. It shows an overview of items booked in the batch including a breakdown of the payout amount and your costs.

Entries

Under the header line, each line in the report is a separate entry.

Columns

Column name	Description
Account Code	A reference for your merchant account.
Batch	Reference number of the settlement batch.
Begin Date	Start date, from which transactions are booked into the batch (CET time zone).
End Date	End date, until which transactions are booked into the batch (CET time zone).
Payout Date	Date on which your payout was booked (CET time zone).1 This value is empty if the batch did not result in a payout, for example in cases of a transfer to a subsequent batch to process negative payable/capture balances.
Month	The month in which the batch was closed.
[unnamed column]	Three-character ISO code representing the primary settlement currency.
Payout Amount	The value of the payout.
Net & Cost fields	Available for Settled, PaidOut, Refunded, Bulk Settlement, Chargeback, Chargeback Reversed, PaidOut Reversed, and RefundedReversed. Summary of payment-level mutations during the month: Net – the net credit or debit amount Cost – the cost withheld/credited from the settlement (i.e. Commission, Markup, Interchange & Scheme fees, corresponds to fields 17-20 of the Settlement details report).
Payment Cost	The PaymentCost journal type is used only to book the following fees: Klarna payments: deductions such as dispute fees. The booking references the PSP reference of the original payment. ELO payments: financial adjustments and arbitration cost. MasterCardPersonalPayments: the transaction fee for the payout. Visa disputes: financial adjustments. These are booked on the corresponding transaction. Mastercard disputes: the administration fee collected by the issuer for disputes where a (pre‑)arbitration case is filed, and the issuer wins. PayPal for marketplaces disputes: the dispute administration fee and the fee for a lost dispute.
Balance Transfer	BalanceTransfer to/from subsequent payout batches in order to process negative payable/capture balances or for batches that could not have been paid out.
Fee	Adyen transaction fees for Received / SentForRefund / RefundedBulk transactions booked during the specified batch period.
Invoice Deduction	Representing a Payment processing invoice that is credited/deducted from the account.
Deposit Correction	Funds being withheld from/released to the account due to a change in the required security deposit (coverage of the exposure on the account).
Reserve	Funds being withheld from or being released to the account due to funding or using the Reserve register.
Merchant Pay-in	A credit transfer or direct debit booked in the account to fund the Reserve.
Other	Any other journal types booked to/from the settlement batch and not covered by the previous columns.
Rate	The exchange rate from the payout currency to your primary settlement currency.
Payout Amount Base	Payout amount converted from the payout currency to your primary settlement currency.