Interactive payment accounting report
The (interactive) payment accounting report
The (interactive) payment accounting report shows all transactional statuses and their corresponding registers for each transaction for a given period. This means you’ll find the same transaction listed multiple times for different payment statuses.
An overview of the report’s features:
- It’s generated every day
- Includes financial status changes, events, and modifications for all payments
- Includes full bookkeeping and user auditing
- Can be used from the company and merchant account level
- The gross/net movements, costs, and the record type are the most important columns.
Use it to:
- maintain a copy of all available status changes in your own database
- replicate Adyen’s accounting data for financial reporting.
Tip: The interactive version of this report lets you select the transactional statuses and the time range of your preference. This makes it the main report to be used for invoice reconciliation.
Note: Only transactional events are listed on the payment accounting report. You won’t see any MerchantPayouts, BalanceTransfers, DepositCorrections etc. These are reported in the Settlement Details Report.
Generate the (interactive) payment accounting report
- Log in to your Customer Area.
- Go to Finance and select between:
- Payment accounting: Whole report for a specific day
Interactive payment accounting: Whole report for specific:
- Time range (days, weeks, etc.)
- Timezone (configured timezone or CET)
- Events/Record types of your choice (ideally you would select those more interesting for you).
Difference from the settlement details report
Columns in the payment accounting report are similar to those in the settlement detail report but the reports differ in a number of ways:
- the set of record types in this report is different from the one associated with the settlement detail report.
- any transaction status that a payment goes through is displayed in this report. E.g. Settled and Refunded, but also statuses like Authorised and SentForSettle that don’t have any direct financial impact.
- record types that can not be attributed to an individual payment are not contained in the Payment Accounting Report. Hence, bulk-sum adjustments (e.g. InvoiceDeduction, MerchantPayout) that act on account balances can not be found here. For more information on payment statuses, see Payments lifecycle.
Note: It’s possible there are open captures from before the month we are looking at. These won't show in the IPAR. To solve this you can go to the Monthly finance report open balances tab, and see if you can match those payments in the Interactive payment accounting report that are still in SentForSettle to it. Look for all payments that do have a SentForSettle journal, but not Settled journal.
Note: The Payment Accounting Report is the report to use when reconciling the invoice, because the PAR can be generated on days, whereas SDRs are batch based. This means that if you have a batch that spans over the end of the month and the beginning of the month due to the weekend, this will cause a difference.
Learn more on this topic and practice what you’ve learned.Go to your Customer Area