AccountLedger

Overview

Fetches the account ledger for the specified time period. This report includes all the transactions (both incoming and outgoing transactions) that affect the merchant's Trustly account balance. Only settled transactions are included.

Request example

{
    "method": "AccountLedger",
    "params": {
        "Signature": "O4TYCzVPzz...IiD6T1Deg35eQ==",
        "UUID": "9e4345db-6093-bb35-07d3-e335f1e28793",
        "Data": {
            "Username": "*******",
            "Password": "*******",
            "FromDate": "2014-01-01",
            "ToDate": "2014-01-31",
            "Currency": null
        }
    },
    "version": 1.1
}

Request parameters

Parameter name	Description	Required	Type	Example
Username	The username.	Yes	Text	joe
Password	The password.	Yes	Text	secret
FromDate	The start date of the returned ledger export.	Yes	Text	2020-01-01
ToDate	The end date (not including the ToDate) of the returned ledger export.	Yes	Text	2020-01-31
Currency	Only export ledger rows of this currency. Specify null to export all rows regardless of currency.	Yes	Text	EUR

Response example

{
    "version": "1.1",
    "result": {
        "signature": "lCteM8iCg++7uyF...TYoY/mc7eUQ6FWNPg==",
        "method": "AccountLedger",
        "data": [{
            "userid": "3839426635",
            "datestamp": "2014-01-30 13:28:45.652299+01",
            "orderid": "3209647863",
            "accountname": "SUSPENSE_ACCOUNT_CLIENT_FUNDS_SWEDEN_ESSE",
            "messageid": "133921",
            "transactiontype": "User deposit of client funds to CLIENT_FUNDS_SWEDEN_ESSE",
            "currency": "EUR",
            "amount": "5.00000000000000000000",
            "gluepayid": "3209647863"
        }, {
            "accountname": "TRANSACTION_FEE_BANK_DEPOSIT",
            "orderid": "3209647863",
            "userid": "3839426635",
            "datestamp": "2014-01-30 13:28:45.652299+01",
            "messageid": "133921",
            "transactiontype": "User deposit of client funds to CLIENT_FUNDS_SWEDEN_ESSE",
            "currency": "SEK",
            "amount": "-3.01",
            "gluepayid": "3209647863"
        }, ...],
        "uuid": "9e4345db-6093-bb35-07d3-e335f1e28793"
    }
}

Response attributes

The result returned is an array of JSON objects.

Note: The key value pairs can be returned in any order.

Key	Description	Type	Example
userid	Your userid in our system.	Text	3839426635
datestamp	The datestamp for when this ledger row affected your balance in our system.	Text	2014-01-30 13:28:45.652299+01
orderid	The globally unique OrderID that resulted in this ledger record.	Text	3209647863
accountname	The name of the bookkeeping account this ledger record belongs to.	Text	SUSPENSE_ACCOUNT_CLIENT_FUNDS_SWEDEN_ESSE
messageid	Your unique MessageID that you used to create the order that resulted in this ledger record.	Text	133921
transactiontype	A human friendly description of this ledger record.	Text	User deposit of client funds to CLIENT_FUNDS_SWEDEN_ESSE
currency	The currency of the amount in this ledger record.	Text	EUR
amount	The amount your balance in our system was affected with due to this ledger record. May contain a lot of decimals.	Text	5.00000000000000000000
gluepayid	An ID meaning different things for different payment methods, you probably don't need this data.	Text	3209647863